Skip to main content

Amortized vs Consolidated Price, and Excess Pricing

P
Written by Prarthana Gupta

Understanding Consolidated Amortized Price, Amortized Price, and Excess Pricing in Cableteque

Objective

This explains how to identify and interpret the Price, Excess Cost, Consolidated Assembly Price, and Amortized Price fields in Cableteque. It helps team members accurately read part pricing and understand how excess pricing affects the final amortized value.

Key Steps

1. Identify the pricing columns in Cableteque 0:07

generated-image-at-00:00:07

  • Locate the pricing fields on the right-hand side of the part record.

  • Confirm the meaning of each column before using the values in reporting or analysis.

  • Key fields to identify:

    • Price

    • Excess

    • Amortized Price

  • Use the column labels to avoid confusing standard pricing with excess-related pricing.

2. Review the example part values 0:22

generated-image-at-00:00:22

  • Use the displayed part number as a reference example.

  • Note the sample values shown in the transcript:

    • Price: $12.16

    • Excess Cost: $18.64

    • Amortized Cost: $30.40

  • Compare these values to understand how the pricing fields relate to one another.

  • Verify that the values you are reviewing are in the correct columns before calculating or reporting totals.

3. Calculate the consolidated assembly price 0:39

generated-image-at-00:00:39

  • Add together the standard Price values to determine the Consolidated Assembly Price.

  • Do not include excess cost in this calculation.

  • Use this total when you need the base assembly price without excess charges.

  • Confirm the result matches the consolidated pricing shown in Cableteque.

4. Calculate the amortized price 0:39

generated-image-at-00:00:39

  • Start with the Consolidated Assembly Price.

  • Add the Excess amount to arrive at the Amortized Price.

  • Use this formula:

    • Amortized Price = Consolidated Assembly Price + Excess

  • Apply this method whenever you need the full assembly cost including excess pricing.

Cautionary Notes

  • Do not include excess cost when calculating the consolidated assembly price.

  • Make sure you are reading the correct column labels, since Price, Excess, and Amortized Price represent different values.

  • If the displayed values do not align with the expected formula, verify the part record before using the numbers in reporting.

  • Use the same pricing logic consistently across all parts to avoid inaccurate totals.

Tips for Efficiency

  • Always confirm the column headers first before performing any calculation.

  • Use the example values as a quick reference when training new team members.

  • Standardize the formula:

    • Consolidated Assembly Price = Price only

    • Amortized Price = Consolidated Assembly Price + Excess

  • When reviewing multiple parts, check the pricing fields in the same order each time to reduce errors.

Link to Loom

Did this answer your question?