Use the information provided below to prepare the following for May and June 2025: Debtors Collection Schedule Cash Budget. The following information was provided by Lewis Traders:1. An unfavourable bank balance of R40 000 is expected on 30 April 2025. 2. Budgeted credit sales for April to June 2025 are as follows: April R420 000 May R372 000 June R432 000 3. Credit sales are estimated to be 60% of the total sales. The balance of the sales is for cash. Customers who purchase for cash are entitled to a discount of 10%.4. Collections from credit sales are expected to be as follows:• 30% during the month of sale (These debtors receive a 5% discount.)• 70% in the following month.5. Budgeted purchases of inventories from April to June 2025 are as follows: April R360 000 May R320 000 June R400 000

Use the information provided below to prepare the following for May and June 2025: Debtors Collection Schedule Cash Budget. The following information was provided by Lewis Traders:1. An unfavourable bank balance of R40 000 is expected on 30 April 2025. 2. Budgeted credit sales for April to June 2025 are as follows: April R420 000 May R372 000 June R432 000 3. Credit sales are estimated to be 60% of the total sales. The balance of the sales is for cash. Customers who purchase for cash are entitled to a discount of 10%.4. Collections from credit sales are expected to be as follows:• 30% during the month of sale (These debtors receive a 5% discount.)• 70% in the following month.5. Budgeted purchases of inventories from April to June 2025 are as follows: April R360 000 May R320 000 June R400 000

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter8: Budgeting For Planning And Control

Section: Chapter Questions

Problem 33E: A companys controller is adjusting next years budget to reflect the impact of an expected 3 percent...

See similar textbooks

Similar questions

Review the completed master budget and answer the following questions: Is Ranger Industries expecting to earn a profit during the next quarter? If so, how much? Does the company need to borrow cash during the quarter? Can it make any repayments? Explain. (Carefully review rows 74 through 80.)
Use the information provided below to prepare the following for November and December 2021: 1. Debtors Collection Schedule
Use the information provided by Tech Talk to prepare the following for March and April 2024: 1.1 Cash Budget 1.2 Debtors Collection Schedule INFORMATION The following information was provided by Tech Talk: 1. Tech Talk expects to have a favourable bank balance of R70 000 on 28 February 2024. 2. Budgeted sales figures for 2024 are as follows: January R420 000 R470 000 3. 4. 5. 6. 7. Cash sales Credit sales 9. February R470 000 R490 000 Total purchases March R610 000 R620 000 Thirty percent (40%) of the cash sales is to informal traders who are entitled to a discount of 20%. Collections from debtors are usually as follows: • 80% is collected in the month after the sale. 20% is collected two months after the sale. Purchases of inventory are expected to be as follows: January R310 000 February R360 000 April R650 000 R600 000 March R300 000 Sixty percent (60%) of the purchases is for cash to take advantage of a discount of 15%. The balance is purchased on credit. Creditors are paid two…
Use the information provided below to prepare the following for January and February 2023: 4.2)Cash Budget INFORMATION The following information was provided by Intel Enterprises:1. The bank balance on 31 December 2022 is expected to be R40 000 (unfavourable).2. Credit sales are expected to be as follows:December 2022 January 2023 February 2023R576 000 R540 000 R648 0003. Credit sales usually make up 40% of the total sales. Cash sales make up the balance. Cash customersreceive a 10% discount.4. Credit sales are normally collected as follows:* 30% in the month in which the transaction takes place, and these customers are entitled to a 5% discount.* 65% in the following monthThe rest is usually written off as bad debts.5. Budgeted purchases of inventory are as follows:December 2022 January 2023 February 2023R1 000 000 R800 000 R920 000 6. Fifty percent (50%) of the purchases are for cash. The remainder is paid in the month after the purchase.7. The monthly salaries amount to R150…
Please provide answer in text (Without image)
Please answer in text form (without image)
Good day . can you please assist on the attached photo below. Q.1 prepare the schedule of budgeted receipts from debtors for the quarter ending 30 november 2019. Show all the calculations . round to the two decimal places.
Use the information provided below to prepare the following for January and February 2023: 4.1 Debtors Collection Schedule 4.2 Cash Budget INFORMATIONThe following information was provided by Intel Enterprises:1. The bank balance on 31 December 2022 is expected to be R40 000 (unfavourable).2. Credit sales are expected to be as follows: December 2022 January 2023 February 2023 R576 000 R540 000 R648 000 3. Credit sales usually make up 40% of the total sales. Cash sales make up the balance. Cash customersreceive a 10% discount.4. Credit sales are normally collected as follows:* 30% in the month in which the transaction takes place, and these customers are entitled to a 5% discount.* 65% in the following monthThe rest is usually written off as bad debts.5. Budgeted purchases of inventory are as follows: December 2022 January 2023 February 2023 R1 000 000 R800 000 R920 000 6. Fifty percent (50%) of the purchases are for cash. The remainder is paid in the month after the…
In preparing its budget for July 2026, Robinson Company has the following accounts receivable information available: Accounts receivable at June 30, 2026 P 350,000 Estimated credit sales for July 400,000 Estimated collections in July for credit sales in July and prior years. 320,000 Estimated write-off in July for uncollectible credit sales. 16,000 Estimated provision or doubtful accounts for credit sales in July 12,000 What is the projected balance of accounts receivable at July 31, 2026? Group of answer choices
From the following information, prepare a monthly cash budget for the three months ending 31st December 2023. Month June July August September October November December Materials Wages 1,800 650 2,000 750 2,400 750 2,250 750 2.300 800 2,500 2,600 900 1,000 The credit terms are as follows: 10% of sales are in cash. 3 months to debtors. 2 months from Creditors. Sales 3,000 3,250 3,500 3,750 4,000 4,250 4,500 The lag in payment for wages is 1/4 month and 1/2 month for overheads. The cash and bank balance on 1st October is expected to be RO 1,500. Other information is given as follows: Admin. Selling, etc 160 160 175 175 200 200 225 Production 225 225 250 300 300 350 350 Preference share dividends @ 5% on RO 50,000 are to be paid on 1st December. Calls on 250 equity shares @RO 2 per share are expected on 1st November. Dividends from investments amounting to RO 250 are expected on 31st December. Income tax (advance) is to be paid in December RO 1,500 Plant and machinery are to be installed…
REQUIRED Use the following information provided by Ashton Enterprises to prepare the: 5.1 Debtors Collection Schedule for January and February 2021. 5.2 Cash Budget for January and February 2021. Note: Where applicable, round off amounts to the nearest Rand. INFORMATION The bank balance on 31 December 2020 is expected to be R40 000 (favourable). Expected credit sales are as follows: December 2020 R360 000 1. 2. 3. 4. 5. 6. 7. 8. 9. * * January 2021 R390 000 February 2021 R420 000 11 Credit sales usually make up 60% of the total sales. Cash sales make up the balance. Credit sales are normally collected as follows: 20% in the month in which the transaction took place. These debtors are entitled to a 5% discount. 75% in the following month. The rest is usually written off as bad debts. The mark-up is 25% on cost. The goods that are sold each month are replaced in the same month. The ratio of cash purchases to credit purchases is 3:1 respectively. Creditors are paid in the month after the…
Use the information supplied to prepare the following for Silver City Traders for the three months ending 31 March 2022. 1.1 Debtors collection schedule. 1.2 Cash budget statement.