Database Systems Part 2 Assignment - Spring 2011

Database Systems Part 2 Assignment - Spring 2011 - BUSMIS...

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 Background Upon graduation, a firm hired you 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 including some 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). Descriptions of Data Files Understanding what type of data you are dealing with before starting can save time and improve your analysis. These tables describe the data files you have. Vendor List File type: Text (.txt) Format: Tab Delimited, Field names included in first row Field Name Type Description VendorNumber Number Unique identifier for each vendor VendorName Text Vendor company name Item Numbers and Description File type: Excel Workbook (.xls) Format: Field names included in first row Field Name Type Description ItemNumber Number Part number (This number is different for each vendor that the item is ordered from – so the same item can have multiple item numbers)
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.

Page1 / 4

Database Systems Part 2 Assignment - Spring 2011 - BUSMIS...

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