The Excel LP model for this scenario shows the following sensitivity report for the constraints. Comment on the salient features
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$G$5 Budget 3500 12 3500 2560 3440
$G$6 Newspaper 0 0 4 1E+30 4
$G$7 Radio 13.76 0 24 1E+30 10.24
$G$8 Twitter 0 0 3 1E+30 3
$G$9 Facebook 4 20 4 229.3333333 4
Answer: The budget has a shadow price of 12, meaning that for every $1 increase in budget, an additional 12 customers could be reached. Facebook's shadow price of 20 can be interpreted as an increase in 20 customers receiving the message for each additional Facebook posting up to 233 postings. Newspaper and Twitter are not in the model and thus have no opportunity cost in this formulation. The budget shadow price is robust, but that of Facebook is comparatively narrow.
You might also like to view...
The margin of safety ratio
a. is computed as actual sales divided by break-even sales. b. indicates what percent decline in sales could be sustained before the company would operate at a loss. c. measures the ratio of fixed costs to variable costs. d. is used to determine the break-even point.
Describe some of the methods used to supervise salespeople and help them work more efficiently
What will be an ideal response?