Kerri Tran, owner of Flower Hour, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Tran wants to set the delivery fee based on the distance driven to deliver the flowers. Tran wants to separate the fixed and variable portions of her van operating costs so that she has a better idea how delivery distance affects these costs. Flower Hour does a regression analysis on the next year's data using Excel. The output generated by Excel is as follows: LOADING...(Click the icon to view the regression analysis.) Requirements 1. Determine the firm's cost equation (use the output from the Excel regression). 2. Determine the R-square (use the output from the Excel regression). What does Flower Hour's R-square indicate? 3. Predict van operating costs at a volume of 16 comma 500 miles assuming the company would use the cost equation from the Excel regression regardless of its R-square. Should the company rely on this cost estimate? Why or why not? Requirement 1. Determine the firm's cost equation (use the output from the Excel regression). (Enter amounts to two decimal places.) y = $ x + $
SUMMARY OUTPUT |
|||||
Regression Statistics |
|||||
Multiple R |
0.87 |
||||
R Square |
0.75 |
||||
Adjusted R Square |
0.71 |
||||
Standard Error |
153.46 |
||||
Observations |
7 |
ANOVA |
|||||
df |
SS |
MS |
F |
Significance F |
|
Regression |
1 |
362,391.24 |
362,391.24 |
15.39 |
0.0112 |
Residual |
5 |
117,751.61 |
23,550.32 |
||
Total |
6 |
480,142.86 |
Standard |
Lower |
Upper |
||||
Coefficients |
Error |
t Stat |
P-value |
95% |
95% |
|
Intercept |
1784.73 |
884.55 |
2.02 |
0.10 |
-489.09 |
4,058.55 |
X Variable 1 |
0.22 |
0.06 |
3.92 |
0.01 |
0.07 |
0.36 |
Part 1
Y = $0.22 X + $1784.73
Variable cost = coefficients – X variable 1
Fixed cost = coefficients – intercept
Part 2
R – square = 0.75
It indicates that the cost equation has 75% of the variability in the data. It means that the data should be used cautiously. Kerri Tran may not use this equation confidently to predict total costs at other volumes within the same relevant range.
Part 3
Y = $0.22 X + $1784.73
For 16500 miles
Y = (0.22*16500)+1784.73 = $5414.73
Kerri Tran, owner of Flower Hour, operates a local chain of floral shops. Each shop has...
Kerri Rafferty, owner of Tulip Time, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Rafferty wants to set the delivery fee based on the distance driven to deliver the flowers. Rafferty wants to separate the fixed and variable portions of her van operating costs so that she has a better idea how delivery distance affects these costs. She has the following data from the past seven months...
Kerri Woo, owner of Flower Petal, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Woo wants to set the delivery fee based on the distance driven to deliver the flowers. Woo wants to separate the food and variable portions of her van operating costs so that she has a better idea how delivery distance affects thes costs. She has the following data from the past seven months...
Karen Woo, owner of Flower Petal, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Woo wants to set the delivery fee based on the distance driven to deliver the flowers. Woo wants to separate the fixed and variable portions of her van operating costs so that she has a better idea how delivery distance affects these costs. She has the following data from the past seven months...
Kathy Woo, owner of Flower Paradise, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Woo wants to set the delivery fee based on the distance driven to deliver the flowers. Woo wants to separate the fixed and variable portions of her van operating costs so that she has a better idea how delivery distance affects these costs. She has the following data from the past seven months:...
THANK YOU! please answer, If you know any part of this please help! anything helps! Kristen Chen owner of Flower Paradise, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Chen wants to set the delivery fee based on the distance driven to deliver the flowers. Chen wants to separate the fixed and variable portions of her van operating costs so that she has a better idea how...
KarenKaren SmithSmith, owner of Flower ParadiseFlower Paradise, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, SmithSmith wants to set the delivery fee based on the distance driven to deliver the flowers. Smith wants to separate the fixed and variable portions of herher van operating costs so that sheshe has a better idea how delivery distance affects these costs. SheShe has the following data from the past seven...
Christina Mitchell, owner of Beautiful Arrangements, operates a local chain of flower shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Ms. Mitchell wants to set the delivery fee based on the distance driven to deliver the arrangements. Ms. Mitchell gives you this set of data from the last seven months: Month Van Operating Costs Miles Driven January $5,460 15,800 February 5,748 17,300 March 4,935 14,600 April 5,310 16,000 May 5,830 17,100 June 5,420...
Christina Mitchell, owner of Beautiful Arrangements, operates a local chain of flower shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Ms. Mitchell wants to set the delivery fee based on the distance driven to deliver the arrangements. Ms. Mitchell gives you this set of data from the last seven months: Month. Van Operating Costs Miles Driven January $5,460 15,800 February 5,748 17,300 March 4,935 14,600 April 5,310 16,000 May 5,830 17,100 June 5,420...
Kate Coughlin, owner of Rose Red, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Coughlin wants to set the delivery fee based on the distance driven to deliver the flowers. Coughlin wants to separate the fixed and variable portions of her van operating costs so that she has a better idea how delivery distance affects these costs. She has the following data from the past seven months:...
Kim Jungemann, owner of Tulip Time, operates a local chain of floral shops Each shop has its own delivery van instead of charging a flat delivery foe, Jungemann wants to set the delivery fee based on the distance driven to deliver the flowers. Jungemann wants to separate the foxed and variable portions of her van operating costs so that she has a better idea how delivery distance affects these costs. She has the following data from the past seven months...