Let’s help Ken and create a new node of type Price. Ken can use the costing sheet setup form ( Inventory management / Setup / Costing / Costing sheets) to define aggregation of his costs. This is where the costing sheet becomes handy. Ken is troubled: in order to figure out the exact cost of consumed precious metals, he has no other choice than copying the data to Excel and running calculation there… or has he? Setting up the costing sheet to aggregate costs Unfortunately, the detailed view doesn’t provide any aggregation level. To do this, he navigates to details of BOM calculation ( Inventory management / Costing versions / Item price / Complete).

Ken, the cost controller is given the task to assess how the trend of raising precious metal prices is going to affect the cost of a particular finished good. The company procures raw materials: gold, silver, platinum and precious stones, and converts them into beautiful necklaces, rings, and earrings. Let’s start with a simple example: assume that our company produces jewelry. This short blog post explains in detail how to use the costing sheet functionality to classify and aggregate costs.