COGS Formula

Applying a COGS formula to determine profitability is useful in determining profitability. The cost to complete a sale to the customer exceeds the cost of acquiring the product (or materials to make that product). Between the time goods are received and delivery of the product to the customer, the business incurs direct expenses which include cost of raw materials, labor, assets, etc. All these costs should be proportionately added to the cost of each product sold when tracking inventory movement at your business; however, overhead costs are not calculated into COGS.

The Cost of Goods Sold Formula:

Beginning Inventory (inventory at the beginning of the time period) + Purchased Inventory (inventory acquired during the time period) – Ending Inventory (inventory left at the end of the time period) = Cost of Goods Sold

All the above figures should represent the same time period, i.e., calculate these numbers on a monthly, quarterly, or yearly basis for the same dates. To calculate the cost of goods sold, you will attribute accumulated direct costs with each inventory stage.

SOS Inventory makes it even easier with COGs software functionality built in.

A cost of goods sold formula example is as follows:

cogs formulaIf the business starts off with 100 units, then buys 50 units and sells 25 units, the cost of goods sold is the cost of 100 units plus the cost of 50 units less the cost of 25 units which equals the cost of 125 units.

In accounting, costs of goods sold reveals the costs associated with generating revenue from a product. These costs will vary from one business to another. If referring to a manufacturer, these costs can include ingredients or parts, labor, assets, storage, and shipping.

Overhead is calculated separately as these costs tend to be regularly monthly costs such as rent, electricity, internet service, etc. which have no impact on product volume. COGS is tied directly to inventory quantities and therefore can vary if the costs to sell an individual unit change.

Understanding the actual cost of goods sold allows your business to do a better job of pricing product or staying aware when costs to produce that product change. As sales increase so, too, do the costs of goods sold because costs will continue to be tied to selling those products. Normal accounting practices indicate the accrual of COGS during the same period as when they are sold.

Tracking cost of goods sold, gross profits and revenue available for overhead is simple to do with SOS Inventory. SOS Inventory records inventory costs and quantities at every stage so you can easily generate a report for any product to determine costs for the time period selected.

What’s more, SOS Inventory will update your QuickBooks Online account to ensure your ledger reflects your actual inventory counts and costs on hand, giving you timely information at your fingertips.

No need for manual COGS formula calculations or cross-referencing multiple spreadsheets from different departments. SOS Inventory gives you the information you need to make product pricing decisions or analyze cost fluctuations.

Thousands of companies use SOS Inventory to manage their businesses.    Free trial