Question

In: Accounting

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 283,000
June 981,700 382,000

Determine the variable cost per gross-ton mile and the fixed cost.

Variable cost (Round to two decimal places.) $ per gross-ton mile
Total fixed cost $

2.

Contribution Margin and Contribution Margin Ratio

For a recent year, Wicker Company-owned restaurants had the following sales and expenses (in millions):

Sales $26,100
Food and packaging $9,106
Payroll 6,600
Occupancy (rent, depreciation, etc.) 5,814
General, selling, and administrative expenses 3,800
$25,320
Income from operations $780

Assume that the variable costs consist of food and packaging, payroll, and 40% of the general, selling, and administrative expenses.

a. What is Wicker Company's contribution margin? Round to the nearest million. (Give answer in millions of dollars.)
$ million

b. What is Wicker Company's contribution margin ratio? Round to one decimal place.
%

c. How much would income from operations increase if same-store sales increased by $1,600 million for the coming year, with no change in the contribution margin ratio or fixed costs? Round your answer to the closest million.
$ million

3.

Sales Mix and Break-Even Sales

Dragon Sports Inc. manufactures and sells two products, baseball bats and baseball gloves. The fixed costs are $522,000, and the sales mix is 30% bats and 70% gloves. The unit selling price and the unit variable cost for each product are as follows:

Products Unit Selling Price Unit Variable Cost
Bats $60 $50
Gloves 150 90

a. Compute the break-even sales (units) for both products combined.
units

b. How many units of each product, baseball bats and baseball gloves, would be sold at break-even point?

Baseball bats units
Baseball gloves units

Solutions

Expert Solution

1
Transportation Costs Gross-Ton Miles
High level 981700 382000
Low level 673000 235000
Change 308700 147000
Variable cost 2.10 =308700/147000
Total fixed cost 179500 =981700-(382000*2.10)
2
a
Sales 26100
Less: Variable costs
Food and packaging 9106
Payroll 6600
General, selling, and administrative expenses 1520 =3800*40%
Total Variable costs 17226
Contribution margin 8874 million
b
Contribution margin 8874
Divide by sales 26100
Contribution margin ratio 34.0%
c
Income from operations increase 544 million =1600*34%
3
a
Fixed costs 522000
/Weighted average unit contribution margin 45 =(60-50)*30%+(150-90)*70%
Break-even sales (units) 11600
b
Baseball bats 3480 =11600*30%
Baseball gloves 8120 =11600*70%

Related Solutions

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...
Please answer both. High-Low Method for a Service Company Boston Railroad decided to use the high-low...
Please answer both. 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 $1,008,400 298,000 February 1,124,300 333,000 March 794,600 216,000 April 1,078,000 323,000...
2.) Boston Railroad decided to use the high-low method and operating data from the past six...
2.) 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 $896,400 265,000 February 999,400 296,000 March 706,300 192,000 April 958,200 287,000 May 803,600 231,000 June 1,030,300 312,000 Determine the...
Boston Railroad decided to use the high-low method and operating data from the past six months...
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 $530,900 224,000 February 591,900 250,000 March 418,300 162,000 April 567,500 242,000 May 476,000 195,000 June 610,200 263,000 Determine the variable...
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...
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...
Shatner Inc. has decided to use the high-low method to estimate the total cost and the...
Shatner 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 5,945 $436,240 3,820 415,670 1,845 280,440 a. Determine the variable cost per unit and the total fixed cost. Variable cost: (Round to the nearest dollar.) $ per unit Total fixed cost: $ b. Based on part (a), estimate the total cost...
Ziegler Inc. has decided to use the high-low method to estimate the total cost and the...
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 1,260 $221,760 2,610 277,690 4,060 344,960 a. Determine the variable cost per unit and the total fixed cost. Variable cost: (Round to the nearest dollar.) $ per unit Total fixed cost: $ b. Based on part (a), estimate the total cost...
High-Low Method, Cost Formulas During the past year, the high and low use of three different...
High-Low Method, Cost Formulas During the past year, the high and low use of three different resources for Fly High Airlines occurred in July and April. The resources are airplane depreciation, fuel, and airplane maintenance. The number of airplane flight hours is the driver. The total costs of the three resources and the related number of airplane flight hours are as follows: Resource Airplane Flight Hours Total Cost Airplane depreciation: High 44,000 $ 18,400,000 Low 28,000 $ 18,400,000 Fuel: High...
High-Low Method, Cost Formulas During the past year, the high and low use of three different...
High-Low Method, Cost Formulas During the past year, the high and low use of three different resources for Fly High Airlines occurred in July and April. The resources are airplane depreciation, fuel, and airplane maintenance. The number of airplane flight hours is the driver. The total costs of the three resources and the related number of airplane flight hours are as follows: Resource Airplane Flight Hours Total Cost Airplane depreciation: High 44,000 $ 18,000,000 Low 28,000 $ 18,000,000 Fuel: High...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT