Month | April | May | June |
Opening balance | 25,000 | 56,000 | 47,000 |
Sales Collection | 186,000 | 150,000 | 141,000 |
Purchases payments | 144,000 | 243,000 | 246,000 |
Wages | 11,000 | 10,000 | 15,000 |
56,000 | (47,000) | (73,000) | |
Bank financing needed | (47,000) | (73,000) | |
Total | (120,000) | ||
Calculation:
Month | Feb | Mar | April | May | June |
Credit Sales | 180,000 | 192,000 | 108,000 | 174,000 | 126,000 |
Purchases | 124,000 | 144,000 | 243,000 | 246,000 | 268,000 |
Wages | 12,000 | 14,000 | 11,000 | 10,000 | 15,000 |
90,000 | 90,000 | ||||
96,000 | 96,000 | ||||
54,000 | 54,000 | ||||
87,000 | |||||
144,000 | 243,000 | 246,000 |
12 BPL Ltd., wie UPL Ltd., wishes to arrange overdrafts facilities with its bankers during the...
12B PL Ltd., wishes to arrange overdrafts facilities with its bankers during the period April to June 2018. When it will be manufacturing mostly for stock. Prepare a Cash Budget for the above period for the following data, indicating the extent of the bank facilities the company will require at the end of each month. Months Credit Sales (Rs.) Purchases (Rs.) Wages (Rs.) February 1.80,000 1.24,000 12,000 March 1,92,000 1,44,000 14.000 April 1,08,000 2,43,000 11,000 May 1.74,000 2,46,000 10,000 June...
Q 3. Prepare the cash budget of the company from January to June based on the following (15) information.(Rs.in lakh) Production Overheads 6.000 Month January February March April May June Sales 72.000 97,000 86,000 88,600 102,500 108,700 Material Purchases 25,000 31,000 25,500 30.600 37,000 38,800 Salaries & wages 10,000 12.100 10.600 25.000 22.000 23.000 6,300 6,000 6,500 8,000 8,200 Office & Sedligads 5,500 6.700 7.500 8.900 11,000 11,500 The opening cash balance for the year may be taken as Rs.72,500...
ABC Ltd is a wholesaler. The management has been extremely worried about the entity’s cash position over the last few years. In January, they sought your advice and asked you to prepare a cash budget for the forthcoming month of May. The business has provided the following information to assist in this task. Estimated total sales for the next six months to 30 June, 2019 are as follows: January February March April May June Total sales $ 152,500 $ 171,250...
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units April May June 2,520 2,460 2,360 The target ending inventory of finished products is as follows. March 31 April 30 May 31 June 30 2,050 2,230 2,100 2,300 2 units of material are required for each unit of finished product. Production for July is estimated at 2,690 units to start building inventory for the fall sales period. Rensing's policy is to have an inventory...
Bridgeport Ltd. estimates sales for the second quarter of 2017
will be as follows.
Month
Units
April
2,520
May
2,460
June
2,360
The target ending inventory of finished products is as
follows.
March 31
2,050
April 30
2,230
May 31
2,100
June 30
2,300
Two units of material are required for each unit of finished
product. Production for July is estimated at 2,690 units to start
building inventory for the fall sales period. Bridgeport’s policy
is to have an inventory...
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units April 2,600 May 2,420 June 2,320 The target ending inventory of finished products is as follows. March 31 2,010 April 30 2,270 May 31 2,100 June 30 2,360 2 units of material are required for each unit of finished product. Production for July is estimated at 2,670 units to start building inventory for the fall sales period. Rensing’s policy is to have an inventory...
Exercise 23-7 Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units 2,600 April Мay 2,500 June 2,380 The target ending inventory of finished products is as follows March 31 2,030 2,290 April 30 May 31 2,140 June 30 2,380 2 units of material are required for each unit of finished product. Production for July is estimated at 2,780 units to start building inventory for the fall sales period. Rensing's policy is to have...
Exercise 21-7
Rensing Ltd. estimates sales for the second quarter of 2017 will
be as follows.
Month
Units
April
2,560
May
2,420
June
2,340
The target ending inventory of finished products is as
follows.
March 31
2,040
April 30
2,200
May 31
2,200
June 30
2,300
2 units of material are required for each unit of finished product.
Production for July is estimated at 2,800 units to start building
inventory for the fall sales period. Rensing’s policy is to have...
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units April May June 2,550 2,675 2,390 The target ending inventory of finished products is as follows. March 31 April 30 May 31 June 30 2,000 2,230 2,200 2,310 Two units of material are required for each unit of finished product. Production for July is estimated at 2,700 units to start building inventory for the fall sales period. Rensing's policy is to have an inventory...
Sheridan Ltd. estimates sales for the second quarter of 2020 will be as follows. Month Units 2,580 April Мay 2,400 June 2,330 The target ending inventory of finished products is as follows. March 31 2,020 2,200 April 30 Мау 31 2,130 June 30 2,330 2 units of material are required for each unit of finished product. Production for July is estimated at 2,660 units to start building inventory for the fall sales period. Sheridan's policy is to have an inventory...