stocksense

Items / LED-0021

Panel Light 15W Lite LED-0021 · Lighting · BrightLine Lighting

On hand (EA)325MAIN 325
Value (FIFO)44,113.84avg 135.73
ClassAX / FCV 0.23
Turnover5.8xlast issue 0 days ago
Days of cover58lead time 10d

Demand and forecast

Monthly demand and forecast for LED-00210.069.0138207276Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 179.0Nov 24: 191.0Dec 24: 231.0Jan 25: 251.0Feb 25: 210.0Mar 25: 109.0Apr 25: 142.0May 25: 126.0Jun 25: 147.0Jul 25: 88.0Aug 25: 187.0Sep 25: 207.0Oct 25: 221.0Nov 25: 178.0Dec 25: 191.0Jan 26: 228.0Feb 26: 156.0Mar 26: 219.0Apr 26: 123.0May 26: 116.0Jun 26: 192.0Jul 26: 133.0Aug 26: 135.0Sep 26: 143.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.4375169.58 / 30.43755.572
Daily demand sdmonthly sd / sqrt(30.4375)38.73 / 5.5177.019
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 * 7.019^2 + 5.572^2 * 2.2^2)51.0
Reorder pointd * LT + safety stock5.572 * 9.6 + 51.0104.4
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days104.4
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 2034/yr, S = 45.00, h = 20%, price = 136.9481.7
Inventory positionon hand + on order325 + 0325

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

From qtyUnit costOrder qtyAnnual costFeasible
0136.9482280,721yes (chosen if cheapest)

MOQ 660, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Aug. 26, 2026325 / 660135.7344,113.84

Movement ledger 120 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026issueSO-261016-872MAIN 21 135.73-2,850.4332544,113.84 Aug. 26, 2026: 21 @ 135.73
Oct. 7, 2026issueSO-261007-663MAIN 29 135.73-3,936.3134646,964.28 Aug. 26, 2026: 29 @ 135.73
Oct. 6, 2026issueSO-261006-925MAIN 7 135.73-950.1437550,900.59 Aug. 26, 2026: 7 @ 135.73
Oct. 3, 2026issueSO-261003-170MAIN 74 135.73-10,044.3838251,850.73 Aug. 26, 2026: 74 @ 135.73
Oct. 2, 2026issueSO-261002-336MAIN 61 135.73-8,279.8345661,895.11 Aug. 26, 2026: 61 @ 135.73
Sept. 26, 2026issueSO-260926-477MAIN 37 135.73-5,022.1951770,174.94 Aug. 26, 2026: 37 @ 135.73
Sept. 25, 2026issueSO-260925-571MAIN 46 135.73-6,243.8155475,197.13 Aug. 26, 2026: 46 @ 135.73
Sept. 14, 2026issueSO-260914-350MAIN 7 135.73-950.1460081,440.94 Aug. 26, 2026: 7 @ 135.73
Sept. 12, 2026issueSO-260912-275MAIN 1 135.73-135.7360782,391.08 Aug. 26, 2026: 1 @ 135.73
Sept. 11, 2026issueSO-260911-653MAIN 9 135.73-1,221.6160882,526.82 Aug. 26, 2026: 9 @ 135.73
Sept. 9, 2026issueSO-260909-258MAIN 43 135.73-5,836.6061783,748.43 Aug. 26, 2026: 43 @ 135.73
Aug. 26, 2026receiptPO-001748MAIN 660 135.7389,585.0366089,585.03
Aug. 18, 2026issueSO-260818-148MAIN 90 129.87-11,688.3200.00 March 30, 2026: 90 @ 129.87
Aug. 7, 2026issueSO-260807-660MAIN 45 129.87-5,844.169011,688.32 March 30, 2026: 45 @ 129.87
July 9, 2026issueSO-260709-449MAIN 112 129.87-14,545.4613517,532.48 March 30, 2026: 112 @ 129.87
July 7, 2026issueSO-260707-862MAIN 21 129.87-2,727.2724732,077.94 March 30, 2026: 21 @ 129.87
June 21, 2026issueSO-260621-968MAIN 33 129.87-4,285.7226834,805.21 March 30, 2026: 33 @ 129.87
June 18, 2026issueSO-260618-759MAIN 52 129.87-6,753.2530139,090.93 March 30, 2026: 52 @ 129.87
June 15, 2026issueSO-260615-414MAIN 68 129.87-8,831.1735345,844.18 March 30, 2026: 68 @ 129.87
June 7, 2026issueSO-260607-763MAIN 24 129.87-3,116.8842154,675.35 March 30, 2026: 24 @ 129.87
June 7, 2026issueSO-260607-763EAST 15 129.87-1,948.0544557,792.24 March 30, 2026: 15 @ 129.87
May 26, 2026issueSO-260526-553MAIN 18 129.87-2,337.6646059,740.29 March 30, 2026: 18 @ 129.87
May 24, 2026issueSO-260524-929MAIN 98 129.87-12,727.2847862,077.96 March 30, 2026: 98 @ 129.87
April 29, 2026issueSO-260429-309MAIN 43 129.87-5,584.4257674,805.24 March 30, 2026: 43 @ 129.87
April 21, 2026issueSO-260421-391MAIN 70 130.17-9,112.0461980,389.65 Dec. 17, 2025: 29 @ 130.60; March 30, 2026: 41 @ 129.87
April 15, 2026issueSO-260415-249MAIN 1 130.60-130.6068989,501.70 Dec. 17, 2025: 1 @ 130.60
April 11, 2026issueSO-260411-324MAIN 9 130.60-1,175.3969089,632.30 Dec. 17, 2025: 9 @ 130.60
March 30, 2026receiptPO-001366MAIN 660 129.8785,714.3369990,807.69
March 26, 2026issueSO-260326-213MAIN 54 130.60-7,052.34395,093.35 Dec. 17, 2025: 54 @ 130.60
March 21, 2026issueSO-260321-382MAIN 154 130.60-20,112.229312,145.69 Dec. 17, 2025: 154 @ 130.60
March 11, 2026issueSO-260311-749EAST 11 130.60-1,436.5924732,257.90 Dec. 17, 2025: 11 @ 130.60
Feb. 22, 2026issueSO-260222-857MAIN 13 130.60-1,697.7825833,694.49 Dec. 17, 2025: 13 @ 130.60
Feb. 18, 2026issueSO-260218-864MAIN 36 130.60-4,701.5627135,392.27 Dec. 17, 2025: 36 @ 130.60
Feb. 13, 2026issueSO-260213-164MAIN 106 130.60-13,843.4730740,093.83 Dec. 17, 2025: 106 @ 130.60
Feb. 3, 2026issueSO-260203-329MAIN 1 130.60-130.6041353,937.30 Dec. 17, 2025: 1 @ 130.60
Jan. 30, 2026issueSO-260130-658MAIN 76 130.60-9,925.5141454,067.90 Dec. 17, 2025: 76 @ 130.60
Jan. 27, 2026issueSO-260127-164MAIN 5 130.60-652.9949063,993.41 Dec. 17, 2025: 5 @ 130.60
Jan. 17, 2026issueSO-260117-187MAIN 100 130.60-13,059.8849564,646.41 Dec. 17, 2025: 100 @ 130.60
Jan. 5, 2026issueSO-260105-698EAST 41 130.60-5,354.5559577,706.29 Dec. 17, 2025: 41 @ 130.60
Jan. 2, 2026issueSO-260102-617EAST 6 130.60-783.5963683,060.84 Dec. 17, 2025: 6 @ 130.60
Dec. 31, 2025issueSO-251231-135MAIN 56 132.28-7,407.6164283,844.43 Sept. 16, 2025: 3 @ 133.07; Sept. 24, 2025: 9 @ 133.07; Oct. 12, 2025: 26 @ 133.07; Dec. 17, 2025: 18 @ 130.60
Dec. 30, 2025issueSO-251230-961EAST 42 133.07-5,589.1369891,252.04 Sept. 16, 2025: 42 @ 133.07
Dec. 24, 2025issueSO-251224-809EAST 42 133.07-5,589.1374096,841.18 Sept. 16, 2025: 42 @ 133.07
Dec. 17, 2025transferTRFMAIN → EAST 157 warehouse transfer, no cost effect
Dec. 17, 2025receiptPO-001058MAIN 660 130.6086,195.21782102,430.31
Dec. 16, 2025issueSO-251216-642MAIN 5 133.07-665.3712216,235.10 Sept. 16, 2025: 5 @ 133.07
Dec. 8, 2025issueSO-251208-352MAIN 3 133.07-399.2212716,900.47 Sept. 16, 2025: 3 @ 133.07
Dec. 5, 2025issueSO-251205-645MAIN 19 133.07-2,528.4213017,299.70 Sept. 16, 2025: 19 @ 133.07
Dec. 3, 2025issueSO-251203-180MAIN 24 133.07-3,193.7914919,828.12 Sept. 16, 2025: 24 @ 133.07
Nov. 30, 2025issueSO-251130-759MAIN 44 133.07-5,855.2817323,021.91 Sept. 16, 2025: 44 @ 133.07
Nov. 14, 2025issueSO-251114-104MAIN 125 133.07-16,634.3221728,877.19 Sept. 16, 2025: 125 @ 133.07
Nov. 5, 2025issueSO-251105-687MAIN 9 133.07-1,197.6734245,511.51 Sept. 16, 2025: 9 @ 133.07
Oct. 29, 2025issueSO-251029-663MAIN 10 133.07-1,330.7535146,709.18 Sept. 16, 2025: 10 @ 133.07
Oct. 14, 2025issueSO-251014-501MAIN 106 133.07-14,105.9136148,039.93 Sept. 16, 2025: 106 @ 133.07
Oct. 12, 2025returnRMAMAIN 26 133.073,459.9446762,145.84
Oct. 11, 2025issueSO-251011-618MAIN 71 133.07-9,448.3044158,685.90 Sept. 16, 2025: 71 @ 133.07
Oct. 9, 2025issueSO-251009-169MAIN 53 133.07-7,052.9551268,134.20 Sept. 16, 2025: 53 @ 133.07
Oct. 5, 2025issueSO-251005-182MAIN 7 133.07-931.5256575,187.15 Sept. 16, 2025: 7 @ 133.07
Sept. 24, 2025returnRMAMAIN 9 133.071,197.6757276,118.67
Sept. 22, 2025issueSO-250922-413MAIN 76 133.07-10,113.6756374,921.00 Sept. 16, 2025: 76 @ 133.07
Sept. 18, 2025issueSO-250918-352MAIN 23 132.64-3,050.6463985,034.67 Aug. 16, 2025: 2 @ 128.04; Sept. 16, 2025: 21 @ 133.07
Sept. 16, 2025issueSO-250916-843MAIN 18 128.04-2,304.6866288,085.31 April 8, 2025: 13 @ 128.04; Aug. 16, 2025: 5 @ 128.04
Sept. 16, 2025receiptPO-000846MAIN 660 133.0787,829.2468090,389.99
Sept. 12, 2025issueSO-250912-870MAIN 33 128.04-4,225.25202,560.76 April 8, 2025: 33 @ 128.04
Sept. 5, 2025issueSO-250905-540MAIN 35 128.04-4,481.33536,786.01 April 8, 2025: 35 @ 128.04
Sept. 3, 2025issueSO-250903-113MAIN 31 128.04-3,969.178811,267.34 April 8, 2025: 31 @ 128.04
Aug. 25, 2025issueSO-250825-331MAIN 79 128.04-10,114.9911915,236.51 April 8, 2025: 79 @ 128.04
Aug. 24, 2025issueSO-250824-677MAIN 4 128.04-512.1519825,351.50 April 8, 2025: 4 @ 128.04
Aug. 20, 2025issueSO-250820-100MAIN 77 128.04-9,858.9220225,863.66 April 8, 2025: 77 @ 128.04
Aug. 18, 2025issueSO-250818-417MAIN 9 128.04-1,152.3427935,722.57 April 8, 2025: 9 @ 128.04
Aug. 18, 2025issueSO-250818-417EAST 25 128.04-3,200.9528836,874.92 April 8, 2025: 25 @ 128.04
Aug. 16, 2025returnRMAMAIN 7 128.04896.2731340,075.86
July 29, 2025issueSO-250729-602MAIN 14 128.04-1,792.5330639,179.60 April 8, 2025: 14 @ 128.04
July 18, 2025issueSO-250718-459MAIN 7 128.04-896.2732040,972.13 April 8, 2025: 7 @ 128.04
July 14, 2025issueSO-250714-864EAST 61 128.04-7,810.3132741,868.39 April 8, 2025: 61 @ 128.04
July 1, 2025issueSO-250701-790MAIN 6 128.04-768.2338849,678.71 April 8, 2025: 6 @ 128.04
June 15, 2025issueSO-250615-795EAST 15 128.04-1,920.5739450,446.93 April 8, 2025: 15 @ 128.04
June 10, 2025issueSO-250610-184MAIN 55 128.04-7,042.0840952,367.50 April 8, 2025: 55 @ 128.04
June 9, 2025issueSO-250609-965MAIN 13 128.04-1,664.4946459,409.59 April 8, 2025: 13 @ 128.04
June 3, 2025issueSO-250603-675MAIN 64 128.04-8,194.4347761,074.08 April 8, 2025: 64 @ 128.04
May 27, 2025issueSO-250527-734EAST 66 128.04-8,450.5054169,268.50 April 8, 2025: 66 @ 128.04
May 23, 2025issueSO-250523-979MAIN 6 128.04-768.2360777,719.01 April 8, 2025: 6 @ 128.04
May 22, 2025issueSO-250522-609EAST 4 128.04-512.1561378,487.23 April 8, 2025: 4 @ 128.04
May 19, 2025issueSO-250519-122MAIN 24 128.04-3,072.9161778,999.38 April 8, 2025: 24 @ 128.04
May 15, 2025issueSO-250515-429MAIN 26 128.52-3,341.4364182,072.29 Jan. 2, 2025: 7 @ 129.82; April 8, 2025: 19 @ 128.04
April 28, 2025issueSO-250428-594EAST 9 129.82-1,168.3466785,413.72 Jan. 2, 2025: 9 @ 129.82
April 24, 2025issueSO-250424-125EAST 11 129.82-1,427.9767686,582.06 Jan. 2, 2025: 11 @ 129.82
April 18, 2025issueSO-250418-493MAIN 1 129.82-129.8268788,010.02 Jan. 2, 2025: 1 @ 129.82
April 12, 2025issueSO-250412-203MAIN 46 129.82-5,971.5068888,139.84 Jan. 2, 2025: 46 @ 129.82
April 8, 2025transferTRFMAIN → EAST 191 warehouse transfer, no cost effect
April 8, 2025receiptPO-000422MAIN 660 128.0484,505.0173494,111.34
April 3, 2025issueSO-250403-520MAIN 75 129.82-9,736.14749,606.32 Jan. 2, 2025: 75 @ 129.82
March 29, 2025issueSO-250329-577MAIN 19 129.82-2,466.4914919,342.46 Jan. 2, 2025: 19 @ 129.82
March 8, 2025issueSO-250308-253MAIN 25 129.82-3,245.3816821,808.95 Jan. 2, 2025: 25 @ 129.82
March 2, 2025issueSO-250302-731MAIN 65 129.82-8,437.9919325,054.33 Jan. 2, 2025: 65 @ 129.82
Feb. 23, 2025issueSO-250223-246MAIN 12 129.82-1,557.7825833,492.32 Jan. 2, 2025: 12 @ 129.82
Feb. 16, 2025issueSO-250216-846MAIN 58 129.82-7,529.2827035,050.10 Jan. 2, 2025: 58 @ 129.82
Feb. 12, 2025issueSO-250212-619MAIN 48 129.82-6,231.1332842,579.39 Jan. 2, 2025: 48 @ 129.82
Feb. 8, 2025issueSO-250208-192MAIN 92 129.82-11,943.0037648,810.52 Jan. 2, 2025: 92 @ 129.82
Jan. 26, 2025issueSO-250126-135MAIN 8 129.82-1,038.5246860,753.51 Jan. 2, 2025: 8 @ 129.82
Jan. 20, 2025issueSO-250120-810MAIN 91 129.82-11,813.1847661,792.04 Jan. 2, 2025: 91 @ 129.82
Jan. 12, 2025issueSO-250112-597MAIN 120 129.88-15,585.3256773,605.22 Oct. 1, 2024: 27 @ 130.09; Jan. 2, 2025: 93 @ 129.82
Jan. 10, 2025issueSO-250110-653MAIN 24 130.09-3,122.2368789,190.54 Oct. 1, 2024: 24 @ 130.09
Jan. 8, 2025issueSO-250108-754MAIN 8 130.09-1,040.7471192,312.78 Oct. 1, 2024: 8 @ 130.09
Jan. 2, 2025receiptPO-000156MAIN 660 129.8285,678.0371993,353.52
Dec. 27, 2024issueSO-241227-707MAIN 49 130.09-6,374.56597,675.49 Oct. 1, 2024: 49 @ 130.09
Dec. 24, 2024issueSO-241224-517MAIN 109 130.09-14,180.1410814,050.04 Oct. 1, 2024: 109 @ 130.09
Dec. 2, 2024issueSO-241202-494MAIN 73 130.09-9,496.7921728,230.18 Oct. 1, 2024: 73 @ 130.09
Nov. 28, 2024issueSO-241128-736MAIN 18 130.09-2,341.6729037,726.97 Oct. 1, 2024: 18 @ 130.09
Nov. 20, 2024issueSO-241120-526MAIN 38 130.09-4,943.5330840,068.64 Oct. 1, 2024: 38 @ 130.09
Nov. 14, 2024issueSO-241114-736MAIN 19 130.09-2,471.7734645,012.18 Oct. 1, 2024: 19 @ 130.09
Nov. 12, 2024issueSO-241112-565MAIN 2 130.09-260.1936547,483.94 Oct. 1, 2024: 2 @ 130.09
Nov. 4, 2024issueSO-241104-193MAIN 54 130.09-7,025.0236747,744.13 Oct. 1, 2024: 54 @ 130.09
Nov. 3, 2024issueSO-241103-910MAIN 19 130.09-2,471.7742154,769.15 Oct. 1, 2024: 19 @ 130.09
Nov. 2, 2024issueSO-241102-600MAIN 41 130.09-5,333.8144057,240.92 Oct. 1, 2024: 41 @ 130.09
Oct. 29, 2024issueSO-241029-755MAIN 22 130.09-2,862.0548162,574.73 Oct. 1, 2024: 22 @ 130.09
Oct. 28, 2024issueSO-241028-289MAIN 11 130.09-1,431.0250365,436.78 Oct. 1, 2024: 11 @ 130.09
Oct. 19, 2024issueSO-241019-900MAIN 6 130.09-780.5651466,867.80 Oct. 1, 2024: 6 @ 130.09
Oct. 16, 2024issueSO-241016-721MAIN 140 130.09-18,213.0252067,648.36 Oct. 1, 2024: 140 @ 130.09
Oct. 1, 2024receiptPO-000001MAIN 660 130.0985,861.3866085,861.38