Scatter Diagrams and High-Low Cost EstimationFrom April 1 through October 31, Coles County Highway Department hires temporary employees to mow and clean the right-of-way along county roads. The County Road Commissioner has asked you to helpher in determining the variable labor cost of mowing and cleaning a mile of road. The following information is available regarding current-year operations:MonthAprilMayJuneJulyAugustSeptemberOctoberMiles Mowed Laborand Cleaned Costs240 $6,800305 7,680325 8,310275 7,200220 6,550200 5,76075 4,960Use the information from the high- and low-volume months to develop a cost-estimating equation for monthly labor costs.Monthly labor costs $0+ $0XPlot the data on a scatter diagram. Using the information from representative high- and low volume months, use the high-low method to develop a cost-estimating equation for monthly labor costs.Monthly labor costs$0 + $oxAdjust the equation developed in requirement (b) to incorporate the effect of an anticipated 5% increase in wages.Monthly labor costs $0 + $ox

Labor costs refer to the sum total of wages paid by an employer to its employees for the particular…

per 325 8,310 275 7,200 220 6,550 200 5,760 75 4,960 information from the high- and low-volume months to dev labor costs - $ 0+ $ ox data on a scatter diagram. Using the information from rep labor costs $ ox 0+$

per 325 8,310 275 7,200 220 6,550 200 5,760 75 4,960 information from the high- and low-volume months to dev labor costs - $ 0+ $ ox data on a scatter diagram. Using the information from rep labor costs $ ox 0+$

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter7: Allocating Costs Of Support Departments And Joint Products

Section: Chapter Questions

Problem 30E: A company uses charging rates to allocate service department costs to the using departments. The...

See similar textbooks

Similar questions

A company uses charging rates to allocate service department costs to the using departments. The accountant compiled the following information on one of the service departments: If Department K plans to use 1,350 hours of the service departments service in the coming year, how much of the service departments cost is allocated to Department K? a. 3,375 b. 27,300 c. 26,325 d. 23,950
Scatter Diagrams and High-Low Cost EstimationFrom April 1 through October 31, Will County Highway Department hires temporary employees to mow and clean the right-of-way along county roads. The County Road Commissioner has asked you to help her in determining the variable labor cost of mowing and cleaning a mile of road. The following information is available regarding current-year operations: Month Miles Mowedand Cleaned LaborCosts April 350 $16,000 May 300 15,000 June 400 18,000 July 250 11,000 August 375 17,000 September 200 10,000 October 100 9,600 a. Use the information from the high- and low-volume months to develop a cost-estimating equation for monthly labor costs. Monthly labor costs = Answer + Answer X b. Plot the data on a scatter diagram. Using the information from representative high- and low volume months, use the high-low method to develop a cost-estimating equation for monthly labor costs. Monthly labor costs = Answer + Answer X d.…
rom April 1 through October 31, Coles County Highway Department hires temporary employees to mow and clean the right-of-way along county roads. The County Road Commissioner has asked you to help her in determining the variable labor cost of mowing and cleaning a mile of road. The following information is available regarding current-year operations: Month Miles Mowedand Cleaned LaborCosts April 240 $6,800 May 305 7,680 June 325 8,310 July 275 7,200 August 220 6,550 September 200 5,760 October 75 4,960 Use the information from the high- and low-volume months to develop a cost-estimating equation for monthly labor costs. Monthly labor costs = + X Plot the data on a scatter diagram. Using the information from representative high- and low volume months, use the high-low method to develop a cost-estimating equation for monthly labor costs. Monthly labor costs = + X Adjust the equation developed in requirement (b) to incorporate the…
Assigning Costs to Activities, Resource Drivers The Receiving Department has three activities: unloading, counting goods, and inspecting. Unloading uses a forklift that is leased for $21,000 per year. The forklift is used only for unloading. The fuel for the forklift is $3,700 per year. Other operating costs (maintenance) for the forklift total $1,500 per year. Inspection uses some special testing equipment that has depreciation of $1,750 per year and an operating cost of $1,750. Receiving has three employees who have an average salary of $50,000 per year. The work distribution matrix for the receiving personnel is as follows: Activity Percentage of Time on Each Activity Unloading 40% Counting 25% Inspecting 35% No other resources are used for these activities. Required: 1. Calculate the cost of each activity. Unloading $fill in the blank 1 Counting $fill in the blank 2 Inspecting $fill in the blank 3 2. Explain the two methods used to assign costs to activities.…
Estimating a cost function, high-low method. Lacy Dallas is examining customer-service costs in the southern region of Camilla Products. Camilla Products has more than 200 separate electrical products that are sold with a 6-month guarantee of full repair or replacement with a new product. When a product is returned by a customer, a service report is prepared. This service report includes details of the problem and the time and cost of resolving the problem. Weekly data for the most recent 8-week period are as follows:
The loan department of Calgary Bank uses standard costs to determine the overhead cost of processing loan applications. During the current month, a fire occurred, and the accounting records for the department were mostly destroyed. The following data were salvaged from the ashes. Standard variable overhead rate per hour $9 Standard hours per application 3 Standard hours allowed 4,980 Standard fixed overhead rate per hour $7 Actual fixed overhead cost $35,630 Variable overhead budget based on standard hours allowed $18,300 Fixed overhead budget $35,630 Overhead controllable variance $1,000 U (a)Determine the following. (1) Total actual overhead cost $ (2) Actual variable overhead cost $ (3) Variable overhead costs applied $ (4) Fixed overhead costs applied $ (5) Overhead volume variance $ (b)Determine how many loans were processed.
Ethan Manufacturing Incorporated produces floor mats for automobiles. The owner, Joseph Ethan, has asked you to assist in estimating maintenance costs. Together, you and Joseph determine that the single best cost driver for maintenance costs is machine hours. These data are from the previous fiscal year for maintenance costs and machine hours: 1. What is the cost equation for maintenance costs using the high-low method? 2. Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1. Month Maintenance Costs Machine Hours 1 $ 2,660 1,750 2 2,820 1,830 3 2,970 1,910 4 3,080 1,930 5 3,160 1,960 6 3,130 1,940 7 3,070 1,920 8 2,910 1,900 9 2,680 1,760 10 2,280 1,160 11 2,290 1,360 12 2,510 1,650
Assigning Costs to Activities, Resource Drivers The receiving department has three activities: unloading, counting goods, and inspecting. Unloading uses a forklift that is leased for $15,000 per year. The forklift is used only for unloading. The fuel for the forklift is $3,600 per year. Other operating costs (maintenance) for the forklift total $1,500 per year. Inspection uses some special testing equipment that has depreciation of $1,200 per year and an operating cost of $750. Receiving has three employees who have an average salary of $50,000 per year. The work distribution matrix for the receiving personnel is as follows: Activity Percentage of Time on Each Activity Unloading 40% Counting 25 Inspecting 35 No other resources are used for these activities. Required: 1. Calculate the cost of each activity. Unloading $fill in the blank 1 Counting $fill in the blank 2 Inspecting $fill in the blank 3 2. Explain the two methods used to assign costs to activities.
Waterways has two major public-park projects to provide with comprehensive irrigation in one of its service locations this month. Job J57 and Job K52 involve 15 acres of landscaped terrain, which will require special-order, sprinkler heads to meet the specifications of the project. Using a job cost system to produce these parts, the following events occurred during December.Raw materials were requisitioned from the company’s inventory on December 2 for $5,091; on December 8 for $1,050; and on December 14 for $3,495. In each instance, two-thirds (2/3) of these materials were for J57 and the rest for K52.Six time tickets were turned in for these two projects for a total amount of 18 hours of work. All the workers were paid $17.5 per hour. The time tickets were dated December 3, December 9, and December 15. On each of those days, 6 labor hours were spent on these jobs, two-thirds (2/3) for J57 and the rest for K52.The predetermined overhead rate is based on machine hours. The expected…
Ethan Manufacturing Incorporated produces floor mats for automobiles. The owner, Joseph Ethan, has asked you to assist in estimating maintenance costs. Together, you and Joseph determine that the single best cost driver for maintenance costs is machine hours. These data are from the previous fiscal year for maintenance costs and machine hours: Month Maintenance Costs Machine Hours 1 $ 2,780 1,870 2 2,940 1,950 3 3,090 2,030 4 3,200 2,050 5 3,280 2,080 6 3,250 2,060 7 3,190 2,040 8 3,030 2,020 9 2,800 1,880 10 2,400 1,280 11 2,410 1,480 12 2,630 1,770 Required: 1. What is the cost equation for maintenance costs using the high-low method? 2. Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1.
The manager of Trusty Car Inspection reviewed the monthly operating costs for the past year. The costs ranged from $4,300 for 1,300 inspections to $3,900 for 900 inspections. Requirements 1. Use the high-low method to calculate the variable cost per inspection. 2. Calculate the total fixed costs. 3. Write the equation and calculate the operating costs for 1,000 inspections. 4. Draw a graph illustrating the total cost under this plan. Label the axes, and show the costs at 900, 1,000, and 1,300 inspections.
please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image) The production supervisor of the Machining Department for Hagerstown Company agreed to the following monthly static budget for the upcoming year: Line Item Description Amount Wages $481,000 Utilities 27,000 Depreciation 46,000 Total $554,000 The actual amount spent and the actual units produced in the first three months in the Machining Department were as follows: Month Amount Spent Units Produced May $522,000 105,000 June 496,000 95,000 July 475,000 86,000 The Machining Department supervisor has been very pleased with this performance because actual expenditures for May–July have been significantly less than the monthly static budget of 554,000. However, the plant manager believes that the budget should not remain fixed…