Please fill it out in the following excel sheet format. Thank you

1. Prepare journal entries for the following unrelated transactions (enter 30 Nov, 2021 as date for the entries) a. Received a $750 check in the mail for services previously rendered on account b. The employees earn $625 per day as wages, No employee works on Saturday or Sunday. Weekly pay day is every Friday. Tuesday is the month-end. The company prepares monthly financial reports C. Month-end physical count of the office supply shows a balance of $725. Trial balance shows a previous month balance of $1,750. $329 purchase during the month d. Office equipment was purchased for $8,253 with an estimated service life of 3 years. Accumulated depreciation on the equipment is $3,897.25. Estimated salvage value is $0. The company prepares monthly financial reports. e. The company purchased merchandise inventory for $7,550, terms 2/10, 1/30, FOB shipping point. As requested by the seller, a shipping charge of $750 was paid to the shippers by the purchaser on arrival of the goods. f. The company received $7,500 in cash for services that will be rendered in the next 3 months. g. On the first day of the month, the company paid $6,000 to the Janitor for the next 6 months of service. h. Paid freight charges of $120 to the shipper for a supply of merchandise inventory. The shipping terms were 2/10, 1/20, FOB shipping point. The company follows periodic inventory 2 Year-end unadjusted Trial Balance information(not in proper form) is provided below Green Environmental Consultants Unadjusted trial balance October 31, 2021 101 Cash 106 Accounts receivable 109 Interest receivable 111 Notes receivable 126 Supplies 128 Prepaid insurance 131 Prepaid rent 161 Office furniture $26,000.00 $61,000.00 50.00 $50,000.00 $5,300.00 $3,400.00 $27,000.00 584,000.00 162 Accumulated depreciation office furniture 201 Accounts Payable 210 Wages Payable 233 Unearned consulting revenue 301 Jeff Moore Capital 302 Jeff Moore, Withdrawals 401 Consulting revenue 409 Interest income 601 Depreciation expense, office furniture 622 Wages expense 637 Insurance expense 640 Rent expense 650 Supplies expense $28,000.00 $18,000.00 $0.00 $26,000.00 $223,000.00 $28,000.00 $232,020.00 $480.00 $0.00 5192,000.00 50.00 544,000.00 56,800.00 Adjustments: a. The balance in the Prepaid Rent account represents three months of rent beginning September 1, 2021 Accrued consulting revenue at year-end totalled 54 200 Interest of 585 had accrued on the notes receivable for the month of October d. A count of the supplies on October 31 revealed a balance of $620 Required: Prepare necessary journal entries, prepare an income statement c Date A/C Title and Explanation PR Dr. Cr