Homework Help is Here – Start Your Trial Now!
Business
Accounting
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

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
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. Cash Budget

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:BRENTFORD LIMITED CASH BUDGET FOR THE PERIOD 01 JULY TO 30 SEPTEMBER 2023 July August Cash receipts Cash payments Cash surplus (shortfall) September
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.
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
steps

Step by step

Solved in 3 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar 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
SEE MORE TEXTBOOKS