Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi, can you please help me fill out the table, and explain step-by-step how you got the answer. Her operations manager is considering a new
Hi, can you please help me fill out the table, and explain step-by-step how you got the answer.
Her operations manager is considering a new plan, which begins in January with 200 units on hand and ends with zero inventory. Stockout cost of lost sales is $125 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. The plan is called plan B. Plan B: Produce at a constant rate of 1,200 units per month, which will meet minimum demands. Then use subcontracting, with additional units at a premium price of $80 per unit. Subcontracting capacity is limited to 1,100 units per month. Evaluate this plan by computing the costs for January through August. In order to arrive at the costs, first compute the ending inventory and subcontracting units for each month by filling in the table below (enter your responses as whole numbers). In order to arrive at the costs, first compute the ending inventory and subcontracting units for each month by filling in the table below (enter your responses as whole numbers). \begin{tabular}{clcccc} \hline Period & Month & Demand & Production & \begin{tabular}{c} Ending \\ Inventory \end{tabular} & \begin{tabular}{c} Subcontract \\ Units \end{tabular} \\ \hline 0 & December & & & 200 & \\ 1 & January & 1,200 & 1,200 & & \\ 2 & February & 1,500 & 1,200 & & \\ 3 & March & 1,700 & 1,200 & & \\ 4 & April & 1,900 & 1,200 & \\ 5 & May & 2,300 & 1,200 & & \\ 6 & June & 2,200 & 1,200 & \\ 7 & July & 1,800 & 1,200 & & \\ 8 & August & 1,300 & 1,200 & & \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started