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 |