stocksense

Items / LED-0017

Downlight 7W Lite LED-0017 · Lighting · BrightLine Lighting

On hand (EA)39MAIN 39
Value (FIFO)1,573.63avg 40.35
ClassBX / FCV 0.25
Turnover5.1xlast issue 2 days ago
Days of cover47lead time 10d

Demand and forecast

Monthly demand and forecast for LED-00170.09.418.728.137.4Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 28.0Nov 24: 30.0Dec 24: 28.0Jan 25: 22.0Feb 25: 20.0Mar 25: 26.0Apr 25: 13.0May 25: 14.0Jun 25: 15.0Jul 25: 16.0Aug 25: 28.0Sep 25: 21.0Oct 25: 34.0Nov 25: 31.0Dec 25: 33.0Jan 26: 30.0Feb 26: 29.0Mar 26: 27.0Apr 26: 12.0May 26: 21.0Jun 26: 21.0Jul 26: 23.0Aug 26: 18.0Sep 26: 24.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.437525.25 / 30.43750.830
Daily demand sdmonthly sd / sqrt(30.4375)6.33 / 5.5171.147
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.147^2 + 0.830^2 * 2.2^2)6.5
Reorder pointd * LT + safety stock0.830 * 9.6 + 6.514.5
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days14.5
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 303/yr, S = 45.00, h = 20%, price = 41.1257.6
Inventory positionon hand + on order39 + 039

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

From qtyUnit costOrder qtyAnnual costFeasible
041.125812,924yes (chosen if cheapest)

MOQ 90, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Aug. 21, 202639 / 9040.351,573.63

Movement ledger 123 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 14, 2026issueSO-261014-135MAIN 7 40.35-282.45391,573.63 Aug. 21, 2026: 7 @ 40.35
Oct. 4, 2026issueSO-261004-570MAIN 1 40.35-40.35461,856.08 Aug. 21, 2026: 1 @ 40.35
Oct. 3, 2026issueSO-261003-205MAIN 2 40.35-80.70471,896.43 Aug. 21, 2026: 2 @ 40.35
Oct. 2, 2026issueSO-261002-115MAIN 17 40.35-685.94491,977.13 Aug. 21, 2026: 17 @ 40.35
Sept. 30, 2026issueSO-260930-206MAIN 16 40.35-645.59662,663.07 Aug. 21, 2026: 16 @ 40.35
Sept. 21, 2026issueSO-260921-333MAIN 1 40.35-40.35823,308.67 Aug. 21, 2026: 1 @ 40.35
Sept. 20, 2026issueSO-260920-279MAIN 1 40.35-40.35833,349.02 Aug. 21, 2026: 1 @ 40.35
Sept. 10, 2026issueSO-260910-744MAIN 1 40.35-40.35843,389.37 Aug. 21, 2026: 1 @ 40.35
Sept. 5, 2026issueSO-260905-818MAIN 2 40.35-80.70853,429.72 Aug. 21, 2026: 2 @ 40.35
Sept. 2, 2026issueSO-260902-389MAIN 3 40.35-121.05873,510.42 Aug. 21, 2026: 3 @ 40.35
Aug. 21, 2026receiptPO-001731MAIN 90 40.353,631.46903,631.46
Aug. 13, 2026issueSO-260813-795MAIN 16 41.09-657.3800.00 April 3, 2026: 13 @ 41.38; April 13, 2026: 3 @ 39.80
Aug. 2, 2026issueSO-260802-216MAIN 2 41.38-82.7616657.38 April 3, 2026: 2 @ 41.38
July 24, 2026issueSO-260724-257MAIN 1 41.38-41.3818740.14 April 3, 2026: 1 @ 41.38
July 22, 2026issueSO-260722-228MAIN 9 41.38-372.4419781.52 April 3, 2026: 9 @ 41.38
July 14, 2026issueSO-260714-998MAIN 5 41.38-206.91281,153.96 April 3, 2026: 5 @ 41.38
July 8, 2026issueSO-260708-960MAIN 8 41.38-331.06331,360.87 April 3, 2026: 8 @ 41.38
June 27, 2026issueSO-260627-918MAIN 3 41.38-124.15411,691.93 April 3, 2026: 3 @ 41.38
June 24, 2026issueSO-260624-860MAIN 5 41.38-206.91441,816.07 April 3, 2026: 5 @ 41.38
June 19, 2026issueSO-260619-158MAIN 2 41.38-82.76492,022.98 April 3, 2026: 2 @ 41.38
June 16, 2026issueSO-260616-443MAIN 1 41.38-41.38512,105.74 April 3, 2026: 1 @ 41.38
June 12, 2026issueSO-260612-718MAIN 5 41.38-206.91522,147.13 April 3, 2026: 5 @ 41.38
June 9, 2026issueSO-260609-451MAIN 5 41.38-206.91572,354.04 April 3, 2026: 5 @ 41.38
May 30, 2026issueSO-260530-102MAIN 2 41.38-82.76622,560.95 April 3, 2026: 2 @ 41.38
May 25, 2026issueSO-260525-596MAIN 2 41.38-82.76642,643.71 April 3, 2026: 2 @ 41.38
May 23, 2026issueSO-260523-453MAIN 1 41.38-41.38662,726.47 April 3, 2026: 1 @ 41.38
May 17, 2026issueSO-260517-983MAIN 4 41.38-165.53672,767.86 April 3, 2026: 4 @ 41.38
May 16, 2026issueSO-260516-933MAIN 7 41.38-289.67712,933.38 April 3, 2026: 7 @ 41.38
May 9, 2026issueSO-260509-929MAIN 5 41.38-206.91783,223.06 April 3, 2026: 5 @ 41.38
April 26, 2026issueSO-260426-723MAIN 8 41.38-331.06833,429.97 April 3, 2026: 8 @ 41.38
April 25, 2026issueSO-260425-517MAIN 2 41.38-82.76913,761.02 April 3, 2026: 2 @ 41.38
April 13, 2026returnRMAMAIN 3 39.80119.41933,843.78
April 3, 2026receiptPO-001378MAIN 90 41.383,724.37903,724.37
April 1, 2026issueSO-260401-374MAIN 5 39.80-199.0200.00 Dec. 23, 2025: 5 @ 39.80
March 29, 2026issueSO-260329-587MAIN 6 39.80-238.835199.02 Dec. 23, 2025: 6 @ 39.80
March 21, 2026issueSO-260321-661MAIN 16 39.80-636.8711437.85 Dec. 23, 2025: 16 @ 39.80
March 2, 2026issueSO-260302-713MAIN 5 39.80-199.02271,074.72 Dec. 23, 2025: 5 @ 39.80
Feb. 26, 2026issueSO-260226-115MAIN 7 39.80-278.63321,273.75 Dec. 23, 2025: 7 @ 39.80
Feb. 23, 2026issueSO-260223-696MAIN 4 39.80-159.22391,552.38 Dec. 23, 2025: 4 @ 39.80
Feb. 17, 2026issueSO-260217-742MAIN 6 39.80-238.83431,711.60 Dec. 23, 2025: 6 @ 39.80
Feb. 13, 2026issueSO-260213-143MAIN 1 39.80-39.80491,950.43 Dec. 23, 2025: 1 @ 39.80
Feb. 12, 2026issueSO-260212-717MAIN 8 39.80-318.44501,990.23 Dec. 23, 2025: 8 @ 39.80
Feb. 4, 2026issueSO-260204-833MAIN 3 39.80-119.41582,308.67 Dec. 23, 2025: 3 @ 39.80
Jan. 29, 2026issueSO-260129-236MAIN 7 39.80-278.63612,428.08 Dec. 23, 2025: 7 @ 39.80
Jan. 27, 2026issueSO-260127-143MAIN 2 39.80-79.61682,706.71 Dec. 23, 2025: 2 @ 39.80
Jan. 26, 2026issueSO-260126-281MAIN 3 39.80-119.41702,786.32 Dec. 23, 2025: 3 @ 39.80
Jan. 23, 2026issueSO-260123-922MAIN 11 39.80-437.85732,905.74 Dec. 23, 2025: 11 @ 39.80
Jan. 19, 2026issueSO-260119-231MAIN 1 39.80-39.80843,343.59 Dec. 23, 2025: 1 @ 39.80
Jan. 1, 2026issueSO-260101-192MAIN 6 39.63-237.76853,383.39 Dec. 10, 2025: 1 @ 38.73; Dec. 23, 2025: 5 @ 39.80
Dec. 23, 2025receiptPO-001076MAIN 90 39.803,582.41913,621.15
Dec. 12, 2025issueSO-251212-792MAIN 2 38.73-77.46138.73 Dec. 10, 2025: 2 @ 38.73
Dec. 12, 2025issueSO-251212-792EAST 23 38.73-890.843116.20 Sept. 27, 2025: 23 @ 38.73
Dec. 10, 2025returnRMAMAIN 3 38.73116.20261,007.03
Dec. 7, 2025issueSO-251207-234EAST 7 38.73-271.1223890.84 Sept. 27, 2025: 7 @ 38.73
Dec. 7, 2025issueSO-251207-234MAIN 4 38.73-154.93301,161.96 Sept. 27, 2025: 4 @ 38.73
Nov. 27, 2025issueSO-251127-310MAIN 4 38.73-154.93341,316.89 Sept. 27, 2025: 4 @ 38.73
Nov. 25, 2025issueSO-251125-954MAIN 8 38.73-309.86381,471.82 Sept. 27, 2025: 8 @ 38.73
Nov. 2, 2025issueSO-251102-343MAIN 19 38.73-735.91461,781.67 Sept. 27, 2025: 19 @ 38.73
Oct. 24, 2025issueSO-251024-405MAIN 8 38.73-309.86652,517.58 Sept. 27, 2025: 8 @ 38.73
Oct. 18, 2025issueSO-251018-789MAIN 20 38.69-773.73732,827.44 July 31, 2025: 2 @ 38.43; Aug. 6, 2025: 1 @ 38.43; Sept. 27, 2025: 17 @ 38.73
Oct. 6, 2025issueSO-251006-291MAIN 1 38.43-38.43933,601.17 July 31, 2025: 1 @ 38.43
Oct. 1, 2025issueSO-251001-736MAIN 5 38.43-192.14943,639.60 May 17, 2025: 4 @ 38.43; July 31, 2025: 1 @ 38.43
Sept. 30, 2025issueSO-250930-383EAST 1 38.43-38.43993,831.74 May 17, 2025: 1 @ 38.43
Sept. 27, 2025transferTRFMAIN → EAST 31 warehouse transfer, no cost effect
Sept. 27, 2025receiptPO-000877MAIN 90 38.733,485.881003,870.17
Sept. 18, 2025issueSO-250918-467MAIN 10 38.43-384.2910384.29 May 17, 2025: 10 @ 38.43
Sept. 18, 2025issueSO-250918-467EAST 2 38.43-76.8620768.58 May 17, 2025: 2 @ 38.43
Sept. 4, 2025issueSO-250904-533EAST 8 38.43-307.4322845.43 May 17, 2025: 8 @ 38.43
Aug. 25, 2025issueSO-250825-500MAIN 21 38.43-807.00301,152.86 May 17, 2025: 21 @ 38.43
Aug. 21, 2025issueSO-250821-857EAST 7 38.43-269.00511,959.87 May 17, 2025: 7 @ 38.43
Aug. 10, 2025issueSO-250810-912MAIN 1 38.43-38.43582,228.87 May 17, 2025: 1 @ 38.43
Aug. 6, 2025returnRMAMAIN 1 38.4338.43592,267.30
July 31, 2025returnRMAMAIN 4 38.43153.72582,228.87
July 27, 2025issueSO-250727-650MAIN 8 38.43-307.43542,075.16 May 17, 2025: 8 @ 38.43
July 23, 2025issueSO-250723-647MAIN 2 38.43-76.86622,382.59 May 17, 2025: 2 @ 38.43
July 20, 2025issueSO-250720-229MAIN 1 38.43-38.43642,459.44 May 17, 2025: 1 @ 38.43
July 12, 2025issueSO-250712-506MAIN 5 38.43-192.14652,497.87 May 17, 2025: 5 @ 38.43
July 8, 2025issueSO-250708-881EAST 3 38.43-115.29702,690.02 May 17, 2025: 3 @ 38.43
July 1, 2025issueSO-250701-813MAIN 1 38.43-38.43732,805.30 May 17, 2025: 1 @ 38.43
June 28, 2025issueSO-250628-214EAST 3 38.43-115.29742,843.73 May 17, 2025: 3 @ 38.43
June 18, 2025issueSO-250618-833MAIN 1 38.43-38.43772,959.02 May 17, 2025: 1 @ 38.43
June 15, 2025issueSO-250615-720MAIN 2 38.43-76.86782,997.45 May 17, 2025: 2 @ 38.43
June 6, 2025issueSO-250606-843MAIN 6 38.43-230.57803,074.30 May 17, 2025: 6 @ 38.43
June 5, 2025issueSO-250605-565EAST 3 38.43-115.29863,304.88 May 17, 2025: 3 @ 38.43
May 25, 2025issueSO-250525-981MAIN 5 37.73-188.64893,420.16 Dec. 12, 2024: 4 @ 37.55; May 17, 2025: 1 @ 38.43
May 17, 2025transferTRFMAIN → EAST 26 warehouse transfer, no cost effect
May 17, 2025receiptPO-000541MAIN 90 38.433,458.59943,608.80
May 10, 2025issueSO-250510-817MAIN 1 37.55-37.554150.21 Dec. 12, 2024: 1 @ 37.55
May 6, 2025issueSO-250506-437MAIN 8 37.55-300.425187.76 Dec. 12, 2024: 8 @ 37.55
April 25, 2025issueSO-250425-368MAIN 7 37.55-262.8713488.19 Dec. 12, 2024: 7 @ 37.55
April 18, 2025issueSO-250418-902MAIN 1 37.55-37.5520751.06 Dec. 12, 2024: 1 @ 37.55
April 6, 2025issueSO-250406-272MAIN 2 37.55-75.1121788.61 Dec. 12, 2024: 2 @ 37.55
April 5, 2025issueSO-250405-454MAIN 3 37.55-112.6623863.72 Dec. 12, 2024: 3 @ 37.55
March 27, 2025issueSO-250327-517MAIN 1 37.55-37.5526976.38 Dec. 12, 2024: 1 @ 37.55
March 12, 2025issueSO-250312-813MAIN 11 37.55-413.08271,013.93 Dec. 12, 2024: 11 @ 37.55
March 6, 2025issueSO-250306-933MAIN 8 37.55-300.42381,427.01 Dec. 12, 2024: 8 @ 37.55
March 1, 2025issueSO-250301-614MAIN 6 37.55-225.32461,727.43 Dec. 12, 2024: 6 @ 37.55
Feb. 28, 2025issueSO-250228-301MAIN 12 37.55-450.63521,952.75 Dec. 12, 2024: 12 @ 37.55
Feb. 20, 2025issueSO-250220-815MAIN 2 37.55-75.11642,403.39 Dec. 12, 2024: 2 @ 37.55
Feb. 18, 2025issueSO-250218-374MAIN 4 37.55-150.21662,478.49 Dec. 12, 2024: 4 @ 37.55
Feb. 16, 2025issueSO-250216-805MAIN 1 37.55-37.55702,628.70 Dec. 12, 2024: 1 @ 37.55
Feb. 6, 2025issueSO-250206-492MAIN 1 37.55-37.55712,666.26 Dec. 12, 2024: 1 @ 37.55
Jan. 27, 2025issueSO-250127-874MAIN 4 37.55-150.21722,703.81 Dec. 12, 2024: 4 @ 37.55
Jan. 27, 2025issueSO-250127-874EAST 1 37.55-37.55762,854.02 Dec. 12, 2024: 1 @ 37.55
Jan. 4, 2025issueSO-250104-642MAIN 17 37.91-644.44772,891.57 Oct. 1, 2024: 4 @ 39.06; Dec. 12, 2024: 13 @ 37.55
Dec. 26, 2024issueSO-241226-942MAIN 5 39.06-195.32943,536.02 Oct. 1, 2024: 5 @ 39.06
Dec. 21, 2024issueSO-241221-361MAIN 2 39.06-78.13993,731.34 Oct. 1, 2024: 2 @ 39.06
Dec. 17, 2024issueSO-241217-115MAIN 1 39.06-39.061013,809.46 Oct. 1, 2024: 1 @ 39.06
Dec. 12, 2024receiptPO-000094MAIN 90 37.553,379.761023,848.53
Dec. 3, 2024issueSO-241203-211MAIN 15 39.06-585.9612468.77 Oct. 1, 2024: 15 @ 39.06
Dec. 1, 2024issueSO-241201-827EAST 5 39.06-195.32271,054.73 Oct. 1, 2024: 5 @ 39.06
Nov. 28, 2024issueSO-241128-311MAIN 19 39.06-742.22321,250.05 Oct. 1, 2024: 19 @ 39.06
Nov. 10, 2024issueSO-241110-502EAST 3 39.06-117.19511,992.26 Oct. 1, 2024: 3 @ 39.06
Nov. 7, 2024issueSO-241107-428EAST 7 39.06-273.45542,109.46 Oct. 1, 2024: 7 @ 39.06
Nov. 1, 2024issueSO-241101-873MAIN 1 39.06-39.06612,382.90 Oct. 1, 2024: 1 @ 39.06
Oct. 31, 2024issueSO-241031-491MAIN 1 39.06-39.06622,421.97 Oct. 1, 2024: 1 @ 39.06
Oct. 19, 2024issueSO-241019-191MAIN 11 39.06-429.70632,461.03 Oct. 1, 2024: 11 @ 39.06
Oct. 14, 2024issueSO-241014-122MAIN 7 39.06-273.45742,890.74 Oct. 1, 2024: 7 @ 39.06
Oct. 13, 2024issueSO-241013-109EAST 6 39.06-234.38813,164.18 Oct. 1, 2024: 6 @ 39.06
Oct. 9, 2024issueSO-241009-178MAIN 2 39.06-78.13873,398.57 Oct. 1, 2024: 2 @ 39.06
Oct. 1, 2024issueSO-241001-656MAIN 1 39.06-39.06893,476.70 Oct. 1, 2024: 1 @ 39.06
Oct. 1, 2024transferTRFMAIN → EAST 22 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000001MAIN 90 39.063,515.76903,515.76