Description
Course Objectives:
By the end of the course, participants will be able to:- Understand key concepts in procurement, logistics, and supply chain management.
- Optimize procurement processes and manage supplier relationships effectively.
- Design and implement efficient logistics strategies.
- Apply advanced Excel tools to analyze procurement data, forecast demand, and enhance decision-making.
- Manage risks and ensure compliance in procurement and supply chain operations.
- Develop skills to streamline inventory management and reduce costs.
Description
Day 1: Fundamentals of Procurement and Supply Chain Management
- Module 1: Introduction to Procurement and Supply Chain Management
- Key terms and concepts
- Importance of procurement and supply chain in business
- Overview of procurement lifecycle
- Strategic role of procurement in the supply chain
- Module 2: Procurement Processes and Best Practices
- Procurement planning and strategy development
- Supplier selection and evaluation
- Contract management and negotiations
- E-procurement and digitization in procurement
- Excel Application:
- Creating a procurement tracking template using Excel
- Basic Excel functions for procurement data management
Day 2: Logistics Management
- Module 3: Overview of Logistics Management
- Role of logistics in the supply chain
- Logistics planning and strategy
- Transportation management and optimization
- Warehousing and distribution strategies
- Module 4: Inventory Management
- Types of inventory and inventory control systems
- Economic order quantity (EOQ)
- Inventory valuation and stock replenishment
- Managing inventory using Excel
- Excel Application:
- Using Excel for inventory management: formulas, conditional formatting, and pivot tables
- Developing logistics dashboards for performance monitoring
Day 3: Advanced Procurement Strategies and Vendor Management
- Module 5: Strategic Sourcing and Vendor Management
- Building relationships with suppliers
- Supplier performance management
- Risk management in procurement
- Ethical procurement and compliance with procurement laws
- Module 6: Contract Management
- Key components of a procurement contract
- Monitoring contract performance
- Legal aspects of procurement contracts
- Excel Application:
- Vendor evaluation and scoring model using Excel
- Supplier performance tracking using pivot tables and charts
Day 4: Supply Chain Optimization
- Module 7: Supply Chain Strategy and Design
- Aligning supply chain strategy with business objectives
- Demand forecasting and inventory optimization
- Managing supply chain risks
- Module 8: Lean Supply Chain Management
- Principles of lean supply chain management
- Reducing waste and improving efficiency
- Sustainable supply chain practices
- Excel Application:
- Forecasting demand using Excel (moving averages, trendlines)
- Analyzing supply chain data using Excel solver and what-if analysis
Day 5: Advanced Excel for Procurement, Logistics, and Supply Chain Management
- Module 9: Data Analysis and Reporting in Procurement
- Advanced Excel functions for data analysis (VLOOKUP, INDEX, MATCH)
- Automating reports using macros and VBA
- Creating procurement dashboards and reports
- Module 10: Case Studies and Practical Applications
- Real-world case studies in procurement, logistics, and supply chain management
- Group exercises: Designing a procurement and logistics management system
- Project presentations and feedback
- Excel Application:
- Final project: Develop a supply chain optimization model using Excel
- Advanced Excel data visualization (pivot charts, sparklines, data bars)
General Notes
GENERAL NOTES
i. The clients have many options on where they would wish to have the training
ii. The client should communicate their preferred training venue at least seven days before the training date failure to which the training shall take place in Nairobi.
iii. This course is delivered by our seasoned trainers who have vast experience as expert professionals in the respective fields of practice. The course is taught through a mix of practical activities, theory, group works and case studies.
iii. Training manuals and additional reference materials are provided to the participants.
iv. Upon successful completion of this course, participants will be issued with a Chania finance consultancy certificate.
v. The onsite training fee covers tuition fees, training materials, tea at 10am, lunch, tea at 4pm, training venue and a certificate on completion. Accommodation and travel may be arranged for our participants upon request.
vi. The online training fee covers tuition fees, training materials, and a certificate on completion.
Available at the following Venues
- Nairobi
- Google Meet
Related Courses
10,000+ unique online course list designs
