Prepare a Cash budget for the Quarter April to June based on the following data and...

Transcribed Image Text:

Prepare a Cash budget for the Quarter April to June based on the following data and additional information. Month Sales ($) Purchase (5) wages (5) Overheads (5) Jan 70,000 38,000 7,000 12,000 Feb 52,000 40,000 8,000 5,500 Mar 59,000 42,000 10,000 13,500 Apr 63,000 44,000 11,500 7,400 May 36,000 46,000 9,000 9,500 Jun 65,000 48,000 8,000 9,000 Additional Information Cash balance at 1 April is $775,000 1. Sales is 40% cash sales and 60% is collected in the following month. 2. All purchases of a month are paid after 3 months. 3. Land was purchased in May for $115,000 4. Wages of a month are paid the following month. All overheads are paid after 2 months. 5. Loan repaid in June was $84.000 Prepare a Cash budget for the Quarter April to June based on the following data and additional information. Month Sales ($) Purchase (5) wages (5) Overheads (5) Jan 70,000 38,000 7,000 12,000 Feb 52,000 40,000 8,000 5,500 Mar 59,000 42,000 10,000 13,500 Apr 63,000 44,000 11,500 7,400 May 36,000 46,000 9,000 9,500 Jun 65,000 48,000 8,000 9,000 Additional Information Cash balance at 1 April is $775,000 1. Sales is 40% cash sales and 60% is collected in the following month. 2. All purchases of a month are paid after 3 months. 3. Land was purchased in May for $115,000 4. Wages of a month are paid the following month. All overheads are paid after 2 months. 5. Loan repaid in June was $84.000