Concept explainers
Case 5A-11 Mixed Cost Analysis and the Relevant Range LO5
The Ramon Company is a manufacturer that 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:
Last Year | This Year | |||||||
Machine | Overhead | Machine | Overhead | |||||
Month | Hours | Hours | Hours | Costs | ||||
January | 21,000 | $84,000 | 21,000 | $86,000 | ||||
February | 25,000 | $99,000 | 24,000 | $93,000 | ||||
March | 22,000 | $89,500 | 23,000 | $93,000 | ||||
April | 23,000 | $90,000 | 22,000 | $87,000 | ||||
May | 20,000 | $81,000 | 20,000 | $80,000 | ||||
June | 19,000 | $75,000 | 18,000 | $76,000 | ||||
July | 14,000 | $70,000 | 12,000 | $67,000 | ||||
August | 10,000 | $64,000 | 13,000 | $71,000 | ||||
September | 12,000 | $69,000 | 73,000 | $73,500 | ||||
October | 17,000 | $75,000 | 17,000 | $72,500 | ||||
November | 16,000 | $71,500 | 15,000 | $71,000 | ||||
December | 19,000 | $78,000 | 18,000 | $75,000 |
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-hours used exceed 19,500, then the fee becomes strictly variable with respect to the total number of machine-hours consumed during the month. Lease expense is a major element of overhead cost.<
Required:
Using the high-low method, estimate a
Prepare a scatter graph using all of the data for the two-year period. Fit a straight line or lines to the plotted points using a ruler. Describe the cost behavior pattern revealed by your scatter graph plot.
Assume a least-squares regression analysis using all of die 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 concerns about the accuracy of the high-low estimates that you have computed or the least-squares regression estimates that have been provided?
Assume that the company consumes 22,500 machine-hours during a month. Using the high-low method, estimate the total overhead cost that 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.
Comment on the accuracy of your high-low estimates assuming a least-squares regression analysis using only the data points in the relevant range of activity estimated the total fixed cost to be $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 5 Solutions
MANAGERIAL ACCOUNTING-CONNECT >CUSTOM<
- (Appendix 11A) Cycle Time, Velocity, Conversion Cost The theoretical cycle time for a product is 30 minutes per unit. The budgeted conversion costs for the manufacturing cell are 2,700,000 per year. The total labor minutes available are 600,000. During the year, the cell was able to produce 1.5 units of the product per hour. Suppose also that production incentives exist to minimize unit product costs. Required: 1. Compute the theoretical conversion cost per unit. 2. Compute the applied conversion cost per unit (the amount of conversion cost actually assigned to the product). 3. CONCEPTUAL CONNECTION Discuss how this approach to assigning conversion costs can improve delivery time performance.arrow_forwardQuestion 15 of 20 Moving to another question will save this response. Question 15 The estimated unit costs for a company to produce and sell a product at a level of 12,000 units per month are as follows: Cost Item EstimatedUnit Cost Direct material $ 32 Direct labor 20 Variable manufacturing overhead 15 Fixed manufacturing overhead 6 Variable selling expenses 3 Fixed selling expenses 4 What are the estimated prime costs per unit? $73 $52 $67 $32arrow_forwardQuestion 23 You are contemplating leaving your full-time employment to concentrate your ability on the marketing of a new low-energy portable heater. You have spoken to a group of manufacturers of similar product, and you have produced the following data based upon the production of 1200 heaters in the six months to December 31, 2021. R R Unit selling price 160 Less: Direct materials 50 Direct labour 30 Fixed Overheads: Admin 4.00 Rent 7.50 Rates…arrow_forward
- Problem 7-18 Relevant Cost Analysis in a Variety of Situations [LO 7-2, LO 7-3, LO 7-4] Andretti Company has a single product called a Dak. The company normally produces and sells 87,000 Daks each year at a selling price of $50 per unit. The company’s unit costs at this level of activity are given below: Direct materials $ 8.50 Direct labor 11.00 Variable manufacturing overhead 2.50 Fixed manufacturing overhead 7.00 ($609,000 total) Variable selling expenses 4.70 Fixed selling expenses 5.50 ($478,500 total) Total cost per unit $ 39.20 A number of questions relating to the production and sale of Daks follow. Each question is independent. Required: 1-a. Assume that Andretti Company has sufficient capacity to produce 108,750 Daks each year without any increase in fixed manufacturing overhead costs. The company could increase its sales by 25% above the present 87,000 units each year if it were willing to increase the fixed…arrow_forwardCh. 8 Homework Question 4 Please solve and explain the following: Each visor requires a total of $4.00 in direct materials that includes an adjustable closure that the company purchases from a supplier at a cost of $1.50 each. Shadee wants to have 30 closures on hand on May 1, 20 closures on May 31, and 25 closures on June 30. Additionally, Shadee’s fixed manufacturing overhead is $1,000 per month, and variable manufacturing overhead is $1.25 per unit produced. Required:1. Determine Shadee's budgeted cost of closures purchased for May and June 2. Determine Shadee's budget manufacturing overhead for May and Junearrow_forward15 es [The following information applies to the questions displayed below.] Diego Company manufactures one product that is sold for $77 per unit in two geographic regions-East and West. The following information pertains to the company's first year of operations in which it produced 59,000 units and sold 54,000 units. Variable costs per unit: Manufacturing: Direct materials. Direct labor Variable manufacturing overhead Variable selling and administrative Fixed costs per year: Fixed manufacturing overhead Fixed selling and administrative expense $27 $ 10 $2 $3 The company sold 41,000 units in the East region and 13,000 units in the West region. It determined that $330,000 of its fixed selling and administrative expense is traceable to the West region, $280,000 is traceable to the East region, and the remaining $52,000 is a common fixed expense. The company will continue to incur the total amount of its fixed manufacturing overhead costs as long as it continues to produce any amount of…arrow_forward
- Ch. 8 Homework Question 6 Please answer and solve the following Each visor requires a total of $4.00 in direct materials that includes an adjustable closure that the company purchases from a supplier at a cost of $1.50 each. Shadee wants to have 30 closures on hand on May 1, 20 closures on May 31 and 25 closures on June 30 and variable manufacturing overhead is $1.25 per unit produced. Suppose that each visor takes 0.30 direct labor hours to produce and Shadee pays its workers $9 per hour. Required: 1. Determine Shadee’s budgeted manufacturing cost per visor. (Note: Assume that fixed overhead per unit is $2.) (Round your answer to 2 decimal places.) 2. Determine Shadee's budgeted cost of goods sold for May and June.arrow_forwardQuestion 17 You are contemplating leaving your full-time employment to concentrate your ability on the marketing of a new low-energy portable heater. You have spoken to a group of manufacturers of similar product, and you have produced the following data based upon the production of 1200 heaters in the six months to December 31, 2021. R R Unit selling price 160 Less: Direct materials 50 Direct labour 30 Fixed Overheads: Admin 4.00 Rent 7.50 Rates…arrow_forward< High-Low Method The manufacturing costs of Rosenthal Industries for the first three months of the year follow: Total Costs Production January February $259,200 2,025 units 264,960 3,760 403,200 6,525 Using the high-low method, determine (a) the variable cost per unit and (b) the total fixed cost. a. Variable cost per unit b. Total fixed cost March Check My Work 2 more Check My Work uses remaining.arrow_forward
- Question 22 You are contemplating leaving your full-time employment to concentrate your ability on the marketing of a new low-energy portable heater. You have spoken to a group of manufacturers of similar product, and you have produced the following data based upon the production of 1200 heaters in the six months to December 31, 2021. R R Unit selling price 160 Less: Direct materials 50 Direct labour 30 Fixed Overheads: Admin 4.00 Rent 7.50 Rates…arrow_forwardQuestion 16 Norton's Mufflers manufactures two different product lines, Model X and Model Y. Market demand for Model X is 4,000 per month and demand for Model Y is 5,500 per month. The available machine hours are 20,000 per month for Norton's molding machine, needed for all models. The following per unit data apply: Model X Model Y $80 Selling price Direct materials Direct labor ($10 per hour) $15 Variable support costs ($5 per machine-hour) $10 Fixed support costs $20 $30 How many units of Model X should be produced? - $90 $30 $15 $15 $20arrow_forwardChapter 20 Excel Online Problems eBook High-low method for a service company Show Me How Office 365 Sierra Railroad Inc. decided to use the high-low method and operating data from the past six months to estimate the fixed and variable components of transportation costs. The activity base used by Sierra Railroad is "gross-ton miles," which is the total number of tons multiplied by the miles moved. January February March April May June Transportation Costs Gross-Ton Miles $732,000 217,000 816,200 242,000 576,800 157,000 782,500 235,000 656,300 841,400 189,000 255,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Determine the variable cost per gross-ton mile and the total fixed cost. Variable cost (If required, round to two decimal places.) $ Total fixed cost $ X per gross-ton milearrow_forward
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning