|
Purchases |
Sales |
| January |
$150,000 |
$100,000 |
| February |
150,000 |
200,000 |
| March |
150,000 |
250,000 |
| April |
130,000 |
250,000 |
| May |
130,000 |
300,000 |
| June |
100,000 |
230,000 |
A cash payment equal to 50% of purchases is made at the time of purchase, and 25% is paid in each of the next 2 months. Purchases for the previous November and December were $140,000 per month. Payroll for a month is 10% of that month’s sales, and other operating expenses are 15% of the following month’s sales (July sales were $210,000). Interest payments were $25,000 paid quarterly in January and April.
Cash disbursements for the month of April were:
Cash disbursements for the month of April are calculated as follows:
April purchases: $130,000 × 50% = $ 65,000
March purchases: 150,000 × 25% = 37,500
February purchases: 150,000 × 25% = 37,500
April payroll: 250,000 × 10% = 25,000
April op. expenses: 300,000 × 15% = 45,000
Interest = 25,000
Total April disbursements = $235,000