Kim Wheeler established

profileProfArgeol
copy_of_02-3b_24e.xls
Home>Business & Finance homework help>Accounting homework help>Kim Wheeler established

Pr. 2-3B

Problem 2-3B # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")
Name: 1
Section: # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
51
Score: 64% # N-box +B-box corrects COUNTIF(B7:AT41," ")
92
Key Code: [Kay code here] Total SUM(AV13:AV15)
Instructions 144
Answers are entered in the cells with gray backgrounds. Percentage =(AV16-AV13-AV14)/AV16
Cells with non-gray backgrounds are protected and cannot be edited. 64%
Enter the appropriate amounts/formulas in the answer cells, or select from the drop-down list. Notes:
In journal entries, dates will not be graded. In the general ledger accounts, only the final balance of the account will be If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
graded. For correct grading in the trial balance, enter a zero where you would otherwise leave an amount cell blank. If number-entry or blank-entry box is incorrect, returns "*"
An asterisk (*) will appear to the right of incorrect entries in outlined answer cells. If number-entry or blank-entry box is correct, returns single space, " "
1. JOURNAL Page 1 Use data verification to set data entry to whole number >= 0, and use drop-downs for lables and names, so that students can't enter a space in a box and have it counted as correct.
Post Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color.
Date Description Ref. Debit Credit
2012
July 1 Cash 21,000 Accounts Payable
Kim Wheeler, Capital 21,000 Accounts Receivable
0 Cash
4 Rent Expense 2,750 Equipment
Cash 2,750 Fees Earned
0 Kim Wheeler, Capital
10 Truck 18,000 Kim Wheeler, Drawing
Cash 4,000 Miscellaneous Expense
Notes Payable 14,000 Wages Expense
0 Notes Payable
13 Equipment 9,000 Prepaid Insurance
Accounts Payable 9,000 Supplies
0 Rent Expense
14 Supplies 1,500 Truck
Cash 1,500 Truck Expense
0 Utilities Expense
15 Prepaid Insurance 3,600 Wages Expense
Cash 3,600
0
15 Cash 12,000
Fees Earned 12,000
JOURNAL Page 2
Post
Date Description Ref. Debit Credit
2012
July 21 Accounts Payable 2,000
Cash 2,000
24 Accounts Receivable 9,800
Fees Earned 9,800
26 Truck Expense 700
Accounts Payable 700
0
27 Utilities Expense 1,000
Cash 1,000
0
27 Miscellaneous Expense 300
Cash 300
0
29 Cash 4,600
Accounts Receivable 4,600
0
30 Wages Expense 2,800
Cash 2,800
0
31 Kim Wheeler, Drawing 2,500
Cash 2,500
2. GENERAL LEDGER
Cash 11
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July 1 - 21,000 - 21,000
- 2,750 2,750
-
-
-
-
Accounts Receivable 12
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July
Supplies 13
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July
Prepaid Insurance 14
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July
Equipment 16
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July
Truck 18
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July
Notes Payable 21
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July
Accounts Payable 22
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July
Kim Wheeler, Capital 31
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July
Kim Wheeler, Drawing 32
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July 0
Fees Earned 41
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July
Wages Expense 51
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July
Rent Expense 53
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July
Utilities Expense 54
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July
Truck Expense 55
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July
Miscellaneous Expense 59
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July
3. AZTEC DESIGNS
Unadjusted Trial Balance
July 31, 2012
Cash -
Accounts Receivable -
Supplies 1,500 -
Prepaid Insurance 3,600 -
Equipment 9,000 -
Truck 18,000 -
Notes Payable - 14,000
Accounts Payable - 12,000 *
Kim Wheeler, Capital - 21,000
Kim Wheeler, Drawing 2,500 -
Fees Earned -
Wages Expense 2,800 -
Rent Expense 2,750 -
Utilities Expense 1,000 -
Truck Expense 700 -
Miscellaneous Expense 300 -
64,500 64,500
4.
Enter the date here.
Total debits should be equal to total credits.
Total debits should be equal to total credits.

Sol

Problem 2-3B
Name: Solution
Section:
Score: ON
Key Code:
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Enter the appropriate amounts/formulas in the answer cells, or select from the drop-down list.
In the general ledger accounts, only the final balance of the account will be graded.
For correct grading in the trial balance, enter a "0" where you would otherwise leave an amount cell blank.
An asterisk (*) will appear to the right of incorrect entries in outlined answer cells.
1. JOURNAL Page 1
Post
Date Description Ref. Debit Credit
2012
July 1 Cash 11 21,000 Accounts Payable
Kim Wheeler, Capital 31 21,000 Accounts Receivable
Cash
4 Rent Expense 53 2,750 Equipment
Cash 11 2,750 Fees Earned
Kim Wheeler, Capital
10 Truck 18 18,000 Kim Wheeler, Drawing
Cash 11 4,000 Miscellaneous Expense
Notes Payable 21 14,000 Wages Expense
Notes Payable
13 Equipment 16 9,000 Prepaid Insurance
Accounts Payable 22 9,000 Supplies
Rent Expense
14 Supplies 13 1,500 Truck
Cash 11 1,500 Truck Expense
Utilities Expense
15 Prepaid Insurance 14 3,600 Wages Expense
Cash 11 3,600
15 Cash 11 12,000
Fees Earned 41 12,000
JOURNAL Page 2
Post
Date Description Ref. Debit Credit
2012
July 21 Accounts Payable 22 2,000
Cash 11 2,000
24 Accounts Receivable 12 9,800
Fees Earned 41 9,800
26 Truck Expense 55 700
Accounts Payable 22 700
27 Utilities Expense 54 1,000
Cash 11 1,000
27 Miscellaneous Expense 59 300
Cash 11 300
29 Cash 11 4,600
Accounts Receivable 12 4,600
30 Wages Expense 51 2,800
Cash 11 2,800
31 Kim Wheeler, Drawing 32 2,500
Cash 11 2,500
GENERAL LEDGER
2. Cash 11
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July 1 1 21,000 21,000
4 1 2,750 18,250
10 1 4,000 14,250
14 1 1,500 12,750
15 1 3,600 9,150
15 1 12,000 21,150
21 2 2,000 19,150
27 2 1,000 18,150
27 2 300 17,850
29 2 4,600 22,450
30 2 2,800 19,650
31 2 2,500 17,150
Accounts Receivable 12
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July 24 2 9,800 9,800
29 2 4,600 5,200
Supplies 13
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July 14 1 1,500 1,500
Prepaid Insurance 14
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July 15 1 3,600 3,600
Equipment 16
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July 13 1 9,000 9,000
Truck 18
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July 10 1 18,000 18,000
Notes Payable 21
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July 10 1 14,000 14,000
Accounts Payable 22
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July 13 1 9,000 9,000
21 1 2,000 7,000
26 2 700 7,700
Kim Wheeler, Capital 31
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July 1 1 21,000 21,000
Kim Wheeler, Drawing 32
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July 31 2 2,500 2,500 0
Fees Earned 41
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July 15 1 12,000 12,000
24 2 9,800 21,800
Wages Expense 51
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July 30 2 2,800 2,800
Rent Expense 53
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July 4 1 2,750 2,750
Utilities Expense 54
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July 27 2 1,000 1,000
Truck Expense 55
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July 26 2 700 700
Miscellaneous Expense 59
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2012
July 27 2 300 300
3. AZTEC DESIGNS
Unadjusted Trial Balance
July 31, 2012
Cash 17,150 -
Accounts Receivable 5,200 -
Supplies 1,500 -
Prepaid Insurance 3,600 -
Equipment 9,000 -
Truck 18,000 -
Notes Payable - 14,000
Accounts Payable - 7,700
Kim Wheeler, Capital - 21,000
Kim Wheeler, Drawing 2,500 -
Fees Earned - 21,800
Wages Expense 2,800 -
Rent Expense 2,750 -
Utilities Expense 1,000 -
Truck Expense 700 -
Miscellaneous Expense 300 -
64,500 64,500
4.
$14,250
Enter the date here.
Total debits should be equal to total credits.
Total debits should be equal to total credits.