# Maintenance Job Plan Labor and Cost Estimate Worksheet

> Source: https://netray.co/tools/maintenance-job-plan-labor-estimate-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Build a task-level job plan with crew size, hours, rates and parts, and export total man-hours and cost to Excel.

## Category

maintenance

## Industry

Manufacturing

## Audience

- Maintenance planner
- Maintenance supervisor
- Reliability engineer

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Task

**Key:** task

**Type:** text

#### Craft

**Key:** craft

**Type:** select

**Options:**

- Mechanic
- Electrician
- Instrument tech
- Millwright
- Welder
- Operator
- Contractor

#### Crew size

**Key:** crew

**Type:** number

#### Hours per person

**Key:** hrs

**Type:** number

**Format:** hours

#### Man-hours

**Key:** mh

**Type:** number

**Expr:** crew * hrs

**Format:** hours

#### Loaded rate per hour

**Key:** rate

**Type:** number

**Format:** currency

#### Labor cost

**Key:** labor

**Type:** number

**Expr:** mh * rate

**Format:** currency

#### Parts and materials

**Key:** parts

**Type:** number

**Format:** currency

#### Task total

**Key:** total

**Type:** number

**Expr:** labor + parts

**Format:** currency

**Rows:**

**Task:** Lock out, isolate and tag

**Craft:** Electrician

**Crew:** 1

**Hrs:** 0.5

**Rate:** 52

**Parts:** 0

**Task:** Drain and remove guard

**Craft:** Mechanic

**Crew:** 2

**Hrs:** 1

**Rate:** 46

**Parts:** 0

**Task:** Replace drive-end bearing and seal

**Craft:** Millwright

**Crew:** 2

**Hrs:** 3.5

**Rate:** 50

**Parts:** 420

**Task:** Align motor and coupling

**Craft:** Millwright

**Crew:** 2

**Hrs:** 1.5

**Rate:** 50

**Parts:** 35

**Task:** Refit guard, test run and vibration check

**Craft:** Mechanic

**Crew:** 2

**Hrs:** 1

**Rate:** 46

**Parts:** 0

**Task:** Restore, remove lockout, sign off

**Craft:** Operator

**Crew:** 1

**Hrs:** 0.5

**Rate:** 38

**Parts:** 0

**Totals:**

#### Total man-hours

**Key:** mh

**Agg:** sum

**Format:** hours

#### Total labor cost

**Key:** labor

**Agg:** sum

**Format:** currency

#### Total parts

**Key:** parts

**Agg:** sum

**Format:** currency

#### Total job cost

**Key:** total

**Agg:** sum

**Format:** currency

**Summary:**

#### Average loaded rate

**Key:** avg_rate

**Expr:** sum_labor / sum_mh

**Format:** currency

#### Parts share of job cost

**Key:** parts_share

**Expr:** sum_parts / (sum_labor + sum_parts) * 100

**Format:** percent

#### Number of tasks

**Key:** tasks

**Expr:** count

**Format:** integer

**Notes:** Man-hours are crew size times hours per person. For elapsed time on the clock, take the longest task path rather than summing hours, because crews work in parallel. Keep the plan as a reusable job plan and update hours after each job closes.

## Content

**Intro:** A good job plan lists the tasks, the crew, the hours and the parts before the work starts. This worksheet does the arithmetic as you type and exports to Excel so it can be attached to a work order or kept as a standard job.

**Sections:**

#### How to use it

**Body:** Edit the example rows or add your own tasks in the order they will be done. For each one, choose the craft, enter crew size and hours per person, a loaded hourly rate, and any parts. The sheet computes man-hours, labor cost and task total, and sums them at the bottom. The summary shows the average rate and the share of cost that is parts. Export to Excel to attach it to the work order or load it into your CMMS or ERP job plan.

**Bullets:**

- Include isolation, permits, cleanup and testing as tasks, not just the repair.
- Use a loaded rate that includes burden, not the bare wage.
- Plan contractors as their own rows with their quoted rate.

#### Why estimates beat guesses

**Body:** Planners who write the task list find missing steps, parts and permits before the equipment is stopped, which shortens downtime. The estimate also lets the scheduler load crews realistically and gives a baseline for comparing actual hours later. Over time, the variance between plan and actual hours shows where your standard jobs are wrong.

#### Reading the totals

**Body:** Total man-hours drive scheduling and crew loading, while total cost supports budget and approval limits. A high parts share suggests checking stock availability and lead time, since a job often waits on parts, not labor. If the total is far above the usual cost for this kind of job, split it into stages or review whether a replacement is cheaper than repair.

#### Common mistakes

**Body:** Estimating only wrench time, leaving out travel, tool gathering and waiting, produces plans that always overrun. Another is reusing a plan without checking that it matches the asset and variant. In an ERP, task lists map to operations on a maintenance order, with planned hours on each operation and components for parts, so structure the worksheet the same way for easy loading.

**Cta:** Netray can help load standard job plans into your ERP from a spreadsheet like this one, with review before anything is written. The worksheet itself is free to use and export.

**Faq:**

#### What is the difference between man-hours and duration?

**Answer:** Man-hours are crew size multiplied by hours each. Duration is the elapsed time. A job of 20 man-hours with four people working in parallel on separate tasks might take only five hours on the clock.

#### Which labor rate should I use?

**Answer:** Use the fully loaded rate including benefits and overhead if you want a true cost. Use the bare wage only if you are comparing with a budget that excludes burden.

#### Can I reuse the worksheet as a standard job?

**Answer:** Yes. Save the exported Excel file as a template for the asset class, and adjust hours after each completion so it reflects reality.

#### How do I handle contractor work?

**Answer:** Add a row with the craft set to Contractor, enter the contractor's hours and quoted rate, and put any markup or travel in the parts and materials column or as a separate row.

## Search terms

maintenance job plan template excel, maintenance job plan worksheet, maintenance work estimate template, maintenance planner labor estimate, job plan man hours calculator, maintenance task list with hours, work order estimate spreadsheet, maintenance cost estimate template

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