CFC8001: Training on Procurement, Logistics & Supply Chain Management with Excel

Onsite Price

Ksh: 224,000.00

$: 2,240.00

Online Price

Ksh: 2,240.00

$: 22.40

Duration:

10 Days

Description

Procurement, Logistics & Supply Chain Management with Excel

Day 1: Introduction to Procurement, Logistics, and Supply Chain Management

Overview of procurement, logistics, and supply chain concepts.
Key principles and objectives.
Importance of integration in supply chain management.
Excel Functions: Basic formulas (SUM, AVERAGE, COUNT, CONCATENATE), data formatting.

Day 2: Procurement Planning and Sourcing Strategies

Procurement cycle and supplier selection.
Sourcing strategies and contract management.
Request for proposals (RFPs) and tenders.
Excel Functions: IF, VLOOKUP, HLOOKUP, INDEX-MATCH for supplier evaluation.

Day 3: Supplier Relationship Management

Vendor selection and performance management.
Negotiation and risk management.
Supplier scorecards and evaluation metrics.
Excel Functions: Pivot Tables, Conditional Formatting for supplier analysis.

Day 4: Inventory and Warehouse Management

Inventory control models (EOQ, JIT, ABC Analysis).
Warehousing best practices.
Demand forecasting and stock optimization.
Excel Functions: COUNTIF, SUMIF, AVERAGEIF, Data Validation for inventory control.

Day 5: Logistics and Transportation Management

Freight management and logistics planning.
Route optimization and transportation cost analysis.
Incoterms and regulatory compliance.
Excel Functions: Solver, Goal Seek, What-If Analysis for logistics optimization.

Day 6: Procurement and Supply Chain Risk Management

Identifying procurement risks and mitigation strategies.
Fraud detection in procurement.
Compliance and ethical considerations.
Excel Functions: Scenario Manager, Data Tables for risk assessment.

Day 7: Contract Management and Legal Aspects

Key components of procurement contracts.
Legal frameworks in procurement.
Dispute resolution and contract performance evaluation.
Excel Functions: Text Functions (LEFT, RIGHT, MID), Power Query for contract tracking.

Day 8: Financial Management in Procurement and Logistics

Costing and pricing strategies.
Budgeting and expenditure tracking.
Procurement performance measurement (KPIs and benchmarks).
Excel Functions: Financial Functions (NPV, IRR, PMT), Custom Charts for cost analysis.

Day 9: Supply Chain Performance Monitoring and Optimization

Supply chain key performance indicators (KPIs).
Process improvement techniques (Lean, Six Sigma).
Sustainable supply chain management.
Excel Functions: Macros, VBA for automation of supply chain reporting.

Day 10: Practical Case Studies and Advanced Excel Application

Hands-on case studies on procurement, logistics, and supply chain challenges.
Advanced Excel techniques for reporting and data visualization.
Final project presentation and feedback session.
Excel Functions: Power BI Integration, Dashboard Creation, Advanced Pivot Tables.

Description

Course Objectives

By the end of this training, participants will be able to:

Gain a solid understanding of procurement, logistics, and supply chain management principles.
Develop effective strategies for procurement planning and sourcing.
Enhance supplier management skills and assess vendor performance efficiently.
Implement best practices in inventory and warehouse management.
Optimize logistics and transportation processes to reduce costs and improve efficiency.
Identify potential risks in procurement and supply chain operations and establish mitigation strategies.
Understand key aspects of contract management and legal considerations in procurement.
Apply financial management principles in procurement and logistics decision-making.
Utilize key performance indicators to evaluate and enhance supply chain performance.
Leverage advanced Excel functions for data analysis and decision-making in procurement and supply chain management.

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.