Required information Tableau DA 3-3: Mini-Case, Analyzing adjusting entries and preparing an adjusted trial balance LO P5 [The following information applies to the questions displayed below.) Roland Company began operations on December 1 and needs assistance in preparing December 31 financial statements, including its year-end adjustments. The Tableau dashboard is provided to assist in the work. Selected December-January Transactions Dec. 31 Year-End Finished Work to Telo Purchased Insurance Started Work for Telo Deg Jan 12 (Dec 7) Dec 13 Dec 24 Jan 5 December 1 Prepaid a 24 month insurance policy (coverage starting immediately) for $2,400 cash. Purchased Supplies Received Cash in Advance Wages Paid Additional Information as of December 31 Required information Tableau DA 3-3: Mini-Case, Analyzing adjusting entries and preparing an adjusted trial balance LO P5 [The following information applies to the questions displayed below) Roland Company began operations on December 1 ond needs assistance in preparing December 31 financial statements, including its year-end adjustments. The Tableau dashboard is provided to assist in the work. Selected December-January Transactions Purchased insurance Started work for Telo Dec. 31 Year-End Jan 5 Dec 1 Dec 13 Dec 7 Dec 24 Jan 12 December 7 Purchased supplies for $2,000 cash. Purchased Supplies Received Cash In Advance Wages Paid Additional Information as of December 31 Saved Required information Tableau DA 3-3: Mini-Case, Analyzing adjusting entries and preparing an adjusted trial balance LO P5 [The following information applies to the questions displayed below) Roland Company began operations on December 1 and needs assistance in preparing December 31 financial statements, including its year-end adjustments. The Tableau dashboard is provided to assist in the work, Selected December-January Transactions Purchased insurance Started work for Telo Dec. 31 Year-End (Dec 1 (Dec 7 Dec Dec 24 Jan 5 Jan 12 my December 13 Agreed to do $10,000 worth of work for Telo over the next 30 days. Payment is to be received when the work is completed on Jan 12 Purchased Supplies Received Cash in Advance Wages Pald Additional Information as of December 31 Saved Required information Tableau DA 3-3: Mini-Case, Analyzing adjusting entries and preparing an adjusted trial balance LO P5 (The following information applies to the questions displayed below.) Roland Company began operations on December 1 and needs assistance in preparing December 31 financial statements, including its year-end adjustments. The Tableau dashboard is provided to assist in the work Selected December-January Transactions Purchased Insurance Dec. 31 Year-End Started work for Telo Dec 1 (Dec 7 Jan 2 Dec 13 (Dec 24h Jan 5 December 24 Received $4,000 cash in advance to perform work for ABX over the next four weeks. Purchased Supplies Received Cash in Advance Wages Paid Additional Information as of December 31 Required information Tableau DA 3-3: Mini-Case, Analyzing adjusting entries and preparing an adjusted trial balance LO PS [The following information applies to the questions displayed below.) Roland Company began operations on December 1 and needs assistance in preparing December 31 financial statements, including its year-end adjustments. The Tableau dashboard is provided to assist in the work Selected December-January Transactions Purchased Insurance Started Work for Telo Dec. 31 Year-End bed work for TO Dec 1 (Dec 7 Dec 13 Dec 24 January 5 Paid wages of $800 cash to workers Purchased Supplies Received Cash in Advance Wages Paid Additional Information as of December 31 needs assistance in preparing December 31 financial statements, ts. The Tableau dashboard is provided to assist in the work. ted December-January Transactions Work for Telo Dec. 31 Year-End Finished Work for Telo ec 13 Dec 24 Jan 5 Jan 12 January 12 Received $10,000 cash from Telo for work performed over the last 30 days. Received Cash in Advance Wages Paid nal Information as of December 31 Saved Dec 1 Dec2 De 24 Jan 5 Parched Sup Received Cash in Advance Wages Paid Additional Information as of December 31 Telo Job Completion at Year-End ABX Job Completion at Year-End Telo 60% Complete ABX 25% Complete Supplies Remaining at Year-End Wages Earned By Workers but not Supplies Remaining at Year-End: $700 tableau plies Remaining at Year-End Wages Earned By Workers but not yet Paid at Year-End Wages Earned By Workers but not yet Paid at Year-End: 500 imtina antrier using accounting equation Tableau DA 3-3: Mini-Case, Analyzing adjusting entries using accounting equation 2 1. For each December 31 adjusting entry, indicate the account impacted along with the amount and direction - or -) of the effects on the accounting equation by filling in the following table. The first entry is completed. 1 Liabilities Assets -5100 Prepaid insurance Equity -$100 insurance expense . Adusting Entry a. Prepaid Insurance b. Supplies c. Accrued Wages d. Accrued Revenue e. Uneamed Revenue Tableau DA 3-3: Mini-Case, Preparing an adjusted trial balance 2. Enter the December 31 adjustments in the following table for prepaid insurance, supplies, accrued wages, accrued revenue, and unearned revenue. Then, complete the adjusted trial balance by entering the adjusted balance for each of the accounts. Adjustments Adjusted Trial Balance Dr. CI. Dr. $ No Account Title 101 Cash 106 Accounts receivable 126 Supplies 128 Prepaid insurance 210 Wages payable 236 Unearned revenue 301 Common stock 404 Revenue Unadjusted Trial Balance Dr. Cr. 9,600 0 2,000 2,400 $ 4,000 10,000 0 0 623 Wages expense 637 Insurance expense 652 Supplies expense Total 0 0 14,000 $ $ $ 14 000 $ 0$ 0 $
