A davis
Jordanjameire
OF2021-Integrated-Project1-resources1.zipOF2021-Integrated-Project1-resources/DEC3-9Sales.xlsx
NewSales
| Date | Quantity | ItemID | State |
| 12/3/22 | 16 | OLDB005 | MD |
| 12/3/22 | 12 | ORIG001 | OH |
| 12/3/22 | 7 | ORIG001 | CA |
| 12/3/22 | 12 | CARA002 | MO |
| 12/3/22 | 10 | CARA002 | NJ |
| 12/3/22 | 16 | TRUF003 | VA |
| 12/3/22 | 9 | TRUF003 | DC |
| 12/3/22 | 12 | ORIG001 | AL |
| 12/3/22 | 16 | OLDB005 | MD |
| 12/3/22 | 13 | TRUF003 | DC |
| 12/3/22 | 16 | CARA002 | MS |
| 12/3/22 | 13 | ORIG001 | NC |
| 12/3/22 | 15 | ORIG001 | VA |
| 12/3/22 | 7 | OLDB005 | NJ |
| 12/3/22 | 9 | CARA002 | NY |
| 12/4/22 | 10 | OLDB005 | ID |
| 12/4/22 | 13 | CARA002 | OH |
| 12/4/22 | 14 | TRUF003 | NY |
| 12/4/22 | 11 | ORIG001 | AL |
| 12/4/22 | 10 | OLDB005 | MD |
| 12/4/22 | 14 | ORIG001 | NC |
| 12/4/22 | 11 | CARA002 | MS |
| 12/4/22 | 12 | ORIG001 | VA |
| 12/4/22 | 16 | OLDB005 | MD |
| 12/4/22 | 15 | OLDB005 | MD |
| 12/4/22 | 8 | OLDB005 | VA |
| 12/4/22 | 10 | ORIG001 | WV |
| 12/4/22 | 8 | CARA002 | CA |
| 12/4/22 | 10 | CARA002 | MO |
| 12/4/22 | 13 | CARA002 | MS |
| 12/4/22 | 12 | TRUF003 | NY |
| 12/4/22 | 9 | TRUF003 | NY |
| 12/4/22 | 9 | ORIG001 | OH |
| 12/5/22 | 12 | TRUF003 | NY |
| 12/5/22 | 12 | OLDB005 | MD |
| 12/5/22 | 11 | OLDB005 | DC |
| 12/5/22 | 7 | CARA002 | MS |
| 12/5/22 | 14 | CARA002 | AL |
| 12/5/22 | 16 | CARA002 | NC |
| 12/5/22 | 9 | ORIG001 | AL |
| 12/5/22 | 12 | ORIG001 | DC |
| 12/5/22 | 12 | ORIG001 | NY |
| 12/5/22 | 15 | ORIG001 | WV |
| 12/5/22 | 15 | ORIG001 | OH |
| 12/5/22 | 10 | TRUF003 | VA |
| 12/5/22 | 8 | OLDB005 | VA |
| 12/5/22 | 16 | CARA002 | DC |
| 12/5/22 | 9 | OLDB005 | MD |
| 12/5/22 | 15 | OLDB005 | WV |
| 12/5/22 | 15 | ORIG001 | AL |
| 12/5/22 | 16 | ORIG001 | SC |
| 12/5/22 | 7 | TRUF003 | SC |
| 12/6/22 | 13 | ORIG001 | OH |
| 12/6/22 | 16 | ORIG001 | NY |
| 12/6/22 | 13 | CARA002 | NJ |
| 12/6/22 | 11 | CARA002 | NJ |
| 12/6/22 | 12 | OLDB005 | NY |
| 12/6/22 | 14 | TRUF003 | NY |
| 12/6/22 | 8 | OLDB005 | OH |
| 12/6/22 | 11 | TRUF003 | DC |
| 12/6/22 | 13 | OLDB005 | CA |
| 12/7/22 | 14 | ORIG001 | AL |
| 12/7/22 | 15 | ORIG001 | MS |
| 12/7/22 | 15 | CARA002 | OH |
| 12/7/22 | 8 | OLDB005 | CA |
| 12/7/22 | 16 | OLDB005 | DC |
| 12/7/22 | 16 | ORIG001 | CA |
| 12/7/22 | 15 | TRUF003 | VA |
| 12/7/22 | 8 | CARA002 | NJ |
| 12/7/22 | 15 | CARA002 | WV |
| 12/8/22 | 12 | OLDB005 | DC |
| 12/8/22 | 8 | CARA002 | NJ |
| 12/8/22 | 9 | CARA002 | NY |
| 12/8/22 | 11 | ORIG001 | MD |
| 12/8/22 | 7 | ORIG001 | AL |
| 12/8/22 | 9 | TRUF003 | VA |
| 12/8/22 | 8 | OLDB005 | MD |
| 12/8/22 | 15 | OLDB005 | MD |
| 12/8/22 | 16 | OLDB005 | VA |
| 12/8/22 | 8 | TRUF003 | NY |
| 12/8/22 | 9 | ORIG001 | OH |
| 12/8/22 | 14 | CARA002 | CA |
| 12/8/22 | 11 | ORIG001 | CA |
| 12/8/22 | 15 | TRUF003 | CA |
| 12/8/22 | 9 | OLDB005 | MD |
| 12/8/22 | 16 | ORIG001 | MD |
| 12/8/22 | 8 | OLDB005 | VA |
| 12/8/22 | 16 | ORIG001 | VA |
| 12/8/22 | 15 | CARA002 | MS |
| 12/8/22 | 9 | ORIG001 | NC |
| 12/8/22 | 11 | ORIG001 | WV |
| 12/8/22 | 15 | OLDB005 | WV |
| 12/8/22 | 8 | TRUF003 | OH |
| 12/9/22 | 13 | OLDB005 | MD |
| 12/9/22 | 14 | TRUF003 | OH |
| 12/9/22 | 13 | ORIG001 | CA |
| 12/9/22 | 13 | ORIG001 | MD |
| 12/9/22 | 16 | CARA002 | VA |
| 12/9/22 | 10 | TRUF003 | MD |
| 12/9/22 | 11 | TRUF003 | VA |
| 12/9/22 | 8 | CARA002 | AL |
| 12/9/22 | 7 | OLDB005 | MD |
| 12/9/22 | 13 | OLDB005 | WV |
| 12/9/22 | 15 | ORIG001 | WV |
| 12/9/22 | 12 | TRUF003 | CA |
| 12/9/22 | 8 | TRUF003 | CA |
| 12/9/22 | 14 | TRUF003 | MO |
| 12/9/22 | 15 | ORIG001 | WV |
| 12/9/22 | 8 | CARA002 | DC |
| 12/9/22 | 13 | OLDB005 | DC |
| 12/9/22 | 9 | CARA002 | MD |
| 12/9/22 | 9 | CARA002 | VA |
| 12/9/22 | 16 | CARA002 | MS |
| 12/9/22 | 8 | OLDB005 | NC |
OF2021-Integrated-Project1-resources/Top't Corn Outline.docx
1. Overview
0. Founded in 1996 in Washington DC
0. Family owned and operated
0. Serving the DMV and beyond
1. Goals
1. Unique and delicious flavor profiles
1. Affordable prices for families
1. Easy access locations for quick purchasing
1. Our Top’t 3 Sellers
2. Original Blend
2. Old Bay
2. Sea Salt and Caramel
1. Future Flavors
3. Rosemary and Olive Oil
3. Spicy Buffalo
3. Korean Barbecue
3. Strawberry Fizz
1. Brick and Mortar Stores
4. National Harbor
4. Nationals Park
4. Old Town Alexandria
4. Mosaic District
1. Food Truck Locations
5. K Street
5. The Wharf
5. Georgetown
5. Nationals Park
1. Truffle Sales by State
1. Maryland Sales of Old Bay Flavor
1. Pricing
8. Price per box $14
8. Commemorative packaging $5
8. DIY Toppings $3
OF2021-Integrated-Project1-resources/Top't Corn Sales Database.accdb
| ItemID | ItemName | Price |
|---|---|---|
| CARA002 | Sea Salt and Caramel | 9 |
| OLDB005 | Old Bay | 9 |
| ORIG001 | Original Blend | 9 |
| TRUF003 | Truffle | 9 |
| CHOC008 | Chocolate | 9 |
| LocationID | LocationDescription | Comments | OpenTime | CloseTime | Days |
|---|---|---|---|---|---|
| FARR | Farragut Square | 1899-12-30 | 1899-12-30 | M-F | |
| Gtown | Georgetown | 1899-12-30 | 1899-12-30 | Th-Sa | |
| GW | George Washington University | 1899-12-30 | 1899-12-30 | Th-Sa | |
| KSt | K Street | 1899-12-30 | 1899-12-30 | M-F | |
| Tysons | Tysons Corner Store | Our store location at Tysons Corner near the mall | 1899-12-30 | 1899-12-30 | M-Su |
| Date | Quantity | ItemID | State | ID |
|---|---|---|---|---|
| 2022-12-03 | 13.0 | OLDB005 | MD | 1 |
| 2022-12-03 | 9.0 | ORIG001 | OH | 2 |
| 2022-12-03 | 4.0 | ORIG001 | CA | 3 |
| 2022-12-03 | 9.0 | CARA002 | MO | 4 |
| 2022-12-03 | 7.0 | CARA002 | NJ | 5 |
| 2022-12-03 | 13.0 | TRUF003 | VA | 6 |
| 2022-12-03 | 6.0 | TRUF003 | DC | 7 |
| 2022-12-03 | 9.0 | ORIG001 | AL | 8 |
| 2022-12-03 | 13.0 | OLDB005 | MD | 9 |
| 2022-12-03 | 10.0 | TRUF003 | DC | 10 |
| 2022-12-03 | 13.0 | CARA002 | MS | 11 |
| 2022-12-03 | 10.0 | ORIG001 | NC | 12 |
| 2022-12-03 | 12.0 | ORIG001 | VA | 13 |
| 2022-12-03 | 13.0 | OLDB005 | NJ | 14 |
| 2022-12-03 | 4.0 | OLDB005 | NJ | 15 |
| 2022-12-03 | 6.0 | CARA002 | NY | 16 |
| 2022-12-04 | 7.0 | OLDB005 | ID | 17 |
| 2022-12-04 | 10.0 | CARA002 | OH | 18 |
| 2022-12-04 | 11.0 | TRUF003 | NY | 19 |
| 2022-12-04 | 8.0 | ORIG001 | AL | 20 |
| 2022-12-04 | 7.0 | OLDB005 | MD | 21 |
| 2022-12-04 | 11.0 | ORIG001 | NC | 22 |
| 2022-12-04 | 8.0 | CARA002 | MS | 23 |
| 2022-12-04 | 9.0 | ORIG001 | VA | 24 |
| 2022-12-04 | 13.0 | OLDB005 | MD | 25 |
| 2022-12-04 | 12.0 | OLDB005 | MD | 26 |
| 2022-12-04 | 5.0 | OLDB005 | VA | 27 |
| 2022-12-04 | 7.0 | ORIG001 | WV | 28 |
| 2022-12-04 | 5.0 | CARA002 | CA | 29 |
| 2022-12-04 | 7.0 | CARA002 | MO | 30 |
| 2022-12-04 | 10.0 | CARA002 | MS | 31 |
| 2022-12-04 | 9.0 | TRUF003 | NY | 32 |
| 2022-12-04 | 6.0 | TRUF003 | NY | 33 |
| 2022-12-04 | 6.0 | ORIG001 | OH | 34 |
| 2022-12-05 | 9.0 | TRUF003 | NY | 35 |
| 2022-12-05 | 9.0 | OLDB005 | MD | 36 |
| 2022-12-05 | 8.0 | OLDB005 | DC | 37 |
| 2022-12-05 | 4.0 | CARA002 | MS | 38 |
| 2022-12-05 | 11.0 | CARA002 | AL | 39 |
| 2022-12-05 | 13.0 | CARA002 | NC | 40 |
| 2022-12-05 | 6.0 | ORIG001 | AL | 41 |
| 2022-12-05 | 9.0 | ORIG001 | DC | 42 |
| 2022-12-05 | 9.0 | ORIG001 | NY | 43 |
| 2022-12-05 | 12.0 | ORIG001 | WV | 44 |
| 2022-12-05 | 12.0 | ORIG001 | OH | 45 |
| 2022-12-05 | 7.0 | TRUF003 | VA | 46 |
| 2022-12-05 | 5.0 | OLDB005 | VA | 47 |
| 2022-12-05 | 13.0 | CARA002 | DC | 48 |
| 2022-12-05 | 6.0 | OLDB005 | MD | 49 |
| 2022-12-05 | 12.0 | OLDB005 | WV | 50 |
| 2022-12-05 | 12.0 | ORIG001 | AL | 51 |
| 2022-12-05 | 13.0 | ORIG001 | SC | 52 |
| 2022-12-05 | 4.0 | TRUF003 | SC | 53 |
| 2022-12-06 | 10.0 | ORIG001 | OH | 54 |
| 2022-12-06 | 13.0 | ORIG001 | NY | 55 |
| 2022-12-06 | 10.0 | CARA002 | NJ | 56 |
| 2022-12-06 | 8.0 | CARA002 | NJ | 57 |
| 2022-12-06 | 9.0 | OLDB005 | NY | 58 |
| 2022-12-06 | 11.0 | TRUF003 | NY | 59 |
| 2022-12-06 | 5.0 | OLDB005 | OH | 60 |
| 2022-12-06 | 8.0 | TRUF003 | DC | 61 |
| 2022-12-06 | 10.0 | OLDB005 | CA | 62 |
| 2022-12-07 | 11.0 | ORIG001 | AL | 63 |
| 2022-12-07 | 12.0 | ORIG001 | MS | 64 |
| 2022-12-07 | 12.0 | CARA002 | OH | 65 |
| 2022-12-07 | 5.0 | OLDB005 | CA | 66 |
| 2022-12-07 | 13.0 | OLDB005 | DC | 67 |
| 2022-12-07 | 13.0 | ORIG001 | CA | 68 |
| 2022-12-07 | 12.0 | TRUF003 | VA | 69 |
| 2022-12-07 | 5.0 | CARA002 | NJ | 70 |
| 2022-12-07 | 12.0 | CARA002 | WV | 71 |
| 2022-12-08 | 5.0 | OLDB005 | MD | 72 |
| 2022-12-08 | 9.0 | OLDB005 | DC | 73 |
| 2022-12-08 | 5.0 | CARA002 | NJ | 74 |
| 2022-12-08 | 6.0 | CARA002 | NY | 75 |
| 2022-12-08 | 8.0 | ORIG001 | MD | 76 |
| 2022-12-08 | 4.0 | ORIG001 | AL | 77 |
| 2022-12-08 | 6.0 | TRUF003 | VA | 78 |
| 2022-12-08 | 5.0 | OLDB005 | MD | 79 |
| 2022-12-08 | 12.0 | OLDB005 | MD | 80 |
| 2022-12-08 | 13.0 | OLDB005 | VA | 81 |
| 2022-12-08 | 5.0 | TRUF003 | NY | 82 |
| 2022-12-08 | 6.0 | ORIG001 | OH | 83 |
| 2022-12-08 | 11.0 | CARA002 | CA | 84 |
| 2022-12-08 | 8.0 | ORIG001 | CA | 85 |
| 2022-12-08 | 12.0 | TRUF003 | CA | 86 |
| 2022-12-08 | 6.0 | OLDB005 | MD | 87 |
| 2022-12-08 | 13.0 | ORIG001 | MD | 88 |
| 2022-12-08 | 5.0 | OLDB005 | VA | 89 |
| 2022-12-08 | 13.0 | ORIG001 | VA | 90 |
| 2022-12-08 | 12.0 | CARA002 | MS | 91 |
| 2022-12-08 | 6.0 | ORIG001 | NC | 92 |
| 2022-12-08 | 8.0 | ORIG001 | WV | 93 |
| 2022-12-08 | 12.0 | OLDB005 | WV | 94 |
| 2022-12-08 | 5.0 | TRUF003 | OH | 95 |
| 2022-12-09 | 10.0 | OLDB005 | MD | 96 |
| 2022-12-09 | 11.0 | TRUF003 | OH | 97 |
| 2022-12-09 | 10.0 | ORIG001 | CA | 98 |
| 2022-12-09 | 10.0 | ORIG001 | MD | 99 |
| 2022-12-09 | 13.0 | CARA002 | VA | 100 |
| 2022-12-09 | 7.0 | TRUF003 | MD | 101 |
| 2022-12-09 | 8.0 | TRUF003 | VA | 102 |
| 2022-12-09 | 5.0 | CARA002 | AL | 103 |
| 2022-12-09 | 4.0 | OLDB005 | MD | 104 |
| 2022-12-09 | 10.0 | OLDB005 | WV | 105 |
| 2022-12-09 | 12.0 | ORIG001 | WV | 106 |
| 2022-12-09 | 9.0 | TRUF003 | CA | 107 |
| 2022-12-09 | 5.0 | TRUF003 | CA | 108 |
| 2022-12-09 | 11.0 | TRUF003 | MO | 109 |
| 2022-12-09 | 12.0 | ORIG001 | WV | 110 |
| 2022-12-09 | 5.0 | CARA002 | DC | 111 |
| 2022-12-09 | 10.0 | OLDB005 | DC | 112 |
| 2022-12-09 | 6.0 | CARA002 | MD | 113 |
| 2022-12-09 | 6.0 | CARA002 | VA | 114 |
| 2022-12-09 | 8.0 | TRUF003 | AL | 115 |
