please help with this excel module, i'm so confused

D E E F G H Quarter 1 Forecasted Demand 2500 3500 4800 3300 2 $ 3 4 Total $ Price per unit $185.00 $ Given Parameters Initial Inventory Material Cost Desired ending inventory Beginning Backlog Stock out cost for backlogs Inventory holding cost Beginning work force Hiring and Training cost Layoff cost Subcontract cost Regular wage rate Overtime wage rate Working days Regular labor hours Maximum overtime labor hours Labor hours required Calculated Parameters Regular time labor cost Regular time production rate Overtime rate Current Overtime capacity units 50.00 per unit units 150 units 50 per unit per quarter 10.00 per unit per quarter 50 workers 400 per worker 550 per worker 250 per unit 15 per hour 22.50 per hour 25 per month 8 per worker/day 100 per worker/quarter 8 hours/unit UU S S $ 9,000 per worker/quarter 75 per worker/quarter 13 per worker/quarter 625 units/quarter 4 plan results. It will be critical part of you homework grade. R S T V Plan A--Level Plan Develop a plan that holds employment steady. No overtime or subcontracting is allowed. Assume stock- outs at the end of the last quarter are no greater than 100 units. Use Minimize Cost as the objective function. 1. Complete the spreadsheet by entering formulas for each cost (cells c34 through 134 and B44), each definitional constraint (range of cells B40:143), and the Total Cost formula. 2. Complete the Solver Window model. a. Use minimize cost as the objective function b. Select the change cell range c. Enter the 3 must have constraints and do a preliminary analysis to make sure the model runs. d. Add the needed constraints on overtime, subcontracting, and stock-outs and hiring and firing. 3. Run the model and check your results. You must get a solution. 4. Proceed to Plan B by doing the following: a. Save the Solver model in an empty range on this spreadsheet. b. Copy this spreadsheet into the Plan B worksheet, c. Load the Solver model into the Plan B worksheet and follow the instructions posted on that worksheet. B C D G H Forecasted Demand Number Hired, H Number Laid oft, L. 3 Quarter 9 4 0 1 1 2 2 3 33 4 34 35 B6 37 38 Month 39 December 2500 3500 4800 3300 E Decision Variables Overtime Ending Hours, 0 Inventory, 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Backlogged Subcontract Production Units, S Units, Units, P. 150 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Costs = SS Workforce Size, w 50 Constraints Production Overtime Capacity uimit Inventory Balance 10 January 41 February 42 March 43 April 45 47 48 Total Cost of Plan- 49 Total Revenue of plans plan $2,608,500.00 Plan Planc D E E F G H Quarter 1 Forecasted Demand 2500 3500 4800 3300 2 $ 3 4 Total $ Price per unit $185.00 $ Given Parameters Initial Inventory Material Cost Desired ending inventory Beginning Backlog Stock out cost for backlogs Inventory holding cost Beginning work force Hiring and Training cost Layoff cost Subcontract cost Regular wage rate Overtime wage rate Working days Regular labor hours Maximum overtime labor hours Labor hours required Calculated Parameters Regular time labor cost Regular time production rate Overtime rate Current Overtime capacity units 50.00 per unit units 150 units 50 per unit per quarter 10.00 per unit per quarter 50 workers 400 per worker 550 per worker 250 per unit 15 per hour 22.50 per hour 25 per month 8 per worker/day 100 per worker/quarter 8 hours/unit UU S S $ 9,000 per worker/quarter 75 per worker/quarter 13 per worker/quarter 625 units/quarter 4 plan results. It will be critical part of you homework grade. R S T V Plan A--Level Plan Develop a plan that holds employment steady. No overtime or subcontracting is allowed. Assume stock- outs at the end of the last quarter are no greater than 100 units. Use Minimize Cost as the objective function. 1. Complete the spreadsheet by entering formulas for each cost (cells c34 through 134 and B44), each definitional constraint (range of cells B40:143), and the Total Cost formula. 2. Complete the Solver Window model. a. Use minimize cost as the objective function b. Select the change cell range c. Enter the 3 must have constraints and do a preliminary analysis to make sure the model runs. d. Add the needed constraints on overtime, subcontracting, and stock-outs and hiring and firing. 3. Run the model and check your results. You must get a solution. 4. Proceed to Plan B by doing the following: a. Save the Solver model in an empty range on this spreadsheet. b. Copy this spreadsheet into the Plan B worksheet, c. Load the Solver model into the Plan B worksheet and follow the instructions posted on that worksheet. B C D G H Forecasted Demand Number Hired, H Number Laid oft, L. 3 Quarter 9 4 0 1 1 2 2 3 33 4 34 35 B6 37 38 Month 39 December 2500 3500 4800 3300 E Decision Variables Overtime Ending Hours, 0 Inventory, 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Backlogged Subcontract Production Units, S Units, Units, P. 150 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Costs = SS Workforce Size, w 50 Constraints Production Overtime Capacity uimit Inventory Balance 10 January 41 February 42 March 43 April 45 47 48 Total Cost of Plan- 49 Total Revenue of plans plan $2,608,500.00 Plan Planc