Excel

1. Find the top 10 sales dates and discuss the average minimum and maximum sales in relationship to the daily sales goal

2. Do you recommend increasing the price per box of popcorn? Your answer should demonstrate whether the new price will increase the number of days the sales goals will be met

3. Explain some maximum and minimum data on your PivotTable/Chart

4. Do you recommend buying a new truck? Explain your decision based on the dollar amount of money the company will gain or lose if they purchase a new truck

July Sales by Location \begin{tabular}{|c|c|c|c|c|c|c|} \hline & A & B & D & E & F & G \\ \hline 1 & Price & $42,000.00 & & & & \\ \hline 2 & Loan term (in months & 12 & & & & \\ \hline 3 & Interest (annual) & 8% & & & & \\ \hline \multicolumn{7}{|l|}{4} \\ \hline 5 & Monthly Payment & $3,653.51 & & & & \\ \hline 6 & Total Payments & $43,842.17 & & & & \\ \hline 7 & Interest Paid & $1,842.17 & & & & \\ \hline \multicolumn{7}{|c|}{8} \\ \hline 9 & Average Sales & $4,881.25 & & & & \\ \hline 10 & Buy new truck? & Buy it! & & & & \\ \hline \multicolumn{7}{|l|}{11} \\ \hline \multicolumn{7}{|l|}{12} \\ \hline \multicolumn{7}{|l|}{13} \\ \hline \multicolumn{7}{|l|}{14} \\ \hline \multicolumn{7}{|l|}{15} \\ \hline \multicolumn{7}{|l|}{16} \\ \hline \multicolumn{7}{|l|}{17} \\ \hline \multicolumn{7}{|l|}{18} \\ \hline \multicolumn{7}{|l|}{19} \\ \hline \multicolumn{7}{|l|}{20} \\ \hline \multicolumn{7}{|l|}{21} \\ \hline \multicolumn{7}{|l|}{22} \\ \hline \multicolumn{7}{|l|}{23} \\ \hline \multicolumn{7}{|l|}{24} \\ \hline 4 & Trucks & TysonsSt & OnlineSalesTable & PivotTable & PivotTable 2 & PivotChart 2 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G \\ \hline 23 & 2014-07-22 & 107 & 60 & 142 & 309 & $1,545 & yes \\ \hline 24 & 20140723 & 116 & 115 & 128 & 359 & $1,795 & yes \\ \hline 25 & 20140724 & 46 & 129 & 145 & 320 & $1,600 & yes \\ \hline 26 & 20140725 & 44 & 112 & 99 & 255 & $1,275 & yes \\ \hline 27 & 20140726 & 112 & 96 & 31 & 239 & $1,195 & no \\ \hline 28 & 20140727 & 73 & 102 & 97 & 272 & $1,360 & yes \\ \hline 29 & 20140728 & 100 & 89 & 109 & 298 & $1,490 & yes \\ \hline 30 & 20140729 & 55 & 30 & 75 & 160 & $800 & no \\ \hline 31 & 2014-07-30 & 137 & 117 & 97 & 351 & $1,755 & yes \\ \hline 32 & 2014-07-31 & 125 & 39 & 80 & 244 & $1,220 & no \\ \hline 33 & & & & & & & \\ \hline 34 & & & & & & & \\ \hline 35 & & & & & & & \\ \hline 36 & & & & & & & \\ \hline 37 & & & & & & & \\ \hline 38 & & & & & & & \\ \hline 39 & & & & & & & \\ \hline 40 & & & & & & & \\ \hline 41 & & & & & & & \\ \hline 42 & & & & & & & \\ \hline 43 & & & & & & & \\ \hline 44 & & & & & & & \\ \hline 45 & & & & & & & \\ \hline 46 & & & & & & & \\ \hline & Truc & New & TysonsStore & OnlineSalesTable & PivotTable & PivotTable 2 & ivotChart 2 \\ \hline \end{tabular} Trucks NewTruck TysonsStore PivotTable PivotTable 2 PivotChart 2 Data \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & A & C & D & E & F & H & I \\ \hline 23 & 2014-07-05 & 2 Old Bay & MD & & & & \\ \hline 24 & 2014-07-05 & 2 Old Bay & DC & & & & \\ \hline 25 & 2014-07-05 & 6 Old Bay & MD & & & & \\ \hline 26 & 2014-07-05 & 2 Old Bay & MD & & & & \\ \hline 27 & 2014-07-05 & 4 Old Bay & VA & & & & \\ \hline 28 & 2014-07-05 & 2 Old Bay & MD & & & & \\ \hline 29 & 2014-07-05 & 4 Old Bay & VA & & & & \\ \hline 30 & 2014-07-05 & 2 Old Bay & WV & & & & \\ \hline 31 & 2014-07-06 & 2 Old Bay & MD & & & & \\ \hline 32 & 2014-07-06 & 8 Old Bay & MD & & & & \\ \hline 33 & 2014-07-06 & 10 Old Bay & WV & & & & \\ \hline 34 & 2014-07-06 & 2 Old Bay & DC & & & & \\ \hline 35 & 2014-07-06 & 4 Old Bay & NC & & & & \\ \hline 36 & 2014-06-30 & 12 Original Blend & OH & & & & \\ \hline 37 & 2014-06-30 & 4 Original Blend & CA & & & & \\ \hline 38 & 2014-06-30 & 2 Original Blend & AL & & & & \\ \hline 39 & 2014-06-30 & 10 Original Blend & NC & & & & \\ \hline 40 & 2014-06-30 & 2 Original Blend & VA & & & & \\ \hline 41 & 2014-07-01 & 10 Original Blend & AL & & & & \\ \hline 42 & 2014-07-01 & 2 Original Blend & NC & & & & \\ \hline 43 & 2014-07-01 & 4 Original Blend & VA & & & & \\ \hline 44 & 2014-07-01 & 10 Original Blend & WV & & & & \\ \hline 45 & 2014-07-01 & 6 Original Blend & OH & & & & \\ \hline 46 & 2014-07-02 & 2 Oriqinal Blend & AL & & & & \\ \hline & Trucks & \begin{tabular}{l|l} NewTruck & TysonsStore \end{tabular} & OnlineSalesTable & PivotTable & PivotTable 2 & votChart 2 & Dat \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & A & C & D & E & G & H & 1 \\ \hline 46 & 2014-07-02 & 2 Original Blend & AL & & & & \\ \hline 47 & 2014-07-02 & 4 Original Blend & DC & & & & \\ \hline 48 & 2014-07-02 & 14 Original Blend & NY & & & & \\ \hline 49 & 2014-07-02 & 12 Original Blend & WV & & & & \\ \hline 50 & 2014-07-02 & 10 Original Blend & OH & & & & \\ \hline 51 & 2014-07-02 & 4 Original Blend & AL & & & & \\ \hline 52 & 2014-07-02 & 4 Original Blend & SC & & & & \\ \hline 53 & 2014-07-03 & 4 Original Blend & OH & & & & \\ \hline 54 & 2014-07-03 & 4 Original Blend & NY & & & & \\ \hline 55 & 2014-07-04 & 6 Original Blend & AL & & & & \\ \hline 56 & 2014-07-04 & 8 Original Blend & MS & & & & \\ \hline 57 & 2014-07-04 & 4 Original Blend & CA & & & & \\ \hline 58 & 2014-07-05 & 6 Original Blend & MD & & & & \\ \hline 59 & 2014-07-05 & 2 Original Blend & AL & & & & \\ \hline 60 & 2014-07-05 & 2 Original Blend & OH & & & & \\ \hline 61 & 2014-07-05 & 6 Original Blend & CA & & & & \\ \hline 62 & 2014-07-05 & 2 Original Blend & MD & & & & \\ \hline 63 & 2014-07-05 & 4 Original Blend & VA & & & & \\ \hline 64 & 2014-07-05 & 6 Original Blend & NC & & & & \\ \hline 65 & 2014-07-05 & 4 Original Blend & WV & & & & \\ \hline 66 & 2014-07-06 & 4 Original Blend & CA & & & & \\ \hline 67 & 2014-07-06 & 2 Original Blend & MD & & & & \\ \hline 68 & 2014-07-06 & 2 Original Blend & WV & & & & \\ \hline 69 & 2014-07-06 & 12 Oriqinal Blend & & & & & \\ \hline 4 & Trucks & \begin{tabular}{l|l} NewTruck TysonsStore \end{tabular} & eSalesTable & ivot & PivotTable 2 & votChart 2 & D \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 4 & A & B & D & E & G & H & 1 \\ \hline 92 & 2014-07-06 & 6 Sea Salt and Caramel & VA & & & & \\ \hline 93 & 2014-07-06 & 4 Sea Salt and Caramel & AL & & & & \\ \hline 94 & 2014-07-06 & 2 Sea Salt and Caramel & DC & & & & \\ \hline 95 & 2014-07-06 & 4 Sea Salt and Caramel & MD & & & & \\ \hline 96 & 2014-07-06 & 2 Sea Salt and Caramel & VA & & & & \\ \hline 97 & 2014-07-06 & 10 Sea Salt and Caramel & MS & & & & \\ \hline 98 & 20140630 & 8 Truffle & VA & & & & \\ \hline 99 & 2014-06-30 & 2 Truffle & DC & & & & \\ \hline 100 & 2014-06-30 & 14 Truffle & DC & & & & \\ \hline 101 & 2014-07-01 & 5 Truffle & NY & & & & \\ \hline 102 & 2014-07-01 & 6 Truffle & NY & & & & \\ \hline 103 & 2014-07-01 & 12 Truffle & NY & & & & \\ \hline 104 & 2014-07-02 & 2 Truffle & NY & & & & \\ \hline 105 & 2014-07-02 & 2 Truffle & VA & & & & \\ \hline 106 & 2014-07-02 & 2 Truffle & SC & & & & \\ \hline 107 & 2014-07-03 & 2 Truffle & NY & & & & \\ \hline 108 & 2014-07-03 & 2 Truffle & DC & & & & \\ \hline 109 & 2014-07-04 & 8 Truffle & VA & & & & \\ \hline 110 & 2014-07-05 & 4 Truffle & VA & & & & \\ \hline 111 & 2014-07-05 & 4 Truffle & NY & & & & \\ \hline 112 & 2014-07-05 & 8 Truffle & CA & & & & \\ \hline 113 & 2014-07-05 & 6 Truffle & OH & & & & \\ \hline 114 & 2014-07-06 & 2 Truffle & OH & & & & \\ \hline 115 & 2014-07-06 & 2 Truffle & MD & & & & \\ \hline & \begin{tabular}{l|l} Trucks \end{tabular} & \begin{tabular}{l|l} ruck & TysonsStore \end{tabular} & eSalesTable & PivotTabl & PivotTable 2 & art 2 & \\ \hline \end{tabular} Drag fields between areas below: Drag fields between areas below: E70 \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & A & C & D & E & G & H & I \\ \hline 70 & 2014-07-04 & 8 Truffle & VA & & & & \\ \hline 71 & 2014-07-04 & 12 Sea Salt and Caramel & NJ & & & & \\ \hline 72 & 2014-07-04 & 2 Sea Salt and Caramel & WV & & & & \\ \hline 73 & 2014-07-05 & 2 Old Bay & MD & & & & \\ \hline 74 & 2014-07-05 & 2 Old Bay & DC & & & & \\ \hline 75 & 2014-07-05 & 4 Sea Salt and Caramel & NJ & & & & \\ \hline 76 & 2014-07-05 & 2 Sea Salt and Caramel & NY & & & & \\ \hline 77 & 2014-07-05 & 6 Original Blend & MD & & & & \\ \hline 78 & 2014-07-05 & 2 Original Blend & AL & & & & \\ \hline 79 & 2014-07-05 & 4 Truffle & VA & & & & \\ \hline 80 & 2014-07-05 & 6 Old Bay & MD & & & & \\ \hline 81 & 2014-07-05 & 2 Old Bay & MD & & & & \\ \hline 82 & 2014-07-05 & 4 Old Bay & VA & & & & \\ \hline 83 & 2014-07-05 & 4 Truffle & NY & & & & \\ \hline 84 & 2014-07-05 & 2 Original Blend & OH & & & & \\ \hline 85 & 2014-07-05 & 6 Sea Salt and Caramel & CA & & & & \\ \hline 86 & 2014-07-05 & 6 Original Blend & CA & & & & \\ \hline 87 & 2014-07-05 & 8 Truffle & CA & & & & \\ \hline 88 & 2014-07-05 & 2 Old Bay & MD & & & & \\ \hline 89 & 2014-07-05 & 2 Original Blend & MD & & & & \\ \hline 90 & 2014-07-05 & 4 Old Bay & VA & & & & \\ \hline 91 & 2014-07-05 & 4 Original Blend & VA & & & & \\ \hline 92 & 2014-07-05 & 2 Sea Salt and Caramel & MS & & & & \\ \hline 93 & 2014-07-05 & 6 Oriqinal Blend & NC & & & & \\ \hline & | Trucks & \begin{tabular}{l|l} NewTruck & TysonsStore \end{tabular} & heSalesTable & PivotTable & PivotTable 2 & ivotChart 2 & Data \\ \hline \end{tabular}