Question 4: (10 Marks) 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 September October November 370 DO $400,000 $300,000 $300,000 December $200,000 $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. UP 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.