What is the equation to be used here?
avalon1163
Registered Posts: 11 Regular contributor ⭐ ? ⭐
Hi,
I have the following situation: £92000 (no VAT) are the total sales and I know that the GP margin is 28%.
Therefore the GP margin is £25536 and the Cost of Goods is £65664  so far so good.
BUT next question is: the inventory has increased by £4036  calculate the Purchase figure.
I added the COS and the increase together because, in the absence of the formula, it appeared to be the only correct thing to do.
However, can anyone explain the reasoning behind this please? If I assume that the opening inventory is x AND I am looking for the purchase figure AND the closing inventory is x+4036 then I get the following:
COS = x + p  (x+4036)
Two variables!!
Help please!
Thank you very much,
Sibylle
I have the following situation: £92000 (no VAT) are the total sales and I know that the GP margin is 28%.
Therefore the GP margin is £25536 and the Cost of Goods is £65664  so far so good.
BUT next question is: the inventory has increased by £4036  calculate the Purchase figure.
I added the COS and the increase together because, in the absence of the formula, it appeared to be the only correct thing to do.
However, can anyone explain the reasoning behind this please? If I assume that the opening inventory is x AND I am looking for the purchase figure AND the closing inventory is x+4036 then I get the following:
COS = x + p  (x+4036)
Two variables!!
Help please!
Thank you very much,
Sibylle
0
Comments

Think it through step by step in terms of what has actually happened rather than in terms of an equation.
I find it easiest to start by asking myself what are my cost of sales ?
I have some opening stock
I purchase some more stock
I still have some left in inventory at the end of the period so this isn't incluced in my cost of sales.
In other words: Opening Stock + Purchases  Closing stock = Cost of Sales.
You can rearrange this any way you like, so to get to purchases
Purchases = Cost of Sales + Closing stock  opening stock
If you think the rearranged forumula through the cost of what you purchased consists of:
The stock you have sold + The stock you still have LESS the cost of what you already had when you started.
Hope that makes sense....0 
Indeed! Visualise the question. Imagine you are Joe Bloggs in X Ltd. Imagine the materials and the process you go through. You need to apply the learning to a situation, otherwise it is just words.0

Thank you very much for taking the time to reply:
all clear now.
All the best,
Sibylle0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 18.9K For AAT students
 247 NEW! Qualifications 2022
 137 General Qualifications 2022 discussion
 8 AAT Level 2 Certificate in Accounting
 33 AAT Level 3 Diploma in Accounting
 59 AAT Level 4 Diploma in Professional Accounting
 8.9K For accounting professionals
 23 coronavirus (Covid19)
 274 VAT
 92 Software
 274 Tax
 136 Bookkeeping
 7.3K General accounting discussion
 193 AAT member discussion (AATQB, MAAT, FMAAT and AAT Licensed Accountants and Bookkeepers)
 3.8K For everyone
 39 AAT news and announcements
 352 Feedback for AAT
 2.8K Chat and offtopic discussion
 589 Job postings
 17 Who can benefit from AAT?
 36 Where can AAT take me?
 44 Getting started with AAT
 26 Finding an AAT training provider
 48 Distance learning and other ways to study AAT
 25 Apprenticeships
 65 AAT membership