MES & Shop FloorFree worksheetPDF, Excel, Word exportInfor VISUAL

Infor VISUAL Shop Labor Ticket Log Worksheet

Labor reporting drives work order cost, so bad entries distort every margin report downstream. This worksheet lets a supervisor collect or audit labor entries by work order and operation, see the cost immediately, and export the lot to Excel.

Download:

Work order	Operation	Employee	Hours type	Hours	Labor rate per hour	Good qty	Scrap qty	Labor cost	Scrap rate
								$48	0%
								$200	2.4%
								$98	0.8%
								$70	0%
								$271	0%

Total hours

Total labor cost

$687

Total scrap

Average cost per hour

$33

Entries logged

Use this as a paper or Excel backup while terminals are down, or to review a batch of entries before keying them into the ERP.

Labor data review

An optional look at how labor data reaches your cost reports.

Optional. The tool and every export work without this. No spam.

How to use the worksheet

Add one row per labor entry. Separate setup from run hours because most shops cost and analyze them differently. Enter good and scrap quantities from the same entry so the scrap rate calculates alongside cost. The totals line and average cost per hour update as you edit.

Keep one row per employee per operation per hours type
Use the loaded rate for the employee, not a plant average
Record scrap on the operation where it was found

The arithmetic

Labor cost is hours multiplied by rate. Scrap rate is scrap divided by good plus scrap, shown as a percentage. Average cost per hour is total cost over total hours, which is a quick way to spot a mix of cheap and expensive labor on one job. These match the plain calculations most costing reports use, though your system may add burden or overhead on top.

Common mistakes

The biggest source of error is hours attributed to the wrong operation or work order, which moves cost between jobs without changing the total. Also watch for setup hours booked as run, missing scrap, and entries left open overnight.

Open entries that run past a shift
Setup hours hidden inside run time
Rate typed for the wrong employee or department

Frequently Asked Questions

Is this a replacement for VISUAL labor reporting?

No. It is a worksheet for backup, review and training. Official labor transactions should still be posted through your ERP so costs, schedules and work order status stay correct.

Why separate setup from run hours?

Setup is a fixed cost per job and run time scales with quantity. Keeping them apart lets you see whether a quote assumed the right setup time and whether small lots are losing money.

Does the cost include overhead?

No. The cost column is hours times the rate you enter. If you want burden, enter a loaded hourly rate that already includes it.

Can I load existing data?

You can type or paste rows into the editable table, then export to Excel. For large volumes, export from your ERP into Excel directly and use this worksheet as a layout reference.

If labor data still needs to be re-keyed from paper or spreadsheets, we can look at ways to read it safely into your ERP reports. The worksheet needs nothing from us.

Talk to an Expert Explore More Free Tools