Question
The following information is applicable to Shine Wholesalers for the year 2020: Budgeted sales: July August September R105 000 R132 000 R165 000 In October
The following information is applicable to Shine Wholesalers for the year 2020: Budgeted sales:
July August September
R105 000 R132 000 R165 000
-
In October 2020, sales are expected to increase by 20% relative to sales in September 2020.
-
Cash sales amount to 20% of total sales.
-
55% of all credit sales are collected in the month of sale, with a discount of 10% to those debtors who pay during this
time. The outstanding credit sales are collected in equal instalments over the next two months. There are no bad debts.
-
Purchases of raw materials are expected to be sufficient to meet 60% of the total sales for the next month. The company normally settles half of its creditors in the month following the month of purchase. The remaining creditors are paid two
months after the month of purchase.
-
Wages and salaries are paid to employees at the end of the month in which they are earned. Wages and salaries are
expected to be:
June R22 200 July R20 500
August September October
R23 500 R26 500 R28 000
-
Rent amounts to R48 000 per annum. This amount is spread evenly throughout the year.
-
All other overheads amount to R38 160 per annum, including annual depreciation amounting to R22 500. Other
overheads and depreciation are incurred evenly throughout the year.
-
An industrial printer which was recently purchased for R45 000 will be paid off in three equal instalments, commencing
in August 2020.
-
The company expects to receive tax refunds of 28 700 from SARS in September 2020.
-
The company had taken a loan of R10 000 in January 2020. The loan will be repaid in four equal instalments. The last
instalment will be repaid in September 2020.
-
The companys bank balance at the end of August 2020 was R35 000.
The management director of the company wants to revamp the companys IT system in November 2020. This undertaking is expected to cost the company R400 000. She wants to know if the company will have sufficient cash to execute the project. Overdraft facilities are available.
Required: Prepare a cash budget for Shine Wholesalers for the months of September and October 2020. Note: show ALL calculations.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started