OPERATIONS RESEARCH

I AM INSISTING AGAIN THIS QUESTION IS TOTALLY DIFFERENT TO THE ONE POSTED IN THIS WEBSITE BECAUSE OF "At the beginning of month 1 there are20 unitsin stock", PLEASE DON'T MAKE MISTAKE OF TAKING THESE SOLUTIONS.

A company produces a certain product and has the capacity to produce100units per month in regular time, and an additional15units per month in overtime. The production cost of the product varies by month due to changes in the material costs over time. The quantities of the product to be delivered over the next six months have already been set. The delivery requirements and production costs are given in the following table:

(d) Interpret of SOLVER solution Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Regular production 100 100 100 100 90 100 Overtime production 0 0 0 5 0 0 Inventory 5 20 10 0 0 Total cost = 111,870 rand\fClick Solve to generate the solution. After that, values appear automatically in variable (yellow colored) cells A B C D E F G H I J K LM NO P Q R S TU V W 1 R1 R2 R3 R4 R5 R6 01 02 03 04 05 06 V1 V2 VS V4 3 Month 1 1 -1 3 95 4 Month 2 1 1 1 -1 85 85 5 Month 3 1 1 1 110 Month 4 1 1 115 7 Month 5 1 1 -1 90 90 8 Month 6 1 100 = 100 10 11 Cost: 180 180 192 192 186 192 210 210 222 222 216 222 12 12 12 12 12 111870 12 13 14 Result: 100 100 100 100 90 100 0 0 0 5 0 0 5 20 10 0 0 15 16 Solver Results X 17 18 19 20 Solver found a solution. All Constraints and optimality 21 conditions are satisfied. Reports 22 Answer 23 O Keep Solver Solution Sensitivity 24 Limits 25 26 O Restore Original Values 27 28 29 Return to Solver Parameters Dialog Outline Reports 30 31 32 33 OK Cancel Save Scenario... 34 35 36 37 Solver found a solution. All Constraints and optimality conditions are satisfied. 38 39 40 When the GRG engine is used, Solver has found at least a local optimal solution. When Simplex LP is used, this 41 means Solver has found a global optimal solution.Quantities in be delivered (units) Pietiuctien cost per unit in regular time S E___- 192 Pmductien test per unit in overtime 2H] 21{} 222 222 216 222