Assignment 7.xlsx - Assignment 7 Part A Signs < = > Less than Equal to Greater than or equal to S M Data Objective Min Demand for small Max Demand for

Assignment 7.xlsx - Assignment 7 Part A Signs < = > Less...

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

Assignment 7Part ASigns<Less than=Equal to>Greater than or equal toDataSMLObjective$20.50 $34.00 $42.00 signRHSMin Demand for small1>14000Max Demand for small1<21000Min Demand for Medium1>6200Max Demand for Medium1<12500Min Demand for Large1 >2600Max Demand for Large1 <4200Bending/ Forming Constraint0.40.70.8 <23400Welding Constraint0.611.2 <23400Painting Constraint1.42.63.1 <46800ResultsVariables1400062002600Objective$607,000.00
Background image
ResultsLHSSlack/SurplusProblem Work area607000< Constraints>Contraints14000.00.0000140001400014000.07000.0014000210000062000006200620062006300.006200125000026000002600260026001600.00260042000012020.0011380.0012020234000017720.005680.00177202340000437803020437804680000
Background image
Microsoft Excel Answer ReportWorksheet: LP MaxReport Created:Thu Nov 15 2018 18:05:22 GMT-0500 (Eastern Standard Time)Result: Solver found a solution. All constraints and optimality conditions are satisfied.Engine: Standard LP/QuadraticSolution Time: 0 millisecondsIterations: 0Subproblems: 0Incumbent Solutions: 0Objective Cell (Max)CellOriginal ValueFinal Value$H$10651221.42857143607000Decision Variable CellsCellOriginal ValueFinal Value$B$2216157.14285714314000$C$2262006200$D$2226002600ConstraintsCellOriginal Value
Background image
Image of page 4

You've reached the end of your free preview.

Want to read all 8 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture