Answered You can hire a professional tutor to get the answer.
Located near HC University, Cocos is a restaurant serving a variety of western meals. In Cocos there are two current / full-time employees, all of...
Located near HC University, Cocos is a restaurant serving a variety of western meals. In Cocos there are two current / full-time employees, all of whom work four hours from 11:00 am, then rest for one hour and again for four hours. All other employees work four hours from 1:00 pm and then rest for one hour and again for four hours. For busy hours, use a 4-hour part-time worker, Saturday is the busiest day, and Saturday from 11:00 am to 10:00 pm.
To minimize the expenditure of wages, but to maintain the best service for the customer, we plan to hire and schedule 4 hour shifts of part-time employees. The hourly wage for part-time employees is 6,000 won. The table below shows the number of employees (including all staff and part-time employees) required by Saturday's time zone in Cocos.
(a) Set up a minimum-cost part-time worker's employment and scheduling. What is the total wage of part-time employees? How many (alternate) part-time employees
are needed? Also, is there any staff that will remain in the time zone?
(b) It is assumed that a part-time employee can choose to work between 3 hours or 4 hours. So what about the minimum cost of part-time staffing and scheduling?
How many (alternate) part-time employees are needed? How much is the cost advantage over the previous one?
=> Find answers using Excel Solver.
