
How it works
- Open 02 Setup. Enter the product, units per year, price today, market price, required margin and your overhead rate.
- Enter one row per component in 03 Cost with material and manufacturing cost in EUR per unit. The total must equal your standard cost.
- Describe the functions in 04 Functions as verb plus noun, choose the type and distribute the importance points from the customer point of view.
- Spread each component across the functions in 05 Function Cost in percent. Every row must add up to 100 percent.
- Read the value index in 05 Function Cost and the summary in 06 Status. Search fields are the functions to work on first.
Definitions used in the workbook
- Function: What the product does, written as a verb plus a noun. The solution stays open.
- Function cost: The share of each component cost that serves the function, added up over all components.
- Importance: The share of points a function gets from the customer point of view.
- Value index: Importance share / cost share. Below 0.8: search field. Above 1.2: protect.
- Target cost: Market price x (1 - required margin).
Sheets in the workbook
- Start
- Setup
- Cost
- Functions
- Function Cost
- Status
Who it is for
Design engineers, product managers and controllers who start a value study on one product.
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.