Data Field Description

$1.$ PONo Uniquely assigned purchase order number

$2.$ VendorID Uniquely assigned vendor number

$3.$ VendorName Vendor name

$4.$ VendorQuality Quality rating ranging from $1-6$ where $1=$ poor and $6=$ exceptional

$5.$ VendorAddress U$.$S postal mailing address and street name

$6.$ VendorCity Mailing address city

$7.$ VendorState Mailing address state

$8.$ VendorZip Mailing address zip

$9.$ VendorPayterms Payment terms negotiated with the vendor

$10.$ PODate Purchase order date

$11.$ POItemID Uniquely identifiable item number

$12.$ POItemDescription Description of item

$13.$ ItemCost Cost of the inventory item per negotiated terms with vendor

$14.$ ItemQty Total quantity of items purchased

For each of the following objectives $($a$,$ b$,$ c$),$ identify the minimum data fields $(1-14)$ you would select for your data strategy:

Your objective is to reduce the carbon footprint of your purchases, so you want to identify which vendor transported your purchases across the most miles last year.

Your objective is to determine which inventory items have the greatest cost increases over the past five years.

Your objective is to identify the five vendors from whom you made the highest value of purchases last year.