Consider the following partially completed sales and operations plan. Using the
ID: 423678 • Letter: C
Question
Consider the following partially completed sales and operations plan. Using the planning values and filled-in values as a guide, complete the plan and calculate the layoff, hiring, and inventory costs EEB Click the icon to view the costs table. EEB Clck the icon to iew the production plan table. Fill in the production plan table below (enter your responses rounded to the nearest whole number) Sales in worker Ending Forecasted sales needed to Actual meet sales workers production average-43 Month Layoffs Hirings March 10,000 3,250 More Info More Info Hirin Workers needed to Actual meet sales workers production Sales in Ending Totals Month Layoffs Hirings inventory Cost of plan: Planning values Starting inventory: Starting and ending workforce: Hours worked per month per worker Hours per unit: Hiring cost per worker: Layoff cost per worker: Monthly per-unit holding cost: average43 10,000 11,000 12,000 10,750 3,250 April May 3,000 38 250 2,150 2,100 2,400 September,500 2,450 S350 $250 S9 August 38 PrintDone Print DoneExplanation / Answer
Understand from the left out field , we have to determine : ” The average ending inventory over the six weeks “
On basis of scrutiny it can be confirmed that the filled up table is correct.
Therefore average ending inventory
= Sum of projected ending inventory for period 1 through 6 / 6
= ( 200 + 0 + 250 + 500 + 250 + 0 ) / 6
= 200
THE AVERAGE ENDING INVENTORYOVER THE SIX WEEKS IS200
THE AVERAGE ENDING INVENTORYOVER THE SIX WEEKS IS200