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:

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:

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

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?
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.
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 Total Costs 2,100 3,770 5,600 $245,700 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
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)…
akeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false Up eBook Show Me How Print Item 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: Units Produced Total Costs 80,000 $25,100,000 92,000 27,206,000 120,000 32,120,000 a. Determine the variable cost per unit and the total fixed cost. Variable cost (Round to two decimal places.) %24 per unit Total fixed cost b. Based on part (a), estimate the total cost for 115,000 units of production. Total cost for 115,000 units Check My Work 4 more Check My Work uses remaining. Previous Next
need answers for 1,2,3 and 4 4. Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how both cost schedules and the income statement will change if the following data change: direct labor is $390,000 and utilities cost $35,000.
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?
meducation.com/ext/map/index.html?_con=con&external_browser=0&launch Url=https%253A%252F %252Fne S... 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) 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 o the company's capacity of 51,000 units per quarter. The following additional information is available. $ 150.00 98.00 49.00 63.00 $360.00 70% 35,700 249,900 $ 2,570,400 $1,749,300 Direct materials (1,377,000 pounds @ $5.00 per pound) Direct labor…
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…
A known manufacturing company has estimated the ff. Component for a new product. Fixed cost= 50,000 Material cost per unit= 2.15 Labor cost per unit = 2 Revenue per unit= 7.50 Vary the production volume from 0 to 100,000 in increments of 10,000. The five different material costs are 1.50,1.95,2.15,2.85 and 3.25. Using the spreadsheet model, what will be the resulting profit if the company decides to make 70,000 units of the new product. Choices: A.623,018 B.176,400 C.45,705 D.No choice given E.138,430
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.