Business, 24.06.2020 05:01 katrinajernae7008

An important application of regression analysis in accounting is in the estimation of cost. By collecting data on volume and cost and using the least squares method to develop an estimated regression equation relating volume and cost, an accountant can estimate the cost associated with a particular manufacturing volume. In the Microsoft Excel Online file below you will find a sample of production volumes and total cost data for a manufacturing operation. Conduct a regression analysis to explore the relationship between total cost and production volume and then answer the questions that follow. Production Volume Total Cost (Units) ($)
400 4,000
450 5,000
550 5,400
600 5,900
700 6,400
750 7,000
1. Use the data to develop an estimated regression equation that could be used to predict the total cost for a given production volume.
2. What is the variable cost per unit produced
3. Compute the coefficient of determination what percentage of the variation in total cost can be explained by production volume
4. The companys production schedule shows 500 units must be produced next month what is the estimated total cost of this operation.

Answers: 2

Show answers

Other questions on the subject: Business

Business, 22.06.2019 00:40, tenleywood

The silverside company is considering investing in two alternative projects: project 1 project 2 investment $500,000 $240,000 useful life (years) 8 7 estimated annual net cash inflows for useful life $120,000 $40,000 residual value $32,000 $10,000 depreciation method straightminusline straightminusline required rate of return 11% 8% what is the accounting rate of return for project 2? (round any intermediary calculations to the nearest dollar, and round your final answer to the nearest hundredth of a percent, x. xx%.)

Answers: 3

continue

Business, 22.06.2019 07:30, 2016gbryant

Jordan, inc. sells fireworks. the company’s marketing director developed the following cost of goods sold budget for april, may, june, and july. april may june july budgeted cost of goods sold $62,000 $72,000 $82,000 $88,000 jordan had a beginning inventory balance of $3,000 on april 1 and a beginning balance in accounts payable of $14,600. the company desires to maintain an ending inventory balance equal to 15 percent of the next period’s cost of goods sold. jordan makes all purchases on account. the company pays 65 percent of accounts payable in the month of purchase and the remaining 35 percent in the month following purchase. required prepare an inventory purchases budget for april, may, and june. determine the amount of ending inventory jordan will report on the end-of-quarter pro forma balance sheet. prepare a schedule of cash payments for inventory for april, may, and june. determine the balance in accounts payable jordan will report on the end-of-quarter pro forma balance sheet.

Answers: 2

continue

Business, 22.06.2019 07:30, davidleew24

Jewelry manufacturers produce a range of products such as rings, necklaces, bracelets, and brooches. what fundamental economic question are they addressing by offering this range of items?

Answers: 3

continue

Business, 22.06.2019 11:00, mateoperkins

What is the advantage of developing criteria for assessing the effectiveness of business products and processes? a. assessment criteria are answers. b. assessment criteria are inexpensive. c. assessment criteria provide you with a list of relevant things to measure. d. assessment criteria provide you with a list of people to contact to learn more about process mentoring.

Answers: 3

continue

You know the right answer?

An important application of regression analysis in accounting is in the estimation of cost. By colle...