Bmis 441 bluth company financial analysis database system
Download
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


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
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