Question: I'm getting really frustrated on how to do the math by hand and not by excel and had the assignment turned back to me twice..

I'm getting really frustrated on how to do the math by hand and not by excel and had the assignment turned back to me twice..

Someone please help and explain this... DO NOT POST FROM EXCEL. This is the third time I've asked for help and I do not understand excel!

There is a pre-filled chart but I cannot get the number correct that are pre-filled

I'm getting really frustrated on how to do the

I'm getting really frustrated on how to do the

Problem 1 Based on the demand shown below, use a (a) chase production strategy and (b) level production strategy to compute the monthly production, ending inventory or backlog, and workforce levels. A worker can produce 50 units per month. Beginning inventory in January is 500 units, and the firm is targeting 200 units of inventory at the end of June. JAN FEB MAR APR MAY JUN Month Demand 2000 3000 5000 6000 5000 2000 Production Ending Inventory Workforce Chase Strategy JAN FEB MAR APR MAY JUN Month Demand 2000 3000 5000 6000 5000 2000 Production 1500 3000 5000 6000 6000 2200 0 0 0 0 0 200 Ending Inventory Workforce 30 60 100 120 120 44 Level Strategy: JAN FEB MAR APR MAY JUN Month Demand 2000 3000 5000 6000 5000 2000 Production 3950 3950 3950 3950 3950 3950 2450 3400 2350 300 -1750 200 Ending Inventory Workforce 79 79 79 79 79 79

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!