Dynamic Pricing Algorithm

Upload Excel File

Drag & Drop your Excel file here

or click to browse

Download Sample Template

Processing your file...

Pricing Results

Dynamic Pricing Results

Showing all items

Suggested Price Legend:

Green = Decrease Price

Yellow = Increase Price

Item #	Description	Cost	Current Price	Suggested Price	Price Driver	Local Price	Markup %	Profit/Box	Profit/Wt (lbs)	Profit/Vol.(cbf)	Holding Cost/Day	Status

Pricing Analytics

Price Distribution

Markup Distribution

Current Profit Per Box vs Cost

Price Adjustment Reasons

Current vs Suggested Price

Price Driver Distribution

Inventory Holding Cost Analysis

Upload an Excel file and view results to see analytics.

Premium Analytics

Advanced pricing insights and strategic recommendations

Current vs Suggested Price

Price Change Magnitude

Inventory Age vs Profitability

Volume Efficiency Analysis

Sales Velocity Heatmap

Competitive Impact Analysis

ROI Distribution Analysis

Upload an Excel file and view results to see premium analytics.

Algorithm Configuration

Markup & Profit Settings

Min Markup Range (%)

to

Min Profit per Box Range ($)

to

Min Profit per Weight Range ($/lb)

to

Min Profit per Volume Range ($/cubic foot)

to

Pricing Factors

Local Discount Factor Discount for local sales (0.90 = 10% discount)

Supply/Demand Factor Price adjustment factor for supply/demand (0.20 = 20% adjustment)

Supply & Demand Settings

Fast Sales Threshold Cases per month considered "fast"

Slow Sales Threshold Cases per month considered "slow"

Low Stock Threshold Quantity considered "low stock"

High Stock Threshold Quantity considered "high stock"

Slow Sales Discount Factor Discount for slow-moving products (0.85 = 15% discount)

Warehouse & Expiration Settings

Warehouse Rent Factor ($/cubic foot/day) Daily rent cost per volume unit

Expiration Discount Factor Discount for expiring products (0.70 = 30% discount)

Excel Template

Required Columns for Excel Upload:

Item - Unique identifier for each product
Description - Product name and description
Cost - Cost per box/case
Weight (lb) - Weight per box/case (in lbs)
Volume (CBF) - Volume per box/case (in cubic feet)
Quantity On Hand - Current inventory quantity
Price - Current price (for comparison)

Optional Columns:

Competitive Pricing Factor - Competitive pricing adjustment (1.0 = no adjustment, 0.85 = 15% discount, 0.90 = 10% discount). Use when you need to match or beat competitor prices.
Rate Per Month - Monthly sales rate per case (defaults to 0 if not provided)
Expiration Discount - Set to 1 if product is expiring soon
Slow Sales Discount - Set to 1 if product is slow-moving
Days In Warehouse - Number of days product has been stored

Download Sample Template