Items / LED-0014
Panel Light 15W Lite LED-0014 · Lighting · BrightLine Lighting
On hand (EA)0
Value (FIFO)0.00avg 0.00
ClassCZ / NCV -
Turnover0.0xlast issue 504 days ago
Days of cover-lead 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 | 0.00 / 30.4375 | 0.000 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 0.00 / 5.517 | 0.000 |
| 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.000^2 + 0.000^2 * 2.2^2) | 0.0 |
| Reorder point | d * LT + safety stock | 0.000 * 9.6 + 0.0 | 0.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 0.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 0/yr, S = 45.00, h = 20%, price = 42.53 | 1.0 |
| Inventory position | on hand + on order | 0 + 0 | 0 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 42.53 | 1 | 4 | yes (chosen if cheapest) |
MOQ 940, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| No stock. | ||||
Movement ledger 33 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| May 30, 2025 | issue | SO-250530-250 | MAIN | 142 | 40.50 | -5,751.71 | 0 | 0.00 | Jan. 30, 2025: 142 @ 40.50 |
| May 9, 2025 | issue | SO-250509-757 | MAIN | 58 | 40.50 | -2,349.29 | 142 | 5,751.71 | Jan. 30, 2025: 58 @ 40.50 |
| April 27, 2025 | issue | SO-250427-725 | MAIN | 24 | 40.50 | -972.12 | 200 | 8,101.00 | Jan. 30, 2025: 24 @ 40.50 |
| April 10, 2025 | issue | SO-250410-845 | MAIN | 74 | 40.50 | -2,997.37 | 224 | 9,073.12 | Jan. 30, 2025: 74 @ 40.50 |
| April 9, 2025 | issue | SO-250409-756 | MAIN | 65 | 40.50 | -2,632.82 | 298 | 12,070.49 | Jan. 30, 2025: 65 @ 40.50 |
| April 9, 2025 | issue | SO-250409-756 | EAST | 111 | 40.50 | -4,496.06 | 363 | 14,703.32 | Jan. 30, 2025: 111 @ 40.50 |
| April 4, 2025 | issue | SO-250404-549 | MAIN | 29 | 40.50 | -1,174.64 | 474 | 19,199.37 | Jan. 30, 2025: 29 @ 40.50 |
| March 27, 2025 | issue | SO-250327-276 | EAST | 10 | 40.50 | -405.05 | 503 | 20,374.02 | Jan. 30, 2025: 10 @ 40.50 |
| March 23, 2025 | issue | SO-250323-745 | MAIN | 92 | 40.50 | -3,726.46 | 513 | 20,779.06 | Jan. 30, 2025: 92 @ 40.50 |
| March 22, 2025 | issue | SO-250322-899 | EAST | 96 | 40.50 | -3,888.48 | 605 | 24,505.52 | Jan. 30, 2025: 96 @ 40.50 |
| March 2, 2025 | issue | SO-250302-325 | MAIN | 28 | 40.50 | -1,134.14 | 701 | 28,394.00 | Jan. 30, 2025: 28 @ 40.50 |
| Feb. 27, 2025 | issue | SO-250227-349 | EAST | 24 | 40.50 | -972.12 | 729 | 29,528.14 | Jan. 30, 2025: 24 @ 40.50 |
| Feb. 22, 2025 | issue | SO-250222-254 | MAIN | 21 | 40.50 | -850.60 | 753 | 30,500.26 | Jan. 30, 2025: 21 @ 40.50 |
| Feb. 21, 2025 | issue | SO-250221-672 | MAIN | 6 | 40.50 | -243.03 | 774 | 31,350.87 | Jan. 30, 2025: 6 @ 40.50 |
| Feb. 17, 2025 | issue | SO-250217-806 | MAIN | 108 | 40.50 | -4,374.54 | 780 | 31,593.90 | Jan. 30, 2025: 108 @ 40.50 |
| Feb. 6, 2025 | issue | SO-250206-873 | MAIN | 43 | 40.50 | -1,741.72 | 888 | 35,968.44 | Jan. 30, 2025: 43 @ 40.50 |
| Feb. 3, 2025 | issue | SO-250203-682 | EAST | 9 | 40.50 | -364.54 | 931 | 37,710.16 | Jan. 30, 2025: 9 @ 40.50 |
| Jan. 30, 2025 | transfer | TRF | MAIN → EAST | 250 | warehouse transfer, no cost effect | ||||
| Jan. 30, 2025 | receipt | PO-000229 | MAIN | 940 | 40.50 | 38,074.70 | 940 | 38,074.70 | |
| Jan. 22, 2025 | issue | SO-250122-712 | MAIN | 222 | 40.40 | -8,969.58 | 0 | 0.00 | Oct. 1, 2024: 222 @ 40.40 |
| Dec. 30, 2024 | issue | SO-241230-375 | MAIN | 6 | 40.40 | -242.42 | 222 | 8,969.58 | Oct. 1, 2024: 6 @ 40.40 |
| Dec. 20, 2024 | issue | SO-241220-974 | MAIN | 279 | 40.40 | -11,272.58 | 228 | 9,212.00 | Oct. 1, 2024: 279 @ 40.40 |
| Dec. 17, 2024 | issue | SO-241217-682 | MAIN | 12 | 40.40 | -484.84 | 507 | 20,484.57 | Oct. 1, 2024: 12 @ 40.40 |
| Nov. 25, 2024 | adjustment | Cycle count | MAIN | -1 | 40.40 | -40.40 | 519 | 20,969.42 | Oct. 1, 2024: 1 @ 40.40 |
| Nov. 25, 2024 | issue | SO-241125-207 | MAIN | 44 | 40.40 | -1,777.75 | 520 | 21,009.82 | Oct. 1, 2024: 44 @ 40.40 |
| Nov. 18, 2024 | issue | SO-241118-929 | MAIN | 181 | 40.40 | -7,313.03 | 564 | 22,787.57 | Oct. 1, 2024: 181 @ 40.40 |
| Oct. 28, 2024 | issue | SO-241028-439 | MAIN | 11 | 40.40 | -444.44 | 745 | 30,100.61 | Oct. 1, 2024: 11 @ 40.40 |
| Oct. 27, 2024 | issue | SO-241027-938 | MAIN | 8 | 40.40 | -323.23 | 756 | 30,545.05 | Oct. 1, 2024: 8 @ 40.40 |
| Oct. 23, 2024 | issue | SO-241023-407 | MAIN | 4 | 40.40 | -161.61 | 764 | 30,868.27 | Oct. 1, 2024: 4 @ 40.40 |
| Oct. 19, 2024 | issue | SO-241019-870 | MAIN | 62 | 40.40 | -2,505.02 | 768 | 31,029.89 | Oct. 1, 2024: 62 @ 40.40 |
| Oct. 13, 2024 | issue | SO-241013-152 | MAIN | 47 | 40.40 | -1,898.96 | 830 | 33,534.90 | Oct. 1, 2024: 47 @ 40.40 |
| Oct. 6, 2024 | issue | SO-241006-862 | MAIN | 63 | 40.40 | -2,545.42 | 877 | 35,433.87 | Oct. 1, 2024: 63 @ 40.40 |
| Oct. 1, 2024 | receipt | PO-000001 | MAIN | 940 | 40.40 | 37,979.29 | 940 | 37,979.29 | |