KeyOne · Articles
Articles – Warehouse, Logistics & Excel Reporting
Practical knowledge from warehousing, logistics and reporting – explained briefly, with formulas and free Excel templates.
How to Create a Shift Schedule in Excel: Steps, Rules and TemplateShift schedule in 5 steps: calculate staffing needs, choose a shift model, respect rest periods and breaks – with Excel formulas and a free template.How to Make a Gantt Chart in Excel: Step-by-Step Guide with FormulasBuild a Gantt chart in Excel step by step: task list, timeline, bars with conditional formatting, progress and delays – with formulas and a free Excel template.Hospital Logistics KPIs: 8 Key Metrics with FormulasThe key KPIs for hospital logistics and ward supply: fill rate, stockout rate, expiry rate, days of supply, inventory turnover and more – with formulas, an example and a free Excel template.How to Build a Cash Flow Forecast: Structure, Example and Common MistakesHow to create a cash flow forecast for a small business: structure with receipts and payments, a 13-week example, minimum cash balance, common mistakes and a free Excel template.How to Calculate Annual Leave in Germany: Formula, Part-Time and ExamplesHow to calculate annual leave entitlement in Germany: statutory minimum, conversion for part-time and other working days, pro-rata leave when joining or leaving, remaining leave – with examples and a free Excel template.Menu Engineering in Excel: Optimise Your Menu by Contribution MarginMenu engineering step by step in Excel: calculate popularity and contribution margin per dish, classify dishes as Star, Plowhorse, Puzzle or Dog – with formulas, an example and a free template.How to Calculate Food Cost: Formula, Example and Benchmarks for RestaurantsHow to calculate food cost and food cost percentage in a restaurant: formula, worked example, per-dish costing with yield, benchmarks and a free Excel template.Warehouse KPIs: The 10 Most Important Metrics with FormulasThe 10 most important warehouse KPIs explained: on-time delivery, picking accuracy, inventory turnover, days of supply, inventory accuracy and more – with formulas and practical tips.