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

Robin Inc. provides the following manufacturing costs for the Third quarter of the year in the table below. Manufacturing Costs for the Third Quarter Months Production in Units Total Costs July 3,800 $59,550 August 4,200 $62,450 September 5,500 $71,875 Using the high-low method, determine the variable costs per unit. (Round intermediate calculations and your final answer to two decimal places.) Group of answer choices $14.37 $13.07 $7.25 $15.67
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
Baraban Corporation has provided the following data for its most recent year of operation: Selling price per unit $ 47 Manufacturing costs: Variable manufacturing cost per unit produced: Direct materials $ 10 Direct labor $ 6 Variable manufacturing overhead $ 5 Fixed manufacturing overhead per year $ 130,000 Selling and administrative expenses: Variable selling and administrative expense per unit sold $ 5 Fixed selling and administrative expense per year $ 63,000 Units in beginning inventory 0 Units produced during the year 10,000 Units sold during the year 9,000 Units in ending inventory 1,000 The net operating income (loss) under absorption costing closest to: $9,000 ($4,000) $117,000 $72,000
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
Sunland Corp. has collected the following data concerning its maintenance costs for the past 6 months. Units Produced Total Cost July 18,060 $33,913 August 32,096 48,144 September 36,108 55,165 October 22,066 38,114 November 40,120 74,724 December 38,114 62,186 (A) Compute the variable cost per unit using the high-low method. (Round answer to 2 decimal places, e.g. 2.25.) Variable cost per unit $enter the variable cost per unit in dollars rounded to 2 decimal places (B) Compute the fixed cost elements using the high-low method. Fixed costs $enter the fixed costs in dollars
The manufacturing costs of Mocha Industries for three months of the year are as follows: Month Total Cost Production April $79,092 1,440 units May 80,136 2,020 units June 81,756 2,920 units a. Using the high-low method, determine the variable cost per unit. Round your answer to two decimal places.fill in the blank 1 of 1$ per unit b. Using the high-low method, determine the total fixed costs.
Robin Inc. shows the following manufacturing costs for the Third quarter of the year: Production Total in Units Costs July 3,800 $59,550 August 4,200 $62,450 September 5,500 $71,875 Using the high-low method, determine the total fixed costs. (Round intermediate calculations to two decimal places, and the final calculation to the nearest dollar.) $39,875 $27,550 $39,875 $32,000
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:
Wildhorse Corp. has collected the following data concerning its maintenance costs for the past 6 months. Total Cost Units Produced $47,149 19,420 July 51,792 34,528 August 59,345 38,844 September 48,150 23,738 October 80,385 43,160 November 66,898 41,002 December Compute the variable cost per unit using the high-low method. (Round answer to 2 decimal places, eg. 2.25.) Variable cost per unit $ Compute the fixed cost elements using the high-low method Fixed costs $ lhp 19 m ho K4 ins prt sc delet 6 7 backde
The manufacturing costs of Mocha Industries for three months of the year are as follows: Total Cost Production April $102,926 1,860 Units May 105,960 2,600 June 110,798 3,780 a. Using the high-low method, determine the variable cost per unit. Round your answer to two decimal places.$fill in the blank 1 per unit b. Using the high-low method, determine the total fixed costs.$fill in the blank 2
Princeton Manufacturing Company summarizes the following total cost data for the month of March. Princeton has a normal capacity per month of 25,000 units of product that sell for $40 each. For the foreseeable future, sales volume should equal normal capacity of production. Direct material $295,000 Direct labor 165,000 Variable overhead 85,000 Fixed overhead (Note 1) 140,000 Selling expense (Note 2) 80,000 Administrative expense (fixed) 56,000 $821,000 Notes:1. Beyond normal capacity, fixed overhead cost increases $6,350 for each 1,000 units or fraction thereof until a maximum capacity of 30,000 units is reached.2. Selling expenses are a 5% sales commission plus shipping costs of $1.20 per unit. a. Using the information available, prepare a formula to estimate Princeton's total cost at various production volumes up to normal capacity. b. Prove your answer in requirement (a) relative to the total cost figure for 25,000 units. c. Calculate the planned total…
The manufacturing costs of Calico Industries for three months of the year are provided below: Total Cost Production (units) April $112,700 275,900 May 91,900 163,500 June 108,700 247,900 Using the high-low method, the variable cost per unit and the total fixed costs are