chapter 6 templates from the book along with answer reports (1)

xlsx

School

University of Massachusetts, Boston *

*We aren’t endorsed by this school

Course

210

Subject

Aerospace Engineering

Date

Oct 30, 2023

Type

xlsx

Pages

Uploaded by JusticeRoseBee14

Microsoft Excel 15.0 Answer Report Worksheet: [CHAPTER 3 TEMPLATES FROM OUR BOOK.xlsx]Flair Furniture Report Created: 3/23/2017 12:36:38 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.016 Seconds. Iterations: 3 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Max) Cell Name Original Value Final Value $D$6 Profit $ - $ 3,975.00 Variable Cells Cell Name Original Value Final Value Integer $B$5 Number of Units Tables 0 300 Contin $C$5 Number of Units Chairs 0 375 Contin Constraints Cell Name Cell Value Formula Status Slack $D$11 Minimum Tables 300 $D$11>=$F$11 Not Binding 200 $D$12 Tables vs. Cahirs 75 $D$12>=$F$12 Binding 0 $D$8 Carpentry Hours 2400 $D$8<=$F$8 Binding 0 $D$9 Painting Hours 975 $D$9<=$F$9 Not Binding 25 $D$10 Maximum Chairs 375 $D$10<=$F$10 Not Binding 75

Flair Furniture T C Tables Chairs Number of Units 300 375 Profit 7 5 $ 3,975.00 Constraints Carpentry Hours 3 4 2400 <= 2400 Painting Hours 2 1 975 <= 1000 Maximum Chairs 0 1 375 <= 450 Minimum Tables 1 0 300 >= 100 Tables vs. Cahirs -1 1 75 >= 75 LHS Sign RHS

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Microsoft Excel 15.0 Answer Report Worksheet: [CHAPTER 3 TEMPLATES FROM OUR BOOK.xlsx]Turkey Ranch Report Created: 3/23/2017 12:39:22 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.016 Seconds. Iterations: 3 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Min) Cell Name Original Value Final Value $D$6 Cost $ - $ 0.78 Variable Cells Cell Name Original Value Final Value Integer $B$5 Number of Units Brand B 0 4.2 Contin $C$5 Number of Units Brand A 0 2.4 Contin Constraints Cell Name Cell Value Formula Status Slack $D$8 protein required 45 $D$8>=$F$8 Binding 0 $D$9 Vitamin required 24 $D$9>=$F$9 Binding 0 $D$10 Iron required 2.1 $D$10>=$F$10 Not Binding 0.6

Holiday Meat Turkey Ranch A B Brand B Brand A Number of Units 4.2 2.4 Cost 0.1 0.15 $ 0.78 Constraints protein required 5 10 45 >= 45 Vitamin required 4 3 24 >= 24 Iron required 0.5 0 2.1 >= 1.5 LHS Sign RHS