stocksense

Items / LED-0040

LED Bulb 9W Classic LED-0040 · Lighting · BrightLine Lighting

On hand (EA)704MAIN 704
Value (FIFO)64,850.65avg 92.12
ClassAX / FCV 0.31
Turnover4.8xlast issue 2 days ago
Days of cover89lead time 10d

Demand and forecast

Monthly demand and forecast for LED-00400.0119239358477Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 331.0Nov 24: 310.0Dec 24: 361.0Jan 25: 230.0Feb 25: 238.0Mar 25: 250.0Apr 25: 330.0May 25: 197.0Jun 25: 269.0Jul 25: 434.0Aug 25: 203.0Sep 25: 264.0Oct 25: 323.0Nov 25: 334.0Dec 25: 277.0Jan 26: 300.0Feb 26: 286.0Mar 26: 299.0Apr 26: 71.0May 26: 245.0Jun 26: 167.0Jul 26: 191.0Aug 26: 197.0Sep 26: 193.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.4375240.25 / 30.43757.893
Daily demand sdmonthly sd / sqrt(30.4375)74.53 / 5.51713.510
Service level / zz = Phi^-1(service level)Phi^-1(0.980)2.054
Safety stockz * sqrt(LT * sd_d^2 + d^2 * sd_LT^2)2.054 * sqrt(9.6 * 13.510^2 + 7.893^2 * 2.2^2)92.7
Reorder pointd * LT + safety stock7.893 * 9.6 + 92.7168.3
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days168.3
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 2881/yr, S = 45.00, h = 20%, price = 94.69117.0
Inventory positionon hand + on order704 + 0704

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

From qtyUnit costOrder qtyAnnual costFeasible
094.69117275,020yes (chosen if cheapest)
2,10090.902,100281,043yes
4,20087.114,200287,599yes

MOQ 1,050, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 24, 2026704 / 1,05092.1264,850.65

Movement ledger 118 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 14, 2026issueSO-261014-780MAIN 27 92.12-2,487.1770464,850.65 Sept. 24, 2026: 27 @ 92.12
Oct. 7, 2026issueSO-261007-523MAIN 117 92.12-10,777.7473167,337.82 Sept. 24, 2026: 117 @ 92.12
Oct. 5, 2026issueSO-261005-731MAIN 6 92.12-552.7084878,115.56 Sept. 24, 2026: 6 @ 92.12
Oct. 3, 2026issueSO-261003-786MAIN 196 92.12-18,055.0185478,668.26 Sept. 24, 2026: 196 @ 92.12
Sept. 24, 2026receiptPO-001825MAIN 1,050 92.1296,723.271,05096,723.27
Sept. 18, 2026issueSO-260918-677MAIN 134 91.91-12,316.5800.00 April 11, 2026: 134 @ 91.91
Sept. 14, 2026issueSO-260914-534MAIN 59 91.91-5,422.9713412,316.58 April 11, 2026: 59 @ 91.91
Aug. 19, 2026issueSO-260819-214MAIN 65 91.91-5,974.4619317,739.56 April 11, 2026: 65 @ 91.91
Aug. 9, 2026issueSO-260809-183MAIN 103 91.91-9,467.2225823,714.02 April 11, 2026: 103 @ 91.91
Aug. 2, 2026issueSO-260802-627MAIN 29 91.91-2,665.5336133,181.24 April 11, 2026: 29 @ 91.91
July 26, 2026issueSO-260726-366MAIN 3 91.91-275.7439035,846.77 April 11, 2026: 3 @ 91.91
July 24, 2026issueSO-260724-994MAIN 47 91.91-4,320.0039336,122.52 April 11, 2026: 47 @ 91.91
July 8, 2026issueSO-260708-915MAIN 141 91.91-12,959.9944040,442.51 April 11, 2026: 141 @ 91.91
June 20, 2026issueSO-260620-210MAIN 153 91.91-14,062.9658153,402.50 April 11, 2026: 153 @ 91.91
June 8, 2026issueSO-260608-122MAIN 14 91.91-1,286.8173467,465.46 April 11, 2026: 14 @ 91.91
May 29, 2026issueSO-260529-312MAIN 21 91.91-1,930.2174868,752.27 April 11, 2026: 21 @ 91.91
May 22, 2026issueSO-260522-288MAIN 10 91.91-919.1576970,682.48 April 11, 2026: 10 @ 91.91
May 16, 2026issueSO-260516-430MAIN 31 91.91-2,849.3677971,601.63 April 11, 2026: 31 @ 91.91
May 12, 2026issueSO-260512-935MAIN 29 91.91-2,665.5381074,450.99 April 11, 2026: 29 @ 91.91
May 9, 2026issueSO-260509-642MAIN 8 91.91-735.3283977,116.52 April 11, 2026: 8 @ 91.91
May 8, 2026issueSO-260508-412MAIN 146 91.91-13,419.5684777,851.84 April 11, 2026: 146 @ 91.91
April 26, 2026issueSO-260426-100MAIN 14 91.91-1,286.8199391,271.40 April 11, 2026: 14 @ 91.91
April 20, 2026issueSO-260420-489MAIN 43 91.91-3,952.341,00792,558.20 April 11, 2026: 43 @ 91.91
April 11, 2026receiptPO-001397MAIN 1,050 91.9196,510.541,05096,510.54
April 2, 2026issueSO-260402-531MAIN 14 92.80-1,299.2400.00 Dec. 28, 2025: 14 @ 92.80
March 29, 2026issueSO-260329-856MAIN 137 92.80-12,713.96141,299.24 Nov. 27, 2025: 100 @ 92.80; Dec. 28, 2025: 37 @ 92.80
March 22, 2026issueSO-260322-452MAIN 62 92.80-5,753.7615114,013.19 Nov. 27, 2025: 62 @ 92.80
March 19, 2026issueSO-260319-935MAIN 23 92.80-2,134.4621319,766.95 Nov. 27, 2025: 23 @ 92.80
March 18, 2026issueSO-260318-757MAIN 71 92.80-6,588.9823621,901.41 Nov. 27, 2025: 71 @ 92.80
March 11, 2026issueSO-260311-221MAIN 6 92.80-556.8230728,490.40 Nov. 27, 2025: 6 @ 92.80
Feb. 25, 2026issueSO-260225-526MAIN 35 92.80-3,248.0931329,047.21 Nov. 27, 2025: 35 @ 92.80
Feb. 10, 2026issueSO-260210-346MAIN 2 92.80-185.6134832,295.30 Nov. 27, 2025: 2 @ 92.80
Feb. 8, 2026issueSO-260208-781MAIN 50 92.80-4,640.1335032,480.91 Nov. 27, 2025: 50 @ 92.80
Feb. 3, 2026issueSO-260203-969MAIN 71 92.80-6,588.9840037,121.04 Nov. 27, 2025: 71 @ 92.80
Feb. 1, 2026issueSO-260201-317MAIN 128 92.80-11,878.7347143,710.02 Nov. 27, 2025: 128 @ 92.80
Jan. 29, 2026issueSO-260129-643MAIN 85 92.80-7,888.2259955,588.76 Nov. 27, 2025: 85 @ 92.80
Jan. 26, 2026issueSO-260126-626MAIN 215 92.80-19,952.5668463,476.98 Nov. 27, 2025: 215 @ 92.80
Dec. 28, 2025returnRMAMAIN 51 92.804,732.9389983,429.54
Dec. 21, 2025issueSO-251221-530MAIN 27 92.80-2,505.6784878,696.60 Nov. 27, 2025: 27 @ 92.80
Dec. 18, 2025issueSO-251218-209MAIN 94 92.80-8,723.4487581,202.28 Nov. 27, 2025: 94 @ 92.80
Dec. 9, 2025issueSO-251209-806MAIN 102 92.22-9,406.3196989,925.72 Aug. 12, 2025: 18 @ 89.97; Sept. 25, 2025: 3 @ 89.97; Nov. 27, 2025: 81 @ 92.80
Dec. 1, 2025issueSO-251201-172MAIN 105 89.97-9,446.491,07199,332.03 Aug. 12, 2025: 105 @ 89.97
Nov. 27, 2025issueSO-251127-937MAIN 35 89.97-3,148.831,176108,778.52 Aug. 12, 2025: 35 @ 89.97
Nov. 27, 2025receiptPO-001021MAIN 1,050 92.8097,442.731,211111,927.35
Nov. 22, 2025issueSO-251122-138MAIN 2 89.97-179.9316114,484.62 Aug. 12, 2025: 2 @ 89.97
Nov. 21, 2025issueSO-251121-812MAIN 212 89.97-19,072.9216314,664.56 Aug. 12, 2025: 212 @ 89.97
Nov. 16, 2025issueSO-251116-508MAIN 4 89.97-359.8737533,737.48 Aug. 12, 2025: 4 @ 89.97
Nov. 14, 2025issueSO-251114-376MAIN 71 89.97-6,387.6337934,097.34 Aug. 12, 2025: 71 @ 89.97
Nov. 9, 2025issueSO-251109-468MAIN 10 89.97-899.6745040,484.97 Aug. 12, 2025: 10 @ 89.97
Oct. 31, 2025issueSO-251031-304MAIN 12 89.97-1,079.6046041,384.64 Aug. 12, 2025: 12 @ 89.97
Oct. 27, 2025issueSO-251027-528MAIN 23 89.97-2,069.2347242,464.24 Aug. 12, 2025: 23 @ 89.97
Oct. 26, 2025issueSO-251026-630MAIN 27 89.97-2,429.1049544,533.47 Aug. 12, 2025: 27 @ 89.97
Oct. 18, 2025issueSO-251018-110MAIN 26 89.97-2,339.1352246,962.57 Aug. 12, 2025: 26 @ 89.97
Oct. 17, 2025issueSO-251017-195MAIN 33 89.97-2,968.9054849,301.70 Aug. 12, 2025: 33 @ 89.97
Oct. 11, 2025issueSO-251011-602MAIN 114 89.97-10,256.1958152,270.59 Aug. 12, 2025: 114 @ 89.97
Oct. 4, 2025issueSO-251004-468MAIN 88 89.97-7,917.0669562,526.79 Aug. 12, 2025: 88 @ 89.97
Sept. 28, 2025issueSO-250928-327MAIN 3 89.97-269.9078370,443.85 Aug. 12, 2025: 3 @ 89.97
Sept. 25, 2025returnRMAMAIN 3 89.97269.9078670,713.75
Sept. 16, 2025issueSO-250916-603MAIN 138 89.97-12,415.3978370,443.85 Aug. 12, 2025: 138 @ 89.97
Sept. 14, 2025issueSO-250914-703MAIN 21 89.97-1,889.3092182,859.24 Aug. 12, 2025: 21 @ 89.97
Sept. 14, 2025issueSO-250914-703EAST 7 89.97-629.7794284,748.54 Aug. 12, 2025: 7 @ 89.97
Sept. 9, 2025issueSO-250909-247EAST 98 89.97-8,816.7394985,378.30 Aug. 12, 2025: 98 @ 89.97
Aug. 23, 2025issueSO-250823-114MAIN 4 90.12-360.491,04794,195.03 May 4, 2025: 1 @ 90.59; Aug. 12, 2025: 3 @ 89.97
Aug. 16, 2025issueSO-250816-314MAIN 104 90.59-9,421.021,05194,555.52 May 4, 2025: 104 @ 90.59
Aug. 12, 2025receiptPO-000773MAIN 1,050 89.9794,464.931,155103,976.53
Aug. 7, 2025issueSO-250807-677EAST 95 90.59-8,605.741059,511.60 May 4, 2025: 95 @ 90.59
July 30, 2025issueSO-250730-303EAST 112 90.59-10,145.7120018,117.34 May 4, 2025: 112 @ 90.59
July 30, 2025issueSO-250730-303MAIN 28 90.59-2,536.4331228,263.05 May 4, 2025: 28 @ 90.59
July 18, 2025issueSO-250718-815MAIN 130 90.59-11,776.2734030,799.48 May 4, 2025: 130 @ 90.59
July 16, 2025issueSO-250716-812MAIN 42 90.59-3,804.6447042,575.75 May 4, 2025: 42 @ 90.59
July 12, 2025issueSO-250712-409MAIN 10 90.59-905.8751246,380.39 May 4, 2025: 10 @ 90.59
July 9, 2025issueSO-250709-620MAIN 83 90.59-7,518.7052247,286.26 May 4, 2025: 83 @ 90.59
July 5, 2025issueSO-250705-443MAIN 20 90.59-1,811.7360554,804.95 May 4, 2025: 20 @ 90.59
July 2, 2025issueSO-250702-768MAIN 9 90.59-815.2862556,616.69 May 4, 2025: 9 @ 90.59
June 30, 2025issueSO-250630-138EAST 44 90.59-3,985.8163457,431.97 May 4, 2025: 44 @ 90.59
June 19, 2025issueSO-250619-580MAIN 40 90.59-3,623.4767861,417.78 May 4, 2025: 40 @ 90.59
June 17, 2025issueSO-250617-739MAIN 64 90.59-5,797.5571865,041.25 May 4, 2025: 64 @ 90.59
June 16, 2025issueSO-250616-801MAIN 17 90.59-1,539.9778270,838.80 May 4, 2025: 17 @ 90.59
June 9, 2025issueSO-250609-997MAIN 14 90.59-1,268.2179972,378.77 May 4, 2025: 14 @ 90.59
June 8, 2025issueSO-250608-831MAIN 90 90.59-8,152.8081373,646.99 May 4, 2025: 90 @ 90.59
May 24, 2025issueSO-250524-820MAIN 14 90.59-1,268.2190381,799.79 May 4, 2025: 14 @ 90.59
May 22, 2025issueSO-250522-421MAIN 103 90.59-9,330.4391783,068.00 May 4, 2025: 103 @ 90.59
May 18, 2025issueSO-250518-280MAIN 69 87.49-6,036.501,02092,398.43 Dec. 17, 2024: 39 @ 85.10; May 4, 2025: 30 @ 90.59
May 11, 2025issueSO-250511-272MAIN 11 85.10-936.101,08998,434.94 Dec. 17, 2024: 11 @ 85.10
May 4, 2025transferTRFMAIN → EAST 356 warehouse transfer, no cost effect
May 4, 2025receiptPO-000510MAIN 1,050 90.5995,116.041,10099,371.04
April 27, 2025issueSO-250427-895MAIN 126 85.10-10,722.60504,255.00 Dec. 17, 2024: 126 @ 85.10
April 17, 2025issueSO-250417-784MAIN 166 85.10-14,126.6017614,977.60 Dec. 17, 2024: 166 @ 85.10
April 14, 2025issueSO-250414-978MAIN 38 85.10-3,233.8034229,104.20 Dec. 17, 2024: 38 @ 85.10
March 31, 2025issueSO-250331-154MAIN 13 85.10-1,106.3038032,338.00 Dec. 17, 2024: 13 @ 85.10
March 22, 2025issueSO-250322-425MAIN 106 85.10-9,020.6039333,444.30 Dec. 17, 2024: 106 @ 85.10
March 14, 2025issueSO-250314-891MAIN 66 85.10-5,616.6049942,464.90 Dec. 17, 2024: 66 @ 85.10
March 6, 2025issueSO-250306-386MAIN 61 85.10-5,191.1056548,081.50 Dec. 17, 2024: 61 @ 85.10
March 4, 2025issueSO-250304-170MAIN 4 85.10-340.4062653,272.60 Dec. 17, 2024: 4 @ 85.10
Feb. 28, 2025issueSO-250228-890MAIN 11 85.10-936.1063053,613.00 Dec. 17, 2024: 11 @ 85.10
Feb. 24, 2025issueSO-250224-269MAIN 9 85.10-765.9064154,549.10 Dec. 17, 2024: 9 @ 85.10
Feb. 19, 2025issueSO-250219-519MAIN 109 85.10-9,275.9065055,315.00 Dec. 17, 2024: 109 @ 85.10
Feb. 12, 2025issueSO-250212-731MAIN 18 85.10-1,531.8075964,590.90 Dec. 17, 2024: 18 @ 85.10
Feb. 5, 2025issueSO-250205-849MAIN 14 85.10-1,191.4077766,122.70 Dec. 17, 2024: 14 @ 85.10
Feb. 1, 2025issueSO-250201-368MAIN 77 85.10-6,552.7079167,314.10 Dec. 17, 2024: 77 @ 85.10
Jan. 28, 2025issueSO-250128-532MAIN 19 85.10-1,616.9086873,866.80 Dec. 17, 2024: 19 @ 85.10
Jan. 25, 2025issueSO-250125-649MAIN 26 85.10-2,212.6088775,483.70 Dec. 17, 2024: 26 @ 85.10
Jan. 16, 2025issueSO-250116-672MAIN 41 85.10-3,489.1091377,696.30 Dec. 17, 2024: 41 @ 85.10
Jan. 11, 2025issueSO-250111-259MAIN 144 86.72-12,487.4695481,185.40 Oct. 1, 2024: 48 @ 89.96; Dec. 17, 2024: 96 @ 85.10
Dec. 26, 2024issueSO-241226-625MAIN 69 89.96-6,206.931,09893,672.86 Oct. 1, 2024: 69 @ 89.96
Dec. 17, 2024issueSO-241217-112MAIN 79 89.96-7,106.481,16799,879.79 Oct. 1, 2024: 79 @ 89.96
Dec. 17, 2024receiptPO-000111MAIN 1,050 85.1089,355.001,246106,986.28
Dec. 12, 2024issueSO-241212-395MAIN 5 89.96-449.7819617,631.28 Oct. 1, 2024: 5 @ 89.96
Dec. 7, 2024issueSO-241207-217MAIN 195 89.96-17,541.3220118,081.06 Oct. 1, 2024: 195 @ 89.96
Dec. 3, 2024issueSO-241203-592MAIN 13 89.96-1,169.4239635,622.38 Oct. 1, 2024: 13 @ 89.96
Nov. 30, 2024issueSO-241130-351MAIN 110 89.96-9,895.1040936,791.80 Oct. 1, 2024: 110 @ 89.96
Nov. 26, 2024issueSO-241126-519MAIN 7 89.96-629.6951946,686.90 Oct. 1, 2024: 7 @ 89.96
Nov. 23, 2024issueSO-241123-852MAIN 19 89.96-1,709.1552647,316.59 Oct. 1, 2024: 19 @ 89.96
Nov. 16, 2024issueSO-241116-596MAIN 87 89.96-7,826.1354549,025.75 Oct. 1, 2024: 87 @ 89.96
Nov. 1, 2024issueSO-241101-438MAIN 87 89.96-7,826.1363256,851.88 Oct. 1, 2024: 87 @ 89.96
Oct. 30, 2024issueSO-241030-250MAIN 91 89.96-8,185.9571964,678.00 Oct. 1, 2024: 91 @ 89.96
Oct. 28, 2024issueSO-241028-833MAIN 240 89.96-21,589.3281072,863.96 Oct. 1, 2024: 240 @ 89.96
Oct. 1, 2024receiptPO-000001MAIN 1,050 89.9694,453.281,05094,453.28