160 likes | 276 Views
BMIS 441 Bluth Company Financial Analysis Database System. BMIS441 FALL 2012 Group # 3 Sahan Fernando David French Will McCahill Michael Morgan. Goals for Bluth Database. Public Company Need for accurate financial data Foreign currency issues with multiple subsidiaries
E N D
BMIS 441Bluth Company Financial AnalysisDatabase System BMIS441 FALL 2012 Group # 3 Sahan Fernando David French Will McCahill Michael Morgan
Goals for Bluth Database • Public Company Need for accurate financial data • Foreign currency issues with multiple subsidiaries • Database to help with summarizing financial items • Summarize whole company and individual subsidiaries • Specifically, assets, liabilities, and stockholders equity • Data will help in preparation of Financial Statements issued to public BMIS 441
Design of Bluth Database • Track currency and division level data • Convert each division data into currency of parent company • Primary users of information will be corporate managers and strategists • Design is as follows: BMIS 441
E R M O D E L
BLUTH Currency Current_Assets Long_Term_Assets Current_Liabilities Long_Term_Liabilities Stockholders_Equity
BLUTH Currency Current_Assets Long_Term_Assets Explain/illustrate: 1. Functional dependency, 2. Normalization process with 3NF Current_Liabilities Long_Term_Liabilities Stockholders_Equity
Order of Data Entry • Bluth • Currency • Current_Assets • Long_Term_Assets • Current_Liabilities • Long_Term_Liabilities • Stockholders_Equity BMIS 441
Objectives of Bluth Database • Provide easy access of division balance sheets to managers • Accurate quarterly data to company stockholders • Keep record of division performance by quarter • Allow management to observe financial performance of each division • Generate financial statements for Bluth company as a whole BMIS 441
SDLC of Bluth Database • Create models of database based on divisional needs • Perform trial runs of database • Check to make sure all relevant data is included • Create queries to help management easily retrieve important company data • Update database with new currency and quarterly data
Implementation of Database • Set up database within a test environment • Database will have same tables and sample data • Put database on web for trial run by managers • Managers will enter most recent quarterly data • Use current exchange rate and sample queries to test usability of database • Create queries for specific management needs • Allow managers to use database for 6 weeks
Implementation Cont. • Management feedback after 6 weeks • Alter database and queries based on management’s feedback • Roll out full system, train foreign managers, and begin use of database • Set up time tables to ensure timely entering of quarterly data
Maintenance of Bluth Database • Division level managers primary modifiers • Insert quarter-end data and new currency rates • Host database on-site with off-site backup • Backup database after each quarter-end data and currency rates entered • Minimum of 15 yearsbacked up • Anti-Fraud queries
Queries • Asset and Liability check against Stockholder’s Equity for fraud • Broken out by division • Calculate total assets of company in USD • Removes currency differences • Calculate total liabilities of company in USD • Removes currency differences • Calculate current ratio of company • Determine liquidity of company
Queries • Calculate division percentage of assets, liabilities, and stockholders equity • Create view and allows managers to insert values into the view • Create Sequence to enforce integrity of data
Analysis of Bluth Database • Database is mandatory for effective management decisions • Helps eliminate currency boundaries • Quicker processing of quarterly data • More accurate quarterly and year-end financial statements • Better understanding of overall health of company • More timely and better informed decisions by management