The columns, and what each is for
| Column | What goes in it | Why it matters |
|---|---|---|
| Ref | A code per item, such as GR-01 for the first guest-room piece | The one name the drawings, the budget and the maker’s order all use |
| Area | The room or area: King guest room, Lobby, Restaurant | Hotels repeat rooms, so quantities follow the room count |
| Item | What it is: Bed, Desk chair, Floor lamp | Read at a glance in a client meeting |
| Description | What makes it this item: size, construction, special requirements | What the maker prices against |
| Maker | The manufacturer or workshop | Where the request for quotation goes |
| Product code | The maker’s own code | Stops the wrong variant being ordered |
| Finish | Fabric, timber, metal, colour, with the maker’s finish codes | The most common source of a wrong delivery |
| Dimensions | W x D x H in millimetres | Checked against the drawings |
| Quantity per area, areas, total quantity | How many in one room, how many rooms, and the product of the two | A room count that changes moves every line at once |
| Unit price, currency, line total | The quoted price per unit and the total | Feeds the budget |
| Price status | Quoted, estimated or to confirm | A budget built on estimates should say so |
| Lead time | Weeks from order to delivery | Drives the programme and the order dates |
| Fire and safety | The standard the item meets, such as the local fire test for upholstery | Hotels and public areas are checked against it |
| Status | Concept, specified, approved, ordered, delivered, installed | Where every item stands, in one column |
| Notes | Anything a person needs to know | Open questions stay visible |
How to use it on a hotel project
- Fill one room type at a time. A 40-key hotel with two room types is two short lists, not 40 long ones.
- Put the number of rooms in Areas. The total quantity follows, so a change from 34 to 36 kings is one cell.
- Leave a price empty and set Price status to “to confirm” until a maker has quoted. An empty cell is honest; a guessed number in a client budget is not.
- Keep public areas (lobby, restaurant, bar, spa) as their own areas, since their items are rarely repeated.
- Send each maker only their rows. Filter by Maker, and that is the request for quotation.
The worked example
The second sheet fills one King guest room of The Saltmarsh Hotel, an invented 40-key hotel we use for samples. The quantities and finishes are examples, the makers are left as “to confirm”, and there are no prices: it shows how the columns fill, not what a room costs. For what rooms cost, see how hotel FF&E budgets are set per key.
The same schedule, filled from your project
Nodejam’s interior design project workflow fills these columns from the project’s own files, then makes the budget, the programme and one request for quotation per maker from the same rows, so the numbers agree across every file.