Group Case Study 论文范文
Memorandum
To: Marketing Manager of Speedy Collection
From: Group 5
Date: October 18, 2016
Subject: Recommendation for the company’s slogan (Under 50 days or your money back)
This memo serves as a suggestion regarding the analysis we made on Speedy Collection’s new slogan. Due to the current competition between the collection services company, the marketing department of the company has suggested a slogan “Under 50 days or your money back!!!!”. We agree that this slogan can build the company’s integrity and gain customers’ trust because 50 days is a relatively long time for them to get their money back. Also, adopting this slogan will distinguish our company from competitors and establish a good reputation. However, it is our opinion that for the slogan to work well and aligned with the money-back guarantee program, we need to add a couple of terms and conditions for the slogan. We have analyzed the data given and come to the idea that this additional terms and conditions are needed. For the individual account, we recommend that the slogan can be applied only if the amount is less than $292. For the business account, we can apply the slogan only if the amount is larger than $350.
After analyzing the two groups of accounts, which are the individual and business account, we learned that there are conditions needed to be satisfied for the slogan to work. For the individual account, we can get the money back within 50 days if the amount is less than $292. We set the maximum price as accurate as possible so that we will not lose any money. For the business account, we can get the money back within 50 days if the amount is greater than $350. The initial minimum for the business account was $304, but we decided to raise the minimum so that the company can still make a profit.
We are confident that Speedy Collection will do a lot better if the slogan is applied, considering all the conditions we just made. Without the company’s capability to collect the money from both accounts (individual and business), the new slogan will put the Marketing manager of Speedy Collection in a fragile position instead. Thus, before the marketing department of the company decides to apply the slogan, these points needs to be taken seriously into account.
Regards,
Speedy Collection Accounting Department
Appendix
Business Account
Regression Statistics |
|
Multiple R |
0.9408918736 |
R Square |
0.8852775178 |
Adjusted R Square |
0.8829362426 |
Standard Error |
4.833869385 |
Observations |
51 |
ANOVA |
|||||
|
df |
SS |
MS |
F |
Significance F |
Regression |
1 |
8835.208495 |
8835.208495 |
378.1176761 |
0 |
Residual |
49 |
1144.948368 |
23.36629323 |
|
|
Total |
50 |
9980.156863 |
|
|
|
|
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
Lower 95.0% |
Upper 95.0% |
Intercept |
95.46489177 |
1.76702719 |
54.02570617 |
0 |
91.91391769 |
99.01586586 |
91.91391769 |
99.01586586 |
AMOUNT |
-0.1545897699 |
0.007950002416 |
-19.44524816 |
0 |
-0.1705658979 |
-0.1386136419 |
-0.1705658979 |
-0.1386136419 |
Business Account Scattered Plot
This scattered plot graph shows the relationship between days and amount for the business account. As we can see from the slope, it shows a strong negative linear correlation between those two variables.
Analysis for Business Account
Simple Regression Equation: Days = 95.46 - 0.15 * Amount
Explanations:
● Independent variable: Amount
● Dependent variable: Days
● b0 = 95.46 suggests that when the amount is equal to zero, it will take 95.46 days to collect the money back
● b1 = -0.15 suggests that for every one unit increase in the amount, the days to collect the money back will decrease by 0.15 days
Days = 95.46 - 0.15 * Amount
(Substitute 50 into Days)
50 = 95.46 - 0.15 * Amount
Amount = 303.07
Solution: Apply the slogan only if Amount > $304
Hypothesis Testing:
Ho: β1 = 0 (no linear relationship)
Ha: β1 ≠ 0
Test Statistic: T = -19.45
Decision Rule:
Reject Ho if |T| > tα/2, df
19.45 > t0.1/2, 49
19.45 > 1.677
Decision:
Reject Ho. We are 90% sure that there is a linear relationship between the amount of dollars and days collected.
Individual Account
Regression Statistics |
|
Multiple R |
0.981330851 |
R Square |
0.963010239 |
Adjusted R Square |
0.962255346 |
Standard Error |
2.6516396 |
Observations |
51 |
Anova |
|||||
|
df |
SS |
MS |
F |
Significance F |
Regression |
1 |
8969.628427 |
8969.628427 |
1275.690907 |
0 |
Residual |
49 |
344.5284359 |
7.031192569 |
|
|
Total |
50 |
9314.156863 |
|
|
|
|
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
Lower 95.0% |
Upper 95.0% |
Intercept |
6.221030953 |
0.979842859 |
6.349008819 |
0.00000006765725733 |
4.251963008 |
8.190098899 |
4.251963008 |
8.190098899 |
AMOUNT |
0.1509667692 |
0.004226770141 |
35.71681547 |
0 |
0.1424727566 |
0.1594607818 |
0.1424727566 |
0.1594607818 |
Individual Account Scattered Plot
This scattered plot graph shows the relationship between days and amount for the individual account. As we can see from the slope, it shows a strong positive linear correlation between those two variables.
Analysis for Individual Account
Simple Regression Equation: Days = 6.22 + 0.15 * Amount
Explanations:
● Independent variable: Amount
● Dependent variable: Days
● b0 = 6.22 suggests that when the amount is equal to zero, it will take 95.46 days to collect the money back
● b1 = 0.15 suggests that for every one unit increase in the amount, the days to collect the money back will increase by 0.15 days
Days = 6.22 + 0.15 * Amount
50 = 6.22 + 0.15 * Amount
Amount = 291.87
Solution: Apply the slogan only if the amount <$292
Hypothesis Testing
Ho: β1 = 0 (no linear relationship)
Ha: β1 ≠ 0
Test Statistic: T = 35.72
Decision Rule:
Reject Ho if |T| > tα/2, df
35.72 > t0.1/2, 49
35.72 > 1.677
Decision and Conclusion:
Reject Ho. We are 90% sure that there is a linear relationship between the amount of dollars and days collected.