Question: please solve with solver in Excel 32. A local firm manufactures children's toys. The projected demand over the next four months for one particular model
32. A local firm manufactures children's toys. The projected demand over the next four months for one particular model of toy robot is Assume that a normal workday is eight hours. Hiring costs are $350 per worker and firing costs (including severance pay) are $850 per worker. Holding costs are $4.00 per aggregate unit held per month. Assume that it requires an average of 1 hour and 40 minutes for one worker to assemble one toy. Shortages are not permitted. Assume that the ending inventory for June was 600 of these toys and the manager wishes to have at least 800 units on hand at the end of October. Assume that the current workforce level is 35 workers. Assume that each worker is paid a salary of $14.40 per hour regardless of whether they are producing toys and that how many of the 8 hours in the normal workday workers will produc toys is a decision
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
