• 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 >>

Forecasting in budgeting &Inventory management( Annual ordering & holding EBQ )

Forums › Ask ACCA Tutor Forums › Ask the Tutor ACCA MA – FIA FMA › Forecasting in budgeting &Inventory management( Annual ordering & holding EBQ )

  • This topic has 9 replies, 2 voices, and was last updated 10 years ago by John Moffat.
Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • April 24, 2015 at 7:33 am #242408
    Zainab
    Member
    • Topics: 5
    • Replies: 8
    • ☆

    Q.31.This year,the output is 5,000 units & the overhead cost is $37,000.Three years ago,the output was 2,000 units & the overhead cost was $8,800.The price index was 132 3 years ago & 164 this year.
    Using the high-low technique, what is the variable cost per unit(to the nearest $0.01) expressed in current year prices?
    A.$.4.13 B.$.5.38 C.$.6.69 D.$.7.40 Ans:C(explanation for the calculation)
    32.A co. purchases 5,000 units per quarter at an even rate throughout the year.Each order placed with the supplier incurrs a delivery charge of $20.The annual cost of holding 1 unit in inventory is $5.What is the maximum total of the inventory cost(order cost plus holding cost’ per year?
    35.A co. manufactures a component for one of it’s products.It used 6,000 of these components evenly throughout the year.Each component cost $20 to manufacture.In addition,there isa cost of $600 to set up the machines each time a batch of these components is manufactured.The holding cost p.u $20 per year.The co. can produce the units at the rate of 5,000 per month.What is the EBQ that should be manufactured each time?
    A.365 units B.1897unts C.6,000 units D..2,000 units Ans:D (explanation for the calculation)

    April 24, 2015 at 8:43 am #242424
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54659
    • ☆☆☆☆☆

    First question:

    I assume that you are asking about the question in our test. If you are then you have copied it wrongly – the question says that the cost this year is 31,000 (not 37,000)

    You need to restate the cost 3 years ago at current prices. i.e. 8,800 x 164/132 = 10,933
    Now you can apply high-low technique in the normal way.
    So the variable cost = (31000-10933)/(5,000-2,000) = 6.69

    April 24, 2015 at 8:47 am #242426
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54659
    • ☆☆☆☆☆

    Second question:

    Again you have copied this wrongly. The question asks for the minimum total cost – not the maximum total cost.

    First you need to calculate the EOQ using the formula.
    D = 4 x 5,000; Co = 20; Ch = 5. So the EOQ = 400.
    Then you can calculate the reorder cost (20,000/400 x 20) and the holding cost (400/2 x 5).

    (The free lecture on inventory control will help you)

    April 24, 2015 at 8:51 am #242427
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54659
    • ☆☆☆☆☆

    Third question:

    You have typed the question wrong – the holding cost is $2 per unit (not $20)

    You need to use the EBQ formula from the formula sheet.

    D = 6,000
    R = 12 x 5,000 = 60,000
    Co = 600
    Ch = 2

    If you put these figures into the formula then the answer comes to 2,000

    April 24, 2015 at 1:44 pm #242459
    Zainab
    Member
    • Topics: 5
    • Replies: 8
    • ☆

    Thank you very much,MrJohn Moffat in helping as the calculation was a bit difficult after several trial to get the answer.

    April 24, 2015 at 5:34 pm #242491
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54659
    • ☆☆☆☆☆

    You are welcome 🙂

    April 26, 2015 at 4:18 pm #242818
    Zainab
    Member
    • Topics: 5
    • Replies: 8
    • ☆

    Dear Mr.John Moffat,
    Can you assit me in answering the Acca June 2006 past exam question number 20 & 21 on process costing:
    20.A company operates a process costing system using the first-in-first-out(FIFO) method of valuation.No losses occur in the process.All materials are input at the commencement of the process.Conversion costs are incurred evenly through the process.
    The following data relates to last period:
    Units Degree of completion
    Opening work in progress 2,000 60%
    Total number of units completed 14,000
    Closing work in progress 3,000 30%
    $
    Cost arising:
    Materials 51,000
    Conversion 193,170

    what was the total number of units input during last period?
    A.12,000 B.13,000 C.15,000 D.17,000
    (i tried after several attempt, and get 15,000,is it right)

    21.What was the value of the closing work in progress for last period?
    A.$.21,330 B.$.21,690 C.$.22,530 D.$.22,890
    (unable to get the answer)

    Thanking you in advance

    Can you please explain to me the prevoius question on effective interest rate from opentuition mock exam.need for cbe very soon to be sat.

    April 26, 2015 at 4:51 pm #242824
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54659
    • ☆☆☆☆☆

    In future please start a new thread when you are asking a question on a different topic – this has nothing to do with budgeting or inventory management.
    (It is because we want everyone to be able to benefit from answers – we cannot simply be free private tutors)

    The ACCA does not publish past exam questions for Papers F1, F2, and F3 and so I do not know how you can say that these questions are from the June 2006 past exam!

    The answer to your first question is correct (15,000).

    For your second question, the cost per finished unit for materials is 51,000/(12,000+3,000) = $3.40
    The cost per finished unit for conversion costs is 193,170/((40%x2,000)+12,000+(30%x3,000)) = $14.10

    So the value of the closing WIP = (3,000 x $3.40) + (3,000 x 30% x $14.10) = $22,890

    (I do suggest that you watch the free lectures on process costing!)

    With regard to your previous question that you refer to in your last sentence, I think I have answered all of your previous questions.

    (I saw that you had asked for an electronic copy of a revision kit to be emailed to you. Sharing electronic copies is illegal and unethical – it is theft – and must not happen via this website. For that reason your post has been deleted. You must buy a revision kit – it is essential to practice from a revision kit before attempting the exam (as we make very clear throughout this website)

    April 26, 2015 at 7:55 pm #242844
    Zainab
    Member
    • Topics: 5
    • Replies: 8
    • ☆

    Topic Process costing:FIFO valuation
    Thank you for help.

    April 27, 2015 at 7:19 am #242879
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54659
    • ☆☆☆☆☆

    I still do not know which question of yours that you are referring to.

  • Author
    Posts
Viewing 10 posts - 1 through 10 (of 10 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 Professionalism, ethical codes and the public interest – ACCA Strategic Business Leader (SBL)
  • mrjonbain on Professionalism, ethical codes and the public interest – ACCA Strategic Business Leader (SBL)
  • kemo1000 on Financial instruments – convertible debentures – ACCA Financial Reporting (FR)
  • barbjohn on Equity Law, Ratio Decidendi – ACCA LW Global
  • Kakui on Equity Law, Ratio Decidendi – ACCA LW Global

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