Supply Chain Management Course Outline

Overview

This 40-hour Supply Chain Management course is designed to train people and help them to enter tactic level supply chain management positions.

Course consists of two parts: 20 hours SCM principles and practical functional processes lecture, and 20 hours hands-on learning analytical skills in using advanced Excel functions and intermediate Access functions.

This course introduces supply chain management evolvement in North America, gives participants the appreciation of the SCM principles, planning and the interrelation of those processes and functions within and across the enterprise boundaries. It provides insight into North American logistics, distribution, inventory, demand planning, and procurement management real world business practices, and comprehension of SCM concepts & terminology.

This course also helps people to learn and use the most important and relevant advanced Excel skills and intermediate Access skills to work effectively and efficiently in a business environment.

In the hands-on Excel classes, participants will be given business tasks and projects as they would in a real business job. They will combine various advanced features and functions in Excel and Access to plan business activities and solve complex business problems.

Participants will be guided step by step, from using simple functions to complex formula and eventually build complex model hands-on.

Learning Outcomes

Upon successful completion of this course the participant will be able to:

Demonstrate the understanding of supply chain management profession evolvement, the SCM labour market, and the importance of networking, the technical skills and soft skills required for SCM professionals and the different career paths for SCM positions
Articulate the concept of supply chain management from strategic, tactical, operational perspective, understand the inter-relationships between the primary business functions and processes within supply chain management
Analyze the supply chain performance and understand various key performance indicators
Understand the logistics practices, freight cost, the structure of a fulfillment network, distribution strategies, the processes and activities in a distribution center
Understand inventory roles within fulfillment, the critical drivers of inventory cost, and the factors impacting EOQ and safety stock;
Understand qualitative and quantitative forecast method, intrinsic and extrinsic forecast techniques, conduct forecasting with regression model and seasonal profile model in Excel
Develop effective procurement/supply management strategies that align with the corporate supply chain management
Plan business activities effectively and efficiently
Increase work productivity dramatically by using appropriate keyboard shortcuts and formula combination
Generate business performance reports in professional presentation and very efficient manner
Conduct complex business analyses to facilitate gaining deep insight of business issues
Conduct business forecast to facilitate business planning
Model business mechanism to provide decision support tool for management
Generate optimized solutions that meet the tactic objectives of business strategies

Topic Outline

Class	Supply Chain Process Lecture	Lab	Super Excel Hands-On
1	Supply chain management evolvement; Supply chain management principles	1	Keyboard shortcuts, countif, sumif, concatenate, vlookup, date, text, range; Use intermediate functions to address basic business problems
2	Supply chain planning & performance measurements; Logistics	2	If, hlookup, vlookup+concatenate, if(iserror(vlookup)), if, if(and/or); Combine functions to address intermediate business problems
3	Distribution; Inventory (1)	3	Linked formulas to build model; Formatting for presentation; Automate reporting
4	Inventory (2); Demand planning/forecasting	4	Access queries; Pivot table; conditional formatting; Handle large volume data & complex analysis
5	Procurement/supply management; Supply chain Network and Flexibility	5	Regression analysis, seasonal profile + moving average; index; Build forecasting model
		6	Build planning model; hyperlink, macro, button, array formula; Generate optimized solution

(Let someone contact you)

Last update:. Visits -- | Web site design and hosting by WECAN.ca CMS