Instructions:

The attached excel file includes the raw data (which has not been reviewed for errors). A second tab includes graphs that provide a visual analysis of each of the possible cost drivers against total operating cost. Review the results to determine if there are any outliers that should be corrected. It is noted that the intern has been known to have made mistakes in data entry before by entering double zeroes on accident. Also, there are no other known errors or outliers that should have occurred. Using the graphs, determine if there are any situations where this has occurred.

If any errors are discovered, they should be corrected (not deleted), and you should use the cleaned-up data file for the remainder of this assignment.

Questions:

2. Using the cleaned data, prepare a correlation matrix showing the relationship among all of the variables.

a-1. Which variable has the strongest correlation with total operating cost?

a-2. What is the correlation?

b-1. Which variable has the weakest correlation with total operating cost?

b-2. What is the correlation?

c. Does it make sense to analyze the total number of meals produced, the number of meals sold, and the number of meals donated as separate variables?

Please answer these! Thank you so much in advance!

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Week & & \begin{tabular}{l} Sales \\ enue \end{tabular} & & \begin{tabular}{l} perating \\ ost \end{tabular} & \begin{tabular}{c} Direct Labor \\ Hours \end{tabular} & \begin{tabular}{c} New Menu \\ Items \\ Developed \end{tabular} & \begin{tabular}{c} Number of \\ Deliveries \\ (Customer \\ Meals) \end{tabular} & \begin{tabular}{c} Number of \\ Deliveries \\ (Donated \\ Meals) \end{tabular} & \begin{tabular}{c} Total Meals \\ Produced \end{tabular} & \begin{tabular}{c} Customer \\ Meals Sold \end{tabular} & Meals Donated \\ \hline 1 & $ & 4,805 & $ & 3,375 & 110 & 2 & 375 & 6 & 2,746 & 1,373 & 1,373 \\ \hline 2 & $ & 3,754 & $ & 3,465 & 94 & 3 & 315 & 8 & 2,145 & 1,073 & 1,073 \\ \hline 3 & $ & 3,879 & $ & 3,564 & 98 & 3 & 325 & 8 & 2,217 & 1,108 & 1,108 \\ \hline 4 & $ & 4,555 & $ & 3,318 & 98 & 2 & 450 & 6 & 2,603 & 1,301 & 1,301 \\ \hline 5 & $ & 4,630 & $ & 3,722 & 98 & 3 & 445 & 8 & 2,646 & 1,323 & 1,323 \\ \hline 6 & $ & 5,230 & $ & 3,419 & 131 & 3 & 435 & 8 & 2,989 & 1,494 & 1,494 \\ \hline 7 & $ & 4,705 & $ & 3,412 & 105 & 2 & 465 & 6 & 2,688 & 1,344 & 1,344 \\ \hline 8 & $ & 4,505 & $ & 3,620 & 110 & 5 & 400 & 6 & 2,574 & 1,287 & 1,287 \\ \hline 9 & $ & 4,680 & $ & 3,724 & 115 & 3 & 400 & 6 & 2,674 & 1,337 & 1,337 \\ \hline 10 & $ & 4,830 & $ & 3,545 & 125 & 3 & 425 & 8 & 2,760 & 1,380 & 1,380 \\ \hline 11 & $ & 4,945 & $ & 3,646 & 140 & 3 & 440 & 8 & 2,826 & 1,413 & 1,413 \\ \hline 12 & $ & 5,305 & $ & 3,539 & 125 & 3 & 460 & 6 & 3,032 & 1,516 & 1,516 \\ \hline 13 & $ & 4,925 & $ & 3,512 & 100 & 2 & 375 & 6 & 2,814 & 1,407 & 1,407 \\ \hline 14 & $ & 4,705 & $ & 3,702 & 146 & 3 & 350 & 8 & 2,688 & 1,344 & 1,344 \\ \hline 15 & $ & 4,830 & $ & 3,829 & 101 & 5 & 460 & 8 & 2,760 & 1,380 & 1,380 \\ \hline 16 & $ & 5,455 & $ & 3,640 & 131 & 3 & 475 & 6 & 3,117 & 1,559 & 1,559 \\ \hline 17 & $ & 5,205 & $ & 3,961 & 135 & 4 & 400 & 8 & 2,974 & 1,487 & 1,487 \\ \hline 18 & $ & 4,200 & $ & 3,893 & 135 & 4 & 460 & 8 & 2,400 & 1,200 & 1,200 \\ \hline 19 & $ & 5,380 & $ & 3,517 & 135 & 3 & 450 & 8 & 3,075 & 1,537 & 1,537 \\ \hline 20 & $ & 6,381 & $ & 4,234 & 135 & 4 & 600 & 8 & 3,647 & 1,823 & 1,823 \\ \hline 21 & $ & 6,757 & $ & 4,356 & 135 & 2 & 620 & 8 & 3,861 & 1,931 & 1,931 \\ \hline 22 & $ & 5,355 & $ & 4,074 & 139 & 4 & 412 & 8 & 3,060 & 1,530 & 1,530 \\ \hline 23 & $ & 5,506 & $ & 4,057 & 141 & 3 & 440 & 8 & 3,146 & 1,573 & 1,573 \\ \hline 24 & $ & 5,506 & $ & 3,983 & 143 & 4 & 460 & 8 & 3,146 & 1,573 & 1,573 \\ \hline 25 & $ & 5,756 & $ & 3,855 & 143 & 3 & 465 & 8 & 3,289 & 1,645 & 1,645 \\ \hline 26 & $ & 6,256 & $ & 4,151 & 143 & 4 & 570 & 8 & 3,575 & 1,788 & 1,788 \\ \hline 27 & $ & 5,565 & $ & 3,718 & 131 & 2 & 400 & 8 & 3,180 & 1,590 & 1,590 \\ \hline 28 & $ & 5,656 & $ & 4,174 & 146 & 3 & 458 & 8 & 3,232 & 1,616 & 1,616 \\ \hline 29 & $ & 5,856 & $ & 3,966 & 147 & 3 & 490 & 8 & 3,346 & 1,673 & 1,673 \\ \hline 30 & $ & 6,406 & $ & 4,270 & 147 & 4 & 588 & 8 & 3,661 & 1,830 & 1,830 \\ \hline 31 & $ & 4,855 & $ & 3,808 & 150 & 3 & 300 & 8 & 2,774 & 1,387 & 1,387 \\ \hline 32 & $ & 5,506 & $ & 4,347 & 150 & 3 & 420 & 10 & 3,146 & 1,573 & 1,573 \\ \hline 33 & $ & 5,656 & $ & 4,300 & 150 & 4 & 440 & 8 & 3,232 & 1,616 & 1,616 \\ \hline 34 & $ & 5,681 & $ & 4,472 & 150 & 5 & 430 & 10 & 3,246 & 1,623 & 1,623 \\ \hline 35 & $ & 5,731 & $ & 4,098 & 150 & 4 & 475 & 8 & 3,275 & 1,637 & 1,637 \\ \hline 36 & $ & 6,006 & $ & 3,796 & 150 & 3 & 500 & 8 & 3,432 & 1,716 & 1,716 \\ \hline 37 & $ & 6,106 & $ & 3,904 & 150 & 4 & 515 & 8 & 3,489 & 1,745 & 1,745 \\ \hline 38 & $ & 6,256 & $ & 4,552 & 150 & 4 & 480 & 8 & 3,575 & 1,788 & 1,788 \\ \hline 39 & $ & 6,306 & $ & 4,457 & 150 & 4 & 540 & 10 & 3,604 & 1,802 & 1,802 \\ \hline 40 & $ & 6,406 & $ & 4,684 & 150 & 4 & 490 & 8 & 3,661 & 1,830 & 1,830 \\ \hline 41 & $ & 6,907 & $ & 4,281 & 1,500 & 4 & 650 & 8 & 3,947 & 1,973 & 1,973 \\ \hline 42 & $ & 7,107 & $ & 4,404 & 150 & 4 & 670 & 8 & 4,061 & 2,031 & 2,031 \\ \hline 43 & $ & 5,856 & $ & 4,424 & 154 & 4 & 450 & 8 & 3,346 & 1,673 & 1,673 \\ \hline 44 & $ & 6,507 & $ & 4,586 & 120 & 4 & 320 & 10 & 3,718 & 1,859 & 1,859 \\ \hline 45 & $ & 6,857 & $ & 4,651 & 169 & 5 & 580 & 10 & 3,918 & 1,959 & 1,959 \\ \hline 46 & $ & 7,007 & $ & 4,976 & 169 & 3 & 700 & 8 & 4,004 & 2,002 & 2,002 \\ \hline 47 & $ & 7,883 & $ & 4,983 & 169 & 5 & 680 & 10 & 4,505 & 2,252 & 2,252 \\ \hline 48 & $ & 5,600 & $ & 4,785 & 173 & 4 & 600 & 10 & 32,000 & 1,600 & 1,600 \\ \hline 49 & $ & 4,375 & $ & 5,120 & 173 & 5 & 720 & 8 & 2,500 & 1,250 & 1,250 \\ \hline 50 & $ & 8,008 & $ & 5,127 & 173 & 4 & 600 & 100 & 4,576 & 2,288 & 2,288 \\ \hline 51 & $ & 6,081 & $ & 4,609 & 180 & 3 & 450 & 10 & 3,475 & 1,737 & 1,737 \\ \hline 52 & $ & 6,256 & $ & 4,742 & 188 & 4 & 460 & 10 & 3,575 & 1,788 & 1,788 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Week & & \begin{tabular}{l} Sales \\ enue \end{tabular} & & \begin{tabular}{l} perating \\ ost \end{tabular} & \begin{tabular}{c} Direct Labor \\ Hours \end{tabular} & \begin{tabular}{c} New Menu \\ Items \\ Developed \end{tabular} & \begin{tabular}{c} Number of \\ Deliveries \\ (Customer \\ Meals) \end{tabular} & \begin{tabular}{c} Number of \\ Deliveries \\ (Donated \\ Meals) \end{tabular} & \begin{tabular}{c} Total Meals \\ Produced \end{tabular} & \begin{tabular}{c} Customer \\ Meals Sold \end{tabular} & Meals Donated \\ \hline 1 & $ & 4,805 & $ & 3,375 & 110 & 2 & 375 & 6 & 2,746 & 1,373 & 1,373 \\ \hline 2 & $ & 3,754 & $ & 3,465 & 94 & 3 & 315 & 8 & 2,145 & 1,073 & 1,073 \\ \hline 3 & $ & 3,879 & $ & 3,564 & 98 & 3 & 325 & 8 & 2,217 & 1,108 & 1,108 \\ \hline 4 & $ & 4,555 & $ & 3,318 & 98 & 2 & 450 & 6 & 2,603 & 1,301 & 1,301 \\ \hline 5 & $ & 4,630 & $ & 3,722 & 98 & 3 & 445 & 8 & 2,646 & 1,323 & 1,323 \\ \hline 6 & $ & 5,230 & $ & 3,419 & 131 & 3 & 435 & 8 & 2,989 & 1,494 & 1,494 \\ \hline 7 & $ & 4,705 & $ & 3,412 & 105 & 2 & 465 & 6 & 2,688 & 1,344 & 1,344 \\ \hline 8 & $ & 4,505 & $ & 3,620 & 110 & 5 & 400 & 6 & 2,574 & 1,287 & 1,287 \\ \hline 9 & $ & 4,680 & $ & 3,724 & 115 & 3 & 400 & 6 & 2,674 & 1,337 & 1,337 \\ \hline 10 & $ & 4,830 & $ & 3,545 & 125 & 3 & 425 & 8 & 2,760 & 1,380 & 1,380 \\ \hline 11 & $ & 4,945 & $ & 3,646 & 140 & 3 & 440 & 8 & 2,826 & 1,413 & 1,413 \\ \hline 12 & $ & 5,305 & $ & 3,539 & 125 & 3 & 460 & 6 & 3,032 & 1,516 & 1,516 \\ \hline 13 & $ & 4,925 & $ & 3,512 & 100 & 2 & 375 & 6 & 2,814 & 1,407 & 1,407 \\ \hline 14 & $ & 4,705 & $ & 3,702 & 146 & 3 & 350 & 8 & 2,688 & 1,344 & 1,344 \\ \hline 15 & $ & 4,830 & $ & 3,829 & 101 & 5 & 460 & 8 & 2,760 & 1,380 & 1,380 \\ \hline 16 & $ & 5,455 & $ & 3,640 & 131 & 3 & 475 & 6 & 3,117 & 1,559 & 1,559 \\ \hline 17 & $ & 5,205 & $ & 3,961 & 135 & 4 & 400 & 8 & 2,974 & 1,487 & 1,487 \\ \hline 18 & $ & 4,200 & $ & 3,893 & 135 & 4 & 460 & 8 & 2,400 & 1,200 & 1,200 \\ \hline 19 & $ & 5,380 & $ & 3,517 & 135 & 3 & 450 & 8 & 3,075 & 1,537 & 1,537 \\ \hline 20 & $ & 6,381 & $ & 4,234 & 135 & 4 & 600 & 8 & 3,647 & 1,823 & 1,823 \\ \hline 21 & $ & 6,757 & $ & 4,356 & 135 & 2 & 620 & 8 & 3,861 & 1,931 & 1,931 \\ \hline 22 & $ & 5,355 & $ & 4,074 & 139 & 4 & 412 & 8 & 3,060 & 1,530 & 1,530 \\ \hline 23 & $ & 5,506 & $ & 4,057 & 141 & 3 & 440 & 8 & 3,146 & 1,573 & 1,573 \\ \hline 24 & $ & 5,506 & $ & 3,983 & 143 & 4 & 460 & 8 & 3,146 & 1,573 & 1,573 \\ \hline 25 & $ & 5,756 & $ & 3,855 & 143 & 3 & 465 & 8 & 3,289 & 1,645 & 1,645 \\ \hline 26 & $ & 6,256 & $ & 4,151 & 143 & 4 & 570 & 8 & 3,575 & 1,788 & 1,788 \\ \hline 27 & $ & 5,565 & $ & 3,718 & 131 & 2 & 400 & 8 & 3,180 & 1,590 & 1,590 \\ \hline 28 & $ & 5,656 & $ & 4,174 & 146 & 3 & 458 & 8 & 3,232 & 1,616 & 1,616 \\ \hline 29 & $ & 5,856 & $ & 3,966 & 147 & 3 & 490 & 8 & 3,346 & 1,673 & 1,673 \\ \hline 30 & $ & 6,406 & $ & 4,270 & 147 & 4 & 588 & 8 & 3,661 & 1,830 & 1,830 \\ \hline 31 & $ & 4,855 & $ & 3,808 & 150 & 3 & 300 & 8 & 2,774 & 1,387 & 1,387 \\ \hline 32 & $ & 5,506 & $ & 4,347 & 150 & 3 & 420 & 10 & 3,146 & 1,573 & 1,573 \\ \hline 33 & $ & 5,656 & $ & 4,300 & 150 & 4 & 440 & 8 & 3,232 & 1,616 & 1,616 \\ \hline 34 & $ & 5,681 & $ & 4,472 & 150 & 5 & 430 & 10 & 3,246 & 1,623 & 1,623 \\ \hline 35 & $ & 5,731 & $ & 4,098 & 150 & 4 & 475 & 8 & 3,275 & 1,637 & 1,637 \\ \hline 36 & $ & 6,006 & $ & 3,796 & 150 & 3 & 500 & 8 & 3,432 & 1,716 & 1,716 \\ \hline 37 & $ & 6,106 & $ & 3,904 & 150 & 4 & 515 & 8 & 3,489 & 1,745 & 1,745 \\ \hline 38 & $ & 6,256 & $ & 4,552 & 150 & 4 & 480 & 8 & 3,575 & 1,788 & 1,788 \\ \hline 39 & $ & 6,306 & $ & 4,457 & 150 & 4 & 540 & 10 & 3,604 & 1,802 & 1,802 \\ \hline 40 & $ & 6,406 & $ & 4,684 & 150 & 4 & 490 & 8 & 3,661 & 1,830 & 1,830 \\ \hline 41 & $ & 6,907 & $ & 4,281 & 1,500 & 4 & 650 & 8 & 3,947 & 1,973 & 1,973 \\ \hline 42 & $ & 7,107 & $ & 4,404 & 150 & 4 & 670 & 8 & 4,061 & 2,031 & 2,031 \\ \hline 43 & $ & 5,856 & $ & 4,424 & 154 & 4 & 450 & 8 & 3,346 & 1,673 & 1,673 \\ \hline 44 & $ & 6,507 & $ & 4,586 & 120 & 4 & 320 & 10 & 3,718 & 1,859 & 1,859 \\ \hline 45 & $ & 6,857 & $ & 4,651 & 169 & 5 & 580 & 10 & 3,918 & 1,959 & 1,959 \\ \hline 46 & $ & 7,007 & $ & 4,976 & 169 & 3 & 700 & 8 & 4,004 & 2,002 & 2,002 \\ \hline 47 & $ & 7,883 & $ & 4,983 & 169 & 5 & 680 & 10 & 4,505 & 2,252 & 2,252 \\ \hline 48 & $ & 5,600 & $ & 4,785 & 173 & 4 & 600 & 10 & 32,000 & 1,600 & 1,600 \\ \hline 49 & $ & 4,375 & $ & 5,120 & 173 & 5 & 720 & 8 & 2,500 & 1,250 & 1,250 \\ \hline 50 & $ & 8,008 & $ & 5,127 & 173 & 4 & 600 & 100 & 4,576 & 2,288 & 2,288 \\ \hline 51 & $ & 6,081 & $ & 4,609 & 180 & 3 & 450 & 10 & 3,475 & 1,737 & 1,737 \\ \hline 52 & $ & 6,256 & $ & 4,742 & 188 & 4 & 460 & 10 & 3,575 & 1,788 & 1,788 \\ \hline \end{tabular}