Analysis and Design of Proposed Accounting System

Only available on StudyMode
  • Download(s): 122
  • Published: September 12, 2012
Open Document
Text Preview
Submitted by:

Camero, Chana Paulene A.
Hinoguin, Vanessa Bea P.
Pagente, LJ Faith B.
Suasin, James P.

Submitted to :

Miss Marianne Sy, Instructor

CISB 32 -B

Submitted by:

Camero, Chana Paulene A.
Hinoguin, Vanessa Bea P.
Pagente, LJ Faith B.
Suasin, James P.

Submitted to :

Miss Marianne Sy, Instructor

CISB 32 -B

SYSTEMS ANALYSIS AND DESIGN
Accounting System Proposal
SYSTEMS ANALYSIS AND DESIGN
Accounting System Proposal

SYSTEMS ANALYSIS AND DESIGN:
ACCOUNTING SYSTEM PROPOSAL
Four Queens Resort

History/Nature of the Business
Four Queens Resort is a 1,700 sq meter hotel and resort located at National Highway, Tuburan District, Pagadian City, Zamboanga del Sur. The said resort is another business venture of Engr. Jocelyn P. Hinoguin who owns a few other businesses such as Cashlink Financials. 

The hotel was named after the owner and her three daughters: Princess, Vanessa and Joyce, thus, Four Queens. According to the owner, the original plan was that of putting up a commercial building to be leased to regional offices of different establishments. But she thought of launching something more profitable. Though there are many hotels in Pagadian, there were only a few that also had a resort in it, thus, she decided to put up the hotel and resort instead.

There had already been a two-storey building where Four Queens Resort stands today and so the owner decided to have it renovated. Renovations and the construction of other facilities, which started in 2008, were completed in 2011 and Four Queens Resort opened its doors to guests and customers in October 2011. Statement of the Problem

The current accounting system of the business is that of a manual one. Further, the business has practices that do not necessarily conform to generally accepted accounting principles. For example: erroneously charging to expenses inventory purchases. Such practices can conceal the true profit of the business and can also affect the different decisions the business makes or should make. This project aims to develop a computerized accounting system, with generally accepted accounting principles as basis, to help the business produce timely and relevant reports that shall aid management in making decisions. Scope and Limitations

Scope: Proposed plan for a computerized accounting system of a hotel/restaurant, Four Queens Resort. > It shows the flow of data provided by the usual transactions the business/firm is engaged in such as sales and expenses (purchases). With the aid of special journals, such usual transactions are also recorded in the system whether they are paid in cash or accrued. >The recorded data are thus recorded in the ledger which summarizes all accounts affected in the different journals. An “account balances” tab is provided in the user interface to display the balances of the different accounts of the firm for viewing purposes/reference. The ultimate goal of this system is to produce financial statements that shall present the financial performance and financial position of the firm which are to be used by the different stakeholders in making sound decisions. Limitations:

The proposed system does not go into the most intricate details of depreciation of assets. The system reserves the right of depreciating assets to the firm and such may be recorded in “Other Transactions” in this system. Furthermore, it does not deal with the firm’s provision for bad debts and if it were to write off receivables, such may be done again in “Other Transactions”.

Context DFD of the current system

Top level DFD of the Current System

CONTEXT DIAGRAM OF PROPOSED SYSTEM

DFD for Proposed System

Entity Relations Diagram of PROPOSED SYSTEM

NORMALIZATION WITH SAMPLE TUPLES
CUSTOMER
Customer_ID| Fname| Lname| Contact_no.|
00804| Chana| Pagente| 09058950061|
01004| Vanessa| Suasin| 09167051181|

SERVICE
Service_type|
Banquet...
tracking img