CFC8002: Procurement and Transportation Management with Advanced Excel Analysis

Module 1: Fundamentals of Procurement Management

• Introduction to Procurement
  • Understanding Procurement Roles and Responsibilities
  • Procurement Processes: From Requisition to Payment
  • Strategic Sourcing and Supplier Selection
  • Ethical and Sustainable Procurement Practices
• Procurement Strategies and Best Practices
  • Category Management and Spend Analysis
  • Supplier Relationship Management
  • Contract Management and Negotiation Techniques
  • Case Study: Successful Procurement Strategies

Module 2: Transportation Management

• Introduction to Transportation Management
  • Overview of Transportation in the Supply Chain
  • Transportation Planning and Optimization
  • Modes of Transportation: Road, Rail, Air, and Sea
  • Risk Management in Transportation
• Advanced Transportation Strategies
  • Distribution Network Design and Optimization
  • Global Transportation and International Trade
  • The Role of Technology in Transportation Management
  • Case Study: Optimizing Transportation Operations

Module 3: Integrated Procurement and Transportation Management

• Supply Chain Integration
  • Aligning Procurement and Transportation Strategies
  • Enhancing Collaboration Across the Supply Chain
  • Cost Optimization in Procurement and Transportation
  • Group Exercise: Developing an Integrated Procurement and Transportation Plan
• Sustainability and Risk Management
  • Sustainable Procurement and Transportation Practices
  • Identifying and Mitigating Risks in Procurement and Transportation
  • Future Trends in Procurement and Transportation Management
  • Case Study: Managing Risks in Global Supply Chains

Module 4: Advanced Excel for Procurement and Transportation Analysis

• Excel Data Analysis Techniques
  • Advanced Excel Functions for Procurement and Transportation
  • Data Management: Cleaning and Organizing Data for Analysis
  • Using Pivot Tables and Pivot Charts for Data Visualization
  • Practical Exercise: Analyzing Procurement and Transportation Data
• Data Visualization and Reporting
  • Creating Dashboards for Procurement and Transportation Metrics
  • Advanced Visualization Techniques in Excel
  • Automating Reports and Using Macros for Efficiency
  • Practical Exercise: Building a Procurement and Transportation Dashboard

Module 5: Strategic Decision-Making in Procurement and Transportation

• Strategic Decision-Making
  • Developing Strategic Plans for Procurement and Transportation
  • Using Excel for Scenario Analysis and Forecasting
  • Supplier Performance Measurement and Transportation KPIs
  • Group Exercise: Strategic Decision-Making Simulation
• Emerging Trends and Technologies
  • The Impact of Digital Transformation on Procurement and Transportation
  • Exploring AI, Blockchain, and IoT in Supply Chain Management
  • Preparing for the Future of Procurement and Transportation
  • Course Review and Final Assessment

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.