Ung penoa Information) Many Tree Industries Inc. is a locally owned forestry supply company based in Kamloops, B.C. You have been recently added to the accounting team and you observe the tollowing sales, production and cash collections data for the 2020/2021 budget: Forecast cash collections: In month of sale In the first month after sale In the second month after sale Bad debt (Uncollectible) 49% 36% 12% 3% Month July 2020 August 2020 September 2020 October 2020 November 2020 December 2020 January 2021 February 2021 March 2021 April 2021 May 2021 June 2021 Sales $ $ 288,700 $ 257,700 $ 271,900 $ 257,600 $ 244,400 $ 296,000 $ 284,500 $ 212,200 $ 247,300 $ 264,600 $ 265,400 $ 238,200 100% (ALL) Sales are on credit Required (Note: a grade of zero will be awarded for presenting the wrong period information) Please complete the following three questions: a) Prepare a table of the expected cash collections schedule during the month of December 2020. (4 marks) b) Prepare a table of the expected cash collections schedule during the first (1st) quarter of 2021. (9 marks) c) What is the net balance in Accounts Receivable at the BEGINNING of the first (1st) quarter? HINT: already calculated (2 marks)