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.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
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.
•
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
●
R105 000
R132 000
R165 000
August
September
October
R22 200
R20 500
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 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.
Required:
Prepare a cash budget for Shine Wholesalers for the months of September and October 2020. Note: show ALL calculations.
Transcribed Image Text: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. • 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 ● R105 000 R132 000 R165 000 August September October R22 200 R20 500 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 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. Required: Prepare a cash budget for Shine Wholesalers for the months of September and October 2020. Note: show ALL calculations.
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education