High-low method Evander Inc. has decided to use the high-low method to estimate the total cost and the fixed and variable cost components of the t cost. The data for various levels of production are as follows: Units Produced 2,100 Total Costs $245,700 3,770 5,600 332,790 382,200 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input answers in the questions below. X Open spreadsheet a. Determine the variable cost per unit and the total fixed cost. Variable cost $ Total fixed cost $ 36 X b. Based on part (a), estimate the total cost for 2,770 units of production. Total cost for 2,770 units $

High-low method Evander Inc. has decided to use the high-low method to estimate the total cost and the fixed and variable cost components of the t cost. The data for various levels of production are as follows: Units Produced 2,100 Total Costs $245,700 3,770 5,600 332,790 382,200 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input answers in the questions below. X Open spreadsheet a. Determine the variable cost per unit and the total fixed cost. Variable cost $ Total fixed cost $ 36 X b. Based on part (a), estimate the total cost for 2,770 units of production. Total cost for 2,770 units $

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

Ziegler Inc. has decided to use the high-low method to estimate the total cost and the fixed and variable cost components of the total cost. The data for various levels of production are as follows: Units Produced Total Costs $28,166,000 104,000 114,000 29,781,000 128,000 32,042,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 a. Determine the variable cost per unit and the total fixed cost. Round your answer for variable cost to the nearest cent. Round your answer for total fixed costs to the nearest dollar. Variable cost: per unit Total fixed cost: b. Based on part (a), estimate the total cost for 84,000 units of production. Round your answer to the nearest dollar. Total cost for 84,000 units:
Using the data in E4-2 and spreadsheet software, determine: The variable cost per unit, the total fixed cost, and R2. The plotted data points using the graphing function. Compare the results to your solutions in E4-2 and E4-3 and explain the reasons for the results.
Using the data in P4-2 and Microsoft Excel: 1. Separate the variable and fixed elements. 2. Determine the cost to be charged to the product for the year. 3. Determine the cost to be charged to factory overhead for the year. 4. Determine the plotted data points using Chart Wizard. 5. Determine R2. 6. How do these solutions compare to the solutions in P4-2 and P4-3? 7. What does R2 tell you about this cost model?
UPVOTE WILL BE GIVEN! INPUT THE COMPLETE SOLUTIONS. YOU MAY USE EXCEL. BOX THE FINAL ANSWERS. c. Calculate for the total manufacturing cost per unit? d. How much is the total cost for Started and Completed?
High-low method Ziegler Inc. has decided to use the high-low method to estimate the total cost and the fixed and variable cost components of the total cost. The data for various levels of production are as follows: X Open spreadsheet 105,000 118,000 134,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. Variable cost: Total fixed cost: Units Produced a. Determine the variable cost per unit and the total fixed cost. Round your answer for variable cost to the nearest cent. Round your answer for total fixed costs to the nearest dollar. Total Costs per unit Total cost for 86,000 units: $30,307,500 32,745,000 35,745,000 b. Based on part (a), estimate the total cost for 86,000 units of production. Round your answer to the nearest dollar.
The following data have been extracted from the records of Puzzle Incorporated: Production level, in units Variable costs Fixed costs Mixed costs Total costs Required A Required B Required: a. Calculate the missing costs. b. Calculate the cost formula for mixed cost using the high-low method. c. Calculate the total cost that would be incurred for the production of 12,880 units. d. Identify the two key cost behavior assumptions made in the calculation of your answer to part c. Required C Production level, in units Variable costs Fixed costs Mixed costs Total costs Complete this question by entering your answers in the tabs below. Calculate the missing costs. Note: Do not round intermediate calculations. February 9,200 $ 19,320 ? 16,312 $ 71,532 February 9,200 $ 19,320 $ 2 X 16,312 $ 71,532 Required D August August 20, 240 $? 35,900 ? $ 106,970 Answer is not complete. 20,240 34,255 35,900 52,475 $ 106,970
The Connors Company has assembled the following data pertaining to certain costs that cannot beeasily identified as either fixed or variable. Connors Company has heard about a method of measuringcost functions called the high-low method and has decided to use it in this situation.A company has heard about a method of measuring cost functions called the regression analysis and hasdecided to use it in this situation.Cost Hours$23,000 5,000$26,000 6,450$34,600 7,650$42,000 10,000$38,000 9,350What is the estimated total cost at an operating level of 9,000 hours?A) $34,200B) $38,200C) $41,400D) $37,800 Work question #7 using regression analysis
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…
Build a spreadsheet: Construct and excel spreadsheet to solve all of the preceding requirements. Show how both cost schedules and the income statement will change if raw material purchases amounted to $190,000 and indirect labor was $20,000.
ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A% merica AS... rk i Required information Use the following information for the Problems below. (Algo) [The following information applies to the questions displayed below.] Trini Company set the following standard costs per unit for its single product Direct materials (30 pounds @ $5.00 per pound) $ 150.00 98.00 Direct labor (7 hours @ $14 per hour) Variable overhead (7 hours @ $7 per hour) Fixed overhead (7 hours @ $9 per hour) Standard cost per unit Production (in units) Standard direct labor hours (7 DLH per unit) Budgeted overhead (flexible budget) Fixed overhead Variable overhead Overhead is applied using direct labor hours. The standard overhead rate is based on a predicted activity level of 80% of the company's capacity of 51,000 units per quarter. The following additional information is available. 49.00 63.00 $360.00 70% 35,700 249,900 Direct materials (1,377,000 pounds @ $5.00 per pound)…
The MTN Company has assembled the following data pertaining to certain costs which cannot be easily identified as either fixed or variable. MTN has heard about a method of measuring cost functions called the high-low method and has decided to use it in this situation Cost Hours $100,000 3,500 61,o00 2,000 85,000 2,600 78,200 2,450 91,000 3,000 110,400 3,900 106,000 3,740 93,000 3,380 Calculate the variable cost per hour Calculate the total fixed costs Write the equation which measures the cost behavior of the costs Calculate the operating costs for 3,750
Convert the accompanying database to an Excel table to find: a.The total cost of all orders. b. The total quantity of airframe fasteners purchased. c. The total cost of all orders placed with Manley Valve.