Production Planning - Regular time manuf In January Solution Regular time manuf.in February Regular time manuf in March 0 0 0 Regular time manuf in

Production Planning - Regular time manuf In January...

This preview shows page 1 - 4 out of 5 pages.

Solution 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Totals 10 10 10 10 10 10 15 15 15 15 15 15 1 1 1 1 1 1 0 LHS January 1 1 -1 0 February 1 1 1 -1 0 March 1 1 1 -1 0 April 1 1 1 -1 0 May 1 1 1 -1 0 June 1 1 1 -1 0 January 1 0 February 1 0 March 1 0 April 1 0 May 1 0 June 1 0 January 1 0 February 1 0 March 1 0 April 1 0 May 1 0 June 1 0 January 1 0 February 1 0 March 1 0 April 1 0 May 1 0 June 1 0 Regular time manuf. In January Regular time manuf.in February Regular time manuf. in March Regular time manuf. in April Regular time manuf. in May Regular time manuf.in June Overtime manuf. in January Overtime manuf. in February Overtime manuf. in March Overtime manuf. in April Overtime manuf. in May Overtime manuf. in June Inventory at the end of Janury Inventory at the end of February Inventory at the end of March Inventory at the end of April Inventory at the end of May Inventory at the end of June Cost of operation Regular production capacity Overtime production capacity Inventory limitations
RHS = 2400 = 2200 = 2700 = 3000 = 3200 = 2400 < 2700 < 2700 < 2700 < 2700 < 2700 < 2700 < 540 < 540 < 540 < 540 < 540 < 540 < 300 < 300 < 300 < 300 < 300 = 150
Microsoft Excel 14.1 Answer Report Worksheet: [lp_examples.xls]Production planning Report Created: 2011-08-22 12:54:17 PM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 2.049719 Seconds. Iterations: 15 Subproblems: 0 Solver Options Max Time 100 sec , Iterations 100, Precision 0.000001 Max Subproblems Unlimited , Max Integer Sols

You've reached the end of your free preview.

Want to read all 5 pages?

• Fall '05
• EL
• LHS, 3rd millennium, regular time, bindin