# Manufacturing Production Report Format in Excel (Daily and Weekly)

> Source: https://netray.co/tools/manufacturing-production-report-format-excel
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable production report: enter planned time, downtime, ideal rate, produced and good units per shift and line, and get OEE per row.

## Category

mes-shop-floor

## Industry

Discrete Manufacturing

## Audience

- Production supervisor
- Plant manager
- Industrial engineer

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Date

**Key:** date

**Type:** date

#### Shift

**Key:** shift

**Type:** select

**Options:**

- A
- B
- C

#### Line / machine

**Key:** line

**Type:** text

#### Planned time (min)

**Key:** planned

**Type:** number

#### Downtime (min)

**Key:** down

**Type:** number

#### Ideal rate (parts/hour)

**Key:** rate

**Type:** number

#### Total produced

**Key:** produced

**Type:** number

#### Good units

**Key:** good

**Type:** number

#### Scrap + rework

**Key:** scrap

**Type:** number

**Expr:** produced - good

#### Availability %

**Key:** avail

**Type:** number

**Expr:** (planned - down) / planned * 100

**Format:** decimal

#### Performance %

**Key:** perf

**Type:** number

**Expr:** produced / (((planned - down) / 60) * rate) * 100

**Format:** decimal

#### Quality %

**Key:** qual

**Type:** number

**Expr:** good / produced * 100

**Format:** decimal

#### OEE %

**Key:** oee

**Type:** number

**Expr:** good * 60 / (rate * planned) * 100

**Format:** decimal

**Rows:**

**Date:** 2026-10-12

**Shift:** A

**Line:** CNC-01

**Planned:** 480

**Down:** 45

**Rate:** 60

**Produced:** 410

**Good:** 398

**Date:** 2026-10-12

**Shift:** B

**Line:** CNC-01

**Planned:** 480

**Down:** 70

**Rate:** 60

**Produced:** 372

**Good:** 361

**Date:** 2026-10-12

**Shift:** A

**Line:** Press-03

**Planned:** 480

**Down:** 30

**Rate:** 120

**Produced:** 790

**Good:** 771

**Date:** 2026-10-12

**Shift:** B

**Line:** Press-03

**Planned:** 480

**Down:** 55

**Rate:** 120

**Produced:** 760

**Good:** 735

**Date:** 2026-10-13

**Shift:** A

**Line:** CNC-01

**Planned:** 480

**Down:** 25

**Rate:** 60

**Produced:** 432

**Good:** 425

**Totals:**

#### Total produced

**Key:** produced

**Agg:** sum

**Format:** number

#### Total good units

**Key:** good

**Agg:** sum

**Format:** number

#### Total scrap + rework

**Key:** scrap

**Agg:** sum

**Format:** number

#### Total downtime (min)

**Key:** down

**Agg:** sum

**Format:** number

#### Average OEE %

**Key:** oee

**Agg:** avg

**Format:** decimal

**Summary:**

#### First pass yield %

**Key:** yield

**Expr:** sum_good / sum_produced * 100

**Format:** decimal

**Primary:** true

#### Scrap + rework rate %

**Key:** scrap_rate

**Expr:** sum_scrap / sum_produced * 100

**Format:** decimal

#### Downtime hours

**Key:** down_hours

**Expr:** sum_down / 60

**Format:** decimal

**Notes:** Ideal rate is the fastest rate the line can run steadily on this part, not the average. Performance above 100 percent means the ideal rate is set too low. Add rows for each line and shift, then export to Excel for the weekly pack.

## Content

**Intro:** A manufacturing production report records what each line was supposed to make, what it made, what was good, and why time was lost. This worksheet replaces the usual Excel sheet: enter one row per line and shift and it calculates availability, performance, quality and OEE for you.

**Sections:**

#### How to use this production report format

**Body:** Add one row per line and shift. Enter planned production time and downtime in minutes, the ideal rate in parts per hour, total produced and good units. Scrap and the OEE factors calculate automatically. Use the date column to build a daily report, or export a full week to Excel and filter by line. Replace the sample rows with your own; the totals and first pass yield update as you edit.

#### What is a manufacturing data report

**Body:** A manufacturing data report is a structured record of production facts for a period: quantities, time, losses and quality, usually by line, shift and part. It exists so that decisions about staffing, maintenance and scheduling rest on counted data. The core columns are always the same, even when the plant adds part number, work order, operator or reason codes.

**Bullets:**

- Identity: date, shift, line or machine, part and work order.
- Time: planned production time, downtime, and the reason for each stop.
- Output: total produced, good units, scrap and rework.
- Derived: availability, performance, quality and OEE.

#### The formulas behind the OEE columns

**Body:** Availability is run time divided by planned time. Performance is actual output divided by what the ideal rate would have produced in the run time. Quality is good units divided by total produced. OEE is the product of the three, which reduces to good units times 60 divided by ideal rate times planned minutes. Example: 480 planned minutes, 45 down, ideal rate 60 per hour, 410 made and 398 good gives availability 90.6 percent, performance 94.0, quality 97.1, OEE about 82.9.

#### Where the data comes from and common mistakes

**Body:** Produced and good quantities come from production order completions or machine counters; scrap comes from reject postings. Downtime comes from operator logs or MES. The usual mistakes are counting planned breaks as downtime, using an average rate as the ideal rate, and treating rework as good output. Agree the definitions once, write them on the report, and keep them stable, otherwise trends mislead.

**Cta:** If this data already lives in your ERP or MES, we can generate the daily report automatically from it, and answer questions about it in plain language, on your own servers if required.

**Faq:**

#### What should a daily production report contain?

**Answer:** At minimum: date, shift, line, planned time, downtime with reasons, produced and good quantities, scrap, and the headline KPIs. Add part numbers and work orders if you run several products per line, so the report ties back to your ERP.

#### How do I convert this to a weekly production report?

**Answer:** Add rows for each day, export to Excel, and use a pivot table on the line column. Sum produced, good and downtime, then recalculate OEE from the sums or average the daily values, whichever your plant has agreed to use.

#### Why is my performance percentage over 100?

**Answer:** The ideal rate you entered is lower than the line actually achieved. Set the ideal rate to the best sustained rate for that part, from the routing standard or a proven demonstration run, and keep it fixed so OEE stays comparable.

#### Is OEE the same as efficiency?

**Answer:** No. Labor or machine efficiency usually compares actual to standard hours. OEE includes availability, performance and quality against planned time, so it also exposes downtime and defects that an efficiency number can hide.

## Search terms

manufacturing production report format excel, production report format manufacturing excel, manufacturing data report example, what is a manufacturing data report, daily production report excel, weekly production report format, oee production report template

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