Question

Variable Costing Income Statement for a Service Company East Coast Railroad Company transports commodities among three...

Variable Costing Income Statement for a Service Company

East Coast Railroad Company transports commodities among three routes (city-pairs): Atlanta/Baltimore, Baltimore/Pittsburgh, and Pittsburgh/Atlanta. Significant costs, their cost behavior, and activity rates for April are as follows:

Cost Amount Cost Behavior Activity Rate
Labor costs for loading and unloading railcars $186,930 Variable $46.50 per railcar
Fuel costs 399,040 Variable 11.60 per train-mile
Train crew labor costs 233,920 Variable 6.80 per train-mile
Switchyard labor costs 123,414 Variable 30.70 per railcar
Track and equipment depreciation 198,100 Fixed
Maintenance 132,100 Fixed

Operating statistics from the management information system reveal the following for April:

Atlanta/
Baltimore
Baltimore/
Pittsburgh
Pittsburgh/
Atlanta
Total
Number of train-miles 12,080 9,520 12,800 34,400
Number of railcars 630 2,120 1,270 4,020
Revenue per railcar $517 $248 $401

a. Prepare a contribution margin by route report for East Coast Railroad Company for the month of April. Calculate the contribution margin ratio, rounded to one decimal place.

East Coast Railroad Company
Contribution Margin by Route
For the Month Ended April 30
Atlanta/Baltimore Baltimore/Pittsburgh Pittsburgh/Atlanta Total
Revenues $ $ $ $
Variable costs:
Labor costs for loading and unloading railcars $ $ $ $
Fuel costs
Train crew labor costs
Switchyard labor costs
Total variable costs $ $ $ $
Contribution margin $ $ $ $
Contribution margin ratio % % % %

Homework Answers

Answer #1
East Coast Railroad Company
Contribution Margin by Route
For the Month Ended April 30
Atlanta/Baltimore Baltimore/Pittsburgh Pittsburgh/Atlanta Total
Revenues 325710 525760 509270 1360740
Variable costs:
Labor costs for loading and unloading railcars 29295 98580 59055 186930
Fuel costs 140128 110432 148480 399040
Train crew labor costs 82144 64736 87040 233920
Switchyard labor costs 19341 65084 38989 123414
Total variable costs 270908 338832 333564 943304
Contribution margin 54802 186928 175706 417436
Contribution margin ratio 16.8% 35.6% 34.5% 30.7%
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
High-Low Method for a Service Company Continental Railroad decided to use the high-low method and operating...
High-Low Method for a Service Company 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 $946,700 261,000 February 1,055,600 292,000 March 746,000 189,000 April 1,012,000 282,000 May 848,800 227,000...
The variable costing income statement for Jackson Company for last year is as follows: Sales (5,000...
The variable costing income statement for Jackson Company for last year is as follows: Sales (5,000 units) P 100,000 Variable expenses: Cost of goods sold P30,000 Selling (10% of sales) 10,000 (40,000) Contribution margin P60,000 Fixed expenses Manufacturing overhead P24,000 Administrative 14,400 (38,400) Operating income P21,600 Selected data for last year concerning the operations of the company are as follows: Beginning inventory - 0 unit Units produced - 8,000 units Manufacturing costs: Direct labor - P3.00 per unit Direct materials...
Income Statements under Absorption and Variable Costing Patagucci Inc. manufactures and sells athletic equipment. The company...
Income Statements under Absorption and Variable Costing Patagucci Inc. manufactures and sells athletic equipment. The company began operations on August 1, 2016, and operated at 100% of capacity (38,500 units) during the first month, creating an ending inventory of 3,500 units. During September, the company produced 35,000 garments but sold 38,500 units at $80 per unit. The September manufacturing costs and selling and administrative expenses were as follows: Number of Units Unit Cost Total Cost Manufacturing costs in September beginning...
Exercise 6-12 (Algo) Variable Costing Income Statement; Reconciliation [LO6-2, LO6-3] Whitman Company has just completed its...
Exercise 6-12 (Algo) Variable Costing Income Statement; Reconciliation [LO6-2, LO6-3] Whitman Company has just completed its first year of operations. The company’s absorption costing income statement for the year follows: Whitman Company Income Statement Sales (42,000 units × $43.10 per unit) $ 1,810,200 Cost of goods sold (42,000 units × $26 per unit) 1,092,000 Gross margin 718,200 Selling and administrative expenses 483,000 Net operating income $ 235,200 The company’s selling and administrative expenses consist of $315,000 per year in fixed...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how the firms resources incompetencies support the given pressures regarding costs and local responsiveness. Describe entry modes have they usually used, and whether they are appropriate for the given strategy. Any key issues in their global strategy? casestudy: Atlanta, June 17, 2014. Sea of Delta employees and their families swarmed between food trucks, amusement park booths, and entertainment venues that were scattered throughout what would...