Alex Gowell Corporation (AGC) is planning to request a line of credit from its bank and wants to estimate its cash needs for the month of September 2020. The following sales forecasts have been made for 2020:

August $400,000 September $300,000 October $300,000 November $200,000 December $200,000

Collection estimates were obtained from the credit collection department as follows:

20% collected within the month of sale; 68% collected the first month following the sale; 10% collected the second month following the sale and the remaining will be uncollectible.

Total labour and raw material costs will be 50% of monthly sales and are typically settled in the month in which they are incurred.

General administrative expenses are $40,000 and $44,000 for the months of October and November respectively.

The corporation tax rate is 40%. Estimated tax liability are to be paid quarterly (i.e. March, June, September and December), though adequate provisions are to be made every month for taxes.

Prepare a cash budget for October and November 2020, assume the ending cash balance in September will be $16,000.