Question 6: Master Budgeting Time: 20 minutes Total: 10 marksMagna Corporation has prepared the following sales budget.MonthJanFebMarchAprilMayCash Sales$15,00020,00028,00034,00032.000Credit Sales$68,00080,00074,00092,00076000Collections are 30% in the month sale, 50% in the month following the sale, and 10% two months following the sale. The remaining 10% is expected to be uncollectible.RequiredPrepare a schedule of cash collections for March through May

Styles Question 6: Master Budgeting Time: 20 minutes Total: 10 marks Magna Corporation has prepared the following sales budget: Month Cash Sales Credit Sales Jan $16,000 $68,000 Feb 20,000 80,000 March 28,000 74,000 April 34,000 92,000 May 32,000 76,000 Collections are 30% in the month of sale, 50% in the month following the sale, and 10% months following the sale. The remaining 10% is expected to be uncollectible. Required: Prepare a schedule of cash collections for March through May