Honda Motors – Supply Chain Management & Forecasting Analysis

This repository contains a comprehensive Supply Chain Management (SCM) and Forecasting Analysis Project on Honda Motors, developed by Nidhi Kekatpure.
The project combines business case study insights, supply chain logistics, and quantitative forecasting models (built in Excel) to analyze and improve decision-making for Honda’s U.S. operations.

---

📌 Project Overview

• Company Honda Motors
• Focus Areas
  • Supply chain management & logistics network
  • Transportation challenges and solutions
  • Quantitative forecasting for sales & production planning
  • Financial performance measures
• Tools Used Excel (Data Analysis, Forecasting Models, Regression, Break-even Analysis), PowerPoint

---

🏭 Company Background

• Entered U.S. market in 1959 (motorcycles).
• Entered U.S. automobile market in 1973, competing with Ford & GM.
• Established manufacturing plant in Ohio and HQ in Torrance, CA.
• Expanded dealerships 805 by 1983.
• By 1990, Honda sold 2 cars in U.S. for every 1 sold in Japan.
• Achieved 1M+ annual U.S. sales in 1997 and sustained until 2019.
• Today 12 manufacturing plants in U.S., 1000s of suppliers worldwide, exports to Canada.
• Market cap $46 billion (2023)contentReference[oaicite0]{index=0}.

---

🚚 Supply Chain & Logistics

Modes of Transportation

• Trucks – Deliver cars to dealerships across North America.
• Trains – Long-distance distribution from plants to hubs.
• Ships – Export to global markets.
• Airfreight – For urgent or remote deliveriescontentReference[oaicite1]{index=1}.

Transportation Issues

• Traffic Congestion – Delays in ports, airports, hubs.
• Shipping Delays – Caused by weather, strikes, port backlog.
• Rising Shipping Costs – Fuel, labor, insurance.
• Security Risks – Theft, piracy, terrorismcontentReference[oaicite2]{index=2}.

Solutions Implemented

• Advanced logistics planning systems (forecasting, route optimization).
• Lean logistics (reduced vendors, shorter transit times).
• Sustainability initiatives (alternative fuels, reduced emissions).
• Automation (warehouse systems, digital platforms, analytics).
• Stronger collaboration with logistics partnerscontentReference[oaicite3]{index=3}.

---

📊 Forecasting & Quantitative Analysis

1. Break-Even Analysis

• New plant investment $18,000,000
• Avg. Selling Price per vehicle $22,166
• Avg. Variable Cost per vehicle $20,333
• Break-even point (BEP) = 9,820 vehiclescontentReference[oaicite4]{index=4}.

---

2. Moving Average (MA)

• 3-Period MA → MAD = 18,291
• 4-Period MA → MAD = 19,260
• Used to smooth sales data and generate short-term forecastscontentReference[oaicite5]{index=5}.

---

3. Weighted Moving Average (WMA)

• 3-Period WMA (weights 3,2,1) → MAD = 19,170
• 4-Period WMA (weights 4,3,2,1) → MAD = 19,547contentReference[oaicite6]{index=6}.

---

4. Linear Regression Model

• Independent Variable (X) Production (Units)
• Dependent Variable (Y) Sales (Units)
• Dataset 16 quarterly data points (2019–2021, U.S.)
• Regression output Showed strong correlation between production & sales.
• Result Regression gave the lowest MAD, making it the best forecasting methodcontentReference[oaicite7]{index=7}.

---

✅ Conclusion

• Linear Regression outperformed MA & WMA in accuracy (least MAD).
• Quantitative forecasting helps streamline production planning.
• Honda should adopt data-driven forecasting to anticipate sales trends and optimize supply chain operations.

---

📌 Recommendations

• Use quantitative forecasting models (Linear Regression + MAWMA for short-term).
• Apply insights for production planning & inventory optimization.
• Diversify suppliers to reduce risk.
• Implement business continuity planning for natural disasters & global disruptions.
• Leverage digital supply chain visibility for proactive decision-makingcontentReference[oaicite8]{index=8}.

---

⚠️ Limitations

• Forecasts rely on historical data – sudden market disruptions (e.g., COVID-19, chip shortage) may reduce accuracy.
• MAD only measures absolute error, not directional bias.
• Models are Excel-based; AIML models (ARIMA, LSTM) could improve accuracy.

---

📂 Repository Contents

• Honda.xlsx – Sales, production, and forecasting models (MA, WMA, Regression).
• Financial Measures Honda.xlsx – Break-even and financial performance analysis.
• Honda.pptx – Presentation summarizing supply chain, logistics, and forecasting insights.
• README.md – Documentation (this file).

---

👩‍💻 Developed by Nidhi Kekatpure
📘 Project Domain Supply Chain Management, Forecasting, Quantitative Analysis
🛠 Tools Used Excel (Statistical & Forecasting Models), PowerPoint (Business Presentation)