e-mail address__________________________________________
1. (50 points) TO BE RETURNED BY 5:30 PM MON DEC 7 TO 280E MH
1.1 Run your glrestor program on your database to restore it to its original status. On all the add/modify/delete's and journal vouchers below, write the outcome of the transaction (i.e., "ok" or "failed") with an explanation of why -- if it failed.
1.2 Delete the following accounts from the general ledger:
Major | Minor | Sub 1 | Sub 2 | Outcome |
1900 | 2000 | 0000 | 0000 | |
2600 | 3000 | 0000 | 0000 | |
4000 | 3000 | 5000 | 0000 | |
2100 | 1000 | 0000 | 0000 | |
1000 | 3000 | 0000 | 0000 |
1.3 Add the following accounts to the general ledger:
Major | Minor | Sub 1 | Sub 2 | Description | Outcome |
1900 | 2000 | 0000 | 0000 | Prepaid Risk Premiums | |
4000 | 3000 | 4000 | 0000 | International Store Revenue | |
1000 | 5000 | 0000 | 0000 | Cash Idlewild Bank NY | |
9200 | 1000 | 0000 | 0000 | CPA Expense | /TR> |
4000 | 3000 | 5000 | 0000 | Inventory Clearance Sales Revenue | |
1000 | 5000 | 0000 | 0000 | Cash -- Verbatim Bank | |
1100 | 0003 | 0000 | 0000 | AIG Stock | |
3000 | 4000 | 0000 | 0000 | Capital |
1.4 Modify the following account descriptions:
Major | Minor | Sub 1 | Sub 2 | New Description | Outcome |
3000 | 4000 | 0000 | 0000 | Contributed Capital | |
1000 | 5000 | 0000 | 0000 | Cash Idlewild Bank NJ | |
4000 | 1000 | 1000 | 0000 | Licensing Revenue | |
9100 | 7000 | 0000 | 0000 | ISP Expense | |
9999 | 9999 | 0000 | 0000 | Suspense Account | |
4000 | 2000 | 0000 | 0000 | Consulting Revenue | |
1900 | 8000 | 0000 | 0000 | Prepaid Taxes | |
9000 | 4000 | 0000 | 0000 | Risk Premiums |
1.5 Using your transaction system post the following journal vouchers to your general ledger system:
1.6 Fill in the answers to the following questions (after completing sections 1.1, 1.2, 1.3, 1.4, and 1.5 above):
1.7 Print a copy of your a44.asp trial balance output after you have completed
posting the transactions above.
BE SURE TO: ORDER THE REPORT IN ASCENDING ACCOUNT NUMBER ORDER.
1.8 Print:
These two items may be in one asp. If so, please note this on your printout.
1.9 Print:
A copy of the je table after posting. Sort the table by sourceref ASC, srseq ASC.
Put your name, Student Number, Database Acct # on each page. 2. (50 points)TO BE RETURNED BY 5:30 PM MON DEC 7 TO 280E MH
Using your electronic web store program:
Put your name, Student Number, Database Acct # on each page.
Note (4) and (5) may be one program
Bind the pages so that they DO NOT fall apart.
Email me at parks@uh.edu if you have issues.
SRN:
7111
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
4000
0000
0000
428.16
First Risk Premium
1000
5000
0000
0000
-428.16
SRN:
7112
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
4000
0000
0000
99.93
Second Risk Premium 2009
1000
6000
0000
0000
-99.93
SRN:
7113
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
5000
1000
1000
0000
8436.87
Sales Staff Expense
1000
5000
0000
0000
-8436.87
SRN:
7114
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
3000
6000
0000
0000
-975.00
Clear Suspense Account
9999
9999
0000
0000
975.00
SRN:
7115
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
5000
0000
0000
884.01
Sales Receipts Dec 2009
4000
3000
1000
0000
-400.00
4000
3000
2000
0000
-400.00
4000
3000
3000
0000
-84.01
SRN:
7116
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
7000
0000
0000
3455.29
Green Giant Energy
1000
4000
0000
0000
-3455.29
SRN:
7161
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
2000
0000
0000
-6910.68
Limo Lease
9000
2000
0000
0000
6910.68
SRN:
7117
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
1000
0000
0000
-450.99
Federal Taxes
2400
1000
0000
0000
-450.99
SRN:
7118
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1100
3000
0000
0000
345612.00
Invest in AIG
1000
1000
0000
0000
-345612.00
SRN:
7119
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1700
3000
0000
0000
1100.54
New Computers
1000
1000
0000
0000
-1100.54
SRN:
7120
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
4000
0000
0000
430.00
Disaster Recovery Expense
1000
1000
0000
0000
-430.00
SRN:
7121
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
4000
0000
0000
143.12
Software License Revenues
4000
1000
0000
0000
-143.13
SRN:
7122
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
1000
0000
0000
-2.01
Paper Clip Expense
1000
2000
0000
0000
-2.02
1000
3000
0000
0000
-2.03
1000
4000
0000
0000
-2.04
1000
5000
0000
0000
-2.05
9000
5000
0000
0000
10.16
SRN:
7161
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
1000
0000
0000
3.13
Employee Party
9000
2000
0000
0000
-3.13
SRN:
7123
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
1000
0000
0000
-14365.38
DEFCON Conference Expenses
9000
2000
0000
0000
-14365.38
BE SURE TO: SHOW THE OVERALL glmaster BALANCE.
BE SURE TO: SHOW THE NUMBER OF ACCOUNTS IN THE glmaster TABLE.
BE SURE TO: SHOW THE REPORT TIME AND DATE.
Include in the report a grand total of the inventory on hand.
Include in the report a grand total of the inventory on hand.
IN SUMMARY: Turn in by 5:30 PM MON DEC 7 to 280E MH: