E F H 8 C D Bricks Corporation $ 1,000 2 $40 25 200 $25 $10 $100 400 2. 1 2 Limited Furing 3 Hour per brick (H) 4 Over time cost per brick (OV) 5 Cost per brick(CH) 6 Starting Production level (SPL) 7 Huring cost per brick (HRC) 8 Fuing cost per brick (FRC) 9 Inventory cost per Brick (IC) 10 Limited Regular Labor Hours(LRLH 11 12 13 Production (P) 14 Demand (D) 15 Increase Production (IP) 16 Decrease Production (DP) 17 Labour hours required 18 Start Inventory (ST) 19 End Inventory (ED 20 Cost of production 21 Cost of Fuig 22 Cost of Hiring 23 Inventory cost 24 Monthly Cost 25 Total cost 4 325 300 75 5 225 350 6 Totals 1.125 125 1.125 125 0 100 250 1 3 100 2.50 100 200 0 150 0 0 200 500 50 50 50 100 $5,000 $5,000 $14,000 $1.000 $0 $0 $0 $3,750 $2,500 $5.000 $7,500 $8,500 $10,000 $25,250 $103,375 3888 8 84.3.3 650 100 125 $20,000 $0 $1875 $11.250 $33.125 100 450 125 0 $12.000 $1.000 $0 $6,250 $19.250 1883 ...EE $6,250 $62,250 $1,000 $3,000 $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: a. The monthly starting inventory must be greater than or equal to Zero. b. The ending inventory of the last month must be Zero. a. c. Number of fired must be = Starting Production Level 21) To calculate the monthly increase production, the following formula is used for the first month, If (Demand Production, production - increase production,0) 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. 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 c. Start inventory + Production + end Inventory (of the previous month)- Demand d. 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