---
title: Supply Chain Management Analysis – Tools & Techniques [Using MS Excel and MS Visio]
description: The Supply Chain Management Analysis online executive development program is designed with the objective to support the SCM Managers to make data driven decisions for the challenges faced by them in short, medium and long term in an end-to-end supply chain management.
---

[CIPS Training Provider in India| CIPS Course ](https://blog.fhyzics.net/chartered-institute-of-procurement-and-supply-cips)

# [Supply Chain Management Analysis – Tools & Techniques [Using MS Excel and MS Visio]](https://blog.fhyzics.net/chartered-institute-of-procurement-and-supply-cips/supply-chain-management-analysis-tools-techniques-using-ms-excel-and-ms-visio)

 Written by [Venkadesh Narayanan](https://blog.fhyzics.net/chartered-institute-of-procurement-and-supply-cips/author/venkadesh-narayanan) | Apr 27, 2020 7:58:16 AM

**Course Description: **

The Supply Chain Management Analysis online executive development program is designed with the objective to support the SCM Managers to make data driven decisions for the challenges faced by them in short, medium and long term in an end-to-end supply chain management. To achieve the above objective the participants will also learn Microsoft Excel and Microsoft Visio tools and supply chain analysis techniques as part of the program.

**Who Should Attend?**

- Supply Chain, Warehouse, Logistics, Transportation Managers to Directors
- Supply Chain Analysts and Process Improvement Experts
- Supply Chain Consultants and Those Who are Interested in Supply Chain Analysis and Process Improvement.

**Program Date:   
**Monday, May 11, 2020

**Mode of Delivery:   
**Online, Instructor-Led

**Medium of Instruction**:   
English

**Prerequisites**:

- Participants shall be able to follow the instruction in English
- Must complete the pre-reading material (10 pages) before the session.

**About Faculty:  
**[https://blog.fhyzics.net/webinar/profile-of-principal-consultant](https://blog.fhyzics.net/webinar/profile-of-principal-consultant)

**Program Fee:  
**Rs. 2,000 + 18% GST. Click here to Register for the Program.

**NEFT Details**: LSC Account Details such as Account Name, Account Number, Bank Name, Branch Name and IFSC Code.

**Session-1**: Supply Chain Management Concepts & Techniques   
**Duration**: 2 Hours on May 11, 2020 from 10:00 AM to 12:00 PM

- Understand an End-to-End Supply Chain
- Basic Model of Supply Chain, Four Flows and Three Entities
- Manufacturing Environments
- Supply Chain Stakeholders
- List of Supply Chain Activities
- Define Organisation from Analysis Perspective
- What is a Process and How to Define a Process?
- Primary, Secondary and Management Processes
- Current-State and Future-State Mapping
- Capability and Capacity Analysis
- Supplier Certification, Acceptance and Evaluation Criteria
- Benchmarking Exercise
- Brainstorming and Brainwriting
- Process Mapping, Swim Lanes
- Interview, Workshop, Focus Groups, Survey, SWOT Analysis, Observation
- Artificial Intelligence and Machine Learning for Supply Chain
- Business Model Canvas
- Data Modelling
- Financial Analysis
- Key Performance Indicators
- Mind Mapping
- Risk Analysis and Management
- Root Cause Analysis

**Session-2:** Supply Chain Management Tools & Techniques  
**Duration**: 2 Hours on May 11, 2020 from 03:00 PM to 05:00 PM

- Supply Chain Case Study
- Supply Chain Scenarios and Application of Excel Functions and Features such as CONCATENATE, LEN, COUNTA, DAYS, NETWORKDAYS, SUMIFS, AVERAGEIFS, VLOOKUP, FIND, SEARCH, IFERROR, COUNTIFS, LEFT, RIGHT, RANK, MINIFS, MAXIFS, SUMPRODUCT, PIVOT TABLE etc.
- Building a Mathematical Model
- Overview of Microsoft Visio and Its Features such as Swim Lanes, Templates, Shapes, Connectors etc.

For more details related to this program, please speak to us at **91-900 300 9633 **or email us at [rameshvenkat@lsc-india.com](mailto:rameshvenkat@lsc-india.com). You may also please visit** [www.lsc-india.com](http://www.lsc-india.com).**

[View full post](https://blog.fhyzics.net/chartered-institute-of-procurement-and-supply-cips/supply-chain-management-analysis-tools-techniques-using-ms-excel-and-ms-visio)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Venkadesh Narayanan"
  },
  "dateModified" : "2023-01-06T10:40:55.402Z",
  "datePublished" : "2020-04-27T07:58:16Z",
  "headline" : "Supply Chain Management Analysis – Tools & Techniques [Using MS Excel and MS Visio]",
  "image" : {
    "@type" : "ImageObject",
    "height" : 600,
    "url" : "https://cdn2.hubspot.net/hubfs/3112120/Supply%20Chain%20Management%20Analysis%20%E2%80%93%20Tools%20&%20Techniques%20%5BUsing%20MS%20Excel%20and%20MS%20Visio%5D.jpg",
    "width" : 800
  },
  "mainEntityOfPage" : "https://blog.fhyzics.net/chartered-institute-of-procurement-and-supply-cips/supply-chain-management-analysis-tools-techniques-using-ms-excel-and-ms-visio",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "CIPS Blog"
  }
}
```