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
CVP computations. Fill in the blanks for each of the following independent cases.
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
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
Assume the following information:VolumeTotal Cost100 units$1,30090 units1,500106 units1,750What is the variable cost per unit? (Round answer to three decimal places.)a. $28.125b. $15.625c. $20.178d. $13.175
46.) Given the following information, choose the cost and activity that would be used as the high data point in high-low cost estimation: Costs (P) Activity (hours)48 000 41 50049 000 42 00057 000 42 50056 000 43 00055 000 43 500Group of answer choices P57 000 and 42 500 hours P55 000 and 42 500 hours P57 000 and 43 500 hoursP55 000 and 43 500 hours P55 000 and 43 000 hours P56 000 and 43 500 hours
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.
Please do not give solution in image format thanku

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