Estimate the job run time from past jobs.
Quotes and schedules use knowledge that people do not write down.
Tools: Python/pandas, Microsoft Excel, ERP export
- Estimated tool cost
- Free
- Company size
- 10-200 employees
- Difficulty
- Medium
Make a daily report of MRP shortages.
| Estimated tool cost | n8n self-host free |
|---|---|
| Company size | 10-200 employees |
| Difficulty | Easy |
Traveler — Make a daily report of MRP shortages.
OP COUNT: 3 · GATE COUNT: 0
OP 10
n8n reads ERP data on a schedule.
OP 20
A large language model (LLM) summarizes the shortages.
OP 30
n8n sends the summary by email or in Microsoft Teams.
| Problem | Each morning, planners take the same MRP report and format it again. |
|---|---|
| What to measure | Measure the time you save each day. Record the time when you first see a shortage. |
| Tools | n8n, Microsoft Teams, ERP API |