Trailblazer Logistics accumulates the following data concerning a mixed cost, using miles as the activity level: Month Miles Driven Total Cost ($) January 6,400 12,800 February 5,900 12,200 March 7,100 13,400 April 6,800 13,000 Required: a. Compute the variable cost per mile using the high-low method. b. Compute the fixed cost element using the high-low method.

Trailblazer Logistics accumulates the following data concerning a mixed cost, using miles as the activity level: Month Miles Driven Total Cost ($) January 6,400 12,800 February 5,900 12,200 March 7,100 13,400 April 6,800 13,000 Required: a. Compute the variable cost per mile using the high-low method. b. Compute the fixed cost element using the high-low method.

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter3: Cost Behavior And Cost Forecasting

Section: Chapter Questions

Problem 61P: Method of Least Squares, Predicting Cost for Different Time Periods from the One Used to Develop a...

See similar textbooks

Similar questions

I want to answer this question
Cullumber Company accumulates the following data concerning a mixed cost, using miles as the activity level. MilesDriven TotalCost MilesDriven TotalCost January 8,005 $14,170 March 8,500 $14,790 February 7,500 13,490 April 8,200 14,485 (A) Compute the variable cost per mile using the high-low method. (Round answer to 2 decimal places, e.g. 2.25.) Variable cost per mile $Type your answer here (B) Compute the fixed cost elements using the high-low method. Fixed costs $Type your answer here
Provide answer this question
Dog
Bruno Company accumulates the following data concerning a mixed cost, using miles as the activity level. Miles Driven Total Cost January 8,015 February 7,510 $14,195 13,515 Miles Driven Total Cost March 8,500 $15,000 April 8,205 14,495 a. Compute the variable cost per mile using the high-low method. b. Compute the fixed cost elements using the high-low method.
get fast answer as per possibility..
Method of Least Squares, Predicting Cost for Different Time Periods from the One Used to Develop a Cost Formula Refer to the information for Farnsworth Company on the previous page. However, assume that Tracy has used the method of least squares on the receiving data and has gotten the following results: Required: 1. Using the results from the method of least squares, prepare a cost formula for the receiving activity. 2. Using the formula from Requirement 1, what is the predicted cost of receiving for a month in which 1,450 receiving orders are processed? (Note: Round your answer to the nearest dollar.) 3. Prepare a cost formula for the receiving activity for a quarter. Based on this formula, what is the predicted cost of receiving for a quarter in which 4,650 receiving orders are anticipated? Prepare a cost formula for the receiving activity for a year. Based on this formula, what is the predicted cost of receiving for a year in which 18,000 receiving orders are anticipated?
Using the data in P4-2 and Microsoft Excel: 1. Separate the variable and fixed elements. 2. Determine the cost to be charged to the product for the year. 3. Determine the cost to be charged to factory overhead for the year. 4. Determine the plotted data points using Chart Wizard. 5. Determine R2. 6. How do these solutions compare to the solutions in P4-2 and P4-3? 7. What does R2 tell you about this cost model?
Scattergraph, High-Low Method, and Predicting Cost for a Different Time Period from the One Used to Develop a Cost Formula Refer to the information for Farnsworth Company on the previous page. Required: 1. Prepare a scattergraph based on the 10 months of data. Does the relationship appear to be linear? 2. Using the high-low method, prepare a cost formula for the receiving activity. Using this formula, what is the predicted cost of receiving for a month in which 1,450 receiving orders are processed? 3. Prepare a cost formula for the receiving activity for a quarter. Based on this formula, what is the predicted cost of receiving for a quarter in which 4,650 receiving orders are anticipated? Prepare a cost formula for the receiving activity for a year. Based on this formula, what is the predicted cost of receiving for a year in which 18,000 receiving orders are anticipated? Use the following information for Problems 3-60 and 3-61: Farnsworth Company has gathered data on its overhead activities and associated costs for the past 10 months. Tracy Heppler, a member of the controllers department, has convinced management that overhead costs can be better estimated and controlled if the fixed and variable components of each overhead activity are known. One such activity is receiving raw materials (unloading incoming goods, counting goods, and inspecting goods), which she believes is driven by the number of receiving orders. Ten months of data have been gathered for the receiving activity and are as follows:
Calculate the per unit cost of an intensive visit using the conventional approach. Calculate the per unit cost of an intensive visit using the ABC approach. Exhibit 12-13Data for cost allocation in Problem 13 Basic data and calculation of unit costs using a conventional approach Total Cost by Visit Type Basic Data A B C D Initial Regular Intensive Total (Given) (Given) (Given) (A + B + C) 1 Number of visits 5,000 10,000 5,000 20,000 2 Direct materials (etc.) $21,000 $14,000 $35,000 $70,000 3 Direct labor $80,000 $80,000 $240,000 $400,000 4 Estimated overhead (total is a given) $150,000 5 Cost / visit: conventional method Additional basic data 1)…
Given the following cost and activity observations for Leno Enterprises'utilities, use the high-low method to calculate Leno's variable utilities cost permachine hour. Cost Machine HoursSeptember £4,100 22,000October £3,700 18,000November £3,900 19,000December £4,500 28,000a) £0.08b) £4.86c) £0.25d) £12.50
Determine fixed and variable costs using the high-low method and prepare graph. E2.26 (LO 3) The controller of Furgee Industries has collected the following monthly expense data for use in analyzing the cost behaviour of maintenance costs. Total Maintenance Costs Total Machine Hours Month January February March April May June $2,500 3,000 3,600 4,500 3,200 4,900 300 350 500 690 400 700 Instructions a. Determine the fixed and variable cost components using the high-low method. b. Prepare a graph showing the behaviour of maintenance costs, and identify the fixed and variable cost components. Use 100-hour increments and $1,000 cost increments.