Here are some common supply chain formulas that can be used in Excel:
SL No.
Inventory Turnover Ratio:
Inventory Turnover Ratio = Cost of Goods Sold/ Average Inventory
1
Days Sales of Inventory (DSI):
2 DSI = (Average Inventory / Cost of Goods Sold) * 365
Reorder Point:
3 Reorder Point = (Lead Time Demand * Lead Time) + Safety Stock
Economic Order Quantity (EOQ):
4 EOQ = sqrt((2* Demand * Ordering Cost) / Holding Cost per Unit)
Total Cost of Ownership (TCO):
TCO = Purchase Price + Ordering Costs + Holding Costs + Shortage Costs + Quality
5 Costs
Supplier Performance Metrics:
On-time Delivery Rate:
On-time Delivery Rate = (Number of On-time Deliveries/Total Number of
6 Deliveries) * 100
Fill Rate:
7 Fill Rate = (Quantity Shipped/Quantity Ordered) * 100
Perfect Order Rate:
8 Perfect Order Rate = (Number of Perfect Orders/ Total Number of Orders) * 100
Lead Time Calculation:
Lead Time = Supplier Processing Time + Transportation Time + Receiving Time +
9 Inspection Time + Buffer Time
These are just a few examples. Depending on your specific supply chain needs,
you may need to customize or create additional formulas.
Why Change Fails
(Lippitt-Knoster Model)
Vision ➕ Skills ➕ Incentives ➕ Resources ➕ Action Plan
Skills ➕ Incentives ➕ Resources ➕ Action Plan
Vision ➕ Incentives ➕ Resources ➕ Action Plan
Vision ➕ Skills ➕ Resources ➕ Action Plan
Vision ➕ Skills ➕ Incentives ➕ Action Plan
Vision ➕ Skills ➕ Incentives ➕ Resources ➕
▬ Change
▬ Confusion
▬ Anxiety
▬ Resistance
▬ Frustration
▬ False Starts
SL No.
A PRODUCT MANAGER
1 Product Managers own the "Vision"
2 Product managers synthesize and communicate "strategy."
3 A product manager is responsible for feature definition
4 A vital focus area for a product manager is "Content."
5 A product manager spends a lot of time on "Feature Conceptualization."
6 A product may have multiple projects and project managers
7 A product manager tries to optimize for the form and function of the product.
8 Product manager creates a Product Roadmap.
9 A senior product leader may manage a "Product Portfolio.
10 A product manager makes their name based on product success in the marketplace
DIFFERENCES BETWEEN
&
A PROJECT MANAGER
Project managers own "Execution."
Project managers consolidate work tasks and communicate "status"
A project manager (with help from business analysts) is responsible for requirements definition.
A project manager's core focus is on "coordination.
A project manager spends time on "Feature Delivery.
A project manager may manage a project or projects that span multiple products.
A project manager strives for optimizing cost, speed, and quality.
Project Manager creates the "Schedule."
A senior project leader may manage a "program."
A project manager makes their name based on project success internally.
SL No.
1
2
3
4
5
Can your team answer these 5 key questions in under 4 minutes?
If not, it's time for a serious wake-up call!
How many types of raw materials and finished goods do you have in the inventory?
What is the exact stock quantity of every raw material and finished good right now?
Today, up to this very moment, what raw materials have been received? Which orders, which stores, and in what quantities?
Today, up to this very moment, what raw materials have been delivered to production? From which orders, which stores, and
Today, up to this very moment, what finished goods have been received? From which orders, which production floors/lines, to
If it takes longer than 4 minutes to answer these questions (with documentation), then your management and planning need
These answers should be at your fingertips. Without accurate, real-time data, your planning will never be realistic, and manag
Don't let poor data management drag your business down. It's time to step up and streamline your processes!
SL No.
1
4
Introduction To Budgeting and Cost Comntrol
Cost Management Plan Set-Up
Cost Estimation and Budgeting
- Expense forecasting over time and according to major project milestones
- Recovery and consideration of the annual financial goal
Cost Control
- Launching of purchasing processes
- Analysis of actual costs
- Identification and explanation of deviations
- Forecast adjustment
Rapports Financiers
- Creating KPIs (Key Performance Indicators)
- Status summary and communication
Scrum Master
Definition:
The Scrum Master is a facilitator and coach who ensures the Scrum framework is followed and helps the team to be productiv
Responsibilities:
- Facilitating Scrum Events: Organizes and facilitates daily stand-ups, sprint planning, sprint reviews, and sprint retrospectives
- Removing Impediments: Identifies and removes obstacles that may hinder the team's progress.
Coaching the Team: Educates the team on Agile practices and principles, helping them to improve and adhere to Scrum proce
- Protecting the Team: Shields the team from external interruptions and distractions.
- Fostering Collaboration: Encourages collaboration and communication within the team and with stakeholders.
Continuous Improvement: Promotes a culture of continuous improvement by helping the team to identify and implement pro
Skills:
- Strong communication and interpersonal skills.
- Conflict resolution and problem-solving abilities.
- Deep understanding of Agile principles and Scrum framework.
- Ability to facilitate meetings and foster team dynamics.
**Here is the Fastest Way to Get Promoted to Your Dream
▬ If you want to be a leader, start acting like one today. Don't wait for the title; showcase your leadership capabilities from to
▬ Begin by (1) solving complex problems and (2) helping others in need. You'll naturally become a leader of choice.
▬ Similarly, if you aspire to be a CEO or the head of your department, act and work like one now. Your actions today pave the
▬ Leadership is not about a title or a designation. It's about impact, influence, and inspiration. - Robin S. Sharma
▬ According to the Center for Creative Leadership, 86% of senior management report that demonstrating leadership potentia
◆ Here is How to Maximize Meeting Outpu
First of all, if there is no note from a meeting, most likely there is no output from the meeting.
Even if you meet for hours but end up with only 3 lines of your notes, only those 3 lines are the output- regardless of how muc
Let's discuss one of the most crucial best practices for a successful meeting: real-time notes visibility.
Getting meeting minutes through a dense email hours after a lengthy meeting isn't effective.
Important points can be missed, unnecessary points can be appeared, and often, juniors who may not fully grasp the priorities
The best approach? Create visible meeting-minutes during the meeting itself.
Display the notes on-screen so everyone can see and contribute in real-time. This way, any missed points can be promptly add
As soon as the meeting wraps up, hit the Send button. This ensures everyone has the meeting minutes as they leave their chai
Real-time notes visibility lead to real-time alignment; which is one of the primary goals of any meeting.
◆ Here is how to achieve a 23% increas
Are you a leader losing track of your team? Are things not progressing as expected? Check the best practice explained below.
Every leader, whether overseeing a small or large team, can benefit from the best practice of daily stand-up meetings with the
These quick, focused meetings, held standing up and lasting no more than 30 minutes, ensure everyone stays aligned and pro
During these stand-ups, cover the following:
▬ Review Yesterday's Work: Understand what was accomplished.
▬ Plan for Today: Identify what needs to be done today.
▬ Address Barriers: Discuss any obstacles or blocks that need attention.
▬ Document Everything: Make sure all the above points are written and visible to everyone.
Implementing daily stand-ups can drastically improve team communication and efficiency. According to a study by Standuply,
Furthermore, a Harvard Business Review study found that teams using daily stand-ups are 21% more likely to complete tasks o
By implementing daily stand-ups, leaders can stay current with the progress of all projects and operational tasks, as well as ad
Project Manager (PM) Responsibilities:
Planning: Developing project plans including scope, schedule, and budget.
Execution: Overseeing daily project activities.
Risk Management: Identifying and mitigating risks.
Communication: Facilitating team and stakeholder communication.
Monitoring and Controlling: Tracking progress and making necessary adjustments.
Closing: Ensuring project objectives are met and formally closing the project.
Focus: Project delivery, team coordination, and maintaining a high-level view of the project lifecycle.
The Synergistic Relationship:
Collaboration: BAs and PMs must work closely to align business needs with project goals.
Communication: BAs provide detailed business requirements, while PMs use this info for planning and execution.
Role Complementation: BAs focus on "what" needs to be achieved; PMs focus on "how" to achieve it.
Change Management: Jointly managing requirement and scope changes.
Quality Assurance: BAs ensure solutions meet business needs, and PMs ensure high-quality project delivery.
Real-World Example:
In a software development project, a BA gathers and details user requirements.
The PM then develops a project plan, assigns tasks, manages timelines, and ensures the project is delivered on time and withi
budget.
Takeaway: While BAs and PMs have distinct roles, their synergy is crucial.
Effective collaboration and communication ensure that projects meet business needs and are delivered efficiently.
Understanding the Synergy Between Business Analysts and Project Managers :
In the dynamic world of project delivery, the roles of Business Analysts (BA) and Project Managers (PM) are pivotal.
Although distinct, their collaboration is essential for success.
Here's a breakdown of their unique responsibilities and how they intersect:
Business Analyst (BA) Responsibilities:
Requirements Gathering: Identifying and documenting business
needs.
Analysis: Improving business processes and systems.
Solution Design: Developing solutions with stakeholders.
Documentation: Creating detailed requirement documents.
Validation: Ensuring solutions meet requirements through testing
and reviews.
Focus: Understanding business needs, stakeholder
communication, and detail-oriented analysis.
Project Manager (PM) Responsibilities:
Planning: Developing project plans including scope, schedule,
and budget.
Execution: Overseeing daily project activities.
Risk Management: Identifying and mitigating risks.
SL No.
7
7 questions to keep your best people: the STAY interview
What do you look forward to every day?
Start on a positive note. Identify and encourage more of what they enjoy.
What's most meaningful in your role?
Allocating at least 20% of work time to meaningful activities reduces burnout by up to 50%.
What would you like to change?
Identify areas where changes could increase job satisfaction or make work more fulfilling.
What challenges are impacting your performance?
Identify obstacles and resolve them to boost productivity & growth.
What would you like to learn?
Understand their development goals and align them with growth opportunities.
What makes you feel valued?
Everyone needs to feel valued, but different people prefer to be recognized in different ways.
How can I support you?
Provide the resources, guidance & support for your team to thrive.
TIPS :
Listen without distractions and interruptions.
Stay open to feedback and accept it gracefully.
Keep it conversational and less formal.
Ask open-ended questions.
Show appreciation.
Follow up with action.
A stay interview delivers a lot:
- Builds trust
- Improves culture
- Helps tailor recognition
- Uncovers hidden issues
- Increases job satisfaction
- Ensures people feel valued
- Guides career development
- Enhances employee retention
- Identifies growth opportunities
- Encourages open communication
- Personalizes employee experience
Don’t take your team for granted.
Lead with empathy.
Start talking today.