You have just been hired as a consultant to a large manufacturing company of sodas, and have decided to use your new MBA skills to make a recommendation

to management on what should be the cost driver(s) for estimating the monthly overhead cost for one of the plants that manufactures this drink outside the United States.

Volume of liquid produced hectoliters	Water used in hectoliters	Number of Batches	Total Overhead costs for the plant
890	6,005	54	$57,266
980	6,588	58	61,020
1,094	7,336	65	64,622
1,212	8,002	73	68,630
1,262	8,435	75	70,653
1,494	9,940	89	79,927
1,557	10,420	95	82,867
1,528	10,326	94	81,748
1,215	8,284	72	68,819
1,145	7,746	69	66,375
1,072	7,168	64	63,767
1,032	6,933	62	62,545
872	5,902	50	56,837
1,006	6,759	60	61,298

Assuming the following level of cost-driver volume for the month, what is the estimated

volume of liquid produced 1499

Water used 10299

Number of Batches 92

Volume of liquid produced to estimate overhead cost 80140.42

Please help find following use the simple regression output to cell reference

and used the intercept as the fixed cost

and the X variable as the variable cost.

Water used ?

Number of Batches ?

Multiple regression ?

Using the simple and multiple regression analyses analysis you performed, what independent variable(s) would you recommend

to estimate the Overhead Costs? Why? You need to provide and discuss the specific R-squared provided in your analysis for each independent variable and multiple variables.

Your response must be a detailed recommendation of why you provided that recommendation and include a discussion of the R-Squared along with providing the specific R-squared results.