Items / LED-0010
LED Bulb 12W Classic LED-0010 · Lighting · BrightLine Lighting
On hand (EA)67MAIN 38, EAST 29
Value (FIFO)783.21avg 11.69
ClassCX / FCV 0.26
Turnover4.5xlast issue 1 days ago
Days of cover105lead 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 | 19.50 / 30.4375 | 0.641 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 5.09 / 5.517 | 0.923 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.900) | 1.282 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.282 * sqrt(9.6 * 0.923^2 + 0.641^2 * 2.2^2) | 4.1 |
| Reorder point | d * LT + safety stock | 0.641 * 9.6 + 4.1 | 10.2 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 10.2 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 234/yr, S = 45.00, h = 20%, price = 11.35 | 180.0 |
| Inventory position | on hand + on order | 67 + 0 | 67 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 11.82 | 94 | 2,987 | yes |
| 180 | 11.35 | 180 | 2,916 | yes (chosen if cheapest) |
| 360 | 10.87 | 360 | 2,964 | yes |
MOQ 90, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 27, 2026 | 67 / 90 | 11.69 | 783.21 |
Movement ledger 110 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 15, 2026 | issue | SO-261015-342 | EAST | 1 | 11.69 | -11.69 | 67 | 783.21 | Sept. 27, 2026: 1 @ 11.69 |
| Oct. 12, 2026 | issue | SO-261012-889 | MAIN | 5 | 11.69 | -58.45 | 68 | 794.90 | Sept. 27, 2026: 5 @ 11.69 |
| Oct. 6, 2026 | issue | SO-261006-297 | MAIN | 10 | 11.69 | -116.90 | 73 | 853.35 | Sept. 27, 2026: 10 @ 11.69 |
| Oct. 3, 2026 | issue | SO-261003-406 | MAIN | 6 | 11.69 | -70.14 | 83 | 970.25 | Sept. 27, 2026: 6 @ 11.69 |
| Oct. 1, 2026 | issue | SO-261001-162 | MAIN | 9 | 11.74 | -105.70 | 89 | 1,040.38 | April 14, 2026: 8 @ 11.75; Sept. 27, 2026: 1 @ 11.69 |
| Sept. 27, 2026 | transfer | TRF | MAIN → EAST | 22 | warehouse transfer, no cost effect | ||||
| Sept. 27, 2026 | receipt | PO-001831 | MAIN | 90 | 11.69 | 1,052.07 | 98 | 1,146.08 | |
| Sept. 20, 2026 | issue | SO-260920-712 | EAST | 5 | 11.75 | -58.75 | 8 | 94.01 | April 14, 2026: 5 @ 11.75 |
| Sept. 20, 2026 | issue | SO-260920-712 | MAIN | 6 | 11.75 | -70.50 | 13 | 152.76 | April 14, 2026: 6 @ 11.75 |
| Sept. 11, 2026 | issue | SO-260911-337 | MAIN | 2 | 11.75 | -23.50 | 19 | 223.26 | April 14, 2026: 2 @ 11.75 |
| Aug. 24, 2026 | issue | SO-260824-152 | MAIN | 1 | 11.75 | -11.75 | 21 | 246.76 | April 14, 2026: 1 @ 11.75 |
| Aug. 21, 2026 | issue | SO-260821-395 | MAIN | 16 | 11.75 | -188.01 | 22 | 258.52 | April 14, 2026: 16 @ 11.75 |
| July 20, 2026 | issue | SO-260720-931 | MAIN | 10 | 11.75 | -117.51 | 38 | 446.53 | April 14, 2026: 10 @ 11.75 |
| July 3, 2026 | issue | SO-260703-859 | MAIN | 3 | 11.75 | -35.25 | 48 | 564.03 | April 14, 2026: 3 @ 11.75 |
| June 28, 2026 | issue | SO-260628-552 | EAST | 1 | 11.75 | -11.75 | 51 | 599.29 | April 14, 2026: 1 @ 11.75 |
| June 16, 2026 | issue | SO-260616-908 | MAIN | 4 | 11.75 | -47.00 | 52 | 611.04 | April 14, 2026: 4 @ 11.75 |
| June 15, 2026 | issue | SO-260615-902 | MAIN | 5 | 11.75 | -58.75 | 56 | 658.04 | April 14, 2026: 5 @ 11.75 |
| June 14, 2026 | issue | SO-260614-212 | EAST | 4 | 11.75 | -47.00 | 61 | 716.79 | April 14, 2026: 4 @ 11.75 |
| June 4, 2026 | issue | SO-260604-525 | MAIN | 1 | 11.75 | -11.75 | 65 | 763.80 | April 14, 2026: 1 @ 11.75 |
| June 1, 2026 | issue | SO-260601-710 | MAIN | 2 | 11.75 | -23.50 | 66 | 775.55 | April 14, 2026: 2 @ 11.75 |
| May 30, 2026 | issue | SO-260530-797 | MAIN | 1 | 11.75 | -11.75 | 68 | 799.05 | April 14, 2026: 1 @ 11.75 |
| May 22, 2026 | issue | SO-260522-872 | MAIN | 6 | 11.75 | -70.50 | 69 | 810.80 | April 14, 2026: 6 @ 11.75 |
| May 18, 2026 | issue | SO-260518-721 | MAIN | 3 | 11.75 | -35.25 | 75 | 881.30 | April 14, 2026: 3 @ 11.75 |
| May 14, 2026 | issue | SO-260514-574 | MAIN | 5 | 11.75 | -58.75 | 78 | 916.55 | April 14, 2026: 5 @ 11.75 |
| April 17, 2026 | issue | SO-260417-225 | MAIN | 2 | 11.75 | -23.50 | 83 | 975.31 | April 14, 2026: 2 @ 11.75 |
| April 16, 2026 | issue | SO-260416-807 | MAIN | 2 | 11.75 | -23.50 | 85 | 998.81 | April 14, 2026: 2 @ 11.75 |
| April 15, 2026 | issue | SO-260415-233 | MAIN | 3 | 11.75 | -35.25 | 87 | 1,022.31 | April 14, 2026: 3 @ 11.75 |
| April 14, 2026 | transfer | TRF | MAIN → EAST | 18 | warehouse transfer, no cost effect | ||||
| April 14, 2026 | receipt | PO-001406 | MAIN | 90 | 11.75 | 1,057.56 | 90 | 1,057.56 | |
| April 2, 2026 | issue | SO-260402-531 | MAIN | 20 | 11.30 | -225.96 | 0 | 0.00 | Dec. 5, 2025: 19 @ 11.30; Jan. 21, 2026: 1 @ 11.30 |
| March 19, 2026 | issue | SO-260319-919 | MAIN | 1 | 11.30 | -11.30 | 20 | 225.96 | Dec. 5, 2025: 1 @ 11.30 |
| March 16, 2026 | issue | SO-260316-226 | MAIN | 7 | 11.30 | -79.09 | 21 | 237.26 | Dec. 5, 2025: 7 @ 11.30 |
| March 12, 2026 | issue | SO-260312-491 | MAIN | 3 | 11.30 | -33.89 | 28 | 316.35 | Dec. 5, 2025: 3 @ 11.30 |
| March 4, 2026 | issue | SO-260304-751 | MAIN | 2 | 11.30 | -22.60 | 31 | 350.24 | Dec. 5, 2025: 2 @ 11.30 |
| March 3, 2026 | issue | SO-260303-844 | MAIN | 4 | 11.30 | -45.19 | 33 | 372.84 | Dec. 5, 2025: 4 @ 11.30 |
| Feb. 27, 2026 | issue | SO-260227-174 | MAIN | 4 | 11.30 | -45.19 | 37 | 418.03 | Dec. 5, 2025: 4 @ 11.30 |
| Feb. 4, 2026 | issue | SO-260204-758 | MAIN | 6 | 11.30 | -67.79 | 41 | 463.22 | Dec. 5, 2025: 6 @ 11.30 |
| Feb. 3, 2026 | issue | SO-260203-917 | MAIN | 4 | 11.30 | -45.19 | 47 | 531.01 | Dec. 5, 2025: 4 @ 11.30 |
| Feb. 1, 2026 | issue | SO-260201-105 | MAIN | 7 | 11.30 | -79.09 | 51 | 576.20 | Dec. 5, 2025: 7 @ 11.30 |
| Jan. 21, 2026 | return | RMA | MAIN | 1 | 11.30 | 11.30 | 58 | 655.29 | |
| Jan. 8, 2026 | issue | SO-260108-479 | MAIN | 10 | 11.30 | -112.98 | 57 | 643.99 | Dec. 5, 2025: 10 @ 11.30 |
| Jan. 7, 2026 | issue | SO-260107-206 | MAIN | 1 | 11.30 | -11.30 | 67 | 756.97 | Dec. 5, 2025: 1 @ 11.30 |
| Jan. 6, 2026 | issue | SO-260106-284 | MAIN | 7 | 11.30 | -79.09 | 68 | 768.27 | Dec. 5, 2025: 7 @ 11.30 |
| Dec. 26, 2025 | issue | SO-251226-705 | MAIN | 16 | 11.30 | -180.80 | 75 | 847.36 | Aug. 17, 2025: 1 @ 11.32; Dec. 5, 2025: 15 @ 11.30 |
| Dec. 25, 2025 | issue | SO-251225-847 | MAIN | 4 | 11.32 | -45.30 | 91 | 1,028.15 | Aug. 17, 2025: 4 @ 11.32 |
| Dec. 16, 2025 | issue | SO-251216-666 | MAIN | 2 | 11.32 | -22.65 | 95 | 1,073.45 | Aug. 17, 2025: 2 @ 11.32 |
| Dec. 12, 2025 | issue | SO-251212-447 | MAIN | 6 | 11.32 | -67.95 | 97 | 1,096.10 | Aug. 17, 2025: 6 @ 11.32 |
| Dec. 5, 2025 | receipt | PO-001034 | MAIN | 90 | 11.30 | 1,016.83 | 103 | 1,164.05 | |
| Nov. 29, 2025 | issue | SO-251129-322 | MAIN | 3 | 11.32 | -33.97 | 13 | 147.22 | Aug. 17, 2025: 3 @ 11.32 |
| Nov. 13, 2025 | issue | SO-251113-583 | MAIN | 21 | 11.32 | -237.82 | 16 | 181.19 | Aug. 17, 2025: 21 @ 11.32 |
| Oct. 19, 2025 | issue | SO-251019-792 | MAIN | 5 | 11.32 | -56.62 | 37 | 419.01 | Aug. 17, 2025: 5 @ 11.32 |
| Oct. 14, 2025 | issue | SO-251014-653 | MAIN | 17 | 11.32 | -192.52 | 42 | 475.63 | Aug. 17, 2025: 17 @ 11.32 |
| Oct. 4, 2025 | issue | SO-251004-624 | MAIN | 3 | 11.32 | -33.97 | 59 | 668.15 | Aug. 17, 2025: 3 @ 11.32 |
| Sept. 27, 2025 | issue | SO-250927-538 | MAIN | 12 | 11.32 | -135.90 | 62 | 702.13 | Aug. 17, 2025: 12 @ 11.32 |
| Sept. 18, 2025 | issue | SO-250918-220 | MAIN | 1 | 11.32 | -11.32 | 74 | 838.02 | Aug. 17, 2025: 1 @ 11.32 |
| Sept. 13, 2025 | issue | SO-250913-484 | MAIN | 11 | 11.32 | -124.57 | 75 | 849.34 | Aug. 17, 2025: 11 @ 11.32 |
| Aug. 22, 2025 | issue | SO-250822-168 | MAIN | 4 | 11.32 | -45.30 | 86 | 973.92 | Aug. 17, 2025: 4 @ 11.32 |
| Aug. 17, 2025 | receipt | PO-000781 | MAIN | 90 | 11.32 | 1,019.21 | 90 | 1,019.21 | |
| Aug. 15, 2025 | issue | SO-250815-420 | MAIN | 2 | 11.00 | -22.01 | 0 | 0.00 | July 5, 2025: 2 @ 11.00 |
| Aug. 11, 2025 | issue | SO-250811-849 | MAIN | 7 | 11.00 | -77.03 | 2 | 22.01 | July 5, 2025: 7 @ 11.00 |