What are the responsibilities and job description for the Strategic Planning Analyst Internship position at OSBORN LLC?
Key Responsibilities:
1. Forecasting Analysis
- Clean, organize, and analyze historical demand data
- Support development and evaluation of forecasting models
- Identify trends, seasonality, and demand variability
- Measure forecast accuracy (e.g., MAPE, bias) and recommend improvements
2. Safety Stock Optimization
- Analyze demand variability and service level targets
- Assist in calculating optimal safety stock levels using statistical methods
- Evaluate current inventory policies and identify gaps or excess
- Provide recommendations to balance service levels and inventory costs
3. Lead Time (LT) Analysis
- Collect and analyze supplier and internal lead time data
- Identify variability and root causes of delays
- Support initiatives to improve lead time reliability and planning assumptions
- Build reporting tools to track LT performance over time
4. Data & Reporting
- Build dashboards and reports using Excel, Power BI, or similar tools
- Present findings and insights to Demand Manager in a clear, structured format
- Document methodologies, assumptions, and recommendations
Qualifications:
- Pursuing a Bachelor’s degree in Business
- Strong communication (verbal and written) and interpersonal skills
- Attention to detail and ability to manage multiple projects in a timely manner