{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

FinalReviewS13

Answer the following question using the excel output

Info iconThis preview shows pages 13–17. Sign up to view the full content.

View Full Document Right Arrow Icon
31. Answer the following question using the Excel output above. Which constraint(s) are binding? 13
Background image of page 13

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
A. Print and Fold B. Cut and Print A C. Print B and Print C D. Print and Cut E. Print, Fold, Print B and Print C 32. Answer the following question using the Excel output above. Keeping within the confines of the problem, the profit on Map A has increased by one dollar. Determine the new objective function value. 33. Quentin Magic Brown manufactures sports shoes and wants to maximize the company's profits. The company makes two types of sport shoe, Airwalkers and Bouncy Basketball shoes. The company earns $10 profit on each pair of Airwalkers and $18 profit on each pair of Bouncy Basketball shoes. The manufacturing process includes cutting the materials on a machine and having workers assemble the pieces. Each pair of Airwalkers requires 3 minutes of cutting time and the Bouncy Basketball shoes require 2 minutes. The machines that cut the material can run at most 1200 minutes a week. Each worker takes 7 hours to assemble a pair of Airwalkers and 8 hours to assemble a pair of Bouncy Basketball shoes; the maximum number of hours available is 3500 per week. Determine the maximum profit for this problem?                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         14
Background image of page 14
                                                      15
Background image of page 15

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Questions 34-37 apply to the Excel output for the Quantum Mo-Botics model is below. The company makes three types of machines and has limitations with regards to the amount of skilled and unskilled labor hours available and time on the assembly line. MAX Profit = 800SemiAuto+1000Robotic + 500Manual s.t. 30SemiAuto + 100Robotic + 45Manual < 4500 Skilled Labor 100SemiAuto + 70Robotic + 90Manual < 9000 Unskilled Labor 15SemiAuto + 20Robotic + 10Manual < 2000 Assembly Line Microsoft Excel 14.0 Sensitivity Report Objective Function Value   $ 82,025.32  Variable Cells     Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$18  SemiAuto 74.05063291 0 800 628.5714286 432.4786325 $C$18  Robotic 22.78481013 0 1000 1666.666667 440 $D$18  Manual 0 -320.253164 500 320.2531646 1E+30 Constraints     Final Shadow Constraint
Background image of page 16
Image of page 17
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}