Apply the same steps in Lab $3\mathrm{.}5$ to Lab $3\mathrm{.}5$ Alt Data xIsx to perform cost driver analysis for the service call center at Thrustmaster. Thrustmaster is a fictitious company that sells game controllers, joysticks, steering wheels for PC$\text{'}$s$,$ and XBOX, Nintendo, and PlayStation consoles.

Thrustmaster is trying to understand its overhead allocation for the call center that supports its sales. It believes that by understanding the overhead costs and their respective cost drivers, the company will be in a better position to allocate overhead to the various products that require more service. Management is considering these four potential cost drivers:

$1.$ Customer call minutes

$2.$ Customer complaints

$3.$ Average workers

$4.$ Company sales

Required:

$1.$ Using regression analysis and choosing from several potential cost drivers, derive the cost drivers that are significant predictors of overall overhead costs and can be used to help allocate overhead. Set alpha to $5\%,$ or $0\mathrm{.}05.$

$2.$ Derive the formula for allocating overhead $($the regression line equation$).$

$3.$ Compare the estimated overhead per month to actual overhead per month using a scatterplot.

Data: Alt Lab $3\mathrm{.}5$ Data.xIsx

Specify the Question: How can we use regression analysis to find cost drivers and derive a formula for allocating overhead?

Obtain the Data: This lab uses the data in Alt Lab $3\mathrm{.}5$ Data xIsx. This dataset contains information for potential cost drivers.

Analyze the Data: Alternate Labs don't have step$-$by$-$step instruction or video support. Apply your experience from the original lab. If needed, reference the text or eBook for instructions and steps from the original lab.