TOTAL MARKS: 50 Marks Machine Problem. Direction: Read, analyze and perform what is/are required. 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 3^rd 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. Instructions 1. Download the ICP DataSheet File from the Moodle. 2. Open the ICP DataSheet File Excel file and perform what is required. 5. Save your file with BH(studentnumber) Group __. Student number refers to your student number. 6. Submit your answer to the MOODLE Requirement. PART I. Using the PIVOT TABLE, create INCOME STATEMENT

1. You need to compute the sales, gross profit, expenses and net income.
2. 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. Rubric:

	10-8	7-5	4- 0
A. Ability to use MS Excel to implement the conceptual models of information systems	Has in-depth clear understanding on how use MS Excel to manage data	Clear understanding On how to use MS Excel to manage data	Barely understood how to use MS Excel or none at all.
	10-8	7-5	4- 0
B. Ability to employ model-building techniques	All tables were created with 80-100% attributes are correct	All tables were created with 40-79% attributes are correct	Not all tables were created and/or less 40% attributes are correct
	20-12	11-6	5-0
C. Ability to develop Interactive Dashboard to support business decisions making	All dashboard were created with 80-100% attributes are correct	All dashboard were created with 40-79% attributes are correct	Not all dashboard were created and/or less 40% attributes are correct

RUBRICS FOR PRESENTATION

10 - 8	7-5	4-3	2-0
exceptional delivery and timing of information exceptional discussion initiated and maintainedto further student learning Reportis exceptionally detailed, organized, logical and includes images, clear and large font	proficient delivery and timing of information proficient discussion started and maintained Report is detailed, organized, logical and includes images, clear and large font	delivery and timing of information needs to be more smooth (too much reading) more active interaction and discussion Report is somewhat organized and includes some images	poor delivery and timing of information discussion needs to be more controlled and dynamic Report needs to be more organized and logical

Attachments:

comp643-final....docx