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:
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.