Assignment

profileSimransukh
coffees20Worksheet_a57990df40b42ccab7b3300627dc62fa.xlsx

coffees

ProductID ProductNo Description Cost
1 10000 Columbian Gold 62.00
2 10001 Columbian Gold 33.00
3 10002 Columbian Gold 16.10
4 11000 Vera Cruz Premium 50.00
5 11001 Vers Cruz Premium 28.90
6 11002 Vers Cruz Premium 14.00
7 20000 Uganda Premium 66.80
8 20001 Uganda Premium 42.00
9 20002 Uganda Premium 23.30
10 21000 Tanzania Brava 51.45
11 21001 Tanzania Brava 38.00
12 21002 Tanzania Brava 20.90
13 22000 Ethiopian Premium 63.10
14 22001 Ethiopian Premium EL 37.00
15 22002 Ethiopian Premium 19.80
16 12000 Brazil Excelsior 44.80
17 12001 Brazil Excelsior 31.00
18 12002 Brazil Excelsior 14.00
19 30000 Hawian Wave 59.00
20 30001 Hawian Wave 32.00
21 30002 Hawian Wave 19.50
22 13000 Costa Rica Gold 44.00
23 13001 Costa Rica Gold 27.00
24 13002 Costa Rica Gold 14.60
25

Sheet1

Description Company Quantity
Columbian Gold Run Way 180 3
Columbian Gold Riviera Club 6
Columbian Gold Wave Coffee 8
Vera Cruz Premium Weston Hotel 8
Vers Cruz Premium Riviera Club 6
Vers Cruz Premium Run Way 180 12
Uganda Premium Whole Foods 5
Uganda Premium Hotel Vancouver 5
Uganda Premium Four Seasons 5
Tanzania Brava Wave Coffee 11
Tanzania Brava Weston Hotel 5
Tanzania Brava Yacca Café 5
Ethiopian Premium Run Way 180 12
Ethiopian Premium EL Wave Coffee 5
Ethiopian Premium Riviera Club 5
Brazil Excelsior Weston Hotel 33
Brazil Excelsior Yacca Café 3
Brazil Excelsior Everwood Hotels 3
Hawian Wave Hotel Vancouver 3
Hawian Wave Four Seasons 3
Hawian Wave Pinnacle Hotels 22
Costa Rica Gold Wave Coffee 44
Costa Rica Gold Weston Hotel 23
Costa Rica Gold Yacca Café 10
Riviera Club 12

Sheet2

CompanysID Company City Addressd1 Address2 Contact
1000 Yacca Café Vancouver 4420 Granville Claire Norris
1001 Riviera Club Vancouver 189 Davey Talin Stewart
1002 Wave Coffee BBY 351 Sperling Oris Adams
1003 Weston Hotel Vancouver 340 Georgia Roman Camenta
1004 Run Way 180 Richmond 1000 Grant Mechian Way Unit 400 Carmen Keely
1005 Whole Foods West Vancouver 233 Marines Dr C.B. Rollens
1006 Everwood Hotels Calgary 2550 Range Road Unit 2300 Terra Morton
1007 Hotel Vancouver Vancouver 1200 Georgia St Chef Milton
1008 Four Seasons Calgary 54 Airport Road Nelson Young
1009 Pinnacle Hotels Vancouver 138 Ship Way Angie Lee

Sheet3

Company Date Description Cost
Run Way 180 April 3,2019 Columbian Gold 62
Riviera Club April 3,2019 Columbian Gold 33
Wave Coffee April 3,2019 Columbian Gold 16.1
Weston Hotel April 3,2019 Vera Cruz Premium 50
Riviera Club April 15,2019 Vers Cruz Premium 28.9
Run Way 180 April 15,2019 Vers Cruz Premium 14
Whole Foods April 15,2019 Uganda Premium 66.8
Hotel Vancouver April 15,2019 Uganda Premium 42
Four Seasons April 15,2019 Uganda Premium 23.3
Wave Coffee April 15,2019 Tanzania Brava 51.45
Weston Hotel April 15,2019 Tanzania Brava 38
Yacca Café April 15,2019 Tanzania Brava 20.9
Run Way 180 May 2,2019 Ethiopian Premium 63.1
Wave Coffee May 2,2019 Ethiopian Premium EL 37
Riviera Club May 2,2019 Ethiopian Premium 19.8
Weston Hotel May 2,2019 Brazil Excelsior 44.8
Yacca Café May 2,2019 Brazil Excelsior 31
Everwood Hotels May1 2,2019 Brazil Excelsior 14
Hotel Vancouver May 12,2019 Hawian Wave 59
Four Seasons May 12,2019 Hawian Wave 32
Pinnacle Hotels May 12,2019 Hawian Wave 19.5
Wave Coffee June 7,2019 Costa Rica Gold 44
Weston Hotel June 7,2019 Costa Rica Gold 27
Yacca Café June 7,2019 Costa Rica Gold 14.6
Riviera Club July 12,2019

Sheet4

OrdersID CompanysID Company OrderNo Date ProductNo Description Quantity Cost Total AccountBalance DaysOverdue
1 1004 Run Way 180 19700 April 3,2019 11001 Vers Cruz Premium 3 33 99 0 0
2 1001 Riviera Club 19722 April 3,2019 20002 Uganda Premium 6 23.3 139.8 0 0
3 1002 Wave Coffee 19744 April 3,2019 21001 Tanzania Brava 8 38 304 120 30
4 1003 Weston Hotel 19750 April 3,2019 22000 Ethiopian Premium 8 63.1 504.8 96 60
5 1001 Riviera Club 19752 April 15,2019 21002 Tanzania Brava 6 20.9 125.4 0 0
6 1004 Run Way 180 19771 April 15,2019 22002 Ethiopian Premium 12 19.8 237.6 0 0
7 1005 Whole Foods 19782 April 15,2019 11000 Vera Cruz Premium 5 50 250 0 0
8 1007 Hotel Vancouver 19783 April 15,2019 30000 Hawian Wave 5 59 295 54 30
9 1008 Four Seasons 19784 April 15,2019 13000 Costa Rica Gold 5 44 220 0 0
10 1002 Wave Coffee 19790 April 15,2019 12002 Brazil Excelsior 11 14 154 0 0
11 1003 Weston Hotel 19791 April 15,2019 30000 Hawian Wave 5 59 295 95 60
12 1000 Yacca Café 19793 April 15,2019 13000 Costa Rica Gold 5 44 220 0 0
13 1004 Run Way 180 19803 May 2,2019 10001 Columbian Gold 12 33 396 110 30
14 1002 Wave Coffee 19808 May 2,2019 11000 Vera Cruz Premium 5 50 250 0 0
15 1001 Riviera Club 19817 May 2,2019 21000 Tanzania Brava 5 51.45 257.25 0 0
16 1003 Weston Hotel 19820 May 2,2019 21002 Tanzania Brava 33 20.9 689.7 225 60
17 1000 Yacca Café 19825 May 2,2019 22001 Ethiopian Premium EL 3 37 111 0 0
18 1006 Everwood Hotels 19829 May1 2,2019 11001 Vers Cruz Premium 3 28.9 86.7 0 0
19 1007 Hotel Vancouver 19832 May 12,2019 20001 Uganda Premium 3 42 126 0 0
20 1008 Four Seasons 19833 May 12,2019 21001 Tanzania Brava 3 38 114 0 0
21 1009 Pinnacle Hotels 19834 May 12,2019 22002 Ethiopian Premium 22 19.8 435.6 67 90
22 1002 Wave Coffee 19840 June 7,2019 10002 Columbian Gold 44 16.1 708.4 344 60
23 1003 Weston Hotel 19842 June 7,2019 11002 Vers Cruz Premium 23 14 322 0 0
24 1000 Yacca Café 19843 June 7,2019 13001 Costa Rica Gold 10 27 270 0 0
25 1001 Riviera Club 19845 July 12,2019 11002 Vers Cruz Premium 12 14 168 0 0
26 1002 Wave Coffee 19846 July 12,2019 12000 Brazil Excelsior 5 44.8 224 0 0
27 1004 Run Way 180 19847 July 12,2019 30000 Hawian Wave 5 59 295 0 0
28 1005 Whole Foods 19848 July 12,2019 30001 Hawian Wave 21 32 672 455 30
29 1006 Everwood Hotels 19851 July 12,2019 13000 Costa Rica Gold 5 44 220 0 0
30 1002 Wave Coffee 19853 August 3,2019 10002 Columbian Gold 21 16.1 338.1 0 0
31 1007 Hotel Vancouver 19854 August 3,2020 11001 Vers Cruz Premium 3 28.9 86.7 0 0
32 1008 Four Seasons 19855 August 3,2021 20000 Uganda Premium 5 66.8 334 0 0
33 1001 Riviera Club 19856 August 16,2019 21002 Tanzania Brava 21 20.9 438.9 89 60
34 1003 Weston Hotel 19857 August 17,2019 12000 Brazil Excelsior 5 44.8 224 0 0
35 1004 Run Way 180 19858 August 17,2019 12001 Brazil Excelsior 3 31 93 0 0
36 1005 Whole Foods 19859 August 17,2019 30002 Hawian Wave 12 19.5 234 0 0
37 1000 Yacca Café 19860 September 3,2019 20000 Uganda Premium 5 66.8 334 0 0
38 1002 Wave Coffee 19863 September 3,2019 21002 Tanzania Brava 12 20.9 250.8 0 0
39 1007 Hotel Vancouver 19866 September 3,2019 22000 Ethiopian Premium 5 63.1 315.5 55 90
40 1008 Four Seasons 19869 September 6,2019 30001 Hawian Wave 3 32 96 0 0
41 1009 Pinnacle Hotels 19873 September 9,2019 30002 Hawian Wave 16 19.5 312 0 0
42 1003 Weston Hotel 19875 Octobert 1,2019 10000 Columbian Gold 5 62 310 0 0
43 1004 Run Way 180 19877 Octobert 1,2019 11001 Vers Cruz Premium 22 28.9 635.8 300 60
44 1005 Whole Foods 19879 Octobert 1,2019 11002 Vers Cruz Premium 44 14 616 277 120
45 1006 Everwood Hotels 19881 Octobert 18,2019 20000 Uganda Premium 5 66.8 334 0 0
46 1007 Hotel Vancouver 19883 Octobert 18,2019 20001 Uganda Premium 3 42 126 0 0
47 1008 Four Seasons 19890 Octobert 18,2019 20002 Uganda Premium 33 23.3 768.9 0 0
48 1009 Pinnacle Hotels 19891 Octobert 18,2019 30001 Hawian Wave 33 32 1,056.00 344 90
49 1000 Yacca Café 19894 November 1,2019 10000 Columbian Gold 5 62 310 0 0
50 1001 Riviera Club 19895 November 1,2019 11001 Vers Cruz Premium 12 28.9 346.8 0 0
51 1002 Wave Coffee 19898 November 10,2019 20000 Uganda Premium 5 66.8 334 0 0
52 1003 Weston Hotel 19900 November 10,2019 22000 Ethiopian Premium 12 63.1 757.2 211 30
53 1004 Run Way 180 19902 November 11,2019 12001 Brazil Excelsior 12 31 372 0 0
54 1005 Whole Foods 19903 November 12,2019 30000 Hawian Wave 24 59 1,416.00 322 60
55 1006 Everwood Hotels 19904 November 12,2019 13000 Costa Rica Gold 24 44 1,056.00 424 160
56 1007 Hotel Vancouver 19905 November 12,2019 13001 Costa Rica Gold 3 27 81 0 0
57 1008 Four Seasons 19911 November 13,2019 13002 Costa Rica Gold 24 14.6 350.4 0 0
58 1009 Pinnacle Hotels 19915 November 13,2019 12001 Brazil Excelsior 12 31 372 0 0
59 1000 Yacca Café 19930 December 2,2019 11000 Vera Cruz Premium 5 50 250 0 0
60 1001 Riviera Club 19933 December 4,2019 11001 Vers Cruz Premium 3 28.9 86.7 0 0
61 1002 Wave Coffee 19935 December 4,2019 20001 Uganda Premium 3 42 126 0 0
62 1003 Weston Hotel 19937 December 4,2019 20002 Uganda Premium 1 23.3 23.3 0 0
63 1004 Run Way 180 19940 December6 ,2019 21000 Tanzania Brava 5 51.45 56.45 0 0
64

Sheet5

Company Total DaysOverdue Contact
Yacca Café 220 0 Claire Norris
Yacca Café 111 0 Claire Norris
Yacca Café 270 0 Claire Norris
Yacca Café 334 0 Claire Norris
Yacca Café 310 0 Claire Norris
Yacca Café 250 0 Claire Norris
Riviera Club 139.8 0 Talin Stewart
Riviera Club 125.4 0 Talin Stewart
Riviera Club 257.25 0 Talin Stewart
Riviera Club 168 0 Talin Stewart
Riviera Club 438.9 60 Talin Stewart
Riviera Club 346.8 0 Talin Stewart
Riviera Club 86.7 0 Talin Stewart
Wave Coffee 304 30 Oris Adams
Wave Coffee 154 0 Oris Adams
Wave Coffee 250 0 Oris Adams
Wave Coffee 708.4 60 Oris Adams
Wave Coffee 224 0 Oris Adams
Wave Coffee 338.1 0 Oris Adams
Wave Coffee 250.8 0 Oris Adams
Wave Coffee 334 0 Oris Adams
Wave Coffee 126 0 Oris Adams
Weston Hotel 504.8 60 Roman Camenta
Weston Hotel 295 60 Roman Camenta
Weston Hotel 689.7 60 Roman Camenta
Weston Hotel 322 0 Roman Camenta
Weston Hotel 224 0 Roman Camenta
Weston Hotel 310 0 Roman Camenta
Weston Hotel 757.2 30 Roman Camenta
Weston Hotel 23.3 0 Roman Camenta
Run Way 180 99 0 Carmen Keely
Run Way 180 237.6 0 Carmen Keely
Run Way 180 396 30 Carmen Keely
Run Way 180 295 0 Carmen Keely
Run Way 180 93 0 Carmen Keely
Run Way 180 635.8 60 Carmen Keely
Run Way 180 372 0 Carmen Keely
Run Way 180 56.45 0 Carmen Keely
Whole Foods 250 0 C.B. Rollens
Whole Foods 672 30 C.B. Rollens
Whole Foods 234 0 C.B. Rollens
Whole Foods 616 120 C.B. Rollens
Whole Foods 1,416.00 60 C.B. Rollens
Everwood Hotels 86.7 0 Terra Morton
Everwood Hotels 220 0 Terra Morton
Everwood Hotels 334 0 Terra Morton
Everwood Hotels 1,056.00 160 Terra Morton
Hotel Vancouver 295 30 Chef Milton
Hotel Vancouver 126 0 Chef Milton
Hotel Vancouver 86.7 0 Chef Milton
Hotel Vancouver 315.5 90 Chef Milton
Hotel Vancouver 126 0 Chef Milton
Hotel Vancouver 81 0 Chef Milton
Four Seasons 220 0 Nelson Young
Four Seasons 114 0 Nelson Young
Four Seasons 334 0 Nelson Young
Four Seasons 96 0 Nelson Young
Four Seasons 768.9 0 Nelson Young
Four Seasons 350.4 0 Nelson Young
Pinnacle Hotels 435.6 90 Angie Lee
Pinnacle Hotels 312 0 Angie Lee
Pinnacle Hotels 1,056.00 90 Angie Lee
Pinnacle Hotels 372 0 Angie Lee

Sheet6

Description Company Date AccountBalance
Columbian Gold Run Way 180 April 3,2019 0
Columbian Gold Riviera Club April 3,2019 0
Columbian Gold Wave Coffee April 3,2019 120
Vera Cruz Premium Weston Hotel April 3,2019 96
Vers Cruz Premium Riviera Club April 15,2019 0
Vers Cruz Premium Run Way 180 April 15,2019 0
Uganda Premium Whole Foods April 15,2019 0
Uganda Premium Hotel Vancouver April 15,2019 54
Uganda Premium Four Seasons April 15,2019 0
Tanzania Brava Wave Coffee April 15,2019 0
Tanzania Brava Weston Hotel April 15,2019 95
Tanzania Brava Yacca Café April 15,2019 0
Ethiopian Premium Run Way 180 May 2,2019 110
Ethiopian Premium EL Wave Coffee May 2,2019 0
Ethiopian Premium Riviera Club May 2,2019 0
Brazil Excelsior Weston Hotel May 2,2019 225
Brazil Excelsior Yacca Café May 2,2019 0
Brazil Excelsior Everwood Hotels May1 2,2019 0
Hawian Wave Hotel Vancouver May 12,2019 0
Hawian Wave Four Seasons May 12,2019 0
Hawian Wave Pinnacle Hotels May 12,2019 67
Costa Rica Gold Wave Coffee June 7,2019 344
Costa Rica Gold Weston Hotel June 7,2019 0
Costa Rica Gold Yacca Café June 7,2019 0
Riviera Club July 12,2019 0

Sheet7

Company Date Quantity Description Cost
Run Way 180 April 3,2019 3 Columbian Gold 62
Riviera Club April 3,2019 6 Columbian Gold 33
Wave Coffee April 3,2019 8 Columbian Gold 16.1
Weston Hotel April 3,2019 8 Vera Cruz Premium 50
Riviera Club April 15,2019 6 Vers Cruz Premium 28.9
Run Way 180 April 15,2019 12 Vers Cruz Premium 14
Whole Foods April 15,2019 5 Uganda Premium 66.8
Hotel Vancouver April 15,2019 5 Uganda Premium 42
Four Seasons April 15,2019 5 Uganda Premium 23.3
Wave Coffee April 15,2019 11 Tanzania Brava 51.45
Weston Hotel April 15,2019 5 Tanzania Brava 38
Yacca Café April 15,2019 5 Tanzania Brava 20.9
Run Way 180 May 2,2019 12 Ethiopian Premium 63.1
Wave Coffee May 2,2019 5 Ethiopian Premium EL 37
Riviera Club May 2,2019 5 Ethiopian Premium 19.8
Weston Hotel May 2,2019 33 Brazil Excelsior 44.8
Yacca Café May 2,2019 3 Brazil Excelsior 31
Everwood Hotels May1 2,2019 3 Brazil Excelsior 14
Hotel Vancouver May 12,2019 3 Hawian Wave 59
Four Seasons May 12,2019 3 Hawian Wave 32
Pinnacle Hotels May 12,2019 22 Hawian Wave 19.5
Wave Coffee June 7,2019 44 Costa Rica Gold 44
Weston Hotel June 7,2019 23 Costa Rica Gold 27
Yacca Café June 7,2019 10 Costa Rica Gold 14.6
Riviera Club July 12,2019 12