Inventory Reports

Stock valuation, ageing and movement · as of Sep 23, 2026, 4:20 PM

Fresh Mart Grocery · Inventory report · all locations · as of Sep 23, 2026 · printed Sep 23, 2026

4.2%

Stock Value · Cost

$286,450.00

vs $274,904.00 on Sep 01

4.0%

Stock Value · Retail

$429,023.00

vs $412,522.00 on Sep 01

3.1%

Active SKUs

1,248

48,392 units on hand

3.6%

Potential Gross Profit

$142,573.00

33.2% margin at retail

Stock value by category

At cost vs at retail · 9 categories · $286,450 at cost

Stock ageing

Value at cost by days since received

0–30 days$168,520.0058.8%

31–60 days$74,260.0025.9%

61–90 days$29,340.0010.2%

Over 90 days$14,330.005.0%

Valuation by category

Cost and retail value, potential margin and stock exceptions per category

Stock valuation by category with SKU count, units, cost and retail value, margin and exception counts
Category	SKUs	Units	Cost value	Retail value	Margin	Low	Out	Expiring	Share of stock value
Pantry	268	10,940	$73,650.00	$105,214.00	30.0%	8	1	0	25.7%
Beverages	186	9,860	$42,310.00	$63,149.00	33.0%	6	2	1	14.8%
Meat & Seafood	96	3,120	$31,860.00	$46,174.00	31.0%	4	1	2	11.1%
Household	124	2,172	$29,670.00	$46,359.00	36.0%	2	1	1	10.4%
Frozen Foods	108	3,870	$27,540.00	$41,727.00	34.0%	3	1	1	9.6%
Dairy & Eggs	118	5,640	$26,720.00	$39,294.00	32.0%	5	1	6	9.3%
Snacks	142	4,690	$24,290.00	$39,177.00	38.0%	2	1	0	8.5%
Fresh Produce	142	6,120	$21,480.00	$33,046.00	35.0%	4	1	9	7.5%
Bakery	64	1,980	$8,930.00	$14,883.00	40.0%	3	3	4	3.1%
All categories	1,248	48,392	$286,450.00	$429,023.00	33.2%	37	12	24	100.0%

Fast movers

Best sellers by units · Sep 01 – Sep 23

Top 6

Fastest-moving products with units sold, days of cover and sell-through
Product	Units sold	Cover	Sell-through
BananasFresh Produce · 210 on hand	1,580	3.1 d	88%
Whole Milk 1LDairy & Eggs · 84 on hand	1,240	1.6 d	94%
Sparkling WaterBeverages · 320 on hand	1,120	6.6 d	78%
Free-range Eggs 12Dairy & Eggs · 54 on hand	690	1.8 d	93%
Sourdough LoafBakery · 22 on hand	610	0.8 d	97%
Chicken BreastMeat & Seafood · 26 on hand	470	1.3 d	95%

Cover = days the current stock lasts at this month's average daily sales. Under 2 days is a reorder risk.

Slow movers

In stock, barely selling · $1,102.80 tied up at cost

6 products

Slow-moving products with cost value, days idle since the last sale and a suggested action
Product	Cost value	Idle	Suggested action
Dish Sponges 6-packHousehold · 152 on hand	$243.20	56 days since Jul 29	Return to supplier
Rye Crispbread 250 gPantry · 96 on hand	$129.60	51 days since Aug 03	Bundle offer
Tahini 300 gPantry · 58 on hand	$197.20	46 days since Aug 08	Markdown 15%
Canned Chickpeas 400 gPantry · 240 on hand	$172.80	42 days since Aug 12	Markdown 20%
Coconut Milk 400 mlPantry · 186 on hand	$204.60	35 days since Aug 19	Feature in promo
Frozen Edamame 500 gFrozen Foods · 74 on hand	$155.40	27 days since Aug 27	Promote at till

Products with no sale for 25+ days, ordered by how long they have been idle.

Stock valuation

On-hand stock valued at cost and at retail price

Stock overview

Stock valuation by product with quantity, unit cost, cost value, unit price, retail value, margin and stock status
Product	SKU	Category	On hand	Unit cost	Cost value	Unit price	Retail value	Margin	Status
Fuji ApplesGreen Valley	FR-APL-0012	Fresh Produce	148	$2.10	$310.80	$3.19	$472.12	34.2%	In Stock
BananasGreen Valley	FR-BAN-0004	Fresh Produce	210	$0.85	$178.50	$1.29	$270.90	34.1%	In Stock
Baby SpinachGreen Valley	VG-SPN-0031	Fresh Produce	36	$1.20	$43.20	$1.99	$71.64	39.7%	Expiring Soon
Whole Milk 1LFresh Dairy	DA-MLK-0101	Dairy & Eggs	84	$1.10	$92.40	$1.69	$141.96	34.9%	In Stock
Free-range Eggs 12Fresh Dairy	DA-EGG-0012	Dairy & Eggs	54	$2.05	$110.70	$2.99	$161.46	31.4%	In Stock
Greek YoghurtFresh Dairy	DA-YOG-0207	Dairy & Eggs	9	$1.55	$13.95	$2.29	$20.61	32.3%	Low Stock
Cheddar CheeseFresh Dairy	DA-CHD-0150	Dairy & Eggs	12	$3.10	$37.20	$4.49	$53.88	31.0%	Low Stock
Sourdough LoafBaker's Guild	BK-SRD-0019	Bakery	22	$2.40	$52.80	$3.79	$83.38	36.7%	Expiring Soon
Butter CroissantBaker's Guild	BK-CRS-0033	Bakery	0	$0.90	$0.00	$1.49	$0.00	39.6%	Out of Stock
Sparkling WaterSunrise	BV-SPW-0088	Beverages	320	$0.45	$144.00	$0.79	$252.80	43.0%	In Stock
Basmati Rice 5kgGolden Harvest	PN-RCE-0500	Pantry	18	$14.20	$255.60	$18.99	$341.82	25.2%	Low Stock
Extra Virgin Olive OilMediterra	PN-OIL-0250	Pantry	7	$6.80	$47.60	$9.49	$66.43	28.3%	Low Stock
Penne PastaMediterra	PN-PST-0120	Pantry	210	$0.95	$199.50	$1.49	$312.90	36.2%	In Stock
Tomato PassataMediterra	PN-TMT-0700	Pantry	5	$1.35	$6.75	$1.99	$9.95	32.2%	Low Stock
Chicken BreastPrime Meats	MT-CHK-0005	Meat & Seafood	26	$4.60	$119.60	$6.49	$168.74	29.1%	Low Stock
Vanilla Ice CreamFrosty Foods	FZ-ICE-0900	Frozen Foods	6	$3.20	$19.20	$4.79	$28.74	33.2%	Low Stock
Potato ChipsCrunchwell	SN-CHP-0040	Snacks	140	$1.05	$147.00	$1.79	$250.60	41.3%	In Stock
Total · 17 products shown			1,307		$1,778.80		$2,707.93	34.3%

Showing 17 of 1,248 products

…