• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Free ACCA & CIMA online courses from OpenTuition

Free ACCA & CIMA online courses from OpenTuition

Free Notes, Lectures, Tests and Forums for ACCA and CIMA exams

  • ACCA
  • CIMA
  • FIA
  • OBU
  • Books
  • Forums
  • Ask AI
  • Search
  • Register
  • Login
  • ACCA Forums
  • Ask ACCA Tutor
  • FIA Forums
  • CIMA Forums
  • OBU Forums
  • Qualified Members forum
  • Buy/Sell Books
  • All Forums
  • Latest Topics

20% off ACCA & CIMA Books

OpenTuition recommends the new interactive BPP books for March 2025 exams.
Get your discount code >>

Cash Budgets BPP Question No 56

Forums › Ask ACCA Tutor Forums › Ask the Tutor ACCA FM Exams › Cash Budgets BPP Question No 56

  • This topic has 5 replies, 2 voices, and was last updated 9 years ago by John Moffat.
Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • September 21, 2016 at 10:53 am #341202
    furqan.90
    Member
    • Topics: 34
    • Replies: 41
    • ☆☆

    Hi John,
    Need help with this question.
    QUESTION
    JP Co has budgeted that sales will be $300,100 in January 20X2, $501,500 in February, $150,000 in March
    and $320,500 in April. Half of sales will be credit sales. 80% of receivables are expected to pay in the month
    after sale, 15% in the second month after sale, while the remaining 5% are expected to be bad debts.
    Receivables who pay in the month after sale can claim a 4% early settlement discount.
    What level of sales receipts should be shown in the cash budget for March 20X2 (to the nearest $)?

    ANSWER
    $290,084
    Receipts for March:
    $
    50% March sales for cash (50% × $150,000) 75,000
    80% × February credit sales less 4% discount (50% × 80% × $501,500 × 96%) 192,576
    15% × January credit sales (50% × 15% × $300,100) 22,508
    290,084
    Why is the book solution not including cash sales of Jan and Feb but including March cash sales?
    My solution

    Jan Feb Mar
    Sales 300100 501500 150000
    Cash sales 150050 250750 75000
    Receipts from credit sales month after sale 115238.4 192576
    Receipts from credit sales 2 months after sale 22507.5
    Total 150050 365988.4 290083.5
    Grand total 806121.9

    September 21, 2016 at 12:34 pm #341216
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54804
    • ☆☆☆☆☆

    Cash sales will pay us in the month in which the sale was made – they pay cash immediately.

    So the cash received from cash sales in Jan and Feb will have been received in Jan and Feb and therefore are not relevant for March. The only cash received from cash sales in March will be 50% of the sales in March.

    September 24, 2016 at 5:12 am #341528
    furqan.90
    Member
    • Topics: 34
    • Replies: 41
    • ☆☆

    Thanks John,I should have read the question properly i thought it was asking for the period Jan to March.

    September 24, 2016 at 10:16 pm #341595
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54804
    • ☆☆☆☆☆

    You are welcome 🙂

    October 17, 2016 at 4:16 am #343757
    furqan.90
    Member
    • Topics: 34
    • Replies: 41
    • ☆☆

    Hi John,

    Just wanted to say a big thank you I got 70 in my F5 you guys rock,i passed three papers in 3 months thanks to you guys.

    Best Regards,
    Furqan

    October 17, 2016 at 8:45 am #343999
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54804
    • ☆☆☆☆☆

    That is great news, and many congratulations 🙂
    I am very please indeed for you.

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.
Log In

Primary Sidebar

Donate
If you have benefited from our materials, please donate

ACCA News:

ACCA My Exam Performance for non-variant

Applied Skills exams is available NOW

ACCA Options:  “Read the Mind of the Marker” articles

Subscribe to ACCA’s Student Accountant Direct

ACCA CBE 2025 Exams

How was your exam, and what was the exam result?

BT CBE exam was.. | MA CBE exam was..
FA CBE exam was.. | LW CBE exam was..

Donate

If you have benefited from OpenTuition please donate.

PQ Magazine

Latest Comments

  • John Moffat on ACCA F2 Revision
  • sanjarmakh on PPE – Depreciation – ACCA Financial Reporting (FR)
  • sanjarmakh on PPE – Depreciation – ACCA Financial Reporting (FR)
  • hunaiza.19 on ACCA F2 Revision
  • kita0553 on PPE – revaluation upwards – ACCA Financial Reporting (FR)

Copyright © 2025 · Support · Contact · Advertising · OpenLicense · About · Sitemap · Comments · Log in