/en/projects · what we have built
A software agent for procurement teams: every week it collects prices for hundreds of items from public sources, supplier emails and 1C, calculates a benchmark price and prepares an Excel workbook for the procurement committee. From 2M RUB, 16 weeks.
| Stage | Weeks | Cost |
|---|---|---|
| Approach check on historical data | 2 | from RUB 150,000 |
| Item catalog, price normalization rules, parameters | 2 | from RUB 200,000 |
| Email channel: price requests, reply parsing, OCR | 4 | from RUB 650,000 |
| Public sources, calculation and 1C reconciliation | 4 | from RUB 550,000 |
| Excel workbook, distribution, trial run, handover | 4 | from RUB 450,000 |
| Total | 16 | from RUB 2,000,000 |
Every week buyers collect prices by hand from websites, supplier price lists and 1C and put them into one table for the committee meeting. The company wants an agent to do this and show where every number came from.
Scheduled collection from public sources, with a separate module for each. Every quote is stored with its URL, timestamp and a snapshot of the page. The agent sends price requests to suppliers from a dedicated mailbox and reads their replies in XLSX, PDF, DOCX and scans. When recognition confidence is low, the quote goes to manual review. From 1C the agent only reads the item catalog, receipts and contracts.
Prices are brought to one basis: rubles per ton, without VAT, on one delivery basis, at the central bank rate. Outliers and stale data are dropped, and each dropped quote is kept along with the rule that removed it. The benchmark price is a weighted median, and every item gets a confidence score. The agent computes a basket index by product group, raises alerts and shows how price changes affect production cost.
The result arrives before the meeting: an Excel workbook built on formulas, a short note by email and a copy in a network folder. Buyers change thresholds and source weights themselves, without a developer. 24 months of history are available to BI tools. Everything runs on one server inside the company network.
16 weeks. The first summary on real data appears in week six.
From 2M RUB. VAT exempt (Skolkovo resident).