Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You don't need Describe how the following would be executed using excel: . Find the 3 month moving average of flowers ordered for 2018. 4.

You don't need Describe how the following would be executed using excel:

. Find the 3 month moving average of flowers ordered for 2018.

4. Add a series of columns to your Orders data table that will result in displaying the total price for each order. At a minimum, you will need the following four columns, however you may find it helpful to add additional columns to further break down the calculations.

a. Add a column that will use a vLookp function to display the price based on the type of flower listed on the "Prices" tab.

b. Add a column that will calculate the price of baby's breath.

c. Add a column that will add the surcharge for special colors.

d. Add a column that will calculate the total order price, adjusting for any discounts.

5. What is the percentage growth from January 2018 to January 2019. (Note: There are a couple of ways that you can approach this task.)

6. Use a "CountIf" function to determine how many orders included baby's breath. Calculate the total sales revenue for baby's breath.

7. Create at least five pivot tables (you may add others):

a. Calculate the total number (by dozens) of each color, of each type of flower. Add a calculated field to determine how many (total stems) of red roses were ordered in the month.

b. Calculate the total sales (by revenue) by each order source.

c. Calculate the average % discount by customer.

d. Use a grouping function to calculate total sales (by revenue) by week.

e. Create a pivot table that summarizes orders by order date and delivery date.

8. Use any combination of Excel tools that we have covered so far in this class to calculate average lead time from customer order date to delivery date, and explain any seasonal fluctuations you may notice.

9. Write a short narrative of at least three other insights gained about this data as a result of this exercise.

Orders Table

Pt.1

image text in transcribed

Pt. 2

image text in transcribed

Pt.3

image text in transcribed

Pt.4

image text in transcribed

Pt. 5

image text in transcribed

Pt. 6

image text in transcribed

Prices Table

image text in transcribed

2018 Totals Tab

image text in transcribed

A B D E F H 1 K L M N o P Yes 5 6 14 11 5 12 Yes 4 5 64 16 84 4 13 2 14 2 2 11 3 1 1 5 5 2 1 1 5 5 Yes Yes 17 16 16 4 Yes 4 1 1 19 5 19 4 8 2 7 10 3 5 1 11 2 Yes Tes Yes Yes Yes 4 1 77 17 7 7 7 74 51 2 1 1 0 0 2 18 4 16 14 4 2 1/25/19 1/25/19 1/25/19 1/25/19 1/25/19 1/25/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 2 0 9 7 6 1 2 11 2 10 2 4 18 11 7 2 3 11 5 14 1 1 14 10 2 2 3 3 14 4 11 2 0 1 1 4 1 Yes Yes No Yes Yes Yes Yes Yes 4 4 17 6 23 18 1 1 3 1 4 6 22 78 25 89 3 12 4 Yes 4 6 16 3 4 14 12 201 190298 202 190299 203 190300 204 190301 205 190302 206 190303 207 190304 208 190305 209 190306 210 190307 211 190308 212 190309 213 190310 214 190311 215 190312 216 190313 217 190314 218 190315 219 190316 220 190317 221 190318 222 190319 223 190320 224 190321 225 190322 226 190323 227 190324 228 190325 229 190326 230 190327 231 190328 232 190329 233 190330 234 190331 235 190332 236 190333 237 190334 238 190335 239 190336 240 190337 241 190338 3 2/11/19 Garcia 2/12/19 Garcia 2/1/19 Kim 2/12/19 Kim 2/11/19 Martin 2/11/19 Kim 2/12/19 Jones 2/11/19 Garcia 2/11/19 Jones 2/11/19 Rivera 2/12/19 Garcia 2/12/19 Rivera 2/11/19 Jones 2/11/19 Garcia 2/11/19 Garcia 2/11/19 Garcia 2/11/19 Smith 2/4/19 Rivera 2/4/19 Kim 2/12/19 Kim 2/11/19 Kim 2/11/19 Smith 2/4/19 Martin 2/12/19 Rivera 2/4/19 Kim 2/11/19 Kim 2/12/19 Martin 2/5/19 Jones 2/5/19 Garcia 2/5/19 Rivera 2/5/19 Jones 2/5/19 Kim 2/5/19 Rivera 2/11/19 Martin 2/5/19 Smith 2/12/19 Kim 2/5/19 Smith 2/5/19 Martin 2/5/19 Rivera 2/5/19 Smith 2/11/19 Martin Lilies Tulips Roses Tulips Lilies Lilies Roses Carnations Lilies Roses Roses Miniature Roses Roses Carnations Carnations Roses Roses Lilies Carnations Roses Carnations Roses Miniature Roses Miniature Roses Roses Roses Roses Roses Lilies Miniature Roses Roses Roses Roses Carnations Roses Carnations Roses Carnations Roses Carnations Lilies 10 7 10 5 5 3 3 2 3 3 1 7 9 9 4 4 14 10 12 5 5 25 23 3 6 2 2 9 6 15 15 0% E-mail 0% Main Website 0% Promotional Wet 15% Main Website 10% E-mail - 15% Phone % 0% Main Website 12% Phone 5% E-mail 12% Phone 5% E-mail E 0% Promotional Wet 5% Main Website 0% Promotional Wet 15% Main Website 0% Main Website 12% Promotional Wet 5% Main Website 15% E-mail 15% Main Website % 12% E-mail 0% Main Website 0% Phone 0% Promotional Wet 12% Main Website 0% Main Website 0% Promotional Wet 12% Main Website 5% Promotional Wet 0% Main Website 15% E-mail 5% Phone 15% E-mail 0% E-mail 15% Main Website 5% Main Website 15% Main Website 0% Main Website 0 0% Promotional Wet 15% Phone ............ 15% Promotional Wet Yes Yes Yes Yes Yes Yes Yes 3 3 2 6 4 1 4 4 12 15 2 10 8 4 4 5 11 13 67 46 51 25 83 83 14 28 12 7 3 1/28/19 2 2 4 1 1 5 5 3 5 2 1 3 1 2 1 0 2 1 1 1 1 1 3 10 Yes Yes Yes Yes 15 4 4 Yes 11 11 3 5 5 1 11 74 81 12 12 5 5 5 Yes Yes 4 1 30 7 19 7 22 11 4 5 15 1/28/19 1/28/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 Yes 19 18 6 21 11 18 1 19 5 . 10 1 6 6 14 2 2 13 6 16 7 11 1 12 7 10 2 5 1 4 4 2 4 0 3 3 3 10 1 11 Yes Yes Yes Yes Yes Yes Yes Yes 90 46 72 7 7 68 43 73 41 8 8 3 20 5 12 7 4 14 9 5 2 9 8 3 3 4 F G H 1 J K L M 4 1 1 2 2 2 3 4 5 5 5 21 3 4 3 17 11 17 2 1 4 4 2 1 3 3 2 Yes Yes Yes Yes Yes 7 5 B 1/7/19 1/7/19 1/7/19 1/7/19 1/7/19 1/7/19 1/7/19 1/7/19 1/7/19 1/7/19 1/7/19 3 16 7 15 16 22 18 79 44 78 71 9 19 19 8 2 5 3 4 Yes 8 2 2 3 3 3 11 8 10 12 1 13 16 2 8 15 14 4 11 Yes 1 0 0 1 6 1 7 2 11 14 11 A 190178 190179 190180 190181 190182 190183 190184 190185 190186 190187 190188 190189 190190 190191 190192 190193 190194 190195 190196 190197 190198 4 4 19 4 11 7 1 4 20 3 8 19 5 5 5 1 2 4 2 1 3 4 1/7/19 Yes Yes Yes Yes Yes Yes Yes 15 2 6 14 6 6 13 65 86 14 42 83 19 4 9 8 3 41 9 16 8 19 Yes 14 2 3 1 3 1 2 1 3 2 Yes Yes 5 3 5 3 3 1 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 0 4 4 1 1 6 C D 2/11/19 Martin 2/11/19 Smith 1/24/19 Kim 2/11/19 Rivera | 1/14/19 Kim 1/25/19 Kim 1/18/19 Martin 2/11/19 Rivera 2/12/19 Rivera 2/11/19 Kim 2/11/19 Kim 1/18/19 Rivera 1/18/19 Rivera 1/14/19 Kim 1/18/19 Martin 2/12/19 Smith 1/18/19 Kim 2/12/19 Kim 1/18/19 Garcia 2/12/19 Jones 2/12/19 Rivera 2/11/19 Kim 1/15/19 Kim 2/12/19 Kim 2/12/19 Kim 118/19 Kim. 2/11/19 Jones 2/11/19 Garcia 2/12/19 Rivera 1/16/19 Jones 1/16/19 Jones 1/17/19 Garcia 2/11/19 Kim 1/17/19 Smith 1/17/19 Smith 2/11/19 Garcia 1/17/19 Garcia 2/11/19 Kim 1/17/19 Kim 1/17/19 Kim 1/18/19 Rivera E E Roses Roses Tulips Roses Roses Roses Carnations Roses Roses Carnations Roses Miniature Roses Miniature Roses Roses Carnations Tulips Lilies Tulips Roses Roses Miniature Roses Carnations Roses Roses Carnations Roses Carnations Roses Lilies Roses Lilies Carnations Tulips Tulips Tulips Tulips Miniature Roses Tulips Carnations Roses Miniature Roses 1 11 17 3 2. 9 1 1 6 6 6 1 5 1 9 13 3 8 8 1 10 12 2 3 4 1 2 2 1 2 0 3 4 1 2 1 1 5 No Yes Yes Yes Yes Yes Yes 190199 N o 10% E-mail 15% Main Website 12% E-mail 10% E-mail 15% Main Website 12% Phone 0% Main Website 10% Main Website 10% Phone 0% Main Website 15% E-mail % 12% Main Website 0% Main Website 12% E-mail 0% Promotional Wet 12% E-mail 0% Main Website 0 % - 10% E-mail 12% E-mail 10% E-mail 12% Main Website 12% Main Website % 0% Phone 15% Main Website 12% Main Website 0% Main Website 0 12% Main Website 12% Promotional Wet 10% E-mail 0% Phone 10% Main Website 15% E-mail - 0% Phone 0% E-mail 0% Main Website 10% Main Website 10% Phone 10% Main Website 12% Phone 12% Phone 0% Phone 76 12 5 23 5 48 65 13 37 25 19 95 9 2 2 6 6 4 4 6 5 3 7 4 4 1 3 Yes 5 23 2 11 4 20 1/7/19 1/7/19 1/7/19 1/7/19 1/7/19 1/7/19 1/8/19 1/8/19 1/8/19 1/8/19 1/8/19 1/8/19 1/8/19 1/8/19 1/9/19 1/9/19 1/9/19 1/9/19 1/9/19 1/9/19 1/9/19 1/9/19 1/9/19 1/10/19 1/10/19 1/10/19 1/10/19 1/10/19 1/10/19 4 16 190200 190201 190202 190203 190204 190205 190206 190207 190208 3 16 6 5 Yes Yes 8 3 8 45 12 8 5 3 3 3 2 6 2 5 Yes No 5 7 5 1 2 3 Yes 3 11 31 3 26 11 13 Yes 190209 1 1 1 2 No 5 70 3 17 6 2 7 2 1 1 2 4 1 0 2 12 3 1 1 2 2 1 0 11 4 1 1 2 2 3 14 6 6 1 1 2 3 3 17 12 20 190210 190211 190212 190213 190214 190215 190216 190217 0 1 1 1 1 4 12 1 1 4 3 10 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes 23 6 6 10 16 63 65 82 24 7 4 14 7 9 12 14 4 4 5 8 5 6 120 121 17 5 5 11 12 4 190218 3 5 4 2 1 B B C D E F G G H 1 J J L M N 0 P 5 5 4 2 1 4 1/10/19 1/11/19 1/11/19 1/11/19 3 7 7 5 5 5 Yes Yes No No 13 9 13 9 18 9 11 6 8 4 2 4 4 4 3 4 9 6 8 1/14/19 Yes 24 7 64 40 53 39 27 12 41 86 9 4 9 2 2 7 Yes 7 7 7 6 5 5 2 1 4 2 1 Yes 2 3 1 1 2 1 2 Yes 6 3 9 16 5 11 10 22 6 13 16 4 4 8 6 8 3 2 6 43 190218 190219 190220 190221 190222 190223 190224 190225 190226 190227 190228 190229 190230 190231 190232 190233 190234 190235 190236 190237 190238 190239 Yes Yes Yes Yes No 9 4 4 4 4 1/14/19 1/14/19 1/14/19 1/14/19 1/14/19 1/14/19 1/14/19 1/14/19 1/14/19 1/14/19 1/14/19 1/14/19 1/14/19 1/14/19 1/14/19 1/15/19 1/15/19 1/18/19 Rivera 1/18/19 Garcia 1/18/19 Kim 1/18/19 Rivera 2/12/19 Garcia 1/24/19 Garcia 2/12/19 Jones 2/11/19 Jones 1/24/19 Jones 1/24/19 Jones 1/24/19 Smith 2/12/19 Kim 2/12/19 Martin 2/12/19 Kim 2/11/19 Kim 2/11/19 Rivera 1/24/19 Smith 1/24/19 Rivera 2/11/19 Martin 1/22/19 Kim 1/25/19 Rivera 1/22/19 Kim 2/11/19 Smith 1/25/19 Kim 1/25/19 Smith 2/11/19 Garcia 2/11/19 Garcia 1 1 1 2 1 1 1 1 1 3 3 3 3 6 16 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 4 4 Yes Yes Yes Yes Yes Yes 6 4 4 2 7 20 9 15 20 18 11 Miniature Roses Lilies Tulips Miniature Roses Roses Roses Carnations Carnations Roses Carnations Carnations Carnations Roses Roses Roses Roses Roses Miniature Roses Tulips Tulips Roses Roses Roses Carnations Roses Roses Tulips Miniature Roses Roses Tulips Carnations Miniature Roses Roses Tulips Roses Roses Miniature Roses Carnations Roses Miniature Roses Roses 17 3 9 17 10 14 15 16 6 11 10 8 8 4 2 2 1 4 11 5 5 10 8 10 3 3 6 6 6 5 2 6 2 2 4 4 3 3 2 2 5 15 5 14 13 15 5 7 8 7 3 8 3 8 2 8 13 18 17 13 34 87 39 73 82 82 27 52 45 2 4 5 4 1 3 3 No Yes Yes 2 5 4 4 1 3 2 3 1 2 2 1 3 7 14 8 8 --- 4 0% Phone 0% Main Website 0% Promotional Wet 0% Main Website 0% Promotional Wel 5% Main Website 0% E-mail 10% Phone 5% Main Website 12% E-mail % - 0% E-mail 0% E-mail 0% Phone 0% Promotional Wet 0% Phone 0% Phone 5% Main Website 5 15% Phone % 12% Main Website 5% Main Website 0% E-mail 5% Main Website 0% Promotional Wet 5% 5% Phone 0% Main Website % 0% Main Website 10% Phone 15% Promotional Wet 0% Phone 10% E-mail 0% Phone 0% Main Website 12% Main Website 12% E-mail 10% Main Website 10% Promotional Wet 0% E-mail 0% Promotional Wet 5% Promotional Wel 5% E-mail 0% Promotional Wel 190240 1/15/19 Yes 7 Yes 1 Yes 15 4 4 8 8 8 3 9 9 2 6 2 7 10 3 3 1 8 8 4 8 8 2 3 190241 190242 190243 190244 190245 190246 190247 190248 190249 190250 190251 190252 190253 9 3 10 2 14 16 9 Yes Yes Yes Yes 1/23/19 Rivera 1 7 8 2 1 3 1 3 4 4 2 Yes 41 18 45 16 41 12 57 69 34 47 70 5 Yes Yes 4 6 z 1/15/19 1/15/19 1/16/19 1/16/19 1/16/19 1/16/19 1/16/19 1/16/19 1/16/19 1/16/19 1/16/19 1/16/19 1/16/19 1/17/19 1/17/19 1/17/19 1/17/19 1/17/19 4 15 13 7 9 15 14 3 3 5 7 11 1/23/19 Jones 1/23/19 Jones 2/11/19 Jones 2/12/19 Rivera 1/23/19 Kim 2/11/19 Smith 2/12/19 Smith 2/12/19 Kim 1/25/19 Garcia 2/12/19 Jones 2/11/19 Garcia 1/24/19 Rivera 1/25/19 Smith 5 9 7 7 4 7 11 16 12 77 13 15 19 15 9 10 2 14 13 Yes No Yes Yes Yes 4 5 3 3 2 1 155 156 157 158 159 160 161 3 4 3 3 3 13 10 6 190254 9 13 11 64 47 50 15 6 7 Yes 1 3 Yes 190255 190256 190257 190258 2 6 6 3 3 16 5 11 3 12 3 3 4 Yes 10 3 65 20 4 1 1 Yes G H 1 J J M 0 P F 14 10 + 4 L 1 IU 3 res 05 Yes 4 11 3 7 5 17 1 1 3 > 1 3 3 5 5 2 20 66 Yes 13 11 16 3 Yes 14 11 IZ 3 12 16 6 10 10 6 9 2 7 Yes 4 3 Yes 10 5 7 9 9 4 3 3 4 10 15 6 7 7 4 13 13 6 6 6 10 8 12 4 6 6 1 Yes Yes Yes 1 2 2 5 5 75 42 55 67 28 31 35 8 7 2 2 7 4 5 Yes 8 8 Yes 0 E IvaLure nuses Roses Miniature Roses Roses Miniature Roses Roses Roses Tulips Carnations Carnations Lilies Roses Tulips Roses Miniature Roses Roses Miniature Roses Roses Miniature Roses Tulips Carnations Carnations Carnations 0 1 No 2 23 2 20 11 1 11 4 5 Yes 91 17 8 9 9 1 11 5 5 4 4 3 3 5 7 8 5 4 4 6 6 2 2 2 1 1 2 8 8 4 4 6 12 10 4 3 2 2 2 3 Yes Yes Yes Yes 5 5 5 3 8 45 38 26 25 48 6 Yes 7 3 2 9 Yes 3 1 1 3 100 19023 161 190258 162 190259 163 190260 164 190261 165 190262 166 190263 167 190264 168 190265 169 190266 170 190267 171 190268 172 190269 173 190270 174 190271 175 190272 1176 190273 177 190274 178 190275 179 190276 180 190277 181 190278 182 190279 183 190280 184 190281 185 190282 186 190283 187 190284 188 190285 189 190286 190 190287 191 190288 192 190289 193 190290 194 190291 195 190292 196 190293 197 190294 198 190295 199 190296 200 190297 2011 190298 Yes B 1/11/19 1/17/19 1/17/19 1/17/19 1/17/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/23/19 1/23/19 1/23/19 1/23/19 1/23/19 1/23/19 1/23/19 1/23/19 1/23/19 1/23/19 1/23/19 1/24/19 1/24/19 1/24/19 1/25/19 D 1/24719 Niveld 1/25/19 Smith 1/25/19 Rivera 2/12/19 Martin 1/25/19 Rivera 1/29/19 Jones 2/12/19 Garcia 2/1/19 Jones 2/1/19 Jones 2/12/19 Garcia 2/12/19 Garcia 2/12/19 Garcia 2/1/19 Jones 1/29/19 Kim 2/1/19 Rivera 1/29/19 Martin 1/29/19 Rivera 1/29/19 Kim 2/1/19 Martin 2/1/19 Kim 2/12/19 Kim 2/1/19 Kim 2/11/19 Kim 2/11/19 Smith | 2/12/19 Kim 1/29/19 Martin 2/12/19 Kim 2/12/19 Rivera 2/12/19 Garcia 2/1/19 Jones 2/11/19 Garcia 2/11/19 Jones 2/11/19 Kim 2/12/19 Smith 2/1/19 Martin 2/12/19 Kim 1/30/19 Kim 2/1/19 Smith 2/12/19 Martin 2/12/19 Martin 2/1/19 Kim 2/11/19 Garcia 8 3 8 Yes 12 11 5 14 12 11 7 1 3 4 9 3 11 7 7 9 9 4 4 1 5 N 3% C-TTDI 0% Promotional Wet 0 0% Main Website 0% Main Website 10% Phone % 12% Phone % 5% Main Website 10% Promotional Wet 10% E-mail 15% Main Website 15% Main Website 15% Promotional Wet 15% Promotional Wel 15% Main Website 0% Main Website 0% E-mail 5% Main Website 15% E-mail E- 0% Phone 15% Main Website 5% Phone 5% Phone 5 0% Promotional Wet 10% Main Website 15% E-mail 0% Main Website 0% Phone 10% Phone 15% Promotional Wet 10% Promotional Wet 0% Main Website 0% Main Website 0 15% Promotional Wet 0% Promotional Web 12% Main Website 0% Main Website 15% Promotional Wet 0% Phone 12% Promotional Wet 0% E-mail - 0% E-mail E- 0% F-mail 4 9 Yes 3 11 15 10 8 1 7 7 Roses 5 3 3 1 3 2 0 10 5 1 1 2 0 0 51 20 58 56 51 31 5 34 6 82 Yes Yes Yes 6 7 1 16 7 17 3 4 1 7 3 2 2 22 10 2 0 5 5 2 2 Yes Yes Yes 1 14 7 16 2 6 1 14 7 7 13 Yes 39 84 9 2 0 4 3 5 1 1 1 2 5 19 5 Yes 1 Yes 3 4 4 3 | Carnations Roses Roses Roses Carnations Roses Roses Roses Roses Carnations Lilies Carnations Carnations Roses Roses Roses Roses Lilies 4 10 18 Yes Yes 8 1 1 5 9 6 2 8 2 3 6 13 1 3 5 7 16 22 Yes Yes Yes 13 17 41 88 6 17 66 48 1 1 3 16 4 11 14 3 3 13 3 3 10 4 4 Yes 10 8 2 2 7 No 0 0 1 Yes 6 1 12 13 5 1 7 5 2 14 14 1 8 11 3 Yes 3 3 11 10 3 Yes 58 59 5 5 Yes 0 0 Date Total 70 75 62 26 11 18 88 1/2/19 28 59 72 43 82 85 31 11 44 37 A B D E F G H J K K L M N o P 1 Columr Column2 Column3 Column Columns Colu Colun Columns Colum: Colur Col Colur Col Colu ColuColumn13 Column1 Column15 Column16 2 The Whole Bouquet - A Floral Wholesale Supplier 3 January Orders (by Dozen) ( Delivery 4 Order Order Date Customer Floral Type Red White Light Pink Dark Pink Yellow Lilac Special Baby's Breath? Discounts Order Source 5 190101 1/2/19 1/11/19 Garcia Roses 21 8 8 13 9 4 4 11 Yes 15% Phone 6 190102 1/2/19 2/11/19 Jones Tulips 15 8 16 13 6 5 12 Yes 0% Main Website 7 190103 1/2/19 2/12/19 Jones Carnations 16 8 12 11 3 4 8 Yes 0% Phone 8 190104 1/2/19 2/11/19 Rivera Roses 5 3 5 5 4 2 2 2 2 5 5 Yes 0% Promotional Wet 9 190106 1/2/19 1/11/19 Garcia Tulips 2 1 2 2 1 1 1 2 2 Yes 0% Main Website 10 190107 1/2/19 1/9/19 Jones Roses 4 2 4 3 1 1 3 3 Yes 0% Main Website 0% 11 190108 1/11/19 Jones Roses 19 8 23 12 5 5 16 No 0% Phone 0 12 190109 1/2/19 2/11/19 Rivera Miniature Roses 7 7 3 6 4 2 2 4 Yes 15% Main Website 13 190110 1/2/19 1/9/19 Garcia Carnations 10 7 14 12 3 4 9 Yes 0% Promotional Wet 14 190111 1/2/19 2/12/19 Jones Carnations 14 9 15 14 5 5 4 4 11 No 12% Phone 15 190112 1/2/19 2/11/19 Martin Miniature Roses 10 6 8 9 2 2 6 Yes 15% Phone 16 190113 1/2/19 2/12/19 Martin Carnations 18 8 18 16 6 5 11 No 0% Phone 17 190114 1/2/19 1/9/19 Kim Roses 19 8 8 15 16 5 5 17 Yes 12% Phone 18 190115 1/2/19 2/11/19 Kim Roses 7 3 8 5 2 2 1 5 5 Yes 15% E-mail E 19 190116 1/2/19 2/12/19 Kim Roses 2 1 1 2 2 1 1 2 Yes 0% Promotional Wet 20 190117 1/2/19 2/12/19 Kim Roses 10 4 10 7 2 3 8 Yes 12% Phone 21 190118 1/2/19 2/11/19 Kim Roses 9 4 9 4 2 2 2 7 No 12% Main Website 22 190119 1/2/19 2/12/19 Kim Roses 17 8 18 10 4 4 5 5 13 Yes 15% Main Website 23 190120 1/2/19 1/9/19 Smith Roses 4 2 3 3 1 1 2 Yes 5% Phone 24 190121 1/2/19 2/12/19 Martin Carnations 3 2 3 2 1 1 1 3 Yes 15% Phone 25 190122 1/2/19 1/9/19 Kim Roses 5 3 5 3 1 1 1 3 3 Yes 15% Phone 26 190123 1/2/19 1/11/19 Rivera Miniature Roses 7 4 9 5 2 2 5 Yes 15% Phone 27 190124 1/2/19 1/9/19 Kim Roses 1 1 1 1 1 0 0 1 Yes 5% E-mail 5- 28 190125 1/2/19 1/11/19 Kim Roses 6 4 6 7 2 1 5 No 12% Promotional Wet 29 190126 1/3/19 2/11/19 Jones Roses 4 2 4 4 1 1 3 Yes 12% E-mail 30 190127 1/3/19 2/12/19 Garcia Tulips 13 6 11 7 3 3 2 10 Yes 5% Main Website 31 190128 1/3/19 2/11/19 Garcia Roses 2 1 1 2 2 0 1 2 Yes 0% Main Website 32 190129 1/3/19 1/10/19 Garcia Carnations 22 8 8 19 16 4 5 17 Yes 12% E-mail 33 190130 1/3/19 2/12/19 Kim Roses 2 1 3 2 2 1 1 1 3 3 Yes 15% Main Website 34 190131 1/3/19 1/10/19 Smith Tulips 17 8 18 14 5 5 4 13 Yes 15% E-mail 35 190132 1/3/19 2/12/19 Rivera Miniature Roses 11 5 11 10 3 3 3 7 Yes 0% Main Website 36 190133 1/3/19 1/11/19 Smith Carnations 4 2 4 3 1 1 3 Yes 15% Main Website 37 190134 1/3/19 2/11/19 Kim Roses 21 8 15 13 4 5 5 11 Yes 15% Main Website 38 190135 1/3/19 2/11/19 Kim Roses 2 2 1 1 1 1 0 0 0 1 NO 15% Main Website 39 190136 1/3/19 | 2/12/19 Kim Roses 3 2 3 2 1 1 3 Yes 12% Promotional Wet 40 190137 1/4/19 1/18/19 Rivera Miniature Roses 11 6 12 7 2 3 3 8 Yes 12% Main Website 41 190138 1/4/19 2/12/19 Garcia Roses 2 1 1 1 1 0 o 0 1 Yes % 0% Promotional Wet 42 190139 1/4/19 1/18/19 Kim Tulips 7 3 10 5 2 2 2 8 Yes 10% E-mail 43 190140 1/4/19 1/18/19 Rivera Miniature Roses 5 3 8 4 4 2 1 5 5 Yes 12% Main Website 44 190141 1/4/19 1/18/19 Kim Roses 9 4 8 5 2 2 6 Yes 12% Main Website 45 190142 1/4/19 2/12/19 Martin Lilies Yes 12% Promotional Wet 75 16 15 21 34 5 31 19 52 10 91 13 79 50 18 77 6 15 49 6 37 28 36 7 G H 1 J K M P 7 5 ID 7 4 2 2 F 21 11 18 1 19 ZZ 11 14 2 2 13 2 4 5 10 1 6 L 15 8 10 1 11 Yes Yes Yes 11 1 0 B B 1/29719 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/30/19 1/30/19 1/30/19 5 1 4 3 5 5 2 8 12 7 10 8 8 20 yu 46 72 7 68 43 73 41 4 3 3 5 3 8 14 9 - 12 9 6 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes 9 3 2 7 10 14 4 11 6 7 4 4 4 5 10 7 4 4 7 11 8 8 7 7 11 15 18 8 9 11 13 12 6 11 14 15 12 5 8 8 5 4 2 2 2 13 5 7 1/30/19 3 2 2 3 4 3 3 4 10 13 16 18 21 4 3 16 12 10 13 18 3 13 1/30/19 1/30/19 1/30/19 1/30/19 1/30/19 1/30/19 1/30/19 1/30/19 1/30/19 10 6 47 72 69 32 43 57 79 67 76 36 59 66 22 48 7 5 2 2 3 3 255 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 4 2 2 4 A 190550 190331 190332 190333 190334 190335 190336 190337 190338 190339 190340 190341 190342 190343 190344 190345 190346 190347 190348 190349 190350 190351 190352 190353 190354 190355 190356 190357 190358 190359 190360 190361 190362 190363 190364 190365 190366 190367 190368 190369 190370 7 8 D D 275719 Rivera 2/11/19 Martin 2/5/19 Smith 2/12/19 Kim 2/5/19 Smith 2/5/19 Martin 2/5/19 Rivera 2/5/19 Smith 2/11/19 Martin 2/12/19 Kim 2/6/19 Jones 2/11/19 Garcia 2/6/19 Jones 2/11/19 Jones 2/11/19 Garcia 2/6/19 Jones 2/6/19 Jones 2/12/19 Garcia 2/6/19 Garcia 2/6/19 Garcia 2/6/19 Garcia 2/12/19 Jones 2/12/19 Jones 2/6/19 Smith 2/11/19 Martin 2/6/19 Martin 2/12/19 Kim 2/6/19 Smith 2/6/19 Martin 2/6/19 Kim 2/6/19 Kim 2/6/19 Kim 2/6/19 Rivera 2/12/19 Martin 2/11/19 Jones 2/11/19 Rivera 2/12/19 Martin 2/12/19 Kim 2/12/19 Kim 2/11/19 Martin | 2/12/19 Kim E Roses Carnations Roses Carnations Roses Carnations Roses Carnations Lilies Roses Roses Tulips Carnations Carnations Carnations Roses Carnations Carnations Roses Carnations Roses Roses Roses Roses Roses Carnations Carnations Roses Carnations Roses Roses Roses Miniature Roses Miniature Roses Carnations Roses Carnations Roses Carnations Roses Roses 7 13 14 4 10 14 18 5 10 1 1 4 4 1 N 0 15% E-mail 0% E-mail 15% Main Website 5% Main Website 15% Main Website 0% Main Website 0% Promotional Wet 15% Phone 15% Promotional Wet 0% Phone 0% Promotional Wet 0% E-mail 15% E-mail 0% Main Website 5% Phone 15% Main Website 12% Promotional Wet 5% E-mail 12% Phone 15% Main Website 12% Main Website 0% Main Website 0% E-mail 15% E-mail E 15% Phone 15% Phone 0% Phone 0% Main Website 15% E-mail 0% Promotional Wet 0% E-mail 0 0% Phone 15% Phone 0% Main Website 15% Promotional Wet 12% E-mail 15% Main Website 0% Main Website 0% E-mail 15% Promotional Wet 0% Main Website 11 12 3 9 1 4 6 3 2 3 0 Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes 6 6 6 6 3 3 4 1 2 4 3 4 4 4 4 1/30/19 1 1 6 3 0 1 2 1 3 2 1 1 5 7 6 11 10 17 14 4 7 7 1/30/19 1/30/19 1/30/19 1/30/19 1/30/19 1/30/19 1/30/19 1/30/19 1/30/19 1/30/19 2 2 6 10 8 18 14 4 4. 9 4 9 1 3 6 4 8 7 13 14 2 4 4 4 12 11 4 No 9 7 1 4 5 Yes 12 3 3 6 6 1 1 1 Yes No 5 20 32 25 45 40 76 72 15 21 26 66 28 81 63 57 49 50, 5 5 1 2 3 3 3 4 1 1 Yes 5 14 8 16 3 1/31/19 1/31/19 11 4 4 7 21 1 3 Yes Yes Yes 13 7 4 8 8 6 6 7 6 5 1/31/19 1/31/19 1/31/19 1/31/19 1/31/19 6 20 16 14 12 11 4 3 1 4 4 2 2 2 2 5 13 12 11 12 8 8 9 8 4 10 10 11 Yes Yes Yes No 3 3 8 8 10 A . D Wholesale Price List (per dozen) 2 Roses 23 3 Miniature Roses 14 4 Tulips 18 5 Lilies 19 6 Carnations 11 7 Baby's Breath = Add $5 per dozen to total order 9 Special Color = Add 20% to the prices 10 11 12 13 14 15 16 A B D 1 2 3 4 5 6 Total Flowers Ordered (Revenue) Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 7 110051 172162 85412 96325 123554 139856 80710 79854 80368 103621 91475 119105 Moving avg #N/A #N/A 122541.7 117966.3 101763.7 119911.7 114706.7 100140 80310.67 87947.67 91821.33 104733.7 8 9 10 11 12 Nov-18 Dec-18 13 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 A B D E F H 1 K L M N o P Yes 5 6 14 11 5 12 Yes 4 5 64 16 84 4 13 2 14 2 2 11 3 1 1 5 5 2 1 1 5 5 Yes Yes 17 16 16 4 Yes 4 1 1 19 5 19 4 8 2 7 10 3 5 1 11 2 Yes Tes Yes Yes Yes 4 1 77 17 7 7 7 74 51 2 1 1 0 0 2 18 4 16 14 4 2 1/25/19 1/25/19 1/25/19 1/25/19 1/25/19 1/25/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 1/28/19 2 0 9 7 6 1 2 11 2 10 2 4 18 11 7 2 3 11 5 14 1 1 14 10 2 2 3 3 14 4 11 2 0 1 1 4 1 Yes Yes No Yes Yes Yes Yes Yes 4 4 17 6 23 18 1 1 3 1 4 6 22 78 25 89 3 12 4 Yes 4 6 16 3 4 14 12 201 190298 202 190299 203 190300 204 190301 205 190302 206 190303 207 190304 208 190305 209 190306 210 190307 211 190308 212 190309 213 190310 214 190311 215 190312 216 190313 217 190314 218 190315 219 190316 220 190317 221 190318 222 190319 223 190320 224 190321 225 190322 226 190323 227 190324 228 190325 229 190326 230 190327 231 190328 232 190329 233 190330 234 190331 235 190332 236 190333 237 190334 238 190335 239 190336 240 190337 241 190338 3 2/11/19 Garcia 2/12/19 Garcia 2/1/19 Kim 2/12/19 Kim 2/11/19 Martin 2/11/19 Kim 2/12/19 Jones 2/11/19 Garcia 2/11/19 Jones 2/11/19 Rivera 2/12/19 Garcia 2/12/19 Rivera 2/11/19 Jones 2/11/19 Garcia 2/11/19 Garcia 2/11/19 Garcia 2/11/19 Smith 2/4/19 Rivera 2/4/19 Kim 2/12/19 Kim 2/11/19 Kim 2/11/19 Smith 2/4/19 Martin 2/12/19 Rivera 2/4/19 Kim 2/11/19 Kim 2/12/19 Martin 2/5/19 Jones 2/5/19 Garcia 2/5/19 Rivera 2/5/19 Jones 2/5/19 Kim 2/5/19 Rivera 2/11/19 Martin 2/5/19 Smith 2/12/19 Kim 2/5/19 Smith 2/5/19 Martin 2/5/19 Rivera 2/5/19 Smith 2/11/19 Martin Lilies Tulips Roses Tulips Lilies Lilies Roses Carnations Lilies Roses Roses Miniature Roses Roses Carnations Carnations Roses Roses Lilies Carnations Roses Carnations Roses Miniature Roses Miniature Roses Roses Roses Roses Roses Lilies Miniature Roses Roses Roses Roses Carnations Roses Carnations Roses Carnations Roses Carnations Lilies 10 7 10 5 5 3 3 2 3 3 1 7 9 9 4 4 14 10 12 5 5 25 23 3 6 2 2 9 6 15 15 0% E-mail 0% Main Website 0% Promotional Wet 15% Main Website 10% E-mail - 15% Phone % 0% Main Website 12% Phone 5% E-mail 12% Phone 5% E-mail E 0% Promotional Wet 5% Main Website 0% Promotional Wet 15% Main Website 0% Main Website 12% Promotional Wet 5% Main Website 15% E-mail 15% Main Website % 12% E-mail 0% Main Website 0% Phone 0% Promotional Wet 12% Main Website 0% Main Website 0% Promotional Wet 12% Main Website 5% Promotional Wet 0% Main Website 15% E-mail 5% Phone 15% E-mail 0% E-mail 15% Main Website 5% Main Website 15% Main Website 0% Main Website 0 0% Promotional Wet 15% Phone ............ 15% Promotional Wet Yes Yes Yes Yes Yes Yes Yes 3 3 2 6 4 1 4 4 12 15 2 10 8 4 4 5 11 13 67 46 51 25 83 83 14 28 12 7 3 1/28/19 2 2 4 1 1 5 5 3 5 2 1 3 1 2 1 0 2 1 1 1 1 1 3 10 Yes Yes Yes Yes 15 4 4 Yes 11 11 3 5 5 1 11 74 81 12 12 5 5 5 Yes Yes 4 1 30 7 19 7 22 11 4 5 15 1/28/19 1/28/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 Yes 19 18 6 21 11 18 1 19 5 . 10 1 6 6 14 2 2 13 6 16 7 11 1 12 7 10 2 5 1 4 4 2 4 0 3 3 3 10 1 11 Yes Yes Yes Yes Yes Yes Yes Yes 90 46 72 7 7 68 43 73 41 8 8 3 20 5 12 7 4 14 9 5 2 9 8 3 3 4 F G H 1 J K L M 4 1 1 2 2 2 3 4 5 5 5 21 3 4 3 17 11 17 2 1 4 4 2 1 3 3 2 Yes Yes Yes Yes Yes 7 5 B 1/7/19 1/7/19 1/7/19 1/7/19 1/7/19 1/7/19 1/7/19 1/7/19 1/7/19 1/7/19 1/7/19 3 16 7 15 16 22 18 79 44 78 71 9 19 19 8 2 5 3 4 Yes 8 2 2 3 3 3 11 8 10 12 1 13 16 2 8 15 14 4 11 Yes 1 0 0 1 6 1 7 2 11 14 11 A 190178 190179 190180 190181 190182 190183 190184 190185 190186 190187 190188 190189 190190 190191 190192 190193 190194 190195 190196 190197 190198 4 4 19 4 11 7 1 4 20 3 8 19 5 5 5 1 2 4 2 1 3 4 1/7/19 Yes Yes Yes Yes Yes Yes Yes 15 2 6 14 6 6 13 65 86 14 42 83 19 4 9 8 3 41 9 16 8 19 Yes 14 2 3 1 3 1 2 1 3 2 Yes Yes 5 3 5 3 3 1 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 0 4 4 1 1 6 C D 2/11/19 Martin 2/11/19 Smith 1/24/19 Kim 2/11/19 Rivera | 1/14/19 Kim 1/25/19 Kim 1/18/19 Martin 2/11/19 Rivera 2/12/19 Rivera 2/11/19 Kim 2/11/19 Kim 1/18/19 Rivera 1/18/19 Rivera 1/14/19 Kim 1/18/19 Martin 2/12/19 Smith 1/18/19 Kim 2/12/19 Kim 1/18/19 Garcia 2/12/19 Jones 2/12/19 Rivera 2/11/19 Kim 1/15/19 Kim 2/12/19 Kim 2/12/19 Kim 118/19 Kim. 2/11/19 Jones 2/11/19 Garcia 2/12/19 Rivera 1/16/19 Jones 1/16/19 Jones 1/17/19 Garcia 2/11/19 Kim 1/17/19 Smith 1/17/19 Smith 2/11/19 Garcia 1/17/19 Garcia 2/11/19 Kim 1/17/19 Kim 1/17/19 Kim 1/18/19 Rivera E E Roses Roses Tulips Roses Roses Roses Carnations Roses Roses Carnations Roses Miniature Roses Miniature Roses Roses Carnations Tulips Lilies Tulips Roses Roses Miniature Roses Carnations Roses Roses Carnations Roses Carnations Roses Lilies Roses Lilies Carnations Tulips Tulips Tulips Tulips Miniature Roses Tulips Carnations Roses Miniature Roses 1 11 17 3 2. 9 1 1 6 6 6 1 5 1 9 13 3 8 8 1 10 12 2 3 4 1 2 2 1 2 0 3 4 1 2 1 1 5 No Yes Yes Yes Yes Yes Yes 190199 N o 10% E-mail 15% Main Website 12% E-mail 10% E-mail 15% Main Website 12% Phone 0% Main Website 10% Main Website 10% Phone 0% Main Website 15% E-mail % 12% Main Website 0% Main Website 12% E-mail 0% Promotional Wet 12% E-mail 0% Main Website 0 % - 10% E-mail 12% E-mail 10% E-mail 12% Main Website 12% Main Website % 0% Phone 15% Main Website 12% Main Website 0% Main Website 0 12% Main Website 12% Promotional Wet 10% E-mail 0% Phone 10% Main Website 15% E-mail - 0% Phone 0% E-mail 0% Main Website 10% Main Website 10% Phone 10% Main Website 12% Phone 12% Phone 0% Phone 76 12 5 23 5 48 65 13 37 25 19 95 9 2 2 6 6 4 4 6 5 3 7 4 4 1 3 Yes 5 23 2 11 4 20 1/7/19 1/7/19 1/7/19 1/7/19 1/7/19 1/7/19 1/8/19 1/8/19 1/8/19 1/8/19 1/8/19 1/8/19 1/8/19 1/8/19 1/9/19 1/9/19 1/9/19 1/9/19 1/9/19 1/9/19 1/9/19 1/9/19 1/9/19 1/10/19 1/10/19 1/10/19 1/10/19 1/10/19 1/10/19 4 16 190200 190201 190202 190203 190204 190205 190206 190207 190208 3 16 6 5 Yes Yes 8 3 8 45 12 8 5 3 3 3 2 6 2 5 Yes No 5 7 5 1 2 3 Yes 3 11 31 3 26 11 13 Yes 190209 1 1 1 2 No 5 70 3 17 6 2 7 2 1 1 2 4 1 0 2 12 3 1 1 2 2 1 0 11 4 1 1 2 2 3 14 6 6 1 1 2 3 3 17 12 20 190210 190211 190212 190213 190214 190215 190216 190217 0 1 1 1 1 4 12 1 1 4 3 10 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes 23 6 6 10 16 63 65 82 24 7 4 14 7 9 12 14 4 4 5 8 5 6 120 121 17 5 5 11 12 4 190218 3 5 4 2 1 B B C D E F G G H 1 J J L M N 0 P 5 5 4 2 1 4 1/10/19 1/11/19 1/11/19 1/11/19 3 7 7 5 5 5 Yes Yes No No 13 9 13 9 18 9 11 6 8 4 2 4 4 4 3 4 9 6 8 1/14/19 Yes 24 7 64 40 53 39 27 12 41 86 9 4 9 2 2 7 Yes 7 7 7 6 5 5 2 1 4 2 1 Yes 2 3 1 1 2 1 2 Yes 6 3 9 16 5 11 10 22 6 13 16 4 4 8 6 8 3 2 6 43 190218 190219 190220 190221 190222 190223 190224 190225 190226 190227 190228 190229 190230 190231 190232 190233 190234 190235 190236 190237 190238 190239 Yes Yes Yes Yes No 9 4 4 4 4 1/14/19 1/14/19 1/14/19 1/14/19 1/14/19 1/14/19 1/14/19 1/14/19 1/14/19 1/14/19 1/14/19 1/14/19 1/14/19 1/14/19 1/14/19 1/15/19 1/15/19 1/18/19 Rivera 1/18/19 Garcia 1/18/19 Kim 1/18/19 Rivera 2/12/19 Garcia 1/24/19 Garcia 2/12/19 Jones 2/11/19 Jones 1/24/19 Jones 1/24/19 Jones 1/24/19 Smith 2/12/19 Kim 2/12/19 Martin 2/12/19 Kim 2/11/19 Kim 2/11/19 Rivera 1/24/19 Smith 1/24/19 Rivera 2/11/19 Martin 1/22/19 Kim 1/25/19 Rivera 1/22/19 Kim 2/11/19 Smith 1/25/19 Kim 1/25/19 Smith 2/11/19 Garcia 2/11/19 Garcia 1 1 1 2 1 1 1 1 1 3 3 3 3 6 16 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 4 4 Yes Yes Yes Yes Yes Yes 6 4 4 2 7 20 9 15 20 18 11 Miniature Roses Lilies Tulips Miniature Roses Roses Roses Carnations Carnations Roses Carnations Carnations Carnations Roses Roses Roses Roses Roses Miniature Roses Tulips Tulips Roses Roses Roses Carnations Roses Roses Tulips Miniature Roses Roses Tulips Carnations Miniature Roses Roses Tulips Roses Roses Miniature Roses Carnations Roses Miniature Roses Roses 17 3 9 17 10 14 15 16 6 11 10 8 8 4 2 2 1 4 11 5 5 10 8 10 3 3 6 6 6 5 2 6 2 2 4 4 3 3 2 2 5 15 5 14 13 15 5 7 8 7 3 8 3 8 2 8 13 18 17 13 34 87 39 73 82 82 27 52 45 2 4 5 4 1 3 3 No Yes Yes 2 5 4 4 1 3 2 3 1 2 2 1 3 7 14 8 8 --- 4 0% Phone 0% Main Website 0% Promotional Wet 0% Main Website 0% Promotional Wel 5% Main Website 0% E-mail 10% Phone 5% Main Website 12% E-mail % - 0% E-mail 0% E-mail 0% Phone 0% Promotional Wet 0% Phone 0% Phone 5% Main Website 5 15% Phone % 12% Main Website 5% Main Website 0% E-mail 5% Main Website 0% Promotional Wet 5% 5% Phone 0% Main Website % 0% Main Website 10% Phone 15% Promotional Wet 0% Phone 10% E-mail 0% Phone 0% Main Website 12% Main Website 12% E-mail 10% Main Website 10% Promotional Wet 0% E-mail 0% Promotional Wet 5% Promotional Wel 5% E-mail 0% Promotional Wel 190240 1/15/19 Yes 7 Yes 1 Yes 15 4 4 8 8 8 3 9 9 2 6 2 7 10 3 3 1 8 8 4 8 8 2 3 190241 190242 190243 190244 190245 190246 190247 190248 190249 190250 190251 190252 190253 9 3 10 2 14 16 9 Yes Yes Yes Yes 1/23/19 Rivera 1 7 8 2 1 3 1 3 4 4 2 Yes 41 18 45 16 41 12 57 69 34 47 70 5 Yes Yes 4 6 z 1/15/19 1/15/19 1/16/19 1/16/19 1/16/19 1/16/19 1/16/19 1/16/19 1/16/19 1/16/19 1/16/19 1/16/19 1/16/19 1/17/19 1/17/19 1/17/19 1/17/19 1/17/19 4 15 13 7 9 15 14 3 3 5 7 11 1/23/19 Jones 1/23/19 Jones 2/11/19 Jones 2/12/19 Rivera 1/23/19 Kim 2/11/19 Smith 2/12/19 Smith 2/12/19 Kim 1/25/19 Garcia 2/12/19 Jones 2/11/19 Garcia 1/24/19 Rivera 1/25/19 Smith 5 9 7 7 4 7 11 16 12 77 13 15 19 15 9 10 2 14 13 Yes No Yes Yes Yes 4 5 3 3 2 1 155 156 157 158 159 160 161 3 4 3 3 3 13 10 6 190254 9 13 11 64 47 50 15 6 7 Yes 1 3 Yes 190255 190256 190257 190258 2 6 6 3 3 16 5 11 3 12 3 3 4 Yes 10 3 65 20 4 1 1 Yes G H 1 J J M 0 P F 14 10 + 4 L 1 IU 3 res 05 Yes 4 11 3 7 5 17 1 1 3 > 1 3 3 5 5 2 20 66 Yes 13 11 16 3 Yes 14 11 IZ 3 12 16 6 10 10 6 9 2 7 Yes 4 3 Yes 10 5 7 9 9 4 3 3 4 10 15 6 7 7 4 13 13 6 6 6 10 8 12 4 6 6 1 Yes Yes Yes 1 2 2 5 5 75 42 55 67 28 31 35 8 7 2 2 7 4 5 Yes 8 8 Yes 0 E IvaLure nuses Roses Miniature Roses Roses Miniature Roses Roses Roses Tulips Carnations Carnations Lilies Roses Tulips Roses Miniature Roses Roses Miniature Roses Roses Miniature Roses Tulips Carnations Carnations Carnations 0 1 No 2 23 2 20 11 1 11 4 5 Yes 91 17 8 9 9 1 11 5 5 4 4 3 3 5 7 8 5 4 4 6 6 2 2 2 1 1 2 8 8 4 4 6 12 10 4 3 2 2 2 3 Yes Yes Yes Yes 5 5 5 3 8 45 38 26 25 48 6 Yes 7 3 2 9 Yes 3 1 1 3 100 19023 161 190258 162 190259 163 190260 164 190261 165 190262 166 190263 167 190264 168 190265 169 190266 170 190267 171 190268 172 190269 173 190270 174 190271 175 190272 1176 190273 177 190274 178 190275 179 190276 180 190277 181 190278 182 190279 183 190280 184 190281 185 190282 186 190283 187 190284 188 190285 189 190286 190 190287 191 190288 192 190289 193 190290 194 190291 195 190292 196 190293 197 190294 198 190295 199 190296 200 190297 2011 190298 Yes B 1/11/19 1/17/19 1/17/19 1/17/19 1/17/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/22/19 1/23/19 1/23/19 1/23/19 1/23/19 1/23/19 1/23/19 1/23/19 1/23/19 1/23/19 1/23/19 1/23/19 1/24/19 1/24/19 1/24/19 1/25/19 D 1/24719 Niveld 1/25/19 Smith 1/25/19 Rivera 2/12/19 Martin 1/25/19 Rivera 1/29/19 Jones 2/12/19 Garcia 2/1/19 Jones 2/1/19 Jones 2/12/19 Garcia 2/12/19 Garcia 2/12/19 Garcia 2/1/19 Jones 1/29/19 Kim 2/1/19 Rivera 1/29/19 Martin 1/29/19 Rivera 1/29/19 Kim 2/1/19 Martin 2/1/19 Kim 2/12/19 Kim 2/1/19 Kim 2/11/19 Kim 2/11/19 Smith | 2/12/19 Kim 1/29/19 Martin 2/12/19 Kim 2/12/19 Rivera 2/12/19 Garcia 2/1/19 Jones 2/11/19 Garcia 2/11/19 Jones 2/11/19 Kim 2/12/19 Smith 2/1/19 Martin 2/12/19 Kim 1/30/19 Kim 2/1/19 Smith 2/12/19 Martin 2/12/19 Martin 2/1/19 Kim 2/11/19 Garcia 8 3 8 Yes 12 11 5 14 12 11 7 1 3 4 9 3 11 7 7 9 9 4 4 1 5 N 3% C-TTDI 0% Promotional Wet 0 0% Main Website 0% Main Website 10% Phone % 12% Phone % 5% Main Website 10% Promotional Wet 10% E-mail 15% Main Website 15% Main Website 15% Promotional Wet 15% Promotional Wel 15% Main Website 0% Main Website 0% E-mail 5% Main Website 15% E-mail E- 0% Phone 15% Main Website 5% Phone 5% Phone 5 0% Promotional Wet 10% Main Website 15% E-mail 0% Main Website 0% Phone 10% Phone 15% Promotional Wet 10% Promotional Wet 0% Main Website 0% Main Website 0 15% Promotional Wet 0% Promotional Web 12% Main Website 0% Main Website 15% Promotional Wet 0% Phone 12% Promotional Wet 0% E-mail - 0% E-mail E- 0% F-mail 4 9 Yes 3 11 15 10 8 1 7 7 Roses 5 3 3 1 3 2 0 10 5 1 1 2 0 0 51 20 58 56 51 31 5 34 6 82 Yes Yes Yes 6 7 1 16 7 17 3 4 1 7 3 2 2 22 10 2 0 5 5 2 2 Yes Yes Yes 1 14 7 16 2 6 1 14 7 7 13 Yes 39 84 9 2 0 4 3 5 1 1 1 2 5 19 5 Yes 1 Yes 3 4 4 3 | Carnations Roses Roses Roses Carnations Roses Roses Roses Roses Carnations Lilies Carnations Carnations Roses Roses Roses Roses Lilies 4 10 18 Yes Yes 8 1 1 5 9 6 2 8 2 3 6 13 1 3 5 7 16 22 Yes Yes Yes 13 17 41 88 6 17 66 48 1 1 3 16 4 11 14 3 3 13 3 3 10 4 4 Yes 10 8 2 2 7 No 0 0 1 Yes 6 1 12 13 5 1 7 5 2 14 14 1 8 11 3 Yes 3 3 11 10 3 Yes 58 59 5 5 Yes 0 0 Date Total 70 75 62 26 11 18 88 1/2/19 28 59 72 43 82 85 31 11 44 37 A B D E F G H J K K L M N o P 1 Columr Column2 Column3 Column Columns Colu Colun Columns Colum: Colur Col Colur Col Colu ColuColumn13 Column1 Column15 Column16 2 The Whole Bouquet - A Floral Wholesale Supplier 3 January Orders (by Dozen) ( Delivery 4 Order Order Date Customer Floral Type Red White Light Pink Dark Pink Yellow Lilac Special Baby's Breath? Discounts Order Source 5 190101 1/2/19 1/11/19 Garcia Roses 21 8 8 13 9 4 4 11 Yes 15% Phone 6 190102 1/2/19 2/11/19 Jones Tulips 15 8 16 13 6 5 12 Yes 0% Main Website 7 190103 1/2/19 2/12/19 Jones Carnations 16 8 12 11 3 4 8 Yes 0% Phone 8 190104 1/2/19 2/11/19 Rivera Roses 5 3 5 5 4 2 2 2 2 5 5 Yes 0% Promotional Wet 9 190106 1/2/19 1/11/19 Garcia Tulips 2 1 2 2 1 1 1 2 2 Yes 0% Main Website 10 190107 1/2/19 1/9/19 Jones Roses 4 2 4 3 1 1 3 3 Yes 0% Main Website 0% 11 190108 1/11/19 Jones Roses 19 8 23 12 5 5 16 No 0% Phone 0 12 190109 1/2/19 2/11/19 Rivera Miniature Roses 7 7 3 6 4 2 2 4 Yes 15% Main Website 13 190110 1/2/19 1/9/19 Garcia Carnations 10 7 14 12 3 4 9 Yes 0% Promotional Wet 14 190111 1/2/19 2/12/19 Jones Carnations 14 9 15 14 5 5 4 4 11 No 12% Phone 15 190112 1/2/19 2/11/19 Martin Miniature Roses 10 6 8 9 2 2 6 Yes 15% Phone 16 190113 1/2/19 2/12/19 Martin Carnations 18 8 18 16 6 5 11 No 0% Phone 17 190114 1/2/19 1/9/19 Kim Roses 19 8 8 15 16 5 5 17 Yes 12% Phone 18 190115 1/2/19 2/11/19 Kim Roses 7 3 8 5 2 2 1 5 5 Yes 15% E-mail E 19 190116 1/2/19 2/12/19 Kim Roses 2 1 1 2 2 1 1 2 Yes 0% Promotional Wet 20 190117 1/2/19 2/12/19 Kim Roses 10 4 10 7 2 3 8 Yes 12% Phone 21 190118 1/2/19 2/11/19 Kim Roses 9 4 9 4 2 2 2 7 No 12% Main Website 22 190119 1/2/19 2/12/19 Kim Roses 17 8 18 10 4 4 5 5 13 Yes 15% Main Website 23 190120 1/2/19 1/9/19 Smith Roses 4 2 3 3 1 1 2 Yes 5% Phone 24 190121 1/2/19 2/12/19 Martin Carnations 3 2 3 2 1 1 1 3 Yes 15% Phone 25 190122 1/2/19 1/9/19 Kim Roses 5 3 5 3 1 1 1 3 3 Yes 15% Phone 26 190123 1/2/19 1/11/19 Rivera Miniature Roses 7 4 9 5 2 2 5 Yes 15% Phone 27 190124 1/2/19 1/9/19 Kim Roses 1 1 1 1 1 0 0 1 Yes 5% E-mail 5- 28 190125 1/2/19 1/11/19 Kim Roses 6 4 6 7 2 1 5 No 12% Promotional Wet 29 190126 1/3/19 2/11/19 Jones Roses 4 2 4 4 1 1 3 Yes 12% E-mail 30 190127 1/3/19 2/12/19 Garcia Tulips 13 6 11 7 3 3 2 10 Yes 5% Main Website 31 190128 1/3/19 2/11/19 Garcia Roses 2 1 1 2 2 0 1 2 Yes 0% Main Website 32 190129 1/3/19 1/10/19 Garcia Carnations 22 8 8 19 16 4 5 17 Yes 12% E-mail 33 190130 1/3/19 2/12/19 Kim Roses 2 1 3 2 2 1 1 1 3 3 Yes 15% Main Website 34 190131 1/3/19 1/10/19 Smith Tulips 17 8 18 14 5 5 4 13 Yes 15% E-mail 35 190132 1/3/19 2/12/19 Rivera Miniature Roses 11 5 11 10 3 3 3 7 Yes 0% Main Website 36 190133 1/3/19 1/11/19 Smith Carnations 4 2 4 3 1 1 3 Yes 15% Main Website 37 190134 1/3/19 2/11/19 Kim Roses 21 8 15 13 4 5 5 11 Yes 15% Main Website 38 190135 1/3/19 2/11/19 Kim Roses 2 2 1 1 1 1 0 0 0 1 NO 15% Main Website 39 190136 1/3/19 | 2/12/19 Kim Roses 3 2 3 2 1 1 3 Yes 12% Promotional Wet 40 190137 1/4/19 1/18/19 Rivera Miniature Roses 11 6 12 7 2 3 3 8 Yes 12% Main Website 41 190138 1/4/19 2/12/19 Garcia Roses 2 1 1 1 1 0 o 0 1 Yes % 0% Promotional Wet 42 190139 1/4/19 1/18/19 Kim Tulips 7 3 10 5 2 2 2 8 Yes 10% E-mail 43 190140 1/4/19 1/18/19 Rivera Miniature Roses 5 3 8 4 4 2 1 5 5 Yes 12% Main Website 44 190141 1/4/19 1/18/19 Kim Roses 9 4 8 5 2 2 6 Yes 12% Main Website 45 190142 1/4/19 2/12/19 Martin Lilies Yes 12% Promotional Wet 75 16 15 21 34 5 31 19 52 10 91 13 79 50 18 77 6 15 49 6 37 28 36 7 G H 1 J K M P 7 5 ID 7 4 2 2 F 21 11 18 1 19 ZZ 11 14 2 2 13 2 4 5 10 1 6 L 15 8 10 1 11 Yes Yes Yes 11 1 0 B B 1/29719 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/29/19 1/30/19 1/30/19 1/30/19 5 1 4 3 5 5 2 8 12 7 10 8 8 20 yu 46 72 7 68 43 73 41 4 3 3 5 3 8 14 9 - 12 9 6 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes 9 3 2 7 10 14 4 11 6 7 4 4 4 5 10 7 4 4 7 11 8 8 7 7 11 15 18 8 9 11 13 12 6 11 14 15 12 5 8 8 5 4 2 2 2 13 5 7 1/30/19 3 2 2 3 4 3 3 4 10 13 16 18 21 4 3 16 12 10 13 18 3 13 1/30/19 1/30/19 1/30/19 1/30/19 1/30/19 1/30/19 1/30/19 1/30/19 1/30/19 10 6 47 72 69 32 43 57 79 67 76 36 59 66 22 48 7 5 2 2 3 3 255 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 4 2 2 4 A 190550 190331 190332 190333 190334 190335 190336 190337 190338 190339 190340 190341 190342 190343 190344 190345 190346 190347 190348 190349 190350 190351 190352 190353 190354 190355 190356 190357 190358 190359 190360 190361 190362 190363 190364 190365 190366 190367 190368 190369 190370 7 8 D D 275719 Rivera 2/11/19 Martin 2/5/19 Smith 2/12/19 Kim 2/5/19 Smith 2/5/19 Martin 2/5/19 Rivera 2/5/19 Smith 2/11/19 Martin 2/12/19 Kim 2/6/19 Jones 2/11/19 Garcia 2/6/19 Jones 2/11/19 Jones 2/11/19 Garcia 2/6/19 Jones 2/6/19 Jones 2/12/19 Garcia 2/6/19 Garcia 2/6/19 Garcia 2/6/19 Garcia 2/12/19 Jones 2/12/19 Jones 2/6/19 Smith 2/11/19 Martin 2/6/19 Martin 2/12/19 Kim 2/6/19 Smith 2/6/19 Martin 2/6/19 Kim 2/6/19 Kim 2/6/19 Kim 2/6/19 Rivera 2/12/19 Martin 2/11/19 Jones 2/11/19 Rivera 2/12/19 Martin 2/12/19 Kim 2/12/19 Kim 2/11/19 Martin | 2/12/19 Kim E Roses Carnations Roses Carnations Roses Carnations Roses Carnations Lilies Roses Roses Tulips Carnations Carnations Carnations Roses Carnations Carnations Roses Carnations Roses Roses Roses Roses Roses Carnations Carnations Roses Carnations Roses Roses Roses Miniature Roses Miniature Roses Carnations Roses Carnations Roses Carnations Roses Roses 7 13 14 4 10 14 18 5 10 1 1 4 4 1 N 0 15% E-mail 0% E-mail 15% Main Website 5% Main Website 15% Main Website 0% Main Website 0% Promotional Wet 15% Phone 15% Promotional Wet 0% Phone 0% Promotional Wet 0% E-mail 15% E-mail 0% Main Website 5% Phone 15% Main Website 12% Promotional Wet 5% E-mail 12% Phone 15% Main Website 12% Main Website 0% Main Website 0% E-mail 15% E-mail E 15% Phone 15% Phone 0% Phone 0% Main Website 15% E-mail 0% Promotional Wet 0% E-mail 0 0% Phone 15% Phone 0% Main Website 15% Promotional Wet 12% E-mail 15% Main Website 0% Main Website 0% E-mail 15% Promotional Wet 0% Main Website 11 12 3 9 1 4 6 3 2 3 0 Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes 6 6 6 6 3 3 4 1 2 4 3 4 4 4 4 1/30/19 1 1 6 3 0 1 2 1 3 2 1 1 5 7 6 11 10 17 14 4 7 7 1/30/19 1/30/19 1/30/19 1/30/19 1/30/19 1/30/19 1/30/19 1/30/19 1/30/19 1/30/19 2 2 6 10 8 18 14 4 4. 9 4 9 1 3 6 4 8 7 13 14 2 4 4 4 12 11 4 No 9 7 1 4 5 Yes 12 3 3 6 6 1 1 1 Yes No 5 20 32 25 45 40 76 72 15 21 26 66 28 81 63 57 49 50, 5 5 1 2 3 3 3 4 1 1 Yes 5 14 8 16 3 1/31/19 1/31/19 11 4 4 7 21 1 3 Yes Yes Yes 13 7 4 8 8 6 6 7 6 5 1/31/19 1/31/19 1/31/19 1/31/19 1/31/19 6 20 16 14 12 11 4 3 1 4 4 2 2 2 2 5 13 12 11 12 8 8 9 8 4 10 10 11 Yes Yes Yes No 3 3 8 8 10 A . D Wholesale Price List (per dozen) 2 Roses 23 3 Miniature Roses 14 4 Tulips 18 5 Lilies 19 6 Carnations 11 7 Baby's Breath = Add $5 per dozen to total order 9 Special Color = Add 20% to the prices 10 11 12 13 14 15 16 A B D 1 2 3 4 5 6 Total Flowers Ordered (Revenue) Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 7 110051 172162 85412 96325 123554 139856 80710 79854 80368 103621 91475 119105 Moving avg #N/A #N/A 122541.7 117966.3 101763.7 119911.7 114706.7 100140 80310.67 87947.67 91821.33 104733.7 8 9 10 11 12 Nov-18 Dec-18 13 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Global Financial Systems Stability And Risk

Authors: Jon Danielsson

1st Edition

0273774662, 9780273774662

More Books

Students also viewed these Accounting questions

Question

Define learning and list at least three learning principles

Answered: 1 week ago