The marketing department of Kyle Corporation has submitted the following sales forecast for the upcoming fiscal year:

$\backslash$table$[[,1$st$,2$nd$,3$rd$,4$th$],[$Budgeted sales $($units$),$Quarter,Quarter,Quarter,Quarter$],[,9,900,11,900,13,900,12,900]]$

The selling price of the company's product is $$39$ per unit. Management expects to collect $55\%$ of sales in the quarter in which the sales are made and $40\%$ in the following quarter; $5\%$ of sales are expected to be uncollectible. The beginning balance of accounts receivable, all of which are expected to be collected in the first quarter, is $$99,500.$

The company expects to start the first quarter with $2,950$ units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to $15\%$ of the next quarter's budgeted sales. The desired ending finished goods inventory for the fourth quarter is $3,200$ units.

Required:

$1-$a$.$ Prepare the company's sales budget.

$\backslash$table$[[$Kyle Corporation$],[$Sales Budget,,,,,$],[$Total sales,$1$st Quarter,$2$nd Quarter,$3$rd Quarter,$4$th Quarter,Year$],[,,,,,]]$

$1-$b$.$ Prepare the schedule of expected cash collections.

$\backslash$table$[[$Kyle Corporation$],[$Schedule of Expected Cash Collections$],[,1$st Quarter,$2$nd Quarter,$3$rd Quarter,$4$th Quarter,Year$],[$Accounts receivable, beginning balance,$$,99,500,$$$,213,525,,231,255,,253,305,$$$,229,635],[1$st Quarter sales,,,$8,,,195,880,,212,175,,],[2$nd Quarter sales,,T$,n,,,,,216,840,,],[3$rd Quarter sales,,,,,,,,,,$],[4$th Quarter sales,,,,,,,,,,$],[$Total cash collections,$$,99,500,$$$,213,525,$$$,427,135,$$$,682,320,$$$,229,635]]$