Cost of Goods Sold

It is time to start creating new fields to help you with your inventory analysis. You have plenty of information in your dataset to start making some calculations.

Using the disclosed costs for each item in the Stock table, your will start calculating the Cost of Goods Sold (COGS) to get an initial insight and to prepare for future calculations. COGS is the sum of costs for manufacturing or acquiring items, excluding delivery of goods, sellers, and marketing, sold by a company during a specific period of time.

We recommend you to keep working in your own workbook but if you lost progress you can open 1_2_cleaning_data_solution.twbx from the Workbooks folder on the Desktop.