Excel-based Production Scheduling System Free Download
Work Order Tracking Template: Progress Report Template of your shop-floor Operations
Work Order Tracking Template as the progress report template help you monitor your shop-floor operations by tracking on production process / work order status at all shop floor area and help you fix potential issue before effect on shipment delay!
Worksheet#1 [Define Operation & Start Date]
Step 1 - Define Operation Name (max. 5 operations)
Step 2 - Define start date for all date fields in this template.
Worksheet#2 [Work Order Log - OP-1]
Step 3 - Entry work order data ( work order no.,item name,order quantity, and order issue date )
Step 4-7 - At each operation whenever a work order has been finished, entry that order with issue date. work order number will be listed from operation-1's data using data validation feature.
Worksheet#7 [W/O Tracking Report]
Step 8 - Use [Ctrl][Alt][F5] to refresh data from all operations, you can see report like above picture.
Return from Work Order Tracking Template to Basic Production Templates Pack