Miller Design Studio 100% Answer

profileProfArgeol
acct100finalassessmentstudenttemplatejun13-1.xls
Home>Business & Finance homework help>Accounting homework help>Miller Design Studio 100% Answer

Chart of Accounts - Table 1

Chart of Accounts
Cash 111
Accounts Receivable 113
Office Supplies 115
Prepaid Rent 117
Office Equipment 145
Accumulated Depreciation - Office Equipment 146
Accounts Payable 212 h
Unearned Design Revenue 213
Wages Payable 214
J. Miller, Capital 311
J. Miller, Withdrawals 312
Income Summary 313
Design Revenue 411
Wages Expense 511
Utilities Expense 512
Rent Expense 514
Office Supplies Expense 517
Depreciation Expense - Office Equipment 519
Dropdown List for Transaction Descriptions
Billed for design services performed
Cash investment by J. Miller
For design services performed for Rave Department Stores
Paid amount due for utility bill received and recorded in July
Paid assistant four weeks' wages
Paid for office equipment purchased in July
Paid September rent in advance
Paid utilities bill for August
Purchased office equipment
Purchased office supplies
Received advance fee for design services
Received cash payment for design services
Received payment for design services performed last month
To accrue unrecorded wages
To close the expense accounts into the income summary account
To close the income summary account
To close the revenue account into the income summary account
To close the withdrawals account
To recognize expiration of one month's rent
To recognize office supplies used during the month
To recognize performance of services paid for in advance
To record depreciation of equipment for the month
To record revenue earned, but not billed until September
To reverse the adjusting entry for accrued design revenue earned
To reverse the adjusting entry for accrued wages
Withdrawal of cash by J. Miller
Dropdown List for Statement of Owner's Equity
J. Miller, Capital, August 1, 2011
J. Miller, Capital, August 31, 2011
Less Withdrawals
Net Income (Loss)
Plus Investment by Owner
Subtotal
Dropdown List for Work Sheet Adjustments
(a)
(b)
(c)
(d)
(e)
(f)
Dropdown List for Ledger Items
Adjusting
Closing
Reversing
Dropdown List for Ledger Post Ref
J1
J2
J3
J4
J5
J6
J7
J8
J9
J10

Reversing Journal Entries - Tab

Name: Charli K Rodgers # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")
Course: Acct 100
Date: # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
Chapter 4, Comprehensive Problem # N-box + B-box corrects COUNTIF(B7:AT41," ")
1. Record the optional reversing entry on August 1 for Wages Payable (see adjustment for unrecorded wages on page 112). Total SUM(AV13:AV15)
General Journal Page 5 Percentage =AV14/AV16
Date Description Post Ref Debit Credit
2011 Notes:
Aug 01 If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
111 20,000 If number-entry or bland-entry box is incorrect, returns "*"
If number-entry or blank-entry box is correct, returns single space, " "
Use data verification to set data entry to whole number >=0, and use dropdowns for labels and names so that students can't enter a space in a box and have it counted as correct.
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.
1. Record the optional reversing entry on August 1 for Accounts Receivable (see adjustment for design revenue on page 115).
Aug 01
Office equipment 145 4,700
Overall Score: 0%
Tab Score:
Chapter 4, Comprehensive Problem
1. Record the optional reversing entry on August 1 for Wages Payable (see adjustment for unrecorded wages on page 112).
General Journal Page 5
Date Description Post Ref Debit Credit
2011
Aug 01 Wages Payable 214 720
Wages Expense 511 720
To reverse the adjusting entry for accrued wages
1. Record the optional reversing entry on August 1 for Accounts Receivable (see adjustment for design revenue on page 115).
Aug 01 Design Revenue 411 400
Accounts Receivable 113 400
To reverse the adjusting entry for accrued design revenue earned
Choose answers from dropdown list.
Enter amounts as positive whole numbers.
Choose answers from dropdown list.

August Journal Entries - Table

Chapter 4, Comprehensive Problem # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")
2. Record the transactions for August in journal form. Note that, for the August 8 transaction, the instructions should state: "Completed the series of designs that began on July 31 for which $1,400 cash was received in advance on July 19. The accrued revenues were adjusted on July 31st for the $800 of work that wa completed and accepted during July." # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
# N-box + B-box corrects COUNTIF(B7:AT41," ")
Total SUM(AV13:AV15)
General Journal Page 6
Date Description Post Ref Debit Credit
2011 Percentage =AV14/AV16
Aug 01 Cash 20,000
20,000 Notes:
If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
If number-entry or bland-entry box is incorrect, returns "*"
Aug 02 4,700 If number-entry or blank-entry box is correct, returns single space, " "
Use data verification to set data entry to whole number >=0, and use dropdowns for labels and names so that students can't enter a space in a box and have it counted as correct.
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.
Aug 07
Aug 08
Aug 12
Aug 13
Aug 15
Aug 16
Aug 19
Aug 20
Aug 21
Aug 22
Aug 23
Aug 26
Aug 30
Tab Score:
Chapter 4, Comprehensive Problem
2. Record the transactions for August in journal form.
General Journal Page 5
Date Description Post Ref Debit Credit
2011
Aug 01 Cash 111 20,000
J. Miller, Capital 311 20,000
Cash investment by J. Miller
Aug 02 Office Equipment 145 4,700
Cash 111 4,700
Purchased office equipment
Aug 07 Office Supplies 115 540
Cash 111 540
Purchased office supplies
Aug 08 Unearned Design Revenue 213 600
Design Revenue 411 600
Billed for design services performed
Aug 12 Accounts Payable 212 3,000
Cash 111 3,000
Paid for office equipment purchased in July
Aug 13 Cash 111 2,400
Unearned Design Revenue 213 2,400
Received advance fee for design services
Aug 15 Cash 111 2,900
Design Revenue 411 2,900
Received cash payment for design services
Aug 16 Cash 111 2,800
Accounts Receivable 113 2,800
Received payment for design services performed last month
Aug 19 Accounts Payable 212 140
Cash 111 140
Paid amount due for utility bill received and recorded in July
Aug 20 Accounts Receivable 113 3,200
Design Revenue 411 3,200
For design services performed for Rave Department Stores
Aug 21 Cash 111 1,160
Design Revenue 411 1,160
Received cash payment for design services
Aug 22 Utilities Expense 512 900
Cash 111 900
Paid utilities bill for August
Aug 23 Wages Expense 511 4,800
Cash 111 4,800
Paid assistant four weeks' wages
Aug 26 Prepaid Rent 117 1,600
Cash 111 1,600
Paid September rent in advance
Aug 30 J. Miller, Withdrawals 312 2,800
Cash 111 2,800
Withdrawal of cash by J. Miller
Choose answers from dropdown list.
Enter amounts as positive whole numbers.
Choose answers from dropdown list.
Enter amounts as positive whole numbers.
Enter amounts as positive whole numbers.
Choose answers from dropdown list.
Enter amounts as positive whole numbers.
Enter amounts as positive whole numbers.
Choose answers from dropdown list.
Enter amounts as positive whole numbers.
Enter amounts as positive whole numbers.

General Ledger - Table 1

Chapter 4, Comprehensive Problem # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")
1, 3, 7 & 8. Post the reversing journal entries, August journal entries, adjusting journal entries, and closing journal entries to the ledger accounts. # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
# N-box + B-box corrects COUNTIF(B7:AT41," ")
General Ledger
Cash Account No. 111 Total SUM(AV13:AV15)
Balance
Date Item Post Ref Debit Credit Debit Credit
2011 Percentage =AV14/AV16
Jul 31 J4 2,800 22,480
Aug 01 Notes:
Aug 02 If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
Aug 07 If number-entry or bland-entry box is incorrect, returns "*"
Aug 12 If number-entry or blank-entry box is correct, returns single space, " "
Aug 13 Use data verification to set data entry to whole number >=0, and use dropdowns for labels and names so that students can't enter a space in a box and have it counted as correct.
Aug 15 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.
Aug 16
Aug 19
Aug 21
Aug 22
Aug 23
Aug 26
Aug 30
Accounts Receivable Account No. 113
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Jul 31 J4 400 5,000
Aug 01
Aug 16
Aug 20
Aug 31
Office Supplies Account No. 115
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Jul 31 Beginning Balance 3,660
Aug 07
Aug 31
Prepaid Rent Account No. 117
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Jul 31 J4 1,600 1,600
Aug 26
Aug 31
Office Equipment Account No. 145
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Jul 31 J4 16,320 16,320
Aug 02
Accumulated Depreciation - Office Equipment Account No. 146
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Jul 31 J4 300 300
Aug 31
.
Accounts Payable Account No. 212
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Jul 31 Beginning Balance 6,280
Aug 12
Aug 19
Unearned Design Revenue Account No. 213
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Jul 31 J4 800 600
Aug 08
Aug 13
Aug 31
Wages Payable Account No. 214
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Jul 31 J4 720 720
Aug 01
Aug 31
J. Miller, Capital Account No. 311
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Jul 31 Beginning Balance 41,160
Aug 01
Aug 31
Aug 31
J. Miller, Withdrawals Account No. 312
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Aug 30
Aug 31
Income Summary Account No. 313
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Aug 31
Aug 31
Aug 31
Design Revenue Account No. 411
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Aug 01
Aug 08
Aug 15
Aug 20
Aug 21
Aug 31
Aug 31
Aug 31
Wages Expense Account No. 511
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Aug 01
Aug 23
Aug 31
Aug 31
Utilities Expense Account No. 512
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Aug 22
Aug 31
Rent Expense Account No. 514
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Aug 31
Aug 31
Office Suplies Expense Account No. 517
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Aug 31
Aug 31
Depreciation Expense - Office Equipment Account No. 519
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Aug 31
Aug 31
Tab Score:
Choose answers from dropdown list.
Choose answers from dropdown list.
Enter amounts as positive whole numbers.

Work Sheet - Table 1

Chapter 4, Comprehensive Problem # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")
4 & 5. Prepare the work sheet. # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
Miller Design Studio # N-box + B-box corrects COUNTIF(B7:AT41," ")
Work Sheet
For the Month Ended August 31, 2011 Total SUM(AV13:AV15)
Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance Sheet
Account Name Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit Percentage =AV14/AV16
Cash
Accounts Receivable Notes:
Office Supplies If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
Prepaid Rent If number-entry or bland-entry box is incorrect, returns "*"
Office Equipment If number-entry or blank-entry box is correct, returns single space, " "
Accumulated Depreciation - Office Equipment Use data verification to set data entry to whole number >=0, and use dropdowns for labels and names so that students can't enter a space in a box and have it counted as correct.
Accounts Payable 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.
Unearned Design Revenue
J. Miller, Capital
J. Miller, Withdrawals
Design Revenue
Wages Expense
Utilities Expense
Rent Expense
Depreciation Expense - Office Equipment
Wages Payable
Office Supplies Expense
Net Loss
Tab Score:
For columns F and J, choose answers from dropdown list that correspond with respective adjustment debit and credit amounts.
Enter all amounts in the debit and credit columns for each section as positive whole numbers.

Income Statement - Table 1

Chapter 4, Comprehensive Problem # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")
6. From the work sheet, prepare the income statement. # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
Miller Design Studio # N-box + B-box corrects COUNTIF(B7:AT41," ")
Income Statement
For the Month Ended August 31, 2011 Total SUM(AV13:AV15)
Revenues
Percentage =AV14/AV16
Expenses
Notes:
If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
If number-entry or bland-entry box is incorrect, returns "*"
If number-entry or blank-entry box is correct, returns single space, " "
Use data verification to set data entry to whole number >=0, and use dropdowns for labels and names so that students can't enter a space in a box and have it counted as correct.
Total expenses 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.
Net Income (Loss)
Tab Score:
Enter expenses in order from largest to smallest using dropdown list.
Enter all amounts as positive whole numbers unless otherwise noted.
Choose answers from dropdown list.
Net loss should be entered as a negative amount.

Statement of Owner's Equity - T

Chapter 4, Comprehensive Problem # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")
6. From the general ledger, work sheet, and income statement, prepare the statement of owner's equity. # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
Miller Design Studio # N-box + B-box corrects COUNTIF(B7:AT41," ")
Statement of Owner's Equity
For the Month Ended August 31, 2011 Total SUM(AV13:AV15)
Percentage =AV14/AV16
Notes:
If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
If number-entry or bland-entry box is incorrect, returns "*"
If number-entry or blank-entry box is correct, returns single space, " "
Tab Score:
Chapter 4, Comprehensive Problem
6. From the work sheet, prepare the income statement.
Miller Design Studio
Statement of Owner's Equity
For the Month Ended August 31, 2011
J. Miller, Capital, August 1, 2011
Plus Investment by Owner
Net Income (Loss)
Subtotal
Less Withdrawals
J. Miller, Capital, August 31, 2011
Enter all amounts as positive whole numbers.
Net loss should be entered as a negative amount.
Choose answers from dropdown list, and be sure to order items in format shown in Chapter 3 Exhibit.
Enter all amounts as positive whole numbers unless otherwise noted.
Choose answers from dropdown list, and be sure to order items in format shown in Chapter 3 Exhibit.

Balance Sheet - Table 1

Chapter 4, Comprehensive Problem # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")
6. From the work sheet and statement of owner's equity, prepare the balance sheet. # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
Miller Design Studio # N-box + B-box corrects COUNTIF(B7:AT41," ")
Balance Sheet
August 31"," 2011 Total SUM(AV13:AV15)
Assets
Percentage =AV14/AV16
Notes:
If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
If number-entry or bland-entry box is incorrect, returns "*"
If number-entry or blank-entry box is correct, returns single space, " "
Total assets Use data verification to set data entry to whole number >=0, and use dropdowns for labels and names so that students can't enter a space in a box and have it counted as correct.
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.
Liabilities
Total liabilities
Owner's Equity
Total owner's equity
Total liabilities and owner's equity
Tab Score:
Choose answers from dropdown list. Enter assets and liabilities in order shown on work sheet.
Enter all amounts as positive whole numbers.

Adjusting Journal Entries - Tab

Chapter 4, Comprehensive Problem # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")
7. From the work sheet, record adjusting entry (a) in journal form. # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
General Journal Page 7 # N-box + B-box corrects COUNTIF(B7:AT41," ")
Date Description Post Ref Debit Credit
2011 Total SUM(AV13:AV15)
Aug 31
Percentage =AV14/AV16
Notes:
If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
7. From the work sheet, record adjusting entry (b) in journal form. If number-entry or bland-entry box is incorrect, returns "*"
If number-entry or blank-entry box is correct, returns single space, " "
Aug 31 Use data verification to set data entry to whole number >=0, and use dropdowns for labels and names so that students can't enter a space in a box and have it counted as correct.
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.
7. From the work sheet, record adjusting entry (c) in journal form.
Aug 31
7. From the work sheet, record adjusting entry (d) in journal form.
Aug 31
7. From the work sheet, record adjusting entry (e) in journal form.
Aug 31
7. From the work sheet, record adjusting entry (f) in journal form.
Aug 31
Tab Score:
Choose answers from dropdown list.
Enter amounts as positive whole numbers.
Choose answers from dropdown list.

Closing Journal Entries - Table

Chapter 4, Comprehensive Problem # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")
8. From the work sheet, record closing entry for revenue in journal form. # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
General Journal Page 8 # N-box + B-box corrects COUNTIF(B7:AT41," ")
Date Description Post Ref Debit Credit
2011 Total SUM(AV13:AV15)
Aug 31
Percentage =AV14/AV16
Notes:
If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
8. From the work sheet, record closing entry for expenses in journal form. If number-entry or bland-entry box is incorrect, returns "*"
If number-entry or blank-entry box is correct, returns single space, " "
Aug 31 Use data verification to set data entry to whole number >=0, and use dropdowns for labels and names so that students can't enter a space in a box and have it counted as correct.
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.
8. Record closing entry for the income summary account in journal form.
Aug 31
8. From the work sheet, record closing entry for withdrawals in journal form.
Aug 31
Tab Score:
Choose answers from dropdown list.
Enter expenses in order from largest to smallest using dropdown list.
Enter amounts as positive whole numbers.
Choose answers from dropdown list.

Post-Closing Trial Balance - Ta

Chapter 4, Comprehensive Problem # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")
9. From the balance sheet, prepare the post-closing trial balance as of August 31, 2011. # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
Miller Design Studio # N-box + B-box corrects COUNTIF(B7:AT41," ")
Post-Closing Trial Balance
August 31"," 2011 Total SUM(AV13:AV15)
Percentage =AV14/AV16
Notes:
If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
If number-entry or bland-entry box is incorrect, returns "*"
If number-entry or blank-entry box is correct, returns single space, " "
Use data verification to set data entry to whole number >=0, and use dropdowns for labels and names so that students can't enter a space in a box and have it counted as correct.
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.
Tab Score:
Enter total debits.
Enter answers from dropdown list. List accounts in order shown on balance sheet.
Enter amounts as positive whole numbers.
Enter total debits.