bmis 441 bluth company financial analysis database system
Download
Skip this Video
Download Presentation
BMIS 441 Bluth Company Financial Analysis Database System

Loading in 2 Seconds...

play fullscreen
1 / 16

BMIS 441 Bluth Company Financial Analysis Database System - PowerPoint PPT Presentation


  • 92 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' BMIS 441 Bluth Company Financial Analysis Database System' - hien


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
bmis 441 bluth company financial analysis database system
BMIS 441Bluth Company Financial AnalysisDatabase System

BMIS441 FALL 2012

Group # 3

Sahan Fernando

David French

Will McCahill

Michael Morgan

goals for bluth database
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
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

slide4

E

R

M

O

D

E

L

slide5

BLUTH

Currency

Current_Assets

Long_Term_Assets

Current_Liabilities

Long_Term_Liabilities

Stockholders_Equity

slide6

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
Order of Data Entry
  • Bluth
  • Currency
  • Current_Assets
  • Long_Term_Assets
  • Current_Liabilities
  • Long_Term_Liabilities
  • Stockholders_Equity

BMIS 441

objectives of bluth database
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
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
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
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
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
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
queries1
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
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
ad