Database Systems Part 2 Assignment (Fall09)

Database Systems Part 2 Assignment (Fall09) - BUSMIS 1060...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
BUSMIS 1060 – I NTRODUCTION TO I NFORMATION S YSTEMS Database Systems Assignment Part 2 - Data Analysis and Reporting Upon graduation, you were hired by a firm as a financial analyst. The company has a subsidiary that manufactures specialty components for automobiles. Due to increased competitive pressures from low cost competitors, financial performance of this subsidiary has been declining. While one possibility is to sell the subsidiary, top management prefers not to do this. The CFO (your boss) believes that the business unit may be able to increase its profitability by managing its supply chain better and would like you to look into the issue. In particular, there are three different ways that the subsidiary’s supply chain could be managed better to increase profitability: Select cheaper vendors to decrease the unit cost for items Select vendors that have fewer late shipments to reduce the need to stock costly ‘back-up’ inventory Select vendors with higher, more favorable Accounts Payable (A/P) terms so that the subsidiary can pay later (and, hence, retain use of the cash for longer) However, these things are not mutually exclusive – the vendor that is best in one of these three areas may be weaker in another area. Data is available which can help you compare and contrast the vendors. It is important to use the available data to analyze the situation and justify your recommendations. The available data includes a vendor list, items bought from the vendors, and a recent history of parts ordered. However, as is the case in many organizations, this information is maintained in different systems. The IS staff has provided you with the data, but it is in different formats: some of it is in a text file (Vendor List.txt), some in an Excel spreadsheet (Item Numbers and Description.xls), and the rest in a table in an Access database (Orders.mdb). Refer to Appendix A to learn more about the data you have been given. Use Microsoft Access to integrate the three data files and develop queries and reports that provide information about how the supply chain can be improved. The questions below will walk you through the queries and reports that you should create. Import the files into an Access database and connect them with appropriate relationships. Keep in mind:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/15/2009 for the course BUSMIS 1060 taught by Professor Robbins during the Fall '09 term at Pittsburgh.

Page1 / 5

Database Systems Part 2 Assignment (Fall09) - BUSMIS 1060...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online