QUESTION 1 REQUIRED Prepare the Cash Budget for a project of Aston Enterprises for the period 01 May 2021 to 31 July 2021. (Ensure that your cash budget has separate monetary columns for each month.) INFORMATION The following information was provided by Aston Enterprises: 1. The bank balance on 30 April 2021 is expected to be RSO 000 (favourable). 2. Expected sales (excluding discounts) are as follows: April May June July R R R R Cash sales 100 000 160 000 170 000 120 000 Credit sales 140 000 150 000 180 000 230 000 3. A discount of 5% is given to customers on cash sales. 4. Customers who purchase on credit usually pay one month after the sale. 5. The production estimates reveal the following: Production costs March April May June July R R Direct materials 45 000 55 000 60 000 75 000 77 000 Direct labour 32 000 35 000 36 000 39 000 41 000 Overheads 25 000 27 000 29 000 33 000 35 000
QUESTION 1 REQUIRED Prepare the Cash Budget for a project of Aston Enterprises for the period 01 May 2021 to 31 July 2021. (Ensure that your cash budget has separate monetary columns for each month.) INFORMATION The following information was provided by Aston Enterprises: 1. The bank balance on 30 April 2021 is expected to be RSO 000 (favourable). 2. Expected sales (excluding discounts) are as follows: April May June July R R R R Cash sales 100 000 160 000 170 000 120 000 Credit sales 140 000 150 000 180 000 230 000 3. A discount of 5% is given to customers on cash sales. 4. Customers who purchase on credit usually pay one month after the sale. 5. The production estimates reveal the following: Production costs March April May June July R R Direct materials 45 000 55 000 60 000 75 000 77 000 Direct labour 32 000 35 000 36 000 39 000 41 000 Overheads 25 000 27 000 29 000 33 000 35 000
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Concept explainers
Variance Analysis
In layman's terms, variance analysis is an analysis of a difference between planned and actual behavior. Variance analysis is mainly used by the companies to maintain a control over a business. After analyzing differences, companies find the reasons for the variance so that the necessary steps should be taken to correct that variance.
Standard Costing
The standard cost system is the expected cost per unit product manufactured and it helps in estimating the deviations and controlling them as well as fixing the selling price of the product. For example, it helps to plan the cost for the coming year on the various expenses.
Topic Video
Question
100%
![QUESTION 1
REQUIRED
Prepare the Cash Budget for a project of Aston Enterprises for the period 01 May 2021 to 31 July
2021. (Ensure that your cash budget has separate monetary columns for each month.)
INFORMATION
The following information was provided by Aston Enterprises:
1. The bank balance on 30 April 2021 is expected to be R50 000 (favourable).
2. Expected sales (excluding discounts) are as follows:
April
May
June
July
R
R
R.
R
Cash sales
100 000
120 000
160 000
170 000
Credit sales
140 000
150 000
180 000
230 000
3. A discount of 5% is given to customers on cash sales.
4. Customers who purchase on credit usually pay one month after the sale.
5. The production estimates reveal the following:
Production costs
March
April
May
June
July
R
R
R
R
R
Direct materials
75 000
77 000
45 000
55 000
60 000
Direct labour
32 000
35 000
36 000
39 000
41 000
Overheads
25 000
27 000
29 000
33 000
35 000](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F59d53c00-a308-4db3-9208-610fb6d61ef3%2Fd826bee6-ff6f-4c18-b962-c049cc394458%2Ffaut4ad_processed.jpeg&w=3840&q=75)
Transcribed Image Text:QUESTION 1
REQUIRED
Prepare the Cash Budget for a project of Aston Enterprises for the period 01 May 2021 to 31 July
2021. (Ensure that your cash budget has separate monetary columns for each month.)
INFORMATION
The following information was provided by Aston Enterprises:
1. The bank balance on 30 April 2021 is expected to be R50 000 (favourable).
2. Expected sales (excluding discounts) are as follows:
April
May
June
July
R
R
R.
R
Cash sales
100 000
120 000
160 000
170 000
Credit sales
140 000
150 000
180 000
230 000
3. A discount of 5% is given to customers on cash sales.
4. Customers who purchase on credit usually pay one month after the sale.
5. The production estimates reveal the following:
Production costs
March
April
May
June
July
R
R
R
R
R
Direct materials
75 000
77 000
45 000
55 000
60 000
Direct labour
32 000
35 000
36 000
39 000
41 000
Overheads
25 000
27 000
29 000
33 000
35 000
![6. Fifty percent (50%) of the materials purchases are for cash. The balance is purchased on
credit and creditors are usually paid two months after the purchase.
7.
Employees involved in the production of finished goods are paid monthly.
8. The payment of production overheads is delayed by one month.
9. Selling and administrative costs are paid for in the month in which they are incurred. They
are forecast at 10% of sales (excluding any discounts).
10. A loan of R300 000 is expected to be obtained on 01 July 2021. Loan repayments of RS 000
per month plus interest at 12% per annum is payable at the end of each month commencing
July 2021.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F59d53c00-a308-4db3-9208-610fb6d61ef3%2Fd826bee6-ff6f-4c18-b962-c049cc394458%2F9igjf2q_processed.jpeg&w=3840&q=75)
Transcribed Image Text:6. Fifty percent (50%) of the materials purchases are for cash. The balance is purchased on
credit and creditors are usually paid two months after the purchase.
7.
Employees involved in the production of finished goods are paid monthly.
8. The payment of production overheads is delayed by one month.
9. Selling and administrative costs are paid for in the month in which they are incurred. They
are forecast at 10% of sales (excluding any discounts).
10. A loan of R300 000 is expected to be obtained on 01 July 2021. Loan repayments of RS 000
per month plus interest at 12% per annum is payable at the end of each month commencing
July 2021.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education