Pacific Logistics accumulates the following data concerning delivery costs: Month Packages Delivered Delivery Cost January 5,500 February 4,200 March 4,800 April 3.800 $28,750 $24,800 $26,400 $23,200 $27,800 May 5,200 Instructions: Using the High-Low method of analyzing costs, answer the following question: What is the estimated fixed delivery cost each month?

Pacific Logistics accumulates the following data concerning delivery costs: Month Packages Delivered Delivery Cost January 5,500 February 4,200 March 4,800 April 3.800 $28,750 $24,800 $26,400 $23,200 $27,800 May 5,200 Instructions: Using the High-Low method of analyzing costs, answer the following question: What is the estimated fixed delivery cost each month?

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

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:
Using the least-squares method of analyzing costs, answer the following questions and show computations to support your answers. a. What is the estimated variable portion of maintenance costs per labor hour? B.What is the estimated fixed maintenance cost each month? C.Formulate the regression equation D.If it is estimated that 600 labor hours will be used in July, what is the expected total power cost for July?
1.Using the high-low method of analyzing costs, answer the following questions and show computations to support your answers. a. What is the estimated variable portion of maintenance costs per labor hour? 2.What is the estimated fixed maintenance cost each month? 3.Formulate the regression equation 4.If it is estimated that 600 labor hours will be used in July, what is the expected total power cost for July? 5.Using the least-squares method of analyzing costs, answer the following questions and show computations to support your answers. a. What is the estimated variable portion of maintenance costs per labor hour? 5a. What is the estimated fixed maintenance cost each month? 5b.Formulate the regression equation 5c.If it is estimated that 600 labor hours will be used in July, what is the expected total power cost for July?
Solve for the cost line equation using the high-low method: \table[[Month, Units Produced,Total Cost], [1,4,500,$ 38,000
Provide correct solution for this question
Global Publishers has collected the following data for recent months: Month March April May June Issues published 20,500 21,800 17,750 21,200 Total cost Variable cost per unit $ Total fixed costs $ Required: a. Using the high-low method, find variable cost per unit, total fixed costs, and the total cost equation. Round the variable cost to two decimal places. $20,960 22,464 18,495 21,395 per unit Total cost = $ x Number of issues published) b. What is the estimated cost for a month in which 19,000 issues are published?
Given the following cost and activity observations for Johnson solve this question
Suppose a company finds that shipping cost is 3,560 each month plus 6.70 per package shipped. What is the cost formula for monthly shipping cost? Identify the independent variable, the dependent variable, the fixed cost per month, and the variable rate.
Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for a Time Period That Differs from the Data Period Refer to the information for Pizza Vesuvio on the previous page. Assume that this information was used to construct the following formula for monthly labor cost. TotalLaborCost=5,237+(7.40EmployeeHours) Required: Assume that 4,000 employee hours are budgeted for the coming year. Use the total labor cost formula to make the following calculations: 1. Calculate total variable labor cost for the year. 2. Calculate total fixed labor cost for the year. 3. Calculate total labor cost for the coming year. Use the following information for Brief Exercises 3-17 through 3-20: Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected:
Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost Refer to the information for Speedy Petes on the previous page. Coefficients shown by a regression program for Speedy Petes data are: Required: Use the results of regression to make the following calculations: 1. Calculate the fixed cost of deliveries and the variable rate per delivery. 2. Construct the cost formula for total delivery cost. 3. Calculate the budgeted cost for next month, assuming that 3,000 deliveries are budgeted. (Note: Round answers to the nearest dollar.) Use the following information for Brief Exercises 3-26 through 3-29: Speedy Petes is a small start-up company that delivers high-end coffee drinks to large metropolitan office buildings via a cutting-edge motorized coffee cart to compete with other premium coffee shops. Data for the past 8 months were collected as follows:
The cost data for BC Billing Solutions for the year 2020 is as follows: Using the high-low method, express the companys overtime wages as an equation where x represents number of invoices processed. Assume BC has monthly fixed costs of $3,800. Predict the overtime wages if 9,000 invoices are processed. Predict the overtime wages if 6,500 invoices are processed. Using Excel, create a scatter graph of the cost data and explain the relationship between the number of invoices processed and overtime wage expense.
Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost Refer to the information for Pizza Vesuvio on the previous page. Coefficients shown by a regression program for Pizza Vesuvios data are: Required: Use the results of regression to make the following calculations: 1. Calculate the fixed cost of labor and the variable rate per employee hour. 2. Construct the cost formula for total labor cost. 3. Calculate the budgeted cost for next month, assuming that 675 employee hours are budgeted. (Note: Round answers to the nearest dollar.) Use the following information for Brief Exercises 3-17 through 3-20: Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected: