Worksheet

Lighting BOM readiness worksheet

List each model and variant down the side, with columns for components, supplier, batch label, lead time and who updates the sheet. Mark the components two orders fought over last month. That column shows where a reserved stock record would help first.

Name: ______________________   Business: ______________________   Date: ______________

Cross out or rewrite any heading that does not fit your business. From the guide “Excel BOMs or Production Software for an LED Lighting Factory”, www.gullysystem.com/blog/excel-boms-or-production-software-for-an-led-lighting-factory