prepare the following cash budget for June and July 2022 from the information provided

extract of the budgeted statement of comprehensive income for the year ended 31 may 2022

sales. R4 800 000 cost of sales R2 400 000 Rent income. R120 000 Advertising. R48 000 salaries. R756 000 Rates and taxes R12 000 other operating expenses R960 000

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. 50% of the sales are for cash and the balance is on credit. as from 01 June 2022 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 4.inventories are kept at a constant level. 60% of the purchases are for cash and the balance is on credit. creditors are paid in the month after the purchase 5.in terms of the lease agreement the rental is received monthly. the rent for the year ended 31 may 2023 is expected to be 10% more than the previous twelve months 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 installment for the year during July 2022.rates are calculated at 80cents (0.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 spend 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