Worksheet: Put list-price reviews on a calendar

List prices drift when nobody owns the review. This sheet sets a date and an owner for each product family and adds competitor and customer inputs to the next review. It builds the Competent step of the check:

List prices consider cost, competitor prices and customer feedback, and are reviewed on a calendar.

Step 1. The calendar

Product family	Review month	Owner	Inputs due	Decision by	Effective date
e.g. Galvanised tube	March and September	Pricing owner	1 March	15 March	1 April

Step 2. Inputs for the next review

Product family	List now	Cost since last review (%)	Competitor list (from the price file)	Customer feedback (sales, lost deals)	Proposed list	Reason
e.g. Galvanised tube	$1,900/t	+6%	$1,950 and $1,880	Two deals lost on lead time, none on price	$1,980	Cost is up and we sit below one competitor

Step 3. Check the list still means something

Product family	Share of invoices at list less a standard discount	Share with a manual price	Keep, rebase or restructure

When most invoices carry a manual price, the list has lost its meaning. Rebase it, or fix the structure, before the next review.

Step 4. Agree the base

Pick the index the list moves with, and write it down once.

Option	For	Against
Our cost	Simple to update	Ignores the market
A published input price	Customers can see it	Needs regular update
Market price	Tracks competitors	Needs a reliable price file

Done when: every product family has a review date and an owner, and the last review recorded cost, competitor and customer inputs.

Adapted from our own pricing diagnostic (PSP, 2011).