Do not need the math algebra I have already provided that. I need the decision variables and constraints inputs in excel solver window (example highlighted in yellow below)

Decision variables: Regular production and overtime.

Constraints: restrict regular production to equate to 60 tankloads per month, and overtime to not exceed 10 truckloads per month. Also, add another constraint to ensure that the ending inventory is greater than or equal to zero.

B D 1 Period May June July August 2 Forecast 50 60 70 90 3 Output 4 Regular 60 60 60 60 5 Overtime 10 10 10 10 6 Subcontract 0 0 10 lo 7 Output - Forecast -SUM(B4:B6)-B2 -SUM(C4:C6)-C2 ESUM(D4D6)-D2 SUM(E4:E6)-E2 8 Inventory 9 Beginning 0 -B10 -C10 -D10 10 Ending -SUM(B4:16)-B2 -SUM(C4:C6)+C9-C2-SUM(D4:D6) +D9-D2 -SUM(E4:E6)+E9-E2 11 Average -(B9-B10)2 -(C9-C102 -D9+D10) 2 -(E9-E1072 12 Backlog 0 0 10 lo 13 Costs 14 Regular 1.000-141000 C4*1000 -D4*1000 -E4*1000 15 Overtime 1,600 -B5*1600 -C5*1600 -D5 1600 -ES 1600 16 Inventory 2,000 -B11.2000 -C11 2000 -D11.2000 -E11.2000 17 Backlog 5,000 =B125 C125 -D123 -E123 18 Total -SUM(B14:B17) -SUM(C14.017) -SUM(D14:17) -SUME 14:17) F G H 1 Period September October Total 2 Forecast 80 70 SUM(B2:G2) 3 Output 4 Regular 60 60 SUM(B4:44) 5 Overtime 10 10 SUM(B5:45) 6 Subcontract 0 0 7 Output - Forecast -SUM(F4:F6)-F2 SUM(G4:G6-G2 8 Inventory 9 Beginning -E10 -F10 10 Ending =SUM(F4:F6)+F9-F2 =SUM(G4:G6)+G9-G2 11 Average =(F9+F10/2 =(G9+G10)/2 =SUM(B11:411) 12 Backlog 0 0 13 Costs 14 Regular @ 1.000 =F4*1000 =G4*1000 =SUM(B14:414) 15 Overtime @1,600 +F5*1600 G5*1600 -SUM(B15:15) 16 Inventory @ 2.000 =F11*2000 =G11.2000 =SUM(B16:16) 17 Backlog @ 5,000 F125 G125 SUM(B17:17) 18 Total =SUM(F14:F17) =SUM(G14:17) =SUM(B18:G18) A B D E F G H 1 Period May June July August September October Total 2 Forecast 50 60 70 90 80 70 420 3 Output 4 Regular 60 60 60 60 60 60 360 5 Overtime 10 10 10 10 10 10 60 6 Subcontract 0 0 0 0 0 0 7 Output - Forecast 20 10 -20 -10 0 8 Inventory 9 Beginning 0 20 30 30 10 0 10 Ending 20 30 30 10 0 0 11 Average 10 25 30 5 0 90 12 Backlog 0 0 0 0 0 0 13 Costs 14 Regular @ 1,000 60000 60000 60000 60000 60000 60000 360000 15 Overtime @1,600 16000 16000 16000 16000 16000 16000 96000 16 Inventory @ 2,000 20000 50000 60000 40000 10000 0 180000 17 Backlog @ 5,000 0 0 0 0 0 0 0 18 Total 96000 126000 136000 116000 86000 76000 636000 The cost of level plan with overtime of 10 units per month is 5636,000