Demand and Regression Analysis

Click For Summary
SUMMARY

The forum discussion centers on the demand and regression analysis for Branded Products, Inc.'s Super Detergent. The regression model presented is Q = 867.98 – 81.86P + 0.007A + 0.006I + 82.86Px + 1.309T, with an R² value of 91.47%, indicating a strong explanatory power for the model. Key insights include that a recession would reduce revenue by approximately $302.24 due to decreased disposable income, and any price change by competitors would impact Branded Products' revenue by 18%. To maintain market share against a $100 decrease in competitor pricing, Branded Products would need to adjust their price to $574.

PREREQUISITES
  • Understanding of regression analysis and its components, including t-statistics and R² values.
  • Familiarity with economic concepts such as demand elasticity and market competition.
  • Knowledge of how to interpret and apply regression models in a business context.
  • Basic skills in statistical analysis software or tools for performing regression analysis.
NEXT STEPS
  • Study the implications of R² values in regression analysis to assess model fit.
  • Learn about demand elasticity and its impact on pricing strategies in competitive markets.
  • Explore advanced regression techniques, such as multiple regression and interaction terms.
  • Investigate the effects of economic downturns on consumer behavior and demand forecasting.
USEFUL FOR

Marketing analysts, business strategists, and data scientists involved in demand forecasting and competitive analysis will benefit from this discussion.

rr2013
Messages
2
Reaction score
0
A bit confused with this question. my answers are below each question. please help.

Branded Products, Inc., based in Halfway Tree is a leading producer and marketer of household laundry detergent and bleach products. About a year ago, Branded products rolled out its new Super Detergent in four western parishes, following success in more limited test markets. At the time of introduction, management wondered whether the company could successfully crack this market, dominated by Breeze and other major players. The following regression model forecast results for Super Detergent over the past seven months (30 weeks). The t-statistics are in parenthesis.
Q = 867.98 – 81.86P + 0.007A + 0.006I + 82.86Px + 1.309T
(345) (24) (0.7) (0.2) (18) (0.063)
R2 = 91.47%, Standard of Error of the Estimate = 33.64 t(0.01, (n-k)df) = 2.492, F(k-1, n-k, 0.01) = 3.895
Q is the demand in cases, P is tile price (per case), Px is the competitor price, A is advertising expenditures (in thousands of dollars), I is disposable income per capita (in thousands of dollars) and T represent the month.
If P = $700.5, Px = $750 A= $350,000 I = $900,0001.What is the revenue implication for Branded Products, if there a recession? If there is a recession income will be affected(reduced) and this reduce revenue; a 302.24 reduction- (dervived from subtracting t-test values- 345-(24+.7+18+0-0.063)

2.What proportion of the variation in super detergent sales is explained by the regression model?
91.47%

3.Determine if Branded products should be concerned about its main competitors
yes any change in comptetirs price will affect barnded products revenue by 18%

4.If Branded Products wants to maintain at least its share of the market, what change in the price of their detergent will be necessary to compensate for a \$100 decrease in the price of its main competitors’ detergent?
$700-$700*18%=$574
 
Last edited by a moderator:
Physics news on Phys.org
Welcome to MHB, rr2013! :)

rr2013 said:
A bit confused with this question. my answers are below each question. please help.

Branded Products, Inc., based in Halfway Tree is a leading producer and marketer of household laundry detergent and bleach products. About a year ago, Branded products rolled out its new Super Detergent in four western parishes, following success in more limited test markets. At the time of introduction, management wondered whether the company could successfully crack this market, dominated by Breeze and other major players. The following regression model forecast results for Super Detergent over the past seven months (30 weeks). The t-statistics are in parenthesis.
Q = 867.98 – 81.86P + 0.007A + 0.006I + 82.86Px + 1.309T
(345) (24) (0.7) (0.2) (18) (0.063)
R2 = 91.47%, Standard of Error of the Estimate = 33.64 t(0.01, (n-k)df) = 2.492, F(k-1, n-k, 0.01) = 3.895
Q is the demand in cases, P is tile price (per case), Px is the competitor price, A is advertising expenditures (in thousands of dollars), I is disposable income per capita (in thousands of dollars) and T represent the month.
If P = $700.5, Px = $750 A= $350,000 I = $900,0001.What is the revenue implication for Branded Products, if there a recession? If there is a recession income will be affected(reduced) and this reduce revenue; a 302.24 reduction- (dervived from subtracting t-test values- 345-(24+.7+18+0-0.063)

I'm not sure what you're doing here.
You can't use t-values this way.
It seems to me that to predict the impact of a recession, we wouldn't assume a change in our own price, nor the competitor's price, advertising expenditures, or the month.
We would assume a change in the disposable income per capita...

2.What proportion of the variation in super detergent sales is explained by the regression model?
91.47%

Right.

3.Determine if Branded products should be concerned about its main competitors
yes any change in comptetirs price will affect barnded products revenue by 18%

How did you get that?

4.If Branded Products wants to maintain at least its share of the market, what change in the price of their detergent will be necessary to compensate for a \$100 decrease in the price of its main competitors’ detergent?
$700-$700*18%=$574

How did you get that?

Maintaining the share of the market implies there should be no change in quantity.
That does not seem to be what you are doing.
 
Last edited:
I like Serena said:
Welcome to MHB, yaoming988! :)
I'm not sure what you're doing here.
You can't use t-values this way.
It seems to me that to predict the impact of a recession, we wouldn't assume a change in our own price, nor the competitor's price, advertising expenditures, or the month.
We would assume a change in the disposable income per capita...
Right.
How did you get that?
How did you get that?

Maintaining the share of the market implies there should be no change in quantity.
That does not seem to be what you are doing.

Quote - regarding question one I subtracted the t values of all the factors excluding income - i saw something similar done in an example online but I'm not certain I'm on the right track please guide me in answering this question.

thr truth is I'm sure i should be using the values given to answer the questions i.ethe t test, f test, rsquared etc but i do not know how to go about doing that. The examples we work in class are a lot simplier.

- - - Updated - - -

rr2013 said:
Quote - regarding question one I subtracted the t values of all the factors excluding income - i saw something similar done in an example online but I'm not certain I'm on the right track please guide me in answering this question.

thr truth is I'm sure i should be using the values given to answer the questions i.ethe t test, f test, rsquared etc but i do not know how to go about doing that. The examples we work in class are a lot simplier.

can you please walk me through answering this question
 
rr2013 said:
can you please walk me through answering this question

Can you walk us through your answers?