Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesOperations & Supply ChainManufacturing & OperationsWeekly Production Schedule

SpreadsheetManufacturing & OperationsFree

Weekly Production Schedule

Plan production orders by line, day and shift, then record output, scrap and downtime to see attainment, yield and performance by line and day.

Shown with sample data

Colour

Weekly Production Schedule

Plan production orders by line, day and shift, then record output, scrap and downtime to see attainment, yield and performance by line and day.

Attainment
100%
Completed orders
Yield
99%
Downtime
160
Minutes
Orders still to run
0
Attainment by line
  • Line 196.8%
  • Line 2101.7%
  • Line 392.5%
Planned units by day
  • Nov 5, 20268,100
  • Nov 6, 20268,400
  • Nov 9, 20268,100
  • Nov 10, 20267,400
  • Nov 11, 20268,200

How to use it

  1. 1Enter each production order with date, line, product, shift and planned quantity.
  2. 2At the end of each run, record good units, scrap and minutes of downtime with a short reason.
  3. 3Review Status in the daily meeting and investigate anything Short.
  4. 4Use By line and By day to spot recurring problems.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Plan what each line makes on each day and shift, then record actual output, scrap and downtime at the end of every run. The schedule works out attainment against plan and yield, flags orders that fell short, and keeps the reason next to the numbers. Summary sheets show attainment, scrap rate and downtime for each line and each day, ready for the morning production meeting.

Who it’s for

  • Small manufacturers and food producers
  • Shift supervisors and planners
  • Daily production meetings

What’s included

  • Schedule sheet: Production orders with planned and actual output.
  • By line sheet: Output, attainment, scrap and downtime for each line.
  • By day sheet: Planned and actual output for each day of the schedule.

How to use it

  1. 1Enter each production order with date, line, product, shift and planned quantity.
  2. 2At the end of each run, record good units, scrap and minutes of downtime with a short reason.
  3. 3Review Status in the daily meeting and investigate anything Short.
  4. 4Use By line and By day to spot recurring problems.

Tips

  • Record the reason for every shortfall in a few words: the patterns tell you where to invest.
  • Plan to about 85 to 90% of theoretical capacity to leave room for changeovers.

Questions

How is attainment worked out?

Good units divided by planned units. Met is 100% or more, Near is 90 to 99%, and Short is below 90%.

What is yield?

Good units as a share of everything produced (good units plus scrap).

Related searchesproduction schedulemanufacturingproduction planningoutput trackingscrap ratedowntime

Details

Format
Spreadsheet
Category
Manufacturing & Operations
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetManufacturing & OperationsFree

Weekly Production Schedule

Plan production orders by line, day and shift, then record output, scrap and downtime to see attainment, yield and performance by line and day.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Manufacturing & Operations
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More manufacturing & operations templates

View all
Equipment Maintenance Log3 sheets

Overdue

1

Due in 14 days

3

Maintenance spend

$2,875

ABCD
1EquipmentLocationTypeInterval (days)
2Commercial espresso machineFront counterKitchen90
3Walk-in fridgeKitchenRefrigeration180
4DishwasherKitchenKitchen120
5HVAC unitRoofBuilding180
Assets
SpreadsheetManufacturing & Operations

Equipment Maintenance Log

Preventive maintenance due dates from each asset's service history, with overdue alerts, repair and downtime tracking, and maintenance cost by asset and month.

10 min setupPreview
OEE Calculator2 sheets

Average OEE

79%

Availability

90%

Performance

90%

ABCD
1DateLineShiftPlanned minutes
2Nov 3Line 1Day450
3Nov 3Line 1Night450
4Nov 3Line 2Day450
5Nov 3Line 2Night450
Shifts
SpreadsheetManufacturing & Operations

OEE Calculator

Overall Equipment Effectiveness by shift: availability, performance and quality, and where time is lost.

10 min setupPreview
Failure Mode and Effects Analysis (FMEA)3 sheets

Failure modes

8

High priority

1

Highest RPN

175

ABCD
1Process stepFailure modeEffect of failureS
2Receive castingsPorosity in casting wallHousing leaks at customer8
3CNC machine boreBore oversizeBearing loose, noise and early failure7
4CNC machine boreBurrs left on joint faceGasket damaged, leak6
5Press-fit bearingBearing not fully seatedShaft misalignment, pump seizure9
Analysis
SpreadsheetManufacturing & Operations

Failure Mode and Effects Analysis (FMEA)

Rate severity, occurrence and detection for every failure mode, get the RPN and action priority, and track risk after actions.

60 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ