The following transactions happen during the month of December, 2023: Dec 1 2 9 11 12 14 21 23 27 28 29 30 31 31 You paid the November interest owing on the bank loan. You issued cheque # 317. You collected $750 cash from a customer, on account, to whom you had previously sold a juicing machine. You paid the November 30 balance of accounts payable. You issued cheque # 318. You purchased, on account, 3 more juicing machines for $675 each (excluding freight). The purchase invoice also included a $65 freight charge for the cost of transporting the machines from the vendor to your place. NOTE: Since you will use the FIFO cost-flow assumption, you should make a "FIFO Inventory Record" (See textbook Illustration 6.5) for your Juicing Machine inventory. You buy $205 of supplies such as protein powder, cups, straws, and fresh fruit and vegetables, on account. You sold, on account, 2 juicing machines to Bill's Fitness for $950 each. You will use the FIFO method of recording inventory transactions. You make and deliver a batch of juice drinks to Fred's Yoga Studio and you issue a sales invoice of $425. The invoice is payable in 30 days. You paid the amount owing on the December 11 purchase. You issued cheque # 319. You purchased, on account, 2 more juicing machines for $685 each (excluding freight). The purchase invoice also included a $55 freight charge for the cost of transporting the machines from the vendor to your place. You paid $115 cash for repairs done to some equipment. You issued cheque # 320. You sold, on account, 4 juicing machines to the owners of City Contemporary Dance Studio (Remember that freight is part of inventory). The selling price of each machine was $950. You received a $105 e-bill for your business cell phone service for December and you paid it immediately. You issued cheque # 321. You collected the full amount from the customer who purchased juicing machines on on Dec. 14. You paid a casual worker $95 cash for wages for work done in December. You issued cheque #322. Instructions - Using a NEW Excel file 'Term Project Part 5 Excel Template' (in 'Term Project' folder in Moodle), complete the following: a. Prepare the FIFO inventory worksheet to determine the cost of goods sold and ending inventory resulting from the inventory purchases and sales noted in the transactions above. You will need the cost of goods sold from the worksheet to complete the journal entry for the sales on December 14th and 29th, HINT: Be sure you research how to properly account for the freight costs in the purchase transactions. In this case, the cost of the freight is included in the same transaction as the merchandise purchases. b. Prepare the journal entries for the transactions that occurred in December, 2023. For transactions affecting 'Cash', include the cheque number in the explanation. c. Post the journal entries to the general ledger. d. Prepare an Unadjusted Trial Balance. 110 130 135 Merchandise inventory 140 Supplies 160 161 210 230 240 245 260 310 320 410 505 508 515 527 540 550 Cashi Accounts receivable 563 570 Equipment Accumulated depreciation Accounts payable Unearned revenue Wages payable Interest payable Notes payable capital drawings Sales revenue Cost of goods sold Advertising expense Depreciation expense Interest expense Repairs expense Supplies expense Telephone expense Wages expense Totals Debit 4,000 1,575 3,325 265 7,350 4,895 7,450 780 1,675 290 95 315 335 675 33,025 Credit 1,825 125 875 75 25 6,000 10,250 13,850 33,025 Notes: The $3,325 merchandise inventory balance is comprised of 5 juicing machines that cost $665 each The notes payable is to the bank and interest is paid on the 1st day of each month (ie. expensed and accrued at the end of each month, then paid the following day). You paid off the loan to your mother early in 2023.