A B D E E F G H 1 J L 3 M N 11. Jane Dapna, the operations manager of Classico Inc., is using the Sales and Operations Planning with Spreadsheets Solver in OM Explorer to develop a 5-month production plan. Her initial plan is to maintain a level workforce and use overtime and backorders as shown in the table. Use the provided inputs to calculate the derived inputs: Utilized time, Inventory, Hires and Layoffs, and the associated costs. (Hint: Don't forget to express the forecasted demand and reactive alternatives as employee-period equivalents.) Inputs Starting Workforce Wages per Worker per Period Overtime Pay Percentage Subcontracting Cost per Period 20 Cost to Hire One Worker $ 4,000.00 Cost to Lay Off One Worker 150% Initial Inventory Level I $10,000.00 $ 20,000.00 10 0 0 Initial Backorders Inventory Cost $ 100.00 1 2 3 4 5 6 7 8 9 10 11 T 12 13 10 14 15 10 16 17 18 19 19 20 20 21 21 22 22 23 24 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 Backorder Cost $ $ 250.00 1 1 1 Period January February March April May Total 20 30 40 30 140 Inputs Forecasted demand Workforce level Undertime Overtime I 20 20 20 20 20 20 100 0 0 0 0 0 0 0 0 10 20 0 30 Vacation time 0 0 0 0 0 0 0 0 0 0 0 0 Subcontracting time Backorders 0 0 10 0 0 0 10 Derived Utilized time 100 10 0 Inventory Hires Layoffs Calculated 0 54 34 55 56 57 58 59 ou 60 61 62 63 64 65 65 BB 66 67 68 69 70 71 71 72 72 73 74 75 76 77 Utilized time cost Undertime cost Overtime cost Vacation time cost Inventory cost Backorders cost Hiring cost Layoff cost Subcontracting cost $ 400,000.00 $ $ $ 180,000.00 $ $ 1,000.00 $ 2,500.00 $ $ $ Total cost $ 583,500.00 Reminder: Express the forecasted demand and reactive alternatives as employee-period equivalents