Dear students,

My expectation on your Business Software Assignment#$1$ are listed below:

for Q$1-$Identify the Suppliers who provide On$-$Time Delivery

a Pivot table named as On$-$Time Delivery in which contains Vendor Names and Average Delivery Days and is sorted ascending by Average Delivery Time. $($Hint: you must find out the "delivery days" from the data provided before creating the pivot table to solve this problem$)$

Identify the best supplier who provides on$-$time delivery.

for Q$2-$ Identify suppliers who provide The Best Accounts Payable Terms

a Pivot table named as Accts$-$Payable$-$Terms in which contains Vendor Names and Maximum A$/$P Terms and is sorted descending by Maximum A$/$P Terms.

Identify the best supplier who provides the best Accounts Payable Terms.

for Q$3-$ Identify suppliers who offer lower pricing items when the same item can be provided by multiple suppliers

a Pivot table named as Low$-$Pricing$-$Items in which contains Item description$($column label$),$ Vendor Names $($row lable$)$ and Minimum Item Cost.

For each item, identify the supplier who provides the lowest price for the item.

The above Objects of your answers for Q$1-$Q$3$ should be included in your Business Software Assignment $1$ EXCEL file. Your answer for Q$4-$ a summary of Q$1-3--$can be posted on a separate worksheet of the same EXCEL file of Q$1-3.$

C$.$ P$.$ Wang, Ph$.$ D$.$

Professor