Home For AAT student members AQ 2013 AAT Level 3 (Level 6 in Scotland)
Current updates regarding coronavirus (Covid-19) and the precautions AAT are taking will be continually updated on the below page.

Please check this link for the latest updates:
We hope you are all safe and well and if you need us we will be here. 💚


Missing Figures

Has anyone got any tips for calculating missing figures and the use of mark up and margin?

Thanks

Answers

  • LoopsterLoopster Registered Posts: 24
    Any question specific? or just in general? Or use of mark-up and margin to calculate missing figures??

    Here are a few basics (which you may already know) apologies if you do.

    Learn your postings in control ledgers mainly for missing figures. Only ever 2 entries on the debit side of the SLCA: Bal b/d and SDB. Only ever 2 entries on the credit side of the PLCA: Bal b/d and PDB.

    So for example. If it asks you to find the discounts allowed figure, you know it's definitely a credit figure in the SLCA you are looking for.

    Learn the VAT control account too. Just follow the "PEARLS" principle (Purchases, Expenses, Assets Debit Revenue Liabilities Sales Credit)

    Opening Inventory + Purchases- Closing Inventory = (COGS) Cost of Goods Sold. So if you are asked to find any of those, as long as you know that you should be fine

    Mark up is always on the cost of goods sold (COGS). COGS represents 100%, and if the mark-up is 25% this represents the profit therefore sale price is 125%

    Margin is always on the sale price. Sale Price represents 100%, if margin is 25% this again represents profit so COGS = 75%

    Quick example:
    • Sales for the year are £100,000
    • Gross profit margin is 25%
    • Opening Inventory is £10,000
    • Closing inventory is £12,000

      What are the purchases for the year??

      Because it's profit margin, sales represents 100%, Margin is 25% Cost of Goods Sold = 75%

      Remember the equation:

      OI+purchases-CI=COGS

      First calculate COGS. £100,000 x (100-25/100) = £75,000

      Now we have £10,000 + ? - £12,000 = £75,000

      So £75,000 +£12,000 =£87,000 - £10,000 = purchases of £77,000

      Just to double check
      Opening Inventory + Purchases - Closing Inventory = Cost of Goods Sold
      £10,000 + £77,000 - £12,000 = £75,000

      Hope this helps.
    lindsk87
Sign In or Register to comment.