Mixed Cost Analysis and the Relevant Range LOS-10
The Ramon Company is a manufacturer tint is interested in developing a cost formula to estimate the variable and fixed components of its monthly manufacturing overhead costs, The Company wishes to use machine-hours as its measure of activity and has gathered the data below for this year and Last year:
The company leases all of its manufacturing equipment. The lease arrangement calls for a flat monthly fee up to 19,500 machine-hours. If the machine-bows used exceeds 19,500, then the fee becomes strictly variable with respect to the total number of machine-bouts consumed during the month. Lease expense is a major element of overhead cost.
Required:
1. Using the high-low method, estimate a
2. Prepare a scattergraph using all of the data for the two-ear period. Fit a straight line or lines to the plotted points using a ruler. Describe the cost behaviour pattern resealed by your scattergraph plot.
3. Assume a least-squares regression analysis using all of the given data points estimated the total fixed cost to be $40,102 and the variable cost to be $2. 13 per machine-hour. Do you have any conceits about the accuracy of the high-Low estimates that you have computed or the least-squares regression estimates that have been provided?
4. Assume that the company consumes 22,500 machine-hours during a month. Using the high-low method, estimate the total overhead costthat would be incurred at this level of activity. Be sure to consider only the data points contained in the relevant range of activity when performing your computations.
5. Comment on the accuracy of your high-low estimates assuming a least-squares regression analysis using only the data points in therelevant range of activity estimated the total fixed cost tobe $10,090 and the variable cost to be $3.53 per machine-hour.
Want to see the full answer?
Check out a sample textbook solutionChapter 6 Solutions
Introduction To Managerial Accounting
- The expected costs for the Maintenance Department of Stazler, Inc., for the coming year include: Fixed costs (salaries, tools): 64,900 per year Variable costs (supplies): 1.35 per maintenance hour Estimated usage by: Actual usage by: Required: 1. Calculate a single charging rate for the Maintenance Department. 2. Use this rate to assign the costs of the Maintenance Department to the user departments based on actual usage. Calculate the total amount charged for maintenance for the year. 3. What if the Assembly Department used 4,000 maintenance hours in the year? How much would have been charged out to the three departments?arrow_forwardStep Costs, Relevant Range Bellati Inc. produces large industrial machinery. Bellati has a machining department and a group of direct laborers called machinists. Each machinist can machine up to 500 units per year. Bellati also hires supervisors to develop machine specification plans and oversee production within the machining department. Given the planning and supervisory work, a supervisor can oversee, at most, three machinists. Bellatis accounting and production history shows the following relationships between number of units produced and the annual costs of supervision and materials handling (by machinists): Required: 1. Prepare a graph that illustrates the relationship between direct labor cost and number of units produced in the machining department. (Let cost of direct labor be the vertical axis and number of units be the horizontal axis.) Would you classify this cost as a strictly variable cost, a fixed cost, or a step cost? 2. Prepare a graph that illustrates the relationship between the cost of supervision and the number of units produced. (Let cost of supervision be the vertical axis and number of units be the horizontal axis.) Would you classify this cost as a strictly variable cost, a fixed cost, or a step cost? 3. Suppose that the normal range of production is between 1,400 and 1,500 units and that the exact number of machinists is currently hired to support this level of activity. Further suppose that production for the next year is expected to increase by an additional 500 units. What is the increase in the cost of direct labor? Cost of supervision?arrow_forwardIdentify cost graphs The following cost graphs illustrate various types of cost behavior: For each of the following costs, identify the cost graph that best illustrates its cost behavior as the number of units produced increases: A. Total direct materials cost B. Electricity costs of 1,000 per month plus 0.10 per kilowatt-hour C. Per-unit cost of straight-line depreciation on factory equipment D. Salary of quality control supervisor, 20,000 per month E. Per-unit direct labor costarrow_forward
- Morris Industries manufactures and sells three products (AA, BB, and CC). The sales price and unit variable cost for the three products are as follows: Their sales mix s reflected as a ratio of 5:3:2. Annual fixed costs shared by the three products are $25,000 per year. What are total variable costs for Morris with their current product mix? Calculate the number of units of each product that will need to be sold in order for Morris to break even. What is their break-even point in sales dollars? Using an income statement format, prove that this is the break-even point.arrow_forwardLabor classification trade-off Skidmore Electronics manufactures consumer electronic products. The company has three assembly labor classifications, S-1, S-2, and S-3. The three classifications are paid 15, 18, and 22 per hour, respectively. The assembly activity for a new smartphone is as follows: A product engineer proposes using a higher-rated employee to perform the assembly on the new phone. His analysis has shown that an S-3 employee can perform the assembly in 0.35 hour per unit. A. Determine the Assembly activity cost using the S-3 labor classification. B. Is the product engineers proposal supported?arrow_forwardWellington, Inc., reports the following contribution margin income statement for the month of May. The company has the opportunity to purchase new machinery that will reduce its variable cost per unit by $10 but will increase fixed costs by 20%. Prepare a projected contribution margin income statement for Wellington, Inc., assuming it purchases the new equipment. Assume sales level remains unchanged.arrow_forward
- High-low method The manufacturing costs of Rosenthal Industries for the first three months of the year follow: Using the high-low method, determine (a) the variable cost per unit and (b) the total fixed cost.arrow_forwardManufacturing builds and sells switch harnesses for glove boxes. The sales price and variable cost for each follows: Their sales mix is reflected in the ratio 4:4:1. If annual fixed costs shared by the three products are $1 8840 how many units of each product will need to be sold in order forJj to break even?arrow_forward
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
- Principles 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 LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College