Can anyone help me with section B (Cash Budget Table)? I started trying to enter the numbers but I am getting lost. Thank you in advance!

Problem 21-4A (Part Level Submission) Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2014 are: Sales Direct materials purchases Direct labor Manufacturing overhead Selling and administrative expenses January $397,950 125,070 102,330 79,590 89,823 February $454,800 147,810 113,700 85,275 97,782 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases are paid in cash in the month of purchase, and the balance due is paid in the month following the purchase. All other items above are paid in the month incurred except for selling and administrative expenses that include $1,137 of depreciation per month. Other data: 1. 2. 3. Credit sales: November 2013, $295,620; December 2013, $363,840. Purchases of direct materials: December 2013, $113,700. Other receipts: January-Collection of December 31, 2013, notes receivable $17,055; February-Proceeds from sale of securities $6,822. Other disbursements: February-Payment of $5,685 cash dividend. 4. The company's cash balance on January 1, 2014, is expected to be $68,220. The company wants to maintain a minimum cash balance of $56,850. (a) Your answer is correct. Prepare schedules for (1) expected collections from customers and (2) expected payments for direct materials purchases for January and February. Expected Collections from Customers January February November 59,124 0 December 109,152 72,768 January 198,975 119,385 February 0 227,400 Total collections 367,251 419,553 Expected Payments for Direct Materials January February December 45,480 0 January 75,042 50,028 February 0 88,686 Total payments 120,522 138,714 COLTER COMPANY Cash Budget For the Two Months Ending February 28, 2014 January February Beginning Cash Balance 68,220 $ Add v Receipts Collections from Customers 367,251 419,553 Notes Receivable 17,055 Sale of Securities 0 6,822 Total Receipts 384,306 426,375 Total Available Cash Less : Disbursements Direct Materials 120,522 138,714 Direct Labor 102,330 113,700 Manufacturing Overhead 79,590 85,275 Selling and Administrative Expenses 89,823 97,782 Cash Dividend 0 5,685 Total Disbursements Excess (Deficiency) of Available Cash Over Cash Disbursements Financing Add v : Borrowings Less : Repayments Ending Cash Balance