A company has the following historical cost information for the past 4 quarters:UnitsCostsQ11681$47023Q21133$42223Q31109$40854Q41129$42494$ 34.160Use Microsoft Excel to calculate the following items with the most accuracy possible:Variable cost perper minimum precision:unitthousandths placeunitFixed costs in$ 31341minimum precision:totalones placeR Squaredminimum precision:thousandths placePlease put an answer in each input field.

Step 1: Perform regression analysis on excel.Step 2: Obtain the summary output in a new tab. Step 3:…

Answered: A company has the following historical…

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

Felix & Company reports the following information. Period Units Produced Total Costs 1 0 $2,595 2 400 3,235 3 800 3,875 4 1,200 4,515 5 1,600 5,155 6 2,000 5,795 7 2,400 6,435 8 2,800 7,075 9 3,200 7,715 10 3,600 8,355 Use spreadsheet software to use ordinary least-squares regression to estimate the cost equation, including fixed and variable cost amounts.
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?
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
An analyst built the following spreadsheet, complete with named ranges (for example, cell B2 is named "Unit_Price" based on the heading in cell A2). A 2 Unit Price 11 3 Unit Cost 5.55 4. Unit Gross Profit Unit_Price Unit_Cost Quantity Sold 5,600 8 Gross Revenue = Quantity_Sold x Unit_Price Variable Costs = Quantity_Sold x Unit_Cost 9 10 Fixed Costs 2,500 11 Net Profit = Gross Revenue - Variable Costs Fixed Costs 12 Profit per Unit = Net_Profit/Quantity_Sold After entering the data shown below in cells B2, B3, B6, and B10, what values should appear in the following cells? (Round your "Unit Gross Profit and Profit per Unit" answers to 2 decimal places.) Cell Value B4 (Unit_Gross_Profit) B8 (Gross_Revenue) B9 (Variable_Costs) B11 (Net Profit) B12 (Profit_per_Unit)
Need help with weighted aver. cont. margin and if you can list the formula as well.
Your boss would like you to estimate the fixed and variable components of a particular cost Actual data for this cost over four recent periods appear below. Activity Cost Period 1 22 235 Period 2 23 243 Period 3 25 255 Period 4 20 227 Using the least-squares regression method, what is the cost formula for this cost? Y = P107.45 + P5.89X O Y = P0.00 + P10.67X O Y = P111.92 + P5.69X O Y = P120.81 + P3.56X
Answer this cost accounting question
The "x" in the overhead cost equation, y = $5.50x + $92,000, represents which of the following? total overhead costs. the variable costs. total fixed costs. the cost driver in units.
Smoky Mountain Corporation makes two types of hiking boots-the Xtreme and the Pathfinder. Data concerning these two product lines appear below: Xtreme $ 121.00 $ 64.70 $ 10.80 Pathfinder Selling price per unit Direct materials per unit Direct labor per unit Direct labor-hours per unit Estimated annual production and sales $ 88.00 $ 54.00 %24 9.00 1.0 DLHS 71,000 units 1.2 DLHS 25, 000 units The company has a traditional costing system in which manufacturing overhead is applied to units based on direct labor-hours. Data concerning manufacturing overhead and direct labor-hours for the upcoming year appear below: Estimated total manufacturing overhead Estimated total direct labor-hours $ 2,020,000 101,000 DLH5 Required: 1. Compute the product margins for the Xtreme and the Pathfinder products under the company's traditional costing system. 2. The company is considering replacing its traditional costing system with an activity-based costing system that would assign its manufacturing…
Please do not give solution in image format thanku
... Question 4 QUIZ - CH 05 Exe ezto.mheducation.com Your Texas Benefits... G Google Sy simplify 28(x)=8700... myLoneStar Login CH 05 Exercises & Problems (Algo) i PƏAES Exercise 5-8 (Algo) Equivalent Units; Cost per Equivalent Unit; Assigning Costs to Units-Weighted- Average Method [LO5-2, LO5-3, LO5-4] Hellx Corporation uses the welghted-average method In Its process costing system. It produces prefabrlcated flooring In a serles of steps carrled out in production departments. All of the materlal that Is used In the first production department Is added at the beginning of processing In that department. Data for May for the first production department follow: Percent Complete Units Materials Conversion Work in process inventory, May 1 Work in process inventory, May 31 Materials cost in work in process inventory, May 1 Conversion cost in work in process inventory, May 1 Units started into production Units transferred to the next prdduction department Materials cost added during May…
sing the following data, apply the high-low method of cost analysis to the three cost data groups: Volume Alpha Beta Gamma 2,000 $6,600 $2,400 $8,000 6,000 $9,800 $7,000 $8,000 13,000 $13,000 $12,000 $8,000 20,000 $21,000 $24,000 $8,000 What cost behavior patterns are apparent for Beta? Select one: a. Fixed b. Variable c. Mixed d. Semi-fixed e. None of the above

SEE MORE QUESTIONS

Recommended textbooks for you

Principles of Cost Accounting

Accounting

ISBN:

9781305087408

Author:

Edward J. Vanderbeck, Maria R. Mitchell

Publisher:

Cengage Learning

Managerial Accounting: The Cornerstone of Busines…

Accounting

ISBN:

9781337115773

Author:

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

Publisher:

Cengage Learning

Principles of Cost Accounting

Accounting

ISBN:

9781305087408

Author:

Edward J. Vanderbeck, Maria R. Mitchell

Publisher:

Cengage Learning

Managerial Accounting: The Cornerstone of Busines…

Accounting

ISBN:

9781337115773

Author:

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

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS