The same question but the last 2, I have calculated the same way as the 1st year and I keep getting it incorrect.
Malameter Manufacturing provides on-site repairs for its fabrications. Management would like to perform a cost analysis of these repairs. Because outliers are relatively rare, management is okay with seeing a basic analysis. Below is cost information from last year.
\begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|l|}{3} \\ \hline 4 & Month & Repairs & Cost of Repairs & & \\ \hline 5 & January & 351 & 4,910 & & \\ \hline 6 & February & 111 & 1,948 & & \\ \hline 7 & March & 457 & 6,315 & & \\ \hline 8 & April & 584 & 7,800 & & \\ \hline 9 & May & 250 & 3,619 & & \\ \hline 10 & June & 86 & 1,583 & & \\ \hline 11 & July & 370 & 4,710 & & \\ \hline 12 & August & 68 & 1,457 & & \\ \hline 13 & September & 571 & 7,142 & & \\ \hline 14 & October & 520 & 7,017 & & \\ \hline 15 & November & 160 & 2,184 & & \\ \hline 16 & December & 382 & 5,047 & & \\ \hline 17 & & 451 & 6,258 & & \\ \hline \multicolumn{6}{|l|}{18} \\ \hline 19 & Required: & & & & \\ \hline 20 & \multicolumn{5}{|c|}{ Use the High-Low Method and MIN(), and MAX() functions to answer the following questions: } \\ \hline 21 & & & & & \\ \hline 22 & \multicolumn{3}{|c|}{ What is the highest cost? } & $7,800 & \\ \hline 23 & \multicolumn{3}{|c|}{ What is the highest number of repairs? } & 584 & \\ \hline 24 & \multicolumn{3}{|c|}{ What is the lowest cost? } & $1,457 & \\ \hline 25 & \multicolumn{3}{|c|}{ What is the lowest number of repairs? } & 682 & \\ \hline 26 & \multicolumn{3}{|c|}{ Compute the Variable Cost per repair. } & $12.290 & \\ \hline 27 & \multicolumn{3}{|c|}{ Compute the Fixed Cost. } & $621.10 & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline 19 & Required: & \\ \hline 20 & \multicolumn{2}{|c|}{ Use the High-Low Method and MIN(), and MAX() functions to answer the followin } \\ \hline 21 & & \\ \hline 22 & What is the highest cost? & 7.800 \\ \hline 23 & What is the highest number of repairs? & 584 \\ \hline 24 & What is the lowest cost? & 1,457 \\ \hline 25 & What is the lowest number of repairs? & 68 \\ \hline 26 & Compute the Variable Cost per repair. & 12.29 \\ \hline 27 & Compute the Fixed Cost. & =D22(D26D23) \\ \hline \end{tabular} \begin{tabular}{l} What is the highest cost? \\ What is the highest number of repairs? \\ What is the lowest cost? \\ What is the lowest number of repairs? \\ \hline Compute the Variable Cost per repair. \\ Compute the Fixed Cost. \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline 29 & \multicolumn{5}{|c|}{ Repeat this process with information from two years prior. } \\ \hline \multicolumn{6}{|l|}{30} \\ \hline 31 & Month & Repairs & \multicolumn{2}{|c|}{ Cost of Repairs } & \\ \hline 32 & January & 391 & $ & 6,366 & \\ \hline 33 & February & 439 & $ & 6,737 & \\ \hline 34 & March & 359 & $ & 5,503 & \\ \hline 35 & April & 261 & $ & 3,886 & \\ \hline 36 & May & 242 & $ & 3,576 & \\ \hline 37 & June & 342 & $ & 5,327 & \\ \hline 38 & July & 156 & $ & 2,941 & \\ \hline 39 & August & 399 & $ & 6,819 & \\ \hline 40 & September & 398 & $ & 5,708 & \\ \hline 41 & October & 151 & $ & 2,919 & \\ \hline 42 & November & 319 & $ & 4,947 & \\ \hline 43 & December & 189 & $ & 3,546 & \\ \hline 44 & & 212 & $ & 3,694 & \\ \hline \multicolumn{6}{|l|}{45} \\ \hline 46 & \multicolumn{4}{|c|}{ What is the highest cost? } & $6,819 \\ \hline 47 & \multicolumn{4}{|c|}{ What is the highest number of repairs? } & 439 \\ \hline 48 & \multicolumn{4}{|c|}{ What is the lowest cost? } & $2,919 \\ \hline 49 & \multicolumn{4}{|c|}{ What is the lowest number of repairs? } & 151 \\ \hline 50 & \multicolumn{4}{|c|}{ Compute the Variable Cost per repair. } & $13.54 \\ \hline 51 & \multicolumn{4}{|c|}{ Compute the Fixed Cost. } & $(12,763.79) \\ \hline \end{tabular} \begin{tabular}{l} What is the highest cost? \\ What is the highest number of repairs? \\ What is the lowest cost? \\ What is the lowest number of repairs? \\ \hline Compute the Variable Cost per repair. \\ Compute the Fixed Cost. \end{tabular} \begin{tabular}{l|r|r|} \hline & 212 & $ \\ \hline What is the highest cost? \\ What is the highest number of repairs? \\ What is the lowest cost? \\ What is the lowest number of repairs? \\ \hline Compute the Variable Cost per repair. & 2,919 \\ \hline Compute the Fixed Cost. & =-D 46(D50D47) \\ \hline \end{tabular}
