Part 1 – Create your file and Import your data

  1. Start Excel creating a new Blank workbook using Excel 2016 or 2019
    • Save the file with the Name _Excel_Exam2
    • Files created in older versions of Excel may not earn full credit!
  2. Enter the appropriate Excel header and footer elements in the locations below. The only part you should type is your name. Header / Footer
  3. 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. files  – Click once
  4. Import the data file that you downloaded and add 2 rows
    • The 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.
    • File Import
  5. Add 3 document properties via the Document Properties panel.
    • Author:
    • Title:  2 Spring 2021
    • Comments: location where you completed the  i.e Home System, Work Computer
  6. Save 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).

  1. 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.
  2. Add the title your last name Revenue in cell A1. (e.g. Revenue).
  3. Change the title font size in cell A1 to 18 points.
  4. Calculate Order Total in column G for all 416 items. The Order Total is the Quantity times the Unit Price.
  5. 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.
  6. Merge and Center the title in cell A1 across only the data columns of the worksheet.
  7. Add like breaks between words in all column titles with 2 words by using a line break. Do not use wrap lines.
  8. 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)
  9. Bold all column headings in row 3.
  10. Align all the column titles vertically at the top and horizontally centered.
  11. 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.
  12. Change the background color of cells A3:H3 to Green, Accent 6 Lighter 60%. Formatted rows 1-3
  13. Rename the worksheet tab to Revenue.
  14. Change the tab color to Green, Accent 6, Lighter 60%.
  15. Freeze panes
    • Column A and Rows 1-3 should remain visible when you scroll either horizontally or vertically
  16. 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.
  17. 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.
  18. 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.
  19. Format as follows:
    • columns, Unit Price, Shipping – set as comma style
    • columns Order Total, Sales Price – set as comma style with 0 decimal places
    • column D – Short Date
    • cell H2 – Percent
  20. Change the worksheet view to the Normal view (if needed).
  21. 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.

  1. Copy the Revenue worksheet to a new tab changing tab name to Analysis
  2. Change the tab color to Orange, Accent 2, Lighter 60%
  3. Change the text in cell A1 to Analysis
  4. Change background fill color the cell A1 to Orange Accent 2, Darker 25%
  5. 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.
  6. 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.
  7. 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. …”
  8. Change the fill color for the column headings in row 3 to match row 1. – see example Fill Color

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.

  1. Copy the Revenue worksheet to a new tab and name it Filtered
  2. Change the tab color to Blue, Accent 1, Lighter 60%
  3. Change the text in cell A1 to Filtered
  4. Change background fill color the cell A1 to Blue, Accent 1, Darker 25%
  5. Delete the totals and adjacent text at the bottom of the data rows in the Filtered worksheet so only the sales remain.
  6. Add a filters for the column headings in row 3 of the Filtered worksheet.
  7. Using the Sort button on the ribbon, add a Custom Sort Sort the data by the Category Name in ascending order (A to Z)
  8. Add a secondary sort on the Quantity in ascending order (Smallest to Largest)
  9. Add Subtotals for Order Total and Sales Price with each change in Category Name and include Summary below the data
  10. Change the filter to only show the Meat/Poultry Category and Meat/Poultry Total by selecting those values from the filter list see exampleFiltered Worksheet
  11. 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.

  1. Copy the Revenue worksheet to a new tab and name it Totals
  2. Change the tab color to Gold, Accent 4, Lighter 60%
  3. Change the text in cell A1 to Totals
  4. Change background fill color the cell A1 to Gold, Accent 4, Darker 25%
  5. Delete the totals and adjacent text at the bottom of the data rows in the Totals worksheet so only the sales remain.
  6. Using the Sort button on the ribbon, add a Custom Sort Sort the data by the Category Name in ascending order (A to Z)
  7. Add a secondary sort on the Order Total in descending order (Largest to Smallest)
  8. Add Subtotals for each change in Category Name with a sum of the Order Total and Sales Price
    • Note: You cannot add subtotals if you format your worksheet as a table!
  9. Collapse the outlines to Hide Detail so that only the subtotals are displayed see exampleCollapse Outline
  10. 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

  1. Create a 3D Pie Chart of the category names Beverages to Seafood and their associated Sales Price subtotals from the Totals worksheet
  2. Move the chart to a new worksheet
    • Name the new worksheet Pie Chart
  3. Change the chart style to Style 8 (if you are not using office 2019 on a PC then choose the closest matching chart type)
  4. Add Percentages and Category Name as the only data labels
    • set them to display on the outside edge of the chart
  5. Change the chart title 2021 SALES BY CATEGORY – see exampleChart
  6. Change the name of the chart worksheet tab to Pie Chart if needed

Part 7 – Adding Summary Worksheet

  1. Add a New Worksheet and named Summary
  2. Change the Summary worksheet tab color to Dark Red (in the Standard Colors)
  3. Enter the title  4 Summary in cell A1 and copy the format from cell A1 in the Revenue worksheet.
  4. Enter text in the cells as indicated belowABCD1 2 Summary23WorksheetsValueMarkup %Range4Revenue5Analysis6Filtered7Totals
  5. Bold the text in cells A3:D3, Center the text in cell B3
  6. Indent the content of cells A4:A7
  7. Add the formulas listed below to reference the named cells as follows:
    • cell B4, formula = Revenue_Total
    • cell B5, formula = Analysis_Total
    • cell B6, formula = Filtered_Total
    • cell B7, formula = Grand_Total
  8. Format the values in column B
    • using the comma style format with 0 decimal places
    • adjust the column width so the values are correctly displayed
  9. Insert a 3D references
    • cell C4 to the Markup values from the Revenue worksheet
    • cell C5 to the Markup values from the Analysis worksheet
    • format the values as percent with 0 decimal places.
  10. Paste the range names starting in cell D4 using the Paste List command (under Use In Formula).
  11. Adjust the column width so all text in column D is completely displayed
  12. Create a hyper link to each worksheet from the text in cells A4:A7
    • i.e. link the text in cell A4 (Revenue) to the Revenue worksheet and so on.
  13. Arrange the worksheet tabs in the following order from left to rightWorksheet Tab Example
    • Summary, Revenue, Analysis, Filtered, Totals, Pie Chart – see example
  14. Select the Revenue worksheet.
  15. Save the file and exit Excel
  16. Upload the file _Excel_Exam2.xlsx
    • Files 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 assignment
Caution – Be sure to remove all circular references from your file.
If there is a circular reference you will receive a score of 0
Resubmit – 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.xlsx1 attachmentsSlide 1 of 1

  • attachment_1attachment_1

UNFORMATTED ATTACHMENT PREVIEW

_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

Do you similar assignment and would want someone to complete it for you? Click on the ORDER NOW option to get instant services at essayloop.com

Do you have a similar assignment and would want someone to complete it for you? Click on the ORDER NOW option to get instant services at essayloop.com. We assure you of a well written and plagiarism free papers delivered within your specified deadline.