• 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
  • CIMA Forums
  • Ask CIMA Tutor
  • FIA
  • OBU
  • Buy/Sell Books
  • All Forums
  • Latest Topics

June 2025 ACCA Exams

How was your exam? Comments & Instant poll >>

20% off ACCA & CIMA Books

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

Budgeting problem

Forums › Ask ACCA Tutor Forums › Ask the Tutor ACCA MA – FIA FMA › Budgeting problem

  • This topic has 13 replies, 5 voices, and was last updated 3 years ago by John Moffat.
Viewing 14 posts - 1 through 14 (of 14 total)
  • Author
    Posts
  • December 6, 2015 at 12:24 am #288061
    kfaz
    Member
    • Topics: 6
    • Replies: 6
    • ☆

    Hello! The question goes:

    “Mr Grob started trading in 20X3, selling one product on credit. The following budgeted information for 20X4 has been gathered:

    Credit sales:
    Jan 20X4: $12,000
    Feb 20X4: $15,000
    Mar 20X4: $21,000

    Receivables have recently been settling their debts 50% in the month following sale, and 50% two months after sale. A promp payment discount of 3% is offered to those receivables paying within one month.
    The gross profit margin is expected to be 25%. Due to an anticipated continued increase in sales, Mr Grob intends to increase inventory levels in March 20X4 by $2,000, and it is intended that the payables balance is increased by $3,000 to ease cash flows in the same month.

    Calculate the budgeted payment to suppliers in March 20X4.”

    I can’t at all see how to get to this payment to suppliers. Please help! Thank you!

    December 6, 2015 at 7:16 am #288099
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54675
    • ☆☆☆☆☆

    Surely the book in which you found the question also contains the answer.

    Please say which part of the answer you are not clear about and I will try and help.

    December 6, 2015 at 9:18 am #288138
    kfaz
    Member
    • Topics: 6
    • Replies: 6
    • ☆

    Sorry! The answer just says:
    $21,000 x 0.75 + $2,000 – $3,000 = $14,750

    It’s the $21,000 x 0.75 I don’t understand.

    Thank you!

    December 6, 2015 at 2:44 pm #288217
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54675
    • ☆☆☆☆☆

    It is because the sales include a profit of 25%. So the cost of the sales will be 21,000 – (25% x 21,000) = 75% x 21,000.
    It is the cost of the goods that is relevant when calculated how much was paid for the goods to the suppliers.

    December 8, 2015 at 11:20 am #288958
    sandhyabarbie6
    Member
    • Topics: 4
    • Replies: 4
    • ☆

    Good evening Sir,
    Can you please help me with this question? i never came across a question where there is both kg and units,,.. but only those of units ! 🙂

    A company manufactures and sells one product which requires 8 kg of raw materials in its manufacture. The budgeted data relating to the next period are as follows:
    units
    Sales 19,000
    Opening inventory 4,000
    Closing inventory 3,000

    opening inventory of raw materials 50,000 kg
    closing inventory of raw materials 53,000 kg

    What is the budgeted raw material purchases for next period ? ______ kg : Correct answer is 147,000 kg . (taken from online mock exams)

    My workings : Production budget Units kg
    Sales budget 19,000 19,000
    + closing inventory 3,000 53,000
    – opening inventory (4,000) (50,000)
    _______ _______
    Budgeted production in units/kg : 18,000 22,000
    _______ _______
    Do i have to use the materials purchases budget also Sir ? 🙂

    Thank You 🙂

    December 8, 2015 at 3:01 pm #289025
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54675
    • ☆☆☆☆☆

    You have first of all to work out how many units are produced, which is indeed 18,000.

    Since each unit requires 8kg of material, they need to use 18,000 x 8kg = 144,000 kg.

    Because of the opening and closing inventories of materials, the amount of materials that needs to be purchased is 144,000 – 50,000 + 53,000 = 147,000 kg.

    (If you have not see this sort of problem before, then you have obviously not watched the free lecture on budgeting 🙂 )

    December 17, 2015 at 7:51 am #292046
    sandhyabarbie6
    Member
    • Topics: 4
    • Replies: 4
    • ☆

    I will definitely watch the free lectures Sir ! Thank You very much for your Precious help ! 🙂

    December 17, 2015 at 8:50 am #292058
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54675
    • ☆☆☆☆☆

    You are welcome 🙂

    April 23, 2022 at 10:40 am #654326
    purav1234
    Participant
    • Topics: 0
    • Replies: 7
    • ☆

    Sir In This above Sum Why We are subtracting 3000??

    April 23, 2022 at 10:41 am #654327
    purav1234
    Participant
    • Topics: 0
    • Replies: 7
    • ☆

    Hello! The question goes:

    “Mr Grob started trading in 20X3, selling one product on credit. The following budgeted information for 20X4 has been gathered:

    Credit sales:
    Jan 20X4: $12,000
    Feb 20X4: $15,000
    Mar 20X4: $21,000

    Receivables have recently been settling their debts 50% in the month following sale, and 50% two months after sale. A promp payment discount of 3% is offered to those receivables paying within one month.
    The gross profit margin is expected to be 25%. Due to an anticipated continued increase in sales, Mr Grob intends to increase inventory levels in March 20X4 by $2,000, and it is intended that the payables balance is increased by $3,000 to ease cash flows in the same month.

    Calculate the budgeted payment to suppliers in March 20X4.”
    Sir I am Not able to Understand Why 3000 is subtracted ??

    April 23, 2022 at 2:59 pm #654334
    purav1234
    Participant
    • Topics: 0
    • Replies: 7
    • ☆

    John Moffat wrote:It is because the sales include a profit of 25%. So the cost of the sales will be 21,000 – (25% x 21,000) = 75% x 21,000.
    It is the cost of the goods that is relevant when calculated how much was paid for the goods to the suppliers.

    Why 3000 is subtracted??

    April 24, 2022 at 6:48 pm #654366
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54675
    • ☆☆☆☆☆

    If the amount owing to payables increases by 3,000 then it must mean that we have paid them 3,000 less than the amount we purchased from them.

    April 27, 2022 at 3:34 pm #654489
    kavishabrito
    Participant
    • Topics: 17
    • Replies: 15
    • ☆

    A company manufactures a single product, M. Budgeted production output of product M during August is 200 units. Each unit of product M requires 6 labour hours for completion and PR Co anticipates 20 per cent idle time. Labour is paid at a rate of $7 per hour. What is the direct labour cost budget for August?

    The answer states that “allowance for idle time (20% of total time = 25% of active time)”

    Can I know how they state that “20% of total time = 25% of active time”

    April 27, 2022 at 4:13 pm #654493
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54675
    • ☆☆☆☆☆

    Suppose that the total time they are paying for is 100 hours.

    20% of the time (so 20 hours) will be idle, which means that 80 hours will be active.

    So the amount of idle time is 20 hours which is 20/80 (i.e. 25%) of the active time.

  • Author
    Posts
Viewing 14 posts - 1 through 14 (of 14 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

  • mrjonbain on What is Assurance? – ACCA Audit and Assurance (AA)
  • Ejueyitsi-Toju on What is Assurance? – ACCA Audit and Assurance (AA)
  • sadik.sadka on How to make the best use of OpenTuition
  • SONIC916 on Lessee accounting – ACCA (SBR) lectures
  • AkinMike on IASB Conceptual Framework – Introduction – ACCA Financial Reporting (FR)

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