The following information is applicable to Shine Wholesalers for the year 2020: Budgeted sales: ● ● ● ● ● ● ● ● ● July August September In October 2020, sales are expected to increase by 20% relative to sales in September 2020. Cash sales amount to 20% of total sales. R105 000 R132 000 R165 000 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 July August September October 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 company's bank balance at the end of August 2020 was R35 000. The management director of the company wants to revamp the company's 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. R22 200 R20 500 R23 500 R26 500 R28 000 Required: Prepare a cash budget for Shine Wholesalers for the months of September and October 2020. Note: show ALL calculations.
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Step by step
Solved in 2 steps with 2 images