BTB (Pty) Limited is a distributor of PPE to rural health clinics in KZN. Turnover has been good and running expenses are under control, however the owner of the business, Mr Sam Jonas, is concerned that upcoming legal expenses and necessary vehicle repairs may negatively affect the business’ cash flow. He has hired you to prepare a cash budget for the next four months, from July to October 2022. All sales are made on credit and collected as follows: • 40% in the month of the sale; • 35% in the month after the sale; • 15% in the second month after the sale; • 10% will be written off as bad debts. All purchases are made on credit and paid for as follows: • 60% in the month of the purchase and • 40% in the month after the purchase. Total administration expenses (rent, rates stationary etc) will be R14 000 per month. The legal costs will be R34 000 in each of July and August 2022. Major repairs and maintenance to vehicles will cost R45 000 and this amount will be paid in three equal instalments from August to October 2022. Cash on hand on 1st July 2022 is expected to be zero, however the company has agreed to maintain a minimum cash balance of R28 000 at all times with immediate effect. Actual sales were R180 000 for May and R130 000 for June 2022. The estimated sales are R140 000 for July, R120 000 for August, R100 000 for September and R110 000 for October. Purchases for June 2022 were R75 000. The estimated purchases are R80 000 for July, R65 000 for August, R40 000 for September and R50 000 for October. Required: (a) Determine the total cash receipts for the month of July

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
100%

BTB (Pty) Limited is a distributor of PPE to rural health clinics in KZN. Turnover has been good and running expenses are under control, however the owner of the business, Mr Sam Jonas, is concerned that upcoming legal expenses and necessary vehicle repairs may negatively affect the business’ cash flow. He has hired you to prepare a cash budget for the next four months, from July to October 2022.

All sales are made on credit and collected as follows:

• 40% in the month of the sale;

• 35% in the month after the sale;

• 15% in the second month after the sale;

• 10% will be written off as bad debts.

All purchases are made on credit and paid for as follows:

• 60% in the month of the purchase and 

• 40% in the month after the purchase.

 

Total administration expenses (rent, rates stationary etc) will be R14 000 per month. The legal costs will be R34 000 in each of July and August 2022. Major repairs and maintenance to vehicles will cost R45 000 and this amount will be paid in three equal instalments from August to October 2022. Cash on hand on 1st July 2022 is expected to be zero, however the company has agreed to maintain a minimum cash balance of R28 000 at all times with immediate effect.

Actual sales were R180 000 for May and R130 000 for June 2022. The estimated sales are R140 000 for July, R120 000 for August, R100 000 for September and R110 000 for October. Purchases for June 2022 were R75 000. The estimated purchases are R80 000 for July, R65 000 for August, R40 000 for September and R50 000 for October.  

Required:

(a) Determine the total cash receipts for the month of July

 

Expert Solution
steps

Step by step

Solved in 2 steps

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