How to calculte COGS

[Anonymous]

Hello everyone

i am trying to create dummy dashboard from financial data. i have below data.

but i am not getting one thing how COGS calculate in that.

i have below formula ..

COGS=Beginning Inventory+Purchase- Ending Inventory

from above data i don't know which one is beginning and end inventory.

Please Help me to find out..

Thanks...

[andrei_delta]

hi,

COGS is Units Sold * Manufacturing Price

the sale is Units Sold * sales price

i think manufacturing price is an issue in your data...and also they multiplied by 10