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...
All of the following tests of controls will provide evidence that access to the data files is limited except
a. inspecting biometric controls b. reconciling program version numbers c. comparing job descriptions with access privileges stored in the authority table d. attempting to retrieve unauthorized data via inference queries
Which of the following best explains why public relations is often overlooked as a tool for supporting product marketing objectives?
A) Public relations departments are typically large divisions within corporations. B) The time and costs associated with public relations prohibit its extensive use. C) Public relations specialists lack the skills necessary to work with marketing experts. D) Many public relations professionals see their jobs as communicating not brand building. E) The public relations department handles stockholders and legislators but not employees.
Anniston Co. planned to produce and sell 40,000 units. At that volume level, variable costs are determined to be $320,000 and fixed costs are $30,000. The planned selling price is $10 per unit. Anniston actually produced and sold 42,000 units.Using a contribution margin format:(a) Prepare a fixed budget income statement for the planned level of sales and production.(b) Prepare a flexible budget income statement for the actual level of sales and production.
What will be an ideal response?
By 2022 it is projected that online sales will account for 17 percent of all retail sales.
Answer the following statement true (T) or false (F)