Accounting Information Systems

Excel Assgm. Question

stacked line graph

Product Details

Customer ID Customer Name

Customer Address

Product Name Category

Cost of Sales

055

111 569

Biscuits Mix

6

16

Judy Street, Albury NSW 2000

Coffee

2%

9

Coffee

$ 65.0 20% 2% Andrew Cencini

5

10/1/19

Global Shipping Company

19

10/1/19 10/5/19 Global Shipping Company

14

Katherine Drive, Perth WA 6010

5% 3%

20007 10/1/19 10/4/19 Taurus Logistics Chocolate 12

4% Laura Giussani 20160 10/1/19 10/4/19 Global Shipping Company

$ 53.0 5% 4% Laura Giussani 20103 10/1/19 10/6/19 Taurus Logistics Chocolate 24

0% Laura Giussani 20120 10/1/19

Chocolate Candy $ 51.0 5% 0%

20096 10/1/19 10/3/19 Global Shipping Company Clam Chowder 23

Pies and Rolls Cafe

25 Gloria Circuit, Ballarat VIC 3090

0% Anne Larsen 20166 10/1/19 10/6/19 Global Shipping Company Coffee 12

Baked Goods & Mixes $ 58.0 10% 0% Anne Larsen 20179 10/1/19 10/5/19 Global Shipping Company Dried Plums 21

20145

Clam Chowder

4% 0% Andrew Cencini 20145 10/1/19 10/4/19 Global Shipping Company Chai 23

20023

Beer Beverages $ 65.0

3% Andrew Cencini 20023 10/1/19 10/6/19 Taurus Logistics Coffee 13

Almonds Dried Fruit & Nuts $ 53.0 10% 3% Andrew Cencini 20048 10/1/19 10/4/19 Taurus Logistics

20

Oil

3% Andrew Cencini 20073 10/1/19 10/5/19 Taurus Logistics Boysenberry Spread 20

Third Wave Cafe

$ 67.0

2% Andrew Cencini 20200 10/1/19 10/6/19 Evergreen Shipping Company

24

20023

Beverages $ 55.0

3% Nancy Freehafer 20023 10/1/19 10/5/19 Evergreen Shipping Company Chocolate 20

30 Gabriel Street, Adelaide SA 5090

Boysenberry Spread Jams, Preserves

4% Nancy Freehafer 20068 10/1/19 10/5/19 Taurus Logistics

22

$ 51.0

4% Ethan Nolan

10/1/19 10/3/19 Taurus Logistics Chocolate 19

Chai Beverages

5% Ethan Nolan

10/1/19 10/6/19 Global Shipping Company Curry Sauce 12

Condiments

13% 5% Ethan Nolan 20084

10/6/19 Global Shipping Company Olive Oil 20

Dried Pears Dried Fruit & Nuts $ 59.0 14% 4% Nancy Freehafer 20145 10/2/19 10/6/19 Evergreen Shipping Company Marmalade 20

Pasta $ 51.0 11% 3% Andrew Cencini 20007 10/2/19 10/6/19 Evergreen Shipping Company Chocolate Biscuits Mix 15

Dried Apples Dried Fruit & Nuts

3% Andrew Cencini 20160 10/2/19 10/4/19 Evergreen Shipping Company Chocolate Biscuits Mix 24

Laura Giussani 20103 10/2/19 10/5/19 Global Shipping Company Crab Meat 17

Ethan Nolan 20166 10/2/19

Evergreen Shipping Company Chocolate 17

Customer ID Payment Type Laura Giussani 20179 10/2/19 10/7/19 Taurus Logistics Long Grain Rice 19
20055

Laura Giussani 20145 10/2/19 10/7/19 Global Shipping Company Dried Plums 19

20022

Laura Giussani 20023 10/2/19 10/6/19 Global Shipping Company Olive Oil 13

20084 Credit Card Anne Larsen 20084 10/2/19 10/5/19 Global Shipping Company Mozzarella 23
20145 Cheque Anne Larsen 20145 10/2/19 10/5/19 Global Shipping Company Syrup 19
20007 Credit Card Anne Larsen 20007 10/2/19 10/7/19 Global Shipping Company Curry Sauce 24
20160 Credit Card Andrew Cencini 20160 10/2/19 10/4/19 Taurus Logistics Green Tea 14
20103 Cheque Andrew Cencini 20103 10/2/19 10/7/19 Evergreen Shipping Company Chocolate Biscuits Mix 22
20120 Cheque Andrew Cencini 20120 10/2/19 10/6/19 Global Shipping Company Dried Plums 17
20096 Credit Card Andrew Cencini 20096 10/2/19 10/6/19 Global Shipping Company Dried Plums 12
20166 Credit Card Andrew Cencini 20166 10/2/19 10/5/19 Evergreen Shipping Company Chocolate 16
20179 Credit Card Nancy Freehafer 20179 10/2/19 10/4/19 Evergreen Shipping Company Beer 23
20145 Cheque Nancy Freehafer 20145 10/2/19 10/5/19 Evergreen Shipping Company Crab Meat 21
20023 Credit Card Ethan Nolan 20023 10/3/19 10/6/19 Taurus Logistics Coffee 23
20048 Cheque Ethan Nolan 20048 10/3/19

Global Shipping Company Green Tea 22

20073 Cheque Ethan Nolan 20073 10/3/19 10/8/19 Evergreen Shipping Company Coffee 16
20200 Cheque Nancy Freehafer 20200 10/3/19 10/8/19 Global Shipping Company Crab Meat 16
20023 Credit Card Andrew Cencini 20023 10/3/19 10/8/19 Global Shipping Company Mozzarella 16
20068 Cheque Andrew Cencini 20068 10/3/19 10/5/19 Global Shipping Company Clam Chowder 13
Laura Giussani 20055 10/3/19 10/7/19 Taurus Logistics Long Grain Rice 23
Ethan Nolan 20022 10/3/19 10/7/19 Taurus Logistics Coffee 24
Laura Giussani 20084 10/3/19 10/5/19 Taurus Logistics Chocolate 12
Laura Giussani 20145 10/3/19 10/8/19 Taurus Logistics Coffee 19
Laura Giussani 20007 10/3/19 10/8/19 Global Shipping Company Boysenberry Spread 22
Anne Larsen 20160 10/3/19 10/8/19 Global Shipping Company Curry Sauce 18
Anne Larsen 20103 10/3/19 10/5/19 Global Shipping Company Curry Sauce 18
Anne Larsen 20120 10/3/19 10/7/19 Global Shipping Company Clam Chowder 13
Andrew Cencini 20096 10/3/19 10/7/19 Global Shipping Company Mozzarella 21
Andrew Cencini 20055 10/3/19 10/6/19 Taurus Logistics Chai 21
Andrew Cencini 20022 10/3/19 10/8/19 Global Shipping Company Curry Sauce 14
Andrew Cencini 20084 10/3/19 10/5/19 Taurus Logistics Dried Plums 21
Andrew Cencini 20145 10/4/19 10/7/19 Evergreen Shipping Company Crab Meat 16
Nancy Freehafer 20007 10/4/19 10/7/19 Global Shipping Company Curry Sauce 20
Nancy Freehafer 20160 10/4/19 10/7/19 Evergreen Shipping Company Crab Meat 19
Ethan Nolan 20103 10/4/19 10/6/19 Taurus Logistics Ravioli 24
Ethan Nolan 20120 10/4/19

Evergreen Shipping Company Clam Chowder 19

Ethan Nolan 20096 10/4/19 10/6/19 Evergreen Shipping Company Chocolate 14
Nancy Freehafer 20166 10/4/19 10/7/19 Taurus Logistics Beer 23
Andrew Cencini 20179 10/4/19 10/9/19 Global Shipping Company Curry Sauce 15
Andrew Cencini 20145 10/4/19 10/6/19 Global Shipping Company Chocolate Biscuits Mix 21
Laura Giussani 20023 10/4/19 10/9/19 Global Shipping Company Dried Plums 24
Ethan Nolan 20048 10/4/19 10/6/19 Evergreen Shipping Company Chocolate Biscuits Mix 13
Laura Giussani 20073 10/4/19 10/9/19 Taurus Logistics Dried Plums 15
Laura Giussani 20200 10/4/19 10/9/19 Evergreen Shipping Company Chocolate Biscuits Mix 13
Laura Giussani 20023 10/4/19 10/8/19 Evergreen Shipping Company Chocolate 21
Anne Larsen 20068 10/4/19 10/9/19 Taurus Logistics Green Tea 16
Anne Larsen 20055 10/4/19 10/7/19 Global Shipping Company Chai 20
Anne Larsen 20022 10/4/19 10/7/19 Evergreen Shipping Company Clam Chowder 21
Andrew Cencini 20084 10/4/19 10/7/19 Global Shipping Company Curry Sauce 15
Andrew Cencini 20145 10/4/19 10/6/19 Global Shipping Company Curry Sauce 14
Andrew Cencini 20007 10/4/19 10/9/19 Evergreen Shipping Company Chocolate Biscuits Mix 24
Andrew Cencini 20160 10/5/19 10/9/19 Global Shipping Company Crab Meat 13
Ethan Nolan 20084 10/5/19

Taurus Logistics Fruit Cocktail 13

Nancy Freehafer 20145 10/5/19 10/9/19 Global Shipping Company Gnocchi 13
Andrew Cencini 20007 10/5/19 10/7/19 Taurus Logistics Almonds 18
Andrew Cencini 20160 10/5/19 10/7/19 Evergreen Shipping Company Green Tea 16
Laura Giussani 20103 10/5/19 10/7/19 Taurus Logistics Fruit Cocktail 15
Ethan Nolan 20120 10/5/19 10/7/19 Taurus Logistics Dried Plums 21
Laura Giussani 20096 10/5/19 10/7/19 Taurus Logistics Coffee 23
Laura Giussani 20166 10/6/19 10/10/19 Evergreen Shipping Company Clam Chowder 13
Laura Giussani 20179 10/6/19 10/10/19 Taurus Logistics Coffee 24
Anne Larsen 20145 10/6/19

Taurus Logistics Chocolate 23

Anne Larsen 20023 10/6/19 10/11/19 Global Shipping Company Coffee 21
Anne Larsen 20048 10/6/19 10/8/19 Global Shipping Company Dried Plums 14
Andrew Cencini 20073 10/6/19 10/9/19 Global Shipping Company Curry Sauce 18
Andrew Cencini 20200 10/6/19 10/9/19 Evergreen Shipping Company Crab Meat 15
Andrew Cencini 20023 10/6/19 10/11/19 Taurus Logistics Green Tea 14
Andrew Cencini 20068 10/6/19 10/10/19 Evergreen Shipping Company Crab Meat 13
Andrew Cencini 20055 10/6/19 10/11/19 Evergreen Shipping Company Chocolate Biscuits Mix 14
Nancy Freehafer 20022 10/6/19 10/8/19 Evergreen Shipping Company Chocolate 19
Nancy Freehafer 20084 10/6/19 10/9/19 Evergreen Shipping Company Chocolate Biscuits Mix 18
Ethan Nolan 20145 10/6/19 10/11/19 Global Shipping Company Coffee 15
Ethan Nolan 20007 10/6/19 10/8/19 Global Shipping Company Syrup 20
Ethan Nolan 20160 10/6/19 10/11/19 Taurus Logistics Boysenberry Spread 21
Nancy Freehafer 20103 10/6/19 10/10/19 Taurus Logistics Long Grain Rice 13
Nancy Freehafer 20120 10/7/19 10/9/19 Taurus Logistics Long Grain Rice 22
Andrew Cencini 20096 10/7/19 10/11/19 Global Shipping Company Beer 12
Andrew Cencini 20055 10/7/19 10/11/19 Global Shipping Company Clam Chowder 13
Laura Giussani 20022 10/7/19 10/10/19 Taurus Logistics Dried Pears 14
Ethan Nolan 20084 10/7/19 10/9/19 Taurus Logistics Scones 14
Laura Giussani 20145 10/7/19 10/9/19 Global Shipping Company Dried Plums 19
Laura Giussani 20007 10/7/19 10/10/19 Global Shipping Company Green Tea 23
Laura Giussani 20160 10/7/19 10/9/19 Taurus Logistics Almonds 22
Anne Larsen 20103 10/7/19 10/9/19 Global Shipping Company Cajun Seasoning 16
Anne Larsen 20120 10/7/19 10/9/19 Evergreen Shipping Company Coffee 20
Anne Larsen 20096 10/7/19 10/11/19 Taurus Logistics Chocolate 21
Andrew Cencini 20166 10/7/19 10/10/19 Global Shipping Company Olive Oil 16
Andrew Cencini 20179 10/7/19 10/10/19 Taurus Logistics Ravioli 18
Andrew Cencini 20145 10/8/19

Global Shipping Company Dried Plums 19

Andrew Cencini 20023 10/8/19 10/10/19 Evergreen Shipping Company Chocolate 19
Andrew Cencini 20048 10/8/19

Evergreen Shipping Company Chocolate 20

Nancy Freehafer 20073 10/8/19 10/13/19 Global Shipping Company Mozzarella 16
Nancy Freehafer 20200 10/8/19 10/12/19 Global Shipping Company Clam Chowder 15
Ethan Nolan 20023 10/8/19 10/13/19 Global Shipping Company Coffee 12
Ethan Nolan 20068 10/8/19 10/10/19 Global Shipping Company Crab Meat 22
Ethan Nolan 20055 10/8/19 10/11/19 Global Shipping Company Boysenberry Spread 20
Nancy Freehafer 20022 10/8/19 10/11/19 Global Shipping Company Olive Oil 16
Nancy Freehafer 20084 10/8/19 10/13/19 Evergreen Shipping Company Clam Chowder 23
Nancy Freehafer 20145 10/8/19 10/13/19 Evergreen Shipping Company Chocolate 16
Andrew Cencini 20007 10/8/19 10/11/19 Global Shipping Company Dried Plums 21
Andrew Cencini 20160 10/8/19 10/12/19 Taurus Logistics Chocolate Biscuits Mix 20
Laura Giussani 20103 10/8/19 10/12/19 Global Shipping Company Olive Oil 12
Ethan Nolan 20120 10/8/19 10/12/19 Global Shipping Company Olive Oil 15
Laura Giussani 20096 10/9/19 10/11/19 Global Shipping Company Coffee 24
Laura Giussani 20055 10/9/19 10/13/19 Evergreen Shipping Company Beer 18
Laura Giussani 20022 10/9/19 10/12/19 Taurus Logistics Scones 14
Anne Larsen 20084 10/9/19

Taurus Logistics Chai 13

Anne Larsen 20145 10/9/19 10/14/19 Taurus Logistics Coffee 22
Anne Larsen 20007 10/9/19 10/12/19 Global Shipping Company Curry Sauce 20
Andrew Cencini 20160 10/9/19 10/12/19 Taurus Logistics Coffee 19
Andrew Cencini 20103 10/9/19 10/13/19 Global Shipping Company Boysenberry Spread 14
Andrew Cencini 20120 10/9/19 10/12/19 Evergreen Shipping Company Beer 21
Andrew Cencini 20096 10/9/19 10/14/19 Evergreen Shipping Company Marmalade 14
Andrew Cencini 20166 10/9/19 10/14/19 Evergreen Shipping Company Chocolate Biscuits Mix 13
Nancy Freehafer 20179 10/9/19 10/13/19 Evergreen Shipping Company Beer 12
Nancy Freehafer 20145 10/9/19 10/13/19 Global Shipping Company Curry Sauce 14
Ethan Nolan 20023 10/9/19 10/13/19 Evergreen Shipping Company Green Tea 18
Ethan Nolan 20048 10/9/19 10/11/19 Global Shipping Company Crab Meat 22
Ethan Nolan 20073 10/9/19 10/11/19 Evergreen Shipping Company Beer 13
Nancy Freehafer 20200 10/9/19 10/11/19 Global Shipping Company Curry Sauce 19
Nancy Freehafer 20023 10/9/19 10/11/19 Global Shipping Company Syrup 12
Nancy Freehafer 20068 10/9/19 10/12/19 Global Shipping Company Gnocchi 23
Andrew Cencini 20055 10/9/19 10/11/19 Global Shipping Company Curry Sauce 20
Andrew Cencini 20022 10/9/19 10/14/19 Taurus Logistics Dried Plums 24
Laura Giussani 20084 10/9/19 10/14/19 Global Shipping Company Coffee 21
Ethan Nolan 20145 10/9/19 10/13/19 Taurus Logistics Scones 22
Laura Giussani 20007 10/9/19 10/12/19 Evergreen Shipping Company Chocolate Biscuits Mix 21
Laura Giussani 20160 10/9/19 10/14/19 Evergreen Shipping Company Crab Meat 12
Laura Giussani 20103 10/9/19 10/14/19 Evergreen Shipping Company Marmalade 20
Anne Larsen 20120 10/9/19 10/11/19 Taurus Logistics Beer 17
Anne Larsen 20096 10/9/19 10/13/19 Taurus Logistics Dried Pears 17
Anne Larsen 20055 10/10/19 10/12/19 Taurus Logistics Clam Chowder 18
Andrew Cencini 20022 10/10/19 10/12/19 Evergreen Shipping Company Chocolate Biscuits Mix 15
Andrew Cencini 20084 10/10/19 10/12/19 Global Shipping Company Chocolate Biscuits Mix 23
Andrew Cencini 20145 10/10/19 10/13/19 Global Shipping Company Dried Pears 24
Andrew Cencini 20007 10/10/19 10/13/19 Taurus Logistics Mozzarella 19
Andrew Cencini 20160 10/10/19 10/14/19 Global Shipping Company Dried Apples 12
Nancy Freehafer 20103 10/10/19 10/14/19 Taurus Logistics Green Tea 20
Nancy Freehafer 20120 10/10/19 10/13/19 Global Shipping Company Dried Pears 17
Ethan Nolan 20096 10/10/19 10/13/19 Evergreen Shipping Company Beer 13
Ethan Nolan 20166 10/10/19

Global Shipping Company Crab Meat 14

Ethan Nolan 20179 10/10/19 10/13/19 Taurus Logistics Beer 16
Nancy Freehafer 20145 10/10/19 10/14/19 Global Shipping Company Chai 22
Nancy Freehafer 20023 10/10/19 10/13/19 Taurus Logistics Scones 20
Nancy Freehafer 20048 10/10/19 10/12/19 Evergreen Shipping Company Marmalade 20
Andrew Cencini 20073 10/10/19 10/12/19 Evergreen Shipping Company Green Tea 12
Andrew Cencini 20200 10/10/19 10/13/19 Evergreen Shipping Company Chocolate 13
Laura Giussani 20023 10/10/19 10/13/19 Global Shipping Company Curry Sauce 14
Ethan Nolan 20068 10/10/19 10/13/19 Evergreen Shipping Company Chocolate Biscuits Mix 13
Laura Giussani 20055 10/11/19

Global Shipping Company Curry Sauce 15

Laura Giussani 20022 10/11/19 10/14/19 Global Shipping Company Dried Pears 24
Laura Giussani 20084 10/11/19 10/16/19 Taurus Logistics Cajun Seasoning 22
Anne Larsen 20145 10/11/19 10/13/19 Taurus Logistics Cajun Seasoning 19
Anne Larsen 20007 10/11/19 10/15/19 Taurus Logistics Coffee 17
Anne Larsen 20160 10/11/19 10/14/19 Global Shipping Company Curry Sauce 14
Andrew Cencini 20103 10/11/19 10/15/19 Global Shipping Company Curry Sauce 24
Andrew Cencini 20120 10/11/19 10/15/19 Evergreen Shipping Company Clam Chowder 16
Andrew Cencini 20096 10/11/19 10/15/19 Global Shipping Company Chai 12
Andrew Cencini 20055 10/11/19 10/13/19 Taurus Logistics Fruit Cocktail 19
Andrew Cencini 20022 10/11/19 10/15/19 Evergreen Shipping Company Beer 23
Nancy Freehafer 20084 10/11/19 10/14/19 Global Shipping Company Coffee 17
Nancy Freehafer 20145 10/11/19 10/15/19 Global Shipping Company Crab Meat 14
Ethan Nolan 20007 10/11/19 10/14/19 Global Shipping Company Curry Sauce 22
Ethan Nolan 20160 10/12/19 10/16/19 Evergreen Shipping Company Crab Meat 14
Ethan Nolan 20103 10/12/19 10/14/19 Evergreen Shipping Company Chocolate 17
Nancy Freehafer 20120 10/12/19 10/14/19 Global Shipping Company Curry Sauce 20
Nancy Freehafer 20096 10/12/19

Evergreen Shipping Company Clam Chowder 17

Nancy Freehafer 20166 10/12/19 10/16/19 Evergreen Shipping Company Marmalade 22
Andrew Cencini 20179 10/12/19 10/16/19 Global Shipping Company Green Tea 18
Andrew Cencini 20145 10/12/19 10/16/19 Taurus Logistics Chocolate 24
Laura Giussani 20023 10/12/19 10/17/19 Global Shipping Company Syrup 22
Ethan Nolan 20048 10/12/19 10/14/19 Global Shipping Company Crab Meat 23
Laura Giussani 20073 10/12/19 10/17/19 Taurus Logistics Boysenberry Spread 20
Laura Giussani 20200 10/12/19 10/16/19 Taurus Logistics Mozzarella 14
Laura Giussani 20023 10/12/19 10/16/19 Evergreen Shipping Company Clam Chowder 22
Anne Larsen 20068 10/12/19 10/16/19 Taurus Logistics Coffee 21
Anne Larsen 20055 10/12/19 10/16/19 Taurus Logistics Ravioli 16
Anne Larsen 20022 10/12/19 10/16/19 Global Shipping Company Boysenberry Spread 24
Andrew Cencini 20084 10/12/19 10/14/19 Global Shipping Company Clam Chowder 13
Andrew Cencini 20145 10/13/19 10/16/19 Taurus Logistics Long Grain Rice 18
Andrew Cencini 20007 10/13/19 10/17/19 Evergreen Shipping Company Clam Chowder 13
Andrew Cencini 20160 10/13/19 10/17/19 Evergreen Shipping Company Chocolate 16
Andrew Cencini 20103 10/13/19 10/16/19 Evergreen Shipping Company Chocolate Biscuits Mix 15
Nancy Freehafer 20120 10/13/19 10/15/19 Global Shipping Company Olive Oil 15
Nancy Freehafer 20096 10/13/19 10/15/19 Global Shipping Company Green Tea 15
Ethan Nolan 20055 10/13/19 10/15/19 Taurus Logistics Ravioli 20
Ethan Nolan 20022 10/13/19 10/15/19 Taurus Logistics Coffee 23
Ethan Nolan 20084 10/13/19 10/17/19 Taurus Logistics Beer 22
Nancy Freehafer 20145 10/13/19

Evergreen Shipping Company Marmalade 13

Nancy Freehafer 20007 10/13/19 10/16/19 Taurus Logistics Beer 22
Nancy Freehafer 20160 10/13/19 10/15/19 Global Shipping Company Dried Plums 12
Andrew Cencini 20103 10/13/19 10/17/19 Evergreen Shipping Company Beer 23
Andrew Cencini 20120 10/14/19 10/16/19 Global Shipping Company Gnocchi 17
Laura Giussani 20096 10/14/19

Global Shipping Company Beer 12

Ethan Nolan 20166 10/14/19 10/17/19 Global Shipping Company Crab Meat 16
Laura Giussani 20179 10/14/19 10/17/19 Global Shipping Company Curry Sauce 13
Laura Giussani 20145 10/14/19 10/19/19 Taurus Logistics Almonds 23
Laura Giussani 20023 10/14/19 10/19/19 Global Shipping Company Coffee 19
Anne Larsen 20048 10/14/19 10/17/19 Global Shipping Company Curry Sauce 17
Anne Larsen 20073 10/14/19 10/18/19 Evergreen Shipping Company Chocolate 13
Anne Larsen 20200 10/14/19 10/16/19 Global Shipping Company Clam Chowder 20
Andrew Cencini 20023 10/14/19 10/18/19 Global Shipping Company Dried Plums 14
Andrew Cencini 20068 10/14/19 10/18/19 Taurus Logistics Fruit Cocktail 14
Andrew Cencini 20055 10/14/19 10/19/19 Global Shipping Company Olive Oil 14
Andrew Cencini 20022 10/14/19 10/16/19 Taurus Logistics Clam Chowder 17
Andrew Cencini 20084 10/14/19 10/16/19 Evergreen Shipping Company Chocolate Biscuits Mix 20
Nancy Freehafer 20145 10/14/19 10/16/19 Global Shipping Company Olive Oil 12
Nancy Freehafer 20007 10/15/19 10/18/19 Global Shipping Company Beer 23
Ethan Nolan 20160 10/15/19 10/19/19 Evergreen Shipping Company Chocolate Biscuits Mix 15
Ethan Nolan 20103 10/15/19 10/19/19 Taurus Logistics Mozzarella 19
Ethan Nolan 20120 10/16/19 10/18/19 Global Shipping Company Curry Sauce 17
Nancy Freehafer 20096 10/16/19

Taurus Logistics Green Tea 17

Nancy Freehafer 20055 10/16/19 10/19/19 Taurus Logistics Dried Plums 23
Nancy Freehafer 20022 10/16/19 10/19/19 Taurus Logistics Ravioli 12
Andrew Cencini 20084 10/16/19 10/21/19 Evergreen Shipping Company Clam Chowder 20
Andrew Cencini 20145 10/16/19 10/19/19 Evergreen Shipping Company Chocolate 23
Laura Giussani 20007 10/16/19 10/19/19 Taurus Logistics Scones 24
Ethan Nolan 20160 10/16/19

Global Shipping Company Curry Sauce 13

Laura Giussani 20103 10/16/19 10/20/19 Evergreen Shipping Company Chocolate Biscuits Mix 13
Laura Giussani 20120 10/16/19 10/19/19 Evergreen Shipping Company Coffee 14
Laura Giussani 20096 10/16/19 10/18/19 Evergreen Shipping Company Green Tea 14
Anne Larsen 20166 10/16/19 10/19/19 Global Shipping Company Clam Chowder 12
Anne Larsen 20179 10/16/19 10/21/19 Evergreen Shipping Company Marmalade 20
Anne Larsen 20145 10/16/19 10/18/19 Global Shipping Company Boysenberry Spread 23
Andrew Cencini 20023 10/17/19 10/20/19 Taurus Logistics Chocolate Biscuits Mix 21
Andrew Cencini 20048 10/17/19 10/20/19 Taurus Logistics Fruit Cocktail 12
Andrew Cencini 20073 10/17/19 10/19/19 Taurus Logistics Beer 20
Andrew Cencini 20200 10/17/19 10/19/19 Taurus Logistics Dried Plums 13
Andrew Cencini 20023 10/17/19

Taurus Logistics Chocolate Biscuits Mix 18

Nancy Freehafer 20068 10/17/19 10/22/19 Global Shipping Company Green Tea 14
Nancy Freehafer 20055 10/17/19 10/22/19 Global Shipping Company Dried Apples 24
Ethan Nolan 20022 10/17/19 10/19/19 Global Shipping Company Chai 18
Ethan Nolan 20084 10/17/19 10/20/19 Evergreen Shipping Company Clam Chowder 23
Ethan Nolan 20145 10/17/19 10/22/19 Taurus Logistics Boysenberry Spread 24
Nancy Freehafer 20007 10/17/19 10/22/19 Taurus Logistics Mozzarella 22
Nancy Freehafer 20160 10/17/19 10/22/19 Global Shipping Company Mozzarella 14
Nancy Freehafer 20103 10/17/19 10/22/19 Global Shipping Company Syrup 18
Andrew Cencini 20120 10/17/19 10/21/19 Evergreen Shipping Company Chocolate 12
Andrew Cencini 20096 10/17/19 10/19/19 Evergreen Shipping Company Beer 15
Laura Giussani 20055 10/17/19 10/21/19 Evergreen Shipping Company Chocolate 24
Ethan Nolan 20022 10/17/19 10/20/19 Taurus Logistics Chocolate 21
Laura Giussani 20084 10/17/19 10/21/19 Global Shipping Company Clam Chowder 22
Laura Giussani 20145 10/17/19 10/20/19 Global Shipping Company Coffee 13
Laura Giussani 20007 10/17/19 10/20/19 Taurus Logistics Boysenberry Spread 18
Anne Larsen 20160 10/17/19 10/19/19 Global Shipping Company Mozzarella 13
Anne Larsen 20103 10/17/19 10/21/19 Taurus Logistics Dried Pears 24
Anne Larsen 20120 10/17/19 10/21/19 Taurus Logistics Scones 24
Andrew Cencini 20096 10/17/19 10/21/19 Taurus Logistics Long Grain Rice 20
Andrew Cencini 20166 10/17/19 10/20/19 Taurus Logistics Clam Chowder 16
Andrew Cencini 20179 10/17/19 10/22/19 Taurus Logistics Chai 22
Andrew Cencini 20145 10/17/19 10/22/19 Evergreen Shipping Company Chocolate 18
Andrew Cencini 20023 10/18/19 10/20/19 Global Shipping Company Curry Sauce 23
Nancy Freehafer 20048 10/18/19 10/22/19 Taurus Logistics Mozzarella 24
Nancy Freehafer 20073 10/18/19 10/20/19 Global Shipping Company Dried Plums 16
Ethan Nolan 20200 10/18/19 10/20/19 Global Shipping Company Gnocchi 22
Ethan Nolan 20023 10/18/19 10/20/19 Global Shipping Company Curry Sauce 18
Ethan Nolan 20068 10/18/19 10/22/19 Taurus Logistics Scones 17
Nancy Freehafer 20055 10/18/19 10/21/19 Global Shipping Company Syrup 19
Nancy Freehafer 20022 10/18/19 10/20/19 Evergreen Shipping Company Chocolate 17
Nancy Freehafer 20084 10/18/19

Evergreen Shipping Company Beer 24

Andrew Cencini 20145 10/18/19 10/21/19 Taurus Logistics Chai 21
Andrew Cencini 20007 10/18/19 10/21/19 Evergreen Shipping Company Chocolate 12
Laura Giussani 20160 10/18/19 10/23/19 Taurus Logistics Long Grain Rice 18
Ethan Nolan 20103 10/18/19 10/21/19 Global Shipping Company Olive Oil 21
Laura Giussani 20120 10/18/19 10/20/19 Taurus Logistics Chocolate 23
Laura Giussani 20096 10/18/19 10/20/19 Taurus Logistics Chai 16
Laura Giussani 20055 10/19/19 10/21/19 Taurus Logistics Clam Chowder 12
Anne Larsen 20022 10/19/19 10/22/19 Evergreen Shipping Company Beer 21
Anne Larsen 20084 10/19/19 10/21/19 Global Shipping Company Clam Chowder 13
Anne Larsen 20145 10/19/19 10/23/19 Taurus Logistics Scones 21
Andrew Cencini 20007 10/19/19 10/23/19 Global Shipping Company Dried Apples 15
Andrew Cencini 20160 10/19/19 10/22/19 Taurus Logistics Beer 18
Andrew Cencini 20103 10/19/19 10/21/19 Evergreen Shipping Company Marmalade 14
Andrew Cencini 20120 10/19/19

Taurus Logistics Clam Chowder 18

Andrew Cencini 20096 10/19/19 10/21/19 Taurus Logistics Dried Plums 12
Nancy Freehafer 20166 10/19/19 10/24/19 Taurus Logistics Chai 15
Nancy Freehafer 20179 10/19/19 10/22/19 Global Shipping Company Curry Sauce 18
Ethan Nolan 20145 10/19/19 10/24/19 Taurus Logistics Chocolate 13
Ethan Nolan 20023 10/19/19 10/23/19 Taurus Logistics Beer 17
Ethan Nolan 20048 10/19/19 10/21/19 Taurus Logistics Almonds 23
Nancy Freehafer 20073 10/19/19 10/24/19 Global Shipping Company Clam Chowder 13
Nancy Freehafer 20200 10/19/19 10/24/19 Evergreen Shipping Company Green Tea 20
Nancy Freehafer 20023 10/19/19 10/23/19 Global Shipping Company Clam Chowder 23
Andrew Cencini 20068 10/20/19 10/22/19 Global Shipping Company Coffee 21
Andrew Cencini 20055 10/20/19 10/24/19 Taurus Logistics Scones 16
Laura Giussani 20022 10/20/19 10/22/19 Evergreen Shipping Company Beer 14
Ethan Nolan 20084 10/20/19 10/22/19 Taurus Logistics Dried Pears 22
Laura Giussani 20145 10/20/19 10/24/19 Taurus Logistics Coffee 16
Laura Giussani 20007 10/20/19 10/23/19 Global Shipping Company Dried Apples 20
Laura Giussani 20160 10/20/19 10/22/19 Evergreen Shipping Company Green Tea 23
Anne Larsen 20103 10/20/19 10/23/19 Taurus Logistics Chocolate 24
Anne Larsen 20120 10/20/19

Global Shipping Company Cajun Seasoning 15

Anne Larsen 20096 10/20/19 10/25/19 Global Shipping Company Curry Sauce 17
Andrew Cencini 20055 10/20/19 10/24/19 Global Shipping Company Clam Chowder 24
Andrew Cencini 20022 10/20/19 10/22/19 Global Shipping Company Curry Sauce 17
Andrew Cencini 20084 10/20/19 10/22/19 Global Shipping Company Clam Chowder 12
Andrew Cencini 20145 10/20/19 10/24/19 Taurus Logistics Clam Chowder 24
Andrew Cencini 20007 10/20/19 10/23/19 Global Shipping Company Curry Sauce 19
Nancy Freehafer 20160 10/20/19 10/23/19 Taurus Logistics Long Grain Rice 24
Nancy Freehafer 20103 10/20/19 10/25/19 Taurus Logistics Green Tea 22
Ethan Nolan 20120 10/20/19 10/25/19 Taurus Logistics Clam Chowder 15
Ethan Nolan 20096 10/20/19 10/24/19 Evergreen Shipping Company Clam Chowder 17
Ethan Nolan 20166 10/20/19 10/23/19 Global Shipping Company Cajun Seasoning 13
Nancy Freehafer 20179 10/20/19 10/24/19 Taurus Logistics Long Grain Rice 24
Nancy Freehafer 20145 10/20/19 10/22/19 Evergreen Shipping Company Clam Chowder 20
Nancy Freehafer 20023 10/21/19 10/25/19 Evergreen Shipping Company Chocolate Biscuits Mix 16
Andrew Cencini 20048 10/21/19 10/23/19 Global Shipping Company Clam Chowder 20
Andrew Cencini 20073 10/21/19 10/25/19 Taurus Logistics Boysenberry Spread 13
Laura Giussani 20200 10/21/19

Evergreen Shipping Company Chocolate Biscuits Mix 20

Ethan Nolan 20023 10/21/19 10/26/19 Global Shipping Company Green Tea 19
Laura Giussani 20068 10/21/19 10/24/19 Global Shipping Company Dried Apples 17
Laura Giussani 20055 10/21/19 10/24/19 Taurus Logistics Cajun Seasoning 12
Laura Giussani 20022 10/21/19 10/23/19 Global Shipping Company Curry Sauce 16
Anne Larsen 20084 10/21/19 10/25/19 Global Shipping Company Cajun Seasoning 13
Anne Larsen 20145 10/21/19 10/26/19 Taurus Logistics Dried Plums 24
Anne Larsen 20007 10/21/19 10/26/19 Taurus Logistics Scones 21
Andrew Cencini 20160 10/21/19 10/26/19 Evergreen Shipping Company Chocolate 12
Andrew Cencini 20103 10/21/19 10/24/19 Taurus Logistics Chocolate Biscuits Mix 15
Andrew Cencini 20120 10/21/19 10/24/19 Evergreen Shipping Company Crab Meat 12
Andrew Cencini 20096 10/21/19 10/25/19 Evergreen Shipping Company Chocolate 24
Andrew Cencini 20055 10/21/19 10/26/19 Taurus Logistics Chocolate 21
Nancy Freehafer 20022 10/22/19 10/24/19 Global Shipping Company Chai 16
Nancy Freehafer 20084 10/22/19 10/24/19 Global Shipping Company Mozzarella 14
Ethan Nolan 20145 10/22/19 10/25/19 Global Shipping Company Curry Sauce 16
Ethan Nolan 20007 10/22/19 10/25/19 Global Shipping Company Dried Plums 23
Ethan Nolan 20160 10/22/19 10/26/19 Evergreen Shipping Company Chocolate Biscuits Mix 21
Nancy Freehafer 20103 10/22/19 10/26/19 Global Shipping Company Curry Sauce 20
Nancy Freehafer 20120 10/22/19

Global Shipping Company Chocolate Biscuits Mix 17

Nancy Freehafer 20096 10/22/19 10/24/19 Global Shipping Company Syrup 17
Andrew Cencini 20166 10/22/19 10/26/19 Evergreen Shipping Company Coffee 15
Andrew Cencini 20179 10/23/19

Global Shipping Company Curry Sauce 22

Laura Giussani 20145 10/23/19 10/27/19 Taurus Logistics Boysenberry Spread 18
Ethan Nolan 20023 10/23/19 10/25/19 Taurus Logistics Chocolate 12
Laura Giussani 20048 10/23/19 10/28/19 Taurus Logistics Long Grain Rice 13
Laura Giussani 20073 10/23/19 10/28/19 Taurus Logistics Chocolate Biscuits Mix 13
Laura Giussani 20200 10/23/19 10/26/19 Evergreen Shipping Company Dried Plums 23
Anne Larsen 20023 10/23/19 10/27/19 Evergreen Shipping Company Clam Chowder 19
Anne Larsen 20068 10/23/19 10/27/19 Global Shipping Company Clam Chowder 23
Anne Larsen 20055 10/23/19 10/26/19 Global Shipping Company Coffee 12
Andrew Cencini 20022 10/23/19 10/26/19 Evergreen Shipping Company Clam Chowder 22
Andrew Cencini 20084 10/23/19 10/28/19 Taurus Logistics Almonds 19
Andrew Cencini 20145 10/23/19 10/26/19 Global Shipping Company Olive Oil 12
Andrew Cencini 20007 10/23/19 10/27/19 Global Shipping Company Curry Sauce 18
Andrew Cencini 20160 10/23/19 10/27/19 Global Shipping Company Syrup 15
Nancy Freehafer 20103 10/23/19 10/28/19 Global Shipping Company Clam Chowder 22
Nancy Freehafer 20120 10/23/19 10/27/19 Global Shipping Company Olive Oil 13
Ethan Nolan 20096 10/23/19 10/27/19 Taurus Logistics Long Grain Rice 20
Ethan Nolan 20055 10/23/19 10/25/19 Global Shipping Company Olive Oil 24
Ethan Nolan 20022 10/23/19 10/26/19 Global Shipping Company Green Tea 24
Nancy Freehafer 20084 10/23/19 10/28/19 Evergreen Shipping Company Green Tea 24
Laura Giussani 20145 10/23/19 10/25/19 Taurus Logistics Coffee 22
Ethan Nolan 20007 10/24/19 10/26/19 Global Shipping Company Syrup 13
Laura Giussani 20160 10/24/19 10/27/19 Global Shipping Company Chocolate Biscuits Mix 24
Laura Giussani 20103 10/24/19 10/27/19 Taurus Logistics Coffee 22
Laura Giussani 20120 10/24/19

Taurus Logistics Chai 22

Anne Larsen 20096 10/24/19 10/27/19 Global Shipping Company Cajun Seasoning 22
Anne Larsen 20166 10/24/19 10/27/19 Evergreen Shipping Company Chocolate 20
Anne Larsen 20179 10/24/19 10/29/19 Taurus Logistics Dried Pears 13
Andrew Cencini 20145 10/24/19 10/28/19 Evergreen Shipping Company Chocolate Biscuits Mix 16
Andrew Cencini 20023 10/24/19 10/28/19 Taurus Logistics Chocolate Biscuits Mix 13
Andrew Cencini 20048 10/24/19 10/29/19 Global Shipping Company Coffee 18
Andrew Cencini 20073 10/24/19 10/27/19 Evergreen Shipping Company Green Tea 15
Andrew Cencini 20200 10/24/19 10/28/19 Evergreen Shipping Company Coffee 14
Nancy Freehafer 20023 10/24/19 10/28/19 Global Shipping Company Curry Sauce 21
Nancy Freehafer 20068 10/24/19 10/28/19 Taurus Logistics Mozzarella 12
Ethan Nolan 20055 10/24/19 10/29/19 Taurus Logistics Chocolate Biscuits Mix 22
Ethan Nolan 20022 10/24/19 10/28/19 Evergreen Shipping Company Green Tea 15
Ethan Nolan 20084 10/24/19 10/27/19 Taurus Logistics Boysenberry Spread 18
Nancy Freehafer 20145 10/24/19 10/26/19 Evergreen Shipping Company Chocolate Biscuits Mix 15
Laura Giussani 20007 10/24/19 10/26/19 Evergreen Shipping Company Chocolate Biscuits Mix 13
Ethan Nolan 20160 10/24/19 10/29/19 Evergreen Shipping Company Crab Meat 19
Laura Giussani 20103 10/24/19 10/27/19 Taurus Logistics Mozzarella 16
Laura Giussani 20120 10/24/19 10/29/19 Global Shipping Company Olive Oil 20
Laura Giussani 20096 10/24/19 10/29/19 Global Shipping Company Mozzarella 18
Anne Larsen 20055 10/24/19 10/28/19 Taurus Logistics Coffee 19
Anne Larsen 20022 10/25/19 10/29/19 Evergreen Shipping Company Chocolate Biscuits Mix 24
Anne Larsen 20084 10/25/19 10/28/19 Evergreen Shipping Company Coffee 23
Andrew Cencini 20145 10/25/19

Evergreen Shipping Company Dried Plums 21

Andrew Cencini 20007 10/25/19 10/29/19 Global Shipping Company Dried Plums 15
Andrew Cencini 20160 10/25/19 10/29/19 Evergreen Shipping Company Crab Meat 16
Andrew Cencini 20103 10/25/19 10/28/19 Evergreen Shipping Company Chocolate Biscuits Mix 17
Andrew Cencini 20120 10/26/19 10/30/19 Global Shipping Company Curry Sauce 15
Nancy Freehafer 20096 10/26/19

Evergreen Shipping Company Green Tea 13

Nancy Freehafer 20166 10/26/19 10/29/19 Taurus Logistics Chai 20
Ethan Nolan 20179 10/26/19 10/29/19 Global Shipping Company Crab Meat 16
Ethan Nolan 20145 10/26/19 10/28/19 Global Shipping Company Crab Meat 18
Ethan Nolan 20023 10/26/19 10/30/19 Taurus Logistics Scones 13
Nancy Freehafer 20048 10/26/19 10/30/19 Taurus Logistics Dried Plums 12
Laura Giussani 20073 10/26/19 10/29/19 Evergreen Shipping Company Chocolate Biscuits Mix 21
Ethan Nolan 20200 10/26/19 10/28/19 Evergreen Shipping Company Chocolate Biscuits Mix 19
Laura Giussani 20023 10/26/19 10/31/19 Taurus Logistics Dried Pears 17
Laura Giussani 20068 10/26/19 10/30/19 Global Shipping Company Syrup 20
Laura Giussani 20055 10/26/19 10/28/19 Evergreen Shipping Company Chocolate Biscuits Mix 17
Anne Larsen 20022 10/26/19 10/30/19 Global Shipping Company Coffee 19
Anne Larsen 20084 10/26/19 10/28/19 Global Shipping Company Gnocchi 13
Anne Larsen 20145 10/26/19 10/30/19 Evergreen Shipping Company Chocolate 20
Andrew Cencini 20007 10/26/19 10/28/19 Evergreen Shipping Company Crab Meat 13
Andrew Cencini 20160 10/26/19 10/28/19 Taurus Logistics Dried Plums 13
Andrew Cencini 20103 10/26/19 10/30/19 Taurus Logistics Almonds 20
Andrew Cencini 20120 10/26/19 10/29/19 Global Shipping Company Green Tea 13
Andrew Cencini 20096 10/26/19 10/30/19 Taurus Logistics Boysenberry Spread 21
Nancy Freehafer 20055 10/27/19 10/31/19 Evergreen Shipping Company Green Tea 20
Nancy Freehafer 20022 10/27/19

Taurus Logistics Chocolate 12

Ethan Nolan 20084 10/27/19 10/29/19 Global Shipping Company Dried Plums 15
Ethan Nolan 20145 10/27/19 11/1/19 Taurus Logistics Mozzarella 15
Ethan Nolan 20007 10/27/19 11/1/19 Evergreen Shipping Company Chocolate Biscuits Mix 12
Nancy Freehafer 20160 10/27/19 10/29/19 Taurus Logistics Ravioli 21
Laura Giussani 20103 10/27/19 11/1/19 Evergreen Shipping Company Clam Chowder 14
Ethan Nolan 20120 10/27/19 10/30/19 Global Shipping Company Curry Sauce 13
Laura Giussani 20096 10/27/19 10/29/19 Global Shipping Company Chai 19
Laura Giussani 20166 10/28/19 10/30/19 Global Shipping Company Green Tea 19
Laura Giussani 20179 10/28/19 10/31/19 Evergreen Shipping Company Chocolate Biscuits Mix 15
Anne Larsen 20145 10/28/19

Global Shipping Company Syrup 24

Anne Larsen 20023 10/28/19 11/2/19 Taurus Logistics Fruit Cocktail 12
Anne Larsen 20048 10/28/19 11/2/19 Taurus Logistics Chocolate 13
Andrew Cencini 20073 10/28/19 10/31/19 Global Shipping Company Curry Sauce 21
Andrew Cencini 20200 10/28/19 11/1/19 Taurus Logistics Dried Plums 15
Andrew Cencini 20023 10/28/19 10/30/19 Taurus Logistics Chocolate Biscuits Mix 12
Andrew Cencini 20068 10/28/19 11/1/19 Taurus Logistics Long Grain Rice 15
Andrew Cencini 20055 10/28/19 11/1/19 Global Shipping Company Clam Chowder 21
Nancy Freehafer 20022 10/28/19 10/30/19 Evergreen Shipping Company Chocolate Biscuits Mix 18
Nancy Freehafer 20084 10/28/19 10/31/19 Taurus Logistics Ravioli 24
Ethan Nolan 20145 10/28/19 10/30/19 Evergreen Shipping Company Clam Chowder 22
Ethan Nolan 20007 10/28/19 11/2/19 Global Shipping Company Curry Sauce 19
Ethan Nolan 20160 10/28/19 11/1/19 Global Shipping Company Boysenberry Spread 16
Nancy Freehafer 20103 10/28/19 11/1/19 Global Shipping Company Coffee 23
Laura Giussani 20120 10/28/19 10/30/19 Evergreen Shipping Company Beer 18
Ethan Nolan 20096 10/28/19 11/1/19 Evergreen Shipping Company Beer 16
Laura Giussani 20055 10/28/19 11/1/19 Global Shipping Company Curry Sauce 21
Laura Giussani 20022 10/28/19 11/2/19 Evergreen Shipping Company Chocolate 17
Laura Giussani 20084 10/28/19 10/30/19 Taurus Logistics Chocolate 16
Anne Larsen 20145 10/28/19 11/2/19 Taurus Logistics Green Tea 22
Anne Larsen 20007 10/28/19 11/2/19 Taurus Logistics Dried Plums 18
Anne Larsen 20160 10/29/19

Taurus Logistics Ravioli 15

Andrew Cencini 20103 10/29/19 11/3/19 Global Shipping Company Coffee 20
Andrew Cencini 20120 10/29/19 11/3/19 Taurus Logistics Fruit Cocktail 19
Andrew Cencini 20096 10/29/19 11/1/19 Global Shipping Company Gnocchi 18
Andrew Cencini 20166 10/29/19 11/3/19 Taurus Logistics Chocolate 14
Andrew Cencini 20179 10/29/19 11/1/19 Global Shipping Company Olive Oil 19
Nancy Freehafer 20145 10/29/19 10/31/19 Evergreen Shipping Company Crab Meat 13
Nancy Freehafer 20023 10/29/19 10/31/19 Taurus Logistics Boysenberry Spread 12
Ethan Nolan 20048 10/29/19 11/1/19 Taurus Logistics Coffee 23
Ethan Nolan 20073 10/29/19 11/1/19 Global Shipping Company Green Tea 16
Ethan Nolan 20200 10/29/19 10/31/19 Taurus Logistics Long Grain Rice 14
Nancy Freehafer 20023 10/29/19 11/3/19 Global Shipping Company Curry Sauce 17
Andrew Cencini 20068 10/29/19 11/1/19 Evergreen Shipping Company Chocolate 13
Andrew Cencini 20055 10/29/19 11/2/19 Global Shipping Company Curry Sauce 15
Andrew Cencini 20022 10/29/19 11/3/19 Global Shipping Company Gnocchi 15
Nancy Freehafer 20084 10/29/19 11/2/19 Global Shipping Company Dried Plums 16
Nancy Freehafer 20145 10/29/19 10/31/19 Evergreen Shipping Company Green Tea 22
Ethan Nolan 20007 10/30/19 11/1/19 Global Shipping Company Curry Sauce 13
Ethan Nolan 20160 10/30/19 11/3/19 Evergreen Shipping Company Chocolate 14
Ethan Nolan 20103 10/30/19 11/3/19 Global Shipping Company Crab Meat 23
Nancy Freehafer 20120 10/30/19

Evergreen Shipping Company Chocolate 14

Laura Giussani 20096 10/30/19 11/2/19 Taurus Logistics Boysenberry Spread 22
Ethan Nolan 20055 10/30/19 11/3/19 Taurus Logistics Clam Chowder 12
Laura Giussani 20022 10/30/19 11/2/19 Global Shipping Company Chocolate Biscuits Mix 12
Laura Giussani 20084 10/30/19 11/2/19 Global Shipping Company Olive Oil 12
Laura Giussani 20145 10/30/19 11/3/19 Evergreen Shipping Company Green Tea 12
Anne Larsen 20007 10/30/19 11/4/19 Evergreen Shipping Company Chocolate 20
Anne Larsen 20160 10/30/19 11/3/19 Taurus Logistics Chocolate 12
Anne Larsen 20103 10/30/19 11/1/19 Global Shipping Company Gnocchi 18
Andrew Cencini 20120 10/30/19 11/1/19 Taurus Logistics Boysenberry Spread 17
Andrew Cencini 20096 10/30/19 11/4/19 Evergreen Shipping Company Chocolate Biscuits Mix 13
Andrew Cencini 20166 10/30/19 11/2/19 Evergreen Shipping Company Chocolate 24
Andrew Cencini 20179 10/30/19 11/2/19 Global Shipping Company Chocolate Biscuits Mix 12
Andrew Cencini 20145 10/30/19 11/2/19 Global Shipping Company Chocolate Biscuits Mix 20
Nancy Freehafer 20023 10/30/19 11/4/19 Evergreen Shipping Company Chocolate Biscuits Mix 12
Nancy Freehafer 20048 10/30/19 11/3/19 Global Shipping Company Cajun Seasoning 23
Ethan Nolan 20073 10/31/19 11/2/19 Global Shipping Company Syrup 14
Ethan Nolan 20200 10/31/19 11/4/19 Evergreen Shipping Company Beer 22
Ethan Nolan 20023 10/31/19

Taurus Logistics Chocolate 17

Nancy Freehafer 20068 10/31/19 11/5/19 Global Shipping Company Cajun Seasoning 19
Andrew Cencini 20055 10/31/19 11/3/19 Global Shipping Company Chocolate Biscuits Mix 19
Andrew Cencini 20022 10/31/19 11/5/19 Taurus Logistics Almonds 24
Andrew Cencini 20084 10/31/19 11/4/19 Evergreen Shipping Company Dried Plums 20
Nancy Freehafer 20145 10/31/19 11/2/19 Evergreen Shipping Company Chocolate Biscuits Mix 14
Nancy Freehafer 20007 10/31/19 11/3/19 Taurus Logistics Dried Plums 17
Ethan Nolan 20160 10/31/19 11/2/19 Global Shipping Company Boysenberry Spread 14
Ethan Nolan 20103 10/31/19 11/5/19 Global Shipping Company Crab Meat 21
Ethan Nolan 20120 10/31/19 11/5/19 Global Shipping Company Green Tea 13
Nancy Freehafer 20096 10/31/19 11/2/19 Global Shipping Company Curry Sauce 20
Laura Giussani 20055 10/31/19 11/5/19 Global Shipping Company Cajun Seasoning 12
Total Total

Yume International is the New Zealand largest food & beverage wholesaler to cafes and convenience stores in Australia.

You are provided with the information related to its customer details, product details, and costs and revenue information sheet.

Yume International has partnered with three shipping companies who ships the products to its Australian customers on time.

You are a junior accountant and your Senior Accounts Manager wants you to summarise this data in a meaningful way.

Required:

PART- A: Complete missing information in costs and revenue information sheet (highlighted in yellow colour) (5 marks)

PART B: Pivot Table and Recommended Charts (5 marks)

i. Calculate gross profit for each customer along with product name and payment type using Pivot Table; categorising the columns by salesperson

ii. Calculate sales revenue by each salesperson using Pivot Table and illustrate it via Clustered Bar Chart

iii. Calculate sales revenue and gross profit earned by each product using Pivot Table and illustrate it via 10 Save Time On Research and Writing Hire a Pro to Write You a 100% Plagiarism-Free Paper. Get My Paper

0%

For Pivot Tables and charts, please use a new worksheet and label it as (Pivot and Charts). You must use relevant Excel functions for the tasks assigned. Do not calculate it manually.

PART C. Discuss, justify and illustrate the following features that can be included, to help with strategic decision making. (10 marks)

SUMIF

COUNTIF

Forecasting

Index Match Function

IF with And/OR

Use suitable data for the purpose of illustration, on separate sheets. Feel free to use data from this question / other sources.

Professional presentation is expected all through

Customer and

Product Details

YUME INTERNATIONAL PVT LTD

Customer Details

Costs & Revenue Information Sheet

Customer ID

Customer Name

Contact Name

Customer Address

Customer Contact

Product Name

Category

Cost / crate

Mark- up

Promotional Discount

Salesperson

Contact Name

Contact Number

Order Date

Shipped Date

Shipper Name

Quantity

Unit Cost

Total

Mark-up %

Total Sales Revenue

Promotional Discounts

Gross Pofit

Payment Type

20

Pies and Rolls Cafe

Cooper Jesse

25 Gloria Circuit, Ballarat VIC 3090

+61 4

24

Chocolate

Baked Goods & Mixes

$ 53.0

20%

2%

Nancy Freehafer

20

16

10/1/

19

10/5/19

Global Shipping Company

Coffee

200

22

Coffee Shop

Xavier Matteo

15

+61 488 828 287

Beverages

$ 65.0

1

5%

Andrew Cencini

20

17

10/1/19

10/4/19

Taurus Logistics

Almonds

23

20084

Chai

Parker Dean

25 Joseph Street, Wollongong NSW 2000

+61 457 753 694

Dried Plums

Dried Fruit & Nuts

20

14

10/6/19

Olive

Oil

20145

The Black Kettle

Roman Zayden

8 Pamela Cresent, Hervey Bay QLD 4019

+61 478 236 315

Long Grain Rice

Grains

$ 66.0

4%

3%

Laura Giussani

20023

Dried Apples

20007

Harrison Pvt Ltd

Jason Preston

12

+61 446 733 724

Curry Sauce

Sauces

$ 67.0

Ethan Nolan

20160

Yumm Cafe

Santiago August

35 Kelly Street, Geelong VIC 3000

+61 420 730 309

Syrup

Condiments

$ 68.0

10%

Clam Chowder

13

20103

Seedling Cafe

Chase Oscar

35 Samantha Street, Canberra ACT 2609

+61 440 833 544

Fruit Cocktail

Fruit & Veg

20120

Campbell

Candy

Sawyer Jeremy

17 Jesse Drive, Albury NSW 2000

+61 413 338 154

Gnocchi

Pasta

$ 51.0

6%

10/3/19

Evergreen Shipping Company

Beer

21

20096

Mitlada Beer Co

Gavin Alejandro

30 Gabriel Street, Adelaide SA 5090

+61 463 165 450

Anne Larsen

20166

Leonardo Marcus

+61 468 338 296

Crab Meat

Canned Meat

$ 58.0

7%

20179

Pioneer Bakers

Kayden Dawson

17 Diane Lane, Sydney NSW 2000

+61 482 312 571

Scones

The Good Cafe

Zion Lorenzo

25 Jeffrey Lane, Adelaide SA 5090

+61 460 771 110

Soups

$ 23.0

Sorento Cafe

Maximus Messiah

33 Christian Street, Canberra ACT 2609

+61 476 609 674

11%

20048

Grain Store

Ezekiel Rhett

12 Sean Circuit, Hervey Bay QLD 40

18

+61 449 174 290

Boysenberry Spread

20073

Third Wave Cafe

Carson Avery

33 Sandra Circuit, Sydney NSW 2000

+61 417 644 717

Olive Oil

$ 55.0

13%

20200

Evan Steven

7 Larry Lane, Wollongong NSW 2000

+61 460 123 704

Marmalade

Jams, Preserves

14%

Chocolate Biscuits Mix

Good Meat

Maverick Graham

6 Beverly Lane, Hobart TAS 4018

+61 477 132 358

Green Tea

16%

20068

Mitalda Beer Co

Bryson Kaleb

+61 474 789 711

$ 59.0

17%

Dried Pears

Mozzarella

Dairy Products

18%

20055

$ 54.0

15%

20022

Cajun Seasoning

$ 56.0

10/2/19

Ravioli

$ 45.0

9%

Payment Details

10/7/19

Credit Card

Cheque

10/8/19

10/9/19

10/10/19

10/11/19

10/12/19

10/13/19

10/14/19

10/15/19

10/16/19

10/17/19

10/18/19

10/19/19

10/21/19

10/20/19

10/22/19

10/23/19

10/24/19

10/25/19

10/26/19

10/27/19

10/28/19

10/29/19

10/30/19

10/31/19

11/1/19

11/2/19

11/3/19

11/4/19

11/5/19

1

Excel Workshop

Subject Code: ACC 202

Subject Name: Accounting Information Systems

Workshop Dates: Week 3, Week 6, Week 8 and

Week 9

Workshop Location: Computer Lab

Objective: Microsoft Excel is the most used spreadsheet program in many business

activities; therefore, these workshops are aimed to provide you with the

fundamental and some advanced excel features.

Workshop Outline: The workshop questions are divided into Exercises and Practice

Questions. The lecturers are required to explain the concept with the help

of given exercises. The students are required to practice similar kind of

questions through practice questions.

2

Week 9

Overview

Exercises Practice Questions

❖ Exercise 25

Generate Data (Random numbers)

❖ Exercise 26

Pivot Table

❖ Exercise 27

Pie Chart

❖ Exercise 28

Other Recommended Charts

❖ Exercise 29

Relative and Absolute Reference

❖ Exercise 30

Split Cells

❖ Exercise 31

Collaboration

❖ Practice Question 19

Pivot Table

❖ Practice Question 20

Pivot Table

❖ Practice Question 21

Pivot Table

❖ Practice Question 22

Pivot Table

❖ Practice Question 23

Recommended Chart

3

Exercise 25 – Generate Data (Random numbers)

The RAND function generates a random decimal number between 0 and 1. Select cell A1. Type RAND()

and press Enter. The RAND function takes no arguments

.

Once you have completed the exercise, your answer should look like this:

4

Exercise 26 – Pivot Table

A pivot table is a table of statistics that summarizes the data of a more extensive table. This summary

might include sums, averages, or other statistics, which the pivot table groups together in a meaningful

way. Pivot tables are a technique in data processing.

Once you have completed the exercise, your answer should look like this:

5

Practice Question 19 – Pivot Table

From the data given in the table, create a pivot table and group the data.

Once you have completed the practice question, your answer should look like this:

6

Practice Question 20 – Pivot Table

From the data given in the table, create a pivot table and group the data for customer AA.

Once you have completed the practice question, your answer should look like this:

7

Practice Question 21 – Pivot Table

From the data given in the table, create a pivot table and group the data for customer TTT.

Once you have completed the practice question, your answer should look like this:

8

Practice Question 22 – Pivot Table

From the data given in the table, create a date pivot.

Once you have completed the practice question, your answer should look like this:

9

Exercise 27 – Pie Chart

From the data given in the table below, let’s learn to create a pie chart

Once you have completed the exercise, your answer should look like this:

10

Exercise 28 – Recommended Charts

From the data given in the table below, practice from the recommended chart options and create:

Clustered Column; Clustered Bar and Stacked Bar

Once you have completed the exercise, your answer should look like this:

11

Practice Question 23 – Recommended Chart

From the data given in the table below, practice from the recommended chart options and create a

Clustered Column Chart.

Once you have completed the practice question, your answer should look like this:

12

Exercise 29 – Relative and Absolute Reference

A relative reference is a reference that will change when you copy it. An absolute reference is a

reference that will not be changed during the process of copying data. Calculate the figures for the cells

highlighted in yellow colour using absolute referencing.

Once you have completed the exercise, your answer should look like this:

https://www.excel-exercise.com/copy-paste/

13

Exercise 30 – Split Cells

You can split the content of a cell into multiple adjacent cell, lets learn it via following example.

.

Once you have completed the exercise, your answer should look like this:

14

Exercise 31 – Collaboration

You and your colleagues can open, work and collaborate on the same Excel workbook. This is called co-

authoring. When you co-author, you can see each other’s changes quickly — in a matter of seconds. And

with certain versions of Excel, you’ll see other people’s selections in different colours. If you’re using a

version of Excel that supports co-authoring, you select Share in the upper-right corner, type email

addresses, and then choose a cloud location.

End of the workshop

1

Excel Workshop

Subject Code: ACC 202

Subject Name: Accounting Information Systems

Workshop Dates: Week 3, Week 6, Week 8 and Week 9

Workshop Location: Computer Lab

Objective: Microsoft Excel is the most used spreadsheet program in many business

activities; therefore, these workshops are aimed to provide you with the

fundamental and some advanced excel features.

Workshop Outline: The workshop questions are divided into Exercises and Practice

Questions. The lecturers are required to explain the concept with the help

of given exercises. The students are required to practice similar kind of

questions through practice questions.

2

Contents
Excel Fundamentals …………………………………………………………………………………………………. 5

Week 3 …………………………………………………………………………………………………………………………… 5

❖ Exercise 1 – Getting started with Excel ………………………………………………………………………….6

❖ Exercise 2 – Alignment and Formatting …………………………………………………………………………7

❖ Exercise 3 – SUM and Decimals …………………………………………………………………………………..8

❖ Exercise 4 – Percentage and AVERAGE Function ……………………………………………………………..9

❖ Practice Question 1 – SUM, Decimals and Percentage……………………………………………………. 10

❖ Practice Question 2 – AVERAGE Function ……………………………………………………………………. 11

❖ Practice Question 3 – SUM and Sales Percentage …………………………………………………………. 12

❖ Exercise 5 – Conditional Formatting Top 10 Values ……………………………………………………….. 13

❖ Practice Question 4 – Conditional Formatting and SUM Function …………………………………….. 14

❖ Exercise 6 – COUNT and COUNTA Functions ………………………………………………………………… 15

❖ Exercise 7 – COUNTIFS and SUMIFS Functions ……………………………………………………………… 16

❖ Practice Question 5 – COUNT and COUNTA Functions ……………………………………………………. 17

❖ Practice Question 6 – COUNTIFS, SUM and SUMIFS Functions………………………………………….. 18

❖ Practice Question 7 – COUNTIFS Function …………………………………………………………………… 19

❖ Practice Question 8 – COUNTIFS Function …………………………………………………………………… 20

❖ Practice Question 9 – SUM and SUMIF Functions………………………………………………………….. 21

Week 6 ……………………………………………………………………………………..Error! Bookmark not defined.

❖ Exercise 8 – IF Function ……………………………………………………… Error! Bookmark not defined.

❖ Exercise 9 – IF Function (True, False)…………………………………….. Error! Bookmark not defined.

3

❖ Practice Question 10 – IF Function (True, False)………………………. Error! Bookmark not defined.

❖ Exercise 10 – IFERROR Function …………………………………………… Error! Bookmark not defined.

❖ Practice Question 11 – IFERROR Function………………………………. Error! Bookmark not defined.

❖ Exercise 11 – AVERAGEIF Function ……………………………………….. Error! Bookmark not defined.

❖ Practice Question 12 – AVERAGEIF Function…………………………… Error! Bookmark not defined.

❖ Practice Question 13 – AVERAGEIF Function…………………………… Error! Bookmark not defined.

❖ Exercise 12 – Remove Duplicate ………………………………………….. Error! Bookmark not defined.

❖ Exercise 13 – MAX and MIN Function……………………………………. Error! Bookmark not defined.

❖ Exercise 14 – Data Validation – Range …………………………………… Error! Bookmark not defined.

❖ Exercise 15 – Data Validation – Drop Down Menu …………………… Error! Bookmark not defined.

❖ Practice Question 14 – Data Validation …………………………………. Error! Bookmark not defined.

Excel Advance ……………………………………………………………………..Error! Bookmark not defined.

Week 8 ……………………………………………………………………………………..Error! Bookmark not defined.

❖ Exercise 16 – LOOKUP Function …………………………………………… Error! Bookmark not defined.

❖ Practice Question 15 – LOOKUP Function ………………………………. Error! Bookmark not defined.

❖ Exercise 17 – VLOOKUP Function (Exact Match)………………………. Error! Bookmark not defined.

❖ Practice Question 16 – VLOOKUP Function (Exact Match) …………. Error! Bookmark not defined.

❖ Exercise 18 – VLOOKUP Function (Approximate Match) ……………. Error! Bookmark not defined.

❖ Exercise 19 – CLEAN Function ……………………………………………… Error! Bookmark not defined.

❖ Exercise 20 – TRIM Function ……………………………………………….. Error! Bookmark not defined.

❖ Practice Question 17 – TRIM Function…………………………………… Error! Bookmark not defined.

❖ Exercise 21 – RANK Function ………………………………………………. Error! Bookmark not defined.

❖ Practice Question 18 – RANK Function ………………………………….. Error! Bookmark not defined.

4

❖ Exercise 22 – PROPER Function……………………………………………. Error! Bookmark not defined.

❖ Exercise 23 – Freeze Panes …………………………………………………. Error! Bookmark not defined.

❖ Exercise 24 – CONCAT Function …………………………………………… Error! Bookmark not defined.

Week 9 ……………………………………………………………………………………..Error! Bookmark not defined.

❖ Exercise 25 – Generate Data (Random numbers) …………………….. Error! Bookmark not defined.

❖ Exercise 26 – Pivot Table ……………………………………………………. Error! Bookmark not defined.

❖ Practice Question 19 – Pivot Table……………………………………….. Error! Bookmark not defined.

❖ Practice Question 20 – Pivot Table……………………………………….. Error! Bookmark not defined.

❖ Practice Question 21 – Pivot Table……………………………………….. Error! Bookmark not defined.

❖ Practice Question 22 – Pivot Table……………………………………….. Error! Bookmark not defined.

❖ Exercise 27 – Pie Chart ………………………………………………………. Error! Bookmark not defined.

❖ Exercise 28 – Recommended Charts …………………………………….. Error! Bookmark not defined.

❖ Practice Question 23 – Recommended Chart………………………….. Error! Bookmark not defined.

❖ Exercise 29 – Relative and Absolute Reference ……………………….. Error! Bookmark not defined.

❖ Exercise 30 – Split Cells ……………………………………………………… Error! Bookmark not defined.

❖ Exercise 31 – Collaboration ………………………………………………… Error! Bookmark not defined.

5

Excel Fundamentals

W eek 3

Overview

Exercises Practice Questions

❖ Exercise 1

Worksheet Basics

❖ Exercise 2

Alignment and Formatting

❖ Exercise 3

SUM and Decimals

❖ Exercise 4

Percentage and

AVERAGE Function

❖ Exercise 5

Conditional Formatting Top 10 Values

❖ Exercise 6

COUNT and COUNTA Functions

❖ Exercise 7

COUNTIFS and SUMIFS Functions

❖ Practice Question 1

SUM, Decimals and Percentage

❖ Practice Question 2

AVERAGE Function

❖ Practice Question 3

SUM and Sales Percentage

❖ Practice Question 4

Conditional Formatting and SUM Function

❖ Practice Question 5

COUNT and COUNTA Functions

❖ Practice Question 6

COUNTIFS, SUM and SUMIFS Functions

❖ Practice Question 7

COUNTIFS Function

❖ Practice Question 8

COUNTIFS Function

❖ Practice Question 9

SUM and SUMIF Functions

6

Exercise 1 – Getting started with Excel

The objective of this exercise if to learn what are spreadsheet, worksheet, cell, rows, columns and formula

bar.

A spreadsheet is a special way of organizing data into rows and columns to make it simpler to read and

manipulate. The worksheet is comprised of columns (the vertical sets of boxes labelled A, B, C, etc), and

rows (the horizontal sets of boxes labelled 1, 2, 3, etc). At the intersection of each row and column is

a cell into which a user can enter either numbers or text. When you enter information or formulas into

Excel, they appear in the line of the formula bar.

7

Exercise 2 – Alignment and Formatting

The objective of this exercise if to learn font setting, alignment and styles. The Worksheet before font

formatting, alignment and style look as follows:

Once you have completed the exercise, your answer should look like this:

8

Exercise 3 – SUM and Decimals
From the data given in the table below, let’s learn to calculate the following:

a) total using the SUM formula

b) the grade in decimals

Once you have completed the exercise, your answer should look like this:

9

Exercise 4 – Percentage and AVERAGE Function
From the data given in Exercise 3, let’s learn to calculate the following:

a) the grade in % and

b) the average marks obtained in the quiz.

%. To calculate the average marks in the cell B10 =AVERAGE(B3:B9)

Once you have completed the exercise, your answer should look like this:

10

Practice Question 1 – SUM, Decimals and Percentage
Using the data given below, practice and fill the yellow coloured-missing figures

a) total using the SUM formula,

b) the grade in decimals,

c) the grade in %

Once you have completed the practice question, your answer should look like this:

11

Practice Question 2 – AVERAGE Function
Using the data given in the question, calculate the AVERAGE for each quiz and test.

Once you have completed the practice question, your answer should look like this:

12

Practice Question 3 – SUM and Sales Percentage
Find the missing values (highlighted in yellow colour)

Once you have completed the practice question, your answer should look like this:

13

Exercise 5 – Conditional Formatting Top 10 Values

From the data given in the table below. Highlight the Top 10 items using the conditional formatting.

Once you have completed the exercise, your answer should look like this:

14

Practice Question 4 – Conditional Formatting and SUM Function

From the data given in the table below, practice:

a) applying SUM formula in the highlighted yellow cells

b) conditional formatting – data bars.

c) conditional formatting – colour scales

d) conditional formatting – Icon sets

Once you have completed the practice question, your answer should look like this:

15

Exercise 6 – COUNT and COUNTA Functions

Count function: From the data given in the table below, COUNT function counts the numbers in a range

of cells. It is important to note that it will count the numbers and will not cater to the text items.

=COUNT(C5:C13). COUNTA function: Count all the cells that are not empty in a range of cells.

=COUNTA(C5:C13)

Once you have completed the exercise, your answer should look like this:

16

Exercise 7 – COUNTIFS and SUMIFS Functions

COUNTIFS function: Counts just come of the items in a range of cells based on a condition of a set of
criteria. For example, it can count how many times the word “Gigi” appears in a range of names . For

example, for Gigi, use the formula =COUNTIFS(B5:B13,F11)

SUMIFS function: Add just come of the numbers in a range based on a condition of a set of criteria. For

example, it can add sales for just the Sales Representative “Gigi” with the formula

=SUMIFS(C5:C13,B5:B13,F11).

Once you have completed the exercise, your answer should look like this:

17

Practice Question 5 – COUNT and COUNTA Functions

From the data given in the table below; find the missing values for COUNT and COUNTA.

Once you have completed the practice question, your answer should look like this:

18

Practice Question 6 – COUNTIFS, SUM and SUMIFS Functions

From the data given below, calculate COUNTIFS, SUM, SUMIFS

Once you have completed the practice question, your answer should look like this:

19

Practice Question 7 – COUNTIFS Function

From the data given in the table below; calculate the COUNTIF function for Buchanan and Dodsworth

Once you have completed the practice question, your answer should look like this:

20

Practice Question 8 – COUNTIFS Function

From the data given, practice the following requirement (part a, b, c, d and e):

a) count the number of cells in the range A2:A15 that equals 2

b) count the number of cells in the range A2:A15 that equals the value in cell A2

c) add the counts of cells in the range A2:A15 that equals to 4 to the count of the

cells in the same range equals to 8

d) count the number of cells in the range A2:A15 that contain a value greater than

the number 5

e) count the number of cells in the range A2:A15 that contain values not equal to

the value in A2

Once you have completed the practice question, your answer should look like this:

21

Practice Question 9 – SUM and SUMIF Functions

From the data given in the table below, calculate Q4 Sales using the SUM formula and SUMIF function

to calculate the meat sold in Quarter 4 of the year.

Once you have completed the practice question, your answer should look like this:

End of the workshop

1

Excel Workshop

Subject Code: ACC 202

Subject Name: Accounting Information Systems

Workshop Dates: Week 3, Week 6, Week 8 and Week 9

Workshop Location: Computer Lab

Objective: Microsoft Excel is the most used spreadsheet program in many business

activities; therefore, these workshops are aimed to provide you with the

fundamental and some advanced excel features.

Workshop Outline: The workshop questions are divided into Exercises and Practice

Questions. The lecturers are required to explain the concept with the help

of given exercises. The students are required to practice similar kind of

questions through practice questions.

2

Excel Advance

Week 8

Overview

Exercises Practice Questions

❖ Exercise 16

LOOKUP Function

❖ Exercise 17

VLOOKUP Function (Exact Match)

❖ Exercise 18

VLOOKUP Function (Approximate Match)

❖ Exercise 19

CLEAN Function

❖ Exercise 20

TRIM Function

❖ Exercise 21

RANK Function

❖ Exercise 22

PROPER Function

❖ Exercise 23

FREEZE Panes

❖ Exercise 24

CONCAT Function

❖ Practice Question 15

LOOKUP Function

❖ Practice Question 16

VLOOKUP Function (Exact Match)

❖ Practice Question 17

TRIM Function

❖ Practice Question 18

RANK Function

3

Exercise 16 – LOOKUP Function

From the given data, let’s find out which type of product was ordered in Order number 10251.

Once you have completed the exercise, your answer should look like this:

4

Practice Question 15 – LOOKUP Function

From the table given in the question, lookup which fruit was order in Order Number 10249 and 10252:

Once you have completed the practice question, your answer should look like this:

5

Exercise 17 – VLOOKUP Function (Exact Match)

VLOOKUP retrieves data based on column number. When you use VLOOKUP, imagine that every column

in the table is numbered, starting from the left.

Once you have completed the exercise, your answer should look like this:

6

Practice Question 16 – VLOOKUP Function (Exact Match)

From the given data, find the following information for a Student ID: 622

Once you have completed the practice question, your answer should look like this:

7

Exercise 18 – VLOOKUP Function (Approximate Match)

You’ll want to use approximate mode in cases when you’re looking for the best match, not an exact match.

From the data given, find the commission rate based on a monthly sales number.

Once you have completed the exercise, your answer should look like this:

8

Exercise 19 – CLEAN Function

The CLEAN function is categorized under Excel Text functions. The function removes non-printable

characters from the given text.

Once you have completed the exercise, your answer should look like this:

9

Exercise 20 – TRIM Function

The Excel TRIM function strips extra spaces from the text, leaving only a single space between words and

no space characters at the start or end of the text.

Once you have completed the exercise, your answer should look like this:

10

Practice Question 17 – TRIM Function

Practice using the Trim formula to eliminate the unnecessary spaces in the text.

Once you have completed the practice question, your answer should look like this:

11

Exercise 21 – RANK Function

RANK can rank values from largest to smallest (i.e. top sales) as well as smallest to largest (i.e. fastest

time) values, using an optional order argument.

Once you have completed the exercise, your answer should look like this:

12

Practice Question 18 – RANK Function

From the data given in the table below, find out the rank of all the students

Once you have completed the practice question, your answer should look like this:

13

Exercise 22 – PROPER Function

From the data given in the table below, apply the PROPER Function

Once you have completed the exercise, your answer should look like this:

14

Exercise 23 – Freeze Panes

From the data given in the table below, freeze a row and freeze a column. To freeze the column/row in

a sheet, click View tab > Freeze Panes.

Once you have completed the exercise, your answer should look like this:

15

Exercise 24 – CONCAT Function

From the data given in the table below, apply the CONCAT Function

Once you have completed the exercise, your answer should look like this:

End of the workshop

Page 2 Kaplan Business School Assessment Outline

Assessment 3

Information

Subject Code:

ACC

20

2

Subject Name:

Accounting Information Systems

Assessment Title:

Assessment 3

Assessment Type:

Excel Assignment

Weighting:

20%

Total Marks:

20

Submission:

Submit Excel Assignment on MyKBS

Due Date:

Monday of Week 11 at 15:55 AEST

Your Task

• Attend the Excel workshops conducted in class in Week 3, 6, 8 and 9
• Practice the Excel workshop exercises, and practice sets in the given weeks
• Solve the Excel Assignment provided under the assessment tab and submit through

MyKBS.

Assessment Description

Please refer to the Excel Assignment available on MyKBS, from Week 3, under the assessment
tab

Assessment Instructions

You are required to submit the Excel Assignment on MyKBS:

Page 2 Kaplan Business School Assessment Outline

Important Study Information

Academic Integrity Policy

KBS values academic integrity. All students must understand the meaning and consequences
of cheating, plagiarism and other academic offences under the Academic Integrity and Conduct
Policy.

What is academic integrity and misconduct?
What are the penalties for academic misconduct?
What are the late penalties?
How can I appeal my grade?

Click here for answers to these questions:
http://www.kbs.edu.au/current-students/student-policies/.

Word Limits for Written Assessments

Submissions that exceed the word limit by more than 10% will cease to be marked from the point
at which that limit is exceeded.

Study Assistance

Students may seek study assistance from their local Academic Learning Advisor or refer to the
resources on the MyKBS Academic Success Centre page. Click here for this information.

about:blank

about:blank

Assessment 3 Information
Subject Code:
Subject Name:
Assessment 3
Assessment Title:
Excel Assignment
Assessment Type:
Weighting:
Total Marks:
Submit Excel Assignment on MyKBS
Submission:
Monday of Week 11 at 15:55 AEST
Due Date:
20
20%
Accounting Information Systems
• ACC202

1

Excel Workshop

Subject Code: ACC 202

Subject Name: Accounting Information Systems

Workshop Dates: Week 3, Week 6, Week 8 and Week 9

Workshop Location: Computer Lab

Objective: Microsoft Excel is the most used spreadsheet program in many business

activities; therefore, these workshops are aimed to provide you with the

fundamental and some advanced excel features.

Workshop Outline: The workshop questions are divided into Exercises and Practice

Questions. The lecturers are required to explain the concept with the help

of given exercises. The students are required to practice similar kind of

questions through practice questions.

2

Week 6

Overview

Exercises Practice Questions

❖ Exercise 8

IF Function

❖ Exercise 9

IF Function (True, False)

❖ Exercise 10

IFERROR Function

❖ Exercise 11

AVERAGEIF Function

❖ Exercise 12

Remove Duplicate

❖ Exercise 13

MAX and MIN Function

❖ Exercise 14

Data Validation – Range

❖ Exercise 15

Data Validation – Drop Down Menu

❖ Practice Question 10

IF Function (True, False)

❖ Practice Question 11

IFERROR Function

❖ Practice Question 12

AVERAGEIF Function

❖ Practice Question 13

AVERAGEIF Function

❖ Practice Question 14

Data Validation

3

Exercise 8 – IF Function

The IF function is one of the most popular functions in Excel, and it allows you to make logical

comparisons between a value and what you expect. Enter the following data into Excel.

Once you have completed the exercise, your answer should look like this:

4

Exercise 9 – IF Function (True, False)

The IF function can perform a logical test and return one value for a TRUE result, and another for a

FALSE result. For example, to “pass” scores above or equal to 70: =IF(B2>=70,”Pass”,”Fail”). More than

one condition can be tested by nesting IF functions.

Once you have completed the exercise, your answer should look like this:

5

Practice Question 10 – IF Function (True, False)

From the given data, identify the students who have aced equivalent to 50 or above to pass.

Once you have completed the practice question, your answer should look like this:

6

Exercise 10 – IFERROR Function

Excel displays the #DIV/0! error when a formula tries to divide a number by 0. IFERROR checks for the

following errors: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.

Once you have completed the exercise, your answer should look like this:

7

Practice Question 11 – IFERROR Function

From the data given below, apply the IFERROR function.

Once you have completed the practice question, your answer should look like this:

8

Exercise 11 – AVERAGEIF Function

The AVERAGE function calculates the average of a series of numbers. That’s great, but what if you want

to choose a specific subset of numbers for your average? That’s where AVERAGEIF comes in. To find out

the value of the average test score in Spring:

Once you have completed the exercise, your answer should look like this:

9

Practice Question 12 – AVERAGEIF Function

From the data given in the table below, practice and find out the average value for chocolate pasties.

Once you have completed the practice question, your answer should look like this:

10

Practice Question 13 – AVERAGEIF Function

From the data given in the table below, practice and find out the average test value for Spring and Fall.

Once you have completed the practice question, your answer should look like this:

11

Exercise 12 – Remove Duplicate

If the duplicate data set is given, you can easily remove it in Excel.

Once you have completed the exercise, your answer should look like this:

12

Exercise 13 – MAX and MIN Function

The MAX function can be used to return the largest value from a set of data. The MIN function can be

used to return the smallest value from a set of data.

Once you have completed the exercise, your answer should look like this:

13

Exercise 14 – Data Validation – Range

Set data validation on cells C2:C15 to restrict users to a whole number between 0 and 26.

Once you have completed the exercise, your answer should look like this:

14

Exercise 15 – Data Validation – Drop Down Menu

Set a data validation list for cells C2:C15 (drop down list of three departments – Sales, Admin and

Accounts).

Once you have completed the exercise, your answer should look like this:

15

Practice Question 14 – Data Validation

From the data given below, set data validation on cells D2:D15 hours to restrict users to a whole

number between 0 and 32 and set a data validation list for cells C2:C15 ( Sales, Accounts). For column E,

calculate the pay: $22/hour multiply by number of hours worked.

Once you have completed the practice question, your answer should look like this:

End of the workshop