stocksense

Items / LED-0016

Downlight 7W Pro LED-0016 · Lighting · BrightLine Lighting

On hand (EA)352MAIN 352
Value (FIFO)29,082.20avg 82.62
ClassAX / FCV 0.14
Turnover5.6xlast issue 2 days ago
Days of cover51lead time 10d

Demand and forecast

Monthly demand and forecast for LED-00160.091.9184276367Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 251.0Nov 24: 190.0Dec 24: 311.0Jan 25: 334.0Feb 25: 219.0Mar 25: 190.0Apr 25: 195.0May 25: 173.0Jun 25: 173.0Jul 25: 162.0Aug 25: 216.0Sep 25: 96.0Oct 25: 169.0Nov 25: 243.0Dec 25: 215.0Jan 26: 197.0Feb 26: 224.0Mar 26: 194.0Apr 26: 188.0May 26: 201.0Jun 26: 183.0Jul 26: 184.0Aug 26: 277.0Sep 26: 239.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.4375209.50 / 30.43756.883
Daily demand sdmonthly sd / sqrt(30.4375)29.88 / 5.5175.416
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 * 5.416^2 + 6.883^2 * 2.2^2)46.0
Reorder pointd * LT + safety stock6.883 * 9.6 + 46.0111.9
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days111.9
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 2512/yr, S = 45.00, h = 20%, price = 83.02116.7
Inventory positionon hand + on order352 + 0352

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

From qtyUnit costOrder qtyAnnual costFeasible
083.02117210,507yes (chosen if cheapest)

MOQ 810, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 4, 2026352 / 81082.6229,082.20

Movement ledger 122 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 14, 2026issueSO-261014-963MAIN 115 82.62-9,501.2935229,082.20 Sept. 4, 2026: 115 @ 82.62
Oct. 11, 2026issueSO-261011-324MAIN 102 82.62-8,427.2346738,583.49 Sept. 4, 2026: 102 @ 82.62
Oct. 2, 2026issueSO-261002-847MAIN 75 82.62-6,196.4956947,010.72 Sept. 4, 2026: 75 @ 82.62
Oct. 1, 2026issueSO-261001-485MAIN 2 82.62-165.2464453,207.22 Sept. 4, 2026: 2 @ 82.62
Sept. 20, 2026issueSO-260920-863MAIN 139 82.62-11,484.1764653,372.46 Sept. 4, 2026: 139 @ 82.62
Sept. 19, 2026issueSO-260919-592MAIN 45 81.54-3,669.3378564,856.62 May 16, 2026: 20 @ 80.19; Sept. 4, 2026: 25 @ 82.62
Sept. 15, 2026issueSO-260915-127MAIN 15 80.19-1,202.8783068,525.95 May 16, 2026: 15 @ 80.19
Sept. 13, 2026issueSO-260913-146MAIN 20 80.19-1,603.8384569,728.82 May 16, 2026: 20 @ 80.19
Sept. 6, 2026issueSO-260906-524MAIN 20 80.19-1,603.8386571,332.66 May 16, 2026: 20 @ 80.19
Sept. 4, 2026receiptPO-001774MAIN 810 82.6266,922.1288572,936.49
Aug. 25, 2026issueSO-260825-853MAIN 206 80.19-16,519.47756,014.37 May 16, 2026: 206 @ 80.19
Aug. 18, 2026issueSO-260818-639MAIN 58 80.19-4,651.1128122,533.84 May 16, 2026: 58 @ 80.19
Aug. 3, 2026issueSO-260803-894MAIN 1 80.19-80.1933927,184.95 May 16, 2026: 1 @ 80.19
Aug. 1, 2026issueSO-260801-678MAIN 12 80.19-962.3034027,265.14 May 16, 2026: 12 @ 80.19
July 22, 2026issueSO-260722-280MAIN 35 80.19-2,806.7135228,227.44 May 16, 2026: 35 @ 80.19
July 10, 2026issueSO-260710-167MAIN 127 80.19-10,184.3338731,034.15 May 16, 2026: 127 @ 80.19
July 8, 2026issueSO-260708-368MAIN 22 80.19-1,764.2251441,218.48 May 16, 2026: 22 @ 80.19
June 15, 2026issueSO-260615-825MAIN 109 80.19-8,740.8853642,982.70 May 16, 2026: 109 @ 80.19
June 4, 2026issueSO-260604-994MAIN 74 80.19-5,934.1864551,723.58 May 16, 2026: 74 @ 80.19
May 31, 2026issueSO-260531-512MAIN 58 80.19-4,651.1171957,657.76 May 16, 2026: 58 @ 80.19
May 26, 2026issueSO-260526-970MAIN 33 80.19-2,646.3277762,308.87 May 16, 2026: 33 @ 80.19
May 16, 2026receiptPO-001496MAIN 810 80.1964,955.2081064,955.20
May 11, 2026issueSO-260511-506MAIN 33 80.58-2,659.1000.00 Dec. 15, 2025: 33 @ 80.58
May 9, 2026issueSO-260509-569MAIN 77 80.58-6,204.57332,659.10 Dec. 15, 2025: 77 @ 80.58
April 28, 2026issueSO-260428-324MAIN 161 80.58-12,973.191108,863.67 Dec. 15, 2025: 161 @ 80.58
April 21, 2026issueSO-260421-964MAIN 8 80.58-644.6327121,836.85 Dec. 15, 2025: 8 @ 80.58
April 9, 2026issueSO-260409-544MAIN 19 80.58-1,531.0027922,481.49 Dec. 15, 2025: 19 @ 80.58
March 26, 2026issueSO-260326-714MAIN 64 80.58-5,157.0429824,012.48 Dec. 15, 2025: 64 @ 80.58
March 23, 2026issueSO-260323-361MAIN 23 80.58-1,853.3136229,169.53 Dec. 15, 2025: 23 @ 80.58
March 21, 2026issueSO-260321-593MAIN 44 80.58-3,545.4738531,022.84 Dec. 15, 2025: 44 @ 80.58
March 16, 2026issueSO-260316-689MAIN 20 80.58-1,611.5842934,568.31 Dec. 15, 2025: 20 @ 80.58
March 3, 2026issueSO-260303-979MAIN 33 80.58-2,659.1044936,179.88 Dec. 15, 2025: 33 @ 80.58
March 2, 2026issueSO-260302-345MAIN 10 80.58-805.7948238,838.98 Dec. 15, 2025: 10 @ 80.58
Feb. 17, 2026issueSO-260217-282MAIN 179 80.58-14,423.6149239,644.77 Dec. 15, 2025: 179 @ 80.58
Feb. 9, 2026issueSO-260209-272MAIN 45 80.58-3,626.0567154,068.37 Dec. 15, 2025: 45 @ 80.58
Jan. 28, 2026issueSO-260128-738MAIN 3 80.58-241.7471657,694.42 Dec. 15, 2025: 3 @ 80.58
Jan. 14, 2026issueSO-260114-458MAIN 132 79.51-10,495.6371957,936.16 Sept. 9, 2025: 26 @ 77.15; Dec. 9, 2025: 14 @ 77.15; Dec. 12, 2025: 1 @ 77.15; Dec. 15, 2025: 91 @ 80.58
Jan. 13, 2026issueSO-260113-377MAIN 62 77.15-4,783.0185168,431.79 Sept. 9, 2025: 62 @ 77.15
Dec. 30, 2025issueSO-251230-326MAIN 46 77.15-3,548.6891373,214.79 Sept. 9, 2025: 46 @ 77.15
Dec. 29, 2025issueSO-251229-103MAIN 17 77.15-1,311.4795976,763.48 Sept. 9, 2025: 17 @ 77.15
Dec. 15, 2025receiptPO-001054MAIN 810 80.5865,268.8397678,074.95
Dec. 12, 2025returnRMAMAIN 1 77.1577.1516612,806.12
Dec. 11, 2025issueSO-251211-726MAIN 2 77.15-154.2916512,728.97 Sept. 9, 2025: 2 @ 77.15
Dec. 9, 2025returnRMAMAIN 14 77.151,080.0316712,883.27
Dec. 4, 2025issueSO-251204-640MAIN 165 77.15-12,728.9715311,803.23 Sept. 9, 2025: 165 @ 77.15
Nov. 27, 2025issueSO-251127-470MAIN 2 77.15-154.2931824,532.21 Sept. 9, 2025: 2 @ 77.15
Nov. 22, 2025issueSO-251122-245MAIN 28 77.15-2,160.0732024,686.50 Sept. 9, 2025: 28 @ 77.15
Nov. 21, 2025issueSO-251121-747MAIN 140 77.15-10,800.3434826,846.56 Sept. 9, 2025: 140 @ 77.15
Nov. 16, 2025issueSO-251116-115MAIN 12 77.15-925.7448837,646.91 Sept. 9, 2025: 12 @ 77.15
Nov. 14, 2025issueSO-251114-491MAIN 42 77.15-3,240.1050038,572.65 Sept. 9, 2025: 42 @ 77.15
Nov. 3, 2025issueSO-251103-349MAIN 19 77.15-1,465.7654241,812.75 Sept. 9, 2025: 19 @ 77.15
Oct. 27, 2025issueSO-251027-683MAIN 77 77.15-5,940.1956143,278.51 Sept. 9, 2025: 77 @ 77.15
Oct. 22, 2025issueSO-251022-804MAIN 8 77.15-617.1663849,218.70 Sept. 9, 2025: 8 @ 77.15
Oct. 2, 2025issueSO-251002-678MAIN 84 77.15-6,480.2164649,835.86 Sept. 9, 2025: 84 @ 77.15
Sept. 27, 2025issueSO-250927-365MAIN 62 77.15-4,783.0173056,316.07 Sept. 9, 2025: 62 @ 77.15
Sept. 18, 2025issueSO-250918-963MAIN 5 77.15-385.7379261,099.08 Sept. 9, 2025: 5 @ 77.15
Sept. 15, 2025issueSO-250915-258MAIN 41 77.20-3,165.3379761,484.80 Sept. 5, 2025: 20 @ 77.23; Sept. 8, 2025: 8 @ 77.23; Sept. 9, 2025: 13 @ 77.15
Sept. 12, 2025issueSO-250912-465MAIN 13 77.23-1,003.9983864,650.13 Sept. 5, 2025: 13 @ 77.23
Sept. 9, 2025receiptPO-000824MAIN 810 77.1562,487.6985165,654.12
Sept. 8, 2025returnRMAMAIN 8 77.23617.84413,166.43
Sept. 5, 2025returnRMAMAIN 33 77.232,548.59332,548.59
Sept. 1, 2025issueSO-250901-858EAST 16 77.23-1,235.6800.00 April 10, 2025: 14 @ 77.23; May 2, 2025: 2 @ 77.23
Aug. 30, 2025issueSO-250830-750EAST 56 77.23-4,324.87161,235.68 April 10, 2025: 56 @ 77.23
Aug. 30, 2025issueSO-250830-750MAIN 66 77.23-5,097.17725,560.55 April 10, 2025: 66 @ 77.23
Aug. 12, 2025issueSO-250812-160MAIN 94 77.23-7,259.6113810,657.73 April 10, 2025: 94 @ 77.23
July 28, 2025issueSO-250728-471MAIN 33 77.23-2,548.5923217,917.34 April 10, 2025: 33 @ 77.23
July 24, 2025issueSO-250724-336EAST 119 77.23-9,190.3626520,465.92 April 10, 2025: 119 @ 77.23
July 1, 2025issueSO-250701-973MAIN 10 77.23-772.3038429,656.28 April 10, 2025: 10 @ 77.23
June 23, 2025issueSO-250623-702MAIN 73 77.23-5,637.7839430,428.58 April 10, 2025: 73 @ 77.23
June 21, 2025issueSO-250621-242MAIN 19 77.23-1,467.3746736,066.36 April 10, 2025: 19 @ 77.23
June 6, 2025issueSO-250606-267MAIN 81 77.23-6,255.6248637,533.73 April 10, 2025: 81 @ 77.23
May 26, 2025issueSO-250526-411MAIN 31 77.23-2,394.1356743,789.35 April 10, 2025: 31 @ 77.23
May 22, 2025issueSO-250522-282MAIN 14 77.23-1,081.2259846,183.48 April 10, 2025: 14 @ 77.23
May 10, 2025issueSO-250510-965MAIN 11 77.23-849.5361247,264.70 April 10, 2025: 11 @ 77.23
May 8, 2025issueSO-250508-542MAIN 101 77.23-7,800.2262348,114.23 April 10, 2025: 101 @ 77.23
May 4, 2025issueSO-250504-665MAIN 18 77.23-1,390.1472455,914.45 April 10, 2025: 18 @ 77.23
May 2, 2025returnRMAMAIN 2 77.23154.4674257,304.59
April 30, 2025issueSO-250430-382MAIN 11 77.23-849.5374057,150.13 April 10, 2025: 11 @ 77.23
April 28, 2025issueSO-250428-441MAIN 4 77.23-308.9275157,999.65 April 10, 2025: 4 @ 77.23
April 14, 2025issueSO-250414-549MAIN 55 77.23-4,247.6475558,308.57 April 10, 2025: 55 @ 77.23
April 10, 2025transferTRFMAIN → EAST 191 warehouse transfer, no cost effect
April 10, 2025receiptPO-000432MAIN 810 77.2362,556.2281062,556.22
April 8, 2025issueSO-250408-635MAIN 37 76.33-2,824.3500.00 Dec. 30, 2024: 15 @ 76.33; Feb. 9, 2025: 22 @ 76.33
April 1, 2025issueSO-250401-631MAIN 88 76.33-6,717.37372,824.35 Dec. 30, 2024: 88 @ 76.33
March 17, 2025issueSO-250317-494MAIN 21 76.33-1,603.011259,541.72 Dec. 30, 2024: 21 @ 76.33
March 13, 2025issueSO-250313-399MAIN 6 76.33-458.0014611,144.73 Dec. 30, 2024: 6 @ 76.33
March 12, 2025issueSO-250312-629MAIN 61 76.33-4,656.3615211,602.74 Dec. 30, 2024: 61 @ 76.33
March 8, 2025issueSO-250308-782MAIN 102 76.33-7,786.0521316,259.10 Dec. 30, 2024: 102 @ 76.33
Feb. 19, 2025issueSO-250219-368MAIN 45 76.33-3,435.0231524,045.15 Dec. 30, 2024: 45 @ 76.33
Feb. 17, 2025issueSO-250217-611MAIN 1 76.33-76.3336027,480.17 Dec. 30, 2024: 1 @ 76.33
Feb. 12, 2025issueSO-250212-188MAIN 28 76.33-2,137.3536127,556.50 Dec. 30, 2024: 28 @ 76.33
Feb. 10, 2025issueSO-250210-196MAIN 9 76.33-687.0038929,693.85 Dec. 30, 2024: 9 @ 76.33
Feb. 9, 2025returnRMAMAIN 22 76.331,679.3439830,380.85
Feb. 7, 2025issueSO-250207-906MAIN 1 76.33-76.3337628,701.51 Dec. 30, 2024: 1 @ 76.33
Feb. 3, 2025issueSO-250203-243MAIN 70 76.33-5,343.3737728,777.84 Dec. 30, 2024: 70 @ 76.33
Feb. 2, 2025issueSO-250202-741MAIN 43 76.33-3,282.3544734,121.21 Dec. 30, 2024: 43 @ 76.33
Feb. 2, 2025issueSO-250202-741EAST 44 76.33-3,358.6949037,403.56 Dec. 30, 2024: 44 @ 76.33
Jan. 31, 2025issueSO-250131-626MAIN 31 76.33-2,366.3553440,762.25 Dec. 30, 2024: 31 @ 76.33
Jan. 24, 2025issueSO-250124-592EAST 172 76.33-13,129.4156543,128.60 Dec. 30, 2024: 172 @ 76.33
Jan. 20, 2025issueSO-250120-929MAIN 12 76.33-916.0173756,258.01 Dec. 30, 2024: 12 @ 76.33
Jan. 3, 2025issueSO-250103-205MAIN 47 76.33-3,587.6974957,174.02 Dec. 30, 2024: 47 @ 76.33
Jan. 1, 2025issueSO-250101-201MAIN 72 78.38-5,643.0879660,761.70 Oct. 1, 2024: 58 @ 78.87; Dec. 30, 2024: 14 @ 76.33
Dec. 30, 2024transferTRFMAIN → EAST 211 warehouse transfer, no cost effect
Dec. 30, 2024receiptPO-000149MAIN 810 76.3361,830.3886866,404.78
Dec. 23, 2024issueSO-241223-189MAIN 95 78.87-7,492.56584,574.40 Oct. 1, 2024: 95 @ 78.87
Dec. 19, 2024issueSO-241219-268MAIN 18 78.87-1,419.6415312,066.96 Oct. 1, 2024: 18 @ 78.87
Dec. 11, 2024issueSO-241211-722EAST 125 78.87-9,858.6217113,486.60 Oct. 1, 2024: 125 @ 78.87
Dec. 7, 2024issueSO-241207-630MAIN 36 78.87-2,839.2829623,345.22 Oct. 1, 2024: 36 @ 78.87
Dec. 6, 2024issueSO-241206-104MAIN 20 78.87-1,577.3833226,184.51 Oct. 1, 2024: 20 @ 78.87
Dec. 2, 2024issueSO-241202-201MAIN 17 78.87-1,340.7735227,761.89 Oct. 1, 2024: 17 @ 78.87
Nov. 25, 2024issueSO-241125-746EAST 73 78.87-5,757.4436929,102.66 Oct. 1, 2024: 73 @ 78.87
Nov. 13, 2024issueSO-241113-264MAIN 60 78.87-4,732.1444234,860.10 Oct. 1, 2024: 60 @ 78.87
Nov. 12, 2024issueSO-241112-246EAST 25 78.87-1,971.7250239,592.24 Oct. 1, 2024: 25 @ 78.87
Nov. 10, 2024issueSO-241110-926MAIN 8 78.87-630.9552741,563.96 Oct. 1, 2024: 8 @ 78.87
Nov. 8, 2024issueSO-241108-469MAIN 20 78.87-1,577.3853542,194.92 Oct. 1, 2024: 20 @ 78.87
Nov. 1, 2024issueSO-241101-857MAIN 4 78.87-315.4855543,772.30 Oct. 1, 2024: 4 @ 78.87
Oct. 31, 2024issueSO-241031-627EAST 49 78.87-3,864.5855944,087.77 Oct. 1, 2024: 49 @ 78.87
Oct. 30, 2024issueSO-241030-733MAIN 67 78.87-5,284.2260847,952.35 Oct. 1, 2024: 67 @ 78.87
Oct. 8, 2024issueSO-241008-208MAIN 129 78.87-10,174.1067553,236.58 Oct. 1, 2024: 129 @ 78.87
Oct. 2, 2024issueSO-241002-570MAIN 6 78.87-473.2180463,410.68 Oct. 1, 2024: 6 @ 78.87
Oct. 1, 2024transferTRFMAIN → EAST 277 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000001MAIN 810 78.8763,883.8981063,883.89