Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

11. 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

11. 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

The management of East Coast Railroad Company improved the profitability of the Atlanta/Baltimore route in May by reducing the price of a railcar from $600 to $500. This price reduction increased the demand for rail services. Thus, the number of railcars increased by 275 railcars to a total of 700 railcars. This was accomplished by increasing the size of each train but not the number of trains. Thus, the number of train-miles was unchanged. All the activity rates remained unchanged.

Required:
a. Prepare a contribution margin report for the Atlanta/Baltimore route for May. Calculate the contribution margin ratio in percentage terms to one decimal place.*
b. Prepare a contribution margin analysis to evaluate managements actions in May. Assume that the May planned quantity, price, and unit cost was the same as April. If an amount is zero, enter "0".*
*Refer to the lists of Labels and Amount Descriptions for the exact wording of the answer choices for text entries. Be sure to complete the statement heading. A colon (:) will automatically appear if it is required. For those boxes in which you must enter subtracted or negative numbers use a minus sign.

Labels
Effect of changes in sales
Effect of changes in fixed costs
Effect of changes in variable cost of goods sold
For the Month Ended May 31
May 31
Variable costs
Amount Descriptions
Actual contribution margin
Contribution margin
Contribution margin ratio
Fuel costs
Labor costs for loading and unloading railcars
Planned contribution margin
Revenue
Sales quantity factor
Switchyard labor costs
Total effect of changes in fixed costs
Total effect of changes in sales
Total effect of changes in variable cost of goods sold
Total variable costs
Train crew labor costs
Unit cost factor
Unit price factor
Variable cost quantity factor

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting Creating Value in a Dynamic Business Environment

Authors: Ronald W. Hilton

11th edition

125956956X, 978-1259569562

More Books

Students also viewed these Accounting questions

Question

Two interviewers are accused of curb-stoning. What have they done?

Answered: 1 week ago