The half year results of Manhattsons Manufacturing Ltd have been completed at 31 August 2019. The last quarter's actual sales and the forecasted sales numbers are as follows: Actual Sales (as per Statement of Forecasted Sales (as per forecasted Statement Comprehensive Income) of Comprehensive Income) June 2019 July 2019 August 2019 September October November 2019 2019 2019 198 000 288 000 396 000 450 000 558 000 630 000 Additional Information: 75% of all sales are on credit. The debtors collection history is as follows: 60% of outstanding amounts are collected during the month following the month of the sale (30 days). The company policy is to allow a settlement discount of 2.5% for all sales settled within 30 days. 25% of outstanding amounts are collected during the second month following the month of the sale (60 days). 10% of outstanding amounts are collected during the third month following the month of the sale (90 days). 5% is irrecoverable. Credit losses are written off at the end of the month in which the last instalment is received.

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%

Good day . can you please assist on the attached photo below.

Q.1 prepare the schedule of budgeted receipts from debtors for the quarter ending 30 november 2019. Show all the calculations . round to the two decimal places.

The half year results of Manhattsons Manufacturing Ltd have been completed at 31 August 2019.
The last quarter's actual sales and the forecasted sales numbers are as follows:
Actual Sales (as per Statement of
Forecasted Sales (as per forecasted Statement
Comprehensive Income)
of Comprehensive Income)
June 2019
July 2019
August 2019
September
October
November
2019
2019
2019
198 000
288 000
396 000
450 000
558 000
630 000
Additional Information:
75% of all sales are on credit.
The debtors collection history is as follows:
60% of outstanding amounts are collected during the month following the month of
the sale (30 days). The company policy is to allow a settlement discount of 2.5% for all
sales settled within 30 days.
25% of outstanding amounts are collected during the second month following the
month of the sale (60 days).
10% of outstanding amounts are collected during the third month following the month
of the sale (90 days).
5% is irrecoverable.
Credit losses are written off at the end of the month in which the last instalment is received.
Transcribed Image Text:The half year results of Manhattsons Manufacturing Ltd have been completed at 31 August 2019. The last quarter's actual sales and the forecasted sales numbers are as follows: Actual Sales (as per Statement of Forecasted Sales (as per forecasted Statement Comprehensive Income) of Comprehensive Income) June 2019 July 2019 August 2019 September October November 2019 2019 2019 198 000 288 000 396 000 450 000 558 000 630 000 Additional Information: 75% of all sales are on credit. The debtors collection history is as follows: 60% of outstanding amounts are collected during the month following the month of the sale (30 days). The company policy is to allow a settlement discount of 2.5% for all sales settled within 30 days. 25% of outstanding amounts are collected during the second month following the month of the sale (60 days). 10% of outstanding amounts are collected during the third month following the month of the sale (90 days). 5% is irrecoverable. Credit losses are written off at the end of the month in which the last instalment is received.
Expert Solution
steps

Step by step

Solved in 3 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