Requirement: Prepare a cash budget for the second quarter
Given:
	January (actual)	February (actual)	March (actual)	April (budget)	May (budget)	June (budget)
Sales	80,000.00	80,000.00	75,000.00	90,000.00	85,000.00	80,000.00
Purchases	45,000.00	40,000.00	42,000.00	50,000.00	45,000.00	35,000.00
Wage	20,000.00	18,000.00	22,000.00	24,000.00	20,000.00	18,000.00
Expenses	5,000.00	6,000.00	6,000.00	6,000.00	6,000.00	6,000.00
Additional Information:
a. 10% of purchase and 20% of sales are for cash
b. Average collection period of the company is 1/2 month and credit purchase is paid off regularly after one month
c. Wages are paid half monthly and the rent of $500 excluded in expense is paid monthly
d. Cash and bank balance as of April 1, was $15,000 and the company wants to keep it on end of every month , the excess cash being put in fixed deposits