Assignment 3 Do P3-35A Due Date: March 19 You are required to use Assignment 3 Spreadsheet to do the assignment, save it as A3YourName, and submit it by the due date. Assignment in a format other than Microsoft Excel spreadsheet will not be accepted. Late assignment will not be accepted either. Assignment solutions will be provided right after the due date. Turn in assignment on time to earn bonus points. P3-35A Journalizing and posting adjustments to the T-accounts and preparing an adjusted trial balance I The unadjusted trial balance of Anniston Air Purification System at December 31, 2018, and the data needed for the adjustments follow ANNISTON AIR PURIFICATION SYSTEM Unadjusted Trial Balance December 31, 2018 Account Title Balance Debit Credit 57.100 19700 200 A Receive conting data needed for the adjustments follow. ANNISTON AIR PURIFICATION SYSTEM Unadjusted Trial Balance December 31, 2018 Balance Debit Credit $ 7,600 19,700 2,900 1800 22.000 5 3.900 2.900 Account Title Cash Accounts Receivable Prepaid Rent Office Supplies Equipment Accumulated Depreciation Equipment Accounts Payable Salaries Payable Unearned Revenge Common Stock Dividends Service Revenue Salaries Expense Rent Expense Depreciation Expence-Equipment Advertising Expense Supplies Expense Total X100 41.00 9,000 15.300 1,100 1.100 $69.000 S6000 Adjustment data at December 31 follow a. On December 15, Anniston contracted to perform services for a client receiving 53,100 in advance. Anniston recorded this receipt of cash as Unearned Revenue. As of December 31, Anniston has completed $2,100 of the services b. Anniston prepaid two months of rent on December 1. (Assume the Prepaid Rent balance as shown on the unadjusted trial balance represents the two months of rent prepaid on December 1.) c. Anniston used $750 of office supplies d. Depreciation for the equipment is $850. e. Anniston received a bill for December's online advertising $1,100. Anniston will not pay the bill until January (Use Accounts Payable) 1. Anniston pays its employees on Monday for the previous week's wages. Its employees cam $3,500 for a five-day workweek December 31 falls on Wednesday this year g. On October 1, Anniston agreed to provide a four-month air system check (beginning October 1) for a customer for $3,400. Anniston has completed the system check every month, but payment has not yet been received and no entries have been made. Requirements 1. Joumalize the adjusting entries on December 31 2. Using the unadjusted trial balance, open the accounts with the unadjusted balancer Post the adjusting entries to the T-accounts 3. Prepare the adjusted trial balance. 4. How will Arniston Air Purification System use the adjusted trial balance? H M N 0 P F G 1 Assignment 3 Bonus Points: Up to 10 points 2 Do P3-35A 3 Due Date: March 19 4 Save the spreadsheet as A3yourname and submit it by the due date. 5 6 Requirement 1 Requirement Cash 7 8 9 a. 10 Accounts Debit Credit Date 31-Dec Accounts Payable Amount Debit Credit Saw Bal 7600 11 31-Dec 12 b, 13 Accounts Receivable Salaries Payable 15 16 Prepaid Rest Lamed Reve Ralpe 17 18 19 20 21 22 Office Supplies Common Stock Sheet1 44 Candles from the Internet can continues you to edit do vay in Pied w Review View Help ecovery Table 31-Dec D the following files. Suve keep 10 G H 126. 13 31-Dec Spreadsheet at time the 14 15 10 bution (1) pension rated from the 05 PM word 12 Per 20 21 22 Cook 23 24 25 hd 26 27 20 12 18 19 Prepaid Rent Loramed Reve Rad 20 21 22 23 24 25 Office Supplies Common Stock Equipment Dn 26 27 28 29 30 Acemaated Depreciation Equipment Selespee 31 32 33 34 35