do it according to the table

Montero Corporation, a merchandising company, has provided the following budget data: Sales January February March April May Purchases $42,000 48,000 36,000 54,000 60,000 $72,000 66,000 60,000 78,000 66,000 Collections from customers are normally 70% in the month of sale, 20% in the month following the sale, and 9% in the second month following the sale. The balance is expected to be uncollectible. Montero pays for purchases in the month following the purchase. Cash disbursements for expenses other than merchandise purchases are expected to be $14,400 for May. Montero's cash balance at May 1 was $22,000. Required (show all calculations), a. Compute the expected cash collections during May. b. Compute the expected cash balance at May 31. [Hint: use the table format below for part a & b - Enable the HTML Editor to write your answer] Month Sales Expected Collections Sx $xx Sx Sxx Sx x% Sxx Total Sxx Balance, May 1 Sxx Expected collections XX Collections from customers are normally 70% in the month of sale, 20% in the month following the sale, and 9% in the second month following the sale. The balance is expected to be uncollectible. Montero pays for purchases in the month following the purchase. Cash disbursements for expenses other than merchandise purchases are expected to be $14,400 for May. Montero's cash balance at May 1 was $22,000. Required (show all calculations): a. Compute the expected cash collections during May. b. Compute the expected cash balance at May 31. (Hint: use the table format below for part a & b - Enable the HTML Editor to write your answer] Month Sales Expected Collections Sx Sxx Sx x % = Sxx Sx x% = $xx Total $xx Sxx XX Balance, May 1 Expected collections Expected disbursements April purchases to be paid in May Cash disbursements for expenses Total disbursements Sxx XX XX XX Expected ending balance $xx