Question: I need the solution using excel but not vba Problem Statement X-Print Manufacturing makes laser printers. One plant assembles the PL-400 model. Standards indicate that

I need the solution using excel but not vba
Problem Statement X-Print Manufacturing makes laser printers. One plant assembles the PL-400 model. Standards indicate that one worker can assemble five printers per day. This model costs about $350 to make and the company figures it costs $5 to hold one printer in inventory for one month. Workers earn $1,500 per month and can be hired for $500 each; firing a worker costs $750. Currently, there are 12 workers in the assembly department. If a printer is backordered, the cost is $35 per unit per month. Requirements: Your assignments are to develop a level strategy, a chase strategy, and a mixed strategy models. (a) Find the minimum constant work force needed to meet monthly demand. What is the total cost of the constant work force plan? (b) Develop a zero-inventory plan (JIT Production) for this problem and determine the cost of this plan. Problem Statement X-Print Manufacturing makes laser printers. One plant assembles the PL-400 model. Standards indicate that one worker can assemble five printers per day. This model costs about $350 to make and the company figures it costs $5 to hold one printer in inventory for one month. Workers earn $1,500 per month and can be hired for $500 each; firing a worker costs $750. Currently, there are 12 workers in the assembly department. If a printer is backordered, the cost is $35 per unit per month. Requirements: Your assignments are to develop a level strategy, a chase strategy, and a mixed strategy models. (a) Find the minimum constant work force needed to meet monthly demand. What is the total cost of the constant work force plan? (b) Develop a zero-inventory plan (JIT Production) for this problem and determine the cost of this plan
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
