The Company has projected sales as follows: Sales September October November December January $ 70,000 $ 80,000 $ 90,000 $ 1,00,000 $ 70,000 Other information:

1. ACME collects 70% of its sales in the month of the sale, 20% in the second month and 10% in the third month.

2. ACME purchases and pays for raw materials one month in advance of its sales. The purchases are 50% of sales.

3. ACME pays $8,000 rent each month for its factory.

4. ACME pays $5,000 other costs each month.

5. A tax prepayment of $40,000 is due in October.

6. ACME has a line of credit with it's local bank for $500,000 at 12% interest, and must maintain a bank balance of $10,000

7. At September 30th, it had borrowed $40,000 on its LOC, and had a bank balance of $10,000

a. Prepare a cash budget for the last quarter of the year (October - December)

b. Will the ACME have its LOC paid off by 12/31?