The marketing department of Jessi Corporation has submitted the following sales budget for the upcoming fiscal year:

Q1 Q2 Q3 Q4

Budgeted Sales ($) $319,600 $387,600 $455,600 $421,600

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

The company expects to start the first quarter with 2,700 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,950 units.

a) Prepare the schedule of cash collections for the upcoming year by quarter, including the total for the year.

b) Prepare the production budget for the upcoming year by quarter, including the total for the year.