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

Refer to the information for Farnsworth Company (p. 139) for the first 10 months of data on receiving orders and receiving cost. Now suppose that Tracy has gathered 2 more months of data: Note: For the following requirements, round the intercept terms to the nearest dollar, round the variable rates to the nearest cent, and R2 to two decimal places. Required: 1. Run two regressions using a computer spreadsheet program such as Excel. First, use the method of least squares on the first 10 months of data. Then, use the method of least squares on all 12 months of data. Write down the results for the intercept, slope, and R2 for each regression. Compare the results. 2. CONCEPTUAL CONNECTION Prepare a scattergraph using all 12 months of data. Do any points appear to be outliers? Suppose Tracy has learned that the factory suffered severe storm damage during Month 11 that required extensive repairs to the receiving areaincluding major repairs on a forklift. These expenses, included in Month 11 receiving costs, are not expected to recur. What step might Tracy, using her judgment, take to amend the results from the method of least squares? 3. CONCEPTUAL CONNECTION Rerun the method of least squares, using all the data except for Month 11. (You should now have 11 months of data.) Prepare a cost formula for receiving based on these results, and calculate the predicted receiving cost for a month with 1,450 receiving orders. Discuss the results from this regression versus those from the regression for 12 months of data.
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.
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:
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
Given the following cost and activity observations for Leno Enterprises'utilities, use the high-low method to calculate Leno's variable utilities cost permachine hour. Cost Machine HoursSeptember £4,100 22,000October £3,700 18,000November £3,900 19,000December £4,500 28,000a) £0.08b) £4.86c) £0.25d) £12.50
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
Uninder Company uses the high-low method to estimate the cost function. The information for 2017 is provided below: Machine-hours Labor Costs Highest observation of cost driver 550 $22,000 Lowest observation of cost driver 250 $13,000 What is the slope coefficient? Select one: a. $30.00 b. $40.00 c. $43.75 d. $52.00
Use the data to prepare the cost statement and income statement by use the variable cost . The production capacity ( 8 000 )unit , the seal price ( 2000 ) to unit . Direct materials ( 176000) Direct wages ( 128000 ). Direct expenses ( 132000 ) Indirect expenses ( 132000 ). ( 100 000 v. , 32 000 f. ). Marketing cost v. ( 100 000 )D. Administration cost 60000 D. Indirect marketing f. ( 100 000). The balance of f. g. f. ( 2500 ) unit , and the balance of f. g. l. ( 1000 ) unit . The number of sales unit ( ? ) unit
The Perize Corporation used regression analysis to predict the annual cost of indirect materials. The results were as follows: Indirect Materials Cost Explained by Units Produced Constant $15,685 Standard error of Y estimate $3,500 r2 0.7832 Number of observations 20 X coefficient(s) 10.25 Standard error of coefficient(s) 2.1876 What is the cost function? Select one: a. Y = $19,185 + $4.48X b. Y = $15,685 + $10.25X c. Y = $12,285 + $10.25X d. Y = $3,500 + $5.15X
Pharma Hill Company accumulates the following data for the period of six months:Unit Heat expenseJanuary 2400 4,000February 2300 4,300March 2200 4,200April 2000 4,000May 1800 3,800June 1900 3,900Required:a) Separate the variable and fixed elements using high-low method.b) Express this cost behavior in equation formc) Calculate heat expense at 2100 units.
Crane Company accumulates the following data concerning a mixed cost, using miles as the activity level. Miles Driven Total Cost Miles Driven Total Cost January 7995 14180 March 8510 14909 February 7505 13502 April 8200 14495 a/ Compute the variable cost per mile using the high-low method. (Round answer to 2 decimal places) Variable cost per mile b/ Compute the fixed cost elements using the high-low method. Fixed costs
The following data points are available. This is an example of a ________ cost. Units Costs600 $560650 $565800 $580900 $590A) variable B) fixed C) mixed D) 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