BUSI508 Week 6 Excel Exercise 5

Question 1 (4 Points) Assuming an arrival and service rate of one truck per hour, is it a feasible for Seabreeze to employ just one server?  Why or why not?

Question 2 (4 Points) Assuming an arrival rate of one truck per hour, a service rate of two trucks per hour, and a total of two employees, what is the total hourly cost of when conisdering employee salaries/benefits and the hour cost to the company for having a truck sitting at the dock for loading or unloading?  Recall, the cost of each employee is $21/hour and when considering the cost to the company for having a truck in the queue, the hourly cost is $35/hour though prorated for the total time spent in the system

Question 3 (4 Points) Assuming an arrival rate of one truck per hour, a service rate of three trucks per hour, and a total of three employees, what is the total hourly cost of when conisdering employee salaries/benefits and the hour cost to the company for having a truck sitting at the dock for loading or unloading?  Recall, the cost of each employee is $21/hour and when considering the cost to the company for having a truck in the queue, the hourly cost is $35/hour though prorated for the total time spent in the system.  

Question 4 (4 Points) Assuming an arrival rate of one truck per hour, a service rate of four trucks per hour, and a total of four employees, what is the total hourly cost of when conisdering employee salaries/benefits and the hour cost to the company for having a truck sitting at the dock for loading or unloading?  Recall, the cost of each employee is $21/hour and when considering the cost to the company for having a truck in the queue, the hourly cost is $35/hour though prorated for the total time spent in the system


Question 5 (4 Points) What is the best employment strategy for Seabreeze, 1, 2, 3, or 4 hourly employees?  Why?