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 months:
LOADING...
(Click the icon to view the data.)Use the high-low method to determine
Flower ParadiseFlower Paradise's
cost equation for van operating costs. Use your results to predict van operating costs at a volume of
15 comma 00015,000
miles.
Let's begin by determining the formula that is used to calculate the variable cost (slope).
Change in cost |
/ |
Change in volume |
= |
Variable cost (slope) |
Now determine the formula that is used to calculate the fixed cost component.
Total operating cost |
- |
Total variable cost |
= |
Fixed cost |
Use the high-low method to determine
Flower ParadiseFlower Paradise's
operating cost equation. (Round the variable cost to the nearest cent and the fixed cost to the nearest whole dollar.)
y = $ |
x + $ |
Month |
Miles Driven |
Van Operating Costs |
January. . . . . . . . . . . . . . . |
15,700 |
$5,350 |
February. . . . . . . . . . . . . . . |
16,500 |
$5,160 |
March. . . . . . . . . . . . . . . . . |
14,500 |
$4,960 |
April. . . . . . . . . . . . . . . . . . |
16,000 |
$5,320 |
May. . . . . . . . . . . . . . . . . . |
16,300 |
$5,500 |
June. . . . . . . . . . . . . . . . . . |
15,100 |
$5,050 |
July. . . . . . . . . . . . . . . . . . . |
14,000 |
$4,560 |
PrintDone
Change in cost / Change in volume = Variable cost (Slope)
(Highest activity cost - Lowest activity cost)/(Highest activity - Lowest activity) = Variable cost per mile
(5,160-4,560)/(16,500 - 14,000) = Variable cost per mile
600/2,500 = Variable cost per mile
0.24 per miles = Variable cost per mile
Total operating cost -Total variable cost = Fixed cost
5,160- (16,500 x 0.24) = Fixed cost
$1,200 = Fixed cost
Operating equation
y = $0.24x + $1,200
predict van operating costs at a volume of 15,000 miles
= Fixed cost + Variable cost per miles x Activity miles
= 1,200 + 0.24x 15,000
= $4,800
Kindly give a positive rating if you are satisfied with this solution and please ask if you have any query.
Thanks
KarenKaren SmithSmith, owner of Flower ParadiseFlower Paradise, operates a local chain of floral shops. Each shop...
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:...
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...
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...
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...
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 tes 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...
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...
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...
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...
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...