The file Comm172 Assignment1 Data 2021.xlsx contains store sales data for Heineken beer. The data for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The file Comm172 Assignment1 Data 2021.xlsx contains store sales data for Heineken beer. The data for this question is in the Question 2 sheet. The respective variables are Qc - the total unit sales of Heineken beer (six-packs, in cans, 72oz) across a large number of U.S. stores Pc - the price per liter of Heineken beer in cans Pb - the price per liter of Heineken beer in glass bottles 3 A - the total cost of advertising in the U.S. (in $1,000) The data cover 52 weeks from January 1, 2001, to December 24, 2001. You seek to understand the demand for a six-pack Heineken beer in cans. You decide to identify the underlying factors that explain the sales and measure the relative importance of these factors. (a) (2 points) Estimate the linear demand function of this form: Qc = 30 + B1Pc + U(1) where u denotes the error term. Please copy and paste your regression results from your Excel file and write down the estimated coefficients and the estimated demand function. Do not submit your Excel file for this question. (b) (1 point) Evaluate the regression coefficients statistically (i.e., which estimated coefficients are statistically significant at the 5% level?). (c) (1 point) What does the sign of the estimated coefficient 31 indicate? What does its magnitude indicate? (d) (3 points) Calculate own-price elasticity of demand at Pc = $15.00 and Pc = $30.00. How do the elasticity values differ and why? (e) (5 points) Based on the elasticity estimates, predict how the total revenue will change if Pc is increased above $15.00 and explain why. How will the profit change? What if Pc is dropped below $30.00? How will the total revenue and profit change? Is the optimal price below or above $15.00? Is it below or above $30.00? Please provide your answers and reasoning. (f) (1 point) Now consider the following demand function: Qc = e^30 x Pc^B1... (2) Write down this function in a log-linear form. (g) (2 points) Now transform the data into logs and estimate the log-linear function. Please copy and paste your regression results from your Excel file. Using the estimated coefficients, write down the estimated demand function as it appears in (2). (h) (2 points) What does the coefficient 31 measure? What does the magnitude of the estimated coefficient 31 indicate? (1) (1 point) You realized that the demand function (2) could be misspecified since it omits other variables. Add the log of Pb and the log of A into the regression equation estimated in part (g) and re-estimate the equation. Please copy and paste your regression results from your Excel file. (i) (0.5 points) Which model fits the data better, the one in part (g) or in part (1)? Hint: look at the adjusted B2 4 (k) (2.5 points) Ace the two products (canned and bottled beer) complements or substitutes? How will the demand for a six-pack Heineken beer in can change if the price of bottled beer Pb is increased by 1%? Explain using the estimation results from part (i). (1) (1 point) Estimate this equation: Qc = b0 + b1T ime + u, where Time is the week number, and write down the estimated function. (m) (2 points) What does the magnitude of the coefficient b1 indicate? What is the absolute change in the total unit sales per 10 weeks? (n) (1 point) Now estimate this equation: In Qc = b0 + b1T ime + u. Write down the estimated function. (0) (2 points) Calculate the percentage sales growth rate g per 10 weeks. Q 338 361 382 406 308 324 311 311 301 296 321 550 461 283 377 360 314 314 310 334 306 305 293 527 L 5215 6623 6859 7948 4560 5081 5383 4410 4294 3913 6116 25411 18043 3351 7038 5719 4248 5036 4278 5175 4343 4675 3985 16359 527 559 319 375 342 408 357 317 330 288 315 291 487 533 320 297 333 359 329 308 323 276 308 293 428 16359 27389 5875 7021 7123 10989 6626 4389 5530 3586 4721 4685 19869 22663 4700 3723 6745 7876 5181 4838 6014 3424 4634 3523 12484 The file Comm172 Assignment1 Data 2021.xlsx contains store sales data for Heineken beer. The data for this question is in the Question 2 sheet. The respective variables are Qc - the total unit sales of Heineken beer (six-packs, in cans, 72oz) across a large number of U.S. stores Pc - the price per liter of Heineken beer in cans Pb - the price per liter of Heineken beer in glass bottles 3 A - the total cost of advertising in the U.S. (in $1,000) The data cover 52 weeks from January 1, 2001, to December 24, 2001. You seek to understand the demand for a six-pack Heineken beer in cans. You decide to identify the underlying factors that explain the sales and measure the relative importance of these factors. (a) (2 points) Estimate the linear demand function of this form: Qc = 30 + B1Pc + U(1) where u denotes the error term. Please copy and paste your regression results from your Excel file and write down the estimated coefficients and the estimated demand function. Do not submit your Excel file for this question. (b) (1 point) Evaluate the regression coefficients statistically (i.e., which estimated coefficients are statistically significant at the 5% level?). (c) (1 point) What does the sign of the estimated coefficient 31 indicate? What does its magnitude indicate? (d) (3 points) Calculate own-price elasticity of demand at Pc = $15.00 and Pc = $30.00. How do the elasticity values differ and why? (e) (5 points) Based on the elasticity estimates, predict how the total revenue will change if Pc is increased above $15.00 and explain why. How will the profit change? What if Pc is dropped below $30.00? How will the total revenue and profit change? Is the optimal price below or above $15.00? Is it below or above $30.00? Please provide your answers and reasoning. (f) (1 point) Now consider the following demand function: Qc = e^30 x Pc^B1... (2) Write down this function in a log-linear form. (g) (2 points) Now transform the data into logs and estimate the log-linear function. Please copy and paste your regression results from your Excel file. Using the estimated coefficients, write down the estimated demand function as it appears in (2). (h) (2 points) What does the coefficient 31 measure? What does the magnitude of the estimated coefficient 31 indicate? (1) (1 point) You realized that the demand function (2) could be misspecified since it omits other variables. Add the log of Pb and the log of A into the regression equation estimated in part (g) and re-estimate the equation. Please copy and paste your regression results from your Excel file. (i) (0.5 points) Which model fits the data better, the one in part (g) or in part (1)? Hint: look at the adjusted B2 4 (k) (2.5 points) Ace the two products (canned and bottled beer) complements or substitutes? How will the demand for a six-pack Heineken beer in can change if the price of bottled beer Pb is increased by 1%? Explain using the estimation results from part (i). (1) (1 point) Estimate this equation: Qc = b0 + b1T ime + u, where Time is the week number, and write down the estimated function. (m) (2 points) What does the magnitude of the coefficient b1 indicate? What is the absolute change in the total unit sales per 10 weeks? (n) (1 point) Now estimate this equation: In Qc = b0 + b1T ime + u. Write down the estimated function. (0) (2 points) Calculate the percentage sales growth rate g per 10 weeks. Q 338 361 382 406 308 324 311 311 301 296 321 550 461 283 377 360 314 314 310 334 306 305 293 527 L 5215 6623 6859 7948 4560 5081 5383 4410 4294 3913 6116 25411 18043 3351 7038 5719 4248 5036 4278 5175 4343 4675 3985 16359 527 559 319 375 342 408 357 317 330 288 315 291 487 533 320 297 333 359 329 308 323 276 308 293 428 16359 27389 5875 7021 7123 10989 6626 4389 5530 3586 4721 4685 19869 22663 4700 3723 6745 7876 5181 4838 6014 3424 4634 3523 12484
Expert Answer:
Answer rating: 100% (QA)
a For a sixpack of Heineken beer in cans the linear demand function is Qc 80 81Pc u The coefficient on the price per liter ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
A case of 24 cans contains 1 can that is contaminated. Three cans are to be chosen randomly for testing. a. How many different combinations of three cans could be selected? b. What is the probability...
-
To help understand the factors impacting a sales budget, you are to visit three businesses with the same ownership or franchise membership. Record the selling prices of two identical products at each...
-
The demand for beer in Japan is given by the following equation: Qd = 700 2P PN + 0.1I, where P is the price of beer, PN is the price of nuts, and I is average consumer income. a) What happens to...
-
How did your parents communication with you influence your self-concept?
-
Using the loanable funds theory, show in a graph how each of the following events affects the supply and demand for loans and the equilibrium real interest rate: a. A war leads the government to...
-
Sprout Company reported the following on the companys income statement in two recent years: a. Determine the times interest earned ratio for the current year and the prior year. Round to one decimal...
-
Atlantic Cruise Lines operates cruise ships and is headquartered in Florida. The firm had \($100\) million in pretax operating income in the current year, of which it reinvested \($25\) million. The...
-
Turner Excavation maintains a checking account and has decided to open a petty cash fund. The following petty cash fund transactions occurred during July: July 2 Established a petty cash fund by...
-
On December 31 before adjusting entries, Accounts Receivable forCalegari Company had a debit balance of $200,000, and the Allowancefor Doubtful Accounts had a credit balance of $6,000. Credit sales 2...
-
The flowers in a garden at a resort need to be replaced. The choices for the flowers are Geraniums (G), Impatiens (I), Petunias (P), and Zinnias (Z). The head gardener holds an election in which all...
-
1- From the following equation of the parabola: x? = -12y, graph and calculate: a) Vertex and focus b) Position C) Form of the equation d) Equation of the directrix
-
What are the implications of shifting baseline syndrome on the perception of environmental degradation, and how does this affect conservation policies and efforts aimed at preserving ecological...
-
How much total heat transfer is necessary to lower the temperature of 0.155 kg of steam from 141.5 C to -15.5 C, including the energy for phase changes? total heat transfer: J How much time is...
-
1 Explain how the culture of Volkswagon created the ethical scandal 2 While Volkswagen claimed to support ethics and sustainability, how can they recover from this ethical disaster? 3 Do you believe...
-
It's not a secret, in fact, it should be one of the main topics that we as human beings should be discussing right now. Our home is suffering and we need to step up and start the right conversations...
-
Elucidate the notion of "matching" within the strategic formulation framework, providing a minimum of three instances exemplifying this concept.
-
Cul de las siguientes es la secuencia correcta deeventos?1. Analizar una transaccin; registrarlo en el diario;publicarlo en el libro mayor2. Analizar una transaccin; publicarlo en el libro 1 answer
-
Suppose the concentration of glucose inside a cell is 0.1 mm and the cell is suspended in a glucose solution of 0.01 mm. a. What would be the free energy change involved in transporting 10-o mole of...
-
Consider the Coke and Pepsi example discussed in the chapter. a) Explain why each firm's reaction function slopes upward. That is, why does Coke's profit-maximizing price go up the higher is Pepsi's...
-
Suppose a production function is given by Q = 10K + 2L. The factor price of labor is 1. Draw the demand curve for capital when the firm is required to produce Q = 80.
-
Sarah consumes apples and oranges (these are the only fruits she eats). She has decides that her monthly budget for fruit will be $50. Suppose that one apple costs $0.25, while one orange costs...
-
Make as comprehensive as possible a list of the assets you own today including your home if you own one, or unexpired rent if you still have some time to go before your next rent bill is due. Decide...
-
Deduct ion your total value of assets drawn up in the previous Review activity any liabilities : (mortgages, bank loans, etc.) to calculate how much you are worth (this is referred to as your owner's...
-
In what important ways will a profit and loss account differ from a statement of cash flow?
Study smarter with the SolutionInn App