Chapter #02 description file.doc - Chapter 2 Hands-on MIS...

Chapter 2 Hands-on MIS Application Software Exercise
This exercise requires some knowledge of spreadsheet database functions. At a
minimum, you should know how to sort the database by various criteria such as item
description, item cost, vendor number, vendor, name, or A/P terms. A/P (Account
Payable) Terms is expressed as the number of days that the customer has to pay the
vendor for a purchase. In other words, 30 designates net 30 days. The vendor that allows
customers the longest amount of time to pay for an order would, of course, offer the most
favorable payment terms.
You will need to add additional columns for calculating the delivery time for each
order. The delivery time can be calculated by subtracting the Order Date from the Arrival