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...
Thread 'Video on imaginary numbers and some queries'
Hi, I was watching the following video. I found some points confusing. Could you please help me to understand the gaps? Thanks, in advance! Question 1: Around 4:22, the video says the following. So for those mathematicians, negative numbers didn't exist. You could subtract, that is find the difference between two positive quantities, but you couldn't have a negative answer or negative coefficients. Mathematicians were so averse to negative numbers that there was no single quadratic...
Thread 'Unit Circle Double Angle Derivations'
Here I made a terrible mistake of assuming this to be an equilateral triangle and set 2sinx=1 => x=pi/6. Although this did derive the double angle formulas it also led into a terrible mess trying to find all the combinations of sides. I must have been tired and just assumed 6x=180 and 2sinx=1. By that time, I was so mindset that I nearly scolded a person for even saying 90-x. I wonder if this is a case of biased observation that seeks to dis credit me like Jesus of Nazareth since in reality...
Back
Top