2-18
1. Don’s Lumber Company: The price of lumber and other building materials are
constantly changing. When a customer inquiries about the price on pre-finished wood
flooring, sales representatives consult a manual price sheet and then call the supplier
for the most recent price. The supplier in turn uses a manual price sheet, which has
2. Henry’s Hardware: Owners do not keep automated, detailed inventory or sales
records. Invoices are not maintained or tracked (other than for tax purposes). The
owners use their own judgment in identifying items that need to be reordered. What is
the business impact of this situation? How could information systems help Henry and
Kathleen run their business? What data should these systems capture? What decisions
could the systems improve?
The business impact includes lost sales, over- and under-ordering products, improper
Improving Decision Making: Using a Spreadsheet to Select Suppliers
Software skills: Spreadsheet date functions, data filtering, DAVERAGE functions.
Business skills: Analyzing supplier performance and pricing.
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