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

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
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.
Calculate the variable and fixed cost
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:
Help
Provide answer
Compute the High low method.
Bruno Company accumulates the following data concerning a mixed cost, using miles as the activity level. Miles Total Miles Total Driven Cost Driven Cost January 8,000 $14,150 March 8,500 $15,000 February 7,500 13,500 April 8,200 14,490 Compute the variable- and fixed-cost elements using the high-low method
Cullumber Company accumulates the following data concerning a mixed cost, using miles as the activity level. Miles Driven Total Miles Total Cost Driven Cost January 8,005 $14,170 March 8,500 $14,790 February 7,500 13,490 April 8,200 14,485 (a1) Your answer is correct. Compute the unit variable costs using the high-low method for this mixed cost. (Round answer to 2 decimal places, e.g. 2.25.) Variable cost per mile (a2) eTextbook and Media $ 1.3 Compute the fixed costs using the high-low method for this mixed cost. Total fixed costs +A $ Attempts: 1 of 10 used