Operations & Supply Chain Analysis (Excel Modeling + Report)

looking for an experienced freelancer in Operations Management / Supply Chain Analysis to assist with a short analytical project involving modeling and written insights.

Scope of Work:

Analyze a supply chain simulation dataset and explain performance outcomes across the supply chain.

Build Excel transportation models to evaluate two plant location alternatives and determine optimal distribution costs.

Calculate NPV for both alternatives using spreadsheet models.

Conduct a case-based analysis related to supply chain security, sustainability, and operational performance.

Use Excel Solver / financial analysis tools to evaluate supply chain design options.

Provide clear tables, charts, and a concise written explanation of findings.

Requirements:

Strong knowledge of Operations Management / Supply Chain concepts

Experience with Excel modeling (Solver, optimization, NPV)

Ability to present results in clear spreadsheets and short reports

Familiarity with transportation models and supply chain performance metrics

Deliverables:

Excel spreadsheets with models and calculations

Short written analysis explaining results and recommendations