Question

15. Integrating Problem The research department of the Corn Flakes Corporation (CFC) estimated the following regression for the demand of the cornflakes it sells: Qx= 1.0 – 2.0PX + 1.51 + 0.8P, – 3.0P + 1.0A where Q, = sales of CFC cornflakes, in millions of 10-ounce boxes per year P = the price of CFC cornflakes, in dollars per 10-ounce box I= personal disposable income, in trillions of dollars per year P, = price of competitive brand of cornflakes, in dollars per 10-ounce box P = price of milk, in dollars per quart A = advertising expenditures of CFC cornflakes, in hundreds of thousands of dollars per year This year, P, = $2,1 = $4, P, = $2.50, P, = $1, and A = $2. (a) Calculate the sales of CFC cornflakes this year. (b) Calculate the elasticity of sales with respect to each variable in the demand function. (c) Estimate the level of sales next year if CFC reduces P, by 10 percent and increases advertising by 20 percent, I rises by 5 percent, P, is reduced by 10 percent, and P, remains unchanged. (d) By how much should CFC change its advertising if it wants its sales to be 30 percent higher than this year?

Please help me answer the Question 4

Answer 1

(Question 4)

Px	I	Py	Pm	A	Qx	Qx'	Qx''	Qx'''
2	4	2.5	1	2	4
1.8	4.2	2.25	1	2.4		4.9
1.8	3.99	2.25	1	1.8			3.985
2.5	3.6	2.75	1.1	1.53				1.83

Excel formula screenshot:

Qut" E14 в в с о Е PxPyPm A 42. 51 2 - A2'0.9 -B2*1.05 =C20.9 =D2 -E2"1.2 = A2"0.9 B30.95 C3 =D3 =E2"0.9 =A21.25 B2*0.9 =C2'1.1 D2 1.1 E4'0.85 Qx =1-(2A2)+(1.5'32)+(0.8*C2)-(3'D2)E2 -1-(2*A3)-(1.5'83](0.8°C3)-(3-D3)-E3 - - *. OM 4 5 = 1-(2'A4)+(1.5'B4)+(0.8"C4)-(3'D4)+E4 -1-(2ºA5)+(1.5'85)+(0.8°C5)-(3'D5)-E5