Question

In: Statistics and Probability

Nordique Products, Inc. is trying to decide which of two available strategies it will implement company-wide...

Nordique Products, Inc. is trying to decide which of two available strategies it will implement company-wide in the future – Strategy A or Strategy B.

To identify the best strategy, managers selected two samples of store locations (20 locations in each sample) and implemented one strategy in each sample.

After several months, the firm has compiled data from the different locations within each sample, and has run regression analyses using this data. A variety of independent / explanatory factors are included in the regression models.

The main dependent variable of interest is store profit. (You can assume that lag between the implementation of the strategy and financial results is minimal.)

Relevant information from the regression analysis for stores implementing Strategy A is as follows:

Count = 20

R-squared = 0.692

Adjusted R-squared = 0.651

Coefficient    Std Error t-value p-value   
Intercept 101,452 9,546 8.24 0.01
Strategy implementation score    9,659 946 4.10 0.01
Experience score 4,500 321 3.96 0.01
Market size 0.453 0.042 0.97 0.21
Customer satisfaction 25,409 3,422 2.24 0.04

Relevant information from the regression analysis for stores implementing Strategy B is as follows:

Count = 20

R-squared = 0.692

Adjusted R-squared = 0.651

Coefficient    Std Error t-value p-value   
Intercept 94,440 8,200 7.04 0.01
Strategy implementation score    10,099 1,031 9.28 0.01
Experience score 3,228 546 4.00 0.01
Market size 0.672 0.100 2.10 0.05
Customer satisfaction 31,094 3,652 2.95 0.03

Required

1. Suppose you are making a prediction about financial profit for a future month, based on the analysis from Strategy A. What would your next step be in relying on regression analysis to assess the effectiveness of Strategy A?

2. Suppose you are making a prediction about financial profit for a future month based on the analysis from Strategy B. What would be your prediction based on a store with the following characteristics:

  • Strategy implementation score = 83

  • Experience score = 9.2

  • Market size = 20,000

  • Customer satisfaction rating = 8

3. In interpreting and/or relying on regression analysis (in general), what qualitative concerns should Nordique managers consider?

Solutions

Expert Solution

Sol:

For strategy A regression equation for predicting profit

profit=101452+9659*Strategy implementation score +4500*Experience score+0.453*market size+25403*customer satsifaction

For strategy B regression equation for predicting profit
profit=94440+10099*Strategy implementation score +3228*Experience score+0.672 *market size+31094*customer satsifaction

Prediction scores for strategy A

profit=101452+9659*Strategy implementation score +4500*Experience score+0.453*market size+25403*customer satsifaction

profit=101452+9659*83 +4500*9.2+0.453*20000+25403*8

=1156833

Prediction scores for strategy B

profit=94440+10099*Strategy implementation score +3228*Experience score+0.672 *market size+31094*customer satsifaction

profit=94440+10099*83 +3228*9.2+0.672 *20000+31094*8

=1224547

In interpreting and/or relying on regression analysis (in general), what qualitative concerns should Nordique managers consider?

R sq

here rs qfor both model is

R sq=0.692

=69.2% variation in profit is explained by model

Overall F test for the model

Indivudual t tests for slopes.

For sttargey A

For startegy B

startegy B is best as all are signficant variables at 5% and R sq=69.2%


Related Solutions

Company Delta is trying to decide which of the two IT systems to install. Syske 10...
Company Delta is trying to decide which of the two IT systems to install. Syske 10 million euro and will increase operating profits by 5 million euro per year. Its useful life is five years. Because of rapid technological change, it will have no salvage walue of this time. System 2 costs 15 million euro and will increase operating profits by 8 million euro per year. Its useful life also 5 years, it also will have no salvage value. For...
a) Indigo Inc. has $581,180 to invest. The company is trying to decide between two alternative...
a) Indigo Inc. has $581,180 to invest. The company is trying to decide between two alternative uses of the funds. One alternative provides $77,120 at the end of each year for 12 years, and the other is to receive a single lump-sum payment of $1,823,990 at the end of the 12 years. Which alternative should Indigo select? Assume the interest rate is constant over the entire investment. b) Indigo Inc. has completed the purchase of new Dell computers. The fair...
(1) Wildhorse Inc. has $574,100 to invest. The company is trying to decide between two alternative...
(1) Wildhorse Inc. has $574,100 to invest. The company is trying to decide between two alternative uses of the funds. One alternative provides $80,173 at the end of each year for 12 years, and the other is to receive a single lump-sum payment of $1,801,773 at the end of the 12 years. Which alternative should Wildhorse select? Assume the interest rate is constant over the entire investment. ALTERNATE ONE    OR      ALTERNATE TWO (2) Wildhorse Inc. has completed the purchase of...
Lizzy, a strategic planner at Wild Products, is trying to decide which product to make and...
Lizzy, a strategic planner at Wild Products, is trying to decide which product to make and sell over the next 5 years. Lizzy gets a raise based on her company’s Return on Investment which has been more that 18% in the last 3 years. Below are the cost and revenue projections for each product: Discount rate: 16%                                                                                                                 Gadgets                                               Widgets Initial Investment:                                                                           Cost of Equipment (zero salvage value)                                  $170,000                                              $380,000              Annual revenues and costs: Sales Revenue                                                                                  $250,000                                              $350,000 Variable...
Without trying to decide who will win if Veronica sues Fun Products, Inc. and the Milton...
Without trying to decide who will win if Veronica sues Fun Products, Inc. and the Milton Hotel chain, analyze the following. Who are the parties to this lawsuit, and what are they called (trial level and appeal level)? What types of law will Veronica's lawsuit involve? What type of remedies is she seeking, and are these remedies (or some of them) appropriate to this type of case? What legal sources will the court consider in deciding if Fun Products, Inc....
when a company is trying to decide on which capitalization option is best for the company...
when a company is trying to decide on which capitalization option is best for the company why are the following three important? Company’s capital structure, Company’s working capital and Asset performance of the company. ​
Your company is trying to decide which one of two projects it should accept. Both projects...
Your company is trying to decide which one of two projects it should accept. Both projects have the same start-up costs. Project 1 will produce annual cash flows of $52 000 at the end of each year for six years. Project 2 will produce cash flows of $39 000 at the beginning of each year for eight years. The company requires a 15% return. Required: a. Whichprojectshouldthecompanyselectandwhy? b. Whichprojectshouldthecompanyselectiftheinterestrateis12%atthe cash flows in Project 2 is also at the end of...
Labeau Products, Ltd., of Perth, Australia, has $12,000 to invest. The company is trying to decide...
Labeau Products, Ltd., of Perth, Australia, has $12,000 to invest. The company is trying to decide between two alternative uses for the funds as follows: Invest in Project X Invest in Project Y Investment required $ 12,000 $ 12,000 Annual cash inflows $ 4,000 Single cash inflow at the end of 6 years $ 28,000 Life of the project 6 years 6 years The company’s discount rate is 16%. Click here to view Exhibit 13B-1 and Exhibit 13B-2, to determine...
Labeau Products, Ltd., of Perth, Australia, has $26,000 to invest. The company is trying to decide...
Labeau Products, Ltd., of Perth, Australia, has $26,000 to invest. The company is trying to decide between two alternative uses for the funds as follows: Invest in Project X Invest in Project Y Investment required $ 26,000 $ 26,000 Annual cash inflows $ 8,000 Single cash inflow at the end of 6 years $ 50,000 Life of the project 6 years 6 years The company’s discount rate is 12%. Click here to view Exhibit 13B-1 and Exhibit 13B-2, to determine...
A machine shop is trying to decide which of two types of metal lathe to purchase....
A machine shop is trying to decide which of two types of metal lathe to purchase. The more versatile Japanese lathe costs $32,000,and will generate an annual profit of$16,000 for three years. Its trade-in value after three years will be about $10,000. The more durable German lathe costs $42,000, and will increase profits by $12,000 per year for six years. Its trade-in value at that point is estimated at $15,000. Based on an NPV calculation at a 10% cost of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT