Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 Fuel costs 460,226 Variable $46.00 per railcar 12.40 per train-mile 7.20 per train-mile 31.00 per railcar Train crew labor costs 267,228 Variable 118,327 Variable Switchyard labor costs Track and equipment depreciation Maintenance 194,400 Fixed Fixed 129,600 $1,345,363 425 Operating statistics from the management information system reveal the following for April: Atlanta Baltimore/ Pittsburgh/ Total Baltimore Pittsburgh Atlanta Number of train-miles 12,835 10,200 14.080 37,115 Number of railcars 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. 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. East Coast Railroad Company Contribution Margin for Atlanta/Baltimore Route For the Month Ended May 31 Revenues Labor costs for loading and unloading railcars Fuel costs Train crew labor costs Switchyard labor costs Total variable costs Contribution margin Contribution margin ratio b. Prepare a contribution margin analysis to evaluate management's actions in May. Assume that the May planned quantity, price, and unit cost was the same as April. The planned contribution margin is given below. If an amount is zero, enter "O". East Coast Railroad Company Contribution Margin Analysis-Atlanta/Baltimore Route For the Month Ended May 31 Planned contribution margin $(29,291) Effect of change in sales: Sales quantity factor Unit price factor Total effect of change in sales Effect of changes in variable cost of goods sold: Variable cost quantity factor Unit cost factor 0 00 Total effect of changes in variable cost of goods sold Actual contribution margin
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started