Ess10ch02_solutiondescription - Chapter 2 Hands-on MIS...

This preview shows page 1 out of 1 page.

Chapter 2 Hands-on MIS Application Software Exercise Solution This exercise requires some student knowledge of spreadsheet database functions. At a minimum, students should know how to sort the database by various criteria such as item description, item cost, vendor number, vendor, name, or A/P terms. Students may need to be told that A/P 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. Students 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 Date.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture