Cost Sheet

From Aligni Wiki

You can quickly determine the cost to build one or more of a particular assembly using the Cost Sheet feature of Aligni.

The cost sheet pulls together the inventory costs and min/max quotes for all the parts on a bill of materials (BOM). It can also use price breaks in your quotes to determine the costs of a particular number of units.

Basic Cost Sheet

Shown below is the cost sheet of a device in our demo database. It lists each part on the BOM, the quantity of that part on the BOM, and various pricing information:

• Min Quote - The minimum quote available. This will be blank if no quotes are listed for the part.
• Max Quote - The maximum quote available. This will be blank if no quotes are listed for the part.
• Inventory - The inventory price stored with the part details.

The extended costs are also listed by multiplying the BOM quantity by the appropriate unit cost figure.

At the bottom of the BOM, you can see a total of the extended costs. These are also listed in the summary box at the top of the page.

Target Cost Sheet

You can also specify a quantity at which to compute costs. Aligni will then use this quantity to choose quotes at available price breaks that minimize the total cost of the build including excess materials. That is, Aligni will choose to buy a larger quantity if the total cost including excess is less than if you were to buy at a smaller quantity. The cost estimate computed this way will always be monotonically increasing with increasing quantity; you will not have a situation where increasing quantity decreases cost.

The complete cost sheet is shown below. The new column 1,000 pcs. indicates the prices per line item at the target quantity. In the extended column, excess quantities are indicated in blue. This is how many extra components were required to meet the next price break.