The controller of Hall industries has collected the following monthly expense data for use in analyzing the cost behavior of maintenance costs.
Month | Total Maintenance Costs | Total Machine Hours |
January | $2,640 | 3,500 |
February | 3,000 | 4,000 |
March | 3,600 | 6,000 |
April | 4,500 | 7,900 |
May | 3,200 | 5,000 |
June | 4,620 | 8,000 |
Instructions
(a) Determine the fixed- and variable-cost components using the high-low method.
(b) Prepare a graph showing the behavior of maintenance costs and identify the fixed- and variable-cost elements. Use 2,000-hour increments and $1,000 cost increments.
Want to see the full answer?
Check out a sample textbook solutionChapter 5 Solutions
Managerial Accounting: Tools for Business Decision Making
Additional Business Textbook Solutions
Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
Horngren's Financial & Managerial Accounting, The Financial Chapters (Book & Access Card)
Financial Accounting (11th Edition)
Managerial Accounting (5th Edition)
Financial Accounting: Tools for Business Decision Making, 8th Edition
Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
- Rex Industries has identified three different activities as cost drivers: machine setups, machine hours, and inspections. The overhead and estimated usage are: Rex Industries data Activity Machine setups Machine hours Inspections Overhead per Activity $155,000 352,800 120,750 Annual Usage 4,000 14,112 3,500 Overhead Rate per Activity $ Complete the chart and compute the overhead rate for each activity. Round to the nearest penny, two decimal places.arrow_forwardThe following are the Maintenance Costs incurred in a Machine Shop for six months with corresponding machine hours. Analyse the Semi-Variable Maintenance Costs into Fixed & Variable elements by High and Low Points Method. Feb Month Jan Mar Apr 34 May 28 June Total Maintenance Costs Rs.000s Machine Hours 30 32 27 29 180 2,000 2,200 1,700 2,400 1,800 1,900 12,000arrow_forwardMission Company is preparing its annual profit plan. As part of its analysis of the profitability of individual products, the controller estimates the amount of overhead that should be allocated to the individual product lines from the information provided below (CMA adapted) Multiple Choice Units produced Material moves per product line Direct labor-hours per product line Budgeted material handling costs: $594,000 Under a traditional costing system that allocates overhead on the basis of direct labor-hours, the materials handling costs allocated to one unit of Wall Mirrors would be O $1000 $1.350 $5,400 Wall Mirrors 210 5 1,050 $22.000 Specialty Nindows 25 46arrow_forward
- The controller of Hendershot Corporation estimates the amount of materials handling overhead cost that should be allocated to the company's two products using the data that are given below: Wall Specialty Mirrors Windows Total expected units produced Total expected material moves Expected direct labor-hours per unit 11,900 1,710 1,190 1,610 8 The total materials handling cost for the year is expected to be $17,148.7O. If the materials handling cost is allocated on the basis of material moves, the total materials handling cost allocated to the specialty windows is closest to: (Round your intermediate calculations to 4 decimal places.)arrow_forwardroduction reports for the third quarter show the following data:  Month Machine hours Direct labour hours Direct materials cost (£) Floor surface (square meters) Actual Overhead (£) July 10,000 44,000 25,000 150 31,200 August 15,000 37,800 21,750 170 47,000 September 13,400 59,500 32,000 210 40,100  Which variable would be the most likely basis for allocating overhead?   a. Machine hours  b. Labour hours  c. Floor surface  d. Direct materials costarrow_forwardAl-Bustan Co. gathered the following information on total costs and factory machine usage for the last six months:        Month Total cost Factory Machine Hours January 14,810 13,900 February 29,210 16,600 March 29,000 6,600 April 19,340 13,200 May 29,810 16,500 June 14,910 6,800  Instructions Using the high-low method of analyzing costs, answer the following questions and show computations to support your answers.  (a)        What is the variable portion of the mixed costs? (b)        What is the fixed portion of the mixed costs? (c)         If it is estimated that 5,000 factory machine hours will be run in July, what is the expected total cost for July?arrow_forward
- Apply the Concepts, Cost Reporting Medco Inc., a manufacturing firm, has four activities: purchasing materials, molding, inspecting molds, and grinding imperfect molds. Purchasing materials and molding are necessary activities; inspection and grinding are unnecessary. SQ provides the value-added quantity for each activity; AQ is the actual activity output. The following data pertain to the four activities for the year ending (actual price per unit of the activity driver is assumed to be equal to the standard price): Activity Activity Driver Purchasing Purchasing hours Molding Inspecting Inspection hours Molding hours Grinding. Number of units Required: SQ AQ SP 28,000 34,000 $20 42,000 47,600 121 0 8,400 15 0 6,000 6 1. Prepare a cost report for the year 1 ended that shows value-added costs, non-value-added costs, and total costs for each activity by completing the following table: Value-and Non-Value-Added Cost Report for the Year 1 Ended Activity Value-Added Costs Non-Value-Added…arrow_forwardBenson Corporation estimated its overhead costs would be $22,500 per month except for January when it pays the $153,120 annual insurance premium on the manufacturing facility. Accordingly, the January overhead costs were expected to be $175,620 ($153,120 + $22,500). The company expected to use 7,900 direct labor hours per month except during July, August, and September when the company expected 9,100 hours of direct labor each month to build inventories for high demand that normally occurs during the Christmas season. The company's actual direct labor hours were the same as the estimated hours. The company made 3,950 units of product in each month except July, August, and September, in which it produced 4,550 units each month. Direct labor costs were $24.70 per unit, and direct materials costs were $10.00 per unit. Required a. Calculate a predetermined overhead rate based on direct labor hours. b. Determine the total allocated overhead cost for January, March, and August. c. Determine…arrow_forwardRocks Industries has identified three different activities as cost drivers: machine setups, machine hours, and inspections. The overhead and estimated usage are: Activity Overhead per Activity Annual Usage Machine Set Up $75,000 6,000 Machine Hours $85,002 5,484 Inspections $70,000 20,000 Compute the overhead rate for each activity.arrow_forward
- Nova Company’s total overhead cost at various levels of activity are presented below:  Month Machine-Hours  TotalOverhead Cost April 52,000  $ 203,860 May 42,000  $ 181,060 June 62,000  $ 226,660 July 72,000  $ 249,460   Assume that the total overhead cost above consists of utilities, supervisory salaries, and maintenance. The breakdown of these costs at the 42,000 machine-hour level of activity is:   Utilities (variable) $ 50,400   Supervisory salaries (fixed)  67,000  Maintenance (mixed)  63,660  Total overhead cost $ 181,060arrow_forwardLake Balboa Manufacturing Company decides to relate total factory overhead costs to direct labor hours (DLH) to develop a cost-volume formula in the form of y = a + bx. Observations from 2019 are collected. They are given and on the excel file. Month Direct Labor Hours Factory Overhead January 9,000 13,000 February 19,000 20,000 March 11,000 14,000 April 14,000 16,000 May 23,000 25,000 June 12,000 20,000 July 12,000 20,000 August 22,000 23,000 September 7,000 14,000 October 13,000 22,000 November 15,000 18,000 December 17,000 18,000 Total 174,000 hours $225,000 In October of 2020, the company used 13,000 direct labor hours. Using the cost formula for factory overhead calculated using the High-Low Method, calculate the factory overhead for October 2020.arrow_forwardThe controller of PUSO Co. estimates the amount of materials handling overhead cost that should be allocated to the firm's two product using the data below: Specialty Windows 7,000 Wall Mirrors Total expected units produced Total expected materials move Expected direct labor per unit 8,000 900 300 7 5 The total materials handling cost for the year is expected to be P38, 448. If the materials handling cost is allocated on the basis of direct labor-hours, how much of the total material handling cost should be allocated to the specialty windows?arrow_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub