stocksense

Items / LED-0030

Flood Light 50W Nova LED-0030 · Lighting · BrightLine Lighting

On hand (EA)125MAIN 125
Value (FIFO)4,441.28avg 35.53
ClassBX / FCV 0.23
Turnover5.6xlast issue 2 days ago
Days of cover54lead time 10d

Demand and forecast

Monthly demand and forecast for LED-00300.027.855.683.3111Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 50.0Nov 24: 101.0Dec 24: 79.0Jan 25: 79.0Feb 25: 49.0Mar 25: 73.0Apr 25: 29.0May 25: 54.0Jun 25: 41.0Jul 25: 60.0Aug 25: 70.0Sep 25: 77.0Oct 25: 95.0Nov 25: 93.0Dec 25: 80.0Jan 26: 66.0Feb 26: 71.0Mar 26: 43.0Apr 26: 75.0May 26: 68.0Jun 26: 92.0Jul 26: 53.0Aug 26: 48.0Sep 26: 67.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.437570.92 / 30.43752.330
Daily demand sdmonthly sd / sqrt(30.4375)16.55 / 5.5172.999
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 * 2.999^2 + 2.330^2 * 2.2^2)17.4
Reorder pointd * LT + safety stock2.330 * 9.6 + 17.439.7
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days39.7
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 850/yr, S = 45.00, h = 20%, price = 35.05520.0
Inventory positionon hand + on order125 + 0125

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

From qtyUnit costOrder qtyAnnual costFeasible
036.5110231,796yes
52035.0552031,703yes (chosen if cheapest)
1,04033.591,04032,095yes

MOQ 260, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Aug. 14, 2026125 / 26035.534,441.28

Movement ledger 127 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 14, 2026issueSO-261014-655MAIN 18 35.53-639.541254,441.28 Aug. 14, 2026: 18 @ 35.53
Oct. 11, 2026issueSO-261011-460MAIN 1 35.53-35.531435,080.82 Aug. 14, 2026: 1 @ 35.53
Oct. 10, 2026issueSO-261010-246MAIN 41 35.53-1,456.741445,116.35 Aug. 14, 2026: 41 @ 35.53
Oct. 9, 2026issueSO-261009-375MAIN 5 35.53-177.651856,573.09 Aug. 14, 2026: 5 @ 35.53
Oct. 2, 2026issueSO-261002-707MAIN 17 35.53-604.011906,750.74 Aug. 14, 2026: 17 @ 35.53
Sept. 28, 2026issueSO-260928-349MAIN 34 35.53-1,208.032077,354.75 Aug. 14, 2026: 34 @ 35.53
Sept. 28, 2026issueSO-260928-349EAST 4 35.53-142.122418,562.78 Aug. 14, 2026: 4 @ 35.53
Sept. 10, 2026issueSO-260910-244MAIN 12 35.53-426.362458,704.90 Aug. 14, 2026: 12 @ 35.53
Sept. 4, 2026issueSO-260904-256MAIN 17 36.04-612.702579,131.26 Aug. 6, 2026: 14 @ 36.15; Aug. 14, 2026: 3 @ 35.53
Aug. 19, 2026issueSO-260819-293MAIN 2 36.15-72.302749,743.96 April 15, 2026: 2 @ 36.15
Aug. 14, 2026issueSO-260814-704MAIN 2 36.15-72.302769,816.26 April 15, 2026: 2 @ 36.15
Aug. 14, 2026receiptPO-001719MAIN 260 35.539,237.852789,888.56
Aug. 12, 2026issueSO-260812-157EAST 15 36.15-542.2618650.71 April 15, 2026: 15 @ 36.15
Aug. 6, 2026returnRMAMAIN 14 36.15506.11331,192.96
Aug. 5, 2026issueSO-260805-467EAST 6 36.15-216.9019686.86 April 15, 2026: 6 @ 36.15
Aug. 4, 2026issueSO-260804-877EAST 8 36.15-289.2025903.76 April 15, 2026: 8 @ 36.15
Aug. 4, 2026issueSO-260804-877MAIN 1 36.15-36.15331,192.96 April 15, 2026: 1 @ 36.15
Aug. 2, 2026issueSO-260802-528EAST 28 36.15-1,012.21341,229.11 April 15, 2026: 28 @ 36.15
July 28, 2026issueSO-260728-362MAIN 8 36.15-289.20622,241.32 April 15, 2026: 8 @ 36.15
July 14, 2026issueSO-260714-142MAIN 37 36.15-1,337.56702,530.53 April 15, 2026: 37 @ 36.15
July 12, 2026issueSO-260712-291MAIN 8 36.15-289.201073,868.09 April 15, 2026: 8 @ 36.15
June 27, 2026issueSO-260627-394EAST 4 36.15-144.601154,157.30 April 15, 2026: 4 @ 36.15
June 24, 2026issueSO-260624-368MAIN 88 36.15-3,181.241194,301.90 April 15, 2026: 88 @ 36.15
May 22, 2026issueSO-260522-295EAST 20 36.15-723.012077,483.13 April 15, 2026: 20 @ 36.15
May 21, 2026issueSO-260521-349MAIN 33 36.15-1,192.962278,206.14 April 15, 2026: 33 @ 36.15
May 15, 2026issueSO-260515-755EAST 2 35.14-70.292609,399.10 Dec. 13, 2025: 2 @ 35.14
May 3, 2026issueSO-260503-527MAIN 13 35.14-456.862629,469.39 Dec. 13, 2025: 13 @ 35.14
April 30, 2026issueSO-260430-767EAST 2 35.14-70.292759,926.26 Dec. 13, 2025: 2 @ 35.14
April 15, 2026transferTRFMAIN → EAST 89 warehouse transfer, no cost effect
April 15, 2026receiptPO-001409MAIN 260 36.159,399.102779,996.54
April 6, 2026issueSO-260406-941MAIN 29 35.14-1,019.1617597.44 Dec. 13, 2025: 29 @ 35.14
April 4, 2026issueSO-260404-245MAIN 13 35.14-456.86461,616.60 Dec. 13, 2025: 13 @ 35.14
April 1, 2026issueSO-260401-458MAIN 31 35.14-1,089.45592,073.46 Dec. 13, 2025: 31 @ 35.14
March 22, 2026issueSO-260322-107MAIN 21 35.14-738.01903,162.91 Dec. 13, 2025: 21 @ 35.14
March 20, 2026issueSO-260320-275MAIN 22 35.14-773.151113,900.92 Dec. 13, 2025: 22 @ 35.14
Feb. 24, 2026issueSO-260224-279MAIN 2 35.14-70.291334,674.07 Dec. 13, 2025: 2 @ 35.14
Feb. 21, 2026issueSO-260221-992MAIN 6 35.14-210.861354,744.36 Dec. 13, 2025: 6 @ 35.14
Feb. 15, 2026issueSO-260215-290MAIN 12 35.14-421.721414,955.22 Dec. 13, 2025: 12 @ 35.14
Feb. 8, 2026issueSO-260208-902MAIN 6 35.14-210.861535,376.94 Dec. 13, 2025: 6 @ 35.14
Feb. 6, 2026issueSO-260206-517MAIN 4 35.14-140.571595,587.80 Dec. 13, 2025: 4 @ 35.14
Feb. 2, 2026issueSO-260202-160MAIN 41 35.14-1,440.881635,728.37 Dec. 13, 2025: 41 @ 35.14
Jan. 31, 2026issueSO-260131-771MAIN 14 35.14-492.012047,169.25 Dec. 13, 2025: 14 @ 35.14
Jan. 21, 2026issueSO-260121-782MAIN 1 35.14-35.142187,661.26 Dec. 13, 2025: 1 @ 35.14
Jan. 19, 2026issueSO-260119-207MAIN 17 35.14-597.442197,696.40 Dec. 13, 2025: 17 @ 35.14
Jan. 16, 2026issueSO-260116-218MAIN 8 35.14-281.152368,293.84 Dec. 13, 2025: 8 @ 35.14
Jan. 14, 2026issueSO-260114-598MAIN 6 35.14-210.862448,574.99 Dec. 13, 2025: 6 @ 35.14
Jan. 14, 2026issueSO-260114-598EAST 12 35.12-421.392508,785.85 Sept. 21, 2025: 2 @ 34.98; Dec. 13, 2025: 10 @ 35.14
Jan. 7, 2026issueSO-260107-177MAIN 8 34.98-279.822629,207.24 Sept. 21, 2025: 8 @ 34.98
Dec. 20, 2025issueSO-251220-283MAIN 6 34.98-209.872709,487.06 Sept. 21, 2025: 6 @ 34.98
Dec. 16, 2025issueSO-251216-441MAIN 11 34.98-384.762769,696.93 Sept. 21, 2025: 11 @ 34.98
Dec. 13, 2025receiptPO-001047MAIN 260 35.149,137.2828710,081.68
Dec. 12, 2025issueSO-251212-200EAST 3 34.98-104.9327944.40 Sept. 21, 2025: 3 @ 34.98
Dec. 6, 2025issueSO-251206-444MAIN 16 34.98-559.64301,049.33 Sept. 21, 2025: 16 @ 34.98
Dec. 5, 2025issueSO-251205-894MAIN 9 34.98-314.80461,608.98 Sept. 21, 2025: 9 @ 34.98
Dec. 1, 2025issueSO-251201-271MAIN 35 34.98-1,224.22551,923.78 Sept. 21, 2025: 35 @ 34.98
Nov. 17, 2025issueSO-251117-801MAIN 80 34.98-2,798.22903,148.00 Sept. 21, 2025: 80 @ 34.98
Nov. 5, 2025issueSO-251105-632MAIN 13 34.98-454.711705,946.23 Sept. 21, 2025: 13 @ 34.98
Oct. 8, 2025issueSO-251008-328MAIN 26 34.98-909.421836,400.94 Sept. 21, 2025: 26 @ 34.98
Oct. 5, 2025issueSO-251005-265EAST 69 34.85-2,404.512097,310.36 May 22, 2025: 18 @ 34.48; Sept. 21, 2025: 51 @ 34.98
Sept. 27, 2025issueSO-250927-333EAST 4 34.48-137.922789,714.87 May 22, 2025: 4 @ 34.48
Sept. 21, 2025transferTRFMAIN → EAST 88 warehouse transfer, no cost effect
Sept. 21, 2025receiptPO-000863MAIN 260 34.989,094.232829,852.79
Sept. 9, 2025issueSO-250909-768MAIN 16 34.48-551.6822758.56 May 22, 2025: 16 @ 34.48
Sept. 8, 2025issueSO-250908-990MAIN 7 34.48-241.36381,310.24 May 22, 2025: 7 @ 34.48
Sept. 4, 2025issueSO-250904-305MAIN 9 34.48-310.32451,551.60 May 22, 2025: 9 @ 34.48
Sept. 3, 2025issueSO-250903-754MAIN 37 34.48-1,275.76541,861.92 May 22, 2025: 37 @ 34.48
Sept. 1, 2025issueSO-250901-918MAIN 4 34.48-137.92913,137.68 May 22, 2025: 4 @ 34.48
Aug. 22, 2025issueSO-250822-827MAIN 1 34.48-34.48953,275.60 May 22, 2025: 1 @ 34.48
Aug. 16, 2025issueSO-250816-161MAIN 19 34.48-655.12963,310.08 May 22, 2025: 19 @ 34.48
Aug. 14, 2025issueSO-250814-917MAIN 9 34.48-310.321153,965.20 May 22, 2025: 9 @ 34.48
Aug. 11, 2025issueSO-250811-502MAIN 5 34.48-172.401244,275.52 May 22, 2025: 5 @ 34.48
Aug. 1, 2025issueSO-250801-347MAIN 36 34.48-1,241.281294,447.92 May 22, 2025: 36 @ 34.48
July 27, 2025issueSO-250727-654MAIN 28 34.48-965.441655,689.20 May 22, 2025: 28 @ 34.48
July 25, 2025issueSO-250725-430MAIN 3 34.48-103.441936,654.64 May 22, 2025: 3 @ 34.48
July 21, 2025issueSO-250721-795MAIN 13 34.48-448.241966,758.08 May 22, 2025: 13 @ 34.48
July 17, 2025issueSO-250717-489MAIN 1 34.48-34.482097,206.32 May 22, 2025: 1 @ 34.48
July 7, 2025issueSO-250707-460MAIN 15 34.48-517.202107,240.80 May 22, 2025: 15 @ 34.48
June 30, 2025issueSO-250630-625MAIN 2 34.48-68.962257,758.00 May 22, 2025: 2 @ 34.48
June 29, 2025issueSO-250629-400MAIN 8 34.48-275.842277,826.96 May 22, 2025: 8 @ 34.48
June 19, 2025issueSO-250619-747MAIN 2 34.48-68.962358,102.80 May 22, 2025: 2 @ 34.48
June 18, 2025issueSO-250618-437MAIN 5 34.48-172.402378,171.76 May 22, 2025: 5 @ 34.48
June 16, 2025issueSO-250616-998MAIN 19 34.41-653.882428,344.16 Dec. 12, 2024: 1 @ 33.24; May 22, 2025: 18 @ 34.48
June 10, 2025issueSO-250610-679MAIN 1 33.24-33.242618,998.04 Dec. 12, 2024: 1 @ 33.24
June 6, 2025issueSO-250606-155MAIN 4 33.24-132.972629,031.28 Dec. 12, 2024: 4 @ 33.24
May 22, 2025receiptPO-000560MAIN 260 34.488,964.802669,164.25
May 13, 2025issueSO-250513-631MAIN 50 33.24-1,662.106199.45 Dec. 12, 2024: 50 @ 33.24
May 5, 2025issueSO-250505-767MAIN 4 33.24-132.97561,861.56 Dec. 12, 2024: 4 @ 33.24
April 29, 2025issueSO-250429-375MAIN 18 33.24-598.36601,994.53 Dec. 12, 2024: 18 @ 33.24
April 3, 2025issueSO-250403-195MAIN 11 33.24-365.66782,592.88 Dec. 12, 2024: 11 @ 33.24
March 28, 2025issueSO-250328-176MAIN 10 33.24-332.42892,958.55 Dec. 12, 2024: 10 @ 33.24
March 23, 2025issueSO-250323-644MAIN 7 33.24-232.69993,290.97 Dec. 12, 2024: 7 @ 33.24
March 23, 2025issueSO-250323-644EAST 10 33.24-332.421063,523.66 Dec. 12, 2024: 10 @ 33.24
March 10, 2025issueSO-250310-257MAIN 1 33.24-33.241163,856.08 Dec. 12, 2024: 1 @ 33.24
March 8, 2025issueSO-250308-190EAST 4 33.24-132.971173,889.33 Dec. 12, 2024: 4 @ 33.24
March 6, 2025issueSO-250306-537MAIN 11 33.24-365.661214,022.29 Dec. 12, 2024: 11 @ 33.24
March 3, 2025issueSO-250303-618MAIN 13 33.24-432.151324,387.96 Dec. 12, 2024: 13 @ 33.24
March 2, 2025issueSO-250302-344MAIN 17 33.24-565.121454,820.10 Dec. 12, 2024: 17 @ 33.24
Feb. 27, 2025issueSO-250227-464MAIN 15 33.24-498.631625,385.22 Dec. 12, 2024: 15 @ 33.24
Feb. 26, 2025issueSO-250226-914EAST 10 33.24-332.421775,883.85 Dec. 12, 2024: 10 @ 33.24
Feb. 24, 2025issueSO-250224-122MAIN 9 33.24-299.181876,216.27 Dec. 12, 2024: 9 @ 33.24
Feb. 17, 2025issueSO-250217-691MAIN 4 33.24-132.971966,515.45 Dec. 12, 2024: 4 @ 33.24
Feb. 14, 2025issueSO-250214-669MAIN 1 33.24-33.242006,648.42 Dec. 12, 2024: 1 @ 33.24
Feb. 3, 2025issueSO-250203-651MAIN 10 33.24-332.422016,681.66 Dec. 12, 2024: 10 @ 33.24
Jan. 27, 2025issueSO-250127-758MAIN 38 33.24-1,263.202117,014.08 Dec. 12, 2024: 38 @ 33.24
Jan. 22, 2025issueSO-250122-941MAIN 11 33.24-365.662498,277.28 Dec. 12, 2024: 11 @ 33.24
Jan. 16, 2025issueSO-250116-903EAST 6 34.68-208.112608,642.95 Oct. 27, 2024: 6 @ 34.68
Jan. 13, 2025issueSO-250113-616MAIN 24 34.68-832.432668,851.05 Oct. 1, 2024: 14 @ 34.68; Oct. 27, 2024: 10 @ 34.68
Dec. 26, 2024issueSO-241226-914EAST 1 34.68-34.682909,683.48 Oct. 1, 2024: 1 @ 34.68
Dec. 12, 2024receiptPO-000095MAIN 260 33.248,642.952919,718.17
Dec. 11, 2024issueSO-241211-670EAST 7 34.68-242.79311,075.22 Oct. 1, 2024: 7 @ 34.68
Dec. 8, 2024issueSO-241208-887EAST 1 34.68-34.68381,318.01 Oct. 1, 2024: 1 @ 34.68
Dec. 7, 2024issueSO-241207-418EAST 8 34.68-277.48391,352.70 Oct. 1, 2024: 8 @ 34.68
Dec. 1, 2024issueSO-241201-275EAST 1 34.68-34.68471,630.17 Oct. 1, 2024: 1 @ 34.68
Dec. 1, 2024issueSO-241201-275MAIN 61 34.68-2,115.75481,664.86 Oct. 1, 2024: 61 @ 34.68
Nov. 30, 2024issueSO-241130-472MAIN 27 34.68-936.481093,780.61 Oct. 1, 2024: 27 @ 34.68
Nov. 26, 2024issueSO-241126-976MAIN 37 34.68-1,283.331364,717.09 Oct. 1, 2024: 37 @ 34.68
Nov. 24, 2024issueSO-241124-780MAIN 5 34.68-173.421736,000.42 Oct. 1, 2024: 5 @ 34.68
Nov. 21, 2024issueSO-241121-607EAST 8 34.68-277.481786,173.84 Oct. 1, 2024: 8 @ 34.68
Nov. 13, 2024issueSO-241113-936MAIN 13 34.68-450.901866,451.32 Oct. 1, 2024: 13 @ 34.68
Nov. 10, 2024issueSO-241110-370MAIN 4 34.68-138.741996,902.22 Oct. 1, 2024: 4 @ 34.68
Nov. 8, 2024issueSO-241108-397MAIN 7 34.68-242.792037,040.95 Oct. 1, 2024: 7 @ 34.68
Oct. 27, 2024returnRMAMAIN 16 34.68554.952107,283.74
Oct. 19, 2024issueSO-241019-995EAST 26 34.68-901.801946,728.79 Oct. 1, 2024: 26 @ 34.68
Oct. 15, 2024issueSO-241015-424MAIN 7 34.68-242.792207,630.59 Oct. 1, 2024: 7 @ 34.68
Oct. 11, 2024issueSO-241011-109MAIN 33 34.68-1,144.592277,873.38 Oct. 1, 2024: 33 @ 34.68
Oct. 1, 2024transferTRFMAIN → EAST 82 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000001MAIN 260 34.689,017.972609,017.97