In: Economics
Set up a table or spreadsheet for CSI, that illustrates the relationship among quantity (Q), price (P), the optimal level of advertising (A), the advertising-sales ratio (A/S), and sales revenue (S). In this spreadsheet, use formula functions to set
Q = 5000 -10p+40A+PA -0.8A2 -0.5 P2
A = $25+$0.625P
A/S = (100XA)/S
S = P x Q
Establish a range for P from 0 to $125 in increments of $5 (i.e., $0, 45, $10, ...$125). To test the sensitivity of all other variables to extreme bounds for the price variable, also set price equal to $1,000, $2,500, and $10,000.