Solved

Below Are Cost and Activity Data for a Particular Cost

Question 7

Essay

Below are cost and activity data for a particular cost over the last four periods.Your boss has asked you to analyze this cost so that management will have a better understanding of how this cost changes in response to changes in activity.

 Activity  Cost  Period 146$292Period 2 40$271Period 3 42$279Period 4 41$267\begin{array}{cc}&\text { Activity } & \text { Cost } \\\text { Period 1}&46 & \$ 292 \\\text {Period 2 }&40 & \$ 271 \\\text {Period 3 }&42 & \$ 279 \\\text {Period 4 }&41 & \$ 267\end{array}

Required:
Using the least-squares regression method,estimate the cost formula for this cost.

Correct Answer:

verifed

Verified

The solution using Microsoft Excel funct...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions