San Diego Mesa College Workbook Excel File

Part 1 – Create your file and Import your data

Start Excel creating a new Blank workbook using Excel 2016 or 2019Save the file with the Name _Excel_Exam2Files created in older versions of Excel may not earn full credit!

Enter the appropriate Excel header and footer elements in the locations below. The only part you should type is your name.

Left Click the link below to create your file.A download link will appear after you click the link and your file has been created. By clicking Create My Data File the button below you agree to follow the guidelines for this assignment.  – Click onceImport the data file that you downloaded and add 2 rowsThe file is a Comma Delimited file so be sure to select that option during the import.Use the Load To option in the import wizard and load the data into cell A3.Use the Convert to Range option, in Table Design tab, to convert the table to a range.At this point your file should look something similar to this image with 417 rows of data and rows 1 & 2 are empty.Add 3 document properties via the Document Properties panel.Author:Title:  2 Spring 2021Comments: location where you completed the  i.e Home System, Work ComputerSave the file with the name _Excel

_Exam2.xlsx

Part 2 – Layout, Format and Enter Formulas – Revenue Worksheet

Modify the worksheet to format and calculate the revenue with a discount.

Important – The formula for Sales Price (step 11) must use the correct cell reference type (refer to your Excel text page E2-93).

Worksheet data entry, the following cells should contain information as follows:cell G2 contains the text Markup.cell G3 contains the text Order Total.cell H2 contains the value 15% formatted as percent with 0 decimal places.cell H3 contains the text Sale Price.

Add the title your last name Revenue in cell A1. (e.g. Revenue).

Change the title font size in cell A1 to 18 points.

Calculate Order Total in column G for all 416 items. The Order Total is the Quantity times the Unit Price.

Calculate Sales Price in column H for all 416 items. The Sales Price is the Order Total times (1 + Markup) + Quantity times Shipping.Self check 1- Changing the value in cell H2 should cause all sales prices to increase. If it doesn’t then you did not use the correct cell reference type in your formula for Sales Price.Be sure to set cell H2 back to 15% after checking.Self check 2 – If your Sales Price formula for the first row is correct then you should be able to copy it to all the remaining rows in the worksheet and obtain the correct results.

Merge and Center the title in cell A1 across only the data columns of the worksheet.

Add like breaks between words in all column titles with 2 words by using a line break. Do not use wrap lines.

Change all column widths to 20 to verify that the text still wraps correctly.Set columns A, C, D, E, and F – width 10 (75 pixels)Set columns B, G, and H – width 13 (96 pixels)

Bold all column headings in row 3.

Align all the column titles vertically at the top and horizontally centered.

Theme make sure you are using the standard Office theme and set the background color of cell A1 to Green, Accent 6 Darker 25% and the text color to White.

Change the background color of cells A3:H3 to Green, Accent 6 Lighter 60%. View Formatted Example of rows 1 – 3 to this point

Rename the worksheet tab to Revenue.

Change the tab color to Green, Accent 6, Lighter 60%.

Freeze panesColumn A and Rows 1-3 should remain visible when you scroll either horizontally or vertically

Enter formulas at the bottom of the Order Total and Sales Price columns to calculate the total all items each of those columns and bold the results in those cells.

Enter the text Totals in column F next to the cell containing the formula you added in the previous step. Format the text as bold.

Add the range name Revenue_Total for the Sales Price total cell at the bottom of the Sales Price column. The scope of the range name should be the workbook and not restricted to a worksheet. Check the scope using the Name Manager.

Format as follows:columns, Unit Price, Shipping – set as comma stylecolumns Order Total, Sales Price – set as comma style with 0 decimal placescolumn D – Short Datecell H2 – Percent

Change the worksheet view to the Normal view (if needed).

Save the workbook before continuing.

Part 3 – What-If Analysis

Analysis Worksheet – In this part of the exam we need to find out how much the markup would need to be increased to produce a total increase in the sales price of the amount specified. The excel tool to accomplish this is the Goal Seek feature. In order for this to work we need to have the sales price dependent on the markup value which you created in Part 2.

If the sales price does not change with a change in the markup price then Goal Seek will not work.

Goal Seek is covered in Chapter 8 page 498.

Copy the Revenue worksheet to a new tab changing tab name to Analysis

Change the tab color to Orange, Accent 2, Lighter 60%

Change the text in cell A1 to Analysis

Change background fill color the cell A1 to Orange Accent 2, Darker 25%

Add the range name Analysis_Total for the Sales total revenue cell at the bottom of the column. The scope of the range name should be the workbook and not restricted to a worksheet.

Use Goal Seeking to adjust the Markup value in cell H2.The Sales Price total value is $20,000 higher than the value in the Revenue worksheet.You must use Goal Seek.Widen the column enough to display the result at the bottom of the column.Format the data area A3:H419 including the column headings but not the totals at the bottom of the columns as a Table using style Medium 3 (1st row in Medium list, column 3)Select Yes if you receive the message “Your selection overlaps one or more data ranges. …”

Change the fill color for the column headings in row 3 to match row 1. – see example

Part 4 – Sorting and Filtering

Filtered Worksheet – In this part of the  you will be sorting on multiple columns, adding subtotals and then applying filters to the data. Most of this content was covered in chapter 4.

Caution – You must select the correction worksheet area before sorting. If you don’t then you will corrupt the data and end up with multiple subtotals in each category.

Copy the Revenue worksheet to a new tab and name it Filtered

Change the tab color to Blue, Accent 1, Lighter 60%

Change the text in cell A1 to Filtered

Change background fill color the cell A1 to Blue, Accent 1, Darker 25%

Delete the totals and adjacent text at the bottom of the data rows in the Filtered worksheet so only the sales remain.

Add a filters for the column headings in row 3 of the Filtered worksheet.

Using the Sort button on the ribbon, add a Custom Sort Sort the data by the Category Name in ascending order (A to Z)

Add a secondary sort on the Quantity in ascending order (Smallest to Largest)

Add Subtotals for Order Total and Sales Price with each change in Category Name and include Summary below the data

Change the filter to only show the Meat/Poultry Category and Meat/Poultry Total by selecting those values from the filter list see example

Add the range name Filtered_Total for the Grand Total in the Sales Price column. The scope of the range name should be the workbook and not restricted to a worksheet.

Part 5 – Create Totals Worksheet

Caution – You must select the correction worksheet area before sorting. If you don’t then you will corrupt the data and end up with multiple subtotals in each category.

Copy the Revenue worksheet to a new tab and name it Totals

Change the tab color to Gold, Accent 4, Lighter 60%

Change the text in cell A1 to Totals

Change background fill color the cell A1 to Gold, Accent 4, Darker 25%

Delete the totals and adjacent text at the bottom of the data rows in the Totals worksheet so only the sales remain.

Using the Sort button on the ribbon, add a Custom Sort Sort the data by the Category Name in ascending order (A to Z)

Add a secondary sort on the Order Total in descending order (Largest to Smallest)

Add Subtotals for each change in Category Name with a sum of the Order Total and Sales PriceNote: You cannot add subtotals if you format your worksheet as a table!

Collapse the outlines to Hide Detail so that only the subtotals are displayed see example

Add the range name Grand_Total for the Grand Total of the Sales Price cell. The scope of the range name should be the workbook and not restricted to a worksheet.

Part 6 – Create a 3D Pie Chart

Create a 3D Pie Chart of the category names Beverages to Seafood and their associated Sales Price subtotals from the Totals worksheet

Move the chart to a new worksheetName the new worksheet Pie Chart

Change the chart style to Style 8 (if you are not using office 2019 on a PC then choose the closest matching chart type)

Add Percentages and Category Name as the only data labelsset them to display on the outside edge of the chart

Change the chart title 2021 SALES BY CATEGORY – see example

Change the name of the chart worksheet tab to Pie Chart if needed

Part 7 – Adding Summary Worksheet

Add a New Worksheet and named Summary

Change the Summary worksheet tab color to Dark Red (in the Standard Colors)

Enter the title  4 Summary in cell A1 and copy the format from cell A1 in the Revenue worksheet.

Enter text in the cells as indicated belowABCD1 2 Summary23WorksheetsValueMarkup %Range4Revenue5Analysis6Filtered7Totals

Bold the text in cells A3:D3, Center the text in cell B3

Indent the content of cells A4:A7

Add the formulas listed below to reference the named cells as follows:cell B4, formula = Revenue_Totalcell B5, formula = Analysis_Totalcell B6, formula = Filtered_Totalcell B7, formula = Grand_TotalFormat the values in column Busing the comma style format with 0 decimal placesadjust the column width so the values are correctly displayedInsert a 3D referencescell C4 to the Markup values from the Revenue worksheetcell C5 to the Markup values from the Analysis worksheetformat the values as percent with 0 decimal places.

Paste the range names starting in cell D4 using the Paste List command (under Use In Formula).

Adjust the column width so all text in column D is completely displayed

Create a hyper link to each worksheet from the text in cells A4:A7i.e. link the text in cell A4 (Revenue) to the Revenue worksheet and so on.Arrange the worksheet tabs in the following order from left to rightSummary, Revenue, Analysis, Filtered, Totals, Pie Chart – see example

Select the Revenue worksheet.

Save the file and exit Excel

Upload the file _Excel_Exam2.xlsxFiles can only be accepted to the class Drop Box using the  2 link

How is this assignment graded?

Follow instructions: naming worksheets, correct placement of discount percentage, headers, footers

Correct use of formulas: using cell references, functions including Sum and absolute references

Formatting worksheet: layout, margins, header/footer, style

Proper use of goal seeking to correct value. Is the Total Revenue in the Discount worksheet exactly $20,000 greater than the Total Revenue in the Revenue worksheet?

Create a chart as a worksheet from the sorted worksheet with subtotals.

Data is filtered and correctly sorted

Upload the saved file as _Excel_Exam2.xlsx as the  2 assignmentCaution – Be sure to remove all circular references from your file.If there is a circular reference you will receive a score of 0Resubmit – This assignment CAN be resubmitted 1 time to improve your score.

Grading RubricPointsRequirements22Revenue worksheet header/footer, document properties, formatting, formulas, freeze panes10Analysis worksheet Goal Seek, format table15Filtered worksheet Sorting, Subtotals, Filter9Totals worksheet Sorting, Subtotals, Outline9Pie Chart Move Chart, Set Style, Title, Data Labels12Summary worksheet Formulas with range names, Hyper links, Paste names, formatting3Worksheet tab color and order correct80

Total possible for uploading

_Exam2.xlsx _excel_exam2
Last Name Category Name Quantity Shipped Date Shipping Cost Unit Price
Long
Dairy Products
14
5/18/2020
Long
Dairy Products
20
5/18/2020
Matti
Produce
35
5/25/2020
Davolio
Grains/Cereals
Matti
Beverages
Matti
Confections
0.5
1.1
0.7
4
6/22/2020
0.83
45
5/22/2020
0.76
49
5/22/2020
12.5
55
23.25
33.25
19
0.7
17.45
Matti
Meat/Poultry
24
5/22/2020
1.86
123.79
Matti
Condiments
90
5/22/2020
0.86
28.5
43.9
Conner
Confections
50
6/5/2020
1.1
Conner
Meat/Poultry
10
5/15/2020
0.98
39
Conner
Confections
15
5/15/2020
0.78
31.23
Conner
Beverages
8
5/15/2020
0.72
Conner
Matti
18
Seafood
30
5/15/2020
0.48
Confections
40
5/29/2020
0.46
9.2
Matti
Condiments
35
5/29/2020
0.63
21.05
Matti
Dairy Products
2
5/29/2020
0.65
21.5
Matti
Confections
Matti
Seafood
Conner
Seafood
Callahan
Grains/Cereals
Conner
Confections
Callahan
Seafood
6
5/18/2020
0.78
31.23
20
5/18/2020
0.74
18.4
14
5/21/2020
0.78
6
6/20/2020
0.35
35
5/21/2020
1.23
20
6/2/2020
0.78
Callahan
Meat/Poultry
6
6/2/2020
0.37
Matti
Meat/Poultry
120
6/3/2020
0.72
Callahan
Grains/Cereals
Matti
Condiments
Matti
Condiments
Callahan
Produce
9.65
31
7
49.3
31
7.45
24
8
6/17/2020
0.83
33.25
28
6/3/2020
0.63
21.05
55
6/3/2020
0.52
15
5/20/2020
1.14
13
45.6
Callahan
Condiments
100
5/20/2020
0.78
19.45
Davolio
Confections
15
5/20/2020
0.51
12.75
0.6
15
Matti
Confections
20
5/19/2020
0.7
17.45
Matti
Davolio
Dairy Products
Beverages
20
25
5/19/2020
5/20/2020
0.25
2.5
Matti
Seafood
10
5/19/2020
0.48
Callahan
Beverages
20
5/25/2020
0.72
Callahan
Meat/Poultry
50
Callahan
Condiments
25
12
18
5/25/2020
0.82
32.8
5/25/2020
0.86
28.5
Callahan
Dairy Products
30
5/25/2020
0.65
21.5
Callahan
Confections
40
5/22/2020
0.4
10
Callahan
Confections
21
5/22/2020
0.6
Fuller
Dairy Products
36
5/25/2020
1.1
55
20
King
Confections
30
5/26/2020
0.78
31.23
King
Produce
30
5/26/2020
1.14
45.6
King
Beverages
20
5/26/2020
1.15
King
Grains/Cereals
10
6/3/2020
0.56
14
21.5
King
Dairy Products
50
5/26/2020
0.65
Matti
Produce
16
5/22/2020
0.75
Matti
Matti
46
30
Seafood
20
5/22/2020
0.48
12
Grains/Cereals
33
5/22/2020
0.14
34.8
Callahan
Confections
21
5/25/2020
0.5
12.5
Callahan
Beverages
4
5/25/2020
0.39
7.75
Davolio
Confections
40
5/27/2020
0.4
10
Davolio
Seafood
128
5/27/2020
0.78
25.89
Davolio
Meat/Poultry
160
5/27/2020
0.72
Fuller
Seafood
6/9/2020
0.3
Conner
10
6/29/2020
24
6
0.4
7
Confections
21
5/28/2020
0.46
9.2
Grains/Cereals
12
6/3/2020
0.43
Matti
Condiments
16
6/5/2020
0.66
22
Matti
Beverages
3
6/5/2020
1.15
46
Buchanan
Conner
Grains/Cereals
1
7
King
Grains/Cereals
14
6/29/2020
0.95
38
Matti
Dairy Products
20
6/5/2020
0.85
34
Davolio
Beverages
25
6/5/2020
0.45
4.5
Davolio
Meat/Poultry
18
6/5/2020
1.86
123.79
Davolio
Seafood
20
6/5/2020
0.74
Davolio
Seafood
30
6/5/2020
18.4
0.48
9.5
Davolio
Confections
25
6/5/2020
0.65
16.25
Matti
Dairy Products
10
6/4/2020
0.63
Matti
Seafood
Callahan
21
5
6/4/2020
0.48
Beverages
28
6/2/2020
0.45
Callahan
Confections
12
6/2/2020
0.56
14
Conner
Seafood
8
6/3/2020
0.78
25.89
12
4.5
Conner
Beverages
15
6/3/2020
1.15
Davolio
Beverages
40
6/5/2020
0.76
Davolio
Confections
35
6/5/2020
0.7
17.45
Davolio
Condiments
2
6/5/2020
0.78
19.45
62.5
46
19
Matti
Seafood
30
6/5/2020
1.25
King
Grains/Cereals
15
5/26/2020
0.95
38
19.5
Fuller
Grains/Cereals
15
6/27/2020
0.78
Fuller
Produce
30
6/9/2020
0.75
King
Grains/Cereals
16
5/20/2020
0.95
Callahan
Beverages
80
6/10/2020
0.45
Callahan
Produce
18
6/10/2020
1.06
30
38
4.5
53
Davolio
Dairy Products
12
6/12/2020
0.25
2.5
Davolio
Dairy Products
12
6/12/2020
0.65
21.5
Buchanan
Produce
12
6/12/2020
0.7
23.25
Buchanan
Produce
18
6/12/2020
1.14
45.6
Buchanan
Seafood
21
6/12/2020
0.74
18.4
Buchanan
Beverages
10
6/12/2020
0.39
7.75
Dodsworth Dairy Products
35
6/26/2020
0.5
12.5
Dodsworth Condiments
60
6/26/2020
0.68
17
Dodsworth Beverages
42
6/26/2020
0.72
2
6/15/2020
0.72
Callahan
Meat/Poultry
Callahan
Beverages
12
6/15/2020
0.6
Buchanan
Beverages
15
6/16/2020
0.72
Buchanan
Confections
21
6/16/2020
0.4
Buchanan
Beverages
20
6/16/2020
0.72
18
24
15
18
10
18
Fuller
Seafood
20
6/17/2020
0.78
31
Conner
Beverages
30
6/12/2020
3.95
263.5
32.8
Conner
Meat/Poultry
28
6/12/2020
0.82
Conner
Dairy Products
60
6/12/2020
1.1
55
Long
Grains/Cereals
18
6/3/2020
0.95
38
Long
Confections
30
6/15/2020
0.48
9.5
Long
Dairy Products
12
6/15/2020
1.1
Callahan
Confections
24
6/16/2020
0.6
Callahan
Dairy Products
40
6/16/2020
0.85
55
20
34
Conner
Confections
14
6/23/2020
0.4
10
Conner
Seafood
10
6/23/2020
0.74
18.4
Conner
Produce
Matti
Beverages
3
6/23/2020
1.06
53
20
6/22/2020
0.76
19
Matti
Condiments
20
6/22/2020
0.4
Matti
Meat/Poultry
30
6/22/2020
0.72
Matti
Beverages
60
6/22/2020
0.6
Davolio
Dairy Products
5
6/24/2020
0.63
Davolio
Produce
25
6/24/2020
1.06
Davolio
Produce
16
6/24/2020
0.4
10
24
15
21
53
10
Fuller
Confections
5
6/19/2020
0.46
9.2
Fuller
Confections
30
6/19/2020
0.78
31.23
7.45
Fuller
Meat/Poultry
24
6/19/2020
0.37
Callahan
Dairy Products
30
6/24/2020
1.1
Callahan
Seafood
20
6/24/2020
0.6
King
Dairy Products
60
6/25/2020
1.1
King
Confections
30
6/25/2020
King
Beverages
36
6/25/2020
55
15
55
0.5
12.5
0.39
7.75
King
Dairy Products
20
6/29/2020
0.5
12.5
Conner
Grains/Cereals
20
5/21/2020
0.42
7
34.8
King
Dairy Products
25
6/29/2020
0.87
King
Condiments
25
6/29/2020
0.52
Davolio
Seafood
10
8/3/2020
0.3
Davolio
Beverages
10
8/3/2020
0.72
Conner
Confections
39
6
18
81
Produce
35
8/6/2020
1.14
45.6
Grains/Cereals
20
6/9/2020
0.95
38
Conner
Condiments
39
Conner
Beverages
50
8/6/2020
13
1.22
Conner
Fuller
8/6/2020
0.63
21.05
8/6/2020
0.39
7.75
Matti
Beverages
40
7/27/2020
0.72
18
Matti
Condiments
24
7/27/2020
1
40
25.89
Matti
Seafood
20
7/27/2020
0.78
Matti
Seafood
25
7/27/2020
0.74
18.4
Davolio
Seafood
2
7/28/2020
0.78
31
Davolio
Seafood
10
7/28/2020
0.78
25.89
Davolio
Beverages
60
Davolio
Meat/Poultry
15
Matti
Beverages
Matti
Seafood
7/28/2020
1.15
46
7/28/2020
0.37
7.45
8
8/5/2020
0.72
10
8/5/2020
0.3
6
19.5
Davolio
Grains/Cereals
20
5/30/2020
0.78
King
Condiments
50
7/28/2020
0.66
King
Seafood
30
7/28/2020
0.76
Long
Dairy Products
3
7/30/2020
0.63
18
22
19
21
Long
Dairy Products
8
7/30/2020
0.25
2.5
Long
Dairy Products
9
7/30/2020
0.87
34.8
0.72
Buchanan
Meat/Poultry
14
7/30/2020
Buchanan
Confections
20
7/30/2020
0.5
Buchanan
Dairy Products
10
7/30/2020
0.9
Conner
Meat/Poultry
40
8/2/2020
0.98
Conner
Beverages
25
8/2/2020
1.15
Conner
Condiments
20
8/2/2020
0.86
Conner
Beverages
50
8/2/2020
0.72
King
Dairy Products
King
Seafood
24
12.5
36
39
46
28.5
18
2
8/9/2020
1.1
55
15
8/2/2020
0.78
25.89
King
Condiments
24
8/2/2020
0.68
Callahan
Condiments
50
8/12/2020
0.66
22
34.8
17
Callahan
Dairy Products
24
8/12/2020
0.87
Callahan
Seafood
24
8/12/2020
0.6
15
Callahan
Seafood
10
8/4/2020
0.78
25.89
Callahan
Seafood
10
8/4/2020
0.74
18.4
7.45
Callahan
Meat/Poultry
10
8/4/2020
0.37
Matti
Dairy Products
50
8/11/2020
0.63
21
18.4
Matti
Seafood
10
8/11/2020
0.74
Fuller
Grains/Cereals
21
6/9/2020
0.45
Matti
Dairy Products
15
8/11/2020
Davolio
Dairy Products
30
8/9/2020
1.1
0.5
9
55
12.5
Davolio
Produce
6
8/9/2020
1.06
53
Davolio
Seafood
20
8/9/2020
0.53
13.25
Davolio
Dairy Products
21
8/9/2020
0.87
34.8
Davolio
Seafood
9
8/9/2020
0.6
15
Dodsworth Beverages
Dodsworth Dairy Products
7
8/6/2020
0.6
1
8/6/2020
0.87
34.8
0.78
31.23
King
Confections
20
5/16/2020
King
Beverages
30
5/16/2020
0.72
King
Confections
42
5/16/2020
0.6
15
18
20
Matti
Confections
25
5/24/2020
0.46
9.2
Matti
Confections
21
5/24/2020
0.48
9.5
Matti
Confections
15
5/24/2020
0.6
Davolio
Seafood
70
5/23/2020
0.78
31
12.5
Davolio
Dairy Products
35
5/23/2020
0.5
Davolio
Condiments
40
5/23/2020
0.52
20
13
Davolio
Beverages
20
5/16/2020
0.76
19
Davolio
Confections
18
5/16/2020
0.5
12.5
Dodsworth Dairy Products
40
5/16/2020
0.63
21
Dodsworth Beverages
40
5/16/2020
3.95
263.5
4.5
Conner
Beverages
110
5/16/2020
0.45
Conner
Beverages
45
5/16/2020
0.72
18
18.4
Conner
Seafood
Conner
Dairy Products
91
5/16/2020
0.74
100
5/16/2020
0.85
34
9.5
King
Seafood
15
5/20/2020
0.48
Buchanan
Grains/Cereals
25
5/28/2020
0.56
14
Conner
Meat/Poultry
80
5/18/2020
1.86
123.79
Conner
Seafood
36
5/18/2020
0.78
25.89
Matti
Seafood
5
5/27/2020
0.3
Buchanan
Beverages
8
5/19/2020
0.72
Davolio
Beverages
Matti
Seafood
0.6
15
0.48
9.65
Matti
Dairy Products
30
5/19/2020
0.65
Meat/Poultry
30
5/24/2020
0.72
Confections
6
5/25/2020
5/19/2020
Davolio
Davolio
18
3
30
6
5/24/2020
1.23
21.5
24
49.3
Conner
Seafood
40
5/25/2020
0.3
6
Conner
Condiments
21
5/25/2020
0.63
21.05
Conner
Confections
20
5/25/2020
Conner
Seafood
15
5/20/2020
Conner
Confections
Dodsworth Beverages
0.5
12.5
0.53
13.25
35
5/20/2020
1.23
49.3
20
5/27/2020
0.72
18
Matti
Condiments
15
5/24/2020
0.86
28.5
Long
Beverages
14
5/20/2020
0.39
7.75
Matti
Produce
20
Conner
5/27/2020
0.75
5/26/2020
0.41
Davolio
Produce
12
5/31/2020
0.75
30
Davolio
Grains/Cereals
Confections
28
15
5/31/2020
30
38
0.7
17.45
5
5/31/2020
0.48
9.65
Confections
12
5/25/2020
0.46
Davolio
Confections
10
5/25/2020
0.6
20
Davolio
Condiments
5
5/25/2020
0.86
28.5
Davolio
Seafood
Davolio
Conner
Beverages
10
5/26/2020
0.72
Conner
Meat/Poultry
12
5/26/2020
0.98
Conner
Beverages
15
5/26/2020
0.56
Fuller
Dairy Products
40
6/8/2020
9.2
18
39
14
0.63
21
Fuller
Meat/Poultry
60
6/8/2020
1.86
123.79
Matti
Condiments
30
5/25/2020
0.66
22
Matti
Dairy Products
40
5/25/2020
0.25
2.5
Matti
Seafood
15
5/25/2020
0.53
13.25
0.65
21.5
Long
Dairy Products
25
5/23/2020
Fuller
Meat/Poultry
10
5/23/2020
0.98
39
Fuller
Dairy Products
30
5/23/2020
0.25
2.5
Fuller
Meat/Poultry
10
5/23/2020
0.37
7.45
Davolio
Confections
6
5/30/2020
0.7
17.45
Davolio
Dairy Products
6
5/30/2020
0.8
Conner
Grains/Cereals
29
8/6/2020
Matti
Seafood
Matti
Dairy Products
32
0.95
38
1
6/1/2020
0.78
25.89
10
6/1/2020
0.85
Conner
Beverages
60
6/1/2020
0.72
Conner
Dairy Products
25
6/1/2020
34
18
0.85
34
Fuller
Confections
24
5/25/2020
0.7
17.45
Fuller
Confections
24
5/25/2020
0.56
14
Fuller
Seafood
20
5/25/2020
0.74
18.4
Matti
Confections
24
5/30/2020
0.65
16.25
Davolio
Beverages
10
5/30/2020
0.72
18
Davolio
Condiments
40
5/30/2020
1.1
43.9
Buchanan
Meat/Poultry
15
5/26/2020
0.98
39
Buchanan
Beverages
35
5/26/2020
0.45
4.5
33.25
Conner
Grains/Cereals
30
6/12/2020
0.83
King
Beverages
10
6/3/2020
1.15
46
King
Beverages
24
6/3/2020
0.56
Conner
Seafood
20
6/29/2020
0.78
Conner
Produce
30
6/29/2020
1.14
45.6
Conner
Beverages
6
6/29/2020
0.39
7.75
Conner
14
25
0.76
19
Grains/Cereals
35
6/3/2020
0.1
33.25
Dairy Products
2
6/1/2020
0.63
Matti
Seafood
Matti
Confections
Matti
Dairy Products
Matti
Confections
6/3/2020
31
Seafood
Matti
Matti
21
10
6/1/2020
0.3
6
7
6/1/2020
0.46
9.2
34.8
10
6/1/2020
0.87
5
6/29/2020
1.22
81
Matti
Grains/Cereals
36
6/5/2020
0.11
Matti
Beverages
20
6/29/2020
0.72
18
38
Davolio
Confections
5
6/8/2020
0.48
9.5
Davolio
Beverages
5
6/8/2020
0.72
18
Long
Confections
60
Long
6/2/2020
0.4
6/2/2020
0.39
Long
Condiments
15
6/2/2020
0.52
Matti
Beverages
Confections
49
36
6/8/2020
Matti
Confections
25
Matti
Meat/Poultry
25
0.4
10
7.75
13
10
6/8/2020
1.1
6/8/2020
0.72
24
Matti
Seafood
30
6/8/2020
0.53
13.25
Matti
Seafood
42
6/9/2020
0.3
43.9
6
Matti
Grains/Cereals
45
6/5/2020
0.17
9
Callahan
Confections
30
6/14/2020
0.7
17.45
Callahan
Confections
14
6/14/2020
1.23
49.3
Callahan
Dairy Products
16
6/14/2020
0.87
34.8
Callahan
Beverages
20
6/14/2020
0.39
7.75
Long
Meat/Poultry
2
6/6/2020
0.82
32.8
Long
Condiments
30
6/6/2020
0.86
28.5
Conner
Condiments
20
6/2/2020
0.75
25
Matti
6/8/2020
0.72
4
6/8/2020
1.25
62.5
Grains/Cereals
48
6/5/2020
0
33.25
Conner
Seafood
30
King
Beverages
Produce
8
Matti
Seafood
Matti
21
18
6/8/2020
0.76
19
6/3/2020
1.14
45.6
King
Beverages
20
6/3/2020
0.56
Conner
Seafood
20
6/6/2020
0.3
14
6
Conner
Beverages
24
6/6/2020
1.15
Conner
Dairy Products
49
6/6/2020
0.85
34
46
Conner
Dairy Products
35
6/6/2020
0.65
21.5
Fuller
Beverages
10
6/3/2020
0.76
19
Fuller
Beverages
40
6/3/2020
0.56
14
Callahan
Produce
8
6/13/2020
0.75
30
Callahan
Seafood
20
6/13/2020
King
0.3
6
6/10/2020
0.5
12.5
King
Confections
30
6/10/2020
King
Confections
80
King
Dairy Products
Dairy Products
44
Dodsworth Confections
1.23
49.3
6/10/2020
0.5
12.5
50
6/10/2020
0.87
34.8
28
6/8/2020
0.6
20
Matti
Seafood
15
6/9/2020
0.3
6
Matti
Grains/Cereals
50
8/5/2020
0.17
38
Matti
Seafood
15
6/9/2020
0.48
Long
Dairy Products
5
6/3/2020
12
0.63
21
Long
Condiments
18
6/3/2020
0.78
19.45
Matti
Grains/Cereals
55
8/11/2020
0.25
19.5
0.3
6
Matti
Dairy Products
10
6/8/2020
0.5
12.5
Davolio
Matti
Seafood
Seafood
25
20
6/9/2020
6/8/2020
0.78
31
Davolio
Beverages
25
6/9/2020
0.45
Davolio
Condiments
40
6/9/2020
0.52
Conner
Dairy Products
Conner
Confections
Conner
Produce
Conner
Meat/Poultry
4.5
13
4
6/6/2020
1.1
55
9
6/9/2020
0.65
16.25
40
6/9/2020
1.06
53
4
6/9/2020
0.72
24
Fuller
Condiments
12
6/7/2020
0.75
Fuller
Seafood
30
6/7/2020
0.78
25
31
Fuller
Meat/Poultry
6
6/7/2020
0.98
39
Fuller
Confections
60
6/7/2020
1.23
49.3
Davolio
Condiments
Dodsworth Dairy Products
Dodsworth Seafood
5
6/13/2020
0.66
15
6/28/2020
0.25
22
2.5
6
6/28/2020
0.48
9.65
Dodsworth Beverages
50
6/28/2020
0.39
7.75
Davolio
Condiments
16
6/14/2020
0.75
25
Davolio
Produce
2
6/14/2020
1.14
45.6
Dodsworth Confections
50
6/15/2020
1.22
81
Dodsworth Dairy Products
50
6/15/2020
0.5
12.5
Buchanan
Confections
28
6/10/2020
Buchanan
0.7
17.45
0.5
12.5
Buchanan
Seafood
30
6/10/2020
0.48
9.5
Buchanan
Dairy Products
Dairy Products
25
24
6/10/2020
6/10/2020
0.85
34
Callahan
Beverages
12
6/10/2020
0.39
7.75
Long
Confections
12
6/10/2020
0.4
10
1
Long
Confections
Long
Produce
14
6/10/2020
0.48
8
6/10/2020
1.06
53
0.78
25.89
Callahan
Seafood
30
6/17/2020
Callahan
Beverages
40
6/17/2020
0.72
9.5
18
Matti
Grains/Cereals
64
5/27/2020
0.33
7
King
Condiments
20
6/17/2020
0.64
21.35
King
Produce
6
6/17/2020
0.75
30
King
Dairy Products
5
6/17/2020
0.87
34.8
Long
Beverages
20
6/13/2020
0.39
7.75
Conner
Beverages
10
6/29/2020
0.45
4.5
9.65
Conner
Seafood
24
6/29/2020
0.48
Matti
Grains/Cereals
75
6/29/2020
0.43
Callahan
Beverages
60
6/20/2020
0.72
Callahan
Produce
45
6/13/2020
0.75
7
18
30
Callahan
Seafood
77
6/13/2020
0.3
6
Callahan
Meat/Poultry
20
6/13/2020
0.82
32.8
Callahan
Dairy Products
Callahan
Beverages
Dodsworth Dairy Products
Conner
Seafood
9
6/13/2020
0.9
36
44
6/13/2020
0.72
18
2
6/16/2020
0.85
6
6/14/2020
1.25
62.5
6/14/2020
3.95
263.5
6/14/2020
0.9
36
Conner
Beverages
5
Conner
Dairy Products
10
Long
Produce
16
6/20/2020
1.06
Matti
Seafood
8
6/29/2020
0.78
Matti
Grains/Cereals
80
6/9/2020
34
53
26
0.55
19.5
Matti
Confections
12
6/29/2020
1.23
49.3
Fuller
Confections
12
6/23/2020
0.46
9.2
Fuller
Confections
40
6/23/2020
0.6
Davolio
Dairy Products
30
6/22/2020
20
0.95
38
Davolio
Beverages
30
6/22/2020
0.45
4.5
Matti
Grains/Cereals
88
6/8/2020
0.62
Davolio
Seafood
Fuller
Meat/Poultry
9
9
6/20/2020
0.48
12
14
6/23/2020
1.86
123.79
Matti
Meat/Poultry
6
6/16/2020
0.98
39
Matti
Dairy Products
7
6/16/2020
0.25
2.5
Long
Confections
5
6/17/2020
0.78
31.23
Long
Seafood
6
6/17/2020
0.48
9.65
0.39
7.75
1.1
43.9
Long
Beverages
10
6/17/2020
Conner
Condiments
10
6/24/2020
Davolio
Condiments
16
6/17/2020
Davolio
1
40
0.39
7.75
Davolio
Produce
20
6/24/2020
1.14
45.6
Callahan
Beverages
Produce
10
18
6/17/2020
6/21/2020
0.75
Callahan
Dairy Products
20
6/21/2020
0.95
Callahan
Beverages
80
6/21/2020
0.45
30
38
4.5
Callahan
Confections
30
6/21/2020
1.1
43.9
Callahan
Dairy Products
24
6/21/2020
0.5
12.5
Callahan
Condiments
35
6/21/2020
1.1
43.9
Davolio
Beverages
60
6/23/2020
3.95
263.5
Fuller
Produce
Fuller
Beverages
Fuller
Seafood
6/29/2020
0.75
9
6/29/2020
1.15
84
20
6/27/2020
0.3
0.01
21
0.7
17.45
Matti
Grains/Cereals
91
6/9/2020
Davolio
Confections
55
6/24/2020
Davolio
Davolio
30
46
6
Beverages
20
6/24/2020
0.45
Seafood
40
6/24/2020
0.76
19
Fuller
Confections
36
6/23/2020
0.7
17.45
Fuller
Seafood
8
6/23/2020
1.25
62.5
Fuller
Dairy Products
35
6/23/2020
0.8
Callahan
Produce
60
6/27/2020
0.75
Callahan
Beverages
Callahan
Dairy Products
1.15
46
0.87
34.8
40
15
Seafood
Confections
32
6/27/2020
6/27/2020
Condiments
Dairy Products
Fuller
30
6
20
Fuller
Fuller
Fuller
4.5
6/23/2020
0.75
6/23/2020
0.63
21
4
6/23/2020
0.48
9.65
65
6/28/2020
0.4
25
10
Fuller
Beverages
60
6/28/2020
0.56
Fuller
Meat/Poultry
65
6/28/2020
0.72
24
28.5
Fuller
Condiments
66
6/28/2020
0.86
Davolio
Beverages
50
6/28/2020
0.76
14
19
Davolio
Beverages
20
6/28/2020
0.6
Davolio
Beverages
90
6/28/2020
0.72
18
34.8
Davolio
Dairy Products
Davolio
Produce
Davolio
Dairy Products
Conner
Beverages
Conner
Seafood
2
6/24/2020
0.87
20
6/27/2020
1.06
4
6/27/2020
0.85
15
53
34
4
6/29/2020
0.72
18
10
6/29/2020
0.74
18.4
Matti
Grains/Cereals
92
6/29/2020
0.21
Conner
Beverages
30
7/26/2020
0.56
38
14
Conner
Seafood
40
7/26/2020
0.74
18.4
Conner
Seafood
30
7/26/2020
0.48
9.65
Davolio
Beverages
20
7/26/2020
0.72
18
2