Question

Kaitly woo owner of Flower ParadiseFlower Paradise​, operates a local chain of floral shops. Each shop...

Kaitly woo 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,

WooWoo

wants to set the delivery fee based on the distance driven to deliver the flowers.

WooWoo

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 + $

Enter any number in the edit fields and then click Check Answer.

Data Table

Month

Miles Driven

Van Operating Costs

January. . . . . . . . . . . . . . .

15,500

$5,390

February. . . . . . . . . . . . . . .

17,400

$5,280

March. . . . . . . . . . . . . . . . .

15,400

$4,960

April. . . . . . . . . . . . . . . .

16,300

$5,340

May. . . . . . . . . . . . . . . .

16,500

$5,450

June. . . . . . . . . . . . . . . .

15,200

$5,230

July. . . . . . . . . . . . . . . . . . .

14,400

$4,680

Homework Answers

Answer #1

Answer

High-Low Method

As we can see that in February month the Miles driven is Highest and In July Month the miles driven is least.

Miles

Operating cost

February

17,400

5,280

July

14,400

4,680

Difference

3,000

600

Variable cost = (High Cost – Low Cost) / (High miles – Low miles)

= (5,280 – 4,680) / (17,400 – 14,400)

Variable cost = $0.2 per Mile

2.

Fixed Cost = Total Cost – Variable cost

Lets take February month, Total Cost = $5,280, Miles = 17,400

Fixed Cost = $5,280 – (17,400 Miles * $0.2 per mile)

Fixed Cost = $1,800

3.

Equation

Total Cost = Variable Cost + Fixed Cost

Total Cost = (Miles Driven * Variable cost per mile) + Fixed Cost

Y = $0.2x + $1,800

x = No. of Miles Driven

y = Total Cost

4.

Expected Cost at 15,000 miles

= ($0.2 * miles) + $1,800

= ($0.2 * 15,000 Miles) + $1,800

Expected Cost for 15,000 Miles = $4,800

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Kathy Smith, owner of Tulip Time, operates a local chain of floral shops. Each shop has...
Kathy Smith, 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, Smith 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 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:...
Kaitlyn Coughlin​, owner of Flower Hour​, operates a local chain of floral shops. Each shop has...
Kaitlyn Coughlin​, 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, 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:...
The Jolly Transport Co. operates a fleet of delivery trucks in the Ft Lauderdale area. It...
The Jolly Transport Co. operates a fleet of delivery trucks in the Ft Lauderdale area. It has been determined that if a truck is driven 105,000 kilometers over a one year period the average operating cost is $0.114 per kilometer. If a truck is driven only 70,000 kilometers annually, the operating costs increases to $0.134 per kilometer. Required: In the space alotted below answer the following questions a)    Using the high-low method, estimate the variable and fixed cost elements of...
Answer the following​ question(s) using the information below. Fresno Home Oil Services wants to determine a...
Answer the following​ question(s) using the information below. Fresno Home Oil Services wants to determine a fuel surcharge to add to its​ customers' bills based on the number of miles driven to each area. It wants to separate the fixed and variable portion of the​ truck's operating costs so it has a better idea of how distance affects these costs. Fresno Home Oil Services has the following data available. Month Miles driven Total operating costs January ​15,900 ​$9,000 February ​17,300...
Urban Elite Cosmetics has used a traditional cost accounting system to apply quality-control costs uniformly to...
Urban Elite Cosmetics has used a traditional cost accounting system to apply quality-control costs uniformly to all products at a rate of 18 percent of direct-labor cost. Monthly direct-labor cost for Satin Sheen makeup is $111,000. In an attempt to more equitably distribute quality-control costs, management is considering activity-based costing. The monthly data shown in the following chart have been gathered for Satin Sheen makeup. Activity Cost Pool Cost Driver Pool Rates Quantity of Driver for Satin Sheen Incoming material...