# Infor VISUAL Shop Labor Ticket Log Worksheet

> Source: https://netray.co/tools/visual-shop-labor-ticket-log-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable log of labor entries by work order operation with hours, rate, setup versus run and computed labor cost.

## Category

mes-shop-floor

## Erp

Infor VISUAL

## Audience

- Production supervisor
- Cost accountant
- Shop floor clerk

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Work order

**Key:** wo

**Type:** text

#### Operation

**Key:** op

**Type:** text

#### Employee

**Key:** employee

**Type:** text

#### Hours type

**Key:** type

**Type:** select

**Options:**

- Setup
- Run
- Rework

#### Hours

**Key:** hours

**Type:** number

**Format:** decimal

#### Labor rate per hour

**Key:** rate

**Type:** number

**Format:** currency

#### Good qty

**Key:** good

**Type:** number

**Format:** integer

#### Scrap qty

**Key:** scrap

**Type:** number

**Format:** integer

#### Labor cost

**Key:** cost

**Type:** number

**Expr:** hours * rate

**Format:** currency

#### Scrap rate

**Key:** scrap_pct

**Type:** number

**Expr:** scrap / max(good + scrap, 1) * 100

**Format:** percent

**Rows:**

**Wo:** W-10452

**Op:** 10

**Employee:** R. Patel

**Type:** Setup

**Hours:** 1.5

**Rate:** 32

**Good:** 0

**Scrap:** 0

**Wo:** W-10452

**Op:** 10

**Employee:** R. Patel

**Type:** Run

**Hours:** 6.25

**Rate:** 32

**Good:** 240

**Scrap:** 6

**Wo:** W-10452

**Op:** 20

**Employee:** M. Silva

**Type:** Run

**Hours:** 3.5

**Rate:** 28

**Good:** 234

**Scrap:** 2

**Wo:** W-10461

**Op:** 10

**Employee:** J. Okafor

**Type:** Setup

**Hours:** 2

**Rate:** 35

**Good:** 0

**Scrap:** 0

**Wo:** W-10461

**Op:** 10

**Employee:** J. Okafor

**Type:** Run

**Hours:** 7.75

**Rate:** 35

**Good:** 120

**Scrap:** 0

**Totals:**

#### Total hours

**Key:** hours

**Agg:** sum

**Format:** decimal

#### Total labor cost

**Key:** cost

**Agg:** sum

**Format:** currency

#### Total scrap

**Key:** scrap

**Agg:** sum

**Format:** integer

**Summary:**

#### Average cost per hour

**Key:** avg_rate

**Expr:** sum_cost / max(sum_hours, 0.0001)

**Format:** currency

#### Entries logged

**Key:** entries

**Expr:** count

**Format:** integer

**Notes:** 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.

## Content

**Intro:** 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.

**Sections:**

#### How to use the worksheet

**Body:** 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.

**Bullets:**

- 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

**Body:** 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

**Body:** 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.

**Bullets:**

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

**Cta:** 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.

**Faq:**

#### Is this a replacement for VISUAL labor reporting?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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.

## Search terms

visual labor ticket log, labor reporting worksheet excel, work order labor tracking template, shop floor time tracking excel, infor visual labor entry, setup and run hours log, labor cost per operation, manual labor ticket backup

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json