Question: please don't use VBA X-Print Manufacturing makes laser printers. One plant assembles the PL-400 model. Standards indicate that one worker can assemble five printers per

 please don't use VBA X-Print Manufacturing makes laser printers. One plant

please don't use VBA

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. (c) You are to submit the followings on the course shell: (i) a pdf copy of an executive summary report with results from parts (a) and (b), and (ii) the program code (Excel spreadsheet)

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!