The controller of Metro Manufacturing has collected the following monthly data to analyze utility costs: Month Total Utility Costs ($) Machine Hours July 3,800 400 August 4,200 450 September 5,100 600 October 6,200 750 November 4,000 420 December 6,500 800 Determine the fixed-cost and variable-cost components of the utility costs using the high- low method. Would you like me to solve this again step-by-step or add details?

The controller of Metro Manufacturing has collected the following monthly data to analyze utility costs: Month Total Utility Costs ($) Machine Hours July 3,800 400 August 4,200 450 September 5,100 600 October 6,200 750 November 4,000 420 December 6,500 800 Determine the fixed-cost and variable-cost components of the utility costs using the high- low method. Would you like me to solve this again step-by-step or add details?

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter4: Accounting For Factory Overhead

Section: Chapter Questions

Problem 4P: Using the data in P4-2 and Microsoft Excel: 1. Separate the variable and fixed elements. 2....

See similar textbooks

Similar questions

This cost data from Hickory Furniture is for the year 2017. Using the high-low method, express the companys utility costs as an equation where X represents number of tables produced. Predict the utility costs if 800 tables are produced. Predict the utility costs if 600 tables are produced. Using Excel, create a scatter graph of the cost data and explain the relationship between number of tables produced and utility expenses.
Data table Month Total Cost Machine Hours January.. 3,420 1,090 February..... S 3,760 1,120 March .... $ 3,532 1,080 April ..... 3,720 1,220 May S 4,800 1,330 June 4,192 1,480 .. %24 %24
The graphs below represent cost behavior patterns that might occur in acompany's cost structure. The vertical axis represents total cost, and thehorizontal axis represents activity output. Required:For each of the following situations, choose the graph from the group a-1 that best illustrates the cost pattern involved. Also, for each situation,identify the driver that measures activity output. 1. The cost of power when a fixed fee of $500 per month is chargedplus an additional charge of $0.12 per kilowatt-hour used2. Commissions paid to sales representatives. Commissions arepaid at the rate of 5 percent of sales made up to total annual salesof $500,000, and 7 percent of sales above $500,000.3. A part purchased from an outside supplier costs $12 per part for the first 3,000 parts and $10 per part for all parts purchased inexcess of 3,000 units.4. The cost of surgical gloves, which are purchased in incrementsof 100 units (gloves come in boxes of 100 pairs).5. The cost of tuition at a…
This cost data from Hickory Furniture is for the year 2017. Using the high-low method, express the factory utility expenses as an equation where x represents number of chairs produced. Predict the utility costs if 900 chairs are produced. Predict the utility costs if 750 chairs are produced. Using Excel, create a scatter graph of the cost data and explain the relationship between number of chairs processed and utility expenses.
Scattergraph method Using the data in P4-2 and a piece of graph paper: 1. Plot the data points on the graph and draw a line by visual inspection, indicating the trend shown by the data points. 2. Determine the variable cost per unit and the total fixed cost from the information on the graph. 3. Determine the variable cost to be charged to the product for the year. 4. Determine the fixed cost to be charged to factory overhead for the year. 5. Do these answers agree with the answers to P4-2? Why or why not?
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?
Potterii sells its products to large box stores and recently added a retail line of products to sell directly to consumers. These estimates are to be used in determining the overhead allocation rate for ABC: What would be the predetermined rate for each cost pool?
Bumblebee Mobiles manufactures a line of cell phones. The management has identified the following overhead costs and related cost drivers for the coming year. The following were incurred in manufacturing two of their cell phones, Bubble and Burst, during the first quarter. REQUIREMENT Review the worksheet called ABC that follows these requirements. You have been asked to determine the cost of each product using an activity-based cost system. Note that the problem information is already entered into the Data Section of the ABC worksheet.
Electan Company produces two types of printers. The company uses ABC, and all activity drivers are duration drivers. Electan Company is considering using DBC and has gathered the following data to help with its decision. A. Activities with duration drivers: B. Activities with consumption ratios and costs: C. Products with cycle time and practical capacity: Required: 1. Using cycle time and practical capacity for each product, calculate the total time for all primary activities. Comment on the relationship to ABC. 2. Calculate the overhead rate that DBC uses to assign costs. Comment on the relationship to a unit-based plantwide overhead rate. 3. Use the overhead rate calculated in Requirement 2 to calculate (a) the overhead cost per unit for each product, and (b) the total overhead assigned to each product. How does this compare to the ABC assignments shown in Part B of the Information set? 4. What if the units actually produced were 10,000 for Printer A and 18,000 for Printer B. Using DBC, calculate the cost of unused capacity.
Silven Company has identified the following overhead activities, costs, and activity drivers for the coming year: Silven produces two models of cell phones with the following expected activity demands: 1. Determine the total overhead assigned to each product using the four activity drivers. 2. Determine the total overhead assigned to each model using the two most expensive activities. The costs of the two relatively inexpensive activities are allocated to the two expensive activities in proportion to their costs. 3. Using ABC as the benchmark, calculate the percentage error and comment on the accuracy of the reduced system. Explain why this approach may be desirable.
The cost data for Evencoat Paint for the year 2019 is as follows: Using the high-low method, express the companys maintenance costs as an equation where x represents the gallons of paint produced. Then estimate the fixed and variable costs. Predict the maintenance costs i190,000 gallons of paint are produced. Predict the maintenance costs if 81,000 gallons of paint are produced. Using Excel, create a scatter graph of the cost data and explain the relationship between gallons of paint produced and equipment maintenance expenses.
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: