Jane Dapna, the operations manager of Classico Inc., is using the Sales and Operations Planning with Spreadsheets Solver in OM Explorer to develop a five month production plan. Her initial plan is to maintain a level workforce and use overtime and backorders as shown below. Use the provided inputs to calculate the derived inputs: Utilized time, Inventory, Hires and Layoffs, and the associated costs.

Transcribed Image Text:

nputs Starting Workforce Wages per Worker per Period Overtime Pay Percentage Subcontracting Cost per Period 20 $4,000.00 150% Cost to Hire One Worker Cost to Lay Off One Worker Initial Inventory Leve Initial Backorders Inventory Cost Backorder Cost $10,000.00 $20,000.00 10 S 100.00 $ 250.00 Period Inputs Forecasted demand Workforce level Undertime Overtime Vacation time Subcontracting time Backorders Derived Utilized time Inventory Hires January February March April Total 40 140 100 30 20 20 10 100 Calculated Utilized time cost Undertime cost Overtime cost Vacation time cost Inventory cost Backorders cost Hiring cost Layof cost Subcontracting cost $ 400,000.00 180,000.00 $ 1,000.00 $ 2,500.00 Total cost 583,500.00