$!$

Required information

$[$The following information applies to the questions displayed below.$]$

These questions relate to the Integrated Analytics Case: Bene Petit. Select the appropriate eBook link to open the Case

Overview, Case Background, and Part $2$: Product and Service Costing.

For this assignment, assume that Bene Petit has completed its first year of full$-$scale operations $($not counting the pilot and

start$-$up phase of the business$).$ Taylor has hired an intern $($graduate student$)$ to compile weekly operating data for the first

year, including total sales revenue, total operating costs, and several potential cost drivers. The intern has identified seven

potential cost drivers, including direct labor hours, new menu items developed, number of deliveries $($customer meals$),$

number of bulk shipments for donated meals, total meals produced $($including the donated meals$),$ total meals sold, and

total meals donated. The intern has provided you with an Excel file $($that has not been reviewed for errors$)$ that includes all

the possible cost drivers.

Run a multiple regression that includes five possible cost drivers. You should omit any redundant variables that are perfectly

correlated.

a$.$ What percentage of the total variation in operating cost can be explained by all five cost drivers combined?

Note: Round your answer to the nearest whole percentage.Use the multiple regression model to predict the total annual operating cost for next year if the company expects $170,000$ total

meals produced $($donated and customer meals combined$),8,000$ direct labor hours, $30,000$ meal kits delivered, $150$ new menu items,

and $750$ shipments of donated meals.

Be sure to multiply the intercept by $52$ weeks to convert from weekly to annual fixed cost.

Note: Round your final answer to the nearest $$10,000($to avoid rounding errors in the individual coefficients$).$

Total annual operating cost for next year