Please answer this Question

1b. Prepare a schedule of expected cash collections

The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year: 1st 2nd 3rd 4th Quarter Quarter Quarter Quarter Budgeted sales (units) 8, 600 10, 600 12, 600 11, 600 The selling price of the company's product is $26 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made and 30% 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 $86,500. The company expects to start the first quarter with 2,300 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 2,550 units. Required: 1-a. Prepare the company's sales budget. JESSI CORPORATION Sales Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Total sales