Raw Preview of Attachment:(refer to the detailed question and attachment below)
Unit 2 Assignment: Management Tools ApplicationFor the past several years, Dustin Larkin has operated a part-time consulting business from his home. As of June 1, 2013, Dustin decided to move to rented quarters and to operate the business, which was to be known as Quixote Consulting, on a full-time basis. Quixote Consulting entered into the following transactions during June:DateTransactionJune 1The following assets were received from Dustin Larkin:Cash, $10,000; Accounts receivable $1,500; supplies, $1,250; and office equipment, $7,500. There were no liabilities received.June 1Paid three months' rent on a lease rental contract, $4,500.June 2Paid the premiums on property and casualty insurance policies, $1,800.June 4Received cash from clients as an advance payment for services to be provided (Record it as unearned fees), $3,000.June 5Purchased additional office equipment on account from Crawford Company, $1,800. June 6.June 6Received cash from clients on account, $800.June 10Paid cash for a newspaper advertisement to run during June, $120.June 12.Paid Crawford Company for part of the debt incurred on June 5, $800.June 12.Recorded services provided on account for the period June 1 to June 12, $2,250.June 14Paid part-time receptionist for 2 weeks' salary, $400. (Note: Ignore any payroll tax or withholdings).June 17Recorded cash from cash clients for fees earned during the period June 1-16, $3,175.June 18Paid cash for supplies, $750.June 20Recorded services provided on account for the period June 13-20, $1,100.June 24Recorded cash from cash clients for fees earned for the period June 17-24, $1,850.June 26Received cash from clients on account, $1,600.June 27Paid part-time receptionist for two weeks' salary, $400. (Note: Ignore any payroll tax or withholdings).June 29Paid telephone bill for June, $130.June 30Paid electricity bill for June, $200.June 30Recorded cash from cash clients for fees earned for the period June 25-30, $2,050June 30Recorded services provided on account for the remainder of June, $1,000.June 30Dustin withdrew $4,500 for personal use.Instructions-Use the Excel template provided in the class titled “Unit 2 and 3 Management Tools Assignment” to complete the following 3 requirements for Unit 2:Journalize each transaction in the two-column journal tab, referring to the following chart of accounts in selecting the accounts to be debited and credited.11-Cash31-Dustin Larkin, Capital12-Accounts Receivable32-Dustin Larkin, Drawing14-Supplies41-Fees Earned15-Prepaid Rent51-Salary Expense16-Prepaid Insurance52-Rent Expense18-Office Equipment53-Supplies Expense19-Accumulated Depreciation54-Depreciation Expense21-Accounts Payable55-Insurance Expense22-Salaries Payable59-Miscellaneous Expense23-Unearned FeesPost the journal to a ledger of four-column accounts, see the Excel tab labeled accordingly.Prepare a trial balance as of June 30, 2013 – using the tab in the Excel workbook labeled accordingly.Be sure and save your work, you will complete the accounting cycle in Unit 3 using the same Excel Template and information.Notes:Proper Journal Entry Formatting is mandatory.Debit Account Descriptions are to be fully left-justified in the line.Credit Account Descriptions are to be indented in the cell.A short description is required for every journal entry.You will be required to create at least ONE additional general Ledger Account to accommodate a few Journal Entries.You may need to add the “Miscellaneous Expense" account to the General Ledger.Or, you may create 2 or 3 new G/L accounts. For example, "Utilities."Be sure that you use proper formatting when you create the Financial Statements. For example:Add required underlining,"$" signs must be properly formatted.The templates are NOT fully “pre-formatted.” You must reformat them for proper presentation in a number of places.Remember, if you have any questions, concerns, or doubts about any of the instructions, please contact your instructor in the Virtual Office as soon as possible.Once completed, submit your assignment to the Unit 2 assignment Dropbox. The assignment is due Tuesday 11:59 p.m. ET of their assigned unit.
Solution: Unit 2 and 3 Assignments