I just solved this problem in excel using solver to determine the cost-minimizing production schedule. Can anyone verify whether I solved it correctly? Below I attached the problem, the data for the problem, my spreadsheet, my formulated spreadsheet, and my solver.

Problem:

During the next five periods, the demands listed in the file P06_58.Xlsx must be met on time. At the beginning of period 1, the inventory level is 0. During each period when production occurs, a setup cost of $10,000 and a per-unit production cost of $45 are incurred. At the end of each period, a perunit holding cost of $5 is incurred. Determine the cost-minimizing production schedule. \f1 Month 1 2 3 4 5 Total Unit Cost Total Cost 2 Demand 2000 1700 3000 2000 3400 12100 3 10000 40000 4 Production 45 544500 5 Inventory 0 1700 0 0 0 0 1700 5 8500 6 Setup Constraint B400 0 9100 10100 8700 7 8 Total Cost of Production 593000 B C D E F G H Month 1 2 3 4 5 Total Unit Cost Total Cost Demand 2000 1700 3000 2000 3400 =SUM(C2:G2) 1 0 1 1 1 =SUM(C3:G3) 10000 =H3*13 Production 3700 0 3000 2000 3400 =SUM(C4:G4) 45 =H4*14 Inventory 0 =B5-C2+C4 =C5-D2+D4 =D5-E2+E4 =E5-F2+F4 =F5-G2+G4 =SUM(C5:G5) 15 =H5*15 6 Setup Constraint =C3*12100-C4 =D3*12100-D4 =E3*12100-E4 =F3*12100-F4 =G3*12100-G4 8 Total Cost of Production =SUM(J2:J5)l. ij j Solver Parameters Set Objective: 53$ 8' I To: 'A' Max 0 Min '' Value Of: By Changing Variable Cells: $335054 I Subject to the Constraints: Add $C$5:$G$6 >= 0 Change Delete Reset All Load] Save Make Unconstrained Variables Non-Negative Select a Solving Method: Simplex LP a Options Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non smooth. C lose Solve