412LP-SuppBprobsFixed

412LP-SuppBprobsFixed - MicrosoftExcel11.6AnswerReport

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

View Full Document Right Arrow Icon
Microsoft Excel 11.6 Answer Report Worksheet: [412LP-SuppBproblems.xls]Problem1 Report Created: 9/14/2010 2:26:23 AM Target Cell (Max) Cell Name Original Value Final Value $H$8 Maximize #Customers 0 113500 Adjustable Cells Cell Name Original Value Final Value $B$5 #ads Radio 1-10 0 10 $C$5 #ads Radio 11-20 0 10 $D$5 #ads Radio 21-30 0 0 $E$5 #ads TV 1-5 0 5 $F$5 #ads TV 6-10 0 5 $G$5 #ads TV 11-15 0 2 Constraints Cell Name Cell Value Formula Status Slack $H$11 Max Spending Actual 145000 $H$11<=$J$11 Binding 0 $H$12 Radio 1-10max Actual 10 $H$12<=$J$12 Binding 0 $H$13 Radio 11-20max Actual 20 $H$13<=$J$13 Binding 0 $H$14 Radio 21-30max Actual 20 $H$14<=$J$14 Not Binding 10 $H$15 TV 1-5max Actual 5 $H$15<=$J$15 Binding 0 $H$16 TV 6-10max Actual 10 $H$16<=$J$16 Binding 0 $H$17 TV 11-15max Actual 12 $H$17<=$J$17 Not Binding 3
Background image of page 1

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

View Full DocumentRight Arrow Icon
Microsoft Excel 11.6 Sensitivity Report Worksheet: [412LP-SuppBproblems.xls]Problem1 Report Created: 9/14/2010 2:26:24 AM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 #ads Radio 1-10 10 0 900 1.0E+030 137.5 $C$5 #ads Radio 11-20 10 0 700 137.5 137.5 $D$5 #ads Radio 21-30 0 -100 400 100 1.0E+030 $E$5 #ads TV 1-5 5 0 10000 1.0E+030 1250 $F$5 #ads TV 6-10 5 0 7500 1250 1250 $G$5 #ads TV 11-15 2 0 5000 1000 1000 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $H$11 Max Spending Actual 145000 0.625 145000 24000 16000 $H$12 Radio 1-10max Actual 10 137.5 10 10 10 $H$13 Radio 11-20max Actual 20 137.5 20 10 10 $H$14 Radio 21-30max Actual 20 0 30 1.0E+030 10 $H$15 TV 1-5max Actual 5 1250 5 5 5 $H$16 TV 6-10max Actual 10 1250 10 1.6 5 $H$17 TV 11-15max Actual 12 0 15 1.0E+030 3
Background image of page 2
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
Background image of page 3

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

View Full DocumentRight Arrow Icon
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
Background image of page 4
Microsoft Excel 11.6 Sensitivity Report
Background image of page 5

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

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/19/2011 for the course DS 412 taught by Professor Eng during the Spring '07 term at S.F. State.

Page1 / 18

412LP-SuppBprobsFixed - MicrosoftExcel11.6AnswerReport

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online