DS 412 using Solver .xlsx - Camshaf 100 VARIABLES objective function Profit max Constraints steel labor machine time \$ \$ Gears 350 25.00 \$ 2,500 \$ 18.00

# DS 412 using Solver .xlsx - Camshaf 100 VARIABLES objective...

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

VARIABLES Camshaf Gears Total for the green part y 100 350 objective function Profit \$ 25.00 \$ 18.00 \$ 8,800 max \$ 2,500 \$ 6,300 Constraints steel 5 8 3300 <= 5000 labor 1 4 1500 <= 1500 machine time 3 2 1000 <= 1000
you can choose any number at the beginning
Microsoft Excel 16.34 Answer Report Worksheet: [DS 412 using Solver .xlsx]Sheet1 Report Created: 3/3/20 5:29:27 PM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 12885497.67 Seconds. Iterations: 2 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 1E-06, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNeg Objective Cell (Max) Cell Name Original Value Final Value \$E\$11 Profit Total \$ 9,850 \$ 8,800 Variable Cells Cell Name Original Value Final Value Integer \$C\$9 Camshaf 250 100 Contin \$D\$9 Gears 200 350 Contin Constraints Cell Name Cell Value Formula Status Slack \$E\$14 steel Total 3300 \$E\$14<=\$G\$14 Not Binding 1700 \$E\$15 labor Total 1500 \$E\$15<=\$G\$15 Binding 0 \$E\$16 machine time Total 1000 \$E\$16<=\$G\$16 Binding 0
gative
Microsoft Excel 16.34 Limits Report

#### You've reached the end of your free preview.

Want to read all 9 pages?

• Spring '17
• King Sway
• Original Value, Max Integer Sols Unlimited, Iterations Unlimited

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern