Question

In: Accounting

Exercise 6A-3 Cost Behavior; High-Low Method [LO6-10] Hoi Chong Transport, Ltd., operates a fleet of delivery...

Exercise 6A-3 Cost Behavior; High-Low Method [LO6-10]

Hoi Chong Transport, Ltd., operates a fleet of delivery trucks in Singapore. The company has determined that if a truck is driven 96,000 kilometers during a year, the average operating cost is 10.3 cents per kilometer. If a truck is driven only 64,000 kilometers during a year, the average operating cost increases to 11.5 cents per kilometer.

Required:

1. Using the high-low method, estimate the variable operating cost per kilometer and the annual fixed operating cost associated with the fleet of trucks.

2. Express the variable and fixed costs in the form Y = a + bX.

3. If a truck were driven 80,000 kilometers during a year, what total operating cost would you expect to be incurred?

Solutions

Expert Solution

  • High Low Working

Note:
units = Kilometers

Units

Cost

High Level

                          96,000

$                988,800.00

Low Level

                          64,000

$                736,000.00

Difference

                          32,000

$                252,800.00

A

Difference in Cost

$                252,800.00

B

Difference in units

                            32,000

C = A/B

Variable cost per unit

$                             7.90

Working

High Level

Low Level

A

Total Cost

$              988,800.00

$                736,000.00

B

Total Units

96000

64000

C

Variable cost per unit

$                           7.90

$                             7.90

D = B x C

Total Variable cost

$              758,400.00

$                505,600.00

E = A - D

Total Fixed Cost

$              230,400.00

$                230,400.00

  • Requirement 1
    Variable cost = $ 7.90 per kilometres
    Fixed Cost = $ 230,400
  • Requirement 2
    Y = a + bX
    Y(total cost) = $ 230,400 + $7.90X
  • Requirement 3

Y(total cost) = $ 230,400 + $7.90X
Total Operating cost = 230400 + (7.90 x 80000)
= 230400 + 632000
= $ 862,400 = Answer


Related Solutions

Hoi Chong Transport, Ltd. operates a fleet of delivery trucks in Singapore. The company has determined...
Hoi Chong Transport, Ltd. operates a fleet of delivery trucks in Singapore. The company has determined that if a truck is driven 150,000 kilometres during a year, the average operating cost is 13.1 cents per kilometre. If a truck is driven only 75,000 kilometres during a year, the average operating cost increases to 15.0 cents per kilometre. (The Singapore dollar is the currency used in Singapore.) Required: 1. Using the high-low method, estimate the variable and fixed cost elements of...
Hoi Chong Transport, Ltd., operates a fleet of delivery trucks in Singapore. The company has determined...
Hoi Chong Transport, Ltd., operates a fleet of delivery trucks in Singapore. The company has determined that if a truck is driven 108,000 kilometers during a year, the average operating cost is 11.9 cents per kilometer. If a truck is driven only 72,000 kilometers during a year, the average operating cost increases to 13.7 cents per kilometer. Required: 1. Using the high-low method, estimate the variable operating cost per kilometer and the annual fixed operating cost associated with the fleet...
Hoi Chong Transport, Ltd., operates a fleet of delivery trucks in Singapore. The company has determined...
Hoi Chong Transport, Ltd., operates a fleet of delivery trucks in Singapore. The company has determined that if a truck is driven 105,000 kilometers during a year, the average operating cost is 11.4 cents per kilometer. If a truck is driven only 70,000 kilometers during a year, the average operating cost increases to 13.4 cents per kilometer. Required: 1. Using the high-low method, estimate the variable and fixed cost elements of the annual cost of the truck operation. (Do not...
Hoi Chong Transport, Ltd., operates a fleet of delivery trucks in Singapore. The company has determined...
Hoi Chong Transport, Ltd., operates a fleet of delivery trucks in Singapore. The company has determined that if a truck is driven 102,000 kilometers during a year, the average operating cost is 11.3 cents per kilometer. If a truck is driven only 68,000 kilometers during a year, the average operating cost increases to 12.9 cents per kilometer. Required: 1. Using the high-low method, estimate the variable operating cost per kilometer and the annual fixed operating cost associated with the fleet...
Please show me step by step. Exercise 6A-1 High-Low Method [LO6-10] The Cheyenne Hotel in Big...
Please show me step by step. Exercise 6A-1 High-Low Method [LO6-10] The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the hotel and the number of occupancy-days over the last year. An occupancy-day represents a room rented for one day. The hotel's business is highly seasonal, with peaks occurring during the ski season and in the summer. Month Occupancy-Days Electrical Costs January 1,736 $ 4,127 February 1,904 $ 4,207 March 2,356 $ 5,083...
Chapter 6 Homework Problem 6A-8 High-Low Method; Predicting Cost [LO6-10] Nova Company’s total overhead cost at...
Chapter 6 Homework Problem 6A-8 High-Low Method; Predicting Cost [LO6-10] Nova Company’s total overhead cost at various levels of activity are presented below: Month Machine- Hours Total Overhead Cost April 46,000 $ 168,260 May 36,000 $ 144,660 June 56,000 $ 191,860 July 66,000 $ 215,460 Assume that the total overhead cost above consists of utilities, supervisory salaries, and maintenance. The breakdown of these costs at the 36,000 machine-hour level of activity is: Utilities (variable) $ 46,800 Supervisory salaries (fixed) 45,000...
Integrative Exercise Cost Behavior and Cost-Volume-Profit Analysis for Many Glacier Hotel Using the High-Low Method to...
Integrative Exercise Cost Behavior and Cost-Volume-Profit Analysis for Many Glacier Hotel Using the High-Low Method to Estimate Variable and Fixed Costs Located on Swiftcurrent Lake in Glacier National Park, Many Glacier Hotel was built in 1915 by the Great Northern Railway. In an effort to supplement its lodging revenue, the hotel decided in 20X1 to begin manufacturing and selling small wooden canoes decorated with symbols hand painted by Native Americans living near the park. Due to the great success of...
Problem 5A-7 Cost Behavior; High-Low Method; Contribution Format Income Statement [LO5-10] Morrisey & Brown, Ltd., of...
Problem 5A-7 Cost Behavior; High-Low Method; Contribution Format Income Statement [LO5-10] Morrisey & Brown, Ltd., of Sydney is a merchandising company that is the sole distributor of a product that is increasing in popularity among Australian consumers. The company’s income statements for the three most recent months follow: Morrisey & Brown, Ltd. Income Statements For the Three Months Ended September 30 July August September Sales in units 5,500 6,000 6,500 Sales $ 577,500 $ 630,000 $ 682,500 Cost of goods...
Problem 5A-7 Cost Behavior; High-Low Method; Contribution Format Income Statement [LO5-10] Morrisey & Brown, Ltd., of...
Problem 5A-7 Cost Behavior; High-Low Method; Contribution Format Income Statement [LO5-10] Morrisey & Brown, Ltd., of Sydney is a merchandising company that is the sole distributor of a product that is increasing in popularity among Australian consumers. The company’s income statements for the three most recent months follow: Morrisey & Brown, Ltd. Income Statements For the Three Months Ended September 30 July August September Sales in units 6,000 6,500 7,000 Sales $ 570,000 $ 617,500 $ 665,000 Cost of goods...
Problem 5A-7 Cost Behavior; High-Low Method; Contribution Format Income Statement [LO5-10] Morrisey & Brown, Ltd., of...
Problem 5A-7 Cost Behavior; High-Low Method; Contribution Format Income Statement [LO5-10] Morrisey & Brown, Ltd., of Sydney is a merchandising company that is the sole distributor of a product that is increasing in popularity among Australian consumers. The company’s income statements for the three most recent months follow: Morrisey & Brown, Ltd. Income Statements For the Three Months Ended September 30 July August September Sales in units 8,500 9,000 9,500 Sales $ 850,000 $ 900,000 $ 950,000 Cost of goods...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT