Problem 2-3A - due in 6 hours

profilecombs
WRD27e_PR02-3A.xlsx
Home>Business & Finance homework help>Accounting homework help>Problem 2-3A - due in 6 hours

Pr. 2-3A

Problem 2-3A # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")
Name: 0
Section: # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
144
Score: 0% # N-box +B-box corrects COUNTIF(B7:AT41," ")
0
Key Code: 2 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. 0%
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. Essay answers will not be graded. 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
2019
June
Craig Pence: Enter the date here.		 Accounts Payable
Accounts Receivable
Cash
Equipment
Fees Earned
Miscellaneous Expense
Wages Expense
Notes Payable
Kris Storey, Capital
Kris Storey, Drawing
Prepaid Insurance
Supplies
Rent Expense
Van
Van Expense
Utilities Expense
Wages Expense
JOURNAL Page 2
Post
Date Description Ref. Debit Credit
2019
June
2. GENERAL LEDGER
Cash 11
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June
Accounts Receivable 12
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June
Supplies 13
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June
Prepaid Insurance 14
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June
Equipment 16
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June
Van 18
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June
Notes Payable 21
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June
Accounts Payable 22
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June
Kris Storey, Capital 31
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June
Kris Storey, Drawing 32
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June
Fees Earned 41
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June
Wages Expense 51
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June
Rent Expense 53
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June
Utilities Expense 54
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June
Van Expense 55
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June
Miscellaneous Expense 59
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June
3. ECO-CENTRIC DESIGNS
Unadjusted Trial Balance
June 30, 2019
Debit Balances Credit Balances
Cash
Accounts Receivable
Supplies
Prepaid Insurance
Equipment
Van
Notes Payable
Accounts Payable
Kris Storey, Capital
Kris Storey, Drawing
Fees Earned
Wages Expense
Rent Expense
Utilities Expense
Van Expense
Miscellaneous Expense

Peggy Hussey: Total debits should be equal to total credits.
Peggy Hussey: Total debits should be equal to total credits.
4.
5.
[Key essay answer here]

Sol

Problem 2-3A
Name: Solution
Section:
Scoring: ON
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 journal entries, dates will not be graded. In the general ledger accounts, only the final balance of the account will be
graded. For correct grading in the trial balance, enter a zero where you would otherwise leave an amount cell blank.
An asterisk (*) will appear to the right of incorrect entries in outlined answer cells. Essay answers will not be graded.
1. JOURNAL Page 1
Post
Date Description Ref. Debit Credit
2019
June 1
Craig Pence: Enter the date here.		 Cash 11 35,000 Accounts Payable
Kris Storey, Capital 31 35,000 Accounts Receivable
Cash
1 Rent Expense 53 4,750 Equipment
Cash 11 4,750 Fees Earned
Kris Storey, Capital
6 Equipment 16 14,100 Kris Storey, Drawing
Accounts Payable 22 14,100 Miscellaneous Expense
Wages Expense
8 Van 18 28,500 Notes Payable
Cash 11 4,500 Prepaid Insurance
Notes Payable 21 24,000 Supplies
Rent Expense
10 Supplies 13 2,380 Van
Cash 11 2,380 Van Expense
Utilities Expense
12 Cash 11 12,200 Wages Expense
Fees Earned 41 12,200
15 Prepaid Insurance 14 3,600
Cash 11 3,600
23 Accounts Receivable 12 11,900
Fees Earned 41 11,900
24 Van Expense 55 1,500
Accounts Payable 22 1,500
JOURNAL Page 2
Post
Date Description Ref. Debit Credit
2019
June 29 Utilities Expense 54 3,100
Cash 11 3,100
29 Miscellaneous Expense 59 950
Cash 11 950
30 Cash 11 7,330
Accounts Receivable 12 7,330
30 Wages Expense 51 5,070
Cash 11 5,070
30 Accounts Payable 22 6,825
Cash 11 6,825
30 Kris Storey, Drawing 32 1,600
Cash 11 1,600
GENERAL LEDGER
2. Cash 11
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June 1 1 35,000 35,000
1 1 4,750 30,250
8 1 4,500 25,750
10 1 2,380 23,370
12 1 12,200 35,570
15 1 3,600 31,970
29 2 3,100 28,870
29 2 950 27,920
30 2 7,330 35,250
30 2 5,070 30,180
30 2 6,825 23,355
30 2 1,600 21,755
Accounts Receivable 12
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June 23 1 11,900 11,900
30 2 7,330 4,570
Supplies 13
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June 10 1 2,380 2,380
Prepaid Insurance 14
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June 15 1 3,600 3,600
Equipment 16
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June 6 1 14,100 14,100
Van 18
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June 8 1 28,500 28,500
Notes Payable 21
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June 8 1 24,000 24,000
Accounts Payable 22
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June 6 1 14,100 14,100
24 1 1,500 15,600
30 2 6,825 8,775
Kris Storey, Capital 31
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June 1 1 35,000 35,000
Kris Storey, Drawing 32
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June 30 2 1,600 1,600
Fees Earned 41
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June 12 1 12,200 12,200
23 1 11,900 24,100
Wages Expense 51
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June 30 2 5,070 5,070
Rent Expense 53
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June 1 1 4,750 4,750
Utilities Expense 54
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June 29 2 3,100 3,100
Van Expense 55
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June 24 1 1,500 1,500
Miscellaneous Expense 59
Post Balance
Date Item Ref. Dr. Cr. Dr. Cr.
2019
June 29 2 950 950
3. ECO-CENTRIC DESIGNS
Unadjusted Trial Balance
June 30, 2019
Debit Balances Credit Balances
Cash 21,755 -
Accounts Receivable 4,570 -
Supplies 2,380 -
Prepaid Insurance 3,600 -
Equipment 14,100 -
Van 28,500 -
Notes Payable - 24,000
Accounts Payable - 8,775
Kris Storey, Capital - 35,000
Kris Storey, Drawing 1,600 -
Fees Earned - 24,100
Wages Expense 5,070 -
Rent Expense 4,750 -
Utilities Expense 3,100 -
Van Expense 1,500 -
Miscellaneous Expense 950 -
91,875
Peggy Hussey: Total debits should be equal to total credits. 		91,875
Peggy Hussey: Total debits should be equal to total credits.
4.
$8,730
5.
Some supplies may have been used, prepaid insurance expired, or depreciation of equipment incurred for which the expense has not been recorded.