Chapter 20 Excel Online ProblemseBookHigh-low method for a service companyShow Me HowOffice 365Sierra Railroad Inc. 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 baseused by Sierra Railroad is "gross-ton miles," which is the total number of tons multiplied by the miles moved.JanuaryFebruaryMarchAprilMayJuneTransportation CostsGross-Ton Miles$732,000217,000816,200242,000576,800157,000782,500235,000656,300841,400189,000255,000This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.Open spreadsheetDetermine the variable cost per gross-ton mile and the total fixed cost.Variable cost (If required, round to two decimal places.) $Total fixed cost $X per gross-ton mile

Lets understand the basics.In high low mehod, total costs are seprated into variable costs and fixed…

Sierra Railroad Inc. decided to use the high-low method and operating data from the past six months to estimate the fixed and variable compor used by Sierra Railroad is "gross-ton miles," which is the total number of tons multiplied by the miles moved. January Transportation Costs $732,000 Gross-Ton Miles 217,000 February 816,200 242,000 March 576,800 157,000 April 782,500 235,000 May June 656,300 841,400 189,000 255,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answ Open spreadsheet

Sierra Railroad Inc. decided to use the high-low method and operating data from the past six months to estimate the fixed and variable compor used by Sierra Railroad is "gross-ton miles," which is the total number of tons multiplied by the miles moved. January Transportation Costs $732,000 Gross-Ton Miles 217,000 February 816,200 242,000 March 576,800 157,000 April 782,500 235,000 May June 656,300 841,400 189,000 255,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answ Open spreadsheet

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter6: Cost-volume-profit Analysis

Section: Chapter Questions

Problem 8E

See similar textbooks

Similar questions

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. January February March April May June Transportation Costs Gross-Ton Miles $536,200 225,000 597,800 252,000 422,500 163,000 573,200 244,000 480,700 196,000 616,300 265,000 Determine the variable cost per gross-ton mile and the total fixed cost. Variable cost (Round to two decimal places.) Total fixed cost pe
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 Gross-Ton Costs Miles January $1,022,500 340,000 February 1,140,000 380,000 March 805,700 246,000 April 1,093,000 368,000 May 916,700 296,000 June 1,175,300 400,000 Determine the variable cost per gross-ton mile and the total fixed cost. Variable cost (Round to two decimal $ per gross-ton places.) mile Total fixed cost
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 $831,600 369000 February 927,200 412000 March 655,300 267000 April 889,000 399,000 May 745,600 321,000 June 955,900 434,000 Determine the variable cost per gross-ton mile and the total fixed cost. Variable cost (Round to two decimal places.) $____ per gross-ton mile Total fixed cost $____
High-Low Method for a Service Company Boston 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 Boston 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 $669,600 243,000 February 746,500 272,000 March 527,600 176,000 April 715,700 263,000 May 600,300 212,000 June 769,600 286,000 Determine the variable cost per gross-ton mile and the fixed cost. Variable cost (Round to two decimal places.) $fill in the blank 1 per gross-ton mile Total fixed cost $fill in the blank 2
High-Low Method for Service Company Miss River 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 Miss River 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 $1,346,500 347,000 February 1,501,300 388,000 March 1,061,000 251,000 April 1,439,400 375,000 May 1,207,200 302,000 June 1,547,700 408,000 Determine the variable cost per gross-ton mile and the fixed cost. Round variable cost per unit to the nearest cent. Variable cost $fill in the blank 1 per gross-ton mile Fixed cost $fill in the blank 2
High-Low Method for a Service Company Boston 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 Boston 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 $999,000 347,000 February 1,113,900 388,000 March 787,200 251,000 April 1,067,900 375,000 May 895,700 302,000 June 1,148,300 408,000 Determine the variable cost per gross-ton mile and the total fixed cost. Variable cost (Round to two decimal places.) $fill in the blank 1 per gross-ton mile Total fixed cost $fill in the blank 2
High-low method for a service company Sierra Railroad Inc. 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 Sierra Railroad is "gross-ton miles," which is the total number of tons multiplied by the miles moved. January Transportation Costs $1,262,700 Gross-Ton Miles 360,000 February 1,407,900 403,000 March 995,000 261,000 April 1,349,800 390,000 May 1,132,100 314,000 June 1,451,400 424,000 Determine the variable cost per gross-ton mile and the total fixed cost. Variable cost (If required, round to two decimal places.) S Total fixed cost $ per gross-ton mile
High-Low Method for a Service Company Boston 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 Boston 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 $1,324,700 294,000 February 1,476,900 329,000 March 1,043,800 213,000 April 1,416,000 318,000 May 1,187,600 256,000 June 1,522,600 346,000 Determine the variable cost per gross-ton mile and the fixed cost. Variable cost (Round to two decimal places.) %$4 per gross-ton mile Total fixed cost Check My Work 4 more Check My Work uses remaining. Previous Next All work saved. Email Instructor Save and Exit Submit Assignment for Gra %24 %24
High-low method for a service company Sierra Railroad Inc. 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 Sierra Railroad is "gross-ton miles," which is the total number of tons multiplied by the miles moved. Transportation Costs $2,900,000 2,875,000 3,065,000 3,225,000 Gross-Ton Miles 3,000,000 2,500,000 6,300,000 9,500,000 12,750,000 10,000,000 Determine the variable cost per gross-ton mile and the total fixed cost. Variable cost (If required, round to two decimal places.) $ Total fixed cost $ January February March April May June 3,387,500 3,250,000 per gross-ton mile
genow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSession Lo...<✰ ✰ O < January February March April May June High-Low Method for a Service Company Boston 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 Boston 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 $690,500 769,900 544,100 738,100 619,100 793,700 230,000 257,000 166,000 248,000 200,000 270,000 Determine the variable cost per gross-ton mile and the total fixed cost. Variable cost (If required, round to two decimal places.) Total fixed cost Check My Work $ $ 6 per gross-ton mile + Previous N Oct 26
Problem #3 In the rail transportation business, the critical activity measure for business activity is ton miles, that is, a measure of miles that tons of cargo have been transported. 3a) Assuming the following data for the Lehigh Valley Railroad Company, use the high-low method to determine variable cost per ton mile and fixed costs for the company. 3b) Express the specific total cost equation for the railroad mathematically. 3c) Calculate the RR's total costs for September, assuming ton miles of 525,000. Total Costs Month February Ton Miles ($000) 265,000 26,830 March 325,000 30,750 April 315,000 28,560 May 450,000 36,270 June 540,000 39,240 July 505,000 37,920 August 550,000 41,490
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 $24,500,000 3,000,000 February 22,375,000 2,500,000 March 29,000,000 6,300,000 April 34,800,000 9,500,000 May 40,312,500 12,750,000 June 35,500,000 10,000,000 Determine the variable cost per gross-ton mile and the total fixed cost. Variable cost (If required, round to two decimal places.) $fill in the blank 1 per gross-ton mile Total fixed cost $fill in the blank 2