Question

In: Finance

The Fresh Detergent Case Enterprise Industries produces Fresh, a brand of liquid detergent. In order to...

The Fresh Detergent Case

Enterprise Industries produces Fresh, a brand of liquid detergent. In order to more effectively manage its inventory, the company would like to better predict demand for Fresh. To develop a prediction model, the company has gathered data concerning demand for Fresh over the last 33 sales periods. Each sales period is defined as one month. The variables are as follows:

Demand = Y = demand for a large size bottle of Fresh (in 100,000)

Price = the price of Fresh as offered by Ent. Industries

AIP = the average industry price

ADV = Ent. Industries Advertising Expenditure (in $100,000) to Promote Fresh in the sales period.

DIFF = AIP - Price = the "price difference" in the sales period

Question:

  1. Obtain the correlation matrix for all six variables and list the variables that have strong correlation with Demand. High correlation is r > 0.50. Explain your findings in plain language.

Month/Yr.

PERIOD

PRICE

AIP

DIFF

ADV

DEMAND

June 2016

1

6.1

5.8

-0.3

5.3

14.4

2

5.75

6

0.25

6.75

15.3

3

5.7

6.3

0.6

7.25

16.5

4

5.7

5.7

0

7.3

16.1

5

5.6

5.85

0.25

7.2

16

6

5.6

5.8

0.2

6.5

15.5

7

5.6

5.75

0.15

6.75

15.2

Jan. 2017

8

6.3

5.85

-0.45

6.89

13.9

9

6.4

5.65

-0.75

5.8

13.3

10

6.2

6

-0.2

5.5

13.12

11

5.9

6.1

0.2

6.5

13.8

12

5.9

6

0.1

6.25

14.8

13

5.7

6.1

0.4

7

15.3

14

5.75

6.2

0.45

6.9

16.3

15

5.75

6.1

0.35

6.8

17.5

16

5.8

6.1

0.3

6.8

17.4

17

5.7

6.2

0.5

7.1

17.1

18

5.8

6.3

0.5

7

16.8

19

5.7

6.1

0.4

6.8

16.5

Jan. 2018

20

5.8

5.75

-0.05

6.5

16

21

5.8

5.75

-0.05

8.1

15.2

22

5.75

5.65

-0.1

7.7

15.3

23

5.7

5.9

0.2

7.3

15.9

24

5.55

5.65

0.1

7.5

16.2

25

5.6

6.1

0.5

8.1

17.5

26

5.65

6.25

0.6

8.3

18.4

27

5.7

5.65

-0.05

8.7

19.4

28

5.75

5.75

0

9.2

19.1

29

5.8

5.85

0.05

8.4

18.7

30

5.3

6.25

0.95

8.8

18.2

31

5.4

6.3

0.9

9.5

18.4

Jan. 2019

32

5.7

6.4

0.7

9.3

17.5

Feb. 2019

33

5.9

6.5

0.6

9.1

17.1

Solutions

Expert Solution

PRICE AIP DIFF ADV DEMAND
PRICE 1
AIP -0.23374 1
DIFF -0.76244 0.807343 1
ADV -0.55717 0.299438 0.537413 1
DEMAND (Y) -0.64098 0.299191 0.588114 0.783047 1

The Above table shows the result of the co-relation matrix. the co relation matrix could be calculated by using excel. In excel, under Data Tab, go to data analysis and click. From the list of options select co relation. Select the above table in the input column and click enter.

Interpreting the results:-

the strong co relation factors (r>.5) are DIFF and ADV.

This means that when the product price is less than that of the industry, the product seems more attractive and hence demand increases. This shows that the DIFF and Demand are positively co related.  

ADV or Advertising Expenditure also increases. More the expenditure, more will be the demand for the product

As we can see Price has a very strong negative co relation with the demand. that is as the price goes up, the demand decreases.


Related Solutions

Enterprise Industries produces Fresh, a brand of liquid laundry detergent. In order to manage its inventory...
Enterprise Industries produces Fresh, a brand of liquid laundry detergent. In order to manage its inventory more effectively and make revenue projections, the company would like to better predict demand for Fresh. To develop a prediction model, the company has gathered data concerning demand for Fresh over the last 30 sales periods (each sales period is defined to be a four-week period). The demand data are presented in table concerning y (demand for Fresh liquid laundry detergent), x1x1 (the price...
Q7. Enterprise Industries produces Fresh, a brand of liquid laundry detergent. In order to manage its...
Q7. Enterprise Industries produces Fresh, a brand of liquid laundry detergent. In order to manage its inventory more effectively and make revenue projections, the company would like to better predict demand for Fresh. To develop a prediction model, the company has gathered data concerning demand for Fresh over the last 30 sales periods (each sales period is defined to be a four-week period). Summary of Fit RSquare 0.940514 RSquare Adj 0.928121 Root Mean Square Error 0.18111 Mean of Response 8.382667...
Enterprise Industries produces Fresh, a brand of liquid laundry detergent. In order to manage its inventory...
Enterprise Industries produces Fresh, a brand of liquid laundry detergent. In order to manage its inventory more effectively and make revenue projections, the company would like to better predict demand for Fresh. To develop a prediction model, the company has gathered data concerning demand for Fresh over the last 30 sales periods (each sales period is defined to be a four-week period). The demand data are presented in table concerning y (demand for Fresh liquid laundry detergent), x1x1 (the price...
Enterprise Industries produces Fresh, a liquid laundry detergent product. In order to study the relationship between...
Enterprise Industries produces Fresh, a liquid laundry detergent product. In order to study the relationship between price and sales of Fresh, the company has gathered data concerning demand for Fresh over the last 30 sales periods (each sales period is four weeks). The data can be found Fresh.xlsx. Here is the explanation of each variable: Period: the index of 30 sales period (Period = 1, 2, …, 30) Sales: the sales volume (in hundreds of thousands of bottles) of Fresh...
Consider the demand for Fresh Detergent in a future sales period when Enterprise Industries' price for...
Consider the demand for Fresh Detergent in a future sales period when Enterprise Industries' price for Fresh will be x1 = 3.70, the average price of competitors’ similar detergents will be x2 = 3.90, and Enterprise Industries' advertising expenditure for Fresh will be x3 = 6.50, y = the demand in hundreds of thousands of bottles. A 95 percent prediction interval for this demand is given on the following Excel add-in (MegaStat) output: 95% Confidence Interval 95% Prediction Interval Predicted...
Consider the demand for Fresh Detergent in a future sales period when Enterprise Industries' price for...
Consider the demand for Fresh Detergent in a future sales period when Enterprise Industries' price for Fresh will be x1 = 3.70, the average price of competitors’ similar detergents will be x2 = 3.90, and Enterprise Industries' advertising expenditure for Fresh will be x3 = 6.50, y = the demand in hundreds of thousands of bottles. A 95 percent prediction interval for this demand is given on the following Excel add-in (MegaStat) output: 95% Confidence Interval 95% Prediction Interval   Predicted...
Hog Wild Incorporated produces clean start, a brand of liquid laundry detergent. The company wishes to...
Hog Wild Incorporated produces clean start, a brand of liquid laundry detergent. The company wishes to study the factors affecting the quarterly demand for the large size bottle of clean start in its sales regions. To do this the company has selected the following variables: y = The demand for the large size bottle X1 = The price of clean start X2 = the average price of competitors with similar detergents X3 = The advertising expenditures to promote clean start...
Lokal Food Manufacturer produces the "Fresh" brand of pasteurised coconut milk from one of its manufacturing...
Lokal Food Manufacturer produces the "Fresh" brand of pasteurised coconut milk from one of its manufacturing processes. The following information of process inputs, outputs and work in process relates to the month of September 2018: kg Opening work in process ...........26,700 Raw materials input.................. 110,600 Output completed....................... 98,400 Closing work in process............. 29,200 The opening and closing work in process are respectively 30 per cent and 60 per cent complete as to conversion costs. Raw materials are added at the...
The market for laundry detergent is monopolistically competitive. Each firm owns one brand, and each brand...
The market for laundry detergent is monopolistically competitive. Each firm owns one brand, and each brand has effectively differentiated itself so that it has some market power (i.e., faces a downward sloping demand curve). Still, no brand earns economic profits, because entry causes the demand for each brand to shift in until the seller can just break even. All firms have identical cost functions, which are U-shaped. (a) Is this market in long-term or short-term equilibrium? Explain your claim? Now...
The label on a bottle of liquid detergent shows the contents to be 12 grams per...
The label on a bottle of liquid detergent shows the contents to be 12 grams per bottle. The production operation fills the bottle uniformly according to the following probability density function: f(x) = { 8 11:975 < x < 12:100 0 elsewhere where x denotes the grams the bottle will be filled. a) What is the expected value and the standard deviation of X? ( b) What is the probability that a bottle will be filled with between 12 and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT