stocksense

Items / LED-0015

Street Light 90W Classic LED-0015 · Lighting · BrightLine Lighting

On hand (EA)62MAIN 62
Value (FIFO)702.66avg 11.33
ClassBX / FCV 0.39
Turnover9.7xlast issue 1 days ago
Days of cover17lead time 10d

Reorder suggested: 800 units (position at or below reorder point: order EOQ), stockout risk low.

Demand and forecast

Monthly demand and forecast for LED-00150.056.9114171228Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 134.0Nov 24: 152.0Dec 24: 101.0Jan 25: 157.0Feb 25: 138.0Mar 25: 118.0Apr 25: 50.0May 25: 88.0Jun 25: 63.0Jul 25: 58.0Aug 25: 141.0Sep 25: 66.0Oct 25: 112.0Nov 25: 207.0Dec 25: 187.0Jan 26: 154.0Feb 26: 74.0Mar 26: 117.0Apr 26: 86.0May 26: 92.0Jun 26: 68.0Jul 26: 97.0Aug 26: 67.0Sep 26: 100.0

actual forecast 90% prediction interval

No forecast run yet for this item. Run forecasts. Policy numbers use trailing 12-month demand.

Policy numbers explained

MetricFormulaSubstitutedResult
Daily demand dmonthly mean / 30.4375113.42 / 30.43753.726
Daily demand sdmonthly sd / sqrt(30.4375)44.03 / 5.5177.981
Service level / zz = Phi^-1(service level)Phi^-1(0.950)1.645
Safety stockz * sqrt(LT * sd_d^2 + d^2 * sd_LT^2)1.645 * sqrt(9.6 * 7.981^2 + 3.726^2 * 2.2^2)42.7
Reorder pointd * LT + safety stock3.726 * 9.6 + 42.778.4
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days78.4
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 1360/yr, S = 45.00, h = 20%, price = 11.31800.0
Inventory positionon hand + on order62 + 062

Price break evaluation (annual cost at each tier's EOQ)

From qtyUnit costOrder qtyAnnual costFeasible
011.7822816,559yes
80011.3180016,362yes (chosen if cheapest)
1,60010.841,60016,512yes

MOQ 400, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
June 19, 202660 / 40011.33680.00
Sept. 1, 20262 / 211.3322.67

Movement ledger 119 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 15, 2026issueSO-261015-912MAIN 35 11.33-396.6762702.66 June 19, 2026: 35 @ 11.33
Oct. 14, 2026issueSO-261014-406MAIN 1 11.33-11.33971,099.33 June 19, 2026: 1 @ 11.33
Oct. 5, 2026issueSO-261005-261MAIN 75 11.33-850.00981,110.66 June 19, 2026: 75 @ 11.33
Sept. 28, 2026issueSO-260928-232MAIN 3 11.33-34.001731,960.66 June 19, 2026: 3 @ 11.33
Sept. 24, 2026issueSO-260924-331MAIN 39 11.33-442.001761,994.66 June 19, 2026: 39 @ 11.33
Sept. 23, 2026issueSO-260923-352MAIN 21 11.33-238.002152,436.66 June 19, 2026: 21 @ 11.33
Sept. 16, 2026issueSO-260916-292MAIN 1 11.33-11.332362,674.66 June 19, 2026: 1 @ 11.33
Sept. 13, 2026issueSO-260913-467MAIN 20 11.33-226.672372,685.99 June 19, 2026: 20 @ 11.33
Sept. 12, 2026issueSO-260912-693MAIN 9 11.33-102.002572,912.66 June 19, 2026: 9 @ 11.33
Sept. 2, 2026issueSO-260902-760MAIN 9 11.33-102.002663,014.66 June 19, 2026: 9 @ 11.33
Sept. 1, 2026returnRMAMAIN 2 11.3322.672753,116.66
Aug. 29, 2026issueSO-260829-383MAIN 2 11.33-22.672733,093.99 June 19, 2026: 2 @ 11.33
Aug. 24, 2026issueSO-260824-502MAIN 36 11.33-408.002753,116.66 June 19, 2026: 36 @ 11.33
Aug. 19, 2026issueSO-260819-488MAIN 9 11.33-102.003113,524.66 June 19, 2026: 9 @ 11.33
Aug. 14, 2026issueSO-260814-605MAIN 4 11.33-45.333203,626.66 June 19, 2026: 4 @ 11.33
Aug. 7, 2026issueSO-260807-730MAIN 6 11.33-68.003243,671.99 June 19, 2026: 6 @ 11.33
Aug. 6, 2026issueSO-260806-768MAIN 10 11.33-113.333303,739.99 June 19, 2026: 10 @ 11.33
July 28, 2026issueSO-260728-115MAIN 58 11.33-657.333403,853.32 June 19, 2026: 58 @ 11.33
July 25, 2026issueSO-260725-130MAIN 32 11.27-360.653984,510.65 Feb. 28, 2026: 16 @ 11.27; March 8, 2026: 14 @ 11.27; June 19, 2026: 2 @ 11.33
July 8, 2026issueSO-260708-749MAIN 7 11.27-78.864304,871.30 Feb. 28, 2026: 7 @ 11.27
June 25, 2026issueSO-260625-615MAIN 4 11.27-45.064374,950.17 Feb. 28, 2026: 4 @ 11.27
June 19, 2026receiptPO-001585MAIN 400 11.334,533.324414,995.23
June 14, 2026issueSO-260614-286MAIN 3 11.27-33.8041461.91 Feb. 28, 2026: 3 @ 11.27
June 12, 2026issueSO-260612-343MAIN 13 11.27-146.4644495.71 Feb. 28, 2026: 13 @ 11.27
June 9, 2026issueSO-260609-262MAIN 9 11.27-101.3957642.17 Feb. 28, 2026: 9 @ 11.27
June 8, 2026issueSO-260608-416MAIN 22 11.27-247.8566743.56 Feb. 28, 2026: 22 @ 11.27
June 2, 2026issueSO-260602-886MAIN 9 11.27-101.3988991.42 Feb. 28, 2026: 9 @ 11.27
June 1, 2026issueSO-260601-844MAIN 8 11.27-90.13971,092.81 Feb. 28, 2026: 8 @ 11.27
May 31, 2026issueSO-260531-361MAIN 7 11.27-78.861051,182.94 Feb. 28, 2026: 7 @ 11.27
May 22, 2026issueSO-260522-374MAIN 2 11.27-22.531121,261.80 Feb. 28, 2026: 2 @ 11.27
May 14, 2026issueSO-260514-244MAIN 14 11.27-157.731141,284.34 Feb. 28, 2026: 14 @ 11.27
May 13, 2026issueSO-260513-279MAIN 14 11.27-157.731281,442.06 Feb. 28, 2026: 14 @ 11.27
May 9, 2026issueSO-260509-548MAIN 3 11.27-33.801421,599.79 Feb. 28, 2026: 3 @ 11.27
May 8, 2026issueSO-260508-478MAIN 44 11.27-495.711451,633.58 Feb. 28, 2026: 44 @ 11.27
May 2, 2026issueSO-260502-380MAIN 8 11.27-90.131892,129.29 Feb. 28, 2026: 8 @ 11.27
April 28, 2026issueSO-260428-161MAIN 3 11.27-33.801972,219.42 Feb. 28, 2026: 3 @ 11.27
April 27, 2026issueSO-260427-716MAIN 19 11.27-214.062002,253.22 Feb. 28, 2026: 19 @ 11.27
April 26, 2026issueSO-260426-898MAIN 3 11.27-33.802192,467.28 Feb. 28, 2026: 3 @ 11.27
April 21, 2026issueSO-260421-193MAIN 20 11.27-225.322222,501.07 Feb. 28, 2026: 20 @ 11.27
April 19, 2026issueSO-260419-892MAIN 31 11.27-349.252422,726.40 Feb. 28, 2026: 31 @ 11.27
April 8, 2026issueSO-260408-563MAIN 10 11.27-112.662733,075.65 Feb. 28, 2026: 10 @ 11.27
March 14, 2026issueSO-260314-732MAIN 111 11.27-1,250.542833,188.31 Feb. 28, 2026: 111 @ 11.27
March 8, 2026returnRMAMAIN 14 11.27157.733944,438.84
March 7, 2026issueSO-260307-963MAIN 20 11.27-225.323804,281.12 Feb. 28, 2026: 20 @ 11.27
Feb. 28, 2026receiptPO-001267MAIN 400 11.274,506.444004,506.44
Feb. 27, 2026issueSO-260227-988MAIN 10 11.30-113.0200.00 Nov. 23, 2025: 10 @ 11.30
Feb. 22, 2026issueSO-260222-275MAIN 11 11.30-124.3210113.02 Nov. 23, 2025: 11 @ 11.30
Feb. 20, 2026issueSO-260220-847MAIN 18 11.30-203.4321237.34 Nov. 23, 2025: 18 @ 11.30
Feb. 18, 2026issueSO-260218-138MAIN 28 11.30-316.4539440.77 Nov. 23, 2025: 28 @ 11.30
Feb. 2, 2026issueSO-260202-513MAIN 7 11.30-79.1167757.22 Nov. 23, 2025: 7 @ 11.30
Jan. 19, 2026issueSO-260119-330MAIN 91 11.30-1,028.4674836.33 Nov. 23, 2025: 91 @ 11.30
Jan. 18, 2026issueSO-260118-188MAIN 9 11.30-101.721651,864.80 Nov. 23, 2025: 9 @ 11.30
Jan. 14, 2026issueSO-260114-839MAIN 17 11.30-192.131741,966.51 Nov. 23, 2025: 17 @ 11.30
Jan. 13, 2026issueSO-260113-760MAIN 22 11.30-248.641912,158.64 Nov. 23, 2025: 22 @ 11.30
Jan. 8, 2026issueSO-260108-957MAIN 15 11.30-169.532132,407.28 Nov. 23, 2025: 15 @ 11.30
Dec. 18, 2025issueSO-251218-251MAIN 25 11.30-282.542282,576.81 Nov. 23, 2025: 25 @ 11.30
Dec. 13, 2025issueSO-251213-883MAIN 54 11.30-610.302532,859.36 Nov. 23, 2025: 54 @ 11.30
Dec. 13, 2025issueSO-251213-883EAST 108 11.25-1,214.663073,469.65 Aug. 27, 2025: 15 @ 10.91; Nov. 23, 2025: 93 @ 11.30
Nov. 30, 2025issueSO-251130-593MAIN 35 10.91-381.724154,684.32 Aug. 27, 2025: 35 @ 10.91
Nov. 24, 2025issueSO-251124-389EAST 5 10.91-54.534505,066.04 Aug. 27, 2025: 5 @ 10.91
Nov. 23, 2025transferTRFMAIN → EAST 113 warehouse transfer, no cost effect
Nov. 23, 2025receiptPO-001014MAIN 400 11.304,520.724555,120.57
Nov. 12, 2025issueSO-251112-483MAIN 167 10.91-1,821.3755599.85 Aug. 27, 2025: 167 @ 10.91
Oct. 23, 2025issueSO-251023-675MAIN 6 10.91-65.442222,421.22 Aug. 27, 2025: 6 @ 10.91
Oct. 8, 2025issueSO-251008-745MAIN 7 10.91-76.342282,486.66 Aug. 27, 2025: 7 @ 10.91
Oct. 6, 2025issueSO-251006-522MAIN 99 10.91-1,079.732352,563.00 Aug. 27, 2025: 99 @ 10.91
Sept. 29, 2025issueSO-250929-747MAIN 25 10.91-272.663343,642.74 Aug. 27, 2025: 25 @ 10.91
Sept. 24, 2025issueSO-250924-806MAIN 4 10.91-43.633593,915.40 Aug. 27, 2025: 4 @ 10.91
Sept. 21, 2025issueSO-250921-937MAIN 12 10.91-130.883633,959.02 Aug. 27, 2025: 12 @ 10.91
Sept. 16, 2025issueSO-250916-645MAIN 2 10.91-21.813754,089.90 Aug. 27, 2025: 2 @ 10.91
Sept. 2, 2025issueSO-250902-977MAIN 23 10.91-250.853774,111.71 Aug. 27, 2025: 23 @ 10.91
Aug. 27, 2025receiptPO-000796MAIN 400 10.914,362.564004,362.56
Aug. 25, 2025issueSO-250825-201EAST 25 10.75-268.6500.00 April 30, 2025: 25 @ 10.75
Aug. 16, 2025issueSO-250816-948EAST 7 10.75-75.2225268.65 April 4, 2025: 5 @ 10.75; April 30, 2025: 2 @ 10.75
Aug. 16, 2025issueSO-250816-948MAIN 109 10.75-1,171.3132343.87 April 4, 2025: 109 @ 10.75
July 12, 2025issueSO-250712-367MAIN 13 10.75-139.701411,515.19 April 4, 2025: 13 @ 10.75
July 4, 2025issueSO-250704-147EAST 19 10.75-204.171541,654.88 April 4, 2025: 19 @ 10.75
July 2, 2025issueSO-250702-530EAST 26 10.75-279.401731,859.06 April 4, 2025: 26 @ 10.75
June 16, 2025issueSO-250616-751EAST 1 10.75-10.751992,138.45 April 4, 2025: 1 @ 10.75
June 7, 2025issueSO-250607-820MAIN 57 10.75-612.522002,149.20 April 4, 2025: 57 @ 10.75
June 4, 2025issueSO-250604-550MAIN 5 10.75-53.732572,761.72 April 4, 2025: 5 @ 10.75
May 26, 2025issueSO-250526-550EAST 1 10.75-10.752622,815.45 April 4, 2025: 1 @ 10.75
May 24, 2025issueSO-250524-150MAIN 68 10.75-730.732632,826.20 April 4, 2025: 68 @ 10.75
May 22, 2025issueSO-250522-339MAIN 3 10.75-32.243313,556.93 April 4, 2025: 3 @ 10.75
May 14, 2025issueSO-250514-893EAST 16 10.75-171.943343,589.16 April 4, 2025: 16 @ 10.75
April 30, 2025returnRMAMAIN 27 10.75290.143503,761.10
April 25, 2025issueSO-250425-205MAIN 55 10.75-591.033233,470.96 April 4, 2025: 55 @ 10.75
April 24, 2025issueSO-250424-771EAST 9 10.75-96.713784,061.99 April 4, 2025: 9 @ 10.75
April 22, 2025issueSO-250422-206EAST 6 10.75-64.483874,158.70 April 4, 2025: 6 @ 10.75
April 4, 2025issueSO-250404-125EAST 7 10.75-75.223934,223.18 April 4, 2025: 7 @ 10.75
April 4, 2025transferTRFMAIN → EAST 117 warehouse transfer, no cost effect
April 4, 2025receiptPO-000410MAIN 400 10.754,298.404004,298.40
March 22, 2025issueSO-250322-179MAIN 74 11.02-815.5500.00 Dec. 11, 2024: 69 @ 11.01; Jan. 3, 2025: 5 @ 11.19
March 21, 2025issueSO-250321-397MAIN 44 11.01-484.3874815.55 Dec. 11, 2024: 44 @ 11.01
Feb. 25, 2025issueSO-250225-393MAIN 88 11.01-968.761181,299.93 Dec. 11, 2024: 88 @ 11.01
Feb. 20, 2025issueSO-250220-686MAIN 6 11.01-66.052062,268.68 Dec. 11, 2024: 6 @ 11.01
Feb. 15, 2025issueSO-250215-522MAIN 9 11.01-99.082122,334.74 Dec. 11, 2024: 9 @ 11.01
Feb. 13, 2025issueSO-250213-407MAIN 35 11.01-385.302212,433.81 Dec. 11, 2024: 35 @ 11.01
Jan. 25, 2025issueSO-250125-383MAIN 140 11.01-1,541.202562,819.11 Dec. 11, 2024: 140 @ 11.01
Jan. 23, 2025issueSO-250123-478MAIN 22 11.12-244.563964,360.32 Oct. 1, 2024: 13 @ 11.19; Dec. 11, 2024: 9 @ 11.01
Jan. 3, 2025returnRMAMAIN 5 11.1955.964184,604.88
Dec. 28, 2024issueSO-241228-388MAIN 8 11.19-89.534134,548.92 Oct. 1, 2024: 8 @ 11.19
Dec. 23, 2024issueSO-241223-368MAIN 23 11.19-257.394214,638.45 Oct. 1, 2024: 23 @ 11.19
Dec. 22, 2024issueSO-241222-446MAIN 10 11.19-111.914444,895.84 Oct. 1, 2024: 10 @ 11.19
Dec. 11, 2024issueSO-241211-899MAIN 14 11.19-156.674545,007.75 Oct. 1, 2024: 14 @ 11.19
Dec. 11, 2024receiptPO-000090MAIN 400 11.014,403.444685,164.43
Dec. 6, 2024issueSO-241206-769MAIN 46 11.19-514.7968760.99 Oct. 1, 2024: 46 @ 11.19
Nov. 27, 2024issueSO-241127-887MAIN 4 11.19-44.761141,275.77 Oct. 1, 2024: 4 @ 11.19
Nov. 25, 2024issueSO-241125-859MAIN 12 11.19-134.291181,320.54 Oct. 1, 2024: 12 @ 11.19
Nov. 22, 2024issueSO-241122-744MAIN 112 11.19-1,253.391301,454.83 Oct. 1, 2024: 112 @ 11.19
Nov. 15, 2024issueSO-241115-828MAIN 19 11.19-212.632422,708.22 Oct. 1, 2024: 19 @ 11.19
Nov. 11, 2024issueSO-241111-633MAIN 1 11.19-11.192612,920.85 Oct. 1, 2024: 1 @ 11.19
Nov. 6, 2024issueSO-241106-283MAIN 4 11.19-44.762622,932.04 Oct. 1, 2024: 4 @ 11.19
Oct. 28, 2024issueSO-241028-475MAIN 1 11.19-11.192662,976.81 Oct. 1, 2024: 1 @ 11.19
Oct. 28, 2024issueSO-241028-475EAST 33 11.19-369.302672,988.00 Oct. 1, 2024: 33 @ 11.19
Oct. 24, 2024issueSO-241024-356EAST 53 11.19-593.123003,357.30 Oct. 1, 2024: 53 @ 11.19
Oct. 12, 2024issueSO-241012-178MAIN 47 11.19-525.983533,950.42 Oct. 1, 2024: 47 @ 11.19
Oct. 1, 2024transferTRFMAIN → EAST 86 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000001MAIN 400 11.194,476.404004,476.40