Order-line allocation
Phased Order Allocation Checker
Split an order that is already defined across phases or buildings. This is not a demand calculator or a production schedule: it checks whether your allocations account for each approved quantity.
Enter order lines and approved totals → allocate quantities to phases → review unallocated or over-allocated counts. No release is approved.
Enter your records
Required inputs must be complete. Enter 0 only when zero is deliberate; missing values remain unresolved. Use non-confidential references only.
Record fields
- Order line reference
- Specification revision
- Count unit (e.g. pieces, sets)
- Approved total for this order line
- Phase or building (unique per line)
- Quantity allocated
Reviewable result
Enter records to begin.
Worksheet processing stays in this page. Inputs are not uploaded or stored, and reloading clears them. Page analytics are disabled here. Contact links and the quote form are separate actions; review the result before choosing to share it.
Worked example
A project buyer splits two approved order lines across three buildings and checks that each approved total is fully allocated.
Example figures are invented for illustration. They are not product data, prices or a quotation.
Example inputs
| Order line reference | Specification revision | Count unit (e.g. pieces, sets) | Approved total for this order line | Phase or building (unique per line) | Quantity allocated |
|---|---|---|---|---|---|
| Line V1 | Rev B | pieces | 120 | Building 1 | 40 |
| Line V1 | Rev B | pieces | 120 | Building 2 | 40 |
| Line V1 | Rev B | pieces | 120 | Building 3 | 30 |
| Line S1 | Rev A | sets | 60 | Building 1 | 30 |
| Line S1 | Rev A | sets | 60 | Building 2 | 30 |
Result from the worksheet
Phased Order Allocation Checker LOCAL WORKSHEET — entered data only Line V1 | Rev B | pieces: approved 120; allocated 110; unallocated 10. Line S1 | Rev A | sets: approved 60; allocated 60; fully allocated by count. No product, inspection, installation, stock or delivery approval is generated.
How to read it
Line V1 Rev B has 40 + 40 + 30 = 110 pieces allocated against an approved 120, so 10 are unallocated. Line S1 Rev A has 30 + 30 = 60 sets and is fully allocated by count. The tool raised no review items, so the buyer must notice the 10 open pieces in the line text and decide which building receives them.
Grouping is exact
Lines are grouped by order line, specification revision and unit, with upper and lower case kept distinct. Allocations are added up within each group and compared with its approved total, which shows the quantity as unallocated, fully allocated or over-allocated. Different revisions are never merged to make a total look complete.
Conflicts stop the calculation
Repeat the same approved total on every line of a group. Different totals for one group are rejected rather than averaged or replaced, and so is a phase that appears twice in the same group. Correct the source allocation first.
Allocated is not ready to ship
A complete split says nothing about stock, production readiness, destination or delivery dates. Keep phase references tied to the approved project schedule and confirm commercial changes separately. Only whole units are accepted, not area or volume.
Order-line allocation questions
Will lines with different specification revisions be added together?
No. The revision is part of the exact grouping, so each revision is checked on its own.
What if two lines give different approved totals?
The calculation stops until the approved total is corrected.
Can the same phase name appear on another order line?
Yes. Duplicates are only checked within one line, revision and unit.
Does a full allocation mean the goods are ready?
No. Readiness and delivery commitments are outside this calculation.
Can I allocate square meters?
No. The worksheet allocates whole units only.
Discuss the reviewed requirement
Use the result to identify questions for WNS Global. Offered products, specifications and commercial conditions still require separate confirmation.