Prepare the following for June and July 2022 from the information provided below. Debtors Collection Schedule...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Prepare the following for June and July 2022 from the information provided below. Debtors Collection Schedule 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 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. 4. 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. 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. Debtors Collection Schedule 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 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. 4. 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. 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.
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Please help me with this its urgent please help me for freee How will the social sciences affect your life in the following areas and explain why: Area of Life Effect and why Work / Career Home and...
-
Steam power plants (Rankine cycle) are commonly used to generate mechanical power through a turbine to produce electricity (see Fig.1). You are working in a fuel-based power plant in the design and...
-
Economics Hi please help me this statement thanks Hi please help me to answer this statement on below question, you dont have to show your work (in this case the decision tre
-
Integer sort. Write a linear-time filter that reads from standard input a sequence of integers that are between 0 and 99 and prints to standard output the same integers in sorted order. For example,...
-
If a computer statistical package were to simulate 1000 random observations from a normal distribution with = 200 and = 50, what percentage of these observations would you expect to have a value of...
-
A project will produce an operating cash flow of $14,600 a year for 8 years. The initial fixed asset investment in the project will be $48,900. The net after-tax salvage value is estimated at $11,000...
-
In problem 3-13, you were asked to prepare a statement of cash flows for New Zealand Dairy Company. Use the information given in the problem to compute the firms free cash flows and the financing...
-
The Ottawa Barber Shop employs four barbers. One barber, who also serves as the manager, is paid a salary of $3,900 per month. The other barbers are paid $1,900 per month. In addition, each barber is...
-
a) A financial institution is a financial intermediary (FI'S) that facilitates the transfer of funds between suppliers and users of funds. Briefly explain the benefits that FI's provide to the...
-
B52 Skate Training prepares adjustments annually and showed the following on its June 30, 2023, year-end: Additional information available at year-end: a. The Prepaid Arena Rental of $182,000 was...
-
Transaction Classification Accounting treatment. 1. At the end of the year, Quo determined that the allowance for credit losses should be 4% of the accounts receivable balance. The allowance in the...
-
find any horistonal asymptoptes of f ( x ) = 3 x - 9 / 2 x - 6
-
5. A box is dragged along the ground by a rope that applies a force of 14 lb at an angle of 30 with the ground. Find the work done by the force in pulling the box 20 ft.
-
profitability, liquidity, gearing, efficiency ratios. I am confused on the numbers to use, but also the values for pre-calculation before calculating the actual ratios. For example: calculating...
-
A Company produces product KL from a process that also yields a by-product, M. The by-product requires $ 4,000 additional processing cost. The company decided to account for the by-product at time of...
-
a line has an equation of 3 x - ky = 0 . find the value of k if this line makes an angle of 1 3 5 degrees with the line 2 x = 5 y - 1 7 = 0
-
Divide. If the divisor contains 2 or more terms, use long division. 2xy + 4xy - xy 2xy 2xy + 4xy - xy 2xy =
-
-x/2 x/4 If A = -x/2 and A-1 =6 then x equals
-
Aside from Calories, what else do you need to obtain through your diet? (a) a complete protein (b) a complete carbohydrate (c) vitamins and minerals (d) both a complete protein and vitamins and...
-
Trace the path of blood through the body, beginning with blood returning from the tissues to the heart. Be sure to name each of the chambers of the heart.
-
Which blood vessels are responsible for nutrient and waste exchange with tissues?
Study smarter with the SolutionInn App