Use the information given below to prepare the following for the first three months of operations (i.e. July, August and September 2023): (template provided) 1. Debtors Collection Schedule 2. Cash Budget
Use the information given below to prepare the following for the first three months of operations (i.e. July, August and September 2023): (template provided) 1. Debtors Collection Schedule 2. Cash Budget
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
100%
Use the information given below to prepare the following for the first three months of operations (i.e. July,
August and September 2023): (template provided)
1. Debtors Collection Schedule
2.
Transcribed Image Text:BRENTFORD LIMITED
CASH BUDGET FOR THE PERIOD 01 JULY TO 30 SEPTEMBER 2023
July
August
Cash receipts
Cash payments
Cash surplus (shortfall)
September
Transcribed Image Text:INFORMATION
The following budgeted information relates to Oscar Limited that will commence business on 01 July 2023:
1. An amount of R800 000 is expected to be banked on 01 July 2023 from the sale of ordinary shares to
the public.
2. New machinery and equipment will be purchased on 02 July 2023 for R400 000. A deposit of 25% will
be paid immediately and the balance plus finance charges of R60 000 will be paid in five equal monthly
instalments commencing August 2023.
The number of units of the only product that is expected to be sold and produced each month are as
follows:
Month
July
August
September
3.
4.
The selling price of the product is R110 per unit. Cash sales are expected to comprise 60% of the total
sales. The balance of the sales will be on credit. Forty percent (40%) of the cash sales is subject to a
10% cash discount. Thirty percent (30%) of the credit sales is expected to be collected in the month of
the sale. The balance is expected to be received in the month after the sale.
5. Variable manufacturing costs per unit are estimated as follows:
Direct materials
Direct labour
Manufacturing overheads
6.
Sales
6 800
13 000
16 000
7.
8.
9.
Production
8 000
15 000
17 000
R30
R18
R14
Direct materials will be purchased for the production requirements of each month. Twenty percent (20%)
of the purchases is expected to be for cash and the balance will be paid two months after the purchase.
Direct workers will have their salaries paid on the last working day of each month.
Payment for the variable manufacturing overheads will be delayed by one month.
Fixed overheads are expected to amount to R300 000 per month, excluding depreciation of R5 000 per
month. Fixed overheads will be paid in the month in which they are incurred.
Expert Solution
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 3 steps with 2 images
Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education