Optimizing Selling Price Calculation on Allegro
Budget: $10 – $30 USD
Please calculate the selling price on Allegro based on the specified margin (Margin Calculation Sheet, Column B). The selling price depends on:
Purchase price (Margin Calculation Sheet, Column C)
Coin cost, which depends on the selling price (Costs Sheet)
SMART cost, which depends on the selling price (Costs Sheet)
Sales commission (Costs Sheet)
Unfortunately, this cannot be calculated using a standard margin calculation method because the margin value depends on the selling price, and the selling price depends on parameters that are themselves dependent on it. Please propose an iterative method, Solver, or Python application to solve this.
Solution
The problem described involves a circular dependency: the selling price depends on costs (coin cost, SMART cost, and commission), which in turn depend on the selling price. This creates a situation where traditional algebraic formulas cannot directly solve for the selling price without iteration. Below, I propose three approaches to solve this: an iterative method in Excel, using Excel Solver, and a Python application.
Purchase price (Margin Calculation Sheet, Column C)
Coin cost, which depends on the selling price (Costs Sheet)
SMART cost, which depends on the selling price (Costs Sheet)
Sales commission (Costs Sheet)
Unfortunately, this cannot be calculated using a standard margin calculation method because the margin value depends on the selling price, and the selling price depends on parameters that are themselves dependent on it. Please propose an iterative method, Solver, or Python application to solve this.
Solution
The problem described involves a circular dependency: the selling price depends on costs (coin cost, SMART cost, and commission), which in turn depend on the selling price. This creates a situation where traditional algebraic formulas cannot directly solve for the selling price without iteration. Below, I propose three approaches to solve this: an iterative method in Excel, using Excel Solver, and a Python application.