Question
Prepare the Cash Budget of Project R for June, July and August. The following are forecasted sales schedule of Project M for the five months
Prepare the Cash Budget of Project R for June, July and August.
The following are forecasted sales schedule of Project M for the five months ended 31 August :
April R100 000
May R130 000
June R150 000
July R160 000
August R210 000
- Cash sales usually comprise 70% of the total sales.
- The remaining sales are on credit and these are collected as follows:
- 30% in the month of the sale, with a 5% cash discount applicable;
- 70% in the month after the sale.
3. The monthly purchases of materials equal 25% of the sales value of the same month (before any discounts) but are paid for two months after the month of purchase.
4. Fixed production overheads, excluding depreciation of R3 000, amount to R20 000 per month and they are payable in the month in which they are incurred.
5. Marketing overheads as a fixed percentage of the monthly sales value (before discounts) will be maintained during the budgeted period. Marketing overheads for May are expected to amount to R19 500. Marketing overheads are paid at the end of the applicable month.
6. Production salaries and wages are budgeted at R25 000 per month and are paid for in the applicable month. Employees are entitled to a 10% increase in remuneration with effect from 01 July.
7. A packing machine that costs R50 000 is expected to be purchased on credit on 31 July. A deposit of R10 000 will be paid on 31 July and the balance plus finance charges of R5 000 will be paid in 10 equal monthly instalments commencing 31 August.
8. A favourable bank balance of R18 000 is expected on 31 May.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started