Items / LED-0022
LED Bulb 12W Pro LED-0022 · Lighting · BrightLine Lighting
On hand (EA)187MAIN 187
Value (FIFO)8,292.27avg 44.34
ClassBX / FCV 0.35
Turnover3.2xlast issue 3 days ago
Days of cover113lead time 10d
Demand and forecast
actual forecast 90% prediction interval
No forecast run yet for this item. Run forecasts. Policy numbers use trailing 12-month demand.
Policy numbers explained
| Metric | Formula | Substituted | Result |
|---|---|---|---|
| Daily demand d | monthly mean / 30.4375 | 50.50 / 30.4375 | 1.659 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 17.72 / 5.517 | 3.211 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.950) | 1.645 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.645 * sqrt(9.6 * 3.211^2 + 1.659^2 * 2.2^2) | 17.4 |
| Reorder point | d * LT + safety stock | 1.659 * 9.6 + 17.4 | 33.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 33.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 606/yr, S = 45.00, h = 20%, price = 45.01 | 77.8 |
| Inventory position | on hand + on order | 187 + 0 | 187 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 45.01 | 78 | 27,958 | yes (chosen if cheapest) |
| 400 | 43.21 | 400 | 27,964 | yes |
| 800 | 41.41 | 800 | 28,424 | yes |
MOQ 200, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 8, 2026 | 187 / 200 | 44.34 | 8,292.27 |
Movement ledger 112 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 13, 2026 | issue | SO-261013-750 | MAIN | 9 | 44.34 | -399.09 | 187 | 8,292.27 | Oct. 8, 2026: 9 @ 44.34 |
| Oct. 11, 2026 | issue | SO-261011-938 | MAIN | 4 | 44.34 | -177.37 | 196 | 8,691.37 | Oct. 8, 2026: 4 @ 44.34 |
| Oct. 8, 2026 | receipt | PO-001858 | MAIN | 200 | 44.34 | 8,868.74 | 200 | 8,868.74 | |
| Oct. 4, 2026 | issue | SO-261004-628 | MAIN | 29 | 43.46 | -1,260.45 | 0 | 0.00 | May 20, 2026: 24 @ 43.46; June 27, 2026: 5 @ 43.46 |
| Sept. 30, 2026 | issue | SO-260930-936 | MAIN | 36 | 43.46 | -1,564.70 | 29 | 1,260.45 | May 20, 2026: 36 @ 43.46 |
| Sept. 8, 2026 | issue | SO-260908-465 | MAIN | 7 | 43.46 | -304.25 | 65 | 2,825.15 | May 20, 2026: 7 @ 43.46 |
| Aug. 29, 2026 | issue | SO-260829-600 | MAIN | 15 | 43.46 | -651.96 | 72 | 3,129.39 | May 20, 2026: 15 @ 43.46 |
| Aug. 27, 2026 | issue | SO-260827-551 | MAIN | 3 | 43.46 | -130.39 | 87 | 3,781.35 | May 20, 2026: 3 @ 43.46 |
| Aug. 25, 2026 | issue | SO-260825-647 | MAIN | 1 | 43.46 | -43.46 | 90 | 3,911.74 | May 20, 2026: 1 @ 43.46 |
| Aug. 24, 2026 | issue | SO-260824-465 | MAIN | 2 | 43.46 | -86.93 | 91 | 3,955.21 | May 20, 2026: 2 @ 43.46 |
| Aug. 9, 2026 | issue | SO-260809-606 | MAIN | 1 | 43.46 | -43.46 | 93 | 4,042.13 | May 20, 2026: 1 @ 43.46 |
| Aug. 5, 2026 | issue | SO-260805-741 | MAIN | 8 | 43.46 | -347.71 | 94 | 4,085.60 | May 20, 2026: 8 @ 43.46 |
| Aug. 1, 2026 | issue | SO-260801-584 | MAIN | 9 | 43.46 | -391.17 | 102 | 4,433.31 | May 20, 2026: 9 @ 43.46 |
| July 30, 2026 | issue | SO-260730-699 | MAIN | 22 | 43.46 | -956.20 | 111 | 4,824.48 | May 20, 2026: 22 @ 43.46 |
| July 29, 2026 | issue | SO-260729-718 | MAIN | 17 | 43.46 | -738.88 | 133 | 5,780.69 | May 20, 2026: 17 @ 43.46 |
| July 16, 2026 | issue | SO-260716-960 | MAIN | 6 | 43.46 | -260.78 | 150 | 6,519.57 | May 20, 2026: 6 @ 43.46 |
| July 9, 2026 | issue | SO-260709-568 | MAIN | 1 | 43.46 | -43.46 | 156 | 6,780.35 | May 20, 2026: 1 @ 43.46 |
| June 27, 2026 | return | RMA | MAIN | 5 | 43.46 | 217.32 | 157 | 6,823.82 | |
| June 23, 2026 | issue | SO-260623-877 | MAIN | 10 | 43.46 | -434.64 | 152 | 6,606.50 | May 20, 2026: 10 @ 43.46 |
| June 14, 2026 | issue | SO-260614-877 | MAIN | 17 | 43.46 | -738.88 | 162 | 7,041.14 | May 20, 2026: 17 @ 43.46 |
| June 5, 2026 | issue | SO-260605-178 | MAIN | 1 | 43.46 | -43.46 | 179 | 7,780.02 | May 20, 2026: 1 @ 43.46 |
| June 1, 2026 | issue | SO-260601-879 | MAIN | 3 | 43.46 | -130.39 | 180 | 7,823.48 | May 20, 2026: 3 @ 43.46 |
| May 24, 2026 | issue | SO-260524-712 | MAIN | 18 | 43.44 | -782.00 | 183 | 7,953.88 | Jan. 24, 2026: 1 @ 43.12; May 20, 2026: 17 @ 43.46 |
| May 20, 2026 | receipt | PO-001508 | MAIN | 200 | 43.46 | 8,692.76 | 201 | 8,735.88 | |
| May 11, 2026 | issue | SO-260511-476 | MAIN | 48 | 43.12 | -2,069.72 | 1 | 43.12 | Jan. 24, 2026: 48 @ 43.12 |
| April 28, 2026 | issue | SO-260428-618 | MAIN | 14 | 43.12 | -603.67 | 49 | 2,112.84 | Jan. 24, 2026: 14 @ 43.12 |
| April 15, 2026 | issue | SO-260415-860 | MAIN | 13 | 43.12 | -560.55 | 63 | 2,716.50 | Jan. 24, 2026: 13 @ 43.12 |
| April 7, 2026 | issue | SO-260407-989 | MAIN | 7 | 43.12 | -301.83 | 76 | 3,277.05 | Jan. 24, 2026: 7 @ 43.12 |
| March 21, 2026 | issue | SO-260321-707 | MAIN | 8 | 43.12 | -344.95 | 83 | 3,578.89 | Jan. 24, 2026: 8 @ 43.12 |
| March 11, 2026 | issue | SO-260311-600 | MAIN | 12 | 43.12 | -517.43 | 91 | 3,923.84 | Jan. 24, 2026: 12 @ 43.12 |
| March 6, 2026 | issue | SO-260306-646 | MAIN | 1 | 43.12 | -43.12 | 103 | 4,441.27 | Jan. 24, 2026: 1 @ 43.12 |
| March 2, 2026 | issue | SO-260302-999 | MAIN | 8 | 43.12 | -344.95 | 104 | 4,484.39 | Jan. 24, 2026: 8 @ 43.12 |
| March 2, 2026 | issue | SO-260302-999 | EAST | 28 | 43.12 | -1,207.33 | 112 | 4,829.34 | Jan. 24, 2026: 28 @ 43.12 |
| Feb. 27, 2026 | issue | SO-260227-295 | MAIN | 4 | 43.12 | -172.48 | 140 | 6,036.67 | Jan. 24, 2026: 4 @ 43.12 |
| Feb. 19, 2026 | issue | SO-260219-811 | EAST | 16 | 43.12 | -689.91 | 144 | 6,209.15 | Jan. 24, 2026: 16 @ 43.12 |
| Feb. 13, 2026 | issue | SO-260213-709 | MAIN | 9 | 43.12 | -388.07 | 160 | 6,899.06 | Jan. 24, 2026: 9 @ 43.12 |
| Feb. 11, 2026 | issue | SO-260211-313 | EAST | 14 | 43.12 | -603.67 | 169 | 7,287.13 | Jan. 24, 2026: 14 @ 43.12 |
| Feb. 4, 2026 | issue | SO-260204-555 | EAST | 7 | 43.12 | -301.83 | 183 | 7,890.80 | Jan. 24, 2026: 7 @ 43.12 |
| Jan. 24, 2026 | issue | SO-260124-823 | MAIN | 12 | 43.19 | -518.28 | 190 | 8,192.63 | Oct. 14, 2025: 2 @ 43.54; Jan. 24, 2026: 10 @ 43.12 |
| Jan. 24, 2026 | transfer | TRF | MAIN → EAST | 65 | warehouse transfer, no cost effect | ||||
| Jan. 24, 2026 | receipt | PO-001173 | MAIN | 200 | 43.12 | 8,623.82 | 202 | 8,710.90 | |
| Jan. 22, 2026 | issue | SO-260122-502 | MAIN | 1 | 43.54 | -43.54 | 2 | 87.08 | Oct. 14, 2025: 1 @ 43.54 |
| Jan. 16, 2026 | issue | SO-260116-380 | MAIN | 38 | 43.54 | -1,654.60 | 3 | 130.63 | Oct. 14, 2025: 38 @ 43.54 |
| Jan. 9, 2026 | issue | SO-260109-252 | MAIN | 6 | 43.54 | -261.25 | 41 | 1,785.23 | Oct. 14, 2025: 6 @ 43.54 |
| Jan. 4, 2026 | issue | SO-260104-325 | MAIN | 2 | 43.54 | -87.08 | 47 | 2,046.48 | Oct. 14, 2025: 2 @ 43.54 |
| Dec. 23, 2025 | issue | SO-251223-107 | MAIN | 48 | 43.54 | -2,090.03 | 49 | 2,133.57 | Oct. 14, 2025: 48 @ 43.54 |
| Dec. 5, 2025 | issue | SO-251205-120 | MAIN | 23 | 43.54 | -1,001.47 | 97 | 4,223.59 | Oct. 14, 2025: 23 @ 43.54 |
| Dec. 3, 2025 | issue | SO-251203-357 | MAIN | 25 | 43.54 | -1,088.56 | 120 | 5,225.06 | Oct. 14, 2025: 25 @ 43.54 |
| Nov. 29, 2025 | issue | SO-251129-643 | MAIN | 18 | 43.54 | -783.76 | 145 | 6,313.62 | Oct. 14, 2025: 18 @ 43.54 |
| Nov. 27, 2025 | issue | SO-251127-636 | MAIN | 1 | 43.54 | -43.54 | 163 | 7,097.38 | Oct. 14, 2025: 1 @ 43.54 |
| Nov. 26, 2025 | issue | SO-251126-706 | MAIN | 7 | 43.54 | -304.80 | 164 | 7,140.92 | Oct. 14, 2025: 7 @ 43.54 |
| Nov. 19, 2025 | issue | SO-251119-824 | MAIN | 22 | 43.54 | -957.93 | 171 | 7,445.72 | Oct. 14, 2025: 22 @ 43.54 |
| Nov. 18, 2025 | issue | SO-251118-238 | MAIN | 2 | 43.54 | -87.08 | 193 | 8,403.64 | Oct. 14, 2025: 2 @ 43.54 |
| Nov. 12, 2025 | issue | SO-251112-544 | MAIN | 5 | 43.54 | -217.71 | 195 | 8,490.73 | Oct. 14, 2025: 5 @ 43.54 |
| Oct. 14, 2025 | receipt | PO-000918 | MAIN | 200 | 43.54 | 8,708.44 | 200 | 8,708.44 | |
| Oct. 7, 2025 | issue | SO-251007-691 | MAIN | 35 | 41.20 | -1,442.08 | 0 | 0.00 | May 4, 2025: 35 @ 41.20 |
| Sept. 29, 2025 | issue | SO-250929-508 | MAIN | 4 | 41.20 | -164.81 | 35 | 1,442.08 | May 4, 2025: 4 @ 41.20 |
| Sept. 28, 2025 | issue | SO-250928-442 | MAIN | 13 | 41.20 | -535.63 | 39 | 1,606.89 | May 4, 2025: 13 @ 41.20 |
| Sept. 26, 2025 | issue | SO-250926-781 | MAIN | 4 | 41.20 | -164.81 | 52 | 2,142.52 | May 4, 2025: 4 @ 41.20 |
| Sept. 12, 2025 | issue | SO-250912-179 | MAIN | 2 | 41.20 | -82.40 | 56 | 2,307.33 | May 4, 2025: 2 @ 41.20 |
| Sept. 4, 2025 | issue | SO-250904-203 | MAIN | 21 | 41.20 | -865.25 | 58 | 2,389.74 | May 4, 2025: 21 @ 41.20 |
| Sept. 2, 2025 | issue | SO-250902-586 | MAIN | 1 | 41.20 | -41.20 | 79 | 3,254.99 | May 4, 2025: 1 @ 41.20 |
| Aug. 26, 2025 | issue | SO-250826-252 | MAIN | 34 | 41.20 | -1,400.88 | 80 | 3,296.19 | May 4, 2025: 34 @ 41.20 |
| Aug. 13, 2025 | issue | SO-250813-240 | MAIN | 1 | 41.20 | -41.20 | 114 | 4,697.07 | May 4, 2025: 1 @ 41.20 |
| July 30, 2025 | issue | SO-250730-638 | MAIN | 1 | 41.20 | -41.20 | 115 | 4,738.28 | May 4, 2025: 1 @ 41.20 |
| July 14, 2025 | issue | SO-250714-673 | MAIN | 34 | 41.20 | -1,400.88 | 116 | 4,779.48 | May 4, 2025: 34 @ 41.20 |
| July 1, 2025 | issue | SO-250701-899 | MAIN | 2 | 41.20 | -82.40 | 150 | 6,180.36 | May 4, 2025: 2 @ 41.20 |
| June 18, 2025 | issue | SO-250618-343 | MAIN | 4 | 41.20 | -164.81 | 152 | 6,262.76 | May 4, 2025: 4 @ 41.20 |
| June 17, 2025 | issue | SO-250617-598 | MAIN | 26 | 41.20 | -1,071.26 | 156 | 6,427.57 | May 4, 2025: 26 @ 41.20 |
| June 7, 2025 | issue | SO-250607-635 | MAIN | 2 | 41.20 | -82.40 | 182 | 7,498.84 | May 4, 2025: 2 @ 41.20 |
| May 28, 2025 | issue | SO-250528-986 | MAIN | 2 | 41.20 | -82.40 | 184 | 7,581.24 | May 4, 2025: 2 @ 41.20 |
| May 7, 2025 | issue | SO-250507-293 | MAIN | 1 | 41.20 | -41.20 | 186 | 7,663.65 | May 4, 2025: 1 @ 41.20 |
| May 5, 2025 | issue | SO-250505-937 | MAIN | 27 | 40.89 | -1,104.11 | 187 | 7,704.85 | Jan. 5, 2025: 14 @ 40.61; May 4, 2025: 13 @ 41.20 |
| May 4, 2025 | receipt | PO-000509 | MAIN | 200 | 41.20 | 8,240.48 | 214 | 8,808.96 | |
| April 25, 2025 | issue | SO-250425-490 | MAIN | 17 | 40.61 | -690.30 | 14 | 568.48 | Jan. 5, 2025: 17 @ 40.61 |
| April 21, 2025 | issue | SO-250421-559 | MAIN | 6 | 40.61 | -243.63 | 31 | 1,258.77 | Jan. 5, 2025: 6 @ 40.61 |
| April 14, 2025 | issue | SO-250414-675 | MAIN | 2 | 40.61 | -81.21 | 37 | 1,502.41 | Jan. 5, 2025: 2 @ 40.61 |
| April 11, 2025 | issue | SO-250411-476 | MAIN | 1 | 40.61 | -40.61 | 39 | 1,583.62 | Jan. 5, 2025: 1 @ 40.61 |
| April 8, 2025 | issue | SO-250408-929 | MAIN | 14 | 40.61 | -568.48 | 40 | 1,624.22 | Jan. 5, 2025: 14 @ 40.61 |
| April 3, 2025 | issue | SO-250403-205 | MAIN | 3 | 40.61 | -121.82 | 54 | 2,192.70 | Jan. 5, 2025: 3 @ 40.61 |
| March 25, 2025 | issue | SO-250325-371 | MAIN | 2 | 40.61 | -81.21 | 57 | 2,314.52 | Jan. 5, 2025: 2 @ 40.61 |
| March 17, 2025 | issue | SO-250317-944 | MAIN | 28 | 40.61 | -1,136.96 | 59 | 2,395.73 | Jan. 5, 2025: 28 @ 40.61 |
| March 17, 2025 | issue | SO-250317-944 | EAST | 36 | 40.61 | -1,461.80 | 87 | 3,532.69 | Jan. 5, 2025: 36 @ 40.61 |
| Feb. 26, 2025 | issue | SO-250226-896 | MAIN | 7 | 40.61 | -284.24 | 123 | 4,994.49 | Jan. 5, 2025: 7 @ 40.61 |
| Feb. 18, 2025 | issue | SO-250218-124 | EAST | 20 | 40.61 | -812.11 | 130 | 5,278.73 | Jan. 5, 2025: 20 @ 40.61 |
| Feb. 6, 2025 | issue | SO-250206-374 | MAIN | 16 | 40.61 | -649.69 | 150 | 6,090.84 | Jan. 5, 2025: 16 @ 40.61 |
| Feb. 1, 2025 | issue | SO-250201-673 | EAST | 1 | 40.61 | -40.61 | 166 | 6,740.53 | Jan. 5, 2025: 1 @ 40.61 |
| Jan. 25, 2025 | issue | SO-250125-256 | EAST | 1 | 40.61 | -40.61 | 167 | 6,781.14 | Jan. 5, 2025: 1 @ 40.61 |
| Jan. 22, 2025 | issue | SO-250122-571 | MAIN | 18 | 40.61 | -730.90 | 168 | 6,821.74 | Jan. 5, 2025: 18 @ 40.61 |
| Jan. 16, 2025 | issue | SO-250116-393 | MAIN | 1 | 40.61 | -40.61 | 186 | 7,552.64 | Jan. 5, 2025: 1 @ 40.61 |
| Jan. 12, 2025 | issue | SO-250112-336 | MAIN | 8 | 40.61 | -324.84 | 187 | 7,593.25 | Jan. 5, 2025: 8 @ 40.61 |
| Jan. 10, 2025 | issue | SO-250110-992 | EAST | 5 | 40.61 | -203.03 | 195 | 7,918.09 | Jan. 5, 2025: 5 @ 40.61 |
| Jan. 5, 2025 | transfer | TRF | MAIN → EAST | 63 | warehouse transfer, no cost effect | ||||
| Jan. 5, 2025 | receipt | PO-000162 | MAIN | 200 | 40.61 | 8,121.12 | 200 | 8,121.12 | |
| Jan. 3, 2025 | issue | SO-250103-703 | MAIN | 2 | 42.76 | -85.52 | 0 | 0.00 | Dec. 20, 2024: 2 @ 42.76 |
| Dec. 29, 2024 | issue | SO-241229-669 | MAIN | 20 | 42.76 | -855.19 | 2 | 85.52 | Oct. 1, 2024: 12 @ 42.76; Nov. 29, 2024: 8 @ 42.76 |
| Dec. 28, 2024 | issue | SO-241228-879 | MAIN | 25 | 42.76 | -1,068.99 | 22 | 940.71 | Oct. 1, 2024: 25 @ 42.76 |
| Dec. 20, 2024 | return | RMA | MAIN | 2 | 42.76 | 85.52 | 47 | 2,009.70 | |
| Dec. 20, 2024 | issue | SO-241220-493 | MAIN | 39 | 42.76 | -1,667.62 | 45 | 1,924.18 | Oct. 1, 2024: 39 @ 42.76 |
| Dec. 19, 2024 | issue | SO-241219-302 | MAIN | 6 | 42.76 | -256.56 | 84 | 3,591.80 | Oct. 1, 2024: 6 @ 42.76 |
| Dec. 15, 2024 | issue | SO-241215-837 | MAIN | 1 | 42.76 | -42.76 | 90 | 3,848.36 | Oct. 1, 2024: 1 @ 42.76 |
| Dec. 10, 2024 | issue | SO-241210-198 | MAIN | 4 | 42.76 | -171.04 | 91 | 3,891.11 | Oct. 1, 2024: 4 @ 42.76 |
| Dec. 6, 2024 | issue | SO-241206-898 | MAIN | 1 | 42.76 | -42.76 | 95 | 4,062.15 | Oct. 1, 2024: 1 @ 42.76 |
| Nov. 29, 2024 | return | RMA | MAIN | 8 | 42.76 | 342.08 | 96 | 4,104.91 | |
| Nov. 16, 2024 | issue | SO-241116-301 | MAIN | 8 | 42.76 | -342.08 | 88 | 3,762.84 | Oct. 1, 2024: 8 @ 42.76 |
| Nov. 13, 2024 | issue | SO-241113-606 | MAIN | 16 | 42.76 | -684.15 | 96 | 4,104.91 | Oct. 1, 2024: 16 @ 42.76 |
| Nov. 9, 2024 | issue | SO-241109-817 | MAIN | 10 | 42.76 | -427.60 | 112 | 4,789.06 | Oct. 1, 2024: 10 @ 42.76 |
| Nov. 8, 2024 | issue | SO-241108-231 | MAIN | 21 | 42.76 | -897.95 | 122 | 5,216.66 | Oct. 1, 2024: 21 @ 42.76 |
| Oct. 18, 2024 | issue | SO-241018-671 | MAIN | 22 | 42.76 | -940.71 | 143 | 6,114.61 | Oct. 1, 2024: 22 @ 42.76 |
| Oct. 6, 2024 | issue | SO-241006-885 | MAIN | 25 | 42.76 | -1,068.99 | 165 | 7,055.32 | Oct. 1, 2024: 25 @ 42.76 |
| Oct. 1, 2024 | issue | SO-241001-178 | MAIN | 10 | 42.76 | -427.60 | 190 | 8,124.30 | Oct. 1, 2024: 10 @ 42.76 |
| Oct. 1, 2024 | receipt | PO-000001 | MAIN | 200 | 42.76 | 8,551.90 | 200 | 8,551.90 | |