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
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 ACCT(LL)+CONNECT+PROCTORIO PL
- (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_forwardPlease help me with show all calculation thankuarrow_forwardProvide solution this questionarrow_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_forwardQuestion 26arrow_forwardQuestion 27arrow_forward
- Please help mearrow_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_forwardPlz answer A,B&Carrow_forward
- Question 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_forwardDengerarrow_forwardFast solve plzarrow_forward
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningAccounting (Text Only)AccountingISBN:9781285743615Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningFinancial & Managerial AccountingAccountingISBN:9781285866307Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning