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. 💚

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. 💚

# What is the equation to be used here?

avalon1163
New MemberRegistered Posts:

**11**
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

591I 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....

18411all clear now.

All the best,

Sibylle