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.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter28: Statistics And Linear Regression (stats)

Section: Chapter Questions

Problem 4R

See similar textbooks

Similar questions

An analyst has started preparing a spreadsheet as shown below. Column A contains the headings for various parameters and Column B contains the analyst's range names to be used in Excel. A 1 Price per Unit 2 Cost per Unit 3 Profit per Unit Price_per_Unit Cost per Unit Profit$_per_Unit 4. 5 Fixed Costs 6 Variable Costs Fixed Costs VariableCosts Label each of the following range names as "Correct" if is a valid range name in Excel or "Incorrect" if the range name is not valid for use in Excel. Proposed Range Name Price_per_Unit Cost per Unit Profit$_per_Unit Fixed Costs VariableCosts
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
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 97,500 $27,165,000 112,500 29,715,000 124,500 31,755,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 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: $fill in the blank 2 per unit Total fixed cost: $fill in the blank 3 Based on part (a), estimate the total cost for 80,000 units of production. Round your answer to the nearest dollar. Total cost for 80,000 units: $fill in the blank 4
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?
UPVOTE WILL BE GIVEN! INPUT THE COMPLETE SOLUTIONS. YOU MAY USE EXCEL. BOX THE FINAL ANSWERS. d. How much is the total cost for completed units? e. How much is the total cost to be accounted for?
UPVOTE WILL BE GIVEN! INPUT THE COMPLETE SOLUTIONS. YOU MAY USE EXCEL. BOX THE FINAL ANSWERS. a. Calculate the total units to be accounted for. = b. Calculate the Equivalent Units of Production - Materials. = c. How much is the conversion cost per unit? =
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:
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
UPVOTE WILL BE GIVEN! INPUT THE COMPLETE SOLUTIONS. YOU MAY USE EXCEL. BOX THE FINAL ANSWERS. a. Calculate the Equivalent Units of Production - Conversion Cost. = b. Calculate for the total material cost per unit =
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.
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?
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