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,...
-
Homepride Carpet Company manufactures carpets. Fiber is placed in process in the Spinning Department, where it is spun into yarn. The output of the Spinning Department is transferred to the Tufting...
-
William Corporations income statement for the year ended December 31, 2014, and its comparative balance sheets as of December 31, 2014 and 2013, follow. During 2014, William engaged in these...
-
Your company is evaluating a new project, and you've estimated that the cost of capital for the project will be 8 percent. Assume that you have also projected the following cash flows for the...
-
In 2013, Copia Company had current assets of $155,000 and current liabilities of $100,000, of which accounts payable were $65,000. Cost of goods sold was $425,000, merchandise inventory increased by...
-
The rigid bar ABC shown in figure is hinged at A and supported by a steel rod at B. Determine the largest load P that can be applied at C if the stress in the steel rod is limited to 45 ksi and the...
-
The molar enthalpy of a ternary mixture of species a, b, and c can be described by the following expression: h = -5000x - 3000x2200x500xxx [J/mol] (a) Come up with an expression for H (b) Calculate H...
-
3. Calculate the total energy of the following (show your work) 1. proton with velocity 400 m/s 2. FM radio photon with frequency 100 MHz
-
How do biopolitical approaches to deviance analyze the regulation of bodies, populations, and social life through techniques of surveillance, discipline, and normalization ?
-
(d) Calculate the mobility using the Kutzbach revision of Gruebler equation. ein 2
-
C an you kindly assist me with the below. I really appreciate your assitance. each wortth forrttyyy poiiinttss. Large organizations have a plethora of internal data from their various computer...
-
Which exercise is easier to do, a straight-arm pullover with a 45 lb barbell or a bent- arm pullover with a 45 lb barbell? Why? (3 points)
-
What role does organizational resilience play in a company's ability to adapt to external shocks and disruptions? Discuss the key factors that contribute to building and sustaining resilience ?
-
Cost Flow Relationships The following information is available for the first year of operations of Idgie Inc., a manufacturer of fabricating equipment: Sales Gross profit Indirect labor $914,500...
-
Prove the following D,(cos x) = - sin x (Hint: Apply the identity cos(A + B) = cos A cos B sin A sin B)
-
Lomax Company typically acquires a large number of individually insignificant properties each year. In computing impairment, Lomax groups these properties by year of acquisition. During 2015, Lomax...
-
On January 1, 2010, Local Petroleum entered into a concession agreement with the government of Egypt and paid a \($3,000,000\) signing bonus. The agreement covers 20,000 acres, has a term of five...
-
Opaque Corporation purchased land in fee for \($420,000\). The land was located in a remote area in Oklahoma. An appraiser estimated the fair market value of the surface rights to be \($200,000\)....
Study smarter with the SolutionInn App