stocksense

Items / LED-0031

LED Tube 18W Classic LED-0031 · Lighting · BrightLine Lighting

On hand (EA)166MAIN 135, EAST 31
Value (FIFO)10,736.42avg 64.68
ClassBX / FCV 0.27
Turnover3.4xlast issue 0 days ago
Days of cover134lead time 10d

Demand and forecast

Monthly demand and forecast for LED-00310.016.232.548.764.9Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 59.0Nov 24: 51.0Dec 24: 51.0Jan 25: 55.0Feb 25: 42.0Mar 25: 31.0Apr 25: 39.0May 25: 46.0Jun 25: 31.0Jul 25: 35.0Aug 25: 50.0Sep 25: 44.0Oct 25: 48.0Nov 25: 57.0Dec 25: 38.0Jan 26: 38.0Feb 26: 39.0Mar 26: 37.0Apr 26: 34.0May 26: 16.0Jun 26: 35.0Jul 26: 31.0Aug 26: 28.0Sep 26: 50.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.437537.58 / 30.43751.235
Daily demand sdmonthly sd / sqrt(30.4375)10.26 / 5.5171.859
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 * 1.859^2 + 1.235^2 * 2.2^2)10.4
Reorder pointd * LT + safety stock1.235 * 9.6 + 10.422.3
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days22.3
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 451/yr, S = 45.00, h = 20%, price = 65.5255.6
Inventory positionon hand + on order166 + 0166

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

From qtyUnit costOrder qtyAnnual costFeasible
065.525630,258yes (chosen if cheapest)
34062.9034030,546yes
68060.2868031,296yes

MOQ 170, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 16, 2026166 / 17064.6810,736.42

Movement ledger 129 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026issueSO-261016-171EAST 4 64.68-258.7116610,736.42 Oct. 16, 2026: 4 @ 64.68
Oct. 16, 2026transferTRFMAIN → EAST 35 warehouse transfer, no cost effect
Oct. 16, 2026receiptPO-001883MAIN 170 64.6810,995.1217010,995.12
Oct. 15, 2026issueSO-261015-665MAIN 4 63.10-252.4100.00 Oct. 1, 2026: 4 @ 63.10
Oct. 11, 2026issueSO-261011-348MAIN 12 64.35-772.204252.41 May 15, 2026: 2 @ 63.10; May 22, 2026: 9 @ 64.77; Oct. 1, 2026: 1 @ 63.10
Oct. 8, 2026issueSO-261008-901MAIN 7 63.10-441.72161,024.62 May 15, 2026: 7 @ 63.10
Oct. 4, 2026issueSO-261004-526MAIN 17 63.10-1,072.76231,466.34 May 15, 2026: 17 @ 63.10
Oct. 1, 2026returnRMAMAIN 5 63.10315.52402,539.10
Sept. 28, 2026issueSO-260928-921MAIN 7 63.10-441.72352,223.58 May 15, 2026: 7 @ 63.10
Sept. 26, 2026issueSO-260926-914MAIN 10 63.10-631.04422,665.31 May 15, 2026: 10 @ 63.10
Sept. 15, 2026issueSO-260915-147MAIN 4 63.10-252.41523,296.34 May 15, 2026: 4 @ 63.10
Sept. 12, 2026issueSO-260912-544MAIN 6 63.10-378.62563,548.76 May 15, 2026: 6 @ 63.10
Sept. 9, 2026issueSO-260909-601MAIN 23 63.10-1,451.38623,927.38 May 15, 2026: 23 @ 63.10
Aug. 31, 2026issueSO-260831-425MAIN 5 63.10-315.52855,378.76 May 15, 2026: 5 @ 63.10
Aug. 31, 2026issueSO-260831-425EAST 4 63.10-252.41905,694.27 May 15, 2026: 4 @ 63.10
Aug. 24, 2026issueSO-260824-147MAIN 1 63.10-63.10945,946.69 May 15, 2026: 1 @ 63.10
Aug. 16, 2026issueSO-260816-800EAST 3 63.10-189.31956,009.79 May 15, 2026: 3 @ 63.10
Aug. 8, 2026issueSO-260808-778MAIN 15 63.10-946.55986,199.10 May 15, 2026: 15 @ 63.10
July 27, 2026issueSO-260727-543MAIN 3 63.10-189.311137,145.66 May 15, 2026: 3 @ 63.10
July 25, 2026issueSO-260725-703MAIN 9 63.10-567.931167,334.97 May 15, 2026: 9 @ 63.10
July 15, 2026issueSO-260715-476MAIN 10 63.10-631.041257,902.90 May 15, 2026: 10 @ 63.10
July 11, 2026issueSO-260711-289MAIN 4 63.10-252.411358,533.93 May 15, 2026: 4 @ 63.10
July 9, 2026issueSO-260709-374MAIN 5 63.10-315.521398,786.35 May 15, 2026: 5 @ 63.10
June 30, 2026issueSO-260630-648EAST 22 63.10-1,388.281449,101.86 May 15, 2026: 22 @ 63.10
June 16, 2026issueSO-260616-903EAST 13 63.10-820.3516610,490.14 May 15, 2026: 13 @ 63.10
May 22, 2026returnRMAMAIN 9 64.77582.8917911,310.49
May 15, 2026transferTRFMAIN → EAST 42 warehouse transfer, no cost effect
May 15, 2026receiptPO-001495MAIN 170 63.1010,727.6017010,727.60
May 11, 2026issueSO-260511-586MAIN 18 64.77-1,165.7800.00 Dec. 20, 2025: 18 @ 64.77
May 4, 2026issueSO-260504-500MAIN 7 64.77-453.36181,165.78 Dec. 20, 2025: 7 @ 64.77
April 20, 2026issueSO-260420-970MAIN 27 64.77-1,748.67251,619.14 Dec. 20, 2025: 27 @ 64.77
April 20, 2026issueSO-260420-970EAST 5 64.77-323.83523,367.82 Dec. 20, 2025: 5 @ 64.77
April 3, 2026issueSO-260403-330MAIN 2 64.77-129.53573,691.64 Dec. 20, 2025: 2 @ 64.77
March 30, 2026issueSO-260330-322EAST 7 64.77-453.36593,821.18 Dec. 20, 2025: 7 @ 64.77
March 18, 2026issueSO-260318-362MAIN 18 64.77-1,165.78664,274.54 Dec. 20, 2025: 18 @ 64.77
March 12, 2026issueSO-260312-772EAST 6 64.77-388.59845,440.32 Dec. 20, 2025: 6 @ 64.77
March 5, 2026issueSO-260305-994MAIN 6 64.77-388.59905,828.91 Dec. 20, 2025: 6 @ 64.77
Feb. 14, 2026issueSO-260214-820EAST 1 64.77-64.77966,217.51 Dec. 20, 2025: 1 @ 64.77
Feb. 10, 2026issueSO-260210-153MAIN 9 64.77-582.89976,282.27 Dec. 20, 2025: 9 @ 64.77
Feb. 7, 2026issueSO-260207-503MAIN 2 64.77-129.531066,865.16 Dec. 20, 2025: 2 @ 64.77
Feb. 4, 2026issueSO-260204-501MAIN 27 64.77-1,748.671086,994.70 Dec. 20, 2025: 27 @ 64.77
Jan. 31, 2026issueSO-260131-871EAST 2 64.77-129.531358,743.37 Dec. 20, 2025: 2 @ 64.77
Jan. 30, 2026issueSO-260130-537MAIN 16 64.77-1,036.251378,872.90 Dec. 20, 2025: 16 @ 64.77
Jan. 19, 2026issueSO-260119-859MAIN 4 64.77-259.061539,909.15 Dec. 20, 2025: 4 @ 64.77
Jan. 17, 2026issueSO-260117-360EAST 2 64.77-129.5315710,168.21 Dec. 20, 2025: 2 @ 64.77
Jan. 10, 2026issueSO-260110-519EAST 14 64.48-902.6915910,297.75 Sept. 1, 2025: 3 @ 63.42; Dec. 20, 2025: 11 @ 64.77
Dec. 27, 2025issueSO-251227-296EAST 21 63.42-1,331.9017311,200.44 Sept. 1, 2025: 21 @ 63.42
Dec. 20, 2025transferTRFMAIN → EAST 58 warehouse transfer, no cost effect
Dec. 20, 2025receiptPO-001068MAIN 170 64.7711,010.1719412,532.34
Dec. 13, 2025issueSO-251213-358MAIN 2 63.42-126.85241,522.18 Sept. 1, 2025: 2 @ 63.42
Dec. 12, 2025issueSO-251212-768MAIN 1 63.42-63.42261,649.02 Sept. 1, 2025: 1 @ 63.42
Dec. 10, 2025issueSO-251210-208MAIN 9 63.42-570.82271,712.45 Sept. 1, 2025: 9 @ 63.42
Dec. 7, 2025issueSO-251207-962MAIN 5 63.42-317.12362,283.26 Sept. 1, 2025: 5 @ 63.42
Nov. 29, 2025issueSO-251129-341MAIN 7 63.42-443.97412,600.38 Sept. 1, 2025: 7 @ 63.42
Nov. 16, 2025issueSO-251116-563MAIN 6 63.42-380.54483,044.35 Sept. 1, 2025: 6 @ 63.42
Nov. 16, 2025issueSO-251116-563EAST 23 63.42-1,458.75543,424.90 Sept. 1, 2025: 23 @ 63.42
Nov. 2, 2025issueSO-251102-887EAST 21 63.42-1,331.90774,883.65 Sept. 1, 2025: 21 @ 63.42
Oct. 25, 2025issueSO-251025-867MAIN 13 63.42-824.51986,215.55 Sept. 1, 2025: 13 @ 63.42
Oct. 22, 2025issueSO-251022-176MAIN 2 63.42-126.851117,040.06 Sept. 1, 2025: 2 @ 63.42
Oct. 20, 2025issueSO-251020-372MAIN 2 63.42-126.851137,166.91 Sept. 1, 2025: 2 @ 63.42
Oct. 18, 2025issueSO-251018-885MAIN 1 63.42-63.421157,293.76 Sept. 1, 2025: 1 @ 63.42
Oct. 16, 2025issueSO-251016-630EAST 8 63.42-507.391167,357.18 Sept. 1, 2025: 8 @ 63.42
Oct. 10, 2025issueSO-251010-199MAIN 19 63.42-1,205.061247,864.58 Sept. 1, 2025: 19 @ 63.42
Oct. 5, 2025issueSO-251005-313MAIN 3 63.42-190.271439,069.63 Sept. 1, 2025: 3 @ 63.42
Sept. 25, 2025issueSO-250925-957MAIN 2 63.42-126.851469,259.90 Sept. 1, 2025: 2 @ 63.42
Sept. 24, 2025issueSO-250924-931MAIN 24 63.32-1,519.681489,386.75 May 3, 2025: 2 @ 62.18; Sept. 1, 2025: 22 @ 63.42
Sept. 16, 2025issueSO-250916-360EAST 5 62.18-310.8917210,906.43 May 3, 2025: 5 @ 62.18
Sept. 12, 2025issueSO-250912-497MAIN 13 62.18-808.3017711,217.32 May 3, 2025: 13 @ 62.18
Sept. 1, 2025transferTRFMAIN → EAST 57 warehouse transfer, no cost effect
Sept. 1, 2025receiptPO-000809MAIN 170 63.4210,782.0819012,025.62
Aug. 22, 2025issueSO-250822-867MAIN 4 62.18-248.71201,243.54 May 3, 2025: 4 @ 62.18
Aug. 13, 2025issueSO-250813-698MAIN 6 62.18-373.06241,492.25 May 3, 2025: 6 @ 62.18
Aug. 10, 2025issueSO-250810-832MAIN 8 62.18-497.42301,865.32 May 3, 2025: 8 @ 62.18
Aug. 8, 2025issueSO-250808-487MAIN 7 62.18-435.24382,362.73 May 3, 2025: 7 @ 62.18
Aug. 3, 2025issueSO-250803-291MAIN 17 62.18-1,057.01452,797.97 May 3, 2025: 17 @ 62.18
Aug. 2, 2025issueSO-250802-913MAIN 2 62.18-124.35623,854.99 May 3, 2025: 2 @ 62.18
Aug. 2, 2025issueSO-250802-913EAST 6 62.18-373.06643,979.34 May 3, 2025: 6 @ 62.18
July 2, 2025issueSO-250702-199MAIN 21 62.18-1,305.72704,352.40 May 3, 2025: 21 @ 62.18
July 1, 2025issueSO-250701-457EAST 14 62.18-870.48915,658.13 May 3, 2025: 14 @ 62.18
June 27, 2025issueSO-250627-579EAST 11 62.18-683.951056,528.61 May 3, 2025: 11 @ 62.18
June 23, 2025issueSO-250623-394MAIN 12 62.18-746.131167,212.56 May 3, 2025: 12 @ 62.18
June 16, 2025issueSO-250616-366MAIN 8 62.18-497.421287,958.68 May 3, 2025: 8 @ 62.18
May 26, 2025issueSO-250526-159EAST 4 62.18-248.711368,456.10 May 3, 2025: 4 @ 62.18
May 24, 2025issueSO-250524-123MAIN 15 62.18-932.661408,704.81 May 3, 2025: 15 @ 62.18
May 14, 2025issueSO-250514-632MAIN 13 62.18-808.301559,637.47 May 3, 2025: 13 @ 62.18
May 7, 2025issueSO-250507-567MAIN 14 60.48-846.6616810,445.77 Dec. 19, 2024: 12 @ 60.19; May 3, 2025: 2 @ 62.18
May 3, 2025transferTRFMAIN → EAST 35 warehouse transfer, no cost effect
May 3, 2025receiptPO-000508MAIN 170 62.1810,570.1218211,292.43
April 30, 2025issueSO-250430-766MAIN 1 60.19-60.1912722.31 Dec. 19, 2024: 1 @ 60.19
April 24, 2025issueSO-250424-458MAIN 5 60.19-300.9613782.50 Dec. 19, 2024: 5 @ 60.19
April 22, 2025issueSO-250422-863MAIN 13 60.19-782.50181,083.46 Dec. 19, 2024: 13 @ 60.19
April 19, 2025issueSO-250419-660MAIN 4 60.19-240.77311,865.97 Dec. 19, 2024: 4 @ 60.19
April 13, 2025issueSO-250413-242MAIN 1 60.19-60.19352,106.74 Dec. 19, 2024: 1 @ 60.19
April 3, 2025issueSO-250403-187MAIN 3 60.19-180.58362,166.93 Dec. 19, 2024: 3 @ 60.19
April 1, 2025issueSO-250401-363MAIN 10 60.19-601.92392,347.51 Dec. 19, 2024: 10 @ 60.19
April 1, 2025issueSO-250401-363EAST 2 60.19-120.38492,949.43 Dec. 19, 2024: 2 @ 60.19
March 28, 2025issueSO-250328-668EAST 1 60.19-60.19513,069.82 Dec. 19, 2024: 1 @ 60.19
March 27, 2025issueSO-250327-109EAST 12 60.19-722.31523,130.01 Dec. 19, 2024: 12 @ 60.19
March 25, 2025issueSO-250325-713MAIN 1 60.19-60.19643,852.32 Dec. 19, 2024: 1 @ 60.19
March 20, 2025issueSO-250320-790EAST 14 60.19-842.70653,912.51 Dec. 19, 2024: 14 @ 60.19
March 11, 2025issueSO-250311-899EAST 2 60.19-120.38794,755.21 Dec. 19, 2024: 2 @ 60.19
March 1, 2025issueSO-250301-266MAIN 1 60.19-60.19814,875.59 Dec. 19, 2024: 1 @ 60.19
Feb. 19, 2025issueSO-250219-736MAIN 16 60.19-963.08824,935.78 Dec. 19, 2024: 16 @ 60.19
Feb. 12, 2025issueSO-250212-520MAIN 10 60.19-601.92985,898.86 Dec. 19, 2024: 10 @ 60.19
Feb. 8, 2025issueSO-250208-911EAST 16 60.19-963.081086,500.79 Dec. 19, 2024: 16 @ 60.19
Jan. 28, 2025issueSO-250128-579EAST 3 60.19-180.581247,463.87 Dec. 19, 2024: 3 @ 60.19
Jan. 24, 2025issueSO-250124-212MAIN 41 60.19-2,467.891277,644.45 Dec. 19, 2024: 41 @ 60.19
Jan. 19, 2025issueSO-250119-194MAIN 1 60.19-60.1916810,112.34 Dec. 19, 2024: 1 @ 60.19
Jan. 18, 2025issueSO-250118-208MAIN 7 61.95-433.6616910,172.53 Oct. 1, 2024: 6 @ 62.24; Dec. 19, 2024: 1 @ 60.19
Jan. 12, 2025issueSO-250112-298MAIN 2 62.24-124.4917610,606.19 Oct. 1, 2024: 2 @ 62.24
Jan. 7, 2025issueSO-250107-988EAST 1 62.24-62.2417810,730.68 Oct. 1, 2024: 1 @ 62.24
Dec. 30, 2024issueSO-241230-510MAIN 8 62.24-497.9517910,792.92 Oct. 1, 2024: 8 @ 62.24
Dec. 27, 2024issueSO-241227-848MAIN 2 62.24-124.4918711,290.87 Oct. 1, 2024: 2 @ 62.24
Dec. 23, 2024issueSO-241223-293MAIN 8 62.24-497.9518911,415.36 Oct. 1, 2024: 8 @ 62.24
Dec. 19, 2024transferTRFMAIN → EAST 51 warehouse transfer, no cost effect
Dec. 19, 2024receiptPO-000116MAIN 170 60.1910,232.7219711,913.31
Dec. 15, 2024issueSO-241215-175MAIN 1 62.24-62.24271,680.59 Oct. 1, 2024: 1 @ 62.24
Dec. 8, 2024issueSO-241208-707MAIN 16 62.24-995.90281,742.83 Oct. 1, 2024: 16 @ 62.24
Dec. 7, 2024issueSO-241207-582MAIN 11 62.24-684.68442,738.74 Oct. 1, 2024: 11 @ 62.24
Dec. 6, 2024issueSO-241206-124MAIN 5 62.24-311.22553,423.42 Oct. 1, 2024: 5 @ 62.24
Nov. 28, 2024issueSO-241128-283MAIN 3 62.24-186.73603,734.64 Oct. 1, 2024: 3 @ 62.24
Nov. 27, 2024issueSO-241127-418MAIN 5 62.24-311.22633,921.37 Oct. 1, 2024: 5 @ 62.24
Nov. 19, 2024issueSO-241119-490MAIN 14 62.24-871.42684,232.59 Oct. 1, 2024: 14 @ 62.24
Nov. 12, 2024issueSO-241112-786MAIN 11 62.24-684.68825,104.01 Oct. 1, 2024: 11 @ 62.24
Nov. 8, 2024issueSO-241108-365MAIN 15 62.24-933.66935,788.69 Oct. 1, 2024: 15 @ 62.24
Nov. 5, 2024issueSO-241105-988MAIN 3 62.24-186.731086,722.35 Oct. 1, 2024: 3 @ 62.24
Oct. 25, 2024issueSO-241025-211MAIN 6 62.24-373.461116,909.08 Oct. 1, 2024: 6 @ 62.24
Oct. 19, 2024issueSO-241019-195MAIN 53 62.24-3,298.931177,282.55 Oct. 1, 2024: 53 @ 62.24
Oct. 1, 2024receiptPO-000001MAIN 170 62.2410,581.4817010,581.48