Finding Cost of Goods Sold

[#1]

Hi, I have a product table , by this i need to find the cost of goods sold.

Product:

LOAD ProductID,

     Name ,

     ProductNumber,

     MakeFlag,

     FinishedGoodsFlag,

     Color,

     SafetyStockLevel,

     ReorderPoint,

     StandardCost,

     ListPrice,

     Size,

     SizeUnitMeasureCode,

     WeightUnitMeasureCode,

     Weight,

     DaysToManufacture,

     ProductLine,

     Class,

     Style,

     ProductSubcategoryID,

     ProductModelID,

     SellStartDate,

     SellEndDate,

     DiscontinuedDate

FROM

E:\Task\Excel\Product.xlsx

(ooxml, embedded labels, table is Product);

How i can Get the Cost Of goods Sold, i can not understand which formula i need to use

Please help me.

[#2]

Hi there,

You will probably need to have a word with your finance department as they have different ideas about things (and might add more info in than what you have).

However I would have it as the sum of the [standard cost] field for products that have been sold. Do you have another table with sales in?

Erica

[#3]

Hi Need Help,

I think this is a question best directed towards whoever collected the data for you.  Its not really a matter of formulas at this point for you, its more a matter of what your fields actually represent