G H D E 1 Bricks Corporation 2 Limited Furing $ 1,000 3 Hour per brick (H) 2 4 Overtime cost per brick (OV) $40 5 Cost per brick(CH) 25 6 Starting Production level (SPL) 200 7 Hiring cost per brick (HRC) $25 8 Firing cost per brick (FRC) $10 9 Inventory cost per Brick (IC) $100 10 Limited Regular Labor Hous(LRLH) 400 11 12 1 2 3 4 5 13 Production (P) 100 100 250 325 225 14 Demand (D) 50 100 200 300 350 15 Increase Production (IP) 0 0 150 75 0 16 Decrease Production (DP) 100 0 0 0 100 17 Labour hours required 200 200 500 650 450 18 Start Inventory (SI 0 30 30 100 125 19 End Inventory (ET) 50 50 100 125 0 20 Cost of production $5.000 $5,000 $14,000 $20,000 $12,000 21 Cost of Furing $1.000 $0 $0 $0 $1,000 22 Cost of Hiring $0 $0 $3,750 $1.875 $0 23 Inventory cost $2.500 $5.000 $7,500 $11,250 $6,250 24 Monthly Cost $8,500 $10,000 $25,250 $33,125 $19,250 25 Total cost $103,375 6 Totals 125 1,125 125 1,125 0 100 250 0 0 $6.250 $62,250 $1,000 $3,000 $0 $5,625 $0 $32,500 $7,250 $103,375 20) The production schedule that minimizes the total cost to meet the forecasted demand is listed in the above sheet. The list of constraints used in the solver are all of the following except: The monthly starting inventory must be greater than or equal to Zero. b. The ending inventory of the last month must be Zero. a. a. 21) To calculate the monthly increase production, the following formula is used for the first month, If (Demand Production, production - increase production) b. If (Demand >0, 0, production - Starting Production Level) c. If (Max (Decrease production, increase production) >0. Production - Starting Production Level,0) d. None of the above. C. d. 22) To calculate the monthly End Inventory, the following formula is used: a. Average (Start inventory, end Inventory, Production) - Demand b. Average (Decrease production, increase production, Start inventory, end Inventory) - Demand Start inventory + Production + end Inventory of the previous month). Demand None of the above. 23) The company is considering introducing an overtime strategy, if the straight labor hours are more than 400 than an overtime cost of $40 per hour occurs. The first month overtime cost can be calculated using the following model: a. If (Production