{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

412LP-SuppBprobsFixed

This preview shows pages 1–6. Sign up to view the full content.

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

View Full Document
Supplement B Reid4ed Media Ads Decision Variables Radio 1-10Radio 11-20Radio 21-30TV 1-5 TV 6-10 TV 11-15 #ads 10 10 0 5 5 2 Objective Function #Customers Maximize 900 700 400 10000 7500 5000 113500 Constraints Actual Limit Max Spending 1000 900 800 12000 10000 8000 145000 <= 145000 Radio 1-10max 1 0 0 0 0 0 10 <= 10 Radio 11-20max 1 1 0 0 0 0 20 <= 20 Radio 21-30max 1 1 1 0 0 0 20 <= 30 TV 1-5max 0 0 0 1 0 0 5 <= 5 TV 6-10max 0 0 0 1 1 0 10 <= 10 TV 11-15max 0 0 0 1 1 1 12 <= 15 part d #customers 900 700 400 10000 5000 7500 cost/customer 1.111111 1.2857143 2 1.2 2 1.06667 orig cost/custom1.111111 1.2857143 2 1.2 1.3333 1.6

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

View Full Document
Microsoft Excel 11.6 Answer Report Worksheet: [412LP-SuppBproblems.xls]Problem2 Report Created: 9/14/2010 1:33:39 AM Target Cell (Min) Cell Name Original Value Final Value \$F\$8 Minimize Costs(\$) 0 65000 Adjustable Cells Cell Name Original Value Final Value \$B\$5 # tons PaperStock1 0 250 \$C\$5 # tons PaperStock2 0 250 \$D\$5 # tons PaperStock3 0 0 \$E\$5 # tons PaperStock4 0 0 Constraints Cell Name Cell Value Formula Status Slack \$F\$11 AveStrength Actual 0 \$F\$11>=\$H\$11 Binding 0 \$F\$12 AveColor Actual 1500 \$F\$12>=\$H\$12 Not Binding 1500 \$F\$13 AveTexture Actual 250 \$F\$13>=\$H\$13 Not Binding 250 \$F\$14 Demand(tons) Actual 500 \$F\$14>=\$H\$14 Binding 0
Microsoft Excel 11.6 Sensitivity Report

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 ]}