please prepare the schedule of expected cash collections. ASAP

Editing Brookes Inc, manufactures basketballs for $20/unit. Brookes Inc. budgets on a quarterly basis and the sales department has budgeted for the following sales: Q1 Q2 Q3 Q4 10,000 11,000 12,000 14,000 > Please prepare the Sales Budget. Sales Budget For the year ended December 31, 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Expected Sales (units) 10,000 11,000 12,000 14,000 47,000 20 20 20 20 20 Selling Price (S/unit) Total Budgeted Sales $200,000 $220,000 $240,000 $280,000 $940,000 1 Brookes Inc does not collect all of the sales revenue in the period of sale. The accounts receivable department has budgeted for % of sales revenue to be collected in the period of sale and 15% to be collected in the next period. The accounts receivable beginning balance is SRO,000. Please prepare the schedule of Expected Cash Collections. Schedule of Expected Cash Collections Quarter 2 Quarter 3 Quarter 1 Quarter Year Accounts Receivable, beginning balance 80,000 90,000 First quarter sales Second quarter sales Third quarter sales Fourth quarter sales Total cash collections