• 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

20% off ACCA & CIMA Books

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

Budgeting

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

  • This topic has 7 replies, 3 voices, and was last updated 3 years ago by John Moffat.
Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • June 15, 2017 at 12:38 pm #393244
    cindy7
    Member
    • Topics: 77
    • Replies: 33
    • ☆☆

    1:A company plans to sell 24,000 units of product R next year. Opening inventory of R is expected to be
    2,000 units and PQ Co plans to increase inventory by 25 per cent by the end of the year. How many
    units of product R should be produced next year? Sir, why didn’t they subtract the 2000 units and then calculate the percentage inventory after?

    2: Each unit of product Zeta requires 3 kg of raw material and 4 direct labour hours. Material costs $2 per kg and
    the direct labour rate is $7 per hour.
    The production budget for Zeta for April to June is as follows.
    April May June
    Production units 7,800 8,400 8,200 Raw material opening inventories are budgeted as follows. April May June 3,800 kg 4,200 kg 4,100 kg. The closing inventory budgeted for June is 3,900 kg.Material purchases are paid for in the month following purchase. What is the figure to be included in the cash budget for June in respect of payments for purchases? Sir, why wasn’t the closing inventory of 3900kg not considered in this calculation?

    June 15, 2017 at 5:57 pm #393265
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54664
    • ☆☆☆☆☆

    I really can’t help you without seeing the questions and what they have done in the answers

    For example, for your first question I would guess that instead of adding the opening inventory and then subtracting the closing inventory , maybe they just subtracting the increase in the inventory.

    If they are questions in the current edition of the BPP Revision Kit then tell me the numbers of the questions and then I will be able to explain.

    June 16, 2017 at 3:03 pm #393311
    cindy7
    Member
    • Topics: 77
    • Replies: 33
    • ☆☆

    thank you.
    1:answer= Required for sales 24,000
    Required to increase inventory (2,000 × 0.25) 500
    24,500. I thought if 24, 000 units are sells then they consist of opening inventory of 2000 units

    2:answer =Payments in June will be in respect of May purchases.
    May
    Production requirements (8,400 units × 3 kg) 25,200 kg
    Closing inventory 4,100 kg
    29,300 kg
    Less opening inventory 4,200 kg
    Purchase budget 25,100 kg
    × $2 per kg = payment for purchases in June $50,200
    Option A is the figure for the quantity of material to be paid for, not its value. Option B is the
    value of June purchases, which will be paid for in July. If you selected option D your adjustments
    for opening and closing material inventories were the wrong way round. I noticed that the 3900kg was not considered and yet its mentioned as the closing inventory. unless I have missed it out somewhere.

    June 16, 2017 at 5:54 pm #393320
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54664
    • ☆☆☆☆☆

    1. Correct. If you want then take the sales less the opening inventory. plus the closing inventory – you get the same result.

    2. But the payment is for the May purchases and therefore it is the opening and closing inventories for May that are relevant. 3900 is the closing inventory for June, which is not relevant.

    December 31, 2021 at 10:17 pm #645144
    sarbrina
    Participant
    • Topics: 57
    • Replies: 78
    • ☆☆

    Hi Mr. John.
    I have a problem with this question from the revision kit. I have reviewed the answer but i cannot seem to understand how they have solved the question. Please be kind enough to explain the question to me in detail.

    Each unit of product Alpha requires 3 kg of raw material. Next month’s production budget for product
    Alpha is as follows.

    Opening inventories:
    Raw materials 15,000 kg
    Finished units of Alpha 2,000 units
    Budgeted sales of Alpha 60,000 units
    Planned closing inventories:
    Raw materials 7,000 kg
    Finished units of Alpha 3,000 units
    How many kilograms of raw materials should be purchased next month?
    A 172,000
    B 175,000
    C 183,000
    D 191,000

    January 1, 2022 at 10:26 am #645159
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54664
    • ☆☆☆☆☆

    The budget on selling 60,000 units of finished goods. In addition they intend to increase the inventory of finished goods by 3,000 – 2,000 = 1,000 units. Therefore they need to produce 60,000 + 1,000 = 61,000 units of finished goods.

    This will require them to use 61,000 x 3kg = 183,000 kg of material.

    They intend to reduce their inventory of material by 15,000 – 7,000 = 8,000 kg. So of there 183,000 kg they need, they will take 8,000 kg from inventory and therefore will need to purchase just the remaining 183,000 – 8,000 = 175,000 kg.

    Have you watched my free lectures on budgeting? I work through an example that includes a similar situation to the situation in this question.

    January 1, 2022 at 11:31 am #645162
    sarbrina
    Participant
    • Topics: 57
    • Replies: 78
    • ☆☆

    Thank you so much for the detailed explanation Mr. John. I will be sure to watch the lecture. Thanks again!

    January 2, 2022 at 9:31 am #645178
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54664
    • ☆☆☆☆☆

    You are welcome.

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

  • Dileena on Sources of finance – Islamic Finance – ACCA (AFM) lectures
  • amaanalli on Governance – ACCA Strategic Business Leader (SBL)
  • nabeelafatima on Using Information Systems – ACCA Performance Management (PM)
  • John Moffat on Irrecoverable Debts and Allowances Example 3 – ACCA Financial Accounting (FA) lectures
  • Fangzi on The cost of capital (part 1) – ACCA (AFM) lectures

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