The following information for ABCs Projects is available:

	MARCH	APRIL	MAY	JUNE	JULY	AUGUS T
Cash revenue	180 000	200 000	250 000	290 000	320 000	350 000
Credit revenue	380 000	410 000	500 000	560 000	560 000	600 000
Total purchases	320 000	340 000	385 000	432 000	445 000	460 000
Salaries and wages	63 000	63 000	63 000	63 000	63 000	63 000
Other expenses	12 000	12 500	12 500	14 500	54 800	59 000

Additional information:

1. 1. Credit revenues are collected as follows:
      • 50% within 30 days (the next month)
      • 25% within 60 days
      • 15% within 30 days
      • 10% uncollectible (bad debt)
   2. The following discount is given on revenues:
      • 10% on all cash revenue
      • 5% on credit revenue paid within 30 days
   3. Salaries, wages and other expenses are paid in cash.
   4. Other expenses include depreciation of $4 000 per month.
2. 5. 55% of all purchases are on credit and are paid for in the following month. The rest represents cash purchases.
   6. The bank balance of ABCs Projects on 1 June is $200 000.
   7. A dividend of $3 000 will be declared on 31 August.

Required:

Prepare the cash budget for the months June, July and August (Use separate columns for June, July and August).