REQUIREMENTS: PART 1: 1. Enter the December 1 beginning account balances into the respective t-accounts in the Ledger. Copy and paste, don't re-type. 2. Prepare the journal entries for December. 3. Post the journal entries to the appropriate accounts. (use cell references & formulas, don't re-type) 4. Prepare an unadjusted trial balance (use cell references & formulas, don't re-type) PART 2: * Right click on "Journal, Ledger, TB" tab; create a copy; rename it "Adj Journal, Ledger, TB". * Copy cells F24:M32 from Info tab, paste it in the new tab in cell A 88. * Delete numbers from the trial balance to prepare for next trial balance 5. Prepare appropriate

DECEMBER TRANSACTIONS & EVENTSDateTransactionAmount2-DecPaid for advertising to appear during month$ 1,0253-DecPaid for minor repairs to the company's computer system$ 5004-DecReceived cash from customer, Alex Products, on account$ 3,95010-DecPaid Suzie Burrows, our office staff employee for work performed* number of days worked6* Pay rate per day.$ 12514-DecNotified by Tyson Engineering Co. that Sunrise has won the bid to provide services.* Total bid for Tyson project. Project to begin in January$ 7,000* on Dec 14, Tyson paid a cash advance on the project$ 1,50015-DecPurchased computer supplies on credit, from Harris Office Supplies$ 1,10016-DecSent a reminder to a customer, Gomez Co. to pay its overdue account.$ 5,66820-DecCompleted the project for Liu Corporation and received immediate cash payment$ 5,62528-DecReceived partial payment from Gomez Co, on its overdue accounts$ 3,00029-DecReimbursed CEO, Reynita Santos, for business automotive mileage* number of miles drives for work activities600* mileage rate$ 0.3231-DecPaid cash dividends to stockholders$ 1,500YEAR END INFORMATION FOR POTENTIAL ADJUSTMENTa.A December 31 count of computer supplies on hand shows $580b.The Prepaid Insurance Balance represents a 12 month policy that was taken out was on Oct 1.cAs of Dec 31, Suzie Burrows has not been paid for four days of work, at the usual rated.The computer equipment, acquired Oct 1, is expected to have a 4 year life with no salvage valuee.The office equipment, acquired Oct 1, is expected to have a 5 year life with no salvage valuef.The prepaid rent balance represents a four month lease, paid in advance on Oct 1.g.The income tax rate is 25%