ProcureIQ – Hotel Purchasing Manager

Good morning, Purchasing Team

Here's your price overview for

Price Trend – This Month

Spend by Department

⚠ Price Alerts – Items with >3% rise this month

Item	Dept	Day 1	Latest	Change	% Rise	Budget	Status

Price Log

Record daily supplier prices for all departments

Quick Entry

Department

Item

Day

Price (LKR)

All Entries

Day	Dept	Item	Price (LKR)	Prev Price	Change	% Chg

Variance Analysis

Compare first-day vs latest price across all tracked items

Price Variance – All Items

Dept	Item	Day 1 Price	Latest Price	Change (LKR)	% Change	Budget	Budget Var.	Status

% Change by Item

Budget Tracker

Monthly budget vs cumulative actual spend – click a budget to edit it

Budget vs Actual – All Items

Dept	Item	Budget (LKR/mo)	Cumul. Actual	Remaining	% Used	Status	Alert

Items Master List

Add items manually, in bulk via CSV, or manage departments

Add a Single Item

Department

Item Name

Unit

Monthly Budget (LKR)

Bulk Upload via CSV

📋

Required CSV columns (in order): Department, Item Name, Unit, Monthly Budget
First row = header. Duplicates (same dept + name) are skipped automatically. Department names must match exactly.

Sample CSV content:

            Department,Item Name,Unit,Monthly Budget

            Kitchen,Butter (kg),kg,15000

            Kitchen,Garlic (kg),kg,8000

            Kitchen,Tomatoes (kg),kg,12000

            F&B,Wine (bottle),btl,45000

            Housekeeping,Hand Soap (L),L,9000

            Engineering,Paint (L),L,22000

📂 Click to choose CSV file or drag & drop here

Or paste CSV text directly:

Need a starting template?

Add Custom Department

New Department Name

All Departments

Department	Items	Price Entries	Type

All Tracked Items

Dept	Item	Unit	Budget/mo (LKR)	Entries	Avg Price	Latest Price

Monthly Price View

Full month grid — every item × every day at a glance. Click any cell to edit.

Change vs prev day: No data Unchanged +1–3% +3–5% +5–10% >10% Decrease

Click a cell to edit · Empty = no entry

Select a department to view