Project #8769 - Using a Spread Sheet to Analyze Supplier Performance and Pricing

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.

Subject Business
Due By (Pacific Time) 07/09/2013 07:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy