SQL Kudler's Accounting Dept Service Request

 

Service Request SR-kf-009

SQL Accounting Database

Organization: Kudler Fine Foods

Locations: All

Requester: Harvey Stephens

Description of Request:

Design an SQL database that contains the fields found in the company's
Chart of Accounts. Add a balance field to the database. Create a query
that will display all of the fields of the database and run a report
totaling the balance field using test data added to the database.

Background of Request:

Kudler's Chart of Accounts currently exists as a Microsoft Excel
spreadsheet. In anticipation of new reports that management will be
requesting, we want to move the Chart of Accounts from the current
spreadsheet to a SQL database. We want to create the database in order
to facilitate decision making at the store and department levels.

Expected Results/Impact when completed:

An SQL database containing the fields in the current Chart of Accounts,
plus a "balance" field.

An SQL query that will display all of the database fields.

A test of the database by means of a query by account number and a
report totaling the balance field test data entered by the database
design team. The query will display all fields (description, short
description, and balance) using the account number as the key to the
query. The report will display all fields with a break based on the
first two digits of the account number and subtotal of the balance field
at each break. A grand total of the balance field will be provided at
the end of the report. The database design team will load sufficient
entries into the balance field to prove their total routine is working -
test balance entries are not necessary for all account numbers.

Finance & Accounting



 

 



 



 



 



 



 



 

 

HYPERLINK
"https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Kudler/Financ
e/KudlerFinance001A.htm" Balance Sheet

 

HYPERLINK
"https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Kudler/Financ
e/KudlerFinance002A.htm" Income Statement

 

HYPERLINK
"https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Kudler/Financ
e/KudlerBudget001.htm" Budgets

 

HYPERLINK
"https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Kudler/Financ
e/KudlerFinanceOver001.htm" Accounting System Overview

 

HYPERLINK
"https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Kudler/Financ
e/KudlerFinanceProcBank001.htm" Procedures

 

HYPERLINK
"https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Kudler/Financ
e/KudlerFinanceCOA001.htm" Chart of Accounts

 



 

Kudler Fine Foods

Balance Sheet

December 31, 2003

Assets

Current Assets:

 

Cash

Accounts Receivable

   Less: Reserve for Bad Debts

Merchandise Inventory

Prepaid Expenses

Notes Receivable

 

$86,000

      $0

$1,430,000

 

$86,000

$429,000

$26,000

          $0

 

 

Total Current Assets

 

 

$1,971,000

Fixed Assets:

 

Vehicles

   Less: Accumulated Depreciation

 

Furniture and Fixtures

   Less: Accumulated Depreciation

 

Equipment

   Less: Accumulated Depreciation

$63,000

 $27,750

 

$435,000

 $186,000

 

$634,000

 $214,000

 

$35,250

 

 

$249,000

 

 

$420,000

 

 

Total Fixed Assets

 

 

$704,250

Other Assets:

 

Goodwill

 

          $0

 

 

Total Other Assets

 

 

          $0

TOTAL ASSETS

$2,675,250

Liabilities and Capital

Current Liabilities:

 

Accounts Payable

Sales Tax Payable

Payroll Taxes Payable

Accrued Wages Payable

Unearned Revenues

Short-Term Notes Payable

Short-Term Bank Loan Payable

 

$96,500

$3,950

$15,840

$0

$0

$0

          $0

 

 

Total Current Liabilities

 

 

$116,290

Long-Term Liabilities:

 

Long-Term Notes Payable

 

$630,000

 

 

Total Long-Term Liabilities

 

 

 $630,000

TOTAL LIABILITIES

$746,290

Capital:

 

Owner's Equity

Net Profit

 

$746,290

 $1,182,670

 

TOTAL CAPITAL

 $1,928,960

TOTAL LIABILITIES AND CAPITAL

$2,675,250