HW 7 - Campbell Motors Decision Variables Td Wd Tp Wp 20.3354697 71.1718571536 26648.0295 29893.4675 Unit costs EPA Reqs Prep Labor Demand Truck $20,000

HW 7 - Campbell Motors Decision Variables Td Wd Tp Wp...

This preview shows page 1 - 3 out of 6 pages.

Campbell Motors Decision Variables: Td Wd Tp Wp 20.3354697 71.1718571536 26648.0295 29893.4675 Unit costs EPA Reqs Prep Labor Demand Truck $20,000 0.14 3 500 -18 Wagon $25,000 0.05 2 400 -11 Total 0.07 250 Objective Max: $483,468 S.T. Prep Labor 203.350123 <= 250 EPA 0.0700005 <= 0.07 Truck demand 20.3354697 "=" 20.3354696 Wagon demand 71.1718572 "=" 71.1718571
Image of page 1
Microsoft Excel 14.5 Answer Report Worksheet: [HW 7.xlsx]Sheet1 Report Created: 10/27/2016 3:55:36 PM Result: Solver found a solution. All constraints and optimality conditions are satisfied Solver Engine Engine: GRG Nonlinear Solution Time: 1.884207 Seconds. Iterations: 9 Subproblems: 0 Solver Options Max Time Unlimited , Iterations Unlimited , Precision 0.000001 Convergence 0.0001, Population Size 100, Random Seed 0, Derivatives Forward , Max Subproblems Unlimited , Max Integer Sols Unlimited , Integer Tolerance 1%, Objective Cell (Max) Cell Name Original Value Final Value $B$11 Max: Unit costs -$44,998 $483,468 Variable Cells Cell Name Original Value Final Value Integer $B$4 Td 1 20.3354697281 Contin $C$4 Wd 1 71.1718571536 Contin $D$4 Tp 1 26648.0294694 Contin $E$4 Wp 1 29893.4675386 Contin Constraints Cell Name Cell Value Formula Status $D$14 Prep Labor Prep Labor 203.350123492 $D$14<=$F$14 Not Binding $D$15
Image of page 2
Image of page 3

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture