Answer the following question using the excel output

Info icon This 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
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
Image of page 14
                                                      15
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
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 ]}

What students are saying

  • Left Quote Icon

    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.

    Student Picture

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

  • Left Quote Icon

    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.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern