Cost, Price and Total Value Analytics

Introduction

Retail sourcing decisions are often distorted by an excessive focus on quoted unit price. A supplier offering the lowest price may generate higher logistics expense, duties, defects, working-capital requirements, markdowns, or disruption risk. Conversely, a higher-priced supplier may create superior total value through better quality, shorter lead times, stronger service, or lower lifecycle cost.

Cost, price and total value analytics provide a structured basis for comparing sourcing alternatives. They connect supplier economics with retail outcomes, including gross margin, inventory productivity, cash flow, customer value and resilience. The central managerial question is not simply “Which supplier is cheapest?” but “Which alternative delivers the required customer and business outcome at the lowest economically relevant cost and acceptable risk?”

Learning Objectives

By the end of this chapter, the reader should be able to:

1. Distinguish supplier cost, selling price, retail price, margin and markup.
2. Construct a cost breakdown and identify cost drivers.
3. Calculate landed cost and total cost of ownership.
4. Analyse duties, freight, payment terms, currency and inventory costs.
5. Evaluate lifecycle cost, quality cost and value-for-money trade-offs.
6. Use scenario and sensitivity analysis in supplier negotiations.
7. Recognise governance, ethical and regulatory risks in cost analytics.

1. The Architecture of Retail Economics

A retail transaction contains several economically different quantities:

The distinction between margin and markup is particularly important. If retail price is P and cost is C, then:

These formulas assume that price and cost are measured on the same basis, such as both excluding recoverable sales tax. A product costing $60 and selling for $100 therefore has a 40% margin but a 66.7% markup. Confusing these measures can cause major pricing and sourcing errors.

Price waterfalls

A price waterfall explains how an initial quoted price becomes an economically usable price. Typical adjustments include volume rebates, promotional allowances, early-payment discounts, logistics charges, duties, taxes, quality claims and other deductions. The waterfall should identify whether each item is included in the supplier quote, paid separately, recoverable, contingent or uncertain.

For example:

A discount should not be treated as a benefit unless its eligibility, timing and accounting treatment are verified. A nominal rebate that is difficult to earn may be less valuable than a smaller but certain price reduction.

2. Cost Breakdown Analysis

A cost breakdown decomposes price into operational drivers. A generic manufactured-product structure may include:

A more detailed model may include energy, tooling depreciation, compliance testing, financing, warranty provision and factory overhead. The correct level of detail depends on materiality, negotiation leverage and supplier transparency.

Cost-driver categories

Materials. Raw materials, components, trims and consumables may be analysed through quantity, yield, specification and market-index effects. A fabric price increase does not necessarily justify an equivalent product-price increase if fabric represents only part of total cost.

Labour. Labour cost depends on wage rates, productivity, overtime, learning curves and statutory benefits. A low wage rate may coexist with low productivity or high rework.

Conversion and overhead. Machinery, energy, maintenance, rent, supervision, quality assurance and factory administration may be allocated using different methods. Allocated overhead is not always avoidable; therefore, negotiation analysis should distinguish incremental cost from accounting allocation.

Packaging and compliance. Retail-ready packaging, labelling, testing, inspection and sustainability certification can materially affect cost.

Profit and risk allowance. Supplier profit is commercially legitimate, but should be assessed in relation to capabilities, capital employed, service requirements and market alternatives rather than removed mechanically.

Should-cost analysis

A should-cost model estimates what a product ought to cost under stated assumptions. It is not necessarily the supplier’s actual cost. It can be expressed as:

The model is useful for negotiation, bid evaluation and detecting unexplained variances. Its limitations include incomplete data, uncertain productivity, differing accounting practices and the danger of treating an estimate as an undisputed fact.

3. Landed Cost

Landed cost measures the cost of receiving a product at the intended destination. A practical formulation is:

Possible origin charges include export documentation, inland transport and port handling. Destination charges may include customs brokerage, terminal handling, storage, inspection and domestic delivery.

The formula must be adapted to the commercial term used. Under an international trade rule such as an Incoterm, responsibility and risk transfer at specified points. The analyst must verify whether freight, insurance and export or import formalities are already included. Adding a charge twice is a common modelling error.

Duties and customs value

Duty is generally calculated from the customs value and applicable tariff rate:

If customs value is based on the transaction value, it may include specified additions such as assists, royalties or certain commissions, subject to local law. The tariff classification, country of origin, preferential agreement and valuation method must be verified by customs specialists. Duty treatment is jurisdiction-specific and should never be inferred solely from a supplier quotation.

Worked example: landed cost

A retailer imports 10,000 units. The net supplier price is $18 per unit. Origin charges are $0.40 per unit, freight is $1.20, insurance is $0.10, and destination charges are $0.80. Duty is 8% of customs value, assumed here to be supplier price plus freight and insurance. A non-recoverable import tax of $0.50 applies per unit.

Customs value per unit:

Duty per unit:

Landed cost per unit:

Rounded to cents, landed cost is $22.54 per unit, or approximately $225,440 for 10,000 units. The calculation assumes that all listed charges are incremental, that the tax is non-recoverable, and that the stated customs valuation rule applies.

4. Total Cost of Ownership

Landed cost is necessary but not sufficient. Total cost of ownership (TCO) includes costs that arise before, during and after the purchase. A general model is:

The exact categories depend on the product and decision horizon.

Important TCO components

Acquisition cost includes price, tooling, moulds, samples, development fees and minimum-order commitments.

Quality cost includes inspection, testing, rework, returns, warranty, customer service and lost sales. Expected defect cost can be estimated as:

This is a probability-weighted estimate. It should be based on credible historical or pilot data, not an unsupported assumption.

Inventory cost includes capital tied up in stock, storage, insurance, handling, obsolescence and shrinkage. A simple annual holding-cost estimate is:

The holding rate may include financing, storage, insurance, damage and obsolescence. If average inventory is $500,000 and the annual holding rate is 24%, annual holding cost is $120,000.

Transaction cost includes sourcing events, supplier audits, contract administration, invoice processing, systems integration and relationship management.

Operating cost is especially important for equipment, technology, fixtures and services. It may include energy, maintenance, labour, consumables, downtime and software support.

End-of-life cost includes disposal, recycling, product withdrawal, data destruction, reverse logistics and environmental compliance. Salvage value or recycling revenue is a benefit and may be deducted if sufficiently certain.

TCO versus lifecycle cost

TCO is commonly used for procurement ownership decisions. Lifecycle cost is broader and covers the full economic life of an asset or product, including use and disposal. For short-life fashion products, markdown and obsolescence may be more significant than maintenance. For retail technology or refrigeration equipment, energy and service costs may dominate the initial purchase price.

5. Time Value of Money and Payment Terms

Payment terms affect cash flow and the economic value of a purchase. A dollar paid later is generally worth more to the buyer than a dollar paid immediately, assuming the buyer can use the cash productively.

For a single future cash flow:

where r is the period discount rate and t is the number of periods. The rate must match the period and risk basis.

For a sequence of cash flows:

A positive net present value indicates value creation relative to the selected discount rate, subject to reliable cash-flow estimates.

Payment terms can be compared through an implicit discount. Suppose a supplier offers either payment of $100 after 60 days or $98 after 10 days. The buyer gives up $2 to retain cash for 50 additional days. The annualised simple cost of taking the early-payment discount is approximately:

The comparison is approximate and assumes a 365-day year, no compounding and equal service conditions. It should be compared with the buyer’s relevant financing cost and liquidity position.

6. Margins, Markdown and Retail Value

Sourcing decisions must be linked to expected retail performance. A supplier price that improves initial margin may still reduce realised profit if it increases defects, stockouts or markdowns.

If units sold at regular price are Q_r and units sold at markdown price are Q_m, realised revenue is:

If total units sold are Q, realised gross profit is:

This approach is superior to evaluating margin only at the initial ticket price. It incorporates demand uncertainty and markdown exposure.

A useful expected-value model is:

Scenarios may include strong demand, base demand, weak demand, supplier delay or quality failure. Expected value does not eliminate risk; it summarises outcomes under stated probabilities. Decision-makers should also examine downside exposure and probability distributions where possible.

7. Value-for-Money and Multi-Criteria Evaluation

Value for money is not synonymous with lowest cost. It considers the relationship between total cost, performance, risk and strategic outcomes. A supplier may create value through:

• higher sell-through;
• lower defect and return rates;
• faster replenishment;
• better availability and fewer stockouts;
• lower energy consumption;
• improved customer experience;
• compliance and reputational protection; and
• innovation or data capability.

A weighted scoring model can support structured comparison:

where j identifies a supplier and i identifies a criterion. Weights should sum to 1, and scores must be defined consistently. Scoring is not a substitute for financial analysis: a high qualitative score should not conceal an unacceptable cost or compliance risk.

A stronger approach is to monetise material benefits and retain a transparent scorecard for benefits that cannot be reliably monetised. Sensitivity testing should show how supplier rankings change when weights, exchange rates, demand or quality assumptions change.

8. Scenario and Sensitivity Analysis

Sensitivity analysis changes one assumption at a time to identify influential variables. Scenario analysis changes several related assumptions to represent coherent futures.

For an imported product, major sensitivities may include:

• exchange-rate movement;
• freight rate and fuel surcharge;
• tariff classification or duty rate;
• demand and markdown rate;
• defect and return rate;
• order quantity and minimum order;
• lead time and safety stock; and
• payment period and financing rate.

A break-even analysis can identify the maximum acceptable price difference. If Supplier A costs $1 more per unit but reduces expected quality and markdown costs by $1.40, Supplier A creates a net benefit of $0.40 per unit before other effects. The comparison should use equivalent service levels and time horizons.

9. Applied Case: Choosing a Private-Label Supplier

The following is an illustrative case.

Background

A fashion retailer is sourcing 50,000 units of a private-label jacket. Supplier A is geographically close; Supplier B is offshore. The retail price is expected to be $80 per unit.

Initial quotations

Analysis

Landed cost for Supplier A is:

Landed cost for Supplier B is:

Supplier B appears cheaper by $1.45 per unit on landed cost. However, expected defect cost is:

Adding quality, markdown and inventory costs produces an indicative TCO:

Supplier A has the lower estimated TCO by $2.97 per unit, or $148,500 across 50,000 units. At an $80 retail price, the indicative gross contribution before other selling expenses is:

Approach and outcome

The retailer should not immediately award the contract solely on this model. It should validate defect data through samples or a pilot, verify duty assumptions, test lead-time reliability and examine capacity. It may negotiate with Supplier B on quality improvement and with Supplier A on price. A dual-source arrangement could reduce disruption risk, although it may sacrifice volume economies.

Learning points

1. Landed cost can reverse the ranking based on quoted price.
2. Expected quality and markdown effects can be financially material.
3. TCO results depend on assumptions and require validation.
4. Resilience and strategic capability may justify a portfolio decision rather than a single-supplier award.

10. Governance, Ethics and Regulation

Cost analytics can create governance risks when assumptions are hidden or data are manipulated. Good practice requires:

• documented definitions and cost boundaries;
• version-controlled models;
• independent review of material assumptions;
• separation of fact, estimate and judgement;
• clear treatment of taxes and rebates;
• audit trails for supplier-provided data;
• confidentiality controls for cost information; and
• compliance with customs, competition, labour, environmental and anti-bribery laws.

Buyers should not demand commercially sensitive information without a legitimate purpose or use cost transparency to impose prices that make lawful production impossible. Ethical sourcing requires attention to wages, working conditions, forced labour, environmental impacts and supplier financial viability. A price reduction achieved through unsafe or unlawful practices is not genuine value creation.

Artificial intelligence can assist with invoice classification, anomaly detection, freight forecasting, commodity-index monitoring and scenario generation. However, AI outputs require human validation. Risks include biased historical data, fabricated explanations, confidentiality leakage, inaccurate tariff classification and overconfidence in estimated probabilities. Models should preserve source references, assumptions and approval controls.

11. Best-Practice Implementation

A robust cost and value process generally follows these steps:

1. Define the decision, time horizon, currency and cost boundary.
2. Establish a common commercial basis for all suppliers.
3. Reconcile quotations with Incoterms, specifications and service levels.
4. Build a transparent cost breakdown and landed-cost model.
5. Add quality, inventory, operating, transaction and end-of-life costs.
6. Link cost assumptions to retail demand, markdown and margin outcomes.
7. Test scenarios, sensitivities and downside risks.
8. Validate material assumptions through samples, audits or historical data.
9. Negotiate drivers rather than only the final price.
10. Monitor realised cost and value after award through variance analysis.

A post-award variance can be expressed as:

The variance should then be decomposed into price, quantity, mix, volume, exchange-rate, freight and quality effects. This converts sourcing analytics from a one-time bid exercise into a continuous performance-management system.

Challenges and Limitations

TCO models may create false precision when data quality is poor. Probabilities of defects, markdowns or disruption are often uncertain. Allocated overhead can be confused with avoidable cost, while benefits such as brand protection are difficult to monetise. Different suppliers may define quality, lead time or service level differently. Currency and tariff conditions can change rapidly. Finally, optimising expected cost may increase concentration risk and reduce resilience.

The appropriate response is not to abandon analytics, but to disclose assumptions, use ranges, conduct sensitivity analysis and combine quantitative evidence with managerial judgement. A sound decision is transparent and revisable rather than merely numerically sophisticated.

Chapter Summary

Cost, price and total value analytics enable retailers to evaluate sourcing alternatives on an economically comparable basis. Supplier price, landed cost, margin, markup and TCO are distinct concepts and must not be conflated. Landed cost incorporates logistics, insurance, duties, destination charges and non-recoverable taxes, while TCO extends the analysis to quality, inventory, transaction, operating and end-of-life costs.

Cost breakdowns and should-cost models reveal underlying drivers and support principled negotiation. Payment terms and timing should be analysed using present value and financing logic. Retail outcomes require attention to realised revenue, markdowns, defects and sell-through rather than only initial ticket margin. Scenario, sensitivity and expected-value analysis make uncertainty visible. Finally, value-for-money decisions must incorporate resilience, compliance, ethics, sustainability and supplier capability. The most effective sourcing decision is therefore the one that delivers the required value at an acceptable total economic and strategic risk.

Key Terms

Cost breakdown: Decomposition of a price into materials, labour, overhead, logistics, profit and other components.

Landed cost: Cost of acquiring and delivering goods to the specified destination, including relevant duties and charges.

Total cost of ownership: All significant costs incurred over the acquisition, use, management and disposal of an item.

Lifecycle cost: Economic cost across the full life of an asset, product or service.

Gross margin: Gross profit divided by sales revenue.

Markup: Gross profit divided by cost.

Price waterfall: Reconciliation from list price to effective net price after discounts, rebates and surcharges.

Should-cost analysis: Estimate of cost based on operational inputs, benchmarks and reasonable assumptions.

Customs value: Value used by authorities to calculate import duty.

Duty: Import charge calculated according to applicable customs rules and rates.

Incoterm: Standardised international trade term allocating responsibilities, costs and risk.

Quality cost: Cost of prevention, appraisal, failure, returns, rework and warranty.

Inventory holding cost: Cost of financing, storing, insuring and risking inventory.

Markdown: Reduction from the original retail price.

Net present value: Present value of future cash flows less initial investment.

Sensitivity analysis: Examination of the effect of changing one or more assumptions.

Scenario analysis: Evaluation of coherent alternative future conditions.

Value for money: Relationship between total cost, performance, benefits and risk.

Implicit financing cost: Economic cost embedded in a payment-term choice.

Cost variance: Difference between actual and budgeted or standard cost.

Review Questions

Short Answer Questions

1. Distinguish gross margin from markup.
2. What costs are normally included in landed cost?
3. Why can quoted price be a poor basis for supplier selection?
4. Define total cost of ownership.
5. What is the purpose of sensitivity analysis?

Long Answer Questions

1. Explain how a retailer should construct a cost breakdown for a private-label product.
2. Discuss the relationship between landed cost, TCO and lifecycle cost.
3. Explain how payment terms affect sourcing economics using present-value reasoning.
4. Evaluate the strengths and limitations of should-cost analysis.
5. Discuss how ethical and regulatory issues influence value-for-money decisions.

Analytical / Application Questions

1. A supplier quotes $22 per unit. Freight is $1.50, insurance is $0.20, duty is 10% of customs value consisting of price plus freight and insurance, and destination charges are $0.80. Calculate landed cost per unit.
2. Supplier X has TCO of $38 per unit with a 3% defect rate; Supplier Y has TCO before quality cost of $35 per unit with a 7% defect rate. If each defective unit costs $20, compare their total expected cost.
3. Construct a three-scenario model for a sourcing decision involving demand, markdown, exchange-rate and quality uncertainty. Identify which assumptions most require validation before contract award.

Multiple Choice Questions with Answers

Question 1

A product costs $60 and sells for $100. What is its gross margin?

A. 40%

B. 60%

C. 66.7%

D. 166.7%

Correct Answer: A. 40%

Question 2

Which item is normally included in landed cost?

A. Retailer’s future advertising campaign

B. Applicable import duty

C. Supplier’s unrelated corporate tax

D. Consumer loyalty points not yet issued

Correct Answer: B. Applicable import duty

Question 3

A product has a 5% defect probability and each defect costs $12. What is expected defect cost per unit?

A. $0.05

B. $0.60

C. $2.40

D. $12.60

Correct Answer: B. $0.60

Question 4

Which statement best distinguishes markup from margin?

A. Markup is based on sales revenue, while margin is based on cost

B. Markup and margin are always identical

C. Markup is based on cost, while margin is based on sales revenue

D. Markup excludes supplier profit

Correct Answer: C. Markup is based on cost, while margin is based on sales revenue

Question 5

A customs value is $25 per unit and the duty rate is 8%. What is the duty per unit?

A. $0.80

B. $2.00

C. $3.13

D. $33.00

Correct Answer: B. $2.00

Question 6

Which cost is most directly associated with capital tied up in inventory?

A. Inventory holding cost

B. Retail ticket price

C. Supplier markup

D. Customs classification

Correct Answer: A. Inventory holding cost

Question 7

What is the principal purpose of a price waterfall?

A. To forecast consumer population growth

B. To reconcile list price to effective net price

C. To calculate employee turnover

D. To determine product colour assortment

Correct Answer: B. To reconcile list price to effective net price

Question 8

Which method changes one assumption at a time to assess its effect on an outcome?

A. Sensitivity analysis

B. Scenario analysis

C. Random sampling only

D. Supplier segmentation

Correct Answer: A. Sensitivity analysis

Question 9

A retailer pays $98 after 10 days instead of $100 after 60 days. The retailer gives up $2 to retain cash for an additional period. This is best interpreted as:

A. An implicit financing cost of taking the early-payment discount

B. A customs duty reduction

C. A reduction in defect probability

D. A change in retail markup only

Correct Answer: A. An implicit financing cost of taking the early-payment discount

Question 10

Which statement best reflects value-for-money analysis?

A. The lowest quoted price always creates the greatest value

B. Value depends only on supplier profit

C. Value considers cost, performance, benefits and risk

D. Value excludes quality and resilience

Correct Answer: C. Value considers cost, performance, benefits and risk