Skip to content
Shop | Excel system

Value Analysis System

Portfolio, cost statement, functions, paired comparison, function cost matrix, idea list with customer gate, requirements matrix, target cost per component, business case, savings tracker and audit.

Screenshot of the Value Analysis System workbook with example data
Example data from the workbook.

How it works

  1. 02 Setup: product, quantity, prices, margin and overhead rate. 03 Portfolio: compare your products and choose the object.
  2. 04 Cost: the cost statement per component. 05 Functions: verb plus noun, type and measure.
  3. 06 Paired Comparison: importance from the customer point of view. 07 Function Cost: matrix, value index and search fields.
  4. 08 Ideas: every idea with function, component, saving, one-time cost, customer effect, risk, decision, status and month.
  5. 09 Requirements: customer requirements, technical characteristics, required and actual values.
  6. 10 Target Cost: target per component and the business case. 11 Savings Tracker: planned and confirmed savings per month.
  7. 12 Audit after every study. 13 Status in every review with the sponsor.

Definitions used in the workbook

  • Value index: Importance share / cost share. Below 0.8: search field. Above 1.2: protect.
  • Gate: An idea with a minus for the customer on a protected function is rejected, whatever it saves.
  • Confirmed: The change is in the bill of material, the routing or the purchase price, first units are built and controlling has confirmed the new cost.
  • Direct saving: Full cost saving / (1 + overhead rate). The overhead share becomes cash only when overhead cost falls.

Sheets in the workbook

  1. Start
  2. Setup
  3. Portfolio
  4. Cost
  5. Functions
  6. Paired Comparison
  7. Function Cost
  8. Ideas
  9. Requirements
  10. Target Cost
  11. Savings Tracker
  12. Audit
  13. Status

Who it is for

Heads of product lines, engineering managers and controllers who have to reach a target cost and prove the saving.

The method behind the numbers

This workbook is part of the Value Analysis and Value Engineering toolkits. The Starter Kit adds the guide and the checklist for the first 30 days. The Excellence Bundle adds playbook, workshop pack, templates, deck and the complete Excel system.

Newsletter

One Lean idea.
Every two weeks.