Store Inventory

The Grand Riverside Hotel — Store

Main store stock, replenished from external vendors and issued out to the kitchen & departments.

£99,890 store stock 24 items low on stock 6 purchase orders due 5 requisitions to fulfil 738 items tracked

Cost centre: Store Stock flow: VENDOR STORE (purchase order — money out) KITCHEN / DEPTS (requisition / issue — internal)

Store stock by category

Perishables Daily ordering £24,050 6 low · 142 items

Grocery Weekly · monthly £41,200 9 low · 318 items

Consumables Single-use £12,480 3 low · 96 items

Stationery Office supplies £3,260 1 low · 54 items

HK Supplies Housekeeping £18,900 5 low · 128 items

Stock movement — this month (May), how the closing value is built

Opening + Purchases − Issued = Closing

Opening balance

£95,190

b/f from April

Purchases (vendors)

£66,000

goods received on POs

−

Issued to departments

£61,300

requisitions fulfilled

Closing — stock on hand

£99,890

matches dashboard total

Only vendor purchases add value to the store; issuing to departments is an internal transfer out. The £61,300 issued is exactly what the kitchen & other departments received this month (kitchen took £44,000 of it). Valued at weighted-average cost.

Stock value by category

Monthly purchases (£)

Issues out to departments by category (this month, £)

Value of stock issued from the Store to each department — the Kitchen receives via requisition, not direct purchase.

Purchase Orders to vendors

6 due

Store stock below reorder level — buy from outside vendors. Money leaves the hotel.

King Prawns kitchen 86'd

OceanCatch Ltd · 0 / 8 kg · store out too

Raise PO

Fresh Tomatoes

FreshFarm Ltd · 4 / 20 kg

Raise PO

Cooking Oil

Global Foods · 60 / 75 L

Raise PO

Bin Liners (liner)

CleanPro · 400 / 600

Raise PO

A4 Paper Ream

OfficePlus · 6 / 10

Raise PO

Toilet Rolls (roll)

AmenityWorld · 432 / 576

Raise PO

View all 6 purchase orders

Incoming requisitions from kitchen & departments

Live · synced 14:32

Internal pull requests landing on the Store. Clicking Issue moves stock out of the Store and into the requesting cost centre — no vendor, no spend. This is the only event that depletes Store stock for the kitchen.

Requisition queue

5 to fulfil

Item	Requested by	Qty requested	Store on hand	Raised	Status	Action
Brie kitchen 86'd	Kitchen · Cold	2 kg	6 kg	14:22	Raised
Beef mince	Kitchen · Grill	10 kg	42 kg	14:18	Raised
Lettuce	Kitchen · Cold	6 kg	28 kg	14:05	Raised
Salmon fillet	Kitchen · Hot	5 kg	11 kg	13:52	Approved
Bath Towels	Housekeeping	24	84	11:30	Raised
Mozzarella	Kitchen · Hot	5 kg	31 kg	13:40	Issued	−5 kg store · +5 kg kitchen
Fresh milk	Kitchen · Bar	30 L	120 L	09:15	Issued	−30 L store · +30 L kitchen

Each issue posts a stock transfer: Store −, requesting cost centre +. Open requisition log

Inventory items

Item	Category	Issued to	Vendor	Pack (purchase → base)	Unit cost / base	In store (base unit)	Stock value	Reorder lvl	Status
Fresh Tomatoes	Perishables	Kitchen	FreshFarm Ltd	loose · kg	£1.20 / kg	4 kg	£4.80	20 kg	Low
Whole Milk	Perishables	Kitchen	DairyCo	1 bottle = 2 L	£0.95 / L	60 L 30 × 2 L	£57.00	40 L	OK
Basmati Rice	Grocery	Kitchen	Global Foods	1 pack = 5 kg	£1.30 / kg	240 kg 48 × 5 kg	£312.00	100 kg	OK
Cooking Oil	Grocery	Kitchen	Global Foods	1 bottle = 5 L	£1.96 / L	60 L 12 × 5 L	£117.60	75 L	Low
Dishwasher Tablets	Consumables	Housekeeping	CleanPro	1 tub = 40 tabs	£0.35 / tab	880 tabs 22 tubs	£308.00	400 tabs	OK
Bin Liners	Consumables	Housekeeping	CleanPro	1 roll = 50	£0.07 / liner	400 liners 8 rolls	£27.20	600 liners	Low
A4 Paper Ream	Stationery	Front Office	OfficePlus	loose · ream	£4.20 / ream	6 reams	£25.20	10 reams	Low
Guest Shampoo 30ml	HK Supplies	Housekeeping	AmenityWorld	1 carton = 60	£0.28 / btl	540 btl 9 cartons	£151.20	300 btl	OK
Bath Towels	HK Supplies	Housekeeping	LinenCo	loose · each	£6.90 / ea	84	£579.60	60	OK
Toilet Rolls	HK Supplies	Housekeeping	AmenityWorld	1 case = 48	£0.39 / roll	432 rolls 9 cases	£166.50	576 rolls	Low

Stock is counted in base units (kg · L · each). Purchase packs (bottles, cases, sacks) convert to base units on receipt; the kitchen requisitions and recipes consume in base units — so reorder levels, value & variance all reconcile. Showing 10 of 738 store items · recipe consumption tracked on the Kitchen dashboard.