please complete all parts

The marketing department of Graber Corporation has submitted the following sales forecast for the upcoming fiscal year. Budgeted unit sales First Quarter Second Quarter Third Quarter Fourth Quarter 16,500 15,500 14,500 15,500 The selling price of the company's product is $25.00 per unit. Management expects to collect 80% of sales in the quarter in which the sales are made and 15% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning balance of accounts receivable, all of which is expected to be collected in the first quarter, is $71,000. The company expects to start the first quarter with 3,700 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 10% of the next quarter's budgeted sales. The desired ending finished goods inventory for the fourth quarter is 3,900 units. Required: 1-a. Compute the company's total sales. Answer is complete but not entirely correct. Year 1st Quarter IS 16,500 2nd Quarter IS 15,500 3rd Quarter 14,500 Total Sales 4th Quarter $ 15,500 IS $ 62.000 1-b. Complete the schedule of expected cash collections. Answer is complete but not entirely correct. 3rd Year 1$ Accounts receivable, beginning balance 1st Quarter sales 2nd Quarter sales 3rd Quarter sales 4th Quarter sales Total cash collections Graber Corporation Schedule of Expected Cash Collections 1st Quarter 2nd 4th Quarter Quarter Quarter 71,000 330,000 $ 82,500 310,000 $ 58,125 290,000 $ 54,375 310,000 401,000 $ 392 500 $ 348,125 $ 364,375 71,000 412.500 368,125 344 375 310,000 $ 1,506,000 2. Prepare the company's production budget for the upcoming fiscal year. Answer is not complete. Graber Corporation Production Budget 2nd 3rd Quarter Quarter 1st Quarter 4th Quarter Year Budgeted unit sales Total units needed 0 0 0 0 0 Required production 0 0 o 0 0