e-mail address__________________________________________
1. (50 points) TO BE RETURNED BY 5PM MON APR 30 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 |
9000 | 4000 | 0000 | 0000 | |
1000 | 4000 | 0000 | 0000 | |
3000 | 4000 | 0000 | 0000 |
1.3 Add the following accounts to the general ledger:
Major | Minor | Sub 1 | Sub 2 | Description | Outcome |
1000 | 4000 | 0000 | 0000 | Cash Pittsburg HQ -- Iron Town Bank | |
4000 | 3000 | 4000 | 0000 | Search Engine Revenue | |
1000 | 5000 | 0000 | 0000 | Cash Toronto Office -- Maple Leaf Bank | |
9000 | 4000 | 0000 | 0000 | Insurance Expense | /TR> |
4000 | 3000 | 5000 | 0000 | Web Ad Revenue | |
1000 | 5000 | 0000 | 0000 | Cash -- Payroll Account -- West Coast Bank | |
1100 | 3000 | 0000 | 0000 | Google Stock | |
3000 | 6000 | 0000 | 0000 | Retained Earnings |
1.4 Modify the following account descriptions:
Major | Minor | Sub 1 | Sub 2 | New Description | Outcome |
3000 | 4000 | 0000 | 0000 | Paid In Capital | |
1000 | 5000 | 0000 | 0000 | Cash Toronto Office -- Maple Leaves Bank | |
1700 | 2000 | 0000 | 0000 | Cisco Switch | |
5100 | 1000 | 2000 | 0000 | Direct Labor -- Walk-in Store Operations | |
9999 | 9999 | 0000 | 0000 | Suspense | |
4000 | 1000 | 0000 | 0000 | Web Operation Revenue | |
2600 | 4000 | 0000 | 0000 | ACM Dues |
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.
Put your name, SSN, Database Acct # on each page. 2. (50 points)TO BE RETURNED BY 5PM MON APR 30 TO 280E MH
Using your electronic web store program:
Include in the report a grand total of the inventory on hand.
Put your name, SSN, Database Acct # on each page.
Note (3) and (4) may be one program
SRN:
7711
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
6000
0000
0000
1348.31
1000
5000
0000
0000
-1348.31
Communications Expenses for December
SRN:
7712
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
4000
0000
0000
238.91
Fire Insurance 2006
1000
5000
0000
0000
-238.91
SRN:
7713
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
5000
1000
1000
0000
2234.57
search server rental
1000
2000
0000
0000
-2234.57
SRN:
7714
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
3000
6000
0000
0000
-975.99
Clear Suspense Account
9999
9999
0000
0000
975.99
SRN:
7715
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
1000
0000
0000
884.50
Sales Receipts December 2006
4000
3000
4000
0000
-800.10
4000
3000
2000
0000
-10.10
4000
3000
3000
0000
-74.40
SRN:
7716
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
7000
0000
0000
560.28
Brazos Water and Power
1000
1000
0000
0000
-560.28
SRN:
7716
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
6000
0000
0000
91.31
Remote Charges
1000
1000
0000
0000
-91.31
SRN:
7717
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
4000
0000
0000
-1200.99
Taxes
2400
1000
0000
0000
600.01
2400
6000
0000
0000
600.98
SRN:
7718
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1100
0003
0000
0000
44000.04
Invest in Google
1000
1000
0000
0000
-44000.04
SRN:
7719
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9999
9999
0000
0000
-0.99
suspense fix
3000
6000
0000
0000
0.99
SRN:
7720
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
2600
4000
0000
0000
600.00
Pay ACM Dues
1000
5000
0000
0000
-600.00
BE SURE TO: SHOW THE OVERALL glmaster BALANCE.
BE SURE TO: SHOW THE NUMBER OF ACCOUNTS IN THE glmaster TABLE.
In summary, turn in by 5PM MON APR 30 to 280E MH: