System Live v1.31.0

FreshStock QR Operations

Database Ledger View

20-Day Overview Dashboard Subscription Requests Managed Stores Simulated Database tables 🖨️ Print QR Labels

WordPress FreshStock QR Subscriber Workspace

Simulating active subscriber session credentials, provincial retail access scopes, and reporting periods

Subscriber Connected

1. SUBSCRIBER LOGIN CREDENTIALS ?

Freshies Group HQ Admin

✉ cvedgesa@gmail.com

PASS: •••••••••••

2. SUBSCRIBER STORE ALLOCATION ?

FILTERED STORE BRANCHES

All Assigned Stores (5)

Freshies Cape Town, Freshies Joburg, Freshies Durban, ...

3. OPERATIONAL PERIOD & FROM/TO DATES ?

SELECTED REPORTING PERIOD

Full 20-Day Simulation

From 2026-06-07 to 2026-06-27

Continuous 20-Day Simulation Active: The metrics below represent a full, closed-loop operational test involving 5 stores and 20 highly perishable agricultural products tracked over 20 consecutive days. Receiving counts, markdown pricing events, and waste logs are completely modeled.

Waste Prevented

💡 Revenue Recovered

Represents the total financial value recovered by discounting critical stock instead of disposing of it.

R 1,676,982.94

Value preserved from 81497 sold items

Represents the total financial value recovered by discounting critical stock instead of disposing of it.

Markdown Efficacy

💡 Sell-Through Rate

Measures the percentage of perishable items effectively sold through markdown strategies rather than discarded.

65.8%

Percentage of critical aging stock sold

Measures the percentage of perishable items effectively sold through markdown strategies rather than discarded.

Dumped Stock Loss

💡 Discarded Waste Cost

Shows the total value of stock that passed its expiration threshold and required disposal.

R 876,359.53

Value of 42377 items sent to compost

Shows the total value of stock that passed its expiration threshold and required disposal.

Continuous Batches

💡 Active Inventory Schedules

Indicates the current number of active inventory batches being tracked across all regional store locations.

2625

Active schedules across 5 checked regions

Indicates the current number of active inventory batches being tracked across all regional store locations.

Cumulative Loss Mitigation Trend (20-Day Profile) ?

Tracking saved value vs lost value day by day

Waste Prevented Dumped Loss

Store Performance ?

Recovery rate by region/province

Freshies Cape Town Western Cape

R 420,334 81.2% recovery

Freshies Pretoria Gauteng

R 398,150 76.8% recovery

Freshies Joburg Gauteng

R 340,527 66.6% recovery

Freshies Durban KZN

R 276,104 55.5% recovery

Freshies PE Eastern Cape

R 241,868 47.9% recovery

Store Profitability Trend ?

Cumulative profit (R) of All Stores over 20 days

Net Profit (R)

Product Profitability Trend ?

Cumulative profit (R) of over 20 days

Net Profit (R)

Product Lifecycles Breakdown ?

Detailed metric analysis of all stocked product catalog classes over simulated reporting window.

Product	Completed Cycles	Total Preserved Revenue	Total Lost Value	Efficacy Rate	GP%	Action
Potatoes	105 batches	R 235,870.99	R 118,738.42	66.7% Efficacy	-42.9%	Simulate
Tomatoes	105 batches	R 147,362.68	R 60,775.41	70.6% Efficacy	-42.8%	Simulate
Apples	105 batches	R 113,590.02	R 60,310.23	65.1% Efficacy	-42.9%	Simulate
Pears	105 batches	R 95,378.14	R 52,102.67	64.7% Efficacy	-42.9%	Simulate
Onions	105 batches	R 76,136.93	R 48,213.77	61.2% Efficacy	-42.9%	Simulate
Peppers	105 batches	R 74,781.36	R 42,597.89	63.6% Efficacy	-42.9%	Simulate
Grapes	105 batches	R 74,711.23	R 41,850.12	64.2% Efficacy	-42.9%	Simulate
Oranges	105 batches	R 72,462.60	R 40,991.20	64.2% Efficacy	-42.9%	Simulate
Peaches	105 batches	R 71,452.18	R 36,587.62	66.3% Efficacy	-42.9%	Simulate
Lemons	105 batches	R 68,721.04	R 33,227.31	67.7% Efficacy	-42.8%	Simulate
Bananas	105 batches	R 58,943.48	R 26,172.72	69.2% Efficacy	-42.8%	Simulate
Melon	105 batches	R 53,021.81	R 28,566.10	65.1% Efficacy	-42.8%	Simulate
Strawberries	105 batches	R 50,008.56	R 28,695.32	63.9% Efficacy	-42.9%	Simulate
Pineapple	105 batches	R 47,624.66	R 24,145.41	66.2% Efficacy	-42.8%	Simulate
Kiwi	105 batches	R 47,268.17	R 26,227.35	64.3% Efficacy	-42.9%	Simulate
Blueberries	105 batches	R 47,211.34	R 25,080.32	65.1% Efficacy	-42.8%	Simulate
Avocados	105 batches	R 45,478.02	R 28,157.29	62.0% Efficacy	-42.8%	Simulate
Raspberries	105 batches	R 43,261.18	R 21,587.12	66.5% Efficacy	-42.9%	Simulate
Mushrooms	105 batches	R 40,417.66	R 22,160.15	64.8% Efficacy	-42.9%	Simulate
Broccoli	105 batches	R 40,117.69	R 20,989.27	65.8% Efficacy	-42.9%	Simulate
TOTAL	2100 batches	R 1,503,819.74	R 787,175.69	65.7% Efficacy	-42.9%

KPI Finding 1: Shrink Vulnerability Index Critical Risk

Potatoes

R 169,625.40

Highest financial loss incurred from dumped stock passing expiry thresholds across regional units.

Recommendation: Adjust summer/winter shelf-life coefficients on the Seasonal Database to trigger markdown alerts 12 hours earlier.

KPI Finding 2: Best Practice Efficacy Leader Model Performance

Potatoes @ Freshies Pretoria

R 60,626.98

Highest cumulative revenue successfully preserved via proactive 30% discount clearances.

Observation: Store displays optimal 2-per-day stock-taking intervals, ensuring highly responsive and synchronized markdown timing.

Store-by-Product Lifecycle Performance ?

Granular breakdown of specific produce lines crossed with local supermarket branches to isolate regional variances.

Supermarket & Produce Line	Completed Cycles	Preserved Revenue	Lost Value	Efficacy Rate	GP%
Potatoes Freshies Cape Town	21 batches	R 52,620.12	R 24,259.20	75.6% Efficacy	-42.9%
Tomatoes Freshies Cape Town	21 batches	R 36,763.20	R 9,991.80	84.0% Efficacy	-42.9%
Apples Freshies Cape Town	21 batches	R 29,488.20	R 11,102.70	79.1% Efficacy	-42.9%
Pears Freshies Cape Town	21 batches	R 22,686.12	R 8,970.56	78.3% Efficacy	-42.8%
Grapes Freshies Cape Town	21 batches	R 19,593.81	R 6,424.74	81.3% Efficacy	-42.9%
Peppers Freshies Cape Town	21 batches	R 19,398.00	R 6,970.00	79.9% Efficacy	-42.8%
Peaches Freshies Cape Town	21 batches	R 19,389.66	R 5,295.68	84.0% Efficacy	-42.9%
Onions Freshies Cape Town	21 batches	R 19,332.24	R 8,426.88	76.6% Efficacy	-42.9%
Lemons Freshies Cape Town	21 batches	R 19,117.28	R 3,186.15	89.6% Efficacy	-42.8%
Oranges Freshies Cape Town	21 batches	R 18,553.50	R 6,583.50	80.1% Efficacy	-42.9%
Bananas Freshies Cape Town	21 batches	R 15,206.40	R 3,185.01	87.2% Efficacy	-42.9%
Blueberries Freshies Cape Town	21 batches	R 12,573.73	R 4,446.75	80.2% Efficacy	-42.8%
Melon Freshies Cape Town	21 batches	R 12,301.23	R 2,992.50	85.4% Efficacy	-42.8%
Kiwi Freshies Cape Town	21 batches	R 12,284.50	R 4,132.92	80.9% Efficacy	-42.9%
Pineapple Freshies Cape Town	21 batches	R 12,067.37	R 3,564.75	82.9% Efficacy	-42.8%
Strawberries Freshies Cape Town	21 batches	R 11,699.60	R 5,660.51	74.7% Efficacy	-42.9%
Avocados Freshies Cape Town	21 batches	R 11,612.16	R 3,844.80	81.2% Efficacy	-42.9%
Raspberries Freshies Cape Town	21 batches	R 11,188.30	R 3,498.56	82.0% Efficacy	-42.9%
Carrots Freshies Cape Town	21 batches	R 10,654.71	R 3,300.66	82.2% Efficacy	-42.8%
Mushrooms Freshies Cape Town	21 batches	R 10,599.95	R 3,058.98	83.2% Efficacy	-42.9%
Broccoli Freshies Cape Town	21 batches	R 10,393.01	R 2,375.01	86.2% Efficacy	-42.9%
Spinach Freshies Cape Town	21 batches	R 10,098.25	R 2,214.59	86.7% Efficacy	-42.8%
Cucumbers Freshies Cape Town	21 batches	R 8,118.00	R 3,542.00	76.6% Efficacy	-42.8%
Cabbage Freshies Cape Town	21 batches	R 8,076.14	R 2,014.60	85.1% Efficacy	-42.9%
Lettuce Freshies Cape Town	21 batches	R 6,518.40	R 3,043.29	75.4% Efficacy	-42.9%
Potatoes Freshies Durban	21 batches	R 41,336.40	R 43,596.00	57.5% Efficacy	-42.9%
Tomatoes Freshies Durban	21 batches	R 21,914.50	R 23,365.44	57.3% Efficacy	-42.8%
Apples Freshies Durban	21 batches	R 19,491.40	R 21,965.65	55.9% Efficacy	-42.8%
Pears Freshies Durban	21 batches	R 17,168.58	R 16,903.36	59.2% Efficacy	-42.9%
Peaches Freshies Durban	21 batches	R 13,029.00	R 10,505.10	63.9% Efficacy	-42.9%
Oranges Freshies Durban	21 batches	R 12,160.25	R 12,257.28	58.6% Efficacy	-42.9%
Peppers Freshies Durban	21 batches	R 11,821.80	R 14,175.36	54.4% Efficacy	-42.9%
Onions Freshies Durban	21 batches	R 11,616.22	R 17,974.00	48.0% Efficacy	-42.9%
Lemons Freshies Durban	21 batches	R 10,824.45	R 13,669.50	53.1% Efficacy	-42.9%
Grapes Freshies Durban	21 batches	R 10,623.22	R 16,341.13	48.2% Efficacy	-42.9%
Strawberries Freshies Durban	21 batches	R 9,504.53	R 8,432.67	61.7% Efficacy	-42.9%
Melon Freshies Durban	21 batches	R 9,230.13	R 10,054.80	56.7% Efficacy	-42.9%
Bananas Freshies Durban	21 batches	R 9,049.46	R 9,730.50	57.0% Efficacy	-42.8%
Blueberries Freshies Durban	21 batches	R 8,389.92	R 7,656.00	61.0% Efficacy	-42.9%
Pineapple Freshies Durban	21 batches	R 7,915.41	R 7,842.45	59.0% Efficacy	-42.8%
Kiwi Freshies Durban	21 batches	R 7,091.25	R 10,214.82	49.8% Efficacy	-42.8%
Broccoli Freshies Durban	21 batches	R 6,980.40	R 6,552.24	60.3% Efficacy	-42.8%
Carrots Freshies Durban	21 batches	R 6,914.86	R 8,381.34	54.1% Efficacy	-42.9%
Avocados Freshies Durban	21 batches	R 6,784.32	R 9,864.90	49.6% Efficacy	-42.8%
Cucumbers Freshies Durban	21 batches	R 6,055.00	R 7,175.00	54.7% Efficacy	-42.9%
Raspberries Freshies Durban	21 batches	R 5,862.64	R 8,871.10	48.6% Efficacy	-42.9%
Mushrooms Freshies Durban	21 batches	R 5,822.96	R 8,988.81	48.1% Efficacy	-42.9%
Cabbage Freshies Durban	21 batches	R 5,819.40	R 5,041.62	62.2% Efficacy	-42.8%
Spinach Freshies Durban	21 batches	R 5,612.90	R 7,882.68	50.4% Efficacy	-42.9%
Lettuce Freshies Durban	21 batches	R 5,084.73	R 5,945.67	55.0% Efficacy	-42.8%
TOTAL	1050 batches	R 696,437.61	R 455,473.56	68.5% Efficacy	-42.9%

Executive Performance & Findings Report ?

Holistic strategic assessment identifying critical performance leaders and high-shrink vulnerabilities across regional stores and fresh product lines.

⭐ Best Store Overall

Freshies Cape Town

Efficacy: 88.5%

Preserved: R 18,450.00

Exemplary compliance with daily scanning protocols and rapid 30% discount response.

⚠️ Worst Store Overall

Freshies Johannesburg

Efficacy: 35.2%

Loss / Waste: R 9,250.00

Lags in daily inventory scanning intervals, resulting in excess stock dumping on expiry dates.

🥗 Best Product Overall

Cucumbers

Efficacy: 81.4%

Preserved: R 11,200.00

High demand elasticity at markdown tier results in exceptional product clearance rates.

📉 Worst Product Overall

Spinach

Efficacy: 29.8%

Loss / Waste: R 4,850.00

Shorter bio-resiliency shelf life. Requires early-alert profiles on the seasonal database.

Key Operations Findings & Actionable Recommendations

1. Improve Regional Checking Intervals: Low-performing stores such as Freshies Johannesburg exhibit average stock check intervals exceeding 28 hours. Raising compliance standards to match the 12-hour cycle achieved at Freshies Cape Town is estimated to reclaim up to R 15,000.00 in quarterly shrink.

2. Dynamic Seasonal Shelf-life Calibrations: High-spoilage produce lines like Spinach require tighter alert triggers during seasonal peaks. Integrating immediate temperature and relative humidity parameters into the FreshStock alert algorithms will notify regional managers to initiate markdown processes up to 8 hours earlier, preventing total product loss.