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

Need help with this accounting question please solve
I want to answer this question
Crane Company accumulates the following data concerning a mixed cost, using miles as the activity level. Miles Driven Total Cost Miles Driven Total Cost January 7995 14180 March 8510 14909 February 7505 13502 April 8200 14495 a/ Compute the variable cost per mile using the high-low method. (Round answer to 2 decimal places) Variable cost per mile b/ Compute the fixed cost elements using the high-low method. Fixed costs
Provide answer this question
Want your help to solve this account problem
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:
Given the following information, choose the cost and activity that would be used as the high data point in high-low cost estimation: Costs (P) Activity (hours) 48 000 41 500 49 000 42 000 57 000 42 500 56 000 43 000 55 000 43 500 O P57 000 and 43 500 hours O P55 000 and 43 000 hours O P55 000 and 42 500 hours O P55 000 and 43 500 hours O P57 000 and 42 500 hours O P56 000 and 43 500 hours