Bmis 441 bluth company financial analysis database system
This presentation is the property of its rightful owner.
Sponsored Links
1 / 16

BMIS 441 Bluth Company Financial Analysis Database System PowerPoint PPT Presentation


  • 64 Views
  • Uploaded on
  • Presentation posted in: General

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

Download Presentation

BMIS 441 Bluth Company Financial Analysis Database System

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


Bmis 441 bluth company financial analysis database system

E

R

M

O

D

E

L


Bmis 441 bluth company financial analysis database system

BLUTH

Currency

Current_Assets

Long_Term_Assets

Current_Liabilities

Long_Term_Liabilities

Stockholders_Equity


Bmis 441 bluth company financial analysis database system

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


Questions

Questions?


  • Login