FinalReviewS13

# 12 apply to this information quality bike maps has

This preview shows pages 12–15. Sign up to view the full content.

12

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

View Full Document
Questions 31 & 32 apply to this information: Quality Bike Maps has produced four map designs for the local area. A limited amount of time (in minutes) is allocated to the printing, cutting and folding of each map. Additionally, at least one thousand of map designs A, B, and C must be printed. The profit per map is \$1 for A and B and \$2 for C and D. The Excel output is provided below. Max Profit = A + B + 2 C + 2 D s.t. A + 2 B + 3 C + 3 D < 15000 Print 2 A + 4 B + C + 3 D < 20000 Cut 3 A + 2 B + 5 C + 3 D < 20000 Fold A > 1000 Print A B > 1000 Print B C > 1000 Print C Microsoft Excel 14.0 Sensitivity Report Objective Function Value  \$10,166.67 Variable Cells     Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$B\$1 8 Map A 1500 0 1 1 0.333333333 \$C\$1 8 Map B 1000 0 1 0.333333333 1E+30 \$D\$1 8 Map C 1000 0 2 0.333333333 1E+30 \$E\$1 8 Map D 2833.333333 0 2 1 0.5 Constraints     Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease \$B\$2 4     Print 15000 0.5 15000 1000 5666.666667 \$B\$2 5     Cut  16500 0 20000 1E+30 3500 \$B\$2 6     Fold 20000 0.166666667 20000 7000 1000 \$B\$2 7     Print A 1500 0 1000 500 1E+30 \$B\$2 8     Print B 1000 -0.33333333 1000 1750 1000 \$B\$2 9     Print C 1000 -0.33333333 1000 500 1000 31. Answer the following question using the Excel output above. Which constraint(s) are binding? 13
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. A. 1,500 B. 11,166.67 C. 11,500.67 D. 11,666.67 E. 12,566.67 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? A. \$3200 B. \$4000 C. \$4280 D. \$6295 E. \$7875

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page12 / 19

12 apply to this information Quality Bike Maps has produced

This preview shows document pages 12 - 15. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online