Astro company is preparing a budget for the fourth quarter of the year 2017. The following information is available: All sales are made on account The accounts receivable are collected as follows: 20% in the month of sale; 70% in the month following the sale; and 10% in the second month following the sale. All purchases of direct materials are on account. The purchases on account are paid as follows: 60% in the month following the purchase; and 40% in the second month following the purchase. All other costs are paid as Incurred. The overhead costs Include dollar3,000 of monthly deprecation and the selling and administrative costs Include dollar1,000 of monthly depreciation. The projected beginning cash balance on October 1 is dollar5,000. Astro Company would like to maintain a dollar 5,000 ending cash balance each month. REQUIRED: Prepare a schedule of cash collections from sales for October, November, and December. Determine the expected accounts receivable balance on December 31. Prepare a schedule of cash payments for direct material purchases for October, November, and December. Determine the expected accounts payable balance on December 31. Prepare a cash budget for October, November, and December. Based on the results of your budget, do you think some additional cash planning is required? Give possible suggestions for amending the cash budget