stocksense

Items / LED-0004

LED Bulb 9W Pro LED-0004 · Lighting · BrightLine Lighting

On hand (EA)331MAIN 331
Value (FIFO)7,545.34avg 22.80
ClassBX / FCV 0.22
Turnover3.4xlast issue 2 days ago
Days of cover113lead time 10d

Demand and forecast

Monthly demand and forecast for LED-00040.033.366.699.8133Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 82.0Nov 24: 92.0Dec 24: 121.0Jan 25: 75.0Feb 25: 105.0Mar 25: 86.0Apr 25: 96.0May 25: 77.0Jun 25: 86.0Jul 25: 82.0Aug 25: 109.0Sep 25: 80.0Oct 25: 95.0Nov 25: 112.0Dec 25: 95.0Jan 26: 85.0Feb 26: 117.0Mar 26: 80.0Apr 26: 84.0May 26: 70.0Jun 26: 62.0Jul 26: 58.0Aug 26: 96.0Sep 26: 118.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.437589.33 / 30.43752.935
Daily demand sdmonthly sd / sqrt(30.4375)19.25 / 5.5173.489
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 * 3.489^2 + 2.935^2 * 2.2^2)20.6
Reorder pointd * LT + safety stock2.935 * 9.6 + 20.648.7
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days48.7
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 1071/yr, S = 45.00, h = 20%, price = 22.92145.0
Inventory positionon hand + on order331 + 0331

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

From qtyUnit costOrder qtyAnnual costFeasible
022.9214525,218yes (chosen if cheapest)

MOQ 370, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 2, 2026331 / 37022.807,545.34

Movement ledger 125 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 14, 2026issueSO-261014-861MAIN 6 22.80-136.773317,545.34 Oct. 2, 2026: 6 @ 22.80
Oct. 13, 2026issueSO-261013-682MAIN 11 22.80-250.753377,682.12 Oct. 2, 2026: 11 @ 22.80
Oct. 11, 2026issueSO-261011-686MAIN 74 22.21-1,643.673487,932.87 May 22, 2026: 52 @ 21.96; Oct. 2, 2026: 22 @ 22.80
Oct. 7, 2026adjustmentCycle countMAIN -1 21.96-21.964229,576.54 May 22, 2026: 1 @ 21.96
Oct. 2, 2026receiptPO-001843MAIN 370 22.808,434.374239,598.51
Sept. 25, 2026issueSO-260925-918MAIN 64 21.96-1,405.75531,164.13 May 22, 2026: 64 @ 21.96
Sept. 22, 2026issueSO-260922-261MAIN 18 21.96-395.371172,569.88 May 22, 2026: 18 @ 21.96
Sept. 14, 2026issueSO-260914-411MAIN 31 21.96-680.911352,965.25 May 22, 2026: 31 @ 21.96
Sept. 11, 2026issueSO-260911-456MAIN 2 21.96-43.931663,646.16 May 22, 2026: 2 @ 21.96
Sept. 4, 2026issueSO-260904-222MAIN 3 21.96-65.891683,690.09 May 22, 2026: 3 @ 21.96
Aug. 27, 2026issueSO-260827-651MAIN 2 21.96-43.931713,755.98 May 22, 2026: 2 @ 21.96
Aug. 26, 2026issueSO-260826-449MAIN 16 21.96-351.441733,799.91 May 22, 2026: 16 @ 21.96
Aug. 10, 2026issueSO-260810-971MAIN 28 21.96-615.011894,151.35 May 22, 2026: 28 @ 21.96
Aug. 9, 2026issueSO-260809-678MAIN 36 21.96-790.732174,766.36 May 22, 2026: 36 @ 21.96
Aug. 5, 2026issueSO-260805-361MAIN 13 21.96-285.542535,557.09 May 22, 2026: 13 @ 21.96
Aug. 1, 2026issueSO-260801-596MAIN 1 21.96-21.962665,842.64 May 22, 2026: 1 @ 21.96
July 21, 2026issueSO-260721-232MAIN 10 21.96-219.652675,864.60 May 22, 2026: 10 @ 21.96
July 17, 2026issueSO-260717-398MAIN 37 21.96-812.702776,084.25 May 22, 2026: 37 @ 21.96
July 1, 2026issueSO-260701-398MAIN 11 21.96-241.613146,896.95 May 22, 2026: 11 @ 21.96
June 24, 2026issueSO-260624-578MAIN 8 21.96-175.723257,138.56 May 22, 2026: 8 @ 21.96
June 15, 2026issueSO-260615-235MAIN 29 21.96-636.983337,314.28 May 22, 2026: 29 @ 21.96
June 13, 2026issueSO-260613-698MAIN 23 21.87-503.053627,951.26 Jan. 29, 2026: 15 @ 21.82; May 22, 2026: 8 @ 21.96
June 4, 2026issueSO-260604-800MAIN 2 21.82-43.643858,454.31 Jan. 29, 2026: 2 @ 21.82
May 28, 2026issueSO-260528-951MAIN 18 21.82-392.803878,497.95 Jan. 29, 2026: 18 @ 21.82
May 22, 2026receiptPO-001516MAIN 370 21.968,126.984058,890.75
May 14, 2026issueSO-260514-663MAIN 21 21.82-458.2735763.78 Jan. 29, 2026: 21 @ 21.82
May 2, 2026issueSO-260502-751MAIN 31 21.82-676.49561,222.04 Jan. 29, 2026: 31 @ 21.82
April 23, 2026issueSO-260423-542MAIN 22 21.82-480.09871,898.53 Jan. 29, 2026: 22 @ 21.82
April 17, 2026issueSO-260417-396MAIN 1 21.82-21.821092,378.62 Jan. 29, 2026: 1 @ 21.82
April 12, 2026issueSO-260412-375MAIN 61 21.82-1,331.151102,400.44 Jan. 29, 2026: 61 @ 21.82
March 28, 2026adjustmentCycle countMAIN -2 21.82-43.641713,731.60 Jan. 29, 2026: 2 @ 21.82
March 28, 2026issueSO-260328-787MAIN 16 21.82-349.161733,775.24 Jan. 29, 2026: 16 @ 21.82
March 13, 2026issueSO-260313-932MAIN 2 21.82-43.641894,124.40 Jan. 29, 2026: 2 @ 21.82
March 7, 2026issueSO-260307-412MAIN 57 21.82-1,243.871914,168.04 Jan. 29, 2026: 57 @ 21.82
March 5, 2026issueSO-260305-980MAIN 5 21.82-109.112485,411.91 Jan. 29, 2026: 5 @ 21.82
Feb. 22, 2026issueSO-260222-184MAIN 1 21.82-21.822535,521.02 Jan. 29, 2026: 1 @ 21.82
Feb. 16, 2026issueSO-260216-586MAIN 50 21.82-1,091.112545,542.84 Jan. 29, 2026: 50 @ 21.82
Feb. 11, 2026issueSO-260211-513MAIN 15 21.82-327.333046,633.95 Jan. 29, 2026: 15 @ 21.82
Feb. 10, 2026issueSO-260210-319MAIN 19 21.82-414.623196,961.28 Jan. 29, 2026: 19 @ 21.82
Feb. 2, 2026issueSO-260202-358MAIN 32 21.82-698.313387,375.90 Jan. 29, 2026: 32 @ 21.82
Jan. 29, 2026receiptPO-001183MAIN 370 21.828,074.213708,074.21
Jan. 28, 2026issueSO-260128-636MAIN 42 21.49-902.5400.00 Oct. 3, 2025: 39 @ 21.49; Dec. 25, 2025: 3 @ 21.49
Jan. 18, 2026issueSO-260118-307MAIN 32 21.49-687.6542902.54 Oct. 3, 2025: 32 @ 21.49
Jan. 6, 2026issueSO-260106-853MAIN 11 21.49-236.38741,590.19 Oct. 3, 2025: 11 @ 21.49
Dec. 30, 2025issueSO-251230-492MAIN 7 21.49-150.42851,826.57 Oct. 3, 2025: 7 @ 21.49
Dec. 29, 2025issueSO-251229-417MAIN 7 21.49-150.42921,977.00 Oct. 3, 2025: 7 @ 21.49
Dec. 25, 2025returnRMAMAIN 3 21.4964.47992,127.42
Dec. 23, 2025issueSO-251223-919MAIN 55 21.49-1,181.90962,062.95 Oct. 3, 2025: 55 @ 21.49
Dec. 22, 2025issueSO-251222-473MAIN 2 21.49-42.981513,244.85 Oct. 3, 2025: 2 @ 21.49
Dec. 7, 2025issueSO-251207-396MAIN 7 21.49-150.421533,287.83 Oct. 3, 2025: 7 @ 21.49
Dec. 4, 2025issueSO-251204-510MAIN 20 21.49-429.781603,438.26 Oct. 3, 2025: 20 @ 21.49
Nov. 30, 2025issueSO-251130-378MAIN 49 21.49-1,052.971803,868.04 Oct. 3, 2025: 49 @ 21.49
Nov. 25, 2025issueSO-251125-132MAIN 36 21.49-773.612294,921.00 Oct. 3, 2025: 36 @ 21.49
Nov. 13, 2025issueSO-251113-654MAIN 23 21.49-494.252655,694.61 Oct. 3, 2025: 23 @ 21.49
Nov. 8, 2025issueSO-251108-371MAIN 4 21.49-85.962886,188.86 Oct. 3, 2025: 4 @ 21.49
Oct. 23, 2025issueSO-251023-956MAIN 2 21.49-42.982926,274.82 Oct. 3, 2025: 2 @ 21.49
Oct. 17, 2025issueSO-251017-202MAIN 8 21.49-171.912946,317.80 Oct. 3, 2025: 8 @ 21.49
Oct. 15, 2025issueSO-251015-926MAIN 9 21.49-193.403026,489.71 Oct. 3, 2025: 9 @ 21.49
Oct. 8, 2025issueSO-251008-286MAIN 15 21.49-322.343116,683.11 Oct. 3, 2025: 15 @ 21.49
Oct. 3, 2025issueSO-251003-366MAIN 48 21.51-1,032.573267,005.45 June 5, 2025: 2 @ 22.15; June 8, 2025: 2 @ 21.37; Oct. 3, 2025: 44 @ 21.49
Oct. 3, 2025receiptPO-000896MAIN 370 21.497,950.973748,038.02
Oct. 1, 2025issueSO-251001-730MAIN 13 22.15-287.97487.05 June 5, 2025: 13 @ 22.15
Sept. 27, 2025issueSO-250927-291MAIN 18 22.15-398.7317375.02 June 5, 2025: 18 @ 22.15
Sept. 26, 2025issueSO-250926-977MAIN 25 22.15-553.7935773.75 June 5, 2025: 25 @ 22.15
Sept. 18, 2025issueSO-250918-653MAIN 34 22.15-753.15601,327.54 June 5, 2025: 34 @ 22.15
Sept. 17, 2025issueSO-250917-104MAIN 1 22.15-22.15942,080.70 June 5, 2025: 1 @ 22.15
Sept. 13, 2025adjustmentCycle countMAIN -2 22.15-44.30952,102.85 June 5, 2025: 2 @ 22.15
Sept. 4, 2025issueSO-250904-215MAIN 2 22.15-44.30972,147.15 June 5, 2025: 2 @ 22.15
Aug. 26, 2025issueSO-250826-872MAIN 10 22.15-221.52992,191.45 June 5, 2025: 10 @ 22.15
Aug. 10, 2025issueSO-250810-678MAIN 13 22.15-287.971092,412.97 June 5, 2025: 13 @ 22.15
Aug. 8, 2025issueSO-250808-873MAIN 78 22.15-1,727.821222,700.94 June 5, 2025: 78 @ 22.15
Aug. 5, 2025issueSO-250805-760MAIN 8 22.15-177.212004,428.77 June 5, 2025: 8 @ 22.15
July 28, 2025issueSO-250728-505MAIN 15 22.15-332.272084,605.98 June 5, 2025: 15 @ 22.15
July 15, 2025issueSO-250715-879MAIN 17 22.15-376.582234,938.25 June 5, 2025: 17 @ 22.15
July 14, 2025issueSO-250714-325MAIN 28 22.15-620.242405,314.83 June 5, 2025: 28 @ 22.15
July 13, 2025issueSO-250713-794MAIN 8 22.15-177.212685,935.07 June 5, 2025: 8 @ 22.15
July 11, 2025issueSO-250711-230MAIN 1 22.15-22.152766,112.29 June 5, 2025: 1 @ 22.15
July 7, 2025issueSO-250707-386MAIN 11 22.15-243.672776,134.44 June 5, 2025: 11 @ 22.15
July 1, 2025issueSO-250701-419MAIN 2 22.15-44.302886,378.11 June 5, 2025: 2 @ 22.15
June 23, 2025issueSO-250623-708MAIN 10 22.15-221.522906,422.41 June 5, 2025: 10 @ 22.15
June 19, 2025issueSO-250619-745MAIN 61 22.15-1,351.253006,643.93 June 5, 2025: 61 @ 22.15
June 11, 2025issueSO-250611-595MAIN 11 22.15-243.673617,995.17 June 5, 2025: 11 @ 22.15
June 8, 2025returnRMAMAIN 2 21.3742.753728,238.84
June 6, 2025issueSO-250606-381MAIN 6 21.37-128.253708,196.09 Jan. 25, 2025: 3 @ 21.37; Feb. 25, 2025: 3 @ 21.37
June 5, 2025receiptPO-000604MAIN 370 22.158,196.093768,324.34
May 28, 2025issueSO-250528-694MAIN 41 21.37-876.356128.25 Jan. 25, 2025: 41 @ 21.37
May 28, 2025issueSO-250528-694EAST 5 21.37-106.87471,004.59 Jan. 25, 2025: 5 @ 21.37
May 23, 2025issueSO-250523-394MAIN 1 21.37-21.37521,111.46 Jan. 25, 2025: 1 @ 21.37
May 15, 2025issueSO-250515-660MAIN 28 21.37-598.48531,132.84 Jan. 25, 2025: 28 @ 21.37
May 13, 2025issueSO-250513-353MAIN 2 21.37-42.75811,731.32 Jan. 25, 2025: 2 @ 21.37
April 15, 2025issueSO-250415-665MAIN 62 21.37-1,325.21831,774.07 Jan. 25, 2025: 62 @ 21.37
April 6, 2025issueSO-250406-410MAIN 28 21.37-598.481453,099.27 Jan. 25, 2025: 28 @ 21.37
April 3, 2025issueSO-250403-345MAIN 6 21.37-128.251733,697.75 Jan. 25, 2025: 6 @ 21.37
March 31, 2025issueSO-250331-531EAST 1 21.37-21.371793,826.00 Jan. 25, 2025: 1 @ 21.37
March 30, 2025issueSO-250330-337MAIN 9 21.37-192.371803,847.37 Jan. 25, 2025: 9 @ 21.37
March 9, 2025issueSO-250309-146MAIN 9 21.37-192.371894,039.74 Jan. 25, 2025: 9 @ 21.37
March 3, 2025issueSO-250303-956EAST 17 21.37-363.361984,232.11 Jan. 25, 2025: 17 @ 21.37
March 2, 2025issueSO-250302-370EAST 50 21.37-1,068.722154,595.47 Jan. 25, 2025: 50 @ 21.37
Feb. 28, 2025issueSO-250228-851MAIN 13 21.37-277.872655,664.19 Jan. 25, 2025: 13 @ 21.37
Feb. 25, 2025returnRMAMAIN 3 21.3764.122785,942.06
Feb. 20, 2025issueSO-250220-693EAST 7 21.37-149.622755,877.93 Jan. 25, 2025: 7 @ 21.37
Feb. 13, 2025issueSO-250213-900MAIN 4 21.37-85.502826,027.55 Jan. 25, 2025: 4 @ 21.37
Feb. 12, 2025issueSO-250212-110MAIN 73 21.37-1,560.322866,113.05 Jan. 25, 2025: 73 @ 21.37
Feb. 6, 2025issueSO-250206-526EAST 2 21.37-42.753597,673.37 Jan. 25, 2025: 2 @ 21.37
Feb. 2, 2025issueSO-250202-291MAIN 9 21.37-192.373617,716.12 Jan. 25, 2025: 9 @ 21.37
Jan. 25, 2025transferTRFMAIN → EAST 82 warehouse transfer, no cost effect
Jan. 25, 2025receiptPO-000214MAIN 370 21.377,908.493707,908.49
Jan. 23, 2025issueSO-250123-173MAIN 55 21.77-1,197.5700.00 Oct. 1, 2024: 55 @ 21.77
Jan. 19, 2025issueSO-250119-732MAIN 5 21.77-108.87551,197.57 Oct. 1, 2024: 5 @ 21.77
Jan. 15, 2025issueSO-250115-651MAIN 6 21.77-130.64601,306.44 Oct. 1, 2024: 6 @ 21.77
Jan. 13, 2025issueSO-250113-742MAIN 9 21.77-195.97661,437.08 Oct. 1, 2024: 9 @ 21.77
Dec. 25, 2024issueSO-241225-238MAIN 18 21.77-391.93751,633.05 Oct. 1, 2024: 18 @ 21.77
Dec. 9, 2024issueSO-241209-739MAIN 65 21.77-1,415.31932,024.98 Oct. 1, 2024: 65 @ 21.77
Dec. 6, 2024issueSO-241206-386MAIN 1 21.77-21.771583,440.29 Oct. 1, 2024: 1 @ 21.77
Dec. 2, 2024issueSO-241202-259MAIN 37 21.77-805.641593,462.07 Oct. 1, 2024: 37 @ 21.77
Nov. 28, 2024issueSO-241128-873MAIN 32 21.77-696.771964,267.70 Oct. 1, 2024: 32 @ 21.77
Nov. 25, 2024issueSO-241125-844MAIN 2 21.77-43.552284,964.47 Oct. 1, 2024: 2 @ 21.77
Nov. 18, 2024issueSO-241118-714MAIN 2 21.77-43.552305,008.02 Oct. 1, 2024: 2 @ 21.77
Nov. 11, 2024issueSO-241111-358MAIN 11 21.77-239.512325,051.57 Oct. 1, 2024: 11 @ 21.77
Nov. 9, 2024issueSO-241109-533MAIN 11 21.77-239.512435,291.08 Oct. 1, 2024: 11 @ 21.77
Nov. 3, 2024issueSO-241103-663MAIN 34 21.77-740.322545,530.60 Oct. 1, 2024: 34 @ 21.77
Oct. 30, 2024issueSO-241030-283MAIN 12 21.77-261.292886,270.91 Oct. 1, 2024: 12 @ 21.77
Oct. 21, 2024issueSO-241021-376MAIN 32 21.77-696.773006,532.20 Oct. 1, 2024: 32 @ 21.77
Oct. 20, 2024issueSO-241020-622MAIN 38 21.77-827.413327,228.97 Oct. 1, 2024: 38 @ 21.77
Oct. 1, 2024receiptPO-000001MAIN 370 21.778,056.383708,056.38