Manufacturing spreadsheets for OEE, cost, and downtime.

Free manufacturing spreadsheet templates

• OEE Tracker Spreadsheet Template. Free OEE tracker with reason-coded downtime, ideal-vs-actual rate, and auto-calculated availability, performance, and quality per shift.
• Unit Cost Spreadsheet Template. Free unit cost Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Machine Hour Rate Spreadsheet Template. Free machine hour rate Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Job Shop Quote Spreadsheet Template. Free job shop quote Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Break-Even Analysis Spreadsheet Template. Free break-even analysis Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Standard Cost Variance Spreadsheet Template. Free standard cost variance Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Cycle Time Tracker Spreadsheet Template. Free cycle time tracker Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Takt Time Spreadsheet Template. Free takt time Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Capacity Planning Spreadsheet Template. Free capacity planning Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Line Balance Spreadsheet Template. Free line balance Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Throughput Analysis Spreadsheet Template. Free throughput analysis Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Downtime Tracker Spreadsheet Template. Free downtime tracker Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• MTBF and MTTR Spreadsheet Template. Free MTBF and MTTR Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Preventive Maintenance Schedule Spreadsheet Template. Free preventive maintenance schedule Excel template: a CSV log plus a live-formula .xlsx workbook, and the matching calculator online.
• Equipment Availability Spreadsheet Template. Free equipment availability Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Spare Parts Inventory Spreadsheet Template. Free spare parts inventory Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Scrap Cost Tracker Spreadsheet Template. Free scrap cost tracker Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• First Pass Yield Spreadsheet Template. Free first pass yield Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Defect Rate Tracker Spreadsheet Template. Free defect rate tracker Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Cost of Poor Quality Spreadsheet Template. Free cost of poor quality Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Supplier Quality PPM Spreadsheet Template. Free supplier quality PPM Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Pallet Utilization Spreadsheet Template. Free pallet utilization Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Freight Cost Per Unit Spreadsheet Template. Free freight cost per unit Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Warehouse Storage Cost Spreadsheet Template. Free warehouse storage cost Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Inventory Carrying Cost Spreadsheet Template. Free inventory carrying cost Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Energy Cost Per Part Spreadsheet Template. Free energy cost per part Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Carbon Emissions Spreadsheet Template. Free carbon emissions Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Compressed Air Leak Cost Spreadsheet Template. Free compressed air leak cost Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Safety Stock Spreadsheet Template. Free safety stock Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• Labor Cost Spreadsheet Template. Free labor cost Excel template: a CSV log plus a live-formula .xlsx workbook. See what it includes, or use the matching calculator online.
• 3D Printing Cost Excel Template. Free 3D printing cost workbook: cost every print job from slicer grams and build hours, machine rates, labour and failures, with margin status and a dashboard.
• A3 Problem Solving Excel Template. Free A3 problem-solving template in Excel: seven boxes, a weekly data box with chart, five whys, countermeasure status and a benefit and payback estimate.
• ABC Inventory Analysis Excel Template. Free ABC analysis workbook: rank items by annual usage value, set your own A/B cut-offs, see the ABC curve and where stock sits by class.
• Activity-Based Costing Excel Template. Free activity-based costing workbook: activity pools, cost drivers and rates, product costs and margins compared with a single plantwide overhead rate.
• APQP Timeline Excel Template. Free APQP timeline: five-phase task plan with Gantt charts, progress against plan, baseline slip, overdue tasks and the forecast start-of-production slip.
• Asset Criticality Ranking Excel Template. Free asset criticality ranking workbook: score assets on consequence and likelihood, rank them into A, B and C classes and see a risk map and downtime cost.
• Batch Yield Reconciliation Excel Template. Free GMP batch yield reconciliation log: yield and reconciliation per batch against each product's limits, unaccounted quantity and missing deviation checks.
• BOM Cost Rollup Excel Template. Free BOM cost rollup workbook: indented bill of materials costed line by line, quantities and costs rolled up through assemblies to unit cost and price.
• Gauge Calibration Log Excel Template. Free gauge calibration log: register with next due dates, as-found results, overdue and due-soon gauges, on-time calibration and drift by gauge type.
• CAPA and 8D Tracker Excel Template. Free CAPA register in Excel: 8D stage dates, due dates by priority, overdue status, on-time closure and effectiveness rate on a live dashboard.
• Capital Project NPV, IRR and Payback Excel Template. Free capital request workbook: yearly savings, tax and depreciation to NPV, IRR, simple and discounted payback, a tornado chart and NPV sensitivity table.
• Casting Cost Estimator Excel Template. Free casting cost estimator in Excel: poured weight from casting yield, melt loss and energy, cores, moulding and pattern cost, priced per casting.
• CNC Machining Quote Excel Template. Free CNC machining quote workbook: cycle time from cutting data, tool wear, setup and NRE roll up to unit price, margin and lead time for five quantities.
• Cost Savings Tracker Excel Template. Free cost savings tracker: a project register, a monthly savings log, realization against plan, a year-end forecast and the gap to your savings target.
• Cycle Count Tracker Excel Template. Free cycle count workbook: log counts against system quantity, apply ABC tolerances, and track location accuracy, adjustment value and miss reasons.
• Demand Forecast Excel Template. Free demand forecast workbook: log forecast vs actual by SKU and month, track accuracy (1 - WAPE), bias, hit rate and forecast value added against a baseline.
• Energy Use and Demand Charge Tracker Excel Template. Free energy tracker workbook: log electricity bills and sub-meters, check demand charges and ratchets, and track load factor and kWh per unit of output.
• First Article Inspection Tracker Excel Template. Free FAI tracker: register of first articles, ballooned characteristic results with limits and PASS/FAIL, near-limit flags, overdue FAIs and inspection time.
• 5S Audit Checklist Excel Template. Free 5S audit workbook: a 25-point checklist, monthly area scores by S, an action log with overdue flags, and a dashboard with trend and radar charts.
• Scope 1 and 2 GHG Inventory Excel Template. Free Scope 1 and 2 GHG inventory workbook: fuel, refrigerant and electricity logs, location- and market-based Scope 2, base-year progress and intensity.
• HACCP CCP Monitoring Log Excel Template. Free HACCP monitoring log: CCP checks judged against critical and operating limits, corrective actions, verification, missed checks and hold cost.
• Production Headcount Plan Excel Template. Free manpower planning workbook: monthly demand and labour standards to required FTE by department, hires vs leavers, the gap, overtime and labour cost.
• Injection Molding Part Cost Excel Template. Free injection molding cost workbook: resin with runner, rejects and regrind, cycle time, press rate, changeover and mold amortisation to a piece price.
• ISO 9001 Internal Audit Planner Excel Template. Free ISO 9001 internal audit planner: audit programme, checklist with findings, conformance by clause, overdue actions and audit hours still to plan.
• Kaizen Project Tracker Excel Template. Free kaizen tracker workbook: one register for improvement projects with PDCA stage, savings, ROI and payback, and a dashboard of savings against plan.
• Kanban Sizing Excel Template. Free kanban sizing workbook: cards per loop from demand, lead time, safety allowance and container size, with the stock and cash effect of resizing.
• Labor Efficiency Tracker Excel Template. Free labor efficiency workbook: earned standard hours vs actual hours by cell and shift, plus utilization, productivity and the value of hours lost.
• Landed Cost and Tariff Excel Template. Free landed cost workbook: duty and extra tariffs on FOB or CIF customs value, landed cost per unit by part and origin, and a tariff what-if.
• Maintenance Budget Tracker Excel Template. Free maintenance budget tracker: monthly phasing by category, spend log with accruals and open orders, variance to date, remaining budget and budget used.
• Maintenance Work Order Log Excel Template. Free maintenance work order log: due dates by priority, backlog in crew-weeks, overdue jobs, emergency work share, on-time completion and cost by asset.
• Make vs Buy Analysis Excel Template. Free make vs buy workbook: avoidable make cost against delivered buy cost, split scenarios, break-even volume, a capacity check and weighted strategic factors.
• MRP Planner Excel Template. Free MRP spreadsheet: net weekly gross requirements against stock, open orders and safety stock; planned orders, release weeks and overdue releases by item.
• Nonconformance (NCR) Log Excel Template. Free NCR log in Excel: dispositions, estimated cost of each nonconformance, open and overdue NCRs, clearance ratio, cost Pareto and monthly trend.
• OTIF Delivery Tracker Excel Template. Free OTIF workbook: log delivered order lines, apply your delivery window and in-full tolerances, and track on time, in full and OTIF by week and customer.
• Overtime Tracker Excel Template. Free overtime tracker workbook: weekly overtime by person and department, cost and premium, budget and limit checks, reasons Pareto and a request sizer.
• Pareto Analysis Excel Template. Free Pareto analysis workbook: tally defects by category, then see Pareto charts by count and by cost, the vital few and defects per unit as you type.
• PCB Assembly Cost Excel Template. Free PCBA cost workbook: cost every board from bare panel, BOM, SMT placements, through-hole joints, test, NRE and yield, with margin status and a dashboard.
• Process FMEA (PFMEA) Excel Template. Free PFMEA workbook: severity, occurrence and detection ratings, RPN before and after actions, action tracking, top 10 risks and RPN by process step.
• Plant Budget vs Actual Excel Template. Free plant budget vs actual workbook: monthly spend by cost line against a budget flexed to actual volume, with spending variances, flags and comments.
• Powder Coating Cost per Part Excel Template. Free powder coating cost workbook: powder per part from area, film and transfer efficiency, line and labour cost, margin status per job and a dashboard.
• PPAP Submission Tracker Excel Template. Free PPAP tracker: package log, element tracker, overdue submissions and elements, readiness per package, first-time approval and a workload check.
• Process Capability Cp Cpk Pp Ppk Excel Template. Free capability study workbook: Cp, Cpk, Pp and Ppk from subgrouped readings, a histogram against the spec, and observed and expected ppm.
• Production Schedule Gantt Excel Template. Free production schedule Gantt workbook: jobs on machines in working days, end dates with holidays, slack to due date, machine load vs capacity.
• Purchase Price Variance Tracker Excel Template. Free PPV tracker workbook: log receipts against standard prices and see net, unfavourable and favourable PPV by month, supplier, category and item.
• Price Quote with Quantity Breaks Excel Template. Free multi-part quote workbook: every part priced at five quantity breaks from cost per part and setup per lot, with tooling, terms and a printable quote.
• Recipe and Batch Costing Excel Template. Free recipe costing workbook: ingredient prices per kg or lb, recipe lines, yield, labour, overhead and packaging, cost per pack, margin and target price.
• Reorder Point and EOQ Planner Excel Template. Free reorder point and EOQ workbook: safety stock from demand and lead-time variability, reorder points, EOQ savings and an order-now list per item.
• Reshoring Total Cost of Ownership Excel Template. Free reshoring TCO workbook: compare offshore, nearshore and domestic sources on total cost of ownership, with payback and the tariff at which each option wins.
• Safety Incident Log Excel Template with TRIR and DART. Free safety incident log workbook: record incidents and hours worked, and see rolling 12-month TRIR, DART rate, LTIFR and overdue corrective actions.
• Shift Production Report Excel Template. Free shift production report workbook: one row per line per shift, plan attainment, line efficiency, yield, units per labour hour and a downtime Pareto.
• 4-Crew Shift Rotation Schedule Excel Template. Free 24/7 shift rota workbook: DuPont, 2-2-3 Panama, 4-on-4-off or 3-on-3-off for four crews, with leave, coverage checks and hours per crew.
• Skills and Training Matrix Excel Template. Free skills matrix workbook: training records with levels and expiry dates, coverage by skill, shift gaps, renewals due and a colour-coded matrix.
• SMED Changeover Analysis Excel Template. Free SMED workbook: changeover steps as internal or external, today vs planned, minutes and money saved, and a log of real changeovers against target.
• S&OP Monthly Plan Excel Template. Free S&OP spreadsheet: 12 months of demand, production plan, projected inventory, days of supply, line utilisation and revenue by product family.
• SPC X-bar and R Control Chart Excel Template. Free X-bar and R control chart workbook: subgroup log, limits from a baseline, both charts and out-of-control signals named in words as you type.
• Supplier Risk Assessment Excel Template. Free supplier risk register: severity, occurrence and detection scores, RPN, a severity floor, mitigation actions with due dates, and a live risk dashboard.
• Supplier Scorecard Excel Template. Free supplier scorecard workbook: monthly PPM, on-time delivery and responsiveness scores, weighted composite, ranking against your minimum and trend charts.
• Time Study and Standard Work Excel Template. Free time study workbook: stopwatch readings, ratings, PF&D allowance, standard time per element, cycles needed, standard work vs takt and SAM.
• Cutting Tool Life Tracker Excel Template. Free cutting tool life tracker: log every edge and tool change, see life achieved against standard, early failures, tool cost per part and spend above standard.
• TPM Autonomous Maintenance Checklist Excel Template. Free TPM autonomous maintenance workbook: CILT standard per machine, weekly check compliance, abnormality tag log with due dates, and an AM dashboard.
• Waste and Recycling Tracker Excel Template. Free waste tracker workbook: log every collection, convert kg, t, lb and US tons, and see the landfill diversion rate, hazardous waste and net cost by stream.
• Water Use Tracker Excel Template. Free water use tracker workbook: monthly intake by source, reuse, discharge and charges, water per unit of output, cost per unit and sub-meter leak check.
• Welding Cost Estimator Excel Template. Free welding cost estimator in Excel: weld metal from joint geometry, arc time, filler, gas and welder labour, priced per weldment for five batch sizes.
• Job Shop Work Order Tracker Excel Template. Free work order tracker for job shops: due dates, stage, on-time delivery, estimate vs actual hours, cost variance and margin, with a live dashboard.