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...

• Homework Help
• 6

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
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