Assembly line balancing calculator with takt time
Takt time, station loading, line efficiency and balance delay for a task list with precedence.
3 tabs · 396 formulas
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.
EOQ, safety stock and reorder point calculator
Economic order quantity, safety stock, reorder point and annual inventory cost for each SKU.
3 tabs · 1,109 formulas
OEE calculator by shift (availability, performance, quality)
Overall equipment effectiveness for each machine and shift, from planned time, stops, cycle time and rejects.
3 tabs · 2,314 formulas
Pareto analysis of defects (80/20 chart)
Ranks defect categories by count and by cost, flags the vital few and tracks them by line and week.
6 tabs · 2,825 formulas
Time study calculator: observed, normal and standard time
Turns stopwatch readings into normal and standard times, with the cycles needed for a set accuracy.
3 tabs · 64 formulas
X-bar and R control chart calculator (SPC)
Control limits, sigma estimate, Cp and Cpk, and out-of-control flags for subgroup measurements.
4 tabs · 323 formulas