MBAC 5103 Al Part 3-520.pdf X MBAC 5101 A1 - 01-Jul-2020 + 158.00 POFT Q G D Date Dec 3 3 4 10 14 17 18 20 Transaction Paid $1,500 for advertising on the local radio station Paid $1,200 to repair the company computer Received $3,000 for the final payment on the November 12th billing Paid Bob Smith for 6 days of work Signed a contract to complete $15,000 of computer work for XYZ Co. XYZ paid $4,000 in advance on December 14th Purchased $1,800 of computer supplies on credit Received $5,000 from Y Co for the November 28 billing Received a cash payment of $7,000 from Z Co for work completed in December Took the week off to celebrate Christmas Paid Joseph for 800 km of business mileage at a rate of $.80/km Paid Joseph a $4.000 dividend Billed Y Ltd $2,000 for work completed in December 24-28 31 31 31 Additional information: . 4 3 4 7 9 0 5 8 7 O P U V E MBAC 5103 A1 Part 3-520.pdf x SMEAC 5101 A1 - 01-N-2020 + 15 158.0 POED 31 1 Q DOBRE A EM Billed Y Ltd $2,000 for work completed in December Additional information: a. Of the $4,000 advance payment received from XYZ Co, $2,500 has been earned b. A count of supplies on December 31 revealed $700 of supplies on hand c. Bob Smith worked for 10 days in December which have not been paid d. A project for T Ltd was completed in December but the $5,000 was not billed Part B Requirements: 1. Prepare a tabular analysis of all the November transactions. Include dates and descriptions to help organize your work. (11 marks] 2. Enter any month-end adjustments (accruals and deferrals) into the table, including dates and descriptions. [14 marks] 3. Prepare an income statement for the month ended November 30, 2020 (10 marks 4. Prepare a retained earnings statement for the month ended November 30, 202015 marks 5. Prepare a balance sheet as at November 30, 2020. [20 marks mo De 4 3 9 5 7 0 U O 7 P MBAC 5103 Al Part 3-520.pdf X MBAC 5101 A1 - 01-Jul-2020 + 158.00 POFT Q G D Date Dec 3 3 4 10 14 17 18 20 Transaction Paid $1,500 for advertising on the local radio station Paid $1,200 to repair the company computer Received $3,000 for the final payment on the November 12th billing Paid Bob Smith for 6 days of work Signed a contract to complete $15,000 of computer work for XYZ Co. XYZ paid $4,000 in advance on December 14th Purchased $1,800 of computer supplies on credit Received $5,000 from Y Co for the November 28 billing Received a cash payment of $7,000 from Z Co for work completed in December Took the week off to celebrate Christmas Paid Joseph for 800 km of business mileage at a rate of $.80/km Paid Joseph a $4.000 dividend Billed Y Ltd $2,000 for work completed in December 24-28 31 31 31 Additional information: . 4 3 4 7 9 0 5 8 7 O P U V E MBAC 5103 A1 Part 3-520.pdf x SMEAC 5101 A1 - 01-N-2020 + 15 158.0 POED 31 1 Q DOBRE A EM Billed Y Ltd $2,000 for work completed in December Additional information: a. Of the $4,000 advance payment received from XYZ Co, $2,500 has been earned b. A count of supplies on December 31 revealed $700 of supplies on hand c. Bob Smith worked for 10 days in December which have not been paid d. A project for T Ltd was completed in December but the $5,000 was not billed Part B Requirements: 1. Prepare a tabular analysis of all the November transactions. Include dates and descriptions to help organize your work. (11 marks] 2. Enter any month-end adjustments (accruals and deferrals) into the table, including dates and descriptions. [14 marks] 3. Prepare an income statement for the month ended November 30, 2020 (10 marks 4. Prepare a retained earnings statement for the month ended November 30, 202015 marks 5. Prepare a balance sheet as at November 30, 2020. [20 marks mo De 4 3 9 5 7 0 U O 7 P