Question 1.)

for store 10, the burgers served = 9164 and the total cost of materials equals $14409. if the number of burgers served doubles to $18328, what would you expect the total costs of materials to be using correlation analysis?

Question 2.)

fill in the high- low estimated costs in column D and calculate what the High-low estimated value would be.

Question 3.)

fill in the regression estimated costs in column E and present the Intercept (a) and coefficent (b) from the regression output.

Question 4.)

calculate the differences between the regression estimated costs and the actual costs and report them in Column F. next, add the sum of the differences and report that number.

\begin{tabular}{|c|c|c|c|c|c|} \hline \begin{tabular}{l} Jume 2023 cost \\ re port for Krusty \\ Krab Burger \end{tabular} & Served(x)Burgers & Materials(M)TotalCostof & \begin{tabular}{l} High-Low Method \\ Estimated costs \end{tabular} & \begin{tabular}{l} Regression Method \\ Estimnted Costs (i.e.. \\ Predicted) \\ \end{tabular} & \begin{tabular}{l} Differe nce (Estimated \\ wing Regression - \\ Actual Costs) \end{tabular} \\ \hline \begin{tabular}{|l|l|} Swere 1 \\ \end{tabular} & 7.54 & 10297 & & & \\ \hline Store 2 & 8,604 & 10202 & & - & \\ \hline Sore 3 & 9,009 & 13,855 & & & \\ \hline Store 4 & 7,742 & 12319 & & & \\ \hline Store 5 & 9.588 & 11.044 & & & \\ \hline Stre 6 & 8,826 & 11,999 & & & \\ \hline Spre? & 4.779 & 9.031 & & & \\ \hline Store 8 & 4,739 & 6.857 & & & + \\ \hline Snre? & 5275 & 8.076 & & & \\ \hline Store 10 & 9,164 & 14,049 & & & + \\ \hline Stare 11 & 3.138 & 5.420 & & & \\ \hline Spre 12 & 3,461 & 3969 & & & \\ \hline Spre 13 & 4699 & 7.500 & - & & \\ \hline Stare 14 & 9.361 & 12580 & & & \\ \hline Sore 15 & 5077 & 10.746 & & & \\ \hline Swre 16 & 8915 & 13,472 & & & i. \\ \hline Sore 17 & 7,112 & 11,335 & + & & \\ \hline Sore 18 & 698 & 9,813 & & E & \\ \hline Spre 19 & 8084 & 10.672 & & & \\ \hline Sore 20 & 5023 & 7254 & & & \\ \hline Stere 21 & 3537 & 6.499 & & & \\ \hline Sere 22 & 7,72 & 10,557 & & & \\ \hline Sxat 23 & -01 & 9450 & & & \\ \hline Sexte 24 & 6,208 & 9,172 & & & \\ \hline Sere 75 & -081 & 8231 & & & \\ \hline Sere 26 & 3551 & 638 & & & \\ \hline & 8651 & 9.97 & & & \\ \hline Strea 28 & 9.368 & 10314 & + & & \\ \hline Strre 29 & 5975 & 3.S52 & + & & \\ \hline Stare 30 & 8088 & 10,953 & & & +2 \\ \hline & & & & Sum of Deftencts & \\ \hline \end{tabular}