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

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
The following computer printout was generated, using regression, for use in estimating maintenance costs. Intercept 8300 X Variable 1 37 Multiple R 0.9500 R Square 0.9025 Activity variable machine hours An estimate of maintenance costs at an activity level of 100 machine hours would be:
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 500 49 000 42 000 57 000 42 500 56 000 43 000 55 000 43 500 O P57 000 and 43 500 hours O P55 000 and 43 000 hours O P55 000 and 42 500 hours O P55 000 and 43 500 hours O P57 000 and 42 500 hours O P56 000 and 43 500 hours
IN EXCEKL FORMAT
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
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.
The table shows cost, C (q), and revenue, R (q). What are the fixed costs? Fixed costs = i 9 R(q) C(q) 0 0 2500 3000 2500 5000 7500 10000 12500 15000 500 1000 1500 2000 6000 6500 7000 7500 9500 11500 14250
cator=&inprogress3Dfalse Calculator Calculate the per-unit contribution margin of a product that has a sale price of $420 if the variable costs per unit are $160. Contribution margin $ per unit
K In the equation y = $7.20x + $250,250, O A. $250,250 are the total costs. OB. $250,250 are the total fixed costs. OC. $250,250 are the total overhead costs. OD. $250,250 are the total variable costs. 4
6
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

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