Additional information 1. All inventories are sold at cost plus 25%. 2. Sales are expected to be spread out evenly throughout each financial year. Sales are expected to increase by 18% for the financial year ending 31 May 2023. 3. Fifty percent (50%) of the sales are for cash and the balance is on credit. As from 01 June 2022 thirty percent (30%) of the cash sales is expected to be made to large retailers who will be granted a 10% cash discount. Collections from credit sales are usually as follows: * 40% in the month of sale, and these debtors are entitled to a 5% discount; * 55% in the month after the sale. The balance is usually written off as bad debts. Inventories are kept at a constant level. Sixty percent (60%) of the purchases are for cash and the balance is on credit. Creditors are paid in the month after the purchase. 4. In terms of the lease agreement the rental is received monthly. The rent for the year ending 31 May 2023 is expected to be 10% more than the previous twelve months. 5. 6. Advertising is paid for monthly and is estimated to be the same percentage of sales (excluding discounts) as for the financial year ended 31 May 2022. 7. Salaries increase by 10% on 01 December of each year. 8. Rates and taxes will be paid in one instalment for the year during July 2022. Rates are calculated at 80 cents (RO.80) per R100 on the value of the premises. The premises are valued at R3 000 000. 9. Other operating expenses are expected to increase by 5% and are spread evenly throughout the year. They are paid for in the month in which they are incurred. 10. An unfavourable bank balance of R180 000 is expected on 31 May 2022. Prepare the following for June and July 2022 from the information provided below. Cash Budget INFORMATION The information provided below was taken from the forecasts of Rustom Wholesalers for the financial year ended 31 May 2022. EXTRACT OF THE BUDGETED STATEMENT OF COMPREHENSIVE INCOME FOR THE YEAR ENDED 31 MAY 2022 R Sales 4 800 000 Cost of sales 2 400 000 Rent income 120 000 |Advertising 48 000 Salaries 756 000 Rates and taxes 12 000 Other operating expenses 960 000

Principles of Cost Accounting
17th Edition
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Edward J. Vanderbeck, Maria R. Mitchell
Chapter7: The Master Budget And Flexible Budgeting
Section: Chapter Questions
Problem 6E: Roman Inc. has the following totals from its operating budgets: Prepare a budgeted income statement...
icon
Related questions
Topic Video
Question

Prepare a cash budget for the period of June and July 2022

Additional information
1.
All inventories are sold at cost plus 25%.
2.
Sales are expected to be spread out evenly throughout each financial year. Sales are expected to increase
by 18% for the financial year ending 31 May 2023.
3.
Fifty percent (50%) of the sales are for cash and the balance is on credit. As from 01 June 2022 thirty
percent (30%) of the cash sales is expected to be made to large retailers who will be granted a 10% cash
discount. Collections from credit sales are usually as follows:
* 40% in the month of sale, and these debtors are entitled to a 5% discount;
* 55% in the month after the sale.
The balance is usually written off as bad debts.
Inventories are kept at a constant level. Sixty percent (60%) of the purchases are for cash and the balance
is on credit. Creditors are paid in the month after the purchase.
4.
In terms of the lease agreement the rental is received monthly. The rent for the year ending 31 May 2023 is
expected to be 10% more than the previous twelve months.
5.
6.
Advertising is paid for monthly and is estimated to be the same percentage of sales (excluding discounts)
as for the financial year ended 31 May 2022.
7.
Salaries increase by 10% on 01 December of each year.
8.
Rates and taxes will be paid in one instalment for the year during July 2022. Rates are calculated at 80
cents (RO.80) per R100 on the value of the premises. The premises are valued at R3 000 000.
9.
Other operating expenses are expected to increase by 5% and are spread evenly throughout the year.
They are paid for in the month in which they are incurred.
10.
An unfavourable bank balance of R180 000 is expected on 31 May 2022.
Transcribed Image Text:Additional information 1. All inventories are sold at cost plus 25%. 2. Sales are expected to be spread out evenly throughout each financial year. Sales are expected to increase by 18% for the financial year ending 31 May 2023. 3. Fifty percent (50%) of the sales are for cash and the balance is on credit. As from 01 June 2022 thirty percent (30%) of the cash sales is expected to be made to large retailers who will be granted a 10% cash discount. Collections from credit sales are usually as follows: * 40% in the month of sale, and these debtors are entitled to a 5% discount; * 55% in the month after the sale. The balance is usually written off as bad debts. Inventories are kept at a constant level. Sixty percent (60%) of the purchases are for cash and the balance is on credit. Creditors are paid in the month after the purchase. 4. In terms of the lease agreement the rental is received monthly. The rent for the year ending 31 May 2023 is expected to be 10% more than the previous twelve months. 5. 6. Advertising is paid for monthly and is estimated to be the same percentage of sales (excluding discounts) as for the financial year ended 31 May 2022. 7. Salaries increase by 10% on 01 December of each year. 8. Rates and taxes will be paid in one instalment for the year during July 2022. Rates are calculated at 80 cents (RO.80) per R100 on the value of the premises. The premises are valued at R3 000 000. 9. Other operating expenses are expected to increase by 5% and are spread evenly throughout the year. They are paid for in the month in which they are incurred. 10. An unfavourable bank balance of R180 000 is expected on 31 May 2022.
Prepare the following for June and July 2022 from the information provided below.
Cash Budget
INFORMATION
The information provided below was taken from the forecasts of Rustom Wholesalers for the financial year ended 31
May 2022.
EXTRACT OF THE BUDGETED STATEMENT OF COMPREHENSIVE INCOME FOR THE YEAR ENDED 31 MAY
2022
R
Sales
4 800 000
Cost of sales
2 400 000
Rent income
120 000
|Advertising
48 000
Salaries
756 000
Rates and taxes
12 000
Other operating expenses
960 000
Transcribed Image Text:Prepare the following for June and July 2022 from the information provided below. Cash Budget INFORMATION The information provided below was taken from the forecasts of Rustom Wholesalers for the financial year ended 31 May 2022. EXTRACT OF THE BUDGETED STATEMENT OF COMPREHENSIVE INCOME FOR THE YEAR ENDED 31 MAY 2022 R Sales 4 800 000 Cost of sales 2 400 000 Rent income 120 000 |Advertising 48 000 Salaries 756 000 Rates and taxes 12 000 Other operating expenses 960 000
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Performance measurements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning