SLO Alignment
Integration of SLO1 through SLO6:
• Apply modeling to decision making
• Use Excel visualization tools
• Apply regression principles
• Use forecasting methods
• Apply Monte Carlo simulation
• Create and use decision models for optimal strategy
CLO Alignment
CLO1: Master appropriate analytical tools
CLO2: Master software and modeling techniques
CLO3: Apply regression to business situations
CLO4: Reinforce Excel decision tools
Objective
Develop a comprehensive business modeling solution that integrates forecasting, risk analysis, and optimization to support a real managerial decision.
Project Requirements
- Select a Real Business Problem
Examples include:
• Pricing strategy
• Demand forecasting
• Inventory planning
• Capital budgeting
• Operational optimization
- Your project must include:
• A regression or forecasting component
• A risk analysis component using probability or simulation
• An optimization or decision model
• Structured and professionally designed Excel workbook
• Clearly labeled inputs, calculations, and outputs
- Executive Summary
Submit a written executive summary that includes:
• Business problem definition
• Modeling approach used
• Key findings
• Risk interpretation
• Final strategic recommendation
- Managerial Interpretation
You must explain:
• Why your modeling approach is appropriate
• What assumptions were made
• Limitations of the model
• Strategic implications for decision makers
Submission Requirements
• Complete Excel model file
• Executive summary document
• Clear organization and professional presentation
Evaluation Criteria
1. Technical accuracy of models
2. Integration of forecasting, risk, and optimization
3. Strategic interpretation and managerial insight
4. Professional Excel structure
5. Clarity and quality of executive summary
