90.2K

Verified Solution

Link Copied!

Travis Country owns $21$ specialty farm supply stores throughout much of the country. Their fiscal year runs July $1$ to June $30.$ As purchasing department costs continue to increase, Travis Country$$s Controller, Kim Sanchez, has decided to investigate the relationship of three different potential drivers of this cost to determine which factor has the strongest influence on purchasing department costs. She can then focus the corporate manager of purchasing operations on controlling or streamlining those activities to control the subsequent costs. Your task is to determine what data should be included, calculate the relationships with each of the three drivers $($put output on different tabs$)$ and determine the best relationship $($using our methods of evaluation$).$ On the tab with the output of your preferred model, in a cell below the output, write the mathematical cost function you have derived $($show how that driver impacts the costs$),$ substituting in the name of your chosen driver for the X and putting in the appropriate name for the Y$.$ Name the tab$/$worksheet containing your preferred model with your first and last name.

$$

Optional bonus half point: If you choose to learn how to address this with a multivariate model, also identify the best multivariate model using a combination of two or three drivers. On your preferred model, in a cell below the output, write the mathematical cost function you have derived, substituting in the drivers for the Xs$.$ Name the tab worksheet containing your preferred model with $$BONUS$.$

Answer & Explanation Solved by verified expert

See Answer