Prepare a Cash Budget in respect of six months from July to December from the following information.
|
Month |
Sales Rs.000 |
Mat. Rs.000 |
Wages Rs.000 |
Production O/H Rs.000 |
Admn O/H Rs. |
Selling O/H Rs |
Dist. O/H Rs |
R & D O/H Rs |
|
April |
100 |
40 |
10.0 |
4.4 |
3,000 |
1,600 |
800 |
1,000 |
|
May |
120 |
60 |
11.2 |
4.8 |
2,900 |
1,700 |
900 |
1,000 |
|
June |
80 |
40 |
8.0 |
5.0 |
3,040 |
1,500 |
700 |
1,200 |
|
July |
100 |
60 |
8.4 |
4.6 |
2,960 |
1,700 |
900 |
1,200 |
|
Aug. |
120 |
70 |
9.2 |
5.2 |
3,020 |
1,900 |
1,100 |
1,400 |
|
Sept |
140 |
80 |
10.0 |
5.4 |
3,080 |
2,000 |
1,200 |
1,400 |
|
Oct |
160 |
90 |
10.4 |
5.8 |
3,120 |
2,050 |
1,250 |
1,600 |
|
Nov |
180 |
100 |
10.8 |
6.0 |
3,140 |
2,150 |
1,350 |
1,600 |
|
Dec |
200 |
110 |
11.6 |
6.4 |
3,200 |
2,300 |
1,500 |
1,600 |
The cash balance as on 1st July was expected Rs.1, 50, 000