For Homework Assignment! Please Help.

General Data

1. Sales are 25% cash, 75% credit

2. Of the credit sales 80% are collected in the month following the month of sale and 20% in the second month following the sale.

3. Gross profit margin on sales averages 25% i.e., the COGS is 75% of sales

4. All inventory purchases are paid during the month in which they are made.

5. The store follows the policy of purchasing enough inventory each month to cover the following months sales at cost.

6. A minimum cash balance of $5,000 is to be maintained by the store.

7. A $15,000 dividend payment will be made in January.

8. The cash balance as of July 31 is $10400

9. Sales budget August $1400 Sept $26000 October 22,000 Nov 38000 Dec 48000 Jan 18000 Feb 16000

10. Monthly expenses wages Aug 1400 Sept 1600 Oct 1600 Nov 1800 Dec 1800 Jan 1400

Other monthly expenses rent 400 depreciation 120 other 1% of sales (paid as incurred)

What is the total expected cash inflow for November? (round to 0 decimal places)