Question: You can upload your EXCEL spreadsheet for this question 4) A local firm produces coffee machines. The projected demand for one model is as follows:

You can upload your EXCEL spreadsheet for this

You can upload your EXCEL spreadsheet for this question 4) A local firm produces coffee machines. The projected demand for one model is as follows: 23 Month Workdays Demand Jan 3825 Feb 7245 March 20 2770 April 22 4440 16 an Assume that a normal workday is eight normal workday is eight hours. Hiring costs hours. Hiring costs are $350 per worker and firing costs are $850 per worker. Holding costs are $4.00 per unit held per month while the unit cost is $10. Assume that it requires average of 1 hour and 40 minutes for one worker to assemble one coffee machine. Assume that the ending inventory for December was 600 of these machined and the manager wishes to have at least 800 units on hand at the end of April. Backorder costs are 20$/unit. Assume that the current workforce level is 35 workers. Regular time labour costs $4/hour with overtime at $6/hour. Create the spreadsheet for an aggregate plan for a level strategy without allowing any backorders

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!