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

Another question on Business

Business, 22.06.2019 11:00

Abank provides its customers mobile applications that significantly simplify traditional banking activities. for example, a customer can use a smartphone to take a picture of a check and electronically deposit into an account. this unique service demonstrates the bank’s desire to practice which one of porter’s strategies?

Answers: 3

Answer

Business, 23.06.2019 08:20

Analyze the forces in the marketing environment that have contributed to pinterest’s explosion in popularity?

Answers: 3

Answer

Business, 23.06.2019 11:30

What features makes up a good budget

Answers: 2

Answer

Business, 23.06.2019 14:30

You receive a memo from the vice president of procurement responding to your query. he writes: â€śit will be very important to maintain product continuity. we have a large base of devoted customers. we want to make sure that the quality and key characteristics of island knight stay the same through this transition. talk to frank, our consulting professional perfumer, for more information about the cologne. seasonal variations in costs are the single most significant factor in our deciding to go with another supplier, so finding a way to limit that should be the top priority. the overall marginal costs and shipping costs are probably somewhat less significant. you may want to talk to cindy, the product manager for island knight, regarding pricing information about the product.â€ť what is the best action to take next?

Answers: 3

Answer

You know the right answer?

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

Questions