Worksheet

Spreadsheet bill of materials health check

One page, one product per line. Columns record the current revision, the date of last change, the number of copies in circulation, approved alternates, planned versus issued variance, and a mark for pass or fail. Three worst rows go below.

Name: ______________________   Business: ______________________   Date: ______________

Scroll the table sideways to see every column.

Cross out or rewrite any heading that does not fit your business. From the guide “Bill of materials in Excel: when a consumer goods plant outgrows it”, www.gullysystem.com/blog/bill-of-materials-in-excel-when-a-consumer-goods-plant-outgrows-it