statistics
| Microsoft Excel 16.0 Sensitivity Report | ||||||||||
| Worksheet: [Book1]Sheet3 | ||||||||||
| Report Created: 6/24/2019 8:48:41 PM | ||||||||||
| Variable Cells | ||||||||||
| Final | Reduced | Objective | Allowable | Allowable | ||||||
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease | ||||
| $B$3 | Variables Internet Ads | 10 | 0 | 200000 | 66666.66667 | 600000 | ||||
| $C$3 | Variables Print Ads | 50 | 0 | 80000 | 1E+30 | 20000 | ||||
| Constraints | ||||||||||
| Final | Shadow | Constraint | Allowable | Allowable | ||||||
| Cell | Name | Value | Price | R.H. Side | Increase | Decrease | ||||
| $D$4 | Budget Total | 75000 | 80 | 75000 | 37500 | 37500 | ||||
| $D$5 | Relationship Total | 0 | 8000 | 0 | 41.66666667 | 41.66666667 | ||||
| $D$6 | Min Internet Total | 10 | 0 | 5 | 5 | 1E+30 | ||||
| $D$7 | Max Internet Total | 10 | 0 | 15 | 1E+30 | 5 |