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: 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.

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: 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.

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter3: Cost Behavior And Cost Forecasting

Section: Chapter Questions

Problem 41E: Examine the graphs in Exercise 3-40. Required: As explained in the chapter, cost behavior patterns...

See similar textbooks

Similar questions

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
Please donot provide solution in image format and provide step by step format and provide solution asap
Can you provide step by step solution for every requirement?
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
Q2. PPLC Company has two support departments, SD1 and SD2, and two operating departments, ODI and OD2. The company decided to use the direct method and allocate variable SD1 dept. costs based on the number of transactions and fixed SD1 dept. costs based on the number of employees. SD2 dept. variable costs will be allocated based on the number of service requests, and fixed costs will be allocated based on the number of computers. The following information is provided: (4 Marks) (Chapter 8, Week 10) Support Departments Operating Departments SD1 SD2 ODI OD2 Total Department variable costs 18,000 19,000 51,000 35,000 Total department fixed costs 20,000 24,000 56,000 30,000 Number of transactions 30 40 200 100 Number of employees 14 18 35 30 Number of service requests 28 18 35 25 Number of computers 15 20 24 28 You are required to allocate variable and fixed costs using direct method.
Please do not give solution in image format thanku
Q3. ADLG Company has two support departments, SS1 and SS2, and two operating departments, OD1 and OD2. The company has decided to use the direct method and allocate variable SS1 dept. costs based on the number of transactions and fixed SS1 dept. costs based on the number of employees. SS2 dept. variable costs will be allocated based on the number of service requests and fixed costs will be allocated based on the number of computers. The following values have been extracted for the allocation | Total Department variable costs Total department fixed costs Number of transactions Number of employees Number of service requests Number of computers Support Departments SS1 16,000 19,500 50 18 37 20 SS2 19,000 34,000 You are required to allocate variable and fixed costs. 55 24 22 25 Operating Departments OD1 105,000 120,000 250 47 26 31 OD2 68,000 55,000 140 38 32 37
For the ERPSim manufacturing game in SAP what should be the prices for 6 flavors of Museli and what should be the sales forecast and loan amount that needs to paid and what should be the amount to be paid for set up time and increasing production capacity? If possible, can you please add a template for loan and price calculator?
Choose the correct letter of answer On a scattergrap, the diagonal line cuts across two sets of observations, namely: 600:200, and 900:500 which refer to costs and units, respectively. The fixed costs is plotted in the graph at P400. In this case, the variable cost per unit is equal to: a. P1.00b. P1.25c. P1.50d. P1.12
IN EXCEKL FORMAT
Convert the accompanying database to an Excel table to find: a.The total cost of all orders. b.Thetotal quantity of airframe fasteners purchased. c. The total cost of all orders placed with Manley Valve. Question content area bottom Part 1 a. The total cost of all orders is $?????? enter your response here.
Please answer completely and correctly with explanation computation formula steps answer in text no copy paste from other answers show explanation and computation clearly for numbers provide full working for all steps with explanation answer in text form