Read full document

Us Steel

By | July 2013
Page 1 of 12
68

Part I

ORGANIZATIONS, MANAGEMENT, AND THE NETWORKED ENTERPRlSE

ApPLICATION SOFTWARE EXERCISE
SPREADSHEET EXERCISE: IMPROVING SUPPLY CHAIN MANAGEMENT You run a company that manufactures aircraft components. You have many competitors who are trying ro offer lower prices and better service ro cus"romers and you are trying ro determine if you can benefit from better supply chain management. At the Laudon Web site for Chapter 2 you can find a spreadsheet file that contains a list of all of the items that your firm has ordered from its suppliers over the past three months. The fields on the spreadsheet file include vendor name, vendor identification number, the purchaser's order number, item identification num­ ber and item description (for each item ordered from the ven­ dor), the cost per item, number of units of the item ordered, the rotal cost of each order, the vendors' accounts payable terms, promised shipping date, promised transit time, and actual arrival date for each order. Prepare a recommendation of how you can use the data in this spreadsheet database to improve your supply chain manage­ ment. You may wish ro look at ways ro identify preferred suppli­ ers or other ways of improving the movement and production of your products. Some criteria you might consider include the supplier's track record for on-time deliveries, suppliers offering the best accounts payable terms, and suppliers offering lower pricing when the same item can be provided by multiple suppli­ ers. Use your spreadsheet software ro prepare reports and, if appropriate, graphs ro s~pport your recommendations.

GROUP PROJECT

With a group of three or four other students, select a business using an industrial network for supply chain management. Use the Web, newspapers, journals, and computer or business maga­ zines ro find out more about that organization and its use of

information technology and links ro other organizations. If pos­ sible, use presentation software ro...
Hide

Rate this document

What do you think about the quality of this document?

Share this document

Let your classmates know about this document and more at Studymode.com