Question: table [ [ January , 1 , 4 0 0 , May, 2 , 2 0 0 ] , [ February , 1 ,

\table[[January,1,400,May,2,200],[February,1,600,June,2,200],[March,1,800,July,1,800],[April,1,800,August,1,400]]
Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. The plan is called plan C.
Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels.
Conduct your analysis for January through August.
The average monthly demand requirement = units. (Enter your response as a whole number.)
In order to arrive at the costs, first compute the ending inventory and stockout units for each month by filling in the table below (enter your responses as whole numbers).
\table[[Period,Month,Demand,Production,\table[[Ending],[Inventory]],Stockouts (Units)],[0,December,,,,],[1,January,1,400,1,775,,],[2,February,1,600,1,775,,],[3,March,1,800,1,775,,],[4,April,1,800,1,775,,],[5,May,2,200,1,775,-,],[6,June,2,200,1,775,,],[7,July,1,800,1,775,,],[8,August,1,400,1,775,,]]
The total stockout cost =$ (Enter your response as a whole number.)
The total inventory carrying cost (Enter your response as a whole number.)
The total cost, excluding normal time labor costs, is = $ (Enter your response as a whole number.)
\ table [ [ January , 1 , 4 0 0 , May, 2 , 2 0 0

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!