You run a company that manufactures aircraft components. You have many competitors who are trying to offer lower prices and better service to customers, and you are trying to determine whether you can benefit from better supply chain management. The attached spreadsheet file contains a list of all of the items that your firm has ordered from its suppliers during the past three months. The fields in the spreadsheet file include vendor name, vendor identification number, purchaser’s order number, item identification number and item description (for each item ordered from the vendor), cost per item, number of units of the item ordered (quantity), total cost of each order, vendor’s accounts payable (A/P) terms, order data, and actual arrival date for each order. Prepare a recommendation of how you can use the data in this spreadsheet database to improve your decisions about selecting suppliers. Use Microsoft Excel to create tables to support your recommendation based on the following criteria:
- The suppliers delivering on-time.
- The suppliers offering the best accounts payable terms.
- The suppliers offering lower pricing when the same item can be provided by multiple suppliers.
This exercise requires you to use spreadsheet functions and formulas. At a minimum, you should know how to sort the database by various criteria. The A/P Terms is expressed as the number of days that you have to pay the vendor for a purchase. The vendor that allows customers the longest amount of time to pay for an order would, of course, offer the most favorable payment. You may need to add additional columns for calculating the actual delivery time for each order and the number of days the delivery is late. These numbers are useful when determining who is the vendor with the best on-time delivery track record.
|Due By (Pacific Time)
||07/09/2013 07:00 pm