Budgeting (AQ 2013) - Sample Assessment 1, Task 1.3 (b)

Hello all. I am wondering if somebody could help me with Task 1.3 (b) with regards to Sample Assessment 1 for Budgeting. My mind has gone blank.

In the Operating Budget, the 'Closing inventory of finished goods' is £179,080 and the Cost of goods sold is £1,266,720. How are these both worked out?

Thank you for your help :)

Comments

  • SandyHood
    SandyHood Registered, Moderator Posts: 2,034 mod
    You need to establish whether FIFO or AVCO is being used to value the inventory.
    I think this question says cost of purchases should be used. In other words, the opening inventory value is used in production along with some of the purchased inventory and all the closing inventory is valued at the cost per unit purchased in the period.

    Does that make sense?
    Sandy
    sandy@sandyhood.com
    Sandy
    sandy@sandyhood.com
    www.sandyhood.com
  • SandyHood
    SandyHood Registered, Moderator Posts: 2,034 mod
    To find cost of goods sold you add up the values for opening inventory and purchases, and take off the closing inventory. This approach works whether FIFO or AVCO is used.
    Sandy
    Sandy
    sandy@sandyhood.com
    www.sandyhood.com
  • thebigalbowski
    thebigalbowski Registered Posts: 2
    Hi Sandy

    Yes, this makes sense. Thank you very much for your help :)
  • Patricia
    Patricia Registered Posts: 3
    Hi,

    Did you find out how to get the closing inventory of 'Closing inventory of finished goods' is £179,080? I am having a blackout, very stuck on this one. Any help is appreciated. Thank you :-)
  • SandyHood
    SandyHood Registered, Moderator Posts: 2,034 mod
    Patricia
    1. work out the purchase cost per kg (or litre)
    2. find the physical number of kgs in the closing inventory
    3. multiply the number of kgs by the cost per kg
    Sandy
    sandy@sandyhood.com
    www.sandyhood.com
  • Patricia
    Patricia Registered Posts: 3
    Sandy, thank you
    Please see below how I did:
    purchase price: 598000/460000=1.3
    closing inventory of finished goods = 81,400 x1.3=105820
    material closing inventory = 68250 x1.3= 88725
    Still not getting £179080, can you please show me what I am doing wrong?
  • SandyHood
    SandyHood Registered, Moderator Posts: 2,034 mod
    Patricia

    Don't muddle up raw materials with finished goods.
    Look at your posting. How can finished goods be worth the same per unit as materials that haven't been worked on?
    Finished goods inventory is valued using cost of production.
    Unlike you I cannot access the questions, but I recall there being a small print note that closing inventory of finished goods was valued using the cost per unit produced.
    Look at all the cost of production inputs: materials, labour and overheads and add them up. Then divide by the number produced. This gives you the cost of production on a per unit basis.
    Find the closing inventory of finished goods (in units) and multiply by the cost per unit.
    Sandy
    sandy@sandyhood.com
    www.sandyhood.com
  • Komal
    Komal Registered Posts: 1
    edited July 2017
    i think its (total production cost / budgeted production level) x budgeted closing inventory of finished goods
    1295800/589000 = 2.2 x 81400
    = £179080

    cost of sales then will be = 150000+1295800-179080= 1266720
Privacy Policy