Question

12 BPL Ltd., wie UPL Ltd., wishes to arrange overdrafts facilities with its bankers during the period April to June 2018. Whe
0 0
Add a comment Improve this question Transcribed image text
Answer #1
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
Add a comment
Know the answer?
Add Answer to:
12 BPL Ltd., wie UPL Ltd., wishes to arrange overdrafts facilities with its bankers during the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 12B PL Ltd., wishes to arrange overdrafts facilities with its bankers during the period April to...

    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...

    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...

    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...

    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...

    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...

    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....

    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....

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
Active Questions
ADVERTISEMENT