Raw materials
Stock at Plot 27, Al Quoz 4 · valued at average cost · reserved = already promised to a job card or order
12 mm clear glass: 9 sheets left, all reserved — SO-MG-26-025 needs about 14.
PR-MG-26-0031 for 40 sheets (Gulf Float Glass Trading, AED 22,600) has the Metal Division Partner's approval and is waiting for yours. Approved today, it arrives Sun 4 Oct.
Stock value
AED84,725
16 items · glass 58% of value
Below reorder level
2
12 mm clear · 12 mm low-iron
Remnant rack
31.4 m²
23 pieces · used first by the cutting plan
On order
AED26,280
LPO-MG-26-0018 3,680 · PR-0031 22,600 pending
Stock list
As at Fri 2 Oct, 10:30 AM · AED excl. VATExport
| Item | On hand | Reserved | Reorder at | Avg cost | Value (AED) | Status |
|---|---|---|---|---|---|---|
| Glass & mirror · full sheets | ||||||
| Clear float glass 6 mmGL-CL-06 · rack A1 | 42 sheets | 6 | 11,970 | OK | ||
| Clear float glass 8 mmGL-CL-08 · rack A2 | 18 sheets | 4 | 6,840 | OK | ||
| Clear float glass 10 mmGL-CL-10 · rack A3 | 26 sheets | 0 | 12,220 | OK | ||
| Clear float glass 12 mmGL-CL-12 · rack A4 · SO-MG-26-025 short by ≈ 5 | 9 sheets | 9 | 5,085 | Low · PR-0031 | ||
| Extra-clear (low-iron) 12 mmGL-LI-12 · rack A5 · premium shower screens | 4 sheets | 0 | 3,280 | Low | ||
| Bronze tinted 6 mmGL-BZ-06 · rack B1 | 12 sheets | 0 | 3,720 | OK | ||
| Mirror 4 mm silverMR-SL-04 · rack B2 | 30 sheets | 0 | 6,300 | OK | ||
| Aluminium & steel · 6 m lengths | ||||||
| Aluminium profile Series 45 slidingAL-S45 · mill finish · +40 bars on LPO-MG-26-0018 | 86 bars | 28 | 7,912 | OK | ||
| Aluminium profile Series 50 casementAL-S50 · mill finish | 54 bars | 0 | 5,616 | OK | ||
| Aluminium U-channel 12 mmAL-UC-12 · anodised | 120 bars | 24 | 4,560 | OK | ||
| SS 304 tube 50.8 mmSS-TB-51 · handrails | 24 lengths | 6 | 3,960 | OK | ||
| Hardware & consumables | ||||||
| Patch fitting sets (SS)HW-PF · cage C1 | 18 sets | 6 | 4,680 | OK | ||
| Floor springs EN3HW-FS-EN3 · 6 reserved for SO-MG-26-025 | 7 pcs | 6 | 1,680 | Watch · 1 free | ||
| Shower hinges glass-to-wallHW-SH-GW · cage C2 | 64 pcs | 4 | 3,072 | OK | ||
| Structural silicone black 300 mlCN-SIL-BK · shelf D1 | 140 tubes | 12 | 1,960 | OK | ||
| EPDM gasketCN-EPDM · shelf D2 | 22 rolls | 3 | 1,870 | OK | ||
| Total · 16 items | 84,725 | |||||
Reorder suggestions
From reorder levels, reservations and the next 2 weeks' plan-
Clear float glass 12 mm · 40 sheetsAED 22,600Waiting for you
-
Extra-clear (low-iron) 12 mm · 10 sheetsAED 8,200Create PR
-
Floor springs EN3 · 6 pcsAED 1,440Create PR
-
Edging wheels & polishing padsAED 3,480Pending
- Aluminium Series 45 · 40 barsAED 3,680On order
12 mm glass runs out every 2 weeks
The factory used 31 sheets of 12 mm in September — mostly partitions and doors for LHP Technical Services. Raising the reorder level from 20 to 30 sheets avoids rush orders like this one.
Value by category
AED 84,725 at average cost58%glass
Glass & mirror49,415
Metals22,048
Hardware9,432
Consumables3,830
Remnant rack
Off-cuts ≥ 0.25 m², labelled and reusedR-01 · 6 mm clear & tinted8 pcs · 9.6 m²
R-02 · 8 mm and 10 mm6 pcs · 8.2 m²
R-03 · 12 mm clear7 pcs · 11.8 m²
R-04 · Mirror2 pcs · 1.8 m²
Total23 pcs · 31.4 m²
R-03 got 1.8 m² from JC-26-0451 on 29 Sep. The cutting optimiser fits small panels into remnants before opening a new sheet — that is how September's yield reached 88%.
Clear float glass 12 mm · who needs it
9 on hand · 40 on PR-MG-26-0031 · ≈ 1.8 sheets a working day over the next 2 weeks| Needed for | Customer | Cut date | Sheets | Covered by |
|---|---|---|---|---|
| SO-MG-26-025 · partitions & doors 86 m²TS-26-014 Bay View Tower · PR-TS-26-0142 | LHP TS | Sat 3 – Mon 5 Oct | 14 | 9 in stock + 5 from PR-0031 |
| Q-MG-26-035 · 9 frameless partitionsQuote being priced · order expected by 5 Oct | Cedar Interiors | Tue 6 Oct | 5 | PR-0031 |
| SO-MG-26-024 · staircase railingOn hold · 30% advance due | Vista Builders | Wed 14 Oct | 3 | PR-0031 |
| Need in the next 2 weeks | 22 | 27 sheets left for stock |