. 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.

This submission should be organized with titles, labels, column headings, etc. as appropriate.

Use Excel Workbook

The Prices Tab:

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 . 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