Templates

Industrial engineering spreadsheet templates

Templates for measuring and improving how work gets done on the shop floor. They calculate overall equipment effectiveness from shift data, turn stopwatch readings into standard times, balance an assembly line against takt time, size orders and safety stock, and set X-bar and R control limits from subgroup samples. Every result traces back to the formula that produced it.

The methods are the standard textbook ones (the OEE availability-performance-quality split, rated time plus allowances, ranked line balancing, the Wilson EOQ formula, Shewhart control charts). Check allowances and service levels against your own operation.

TemplateIndustrial engineering

First-pass yield and rework tracker

Compare units passing initial inspection with reworked units and scrap to calculate first-pass yield and total station yield.

2 tabs · 306 formulas

TemplateIndustrial engineering

Inventory cycle count variance

Compare book inventory with a physical count and translate quantity differences into cost differences.

2 tabs · 246 formulas

TemplateIndustrial engineering

Inventory stock and reorder tracker

Roll stock balances forward from opening units, receipts, and issues, then compare closing stock with a minimum and target.

2 tabs · 186 formulas

TemplateIndustrial engineering

Kanban container and card calculator

Size a pull replenishment loop by calculating lead-time demand, safety-buffered demand, and required kanban containers.

2 tabs · 246 formulas

TemplateIndustrial engineering

Preventive maintenance schedule

Track calendar-based maintenance from the last service date and a manually specified interval.

2 tabs · 186 formulas

TemplateIndustrial engineering

Production capacity plan

Compare required production hours with available line hours for orders using an entered cycle time.

2 tabs · 246 formulas

TemplateIndustrial engineering

Scrap and rework cost tracker

Measure scrap share and the direct cost of scrapped units and rework hours by production batch.

2 tabs · 306 formulas

TemplateIndustrial engineering

Supplier delivery and quality scorecard

Compare supplier delivery reliability and accepted-unit quality using counts from the same review period.

2 tabs · 246 formulas

TemplateIndustrial engineering

Warehouse pallet and bin utilization

Calculate total pallet positions, remaining open capacity, and storage utilization across warehouse aisles or zones.

2 tabs · 246 formulas