Variable Costing Income StatementAc€??Service Company
Mid-Atlantic Railroad Company transports commodities among three routes (city-pairs): Boston/Philadelphia, Philadelphia/Buffalo, and Buffalo/Boston. Significant costs, their cost behavior, and activity rates for May 2014, are as follows: Cost Amount Cost Behavior
Activity Rate Labor costs for loading and unloading railcars $142,330 Variable $43.00 per railcar Fuel costs 385,280 Variable
11.20 per train mile Train crew labor costs 264,880 Variable 7.70 per train mile Switch yard labor cost 97,645 Variable 29.50 per railcar Track and equipment depreciation 186,900 Fixed Maintenance 124,600 Fixed
Operating statistics from the management information system reveal the following for May: Boston/Philadelphia Philadelphia/Buffalo Buffalo/Boston Total Number of Train miles 12,080 9,520 12,800 34,400 Number of railcars 500 1,700 1,110 3,310 Revenue per railcar $603 $256 $551
Question: Prepare a contribution margin by route report for Mid-Atlantic Railroad Company for the month of May. Calculate the contribution margin ratio, rounded to one decimal place (Answer needs to be broken out like the table below)