Quillin company had the following budgeted information for october: 1. octo

Quillin company had the following budgeted information for october:

1. october 1 cash balance $3500

2. expected sales 2500 units at $25 each (half in cash remainder on credit due in november)

3. inventory purchases 3000 units at $14 each (all in cash)

4. rent $1450

5. payroll $1000

6. utilities and other costs $4500

7. SG&A $15000 including $2000 of depreciation

8. accounts receivable balance oct. 1 $35000 (includeds $700 bad debts allowance)

Quillen Co. requires an ending cash balance of $10000

Prepare a cash budget for october