Question: please create an excel sheet showing formula to solve this 36. AutoMax is an online car retailer that supports its customers with a live call
please create an excel sheet showing formula to solve this

36. AutoMax is an online car retailer that supports its customers with a live call center. The call center operates daily from 8:00 AM to 9:00 PM. Call center employees work 9 hour shifts that may begin at the following five times: 8:00 AM, 9:00 AM, 10:00 AM, 11:00 AM, or 12:00 PM (noon). Employees get a one-hour break in the middle of their shift. Workers that start at 8:00 or 9:00 are paid $211 for each shift worked. Workers starting at 10:00, 11:00, or noon are paid $232,$242, and $253 per shift, respectively. The following table summarizes the minimum number of workers needed during each hour of daily operations in order to handle the forecasted call volume. The company would like to determine how many workers to schedule for each shift in order to handle the call volume in the most efficient manner. Questions and Problems a. Formulate a LP model for this problem. b. Implement your model in a spreadsheet and solve it. c. What is the optimal solution
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
