Goal of the Day

Today you will study supplier performance evaluation, analyze Titan’s supplier data, and map out how supplier issues impact supply chain fulfillment.
You will prepare to start supplier risk modeling tomorrow based on delivery quality metrics.

Detailed Tasks with U2xAI Prompts and Interview Preparation Focus

1. Study Supplier KPIs and Evaluation Models

  • What to Do:
    Learn about key KPIs for evaluating suppliers:Study basic evaluation methods like Supplier Scorecards and Weighted Scoring Models.
    • On-Time Delivery (OTD) Rate
    • Defect/Return Rate
    • Lead Time Variability
    • Price Competitiveness
    • Responsiveness to Emergencies
  • U2xAI Prompt:
    "List common KPIs used to evaluate suppliers and explain the business importance of each KPI in supply chain management."
  • How This Helps for Interviews:
    You’ll be ready for questions like, “How would you evaluate supplier performance?” or “What KPIs would you track for critical suppliers?”
  • Time Recommendation: 1 hour

2. Explore Supplier Data and Identify Key Fields

  • What to Do:
    Review Titan’s supplier-related datasets:
    • Supplier Profiles (ID, Name, Region, Product Category)
    • Supplier Orders (Order Date, Delivery Date, Quantity, Defect Reports)
    • Risk Profiles (Financial Risk Rating, Delivery Risk, Quality Risk)
  • U2xAI Prompt:
    "List typical fields found in supplier datasets and explain how each can be used for evaluating supplier performance and risk."
  • How This Helps for Interviews:
    You’ll face questions like, “Given a supplier dataset, what would you analyze first?” — this practice helps you respond clearly and immediately.
  • Time Recommendation: 1.5 hours

3. Map Supplier Risk Metrics

  • What to Do:
    Identify risk factors that can be calculated or derived from supplier data:
    • Delivery Delays = Actual Delivery Date - Promised Delivery Date
    • Defect Rate = (Defect Quantity / Total Quantity) × 100
    • Lead Time Consistency (standard deviation of lead times)
  • U2xAI Prompt:
    "Suggest important supplier risk metrics that can be derived from supplier delivery and quality data, and how each relates to supply chain risk."
  • How This Helps for Interviews:
    You’ll be ready for questions like, “How would you assess supplier risk quantitatively?” — a common topic for supply chain analytics and operations roles.
  • Time Recommendation: 1 hour
  • What to Do:
    Write out examples of how supplier performance impacts fulfillment:
    • Late deliveries ➔ Stockouts ➔ Order delays
    • High defect rates ➔ Quality issues ➔ Customer returns
    • Inconsistent lead times ➔ Unpredictable inventory replenishment
  • U2xAI Prompt:
    "Explain how supplier delivery issues and quality problems lead to fulfillment disruptions in the supply chain."
  • How This Helps for Interviews:
    Demonstrates that you can connect operational issues across the supply chain, not just analyze isolated supplier performance.
  • Time Recommendation: 45 minutes

5. Document a Supplier Scorecard Structure

  • What to Do:
    Create a template structure for a basic Supplier Scorecard:
    • Columns: Supplier ID, Name, OTD Rate, Defect Rate, Lead Time Variability, Risk Score
    • Rating: Good, Moderate, Poor based on thresholds
  • U2xAI Prompt:
    "Help me design a basic supplier scorecard template including KPIs like on-time delivery, defect rate, and risk profile."
  • How This Helps for Interviews:
    Companies often expect analysts to contribute to or build supplier evaluation scorecards. This shows your ability to structure real-world deliverables.
  • Time Recommendation: 45 minutes

6. Plan Supplier Risk Modeling Activities for Tomorrow

  • What to Do:
    List possible ideas for risk modeling:
    • Classify suppliers into Low, Medium, High Risk categories
    • Combine delivery, quality, and financial risk into a composite risk score
  • U2xAI Prompt:
    "Suggest simple supplier risk modeling techniques that combine delivery, quality, and financial risks into a single supplier risk score."
  • How This Helps for Interviews:
    If asked, “How would you create a supplier risk model?” — you’ll have ready ideas to propose structured, business-aligned solutions.
  • Time Recommendation: 15 minutes

Step-by-Step BUILDUP Application for Day 12

  • Breakdown:
    Focus on understanding supplier evaluation KPIs and risk metrics.
  • Understand:
    Study supplier delivery, quality, and risk profile data fields.
  • Implement:
    Map key risk factors and create a supplier scorecard structure.
  • Link:
    Relate supplier performance to fulfillment rates and supply chain disruptions.
  • Document:
    Write a supplier evaluation framework and prepare a basic supplier scorecard.
  • Upgrade Progress:
    Plan tomorrow’s activities: supplier risk modeling and classification.

Deliverables for Today

  • Supplier Evaluation KPI Summary Sheet
  • List of Key Supplier Risk Metrics
  • Supplier Issues Impact Mapping (to Fulfillment)
  • Supplier Scorecard Template
  • Supplier Risk Modeling Planning Notes

Practice Interview Questions for Day 12

  1. What KPIs would you track to evaluate supplier performance?
  2. How would you calculate a supplier’s delivery reliability?
  3. What is a defect rate, and how does it impact fulfillment?
  4. How would you create a supplier scorecard for quarterly reviews?
  5. How does supplier inconsistency impact inventory and customer satisfaction?

Bonus Practice:
Prepare a 2-minute explanation answering:
“If Titan’s top supplier starts missing 20% of deliveries, what actions would you take based on supplier KPIs?”