This portfolio is an operations analysis model developed in Microsoft Excel, designed to evaluate the supply chain of a simulated company called Pro Fit, with a focus on cost reduction. The company generates revenue through the wholesale distribution of gym equipment to retailers and fitness centres.
The model incorporates risk analysis techniques, including scenario analysis, to assess how changes in market conditions may impact the company’s operational and financial performance. Key areas covered within the model include demand planning and forecasting, procurement planning, inventory management, customer cost analysis, and product performance analysis.
The model is structured using financial modelling best practices, progressing from a cover page through inputs, calculations, and outputs. The outputs sheet presents a range of data visualizations, including combo charts, pie charts, column charts, and line charts.
Notes have been added to help guide the reader.
From a technical perspective, the model leverages a combination of Excel functions and tools, including:
- =CHOOSE
- Combo Box
- =SUMPRODUCT
- =AVERAGE, ABS
- =SQRT
- Conditional Formatting
- =IF
- Pivot Tables
- Pivot Charts