A company is preparing a cash budget for the last three months of 2020

additional needed info to solve part c :

Budgeted Item: August September October November December Sales $465,000 $500,000 $550,000 $480,000 $530,000 $95,160 $102,520 $106,280 $99,180 $111.020 Direct Material Purchases Direct Labor Costs $ 169,920 $183,600 $ 192,960 $176,400 $ 197,640 Overhead Costs $128,020 $134,100 $138,260 $130,900 $140,340 Selling and Admin Costs $78,800 $81,600 $85,600 $80,000 $84,000 All sales are on account. All direct material purchases are on account. All costs besides direct material purchases are made as incurred. The overhead costs include $3,000 of monthly depreciation and the selling and administrative costs include $1,000 of monthly depreciation. In November, Coolidge must make an $5,000 installment payment on a note payable and must pay $7,500 of cash dividends to preferred shareholders in December. The projected beginning balance of cash on October 1 is $12,000. Coolidge would like to maintain a minimum $12,000 cash balance. Part C 1. Prepare a cash budget for October, November and December in Workpaper #5 (23 pts). 2. Based on the results of your budget, give one suggested change to the cash budget for each month (1 pt each). October: November: December: Part A Workpaper #3 1. SCHEDULE OF CASH COLLECTIONS FROM SALES August Septembe October November December 279.000 Cash Collections of CREDIT sales: 60%-Month of Sale 30%-1 Month after Sale 10% -2 Months after Sale Total Collections of Credit Sales 300,000 139,500 330,000 150,000 46,500 288,000 165,000 50,000 318,000 144,000 55,000 Part B Workpaper #4 1. SCHEDULE OF CASH PAYMENTS FOR DIRECT MATERIAL PURCHASES August Septembe October November December 85,644 Cash Payments: 90%-Month of Purchase 10%-1 Month After Purchase Total Cash Payments for DM 92,268 9,516 101.784 95,652 10,252 105,904 89,262 10,628 99,890 99,918 9,918 109,836