Tabellab
Excel for Trades & Logistics 3
The Big, Comprehensive Workbook: 180+ Lessons on Freight Quotes, Load Planning, S&OP, Spare Parts and Kanban – Hands-On Labs with Full Solutions
- 501pages
- 180lessons
- 9courses
- 180exam questions
$14.99PDF · instant download
- Secure checkout with Stripe (cards, Apple Pay, Google Pay)
- Download link by email — valid 12 months
- Full solutions appendix included
What's inside
Excel for Trades & Logistics 3: 9 courses, 180 hands-on lessons, with a full solutions appendix.
Learn by doing. Every lesson starts with a clear goal and a short explanation, shows the worksheet cell by cell, and gives you tasks to solve on your own computer in Excel, LibreOffice Calc or Google Sheets. When you are done, check your formulas against the solutions and hints in the appendix and correct your sheet.
- 9 complete courses, 180 lessons, 180 exam questions with answers
- Worksheets with row and column labels – easy to type in
- Tasks with exact solutions and hints in the appendix
- All figures are fictional practice data
Every course is also available as an interactive course on tabellab.com, where each cell is checked instantly.
Courses in this book
- Freight Forwarding Quotes: Chargeable Weight, Weight Breaks, W/M for Sea Freight, FCL vs LCL, Surcharges & Quote Margins
- Load Planning: Cartons per Layer, Pallet Height & Weight Limits, Pallets per Truck & Container, Cube Utilisation & Cost per Unit
- Sales & Operations Planning: Demand Plans by Product Family, Capacity Gaps, Inventory Projections, Level vs Chase & the Monthly S&OP Pack
- Spare Parts & Slow Movers: Intermittent Demand, ADI & CV², Croston Forecasts, Service-Level Stock, Criticality and Dead Stock
- Kanban & Pull Systems: Card Counts, Two-Bin Sizing, Supermarket Levels, Replenishment Lead Times & Levelled Schedules
- Route Planning by Hand: Distance Matrices, Nearest-Neighbour Tours, 2-Opt Improvements, Time Windows, Vehicle Capacity & Sweep Routes
- Distribution Network Design: Centre-of-Gravity Locations, Customer Assignment, Transport vs Warehouse Costs, Service Coverage & the Number of Depots
- Periodic Review & Min–Max Inventory Policies: Review Periods, Order-Up-To Levels, Pipeline Stock, a 52-Week Simulation & Joint Replenishment
- Choosing Transport Modes: Road, Rail, Sea, Air & Intermodal – Door-to-Door Cost, Transit Time, Inventory in Transit & CO₂ per Tonne-km
Details
| Format | PDF, US Letter (8.5 × 11 in) |
|---|---|
| Language | English |
| Pages | 501 |
| Series | The Tabellab Workbook, volume 3 |
| Author | Babala Özdemir |
| Delivery | Instant download after payment |
