MHB Demand and Regression Analysis

AI Thread Summary
Branded Products, Inc. is analyzing the demand for its Super Detergent using a regression model that indicates a strong explanatory power (R² = 91.47%). The discussion highlights concerns about revenue implications during a recession, suggesting a reduction in income would negatively impact sales. Competitor pricing is also a significant factor, as any price change from competitors could affect Branded's revenue by 18%. To maintain market share against a $100 decrease in competitor pricing, Branded would need to lower its price to approximately $574. The participants express confusion over the correct application of statistical methods to derive these insights.
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:
Mathematics 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?
 
Seemingly by some mathematical coincidence, a hexagon of sides 2,2,7,7, 11, and 11 can be inscribed in a circle of radius 7. The other day I saw a math problem on line, which they said came from a Polish Olympiad, where you compute the length x of the 3rd side which is the same as the radius, so that the sides of length 2,x, and 11 are inscribed on the arc of a semi-circle. The law of cosines applied twice gives the answer for x of exactly 7, but the arithmetic is so complex that the...
Is it possible to arrange six pencils such that each one touches the other five? If so, how? This is an adaption of a Martin Gardner puzzle only I changed it from cigarettes to pencils and left out the clues because PF folks don’t need clues. From the book “My Best Mathematical and Logic Puzzles”. Dover, 1994.
Thread 'Imaginary Pythagoras'
I posted this in the Lame Math thread, but it's got me thinking. Is there any validity to this? Or is it really just a mathematical trick? Naively, I see that i2 + plus 12 does equal zero2. But does this have a meaning? I know one can treat the imaginary number line as just another axis like the reals, but does that mean this does represent a triangle in the complex plane with a hypotenuse of length zero? Ibix offered a rendering of the diagram using what I assume is matrix* notation...
Back
Top