On a large hotel project, the line L1902 — 900 linear m looks convenient only until the original design documents are opened. An architectural schedule may contain both L1902S and L1902M at the same time, and these are not two ways of writing the same name. They are different HI WOOD product items with different cross-sections: L1902S — 80×27×2000 mm, L1902M — 100×33×2000 mm. If an estimator, BIM export, or Excel "for convenience" removes the last letter and merges both lines into L1902, the procurement will lose the link between the room, the design detail, and the specific SKU.

For a 60-room hotel, the problem scales quickly. In standard rooms, the project may use L1902S, while some public areas use another model, L1902M, linked in the current STAVROS card to a lighting scenario. Corridors, elevator lobbies, the restaurant, the lobby, and conference areas may have their own solutions. If all of this is combined into a total linear meterage L1902, it is no longer possible to understand from it:

  • how much L1902S to buy;

  • how much L1902M to buy;

  • where reserve S is needed;

  • where reserve M is needed;

  • which leftovers can be reused;

  • what to receive at the warehouse;

  • which SKU to reorder in six months.

Therefore, the L1902S cornice must be purchased wholesale for such a project through the following chain:

room → approved design scenario → specific SKU → separate profile route → separate parts list → separate cutting plan → 2000 mm strips → SKU reserve → marking → receiving → warehouse → issue → reorder without removing S/M.

Main principle:

L1902S and L1902M cannot be merged under a common root L1902. The suffixes S and M are part of specific product designations and must be preserved in all documents from design to warehouse.

This is the opposite task from the case where two historical names actually refer to one confirmed product record. Here, merging destroys the data.

Go to Catalog

What exactly L1902S represents

In this article, the main product is the HI WOOD L1902S decorative ceiling cornice made of polystyrene.

Parameter L1902S
Article number L1902S
Brand HI WOOD
Material Polystyrene
Size 80×27×2000 mm
Length 2000 мм
Role in the article primary purchased SKU

Product card: cornice HI WOOD L1902S 80×27×2000 mm.

For a wholesale specification, the line must retain at minimum:

HI WOOD L1902S / polystyrene / 80×27×2000 mm / quantity / project / phase.

Not:

L1902.

Not:

80 mm cornice.

Not:

standard cornice without lighting.

Why the letter S is not a technical comment

In a weak table, an employee might assume:

S is an extra letter; remove it for grouping.

But after removal:

L1902S → L1902

the SKU ceases to be specific.

This is not shortening the text.

This is loss of the identifier.

Our factory also produces:

View Full Product Catalog

L1902M is a separate SKU, not a “version of the entry” L1902S

Next to it in the catalog there is L1902M:

Parameter L1902M
Article number L1902M
Material Polystyrene
Size 100×33×2000 mm
Length 2000 мм
Status for the article separate SKU

Card: cornice HI WOOD L1902M 100×33×2000 mm.

The current product card L1902M separately positions the item as a polystyrene ceiling cornice with lighting. This is useful for understanding the project role, but the purchaser still should not decide on their own:

there is lighting → therefore automatically M.

More correctly:

the lighting design and architectural specification are coordinated → L1902M is approved for the specific zone.

Get Consultation

The geometry itself shows that this is not a single product

L1902S:

80×27×2000 mm.

L1902M:

100×33×2000 mm.

Differences include:

  • profile height/width;

  • removal;

  • cross-section;

  • project detail;

  • article number.

Therefore:

the remaining stock of L1902M is not a substitute for L1902S.

And vice versa.

Why the line “L1902 — 900 m” is not a ready-made request

Let's imagine a summary estimate:

L1902 — 900 linear m.

At first glance, it seems that the next step is:

900 / 2 = 450 planks.

But this figure does not answer the main question:

which planks exactly?

If S and M are mixed in the 900 m, the theoretical 450 pieces have no product identity.

For example, the actual structure could be:

  • L1902S — 640 m;

  • L1902M — 260 m.

Even before cutting, this is:

  • one procurement line S;

  • another procurement line M.

They cannot be merged back.

Why the error starts in the estimate, not in the warehouse

Mixed-up items are often considered a warehouse problem.

But here the warehouse is already receiving corrupted data.

If the estimate contains:

L1902,

the storekeeper cannot restore:

  • was it S;

  • was it M;

  • which room the item belonged to;

  • what geometry is needed.

Therefore, protection begins earlier:

architecture → BIM → estimate → procurement.

We create two master positions

In the corporate reference book:

Master SKU 1

HI WOOD L1902S / 80×27×2000 mm.

Master SKU 2

HI WOOD L1902M / 100×33×2000 mm.

Forbidden third card:

L1902 / generic.

The common root can only be used as search text or a family label.

Not as a purchasing SKU.

How to store data in ERP or Excel

Useful fields:

Field Example
brand HI WOOD
sku L1902S
family L1902
material polystyrene
A 80
C 27
L 2000
project_role As per project
room_group Type A
revision R2

For M:

sku = L1902M.

Field family=L1902 acceptable.

But grouping by family must not sum items for purchasing.

One project may legitimately contain both models

Example of a conditional hotel:

  • 60 standard rooms — L1902S per architectural specification;

  • some corridors — L1902S;

  • lobby with lighting scenario — L1902M;

  • restaurant — specific SKU per its project;

  • conference area — specific SKU per project;

  • elevator lobbies — per finish schedule.

This is not a universal assignment rule.

This is a procurement separation model.

First, the project determines the SKU.

Then procurement calculates the quantity.

Room map: the first document after the project

Practical table:

Room Lighting scenario Approved SKU Base
Number A no separate lighting node L1902S architectural specification
Number B no separate lighting node L1902S architectural specification
Lobby As per project L1902M architecture + lighting design
Restaurant As per project ___ Project
Corridor As per project L1902S finish schedule

Key field:

Approved SKU.

Not:

light yes/no.

The lighting scenario helps verify consistency.

But it does not replace the product specification.

Why a lighting design cannot be used instead of an architectural design

Electrical documentation may describe:

  • LED strip;

  • power supply;

  • contour;

  • control;

  • connection.

Architectural documentation defines:

  • specific cornice;

  • its geometry;

  • route;

  • junctions;

  • height/position.

If the electrician writes:

lighting contour L1902M,

and the architecture:

L1902S,

this is a collision.

Not a reason to buy both.

What to do in case of an S/M collision between project disciplines

Procedure:

  1. record the room;

  2. write down the architectural SKU;

  3. issue the lighting SKU;

  4. compare the assembly drawings;

  5. forward the question to the responsible designer;

  6. obtain the approved solution;

  7. update the revision;

  8. only after that, consider the purchase.

Procurement does not choose between S and M on its own.

We divide the hotel into room types

On a property with 60 rooms, you don't need to manually count each room from scratch if the layouts repeat.

You can create types:

  • room A;

  • room AR — mirrored;

  • room B;

  • accessible environment room;

  • corridor type K1;

  • elevator hall;

  • lobby;

  • restaurant;

  • conference area;

  • utility rooms.

For each type, the following is recorded:

  • specific SKU;

  • route length;

  • number of parts;

  • number of slats;

  • reserve;

  • revision.

For each type, we fix one approved SKU or separate routes

If the entire room uses L1902S:

room A / L1902S.

If both profiles are actually provided within one zone:

  • route S;

  • route M.

What you must not do:

room A / L1902.

And you cannot mix the linear footage before calculation.

We do not count the entire ceiling perimeter as one cornice

For the room:

  • perimeter 18 m;

  • route L1902S — 12.4 m;

  • route L1902M — 3.6 m;

  • another 2 m — a different junction or without a cornice.

If you write:

L1902 — 16 m,

the sum seems to be correct.

But the procurement information has been destroyed.

Therefore:

L1902S — 12.4 m.

L1902M — 3.6 m.

And only separately:

total decorative trim — 16 m.

We get two finished linear meterages

After standardizing the hotel, we can get, for example:

  • L1902S — approximately 640 m;

  • L1902M — approximately 260 m.

This is not a final number of planks.

But already two independent material flows.

Now you can:

  • count S parts;

  • count M parts;

  • build two cutting maps;

  • create two reserves.

Why S and M footage cannot be merged again

Bad summary:

L1902 total = 900 m.

It is only suitable for very rough analytics.

Not for:

  • requests;

  • warehouse;

  • invoice;

  • reserve;

  • reorder.

The system should be able to show:

family total = 900 m;

while preserving:

L1902S = 640 m;

L1902M = 260 m.

Converting L1902S footage into parts

Each route requires:

  • straight sections;

  • corner sections;

  • returns;

  • endings;

  • areas between doors;

  • fragments at niches;

  • interfaces with other elements.

It is the details that form the actual cutting layout.

Not the sum of meters itself.

Why dividing meters by two is not enough

L1902S has a length of 2000 mm.

If the net footage is:

640 m,

Naively:

640 / 2 = 320 planks.

But this is only a theoretical minimum.

If the project contains many 1200 mm parts, two such parts do not fit into one plank.

1200 + 1200 = 2400 > 2000.

Then the actual quantity is higher.

A conditional example with L1902S details

Let a typical number contain:

  • 1850 mm;

  • 1850 mm;

  • 950 mm;

  • 950 mm;

  • 620 mm;

  • 620 mm.

Net length:

6.84 m.

Naively:

6.84 / 2 = 3.42 → 4 planks.

But let's check the cutting.

Option

Bar 1:

Bar 2:

Bar 3:

950 + 950 = 1900.

Plank 4:

620 + 620 = 1240.

Yes, 4 planks are enough.

In another set with the same linear meters, 5 may be needed.

Therefore, the map is essential.

L1902M is calculated using its own map

There is no need to try to use S leftovers for M.

Even if the length of the segment fits.

For example:

  • remaining L1902S — 900 mm;

  • need part L1902M — 850 mm.

Fits by length.

By SKU — no.

Functional value of the S remnant for M:

Why the same white color proves nothing

Both profiles:

  • white;

  • polystyrene;

  • two-meter;

  • ceiling-mounted.

But they differ:

  • by article number;

  • size;

  • by cross-section;

  • by design node;

  • by purpose in a specific project.

After painting, visual inspection becomes even more difficult.

Therefore, identification is carried out before installation.

The summary specification must retain both lines

Example:

SKU Size Rooms Footage Slats Reserve
L1902S 80×27×2000 rooms, corridors as per design ___ ___ ___
L1902M 100×33×2000 lighting zones as per design ___ ___ ___

This is much stronger:

L1902 / 900 m / 450 pcs.

Why the string L1902 should be considered a master data error

A common root is acceptable as a family.

But if:

SKU = L1902,

this means the article field is corrupted.

The validator can check:

  • L1902S — acceptable;

  • L1902M — acceptable;

  • L1902 — CHECK/ERROR.

This way the error is caught before purchase.

Export from BIM must preserve the full SKU

The risk arises if the parameter:

Family = L1902

and a separate suffix is stored in another field.

When exporting to Excel, the second parameter is lost.

Therefore, in BIM it is useful to have:

SKU = L1902S

Or:

SKU = L1902M.

Do not assemble the SKU manually after export.

How to verify BIM export

Test sample:

  • one L1902S object;

  • one L1902M.

After export, the following should remain:

L1902S;

L1902M.

If both became:

L1902,

export cannot be used for procurement.

Excel functions can also remove the suffix

Dangerous practices:

  • LEFT() with a fixed number of characters;

  • removing the last letters;

  • grouping by root;

  • cleaning up "unnecessary" characters;

  • pattern search L1902*.

Excel itself is not to blame.

The problem lies in the processing logic.

How to safely group a family

You can add:

family = L1902.

But do not replace:

sku.

Then the report may show:

family L1902 — total volume 900 m.

At the same time, the detailed purchase retains:

S and M.

We prohibit automatic merging by item root

Bad algorithm:

take the first five characters of the SKU.

Then:

  • L1902S;

  • L1902M

become one.

Stronger:

The SKU is compared in full.

Family is a separate field.

What to do if the contractor sent a file without suffixes

Cannot be restored:

S for numbers, M for lobby

from memory.

Need to return to:

  • architectural schedule;

  • lighting project;

  • approved nodes;

  • latest revision.

After that, the file is normalized.

Why you can't guess by room

Even if usually:

numbers = S;

lobby = M.

In a specific project, it may be different.

Therefore, the room's function is a hint.

Not a SKU source.

Who confirms the final model

For a specific project's process:

  • architect;

  • interior designer;

  • responsible design engineer;

  • general designer.

Procurement does not make architectural decisions.

It ensures that the decision made is not lost in the data.

The commercial proposal must contain two lines

If the item uses both models:

L1902S — ___ pcs.

L1902M — ___ pcs.

Not:

L1902 — ___ pcs.

Even if the total amount is the same.

What to do if the supplier wrote only L1902

Send back for clarification.

Request:

  • full SKU;

  • size;

  • quantity for each SKU.

Before payment.

It is harder to correct after shipment.

If S and M have swapped quantities

For example, project:

S = 300;

M = 80.

Quote:

S = 80;

M = 300.

You should not just "swap the numbers".

First, check:

  • the original room matrix;

  • the import formula;

  • the pivot table;

  • whether the routes are mixed up.

This eliminates the cause, not the symptom.

Acceptance of L1902S and L1902M is carried out separately

For L1902S, check:

  • exact SKU L1902S;

  • 80×27×2000 mm;

  • quantity;

  • factory marking;

  • condition;

  • match with the count.

For L1902M:

  • exact SKU L1902M;

  • 100×33×2000 mm;

  • quantity;

  • marking;

  • condition;

  • compliance with its order line.

Cannot accept:

total 380 rails L1902.

If S and M are mixed inside, the total quantity proves nothing.

How to draw up a mis-shipment report

Example:

Ordered L1902S — 300 pcs.

Ordered L1902M — 80 pcs.

Actual L1902S — 280 pcs.

Actual L1902M — 100 pcs.

Total quantity:

But the delivery is still incorrect.

Shortage of S:

Surplus M:

This is a good example of why the family total cannot be used for acceptance.

Storage cells must be different

Minimum:

HIWOOD / L1902S / 80×27×2000

Separately:

HIWOOD / L1902M / 100×33×2000

Not:

L1902.

Not:

curtain rods 2 m.

After opening the packaging, white profiles are harder to distinguish visually.

Therefore, the SKU must remain on the cell and on the stock balances.

Why opened packages are especially dangerous

As long as the box or pack has a factory label:

the identity is obvious.

After opening:

  • individual strips are moved;

  • leftovers are stacked nearby;

  • crews return the material;

  • labels get lost.

If the warehouse uses a shared code L1902, the error becomes almost inevitable.

Internal labeling

For example:

L1902S / K1 / E04.

L1902M / K1 / LOBBY.

If one floor uses both models:

L1902S / E04 / S-ZONE.

L1902M / E04 / M-ZONE.

The internal code does not replace the factory SKU.

It adds a logistics designation.

Floor kits

For a typical floor, one kit can be created with two lines:

Floor SKU Quantity
4 L1902S ___
4 L1902M ___

If there is no M on the floor:

line M = 0.

This is more useful than having no field at all.

This shows that M was not forgotten.

It is genuinely not provided.

The installer must not change S to M on their own

Scenario:

the floor ran out of L1902S.

There is L1902M in stock.

The installer decides:

both are white and two meters long, I'll install M.

This is a project change.

Different sizes mean a different ceiling assembly.

Therefore:

shortage of S → check remaining stock → reserve S → reorder S.

Not:

take M.

And vice versa: remaining stock of S does not cover a shortage of M

If a lighting zone uses L1902M, the remaining stock of L1902S does not become a substitute just because the length is the same.

Functionally:

reserve(S) ≠ reserve(M).

Reserve is split by SKU

The following must exist:

reserve_L1902S

and:

reserve_L1902M.

Forbidden string:

reserve_L1902.

Why?

Because 10 S planks and 10 M planks are not 20 universal planks.

Installation and operational reserve

For each SKU separately.

Installation reserve S

For:

  • cut errors;

  • damage;

  • local changes in S-zones.

Operational reserve S

After delivery:

  • repairs;

  • replacement;

  • damage during operation.

For M — its own reserve.

They cannot be exchanged without a design decision.

Useful remnants are also separated

Marking:

L1902S / 860 mm / FREE.

Or:

L1902M / 860 mm / FREE.

Identical 860 mm remain different resources.

Why the total remaining length is misleading

In stock:

  • L1902S — 8 m remaining;

  • L1902M — 6 m.

Phrase:

L1902 remaining — 14 m

not available for reorder.

If you need S:

8 m of S available.

If you need M:

6 m of M available.

How to maintain a stock bank

SKU Length Status Purpose
L1902S 860 FREE Type A
L1902M 860 FREE Lobby
L1902S 520 ASSIGNED E05
L1902M 430 RESERVE lighting zone

So one physical piece cannot be assigned to two different SKUs.

Changing the lighting design: what to do if the lighting was removed

Cannot be done automatically:

replace L1902M with L1902S.

Why?

Because M and S have different geometry.

A unit designed for M may require:

  • a different position;

  • another junction;

  • a different gap;

  • a different architectural line.

If the lighting scenario was removed:

  1. the project is updated;

  2. the profile is confirmed;

  3. only then is the specification changed.

If the backlight was added

Similarly, you cannot:

replace S with M using a single letter in Excel.

Need to check:

  • the geometry of the ceiling unit;

  • the architectural drawing;

  • the lighting system;

  • installation location;

  • revision.

Only after this:

L1902M.

Why dimensions need to be rechecked with every S/M change

S:

80×27.

M:

100×33.

A SKU change means:

  • +20 mm in one dimension;

  • +6 mm in another.

Even without lighting calculations, this is already a different geometric object.

Therefore, a SKU change is not a formal edit.

The first standard number as a control L1902S

Before the mass launch of 60 numbers, it is useful to complete one standard number.

Checked:

  • physical L1902S;

  • geometry;

  • route;

  • joints;

  • quantity;

  • actual consumption;

  • remainders.

After acceptance, the model is scaled to identical numbers.

The first lighting zone is checked separately

If the project uses L1902M:

  • its actual card is taken;

  • the geometry is verified;

  • the specific node is checked;

  • the electrical part is checked by the relevant section of the project.

The article does not become a guide to LED installation.

Only this matters here:

The M-zone must end with the exact product line L1902M.

How to send a consolidated request to the supplier

For example:

HI WOOD L1902S / 80×27×2000 mm / 300 pcs.

And separately:

HI WOOD L1902M / 100×33×2000 mm / 80 pcs.

Pros:

  • reserve for each item;

  • a queue;

  • project.

Not:

L1902 — 380 pcs.

Why general B2B anchors should not blur product precision

The user can search large supplier of building materials or finishing material suppliers.

But after a general commercial entry, the request should narrow down to:

L1902S.

If the project uses M:

separate line L1902M.

The same applies to wholesale suppliers of building materials, wholesale purchasing of building materials, deliveries of finishing materials и materials in bulk.

A broad request leads to the supplier.

The SKU makes the order precise.

How to place a reorder L1902S

Not:

cornice L1902 — 40 more pieces.

Stronger:

HI WOOD L1902S / 80×27×2000 mm / 40 pcs. / site ___ / phase ___ / reason for reorder ___.

If you need M:

separate reorder M.

Reorder through another employee

The new procurement specialist must receive:

  • master specification;

  • old invoice;

  • a link to the card;

  • reference sample;

  • remainder;

  • reserve.

Not a description:

that cornice without light.

Specification versioning

For example:

L1902-map-v1

Initial S/M allocation.

L1902-map-v2

After lobby approval.

L1902-map-v3

After restaurant modification.

Only one active revision goes to procurement.

Previous ones are archived.

Why different departments should not work on different versions

Architecture uses v3.

Procurement opened v2.

Electricians are viewing v1.

Result:

  • different zones;

  • different quantities;

  • S/M collisions.

Therefore, each summary should show:

revision.

Fifteen mistakes when purchasing L1902S and L1902M

1. Remove S and M as "extra letters"

Why it happens: there is a desire to group a family.

Consequence: two SKUs turn into one line.

How to prevent: store the family and SKU separately.

2. Merge items by the root L1902

Why it happens: automatic normalization.

Consequence: the total linear meters lose the product structure.

How to prevent: compare the full SKU.

3. Treat S and M as variants of the same strip

Why it happens: common root and length 2000 mm.

Consequence: incorrect replacement during installation.

How to prevent: keep dimensions and separate cards.

4. Add up the square footage of S and M

Why it occurs: a single total is needed for the project.

Consequence: it is impossible to place a correct order.

How to prevent: keep the family total only analytically.

5. Keep one shared reserve

Why it occurs: it is simpler from an accounting standpoint.

Consequence: the stock of one SKU masks a shortage of another.

How to prevent: reserve_S and reserve_M.

6. Confusing the architectural and electrical specifications

Why it happens: M is tied to the lighting scenario.

Consequence: the electrical document starts to be treated as the source of product geometry.

How to prevent: consolidate the sections, and resolve collisions with a design decision.

7. Changing S to M just because lighting was added

Why it happens: the logic seems obvious.

Consequence: the new ceiling assembly has not been checked.

How to prevent: a separate project revision.

8. Changing M to S after removing lighting

Why it happens: M is perceived only as "lighting-related."

Consequence: the assembly geometry changes without approval.

How to prevent: the profile is confirmed by the architect.

9. Accept delivery by the word L1902

Why it happens: the invoice uses an abbreviated name.

Consequence: the quantity may be correct, but the S/M distribution is not.

How to prevent: full SKUs in the documents.

10. Store both models in the same bin

Why it happens: both are white and two meters long.

Consequence: mix-up after opening the packages.

How to prevent: separate bins.

11. Label leftovers without a suffix

Why it happens: length seems to be the main parameter.

Consequence: an M leftover can end up in the S zone.

How to prevent: SKU + length.

12. Reordering "the same L1902"

Why it happens: a new employee doesn't know the history.

Consequence: ordering a different SKU.

How to prevent: master specification.

13. Treating size as secondary

Why it happens: the SKU seems sufficient.

Consequence: an internal S/M error isn't caught by the second check.

How to prevent: SKU + 80×27 or 100×33.

14. Assigning L1902S the frequency of a generic query

Why it happens: there are figures for "wholesale cornices".

Consequence: a fabricated SEO metric.

How to prevent: do not assign someone else's frequency to a SKU query.

15. Turn the article into a general guide to LED

Why it happens: M is associated with lighting.

Consequence: the purchasing intent of L1902S is lost.

How to prevent: light is considered only as a project factor for separating SKUs.

Main practical table for the hotel

Room Lighting scenario SKU Size Net area Slats Reserve
Number A no separate lighting node L1902S 80×27×2000 ___ ___ ___
Number B no separate lighting node L1902S 80×27×2000 ___ ___ ___
Corridor As per project L1902S 80×27×2000 ___ ___ ___
Lobby lighting assembly per project L1902M 100×33×2000 ___ ___ ___
Restaurant As per project ___ ___ ___ ___ ___

This table must exist before merging the budget.

Validation table of invalid records

Record Status
L1902S valid specific SKU
L1902M valid specific SKU
L1902 insufficient data to order
2 m track insufficient data
lighting track insufficient data for the specific purchase
standard L1902 household description, not an SKU

Practical scenario: 60 rooms and two public areas

Let's imagine a hypothetical property:

  • 40 type A rooms;

  • 20 type B rooms;

  • four standard corridors;

  • one lobby;

  • restaurant.

Let the architectural specification determine:

  • A → L1902S;

  • B → L1902S;

  • corridors → L1902S;

  • lobby → L1902M;

  • restaurant → L1902M in the area per the project.

Now it can be calculated separately.

Conditional number A

Net requirement L1902S:

10.8 m.

40 rooms:

432 m S.

Conditional number B

Net requirement:

12.2 m S.

20 rooms:

244 m S.

Numbers only:

676 m L1902S.

Lobby and restaurant

For example:

  • lobby — 84 m M;

  • restaurant — 46 m M.

Total:

130 m L1902M.

Summary family-total:

806 m.

But the purchase remains:

  • S = 676 m + corridors + own reserve;

  • M = 130 m + own reserve.

Not:

L1902 = 806 m.

Why even the net meterage S needs to be converted into parts

676 m / 2 = 338 strips — only a mathematical guideline.

If the numbers contain parts of 1150 mm:

  • two such parts do not fit into one strip.

Therefore, the actual order may be higher.

Conditional cutting of number A

Let the parts be S:

  • 1880;

  • 1880;

  • 980;

  • 980;

  • 720;

  • 720;

  • 620;

  • 620;

  • 600;

  • 600;

  • 600;

  • 600 mm.

Net length:

10.8 m.

Combination options:

  • 1880 → separate strip;

  • 1880 → separate;

  • 980 + 980 = 1960;

  • 720 + 620 + 600 = 1940;

  • 720 + 620 + 600 = 1940;

  • 600 + 600 = 1200.

This results in 6 initial strips before technological refinement.

That is:

6 × 2 = 12 m of source material

for 10.8 m of finished parts.

This is an example of why /2 Not enough.

Why the L1902M map should be separate

Suppose the lobby has M parts:

  • 1900;

  • How to work with the delivery queue

    For example:

    Phase 1

    • rooms 1–20 — S;

    • corridor 1–2 — S;

    • part of the lobby — M.

    Phase 2

    • rooms 21–40 — S;

    • restaurant — M.

    Phase 3

    • rooms 41–60 — S;

    • remaining public areas — according to the current map.

    Each queue reduces one shared master-balance.

    Why the reserve does not need to be duplicated in each queue

    If the object has:

    reserve_S = 12;

    reserve_M = 6,

    no need to automatically include these figures in every delivery.

    Otherwise, over three queues you get:

    36 S + 18 M reserve.

    Reserve — one manageable project value.

    How to restore the reserve after use

    Used:

    2 S planks.

    Remaining:

    Next decision:

    • restore to 12;

    • leave 10 as sufficient;

    • adjust the reserve based on actual statistics.

    But do not forget to update the figure.

    How to conduct the final inventory count

    After completing the queue, separately:

    Status L1902S L1902M
    whole ___ ___
    ISSUED ___ ___
    Remains statement statement
    Damaged ___ ___
    installation reserve ___ ___
    operational reserve ___ ___

    No line should be named:

    L1902 total stock

    without detail.

    Why the overall family total can only be stored as reference

    For example:

    L1902 family = 76 whole planks.

    But next to it, be sure to:

    • S = 58;

    • M = 18.

    Family-total is convenient for:

    • report;

    • warehouse volume;

    • total budget.

    Not for deciding the availability of a specific SKU.

    How to check physical completeness

    Question:

    how many standard numbers can be fully covered by the current S?

    If one number requires 6 S strips, and the warehouse has:

    S = 48;

    M = 30,

    Answer:

    8 numbers.

    Not:

    13 numbers by total L1902.

    Why this metric is stronger than the total remaining balance

    It shows:

    the real ability to continue installation.

    If S runs out, the surplus of M does not mask the problem.

    How to perform a check after the first ten numbers

    Compare:

    • the S norm per number;

    • actual S consumption;

    • returned whole S;

    • useful S remainders;

    • damage.

    M is not involved in this comparison if it is absent in typical numbers.

    This way, S consumption comes out clean.

    How to check the first public M-zone

    Separately:

    • M plan;

    • actual M;

    • assembly unit;

    • remnants;

    • reserve.

    Do not compare it with the S norm.

    Why a mass hotel is especially sensitive to a single SKU error

    If one room mistakenly received M instead of S, this is a local problem.

    If the BIM export turned the entire hotel into L1902, the error will repeat:

    • in 60 rooms;

    • in corridors;

    • lobby;

    • restaurant;

    • reserve.

    Therefore, master data is controlled before cutting geometry.

    How to store the design reason for assignment

    The table can contain:

    assignment_reason.

    For example:

    architecture_spec_R3.

    For M:

    light_node_LB-04 + architecture_R3.

    This is not required for every small project.

    But on a large project it helps to understand:

    why is there an M here?

    What to do if the reason for assignment no longer applies

    For example, the lighting unit has been cancelled.

    The row gets:

    REVIEW.

    Not:

    automatically S.

    After the design solution:

    • new SKU;

    • new revision;

    • new calculation.

    How to check the change via the delta

    Was:

    • M — 30 m.

    After the revision:

    • M — 18 m;

    • S — 8 m;

    • 4 m — without a cornice.

    Change:

    • M −12 m;

    • S +8 m;

    • total −4 m.

    Such a delta is much more informative:

    was 30, became 26.

    It preserves the product structure.

    Why you can't substitute using only linear meters

    If you remove 12 m of M and add 12 m of S:

    total footage is the same.

    But:

    • the number of planks may differ due to the structure of the parts;

    • remaining stock varies;

    • reserve varies.

    Therefore, after changing the SKU, a new parts map is built.

    How to maintain a repair fund after handover

    Pass:

    • whole L1902S;

    • whole L1902M;

    • individual stock;

    • product cards;

    • photos of end sections;

    • the latest specification;

    • room map.

    Not:

    L1902 cornice stock.

    Why operations needs to know S/M

    A year later, the cornice in the room is damaged.

    The service employee sees:

    room A → L1902S.

    In the lobby:

    zone L-02 → L1902M.

    He does not choose a profile by visual similarity.

    How to create a repair passport

    Example:

    L1902S
    Size: 80×27×2000
    Application: rooms per map R3
    Reserve: ___
    Storage location: ___
    URL: card S

    Separately:

    L1902M
    Size: 100×33×2000
    Application: M-zones per map R3
    Reserve: ___
    Storage location: ___
    URL: card M

    When order L1902S is better not to place

    Do not lock in a large batch if:

    • suffixes are lost in the estimate;

    • it is unknown where S is and where M is;

    • architecture and electrical contradict;

    • no active revision;

    • supplier sent general L1902;

    • reserve calculated as general.

    You can request a price.

    But not the final delivery.

    Final project readiness matrix

    Check Status
    L1902S confirmed Yes/No
    80×27×2000 confirmed Yes/No
    L1902M separated Yes/No
    100×33×2000 confirmed Yes/No
    SKU in BIM complete Yes/No
    Excel does not remove S/M Yes/No
    L1902 rows without suffix are missing Yes/No
    rooms classified Yes/No
    architecture/lighting collisions resolved Yes/No
    S footage separate Yes/No
    M footage separate Yes/No
    S parts map ready Yes/No
    M parts map ready Yes/No
    number of S slats known Yes/No
    number of M strips is known Yes/No
    reserve_S is known Yes/No
    reserve_M is known Yes/No
    the CP has two lines Yes/No
    storage cells are separate Yes/No
    remaining stock is marked S/M Yes/No
    Reorder format approved Yes/No

    Three final diagnostic tests

    Test 1 — remove the suffix

    In the file copy, replace:

    L1902S → L1902.

    The system should output:

    ERROR/UNKNOWN.

    If it calmly continues the calculation — the protection is weak.

    Test 2 — change S to M

    In one standard room, replace:

    S → M.

    The system should show:

    • a different size;

    • another master SKU;

    • need for design verification.

    If only a letter in the text changes without other consequences — the model is too coarse.

    Test 3 — add a general reserve

    Try to record:

    reserve L1902 = 20.

    The system should require:

    • how many S;

    • how many M.

    How to perform a reverse audit of the final order

    Suppose the final request:

    S = 340 pcs.

    M = 92 pcs.

    It must be possible to restore:

    S

    • 60 numbers;

    • corridors;

    • other S-zones;

    • cutting;

    • reserve_S.

    M

    • lobby;

    • restaurant;

    • other M-zones;

    • cutting;

    • reserve_M.

    If 432 exists only as:

    L1902 total,

    the specification is insufficient.

    Why the final order must be reproducible

    Another employee must take:

    • an up-to-date floor plan;

    • revision;

    • parts lists;

    • Cutting list

    and obtain close S and M figures.

    If the distribution exists only "in the architect's head" or "in the procurement officer's memory," a large purchase is not ready.

    Diagnostic scenario: BIM stores the family but loses the SKU

    The model may contain two valid elements:

    • family = L1902, sku = L1902S;

    • family = L1902, sku = L1902M.

    On screen, everything looks correct.

    The problem appears during export if the export template takes only the field family.

    Two rows appear in Excel:

    L1902;

    L1902.

    If you then create a pivot table, they are merged.

    To catch this before the actual order, you need a test:

  1. select one room S;

  2. one room M;

  3. export;

  4. check the full SKU;

  5. compare with the source model.

If the suffixes are lost, the entire export is considered unsuitable for purchasing.

Why restoring S/M after export is dangerous

You can write a formula:

if lighting scenario = yes → M, otherwise S.

But this is already a new project rule that might not have existed.

For example:

  • in the lighting zone, the project uses a different profile;

  • in a room without lighting, the architecture chose M for geometric reasons;

  • part of the route has a mixed scheme.

Therefore, a lost SKU cannot be restored by supply logic.

The original field must be restored.

Diagnostic scenario: Excel removes the last letter

In the source:

L1902S.

Cleaning function:

the first five characters or removal of trailing letter suffixes.

Result:

L1902.

To protect against this, control is useful:

if the source SKU starts with L1902 and after conversion the string length decreased — CHECK.

This is a simple technical test that prevents a real purchasing error.

Diagnostic scenario: the string L1902 has already arrived from the old archive

It is not always possible to fix the source.

Then the string receives the status:

UNRESOLVED.

No S/M quantity is assigned to it until confirmation.

Working table:

Raw Room Revision Possible SKU Status
L1902 Number 214 R1 S/M unknown unresolved
L1902 Lobby R1 S/M unknown unresolved

Next, the following are raised:

  • old drawings;

  • specification;

  • invoice;

  • photo of the packaging;

  • correspondence;

  • BIM model.

Only after confirmation:

resolved_to = L1902S

Or:

resolved_to = L1902M.

Why can't unknown strings be distributed proportionally

Let's imagine:

known S = 300 m;

known M = 100 m;

unresolved L1902 = 80 m.

Bad approach:

let's distribute 60 m to S and 20 m to M in a 3:1 ratio.

This is mathematically elegant.

Design-wise — meaningless.

The unknown 80 m refer to specific rooms, not to a statistical proportion.

Verifying the first order as a physical reference

After the first delivery, it is useful to create two reference sets.

S-reference:

  • factory label L1902S;

  • photo of the end;

  • size 80×27×2000;

  • control sample;

  • invoice;

  • batch number.

M-reference:

  • label L1902M;

  • photo of the end;

  • 100×33×2000;

  • control sample;

  • account.

They are not needed just for a collection of samples.

The reference links the digital specification to the physical product.

What to do if the packaging arrived without a readable label

Do not determine the profile "by appearance from a distance."

Procedure:

  1. set aside the disputed pack;

  2. compare the end section with the reference;

  3. check the geometry;

  4. check the delivery note;

  5. obtain confirmation from the supplier if necessary.

Until the SKU is confirmed:

quarantine.

Do not release for installation.

How to compare two commercial offers

Supplier A:

S — 340 pcs.;
M — 92 pcs.

Supplier B:

L1902 — 432 pcs.

Even if offer B is cheaper, comparison is premature.

It is necessary to request from B:

  • S/M distribution;

  • sizes;

  • the price of each item.

Only after that can you compare:

  • cost;

  • deadline;

  • delivery;

  • reorder terms.

Why the family-total price can hide a substitution

For example:

  • S is cheaper than M;

  • the supplier accidentally increased S and decreased M.

The total amount may look more favorable.

But the object will receive less M.

Therefore, commercial optimization should not occur before verifying the product matrix.

How to monitor S↔M changes via delta

Revision R2:

  • S = 340;

  • M = 92.

Revision R3:

  • S = 352;

  • M = 80.

Delta:

  • S +12;

  • M −12.

At first glance, the family total has not changed.

But the project changed significantly.

Need to know:

  • which rooms changed SKU;

  • why;

  • whether the new node has been checked.

This is another argument against a single metric L1902 total.

How to preserve the source of each row

In the master file, the following are useful:

  • room_id;

  • source_document;

  • source_revision;

  • sku;

  • length;

  • qty;

  • status.

Example:

room_214 / architecture_R3 / L1902S / 10.8 m / 6 pcs. / approved.

Then, in a dispute, you can return to the source.

How to verify mass scaling of a standard room

Standard room A confirmed:

6 strips S.

Number of such rooms:

Base requirement:

240 S.

But before multiplication, the following are checked:

  • mirrored rooms;

  • accessible environment rooms;

  • corner rooms;

  • rooms with a different ceiling node.

If two rooms differ, they become a separate type.

This way, an error in one geometry does not multiply across 40.

How to check that M was not included in the standard multiplier S

The types table must have a field:

sku.

Not only:

qty_per_room.

Otherwise the template:

6 strips ×40

may accidentally take M after copying the row.

Why the reserve must also have a source

For example:

reserve_S = 12.

Good to know:

  • 6 — installation;

  • 4 — operational;

  • 2 — queue change.

For M:

its own logic.

This is better than one percent on family-total.

What to do if a lot of M remains after canceling the light zone

Do not transfer the remainder to S-reserve.

Options:

  • use in other approved M-zones;

  • reduce the next purchase of M;

  • keep as M-reserve;

  • approve the project change.

Warehouse excess of M does not reduce the need for S.

How to verify that the repair fund is real

In the passport:

reserve_S = 8;
reserve_M = 4.

The following must physically exist:

  • eight whole S;

  • four point M.

If there are 12 unknown "L1902":

repair stock is not confirmed.

When a project can be considered ready for wholesale purchasing

Not when there is a total area.

But when you can answer without guessing:

  • where S;

  • where M;

  • how many parts of each;

  • how many planks of each;

  • what reserve for each;

  • where to store;

  • how to reorder.

This is the final data readiness.

Final role check before payment

It is useful to give the same specification to three project participants and check whether they understand it the same way.

The architect must confirm that the room and the design node are actually linked to L1902S or L1902M, and not to the generic L1902 family.

The procurement specialist must see two separate SKUs, separate quantities, and separate reserves. They must not have to reconstruct S/M from comments like "standard" and "lighting".

The warehouse must understand in advance that after delivery there will be two different bins, two reference samples, and two sets of stock.

If all three roles read the document the same way, the likelihood of picking errors drops sharply.

How to check a document for self-sufficiency

Let's imagine that the person who compiled the table is unavailable.

A new employee receives only:

  • specification;

  • CP;

  • floor plan;

  • latest stock levels.

They must be able to answer:

  • how many S are ordered;

  • how many M are ordered;

  • where each is used;

  • what reserve is available;

  • which SKU is needed for a reorder.

If this is impossible without calling the author, the document depends too much on informal knowledge.

Why the comment "without light" does not replace L1902S

Such a label may be understandable today.

A year later:

  • the project will change;

  • a different curtain rail will appear;

  • a new employee does not know the context.

Therefore, a comment can supplement the SKU, but not replace it.

Correct line:

L1902S / 80×27×2000 / number A / architectural specification R3.

Not:

standard cornice without lighting.

Why the comment "for lighting" does not replace L1902M

For the same reason.

Other profiles for lighting solutions may also exist at the site.

Therefore, the purpose is an attribute.

SKU — identifier.

It is this separation that makes the specification resilient to staff turnover and subsequent repair purchases.

Final procurement chain L1902S

Room

→ approved project scenario

→ exact L1902S or L1902M

→ full SKU in BIM/Excel

→ separate finished length

→ separate parts list

→ separate cutting

→ 2000 mm strips for each SKU

→ reserve_S / reserve_M

→ two request lines

→ two quotation lines

→ receipt by full SKU

→ separate warehouse bins

→ labeled stock

→ issue by zones

→ changes only via a new revision

→ reorder L1902S or L1902M without generic L1902

The main question of the article is not:

which of the two cornices is better?

And not:

how to create hidden lighting?

But:

how can a hotel property keep two different HI WOOD items — L1902S and L1902M — as two separate SKUs from the project room through reorder, so that the reduction L1902 does not destroy the purpose, quantity, reserve, and warehouse accounting?

Once this issue is resolved, purchasing stops depending on guesswork. The room, corridor, lobby, or restaurant receives exactly the SKU approved by the project; stock and reserve are not mixed; and a new employee a year later can reorder L1902S without saying “that L1902 cornice, the one without the light.”

Final check of the repair stock

Before handing the hotel over to operations, the reserve must be physically reconciled with the documents. If the passport shows L1902S — 8 pcs. и L1902M — 4 pcs., then the warehouse must contain exactly eight whole S and four whole M, not twelve unnamed white cornices.

Remainders are also counted separately. Having five meters of M does not reduce the need for S when renovating a standard room. Similarly, a stock of S does not cover a lighting unit for which the project specifies M.

This final check completes the entire chain: the suffix is preserved not only until installation, but also after the project is handed over. This is exactly what makes it possible, several years later, to restore a damaged section by the exact SKU, rather than selecting a “similar L1902” from memory or by appearance.

The last readiness criterion is simple: not a single working document used for ordering, acceptance, warehousing, or repair should contain an unlabeled line L1902. If it is still there, the S/M suffixes may be lost again.

Such control preserves the product identity of the two cornices throughout the entire project.