INTL
Freelancer
보통
외주
원격 가능
Profit Maximization Linear Programming
예산
$30~$250 USD
예상 기간
3~7일
난이도
보통
기술 스택
Excel
LibreOffice Calc
Python
PuLP
Pyomo
Linear Programming
Operations Research
Data Analysis
Statistical Analysis
Mathematics
Statistics
AI 분석 요약
이 프로젝트는 주어진 비즈니스 맥락에 맞춰 수익 극대화를 위한 선형 계획법(Linear Programming) 모델을 수립하고, 이를 Excel Solver나 Python 같은 도구로 구현하여 최적해를 찾아야 합니다. 도출된 결과와 쉐도우 프라이스, 민감도 분석을 포함한 상세 보고서 작성이 필요하며, 최적화 모델링 및 결과 해석 역량이 핵심입니다.
프로젝트 원문 설명
I need a clear, well-structured linear programming model that focuses on pure optimisation—specifically a profit-maximisation scenario. All coefficients, constraints and objective functions must be laid out transparently so the logic is easy to follow and modify later.
What I will hand over:
• A concise description of the business context, the decision variables involved, and any hard limits or relationships that must hold.
What I expect back:
• A fully formulated LP model (objective function and constraints) expressed in standard mathematical notation.
• A working solution file that can be run in either Excel Solver, LibreOffice Calc with Solver, Python (PuLP, Pyomo or similar) or another open-source tool—please specify your choice up front.
• A short write-up (one to two pages) explaining the results, shadow prices and any sensitivity insights so I can understand how profit responds to changes in key parameters.
Acceptance criteria:
• Objective function must explicitly maximise profit; no surrogate measures.
• The model must run and reproduce the optimal profit figure you report, with all constraints satisfied.
• Variables, constraints and assumptions must match the business context I provide; no unstated simplifications.
If you have experience tackling maximisation problems in optimisation software and can explain your results clearly, I’m ready to move quickly once we agree on the toolset.
What I will hand over:
• A concise description of the business context, the decision variables involved, and any hard limits or relationships that must hold.
What I expect back:
• A fully formulated LP model (objective function and constraints) expressed in standard mathematical notation.
• A working solution file that can be run in either Excel Solver, LibreOffice Calc with Solver, Python (PuLP, Pyomo or similar) or another open-source tool—please specify your choice up front.
• A short write-up (one to two pages) explaining the results, shadow prices and any sensitivity insights so I can understand how profit responds to changes in key parameters.
Acceptance criteria:
• Objective function must explicitly maximise profit; no surrogate measures.
• The model must run and reproduce the optimal profit figure you report, with all constraints satisfied.
• Variables, constraints and assumptions must match the business context I provide; no unstated simplifications.
If you have experience tackling maximisation problems in optimisation software and can explain your results clearly, I’m ready to move quickly once we agree on the toolset.
Freelancer에서 원본 확인
원본 보기