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 $175,582 Variable $46.00 per railcar Fuel costs 460,226 Variable 12.40 per train-mile Train crew labor costs 267,228 Variable 7.20 per train-mile Switchyard labor costs 118,327 Variable 31.00 per railcar Track and equipment depreciation 194,400 Fixed Maintenance 129,600 Fixed $1,345,363 Operating statistics from the management information system reveal the following for April: Atlanta/Baltimore Baltimore/Pittsburgh Pittsburgh/Atlanta Total Number of train-miles 12,835 10,200 14,080 37,115 Number of railcars 425 2,160 1,232 3,817 Revenue per railcar $600 $275 $440 a. Prepare a contribution margin by route report for East Coast Railroad Company for the month of April. Compute the contribution margin ratio. Rounded to one decimal place. If required, use the minus sign to indicate a negative contribution margin. 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 % % % %
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 $175,582 Variable $46.00 per railcar Fuel costs 460,226 Variable 12.40 per train-mile Train crew labor costs 267,228 Variable 7.20 per train-mile Switchyard labor costs 118,327 Variable 31.00 per railcar Track and equipment depreciation 194,400 Fixed Maintenance 129,600 Fixed $1,345,363 Operating statistics from the management information system reveal the following for April: Atlanta/Baltimore Baltimore/Pittsburgh Pittsburgh/Atlanta Total Number of train-miles 12,835 10,200 14,080 37,115 Number of railcars 425 2,160 1,232 3,817 Revenue per railcar $600 $275 $440 a. Prepare a contribution margin by route report for East Coast Railroad Company for the month of April. Compute the contribution margin ratio. Rounded to one decimal place. If required, use the minus sign to indicate a negative contribution margin. 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 % % % %
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
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 | $175,582 | Variable | $46.00 | per railcar | ||
Fuel costs | 460,226 | Variable | 12.40 | per train-mile | ||
Train crew labor costs | 267,228 | Variable | 7.20 | per train-mile | ||
Switchyard labor costs | 118,327 | Variable | 31.00 | per railcar | ||
Track and equipment |
194,400 | Fixed | ||||
Maintenance | 129,600 | Fixed | ||||
$1,345,363 |
Operating statistics from the management information system reveal the following for April:
Atlanta/ Baltimore |
Baltimore/ Pittsburgh |
Pittsburgh/ Atlanta |
Total | |||||
Number of train-miles | 12,835 | 10,200 | 14,080 | 37,115 | ||||
Number of railcars | 425 | 2,160 | 1,232 | 3,817 | ||||
Revenue per railcar | $600 | $275 | $440 |
a. Prepare a contribution margin by route report for East Coast Railroad Company for the month of April. Compute the contribution margin ratio. Rounded to one decimal place. If required, use the minus sign to indicate a negative contribution margin.
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 | % | % | % | % |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education