Business & Operations
Procurement & Spend Analytics
IntermediateCertificate$9.99
Operations & Supply Chain in Excel
Inventory KPIs, ABC, EOQ, safety stock, forecasting, capacity, landed cost and Lean metrics: 8 labs on one distributor's real-looking data.
- One-time payment
- 14-day money-back guarantee
- Secure checkout with Stripe
What you'll build
What you will be able to do
Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.
- Measure how fast five product categories of a home-goods distributor turn their stock, and how well they serve customers.
- Split 12 SKUs into A, B and C items by annual consumption value, so you know where tight control pays off.
- Find the order quantity that keeps the total of ordering and holding costs lowest for the best-selling skillet set.
- Set the reorder point for a duvet from 20 days of sales, a 10-day lead time and a 95% service level.
- Forecast monthly demand for a storage box two ways and measure how wrong the forecasts were.
- Find out whether the warehouse packing line can handle 520 orders a day, and which station holds it back.
- Compare three suppliers for a floor lamp on true landed cost and on a weighted scorecard, then pick one.
- Calculate the pace the customer demands, how effective the bottleneck printer really is, and the sigma level of outbound orders.
About this course
Operations decisions rely on a core toolkit of calculations, and this course covers the essentials in one place. You measure inventory turnover, days of supply and fill rate, then classify items with ABC analysis. The economic order quantity balances ordering against holding cost, and safety stock with a reorder point protects service levels. Demand forecasts use moving averages and exponential smoothing, judged by MAD and MAPE. You calculate capacity and utilisation to find the bottleneck, compare suppliers on landed cost and weighted scores, and finish with lean and quality measures such as takt time, overall equipment effectiveness, DPMO and sigma level. For operations and supply chain students, planners and buyers.
Curriculum
Course content
8 lessons · 8 labs · 2 h · final exam
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Final exam
Certificate
Finish with a certificate you can verify
Complete every lesson and pass the final exam to receive a certificate of completion for this course, with a unique credential ID and a public verification page.
- Names the course, your score and the date of issue
- A verification link for your CV or LinkedIn profile
- 12 questions, 75% to pass, unlimited retries.
A Tutorvo certificate confirms that you completed a course. It is not an official or professional qualification.
Before you buy
Questions about this course
Is this a subscription?
No. You pay $9.99 once for this course. There is no subscription and nothing renews automatically. Prices are in US dollars; taxes may be added where required.
What exactly do I get?
All lessons and labs of this course, the final exam and the certificate, including later updates to the course, for as long as Tutorvo offers it. Access is personal and tied to your account.
Can I get a refund?
Yes. If you are not satisfied, email hello@tutorvo.com within 14 days of buying and we refund the course in full via Stripe. The guarantee does not apply once a certificate for the course has been issued to you, or where there are signs of abuse.
When can I start?
Right after payment. Access starts immediately at your request; for consumers in the EU/EEA the statutory right of withdrawal therefore ends once access has begun, while our 14-day money-back guarantee applies regardless.
Do I need Excel or other software?
No. The labs run in a spreadsheet inside your browser on a laptop, tablet or phone. Function names and syntax follow Excel.
Is the certificate an official qualification?
No. It confirms that you completed all lessons of the course and passed its final exam. It is not an official, state-recognised or professional qualification. The name is taken from your profile when the certificate is issued.
Full details are in our Terms · hello@tutorvo.com
Business & Operations
Supply Chain Risk & Resilience: Safety Stock, Dual Sourcing & Disruption Scenarios
IntermediateCertificate$9.99