Help with statistics work
gabriel500
Exercise5data.xlsx13.2
| Constraint Classification |
| a. |
| b. |
| c. |
| d. |
| e. |
| f. |
| g. |
13.3
| Portfolio Allocation Model |
| Note: this refers to the Innis Investments example,which was not clearly stated in the problem. |
| Decision Variables: |
| Objective: |
| Constraints: |
13.5
| ColPal Products | |
| Decision Variables: | How many minutes of each type of ad should be purchased (R radio, T TV) |
| Objective: | Maximize Exposure |
| Constraints: | Limited Budget of $25,000 |
| TV allocation should be at least 75% | |
| Nonnegativity |
13.11
| Valencia Products | Answer Report | |||||||||||||
| Objective Cell (Max) | ||||||||||||||
| Cell | Name | Original Value | Final Value | |||||||||||
| LaserStop | SpeedBuster | $A$12 | TOTAL PROFIT | $0.00 | $45,333.33 | |||||||||
| Numbers Produced | 0.00 | 333.33 | ||||||||||||
| Unit Profit | $124.00 | $136.00 | ||||||||||||
| Used | Variable Cells | |||||||||||||
| Component A | 18 | 12 | 4000 | <= | 4000 | units available | Cell | Name | Original Value | Final Value | Integer | |||
| Component B | 6 | 8 | 2666.6666666667 | <= | 3500 | units available | $B$5 | Numbers Produced LaserStop | 0.00 | 0.00 | Contin | |||
| $C$5 | Numbers Produced SpeedBuster | 0.00 | 333.33 | Contin | ||||||||||
| TOTAL PROFIT | ||||||||||||||
| Constraints | ||||||||||||||
| Cell | Name | Cell Value | Formula | Status | Slack | |||||||||
| $D$8 | Component A Used | 4000 | $D$8<=$F$8 | Binding | 0 | |||||||||
| $D$9 | Component B Used | 2666.6666666667 | $D$9<=$F$9 | Not Binding | 833.3333333333 | |||||||||
