6) The following information pertains to Crockett Corporation: Month Sales Purchases July $30,000 $10,000 August 34,000 12,000 September 38,000 14,000 October 42,000 16,000 November 48,000 18,000 December 60,000 20,000 Cash is collected from customers in the following manner: Month of sale Month following sale 40% 50% 10% Two months following sale 80% of purchases are paid for in cash in the month of purchase, and the balance is paid the following month. Required: Complete the cash budget for the 4th quarter. Beginning Balance: Cash Collections from: August September October November December Total Cash Collections Cash Payments from: September October November December Total Cash Payments Change in Cash Ending Cash Balance October November December $10,000 30200 52800 16000 -17