Description
Course Objectives:
- Enhance Procurement Knowledge:
- Understand the entire procurement lifecycle, including procurement planning, methods, and documentation.
- Learn best practices in project-based procurement and supply chain management.
- Develop Contract Management Expertise:
- Gain practical skills in drafting, monitoring, and managing contracts.
- Understand different types of contracts and key contractual clauses to ensure compliance and risk mitigation.
- Learn how to handle contract amendments, variations, and disputes effectively.
- Master Negotiation Techniques:
- Acquire negotiation strategies and tactics tailored to procurement and contract-related contexts.
- Improve communication and conflict resolution skills to achieve optimal negotiation outcomes.
- Build strong, sustainable relationships with suppliers and contractors through effective negotiation.
- Apply Data Analytics in Procurement:
- Use Advanced Excel to analyze procurement and contract data for informed decision-making.
- Create dashboards and reports to monitor contract performance, procurement costs, and supplier performance.
- Identify procurement risks and apply data-driven risk mitigation strategies.
- Improve Decision-Making and Forecasting:
- Leverage Excel tools like PivotTables, conditional formatting, and scenario analysis for procurement forecasting and budgeting.
- Utilize data insights to drive strategic procurement and contract management decisions.
- Develop proficiency in Excel-based risk analysis for procurement and contract management.
Description
Course Overview:
This course is designed to give participants a comprehensive understanding of the essentials of project procurement, effective contract management, and key negotiation techniques. The course also integrates the use of Advanced Excel for data analytics, focusing on procurement data analysis, contract tracking, and data-driven decision-making.
Course Objectives:
- Develop a thorough understanding of procurement methods, strategies, and best practices in project-based environments.
- Master key aspects of contract management including contract drafting, monitoring, compliance, and closeout.
- Enhance negotiation skills for procurement and contract-related activities, ensuring optimal outcomes.
- Understand procurement and contract-related risk management.
- Leverage Advanced Excel for procurement data analysis, contract performance tracking, and informed decision-making.
Course Outline
Day 1: Project Procurement Fundamentals
- Introduction to Project Procurement
- Understanding the procurement management process
- The role of procurement in project success
- Stages of the procurement life cycle
- Procurement planning and strategy development
- Procurement Methods and Techniques
- Tendering: open, restricted, negotiated, and competitive dialogue
- Direct procurement and framework agreements
- Selecting the appropriate procurement approach for projects
- Procurement Documentation
- Key documents: Request for proposals (RFP), Invitation to tender (ITT)
- Core components of a procurement contract
- Supplier relations and communication
Day 2: Contract Management Essentials
- Introduction to Contract Management
- Contract types: fixed-price, cost-plus, time and materials
- The contract management life cycle: initiation to closeout
- Key performance indicators (KPIs) for monitoring contracts
- Drafting and Negotiating Contracts
- Key terms and clauses in contracts
- Contract negotiation strategies and tactics
- Mitigating risks through effective negotiation
- Contract Compliance and Monitoring
- Tools and techniques for contract monitoring and compliance
- Handling contract amendments and variations
- Managing contract disputes and resolution strategies
Day 3: Negotiation Skills for Procurement and Contract Management
- Principles of Negotiation
- Phases and objectives of the negotiation process
- Key negotiation techniques (BATNA, ZOPA)
- Preparing for procurement contract negotiations
- Negotiation Tactics and Strategies
- Interest-based negotiation techniques
- Handling difficult negotiations
- Building long-term relationships through successful negotiation
- Effective Communication in Negotiation
- Active listening and persuasion strategies
- Managing conflicts and finding win-win solutions
- Securing favorable terms in contract deals
Day 4: Data Analytics for Procurement and Contract Management (Using Advanced Excel)
- Introduction to Data Analytics for Procurement
- Role of data in procurement decision-making
- Using Advanced Excel for procurement data management
- Sorting, filtering, and summarizing procurement data with Excel
- Advanced Excel for Contract Monitoring
- Building dashboards to track contract performance
- Utilizing PivotTables for contract data analysis
- Conditional formatting and data visualization in contract analytics
- Reporting and Performance Tracking
- Creating dynamic reports for procurement and contract management
- Automating data updates using Excel formulas and macros
- Generating insights from procurement data for decision-making
Day 5: Advanced Excel for Procurement Risk Management & Decision Making
- Risk Analysis in Procurement
- Identifying procurement risks with data analytics
- Risk assessment models: Monte Carlo simulations, scenario analysis
- Building risk management dashboards in Excel
- Forecasting and Budgeting in Procurement
- Using Excel to forecast procurement costs
- Tracking budgets and performing variance analysis
- Sensitivity analysis for procurement decision-making
- Making Data-Driven Procurement Decisions
- Interpreting data for strategic decision-making in procurement
- Case studies on successful data-driven procurement
- Presenting procurement performance reports
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
- Thika
- Google Meet
Related Courses
10,000+ unique online course list designs
