Problem Two-Pager and Data Needs for Car Wash Case Congratulations! Your team has received a new consulting contract. The first step with any new client is to define the problem. Therefore, you should put together a Problem Two-Pager based on the scenario and data Download scenario and datayou have. You will want to put together a rough Income Statement to understand how much revenue the company is generating and if they are earning a profit. Perform a thorough root cause analysis using both the 5 Whys and the Fishbone. Identify your top 3-5 potential causes. Please keep in mind that "poor management" is not a cause. You need to be more specific. Prepare at least one correlation and at least one regression analysis using the data provided to evaluate whether or not it is a likely cause. Based on the potential causes, compile a list of data that your team would like to have available to further analyze for this case. You goal should be to identify the data that will help you to analyze whether or not you have accurately identified the causes. Separate that data into both internal data that should be collected by the owner, and external data that your team would like to research.
\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline Location & \begin{tabular}{l} Capacity \\ Per hour \end{tabular} & \begin{tabular}{l} Daily \\ Open \\ Hours \end{tabular} & \begin{tabular}{c} Equipment \\ Age in \\ Years \end{tabular} & & \begin{tabular}{l} nthly Fixed \\ Cost \end{tabular} & & \begin{tabular}{l} able \\ st \end{tabular} & \begin{tabular}{l} Employee \\ Turnover \\ Rate \end{tabular} & \begin{tabular}{l} Customer \\ Satisfaction \\ ( 5 point \\ scale) \end{tabular} & Manager \\ \hline Cape Coral & 25 & 10 & 4 & $ & 37,051.03 & $ & 2.63 & 6.0 & 4.77 & Eileen Dover \\ \hline Clearwater & 25 & 9 & 5 & $ & 34,916.33 & $ & 2.44 & 3.3 & 4.91 & Joe King \\ \hline Coral Springs & 25 & 8 & 3 & $ & 24,743.23 & $ & 2.53 & 4.1 & 4.86 & Juan Moment \\ \hline Fort Lauderdale & 20 & 10 & 7 & $ & 21,856.66 & $ & 3.22 & 6.3 & 4.61 & Lou Cowt \\ \hline Gainesville & 20 & 8 & 9 & $ & 27,333.75 & $ & 3.13 & 8.7 & 3.62 & Marsha Mallow \\ \hline Hollywood & 15 & 10 & 7 & $ & 23,251.01 & $ & 3.10 & 9.0 & 2.97 & Patty O'dors \\ \hline Miami Gardens & 25 & 8 & 4 & $ & 24,652.73 & $ & 2.10 & 3.1 & 4.93 & Willy Gofarr \\ \hline Miramar & 25 & 9 & 5 & $ & 22,478.59 & $ & 2.40 & 5.6 & 4.81 & Barb Dwyer \\ \hline Palm Bay & 20 & 8 & 6 & $ & 17,947.40 & $ & 2.85 & 8.4 & 4.49 & Jean Poole \\ \hline Pembroke Pines & 15 & 10 & 4 & $ & 15,777.22 & $ & 2.67 & 4.6 & 4.84 & Moira Less \\ \hline Pompano Beach & 15 & 10 & 3 & $ & 11,716.30 & $ & 2.76 & 3.7 & 4.88 & Ben Dunn \\ \hline West Palm Beach & 15 & 8 & 3 & $ & 13,743.86 & $ & 2.44 & 5.1 & 4.87 & Cy Kocess \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Location & & Nov-20 & & Dec-20 & & Jan-21 & & Feb-21 & & Mar-21 & & Apr-21 & & May-21 & & Jun-21 & & Jul-21 & & Aug-21 & & Sep-21 & & Oct-21 \\ \hline Cape Coral & $ & 12.17 & $ & 12.24 & $ & 12.53 & $ & 11.25 & & 12.16 & $ & 12.82 & $ & 12.95 & $ & 13.93 & $ & 12.90 & $ & 13.16 & $ & 15.89 & $ & 12.04 \\ \hline Clearwater & $ & 12.56 & $ & 12.91 & $ & 11.09 & $ & 13.53 & $ & 14.29 & $ & 13.90 & $ & 12.55 & $ & 13.68 & $ & 14.34 & 5 & 14.55 & $ & 12.53 & 5 & 14.42 \\ \hline ings & $ & 16.17 & $ & 15.99 & $ & 16.18 & $ & 15.91 & $ & 15.99 & $ & 17.06 & $ & 15.03 & $ & 17.91 & $ & 16.44 & 5 & 17.07 & $ & 19.33 & & 9.15 \\ \hline ort Lauderdale & $ & 13.92 & $ & 12.78 & $ & 2.86 & $ & 13.60 & $ & 12.82 & $ & 2.48 & $ & 12.88 & $ & .39 & $ & 12.54 & $ & 3.38 & $ & 13.57 & $ & 3.38 \\ \hline ainesville & $ & 11.25 & $ & 12.18 & $ & 12.00 & $ & 11.57 & $ & 12.53 & $ & 12.71 & $ & 12.31 & $ & 12.65 & $ & 12.50 & $ & 12.34 & $ & 12.96 & $ & 13.41 \\ \hline Hollywood & $ & 11.03 & $ & 12.11 & $ & 11.57 & $ & 12.80 & $ & 11.30 & $ & 12.43 & $ & 11.92 & $ & 12.12 & $ & 12.71 & $ & 12.30 & $ & 12.89 & $ & 12.84 \\ \hline Miami Gardens & $ & 12.03 & $ & 11.92 & $ & 11.86 & $ & 10.39 & $ & 11.70 & $ & 10.91 & $ & 12.64 & $ & 12.44 & $ & 12.96 & $ & 12.27 & $ & 12.19 & $ & 13.40 \\ \hline Miramar & $ & 14.46 & $ & 16.01 & $ & 16.07 & $ & 14.73 & $ & 14.48 & $ & 14.47 & $ & 15.20 & $ & 16.11 & $ & 15.74 & $ & 15.97 & $ & 16.87 & $ & 17.35 \\ \hline Palm Bay & $ & 11.45 & $ & 13.14 & $ & 11.74 & $ & 11.73 & $ & 11.82 & $ & 12.99 & $ & 11.94 & $ & 12.66 & $ & 13.05 & $ & 13.26 & $ & 13.02 & $ & 12.23 \\ \hline Pembroke Pines & $ & 12.76 & $ & 11.61 & $ & 12.24 & $ & 12.25 & $ & 12.49 & $ & 12.13 & $ & 11.80 & $ & 12.58 & $ & 12.61 & $ & 12.96 & $ & 12.88 & $ & 13.19 \\ \hline Pompano Beach & $ & 17.56 & $ & 19.00 & $ & 16.40 & $ & 19.66 & $ & 19.10 & $ & 16.83 & $ & 19.85 & $ & 18.34 & $ & 17.22 & $ & 1.71 & $ & 22.23 & $ & 18.44 \\ \hline Nest Palm Beach & $ & 10.75 & $ & 11.11 & $ & 11.13 & $ & 11.46 & $ & 11.15 & $ & 12.48 & $ & 12.76 & $ & 13.15 & $ & 13.23 & $ & 13.02 & $ & 11.23 & $ & 11.63 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Location & Nov-20 & Dec-20 & Jan-21 & Feb-21 & Mar-21 & Apr-21 & May-21 & Jun-21 & Jul-21 & Aug-21 & Sep-21 & Oct-21 \\ \hline Cape Coral & 5,172 & 4,634 & 4,518 & 5,494 & 5,648 & 5,490 & 4,815 & 5,858 & 7,261 & 7,625 & 7,485 & 6,742 \\ \hline Clearwater & 3,995 & 3,527 & 4,529 & 5,187 & 6,266 & 5,759 & 5,237 & 6,011 & 5,063 & 5,254 & 5,265 & 5,149 \\ \hline Coral Springs & 4,651 & 4,252 & 4,619 & 5,020 & 6,146 & 5,707 & 5,770 & 5,343 & 4,847 & 4,433 & 4,215 & 4,047 \\ \hline Fort Lauderdale & 3,795 & 3,528 & 4,185 & 4,735 & 5,593 & 5,131 & 5,221 & 5,211 & 4,437 & 4,129 & 4,673 & 4,703 \\ \hline Gainesville & 3,327 & 3,563 & 3,724 & 4,132 & 4,601 & 5,114 & 5,021 & 4,619 & 4,967 & 4,348 & 4,020 & 4,380 \\ \hline Hollywood & 2,966 & 3,303 & 3,769 & 4,195 & 4,350 & 4,421 & 4,343 & 4,107 & 3,891 & 3,758 & 3,177 & 3,719 \\ \hline Miami Gardens & 3,025 & 2,904 & 3,185 & 3,403 & 3,592 & 3,754 & 4,037 & 3,626 & 3,149 & 3,326 & 3,372 & 3,482 \\ \hline Miramar & 2,552 & 2,616 & 2,905 & 3,501 & 3,758 & 4,021 & 3,715 & 4,080 & 3,071 & 2,933 & 3,008 & 3,555 \\ \hline Palm Bay & 2,263 & 2,373 & 2,375 & 2,898 & 3,242 & 3,218 & 3,232 & 3,246 & 3,171 & 2,932 & 2,922 & 2,736 \\ \hline Pembroke Pines & 2,034 & 2,301 & 2,036 & 2,047 & 2,766 & 2,749 & 2,666 & 2,658 & 2,634 & 2,390 & 2,267 & 2,431 \\ \hline Pompano Beach & 2,596 & 2,395 & 2,216 & 2,596 & 3,311 & 3,866 & 2,387 & 2,619 & 2,512 & 2,190 & 2,463 & 2,279 \\ \hline West Palm Beach & 2,586 & 2,606 & 2,352 & 2,757 & 3,021 & 2,948 & 3,268 & 3,500 & 3,497 & 3,316 & 2,858 & 3,087 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline Location & \begin{tabular}{l} Capacity \\ Per hour \end{tabular} & \begin{tabular}{l} Daily \\ Open \\ Hours \end{tabular} & \begin{tabular}{c} Equipment \\ Age in \\ Years \end{tabular} & & \begin{tabular}{l} nthly Fixed \\ Cost \end{tabular} & & \begin{tabular}{l} able \\ st \end{tabular} & \begin{tabular}{l} Employee \\ Turnover \\ Rate \end{tabular} & \begin{tabular}{l} Customer \\ Satisfaction \\ ( 5 point \\ scale) \end{tabular} & Manager \\ \hline Cape Coral & 25 & 10 & 4 & $ & 37,051.03 & $ & 2.63 & 6.0 & 4.77 & Eileen Dover \\ \hline Clearwater & 25 & 9 & 5 & $ & 34,916.33 & $ & 2.44 & 3.3 & 4.91 & Joe King \\ \hline Coral Springs & 25 & 8 & 3 & $ & 24,743.23 & $ & 2.53 & 4.1 & 4.86 & Juan Moment \\ \hline Fort Lauderdale & 20 & 10 & 7 & $ & 21,856.66 & $ & 3.22 & 6.3 & 4.61 & Lou Cowt \\ \hline Gainesville & 20 & 8 & 9 & $ & 27,333.75 & $ & 3.13 & 8.7 & 3.62 & Marsha Mallow \\ \hline Hollywood & 15 & 10 & 7 & $ & 23,251.01 & $ & 3.10 & 9.0 & 2.97 & Patty O'dors \\ \hline Miami Gardens & 25 & 8 & 4 & $ & 24,652.73 & $ & 2.10 & 3.1 & 4.93 & Willy Gofarr \\ \hline Miramar & 25 & 9 & 5 & $ & 22,478.59 & $ & 2.40 & 5.6 & 4.81 & Barb Dwyer \\ \hline Palm Bay & 20 & 8 & 6 & $ & 17,947.40 & $ & 2.85 & 8.4 & 4.49 & Jean Poole \\ \hline Pembroke Pines & 15 & 10 & 4 & $ & 15,777.22 & $ & 2.67 & 4.6 & 4.84 & Moira Less \\ \hline Pompano Beach & 15 & 10 & 3 & $ & 11,716.30 & $ & 2.76 & 3.7 & 4.88 & Ben Dunn \\ \hline West Palm Beach & 15 & 8 & 3 & $ & 13,743.86 & $ & 2.44 & 5.1 & 4.87 & Cy Kocess \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Location & & Nov-20 & & Dec-20 & & Jan-21 & & Feb-21 & & Mar-21 & & Apr-21 & & May-21 & & Jun-21 & & Jul-21 & & Aug-21 & & Sep-21 & & Oct-21 \\ \hline Cape Coral & $ & 12.17 & $ & 12.24 & $ & 12.53 & $ & 11.25 & & 12.16 & $ & 12.82 & $ & 12.95 & $ & 13.93 & $ & 12.90 & $ & 13.16 & $ & 15.89 & $ & 12.04 \\ \hline Clearwater & $ & 12.56 & $ & 12.91 & $ & 11.09 & $ & 13.53 & $ & 14.29 & $ & 13.90 & $ & 12.55 & $ & 13.68 & $ & 14.34 & 5 & 14.55 & $ & 12.53 & 5 & 14.42 \\ \hline ings & $ & 16.17 & $ & 15.99 & $ & 16.18 & $ & 15.91 & $ & 15.99 & $ & 17.06 & $ & 15.03 & $ & 17.91 & $ & 16.44 & 5 & 17.07 & $ & 19.33 & & 9.15 \\ \hline ort Lauderdale & $ & 13.92 & $ & 12.78 & $ & 2.86 & $ & 13.60 & $ & 12.82 & $ & 2.48 & $ & 12.88 & $ & .39 & $ & 12.54 & $ & 3.38 & $ & 13.57 & $ & 3.38 \\ \hline ainesville & $ & 11.25 & $ & 12.18 & $ & 12.00 & $ & 11.57 & $ & 12.53 & $ & 12.71 & $ & 12.31 & $ & 12.65 & $ & 12.50 & $ & 12.34 & $ & 12.96 & $ & 13.41 \\ \hline Hollywood & $ & 11.03 & $ & 12.11 & $ & 11.57 & $ & 12.80 & $ & 11.30 & $ & 12.43 & $ & 11.92 & $ & 12.12 & $ & 12.71 & $ & 12.30 & $ & 12.89 & $ & 12.84 \\ \hline Miami Gardens & $ & 12.03 & $ & 11.92 & $ & 11.86 & $ & 10.39 & $ & 11.70 & $ & 10.91 & $ & 12.64 & $ & 12.44 & $ & 12.96 & $ & 12.27 & $ & 12.19 & $ & 13.40 \\ \hline Miramar & $ & 14.46 & $ & 16.01 & $ & 16.07 & $ & 14.73 & $ & 14.48 & $ & 14.47 & $ & 15.20 & $ & 16.11 & $ & 15.74 & $ & 15.97 & $ & 16.87 & $ & 17.35 \\ \hline Palm Bay & $ & 11.45 & $ & 13.14 & $ & 11.74 & $ & 11.73 & $ & 11.82 & $ & 12.99 & $ & 11.94 & $ & 12.66 & $ & 13.05 & $ & 13.26 & $ & 13.02 & $ & 12.23 \\ \hline Pembroke Pines & $ & 12.76 & $ & 11.61 & $ & 12.24 & $ & 12.25 & $ & 12.49 & $ & 12.13 & $ & 11.80 & $ & 12.58 & $ & 12.61 & $ & 12.96 & $ & 12.88 & $ & 13.19 \\ \hline Pompano Beach & $ & 17.56 & $ & 19.00 & $ & 16.40 & $ & 19.66 & $ & 19.10 & $ & 16.83 & $ & 19.85 & $ & 18.34 & $ & 17.22 & $ & 1.71 & $ & 22.23 & $ & 18.44 \\ \hline Nest Palm Beach & $ & 10.75 & $ & 11.11 & $ & 11.13 & $ & 11.46 & $ & 11.15 & $ & 12.48 & $ & 12.76 & $ & 13.15 & $ & 13.23 & $ & 13.02 & $ & 11.23 & $ & 11.63 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Location & Nov-20 & Dec-20 & Jan-21 & Feb-21 & Mar-21 & Apr-21 & May-21 & Jun-21 & Jul-21 & Aug-21 & Sep-21 & Oct-21 \\ \hline Cape Coral & 5,172 & 4,634 & 4,518 & 5,494 & 5,648 & 5,490 & 4,815 & 5,858 & 7,261 & 7,625 & 7,485 & 6,742 \\ \hline Clearwater & 3,995 & 3,527 & 4,529 & 5,187 & 6,266 & 5,759 & 5,237 & 6,011 & 5,063 & 5,254 & 5,265 & 5,149 \\ \hline Coral Springs & 4,651 & 4,252 & 4,619 & 5,020 & 6,146 & 5,707 & 5,770 & 5,343 & 4,847 & 4,433 & 4,215 & 4,047 \\ \hline Fort Lauderdale & 3,795 & 3,528 & 4,185 & 4,735 & 5,593 & 5,131 & 5,221 & 5,211 & 4,437 & 4,129 & 4,673 & 4,703 \\ \hline Gainesville & 3,327 & 3,563 & 3,724 & 4,132 & 4,601 & 5,114 & 5,021 & 4,619 & 4,967 & 4,348 & 4,020 & 4,380 \\ \hline Hollywood & 2,966 & 3,303 & 3,769 & 4,195 & 4,350 & 4,421 & 4,343 & 4,107 & 3,891 & 3,758 & 3,177 & 3,719 \\ \hline Miami Gardens & 3,025 & 2,904 & 3,185 & 3,403 & 3,592 & 3,754 & 4,037 & 3,626 & 3,149 & 3,326 & 3,372 & 3,482 \\ \hline Miramar & 2,552 & 2,616 & 2,905 & 3,501 & 3,758 & 4,021 & 3,715 & 4,080 & 3,071 & 2,933 & 3,008 & 3,555 \\ \hline Palm Bay & 2,263 & 2,373 & 2,375 & 2,898 & 3,242 & 3,218 & 3,232 & 3,246 & 3,171 & 2,932 & 2,922 & 2,736 \\ \hline Pembroke Pines & 2,034 & 2,301 & 2,036 & 2,047 & 2,766 & 2,749 & 2,666 & 2,658 & 2,634 & 2,390 & 2,267 & 2,431 \\ \hline Pompano Beach & 2,596 & 2,395 & 2,216 & 2,596 & 3,311 & 3,866 & 2,387 & 2,619 & 2,512 & 2,190 & 2,463 & 2,279 \\ \hline West Palm Beach & 2,586 & 2,606 & 2,352 & 2,757 & 3,021 & 2,948 & 3,268 & 3,500 & 3,497 & 3,316 & 2,858 & 3,087 \\ \hline \end{tabular}
