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.

Intermediate Accounting: Reporting And Analysis
3rd Edition
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Chapter22: Accounting For Changes And Errors.
Section: Chapter Questions
Problem 4RE: Refer to RE22-2. Assume Heller Company had sales revenue of 510,000 in 2019 and 650,000 in 2020....
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
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Fundamentals Of Financial Management, Concise Edi…
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College