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

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

The following information relates to XYZ manufacturing for the first quarter of 2021: Fixed Cost MVR 50,000 Total Cost MVR 80,000 Total Revenues MVR 120,000 Number of units produced and sold during the period is 10000 units. Calculate: a) Break-even point in units b) Margin of safety in units and value
Western Trucking operates a fleet of delivery trucks. The fixed expenses to operate the fleet are $70,557 in March and rose to $90,644 in April. It costs Western Trucking $0.61 per mile in variable costs. In March, the delivery trucks were driven a total of 81,549 miles, and in April, they were driven a total of 96,989 miles. Using this information, answer the following: What were the total costs to operate the fleet in March? Round to the nearest whole dollar, no decimals.
Required information [The following information applies to the questions displayed below.] Aces Incorporated, a manufacturer of tennis rackets, began operations this year. The company produced 6,850 rackets and sold 5,330. Each racket was sold at a price of $90. Fixed overhead costs are $89,050 per year, and fixed selling and administrative costs are $67,000 per year. The company also reports the following per unit variable costs for the year. Direct materials Direct labor Variable overhead Variable selling and administrative expenses Prepare an income statement under variable costing. ACES INCORPORATED Income Statement (Variable Costing) Sales Less: Variable expenses Variable cost of goods sold Vanable selling and administrative expenses Contribution margin Fixed overhead Fixed selling and administrative expenses 333 X x X > $ 89,050✔ 67,000 $479,700 335,790 $12 8 5 2 156,050 Income $ 179,740 "Red text indicates no response was expected in a cell or a formula-based calculation is…
Answer
Western Trucking operates a fleet of delivery trucks. The fixed expenses to operate the fleet are $79,900 in March and rose to $93,120 in April. It costs Western Trucking $0.15 per mile in variable costs. In March, the delivery trucks were driven a total of 85,000 miles, and in April, they were driven a total of 96,000 miles.
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,776,000 560,000 February 2,700,000 1,000,000 March 1,650,000 500,000 April 1,860,000 600,000 May 1,440,000 400,000 June 1,566,000 460,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
Western Trucking operates a fleet of delivery trucks. The fixed expenses to operate the fleet are $80,910 in March and rose to $93,120 in April. It costs Western Trucking $0.14 per mile in variable costs. In March, the delivery trucks were driven a total of 87,000 miles, and in April, they were driven a total of 97,000 miles. Using this information, answer the following: A. What were the total costs to operate the fleet in March and April, respectively? March April Total cost $fill in the blank 1 $fill in the blank 2 B. What were the cost per mile to operate the fleet in March and April, respectively? If required, round your answers to nearest cent. March April Cost per mile $fill in the blank 3 $fill in the blank 4
Give me correct answer and explanation.s
8) Paine Company wishes to determine the fixed portion of its electrical costs (a mixed cost). Management believes that the variable portion of the electrical costs is driven by machine-hours. Information for the previous three months follows: January February March Machine-hours Electrical cost 33,000 31,000 34,000 A) $283. B) $375. (C) $327. D) $408. $600 $585 $610 Using the high-low method, the fixed portion of the company's electrical costs would be estimated to be closest to:
Whipple Company has sales revenue of $585,000. Cost of goods sold before adjustment is $335,000. The company uses machine hours to allocate manufacturing overhead and estimated 10,450 machine hours would be used during the year. For the year, manufacturing overhead was under-allocated by $13,400. The company's actual manufacturing overhead is $91,000. What is the actual gross profit? Select one: a. $250,000 b. $159,000 c. $236,600 d. $104,400 e. $263,400
(J)
Pacific Inc. has provided the following data for the latest quarter of the most recent year: Sales $300,000 Fixed manufacturing overhead 55,000 Direct labour 72,500 Fixed selling expense 46,250 Variable manufacturing overhead 41,000 Variable administrative expense 48,000 Direct materials 51,500 Fixed administrative expense 44,500 Variable selling expense 49,750 Assume that direct labour is a variable cost and that there was no beginning or ending inventories.The total contribution margin of Pacific for the latest quarter was? Multiple Choice $87,000. $176,000. $37,250. $211,000.