ForrestGreen followed in the footsteps of his Father, Tony Green, and spent most of his adult life working with flowers. He worked for a large commercial flower grower while he got his online degree in horticulture for Colorado State University. After graduation, he traveled extensively to see how flowers are grown around the world. He spent a year at the Dutch Flower Auction where European flower growers, members of the Dutch Flower Wholesale Association, assembled their flowers in a 2 million square meter warehouse for buyers from around the world. He then spent some time in Kenya, which is surprisingly the 3rd largest exporter of cut flowers in the world. Kenya enjoys a sunny climate that enables high-quality blossoms to be grown year-round. After working with large flower

distribution organizations, he recognized the inherent problems created by shipping flowers around the world from remote locations. First, it was getting more expense as the cost of jet fuel and transportation increases. Second, consumers were becoming more demanding. They wanted fresher flowers that lasted longer.

PART I. Using the PIVOT TABLE, create INCOME STATEMENT

a) You need to compute the sales, gross profit, expenses and net income.

b) The data should be clustered by Business Unit and Product Line.

2. Using the PIVOT TABLE, create a summary of revenues per Country and per product line. This should be placed on DASHBOARD SHEET.

3. Using the PIVOT CHART, create a

a. COMPARATIVE ANALYSIS OF REVENUE AND NET INCOME per RETAILER

b. REVENUE SUMMARY - PER MONTH

c. REVENUE SUMMARY PER COUNTRY

d. NET INCOME SUMMARY - PER MONTH

e. GROSS PROFIT PER PRODUCT LINE

Note:

PUT the CHARTS on the DASHBOARD SHEET. The table should be on another sheet.

4. Using PIVOT table and PIVOT Chart, create an information which you think that the manager needs to know. Your group has to decide what information you want to put in your dashboard. (minimum of 5 charts). Your Dashboard should be interactive.