Question

In: Accounting

High-Low Method Luisa Crimini has been operating a beauty shop in a college town for the...

  1. High-Low Method

    Luisa Crimini has been operating a beauty shop in a college town for the past 10 years. Recently, Luisa rented space next to her shop and opened a tanning salon. She anticipated that the costs for the tanning service would primarily be fixed, but found that tanning salon costs increased with the number of appointments. Costs for this service over the past 8 months are as follows:

    Tanning
    Month Appointments Total Cost
    January 800 $1,758
    February 2,100 $2,150
    March 3,200 $2,790
    April 2,500 $2,500
    May 1,600 $1,800
    June 2,200 $2,255
    July 2,150 $2,300
    August 3,000 $2,640

    Required:

    1. Which month represents the high point? The low point?

    High point
    Low point

    In your calculations, round per unit costs to the nearest cent.

    2. Using the high-low method, compute the variable rate for tanning. Compute the fixed cost per month. Round the variable rate per tanning appointment to the nearest cent and use it in your further calculations. Round the fixed cost per month to the nearest dollar and use it in your further calculations.

    Variable rate for tanning $ per tanning appointment
    Fixed cost per month $

    3. Using the variable rate and fixed cost, what is the cost formula for tanning services?

    4. Calculate the total predicted cost of tanning services for September for 2,500 appointments using the formula found in Requirement 3. Of that total cost, how much is the total fixed cost for September? How much is the total predicted variable cost for September? If required, round the final answers to the nearest dollar.

    Total predicted cost for September $
    Total fixed cost for September $
    Total predicted variable cost for September $

    5. Which of the following statements is correct when luisa uses the high-low method to estimate the costs?

Solutions

Expert Solution

high low method uses the cost at highest activity and lowest activity to separate fixed & variable cost from mixed costs.

1.High point = March because it have highest tanning appointments

low point = January because it have lowest tanning appointments

2.

Cost Units
High $2,790 3200
Low $1758 800
Changes 1032 [$2790-1758] 2,400 [3200-800]

variable cost per appointment = change in cost/ change in units

=$1032/2400

=$0.43 per tanning apt

Total cost = fixed cost+variable cost

$2,790 = fixed cost +$0.43*3200

$2,790= fixed cost+1,376

fixed cost = $1,414

calculations.

Variable rate for tanning $0.43 per tanning appointment
Fixed cost per month $1414

3.cost fromual

y = a+bX

y = total cost

a= fixed cost

b= variable cost per tanning appointment

X= number of appointments

Y=$1,414+ $0.43X

Total tanning service cost = $1,414 + ($0.43*Number of appointments)

4.

X= 2,500

Y = $1,414 +$0.43*2,500

=$1,414+$1,075

=$2,489

Total predicted cost for September $2,489
Total fixed cost for September $1,414 (it is fixed and remain same irrespective of number of appointments]
Total predicted variable cost for September $1,075

Please upvote if you find this helpful.Incase of query please comment.


Related Solutions

High-Low Method Luisa Crimini has been operating a beauty shop in a college town for the...
High-Low Method Luisa Crimini has been operating a beauty shop in a college town for the past 10 years. Recently, Luisa rented space next to her shop and opened a tanning salon. She anticipated that the costs for the tanning service would primarily be fixed, but found that tanning salon costs increased with the number of appointments. Costs for this service over the past 8 months are as follows: Month Tanning Appointments Total Cost January 1,600 $1,754 February 2,000 2,140...
High-Low Method Luisa Crimini has been operating a beauty shop in a college town for the...
High-Low Method Luisa Crimini has been operating a beauty shop in a college town for the past 10 years. Recently, Luisa rented space next to her shop and opened a tanning salon. She anticipated that the costs for the tanning service would primarily be fixed, but found that tanning salon costs increased with the number of appointments. Costs for this service over the past 8 months are as follows: Tanning Month Appointments Total Cost January 600 $1,750 February 2,000 $2,130...
High-Low Method Luisa Crimini has been operating a beauty shop in a college town for the...
High-Low Method Luisa Crimini has been operating a beauty shop in a college town for the past 10 years. Recently, Luisa rented space next to her shop and opened a tanning salon. She anticipated that the costs for the tanning service would primarily be fixed, but found that tanning salon costs increased with the number of appointments. Costs for this service over the past 8 months are as follows: Tanning Month Appointments Total Cost January 800 $1,748 February 2,100 $2,110...
Luisa Crimini has been operating a beauty shop in a university town for the past 10...
Luisa Crimini has been operating a beauty shop in a university town for the past 10 years. Recently, Luisa rented space next to her shop and opened a spray-tanning salon. She anticipated that the costs for the spray-tanning service would primarily be fixed but found that spray-tanning salon costs increased with the number of appointments. Costs for this service over the past eight months are as follows: Spray-Tanning Appointments Total Cost January 1,600               $ 1,754 February 2,000              2,140 March 3,500...
High-low method Ziegler Inc. has decided to use the high-low method to estimate the total cost...
High-low method Ziegler Inc. has decided to use the high-low method to estimate the total cost and the fixed and variable cost components of the total cost. The data for various levels of production are as follows: Units Produced Total Costs 104,500 $30,703,250 119,500 33,380,750 136,500 36,415,250 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Determine the variable cost per unit and...
1. High-Low Method for a Service Company Boston Railroad decided to use the high-low method and...
1. High-Low Method for a Service Company Boston Railroad decided to use the high-low method and operating data from the past six months to estimate the fixed and variable components of transportation costs. The activity base used by Boston Railroad is a measure of railroad operating activity, termed “gross-ton miles,” which is the total number of tons multiplied by the miles moved. Transportation Costs Gross-Ton Miles January $854,100 325,000 February 952,200 363,000 March 673,000 235,000 April 913,000 351,000 May 765,700...
1. High-Low Method for a Service Company Boston Railroad decided to use the high-low method and...
1. High-Low Method for a Service Company Boston Railroad decided to use the high-low method and operating data from the past six months to estimate the fixed and variable components of transportation costs. The activity base used by Boston Railroad is a measure of railroad operating activity, termed “gross-ton miles,” which is the total number of tons multiplied by the miles moved. Transportation Costs Gross-Ton Miles January $929,600 247,000 February 1,036,400 276,000 March 732,500 179,000 April 993,700 268,000 May 833,400...
Question One High-Low Method, High—Low Method, Cost Formulas (LO 3) During the past year, the high...
Question One High-Low Method, High—Low Method, Cost Formulas (LO 3) During the past year, the high and low use of three different resources for Wilson Trucking occurred in July and April. The resources are truck depreciation, fuel, and truck maintenance. The number of kilometres travelled is the driver. The total costs of the three resources and the related number of truck kilometres are as follows: Resource                              Truck Kilometres      Total Cost ($) Truck depreciation: High                                                   46,000,000   2,800,000 Low                                                    32,400,000   2,800,000 Fuel:...
35) The following data has been assembled for John Company. Use the high-low method. Month                   Cost        &nb
35) The following data has been assembled for John Company. Use the high-low method. Month                   Cost               Hours January             $24,400                2,000 February            $39,000                2,200 March               $35,280                2,750 April                 $36,400                3,500 May                  $40,000                4,000 The expected total cost at an operating level of 1,900 hours is ________. A) $23,180 B) $23,620 C) $24,000 D) $24,400
Continental Railroad decided to use the high-low method and operating data from the past six months...
Continental Railroad decided to use the high-low method and operating data from the past six months to estimate the fixed and variable components of transportation costs. The activity base used by Continental Railroad is a measure of railroad operating activity, termed "gross-ton miles," which is the total number of tons multiplied by the miles moved. Transportation Costs Gross-Ton Miles January $854,900 228,000 February 953,100 255,000 March 673,600 165,000 April 913,800 247,000 May 766,400 198,000 June 982,600 268,000 Determine the variable...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT