stocksense

Items / LED-0027

LED Bulb 12W Prime LED-0027 · Lighting · BrightLine Lighting

On hand (EA)100MAIN 100
Value (FIFO)2,373.50avg 23.74
ClassBX / FCV 0.34
Turnover13.1xlast issue 7 days ago
Days of cover37lead time 10d

Demand and forecast

Monthly demand and forecast for LED-00270.039.178.1117156Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 80.0Nov 24: 127.0Dec 24: 77.0Jan 25: 81.0Feb 25: 104.0Mar 25: 80.0Apr 25: 70.0May 25: 97.0Jun 25: 63.0Jul 25: 67.0Aug 25: 63.0Sep 25: 77.0Oct 25: 74.0Nov 25: 79.0Dec 25: 142.0Jan 26: 71.0Feb 26: 71.0Mar 26: 112.0Apr 26: 103.0May 26: 56.0Jun 26: 61.0Jul 26: 44.0Aug 26: 62.0Sep 26: 112.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.437582.25 / 30.43752.702
Daily demand sdmonthly sd / sqrt(30.4375)27.56 / 5.5174.996
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 * 4.996^2 + 2.702^2 * 2.2^2)27.2
Reorder pointd * LT + safety stock2.702 * 9.6 + 27.253.1
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days53.1
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 986/yr, S = 45.00, h = 20%, price = 23.91136.2
Inventory positionon hand + on order100 + 0100

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

From qtyUnit costOrder qtyAnnual costFeasible
023.9113624,235yes (chosen if cheapest)

MOQ 360, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
July 15, 202695 / 36023.742,254.82
Aug. 29, 20263 / 323.7471.20
Sept. 14, 20262 / 223.7447.47

Movement ledger 130 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 9, 2026issueSO-261009-583MAIN 15 23.74-356.021002,373.50 July 15, 2026: 15 @ 23.74
Oct. 5, 2026issueSO-261005-716MAIN 23 23.74-545.901152,729.52 July 15, 2026: 23 @ 23.74
Oct. 1, 2026issueSO-261001-685MAIN 47 23.74-1,115.541383,275.43 July 15, 2026: 47 @ 23.74
Sept. 29, 2026issueSO-260929-891MAIN 45 23.74-1,068.081854,390.98 July 15, 2026: 45 @ 23.74
Sept. 24, 2026issueSO-260924-318MAIN 7 23.74-166.142305,459.05 July 15, 2026: 7 @ 23.74
Sept. 14, 2026returnRMAMAIN 2 23.7447.472375,625.20
Sept. 9, 2026issueSO-260909-545MAIN 15 23.74-356.022355,577.72 July 15, 2026: 15 @ 23.74
Sept. 7, 2026issueSO-260907-370MAIN 6 23.74-142.412505,933.75 July 15, 2026: 6 @ 23.74
Sept. 6, 2026issueSO-260906-732MAIN 9 23.74-213.622566,076.16 July 15, 2026: 9 @ 23.74
Sept. 5, 2026issueSO-260905-306MAIN 27 23.74-640.842656,289.78 July 15, 2026: 27 @ 23.74
Sept. 2, 2026issueSO-260902-453MAIN 5 23.74-118.682926,930.62 July 15, 2026: 5 @ 23.74
Aug. 31, 2026issueSO-260831-293MAIN 5 23.74-118.682977,049.30 July 15, 2026: 5 @ 23.74
Aug. 29, 2026returnRMAMAIN 3 23.7471.203027,167.97
Aug. 27, 2026issueSO-260827-189MAIN 4 23.74-94.942997,096.76 July 15, 2026: 4 @ 23.74
Aug. 19, 2026issueSO-260819-225MAIN 2 23.74-47.473037,191.70 July 15, 2026: 2 @ 23.74
Aug. 16, 2026issueSO-260816-772MAIN 9 23.74-213.623057,239.18 July 15, 2026: 9 @ 23.74
Aug. 13, 2026issueSO-260813-975MAIN 7 23.74-166.143147,452.79 July 15, 2026: 7 @ 23.74
Aug. 2, 2026issueSO-260802-472MAIN 38 23.74-901.933217,618.94 July 15, 2026: 38 @ 23.74
July 25, 2026issueSO-260725-891MAIN 1 23.74-23.743598,520.86 July 15, 2026: 1 @ 23.74
July 15, 2026receiptPO-001646MAIN 360 23.748,544.603608,544.60
July 4, 2026issueSO-260704-159MAIN 43 23.89-1,027.4300.00 Feb. 27, 2026: 41 @ 23.89; May 15, 2026: 2 @ 23.89
June 30, 2026issueSO-260630-484MAIN 27 23.89-645.13431,027.43 Feb. 27, 2026: 27 @ 23.89
June 10, 2026issueSO-260610-206MAIN 19 23.89-453.98701,672.57 Feb. 27, 2026: 19 @ 23.89
June 3, 2026issueSO-260603-981MAIN 15 23.89-358.41892,126.55 Feb. 27, 2026: 15 @ 23.89
May 15, 2026returnRMAMAIN 2 23.8947.791042,484.96
May 9, 2026issueSO-260509-585MAIN 2 23.89-47.791022,437.17 Feb. 27, 2026: 2 @ 23.89
May 1, 2026issueSO-260501-315MAIN 56 23.89-1,338.051042,484.96 Feb. 27, 2026: 56 @ 23.89
April 30, 2026issueSO-260430-231MAIN 4 23.89-95.581603,823.01 Feb. 27, 2026: 4 @ 23.89
April 22, 2026issueSO-260422-606MAIN 19 23.89-453.981643,918.58 Feb. 27, 2026: 19 @ 23.89
April 20, 2026issueSO-260420-782MAIN 10 23.89-238.941834,372.57 Feb. 27, 2026: 10 @ 23.89
April 16, 2026issueSO-260416-900MAIN 11 23.89-262.831934,611.50 Feb. 27, 2026: 11 @ 23.89
April 8, 2026issueSO-260408-174MAIN 4 23.89-95.582044,874.34 Feb. 27, 2026: 4 @ 23.89
April 5, 2026issueSO-260405-511MAIN 43 23.89-1,027.432084,969.91 Feb. 27, 2026: 43 @ 23.89
April 5, 2026issueSO-260405-511EAST 12 23.89-286.732515,997.34 Feb. 27, 2026: 12 @ 23.89
March 16, 2026issueSO-260316-549EAST 107 23.85-2,552.222636,284.07 Oct. 28, 2025: 6 @ 23.45; Jan. 13, 2026: 4 @ 23.45; Feb. 27, 2026: 97 @ 23.89
March 1, 2026issueSO-260301-723MAIN 5 23.45-117.263708,836.29 Oct. 28, 2025: 5 @ 23.45
Feb. 27, 2026issueSO-260227-165MAIN 29 23.45-680.113758,953.55 Oct. 28, 2025: 29 @ 23.45
Feb. 27, 2026transferTRFMAIN → EAST 90 warehouse transfer, no cost effect
Feb. 27, 2026receiptPO-001262MAIN 360 23.898,601.774049,633.66
Feb. 20, 2026issueSO-260220-222MAIN 13 23.45-304.88441,031.89 Oct. 28, 2025: 13 @ 23.45
Feb. 15, 2026issueSO-260215-782MAIN 4 23.45-93.81571,336.77 Oct. 28, 2025: 4 @ 23.45
Feb. 14, 2026issueSO-260214-156MAIN 25 23.45-586.30611,430.58 Oct. 28, 2025: 25 @ 23.45
Jan. 30, 2026issueSO-260130-561MAIN 5 23.45-117.26862,016.88 Oct. 28, 2025: 5 @ 23.45
Jan. 27, 2026issueSO-260127-839MAIN 22 23.45-515.95912,134.14 Oct. 28, 2025: 22 @ 23.45
Jan. 26, 2026issueSO-260126-833EAST 13 23.45-304.881132,650.09 Oct. 28, 2025: 13 @ 23.45
Jan. 19, 2026issueSO-260119-683MAIN 3 23.45-70.361262,954.96 Oct. 28, 2025: 3 @ 23.45
Jan. 13, 2026returnRMAMAIN 4 23.4593.811293,025.32
Jan. 3, 2026adjustmentCycle countMAIN -2 23.45-46.901252,931.51 Oct. 28, 2025: 2 @ 23.45
Jan. 2, 2026issueSO-260102-990MAIN 23 23.45-539.401272,978.42 Oct. 28, 2025: 23 @ 23.45
Jan. 1, 2026issueSO-260101-184MAIN 9 23.45-211.071503,517.82 Oct. 28, 2025: 9 @ 23.45
Dec. 26, 2025issueSO-251226-610MAIN 70 23.45-1,641.651593,728.88 Oct. 28, 2025: 70 @ 23.45
Dec. 21, 2025issueSO-251221-649MAIN 6 23.45-140.712295,370.53 Oct. 28, 2025: 6 @ 23.45
Dec. 12, 2025issueSO-251212-588EAST 22 23.45-515.952355,511.24 Oct. 28, 2025: 22 @ 23.45
Dec. 11, 2025issueSO-251211-822EAST 23 23.45-539.402576,027.19 Oct. 28, 2025: 23 @ 23.45
Dec. 5, 2025issueSO-251205-170EAST 10 23.45-234.522806,566.59 Oct. 28, 2025: 10 @ 23.45
Dec. 4, 2025issueSO-251204-552MAIN 11 23.45-257.972906,801.11 Oct. 28, 2025: 11 @ 23.45
Nov. 30, 2025issueSO-251130-544MAIN 12 23.45-281.433017,059.08 Oct. 28, 2025: 12 @ 23.45
Nov. 18, 2025issueSO-251118-916MAIN 6 23.45-140.713137,340.51 Oct. 28, 2025: 6 @ 23.45
Nov. 10, 2025issueSO-251110-594MAIN 29 23.45-680.113197,481.22 Oct. 28, 2025: 29 @ 23.45
Nov. 8, 2025issueSO-251108-533MAIN 27 23.06-622.513488,161.33 May 25, 2025: 6 @ 22.74; June 18, 2025: 1 @ 22.74; Oct. 12, 2025: 8 @ 22.74; Oct. 28, 2025: 12 @ 23.45
Nov. 5, 2025issueSO-251105-180EAST 5 22.74-113.703758,783.84 May 25, 2025: 5 @ 22.74
Oct. 28, 2025transferTRFMAIN → EAST 102 warehouse transfer, no cost effect
Oct. 28, 2025receiptPO-000957MAIN 360 23.458,442.763808,897.54
Oct. 26, 2025issueSO-251026-481MAIN 2 22.74-45.4820454.78 May 25, 2025: 2 @ 22.74
Oct. 18, 2025issueSO-251018-449MAIN 44 22.74-1,000.5222500.26 May 25, 2025: 44 @ 22.74
Oct. 16, 2025issueSO-251016-894MAIN 16 22.74-363.83661,500.78 May 25, 2025: 16 @ 22.74
Oct. 12, 2025returnRMAMAIN 8 22.74181.91821,864.61
Oct. 9, 2025issueSO-251009-478MAIN 17 22.74-386.56741,682.69 May 25, 2025: 17 @ 22.74
Oct. 1, 2025issueSO-251001-104MAIN 3 22.74-68.22912,069.26 May 25, 2025: 3 @ 22.74
Sept. 23, 2025issueSO-250923-776MAIN 14 22.74-318.35942,137.48 May 25, 2025: 14 @ 22.74
Sept. 18, 2025issueSO-250918-315MAIN 57 22.74-1,296.131082,455.82 May 25, 2025: 57 @ 22.74
Sept. 3, 2025issueSO-250903-818MAIN 6 22.74-136.431653,751.95 May 25, 2025: 6 @ 22.74
Aug. 23, 2025issueSO-250823-185MAIN 5 22.74-113.701713,888.39 May 25, 2025: 5 @ 22.74
Aug. 23, 2025issueSO-250823-185EAST 5 22.74-113.701764,002.08 May 25, 2025: 5 @ 22.74
Aug. 20, 2025issueSO-250820-391MAIN 7 22.74-159.171814,115.78 May 25, 2025: 7 @ 22.74
Aug. 17, 2025issueSO-250817-587EAST 2 22.74-45.481884,274.95 May 25, 2025: 2 @ 22.74
Aug. 14, 2025issueSO-250814-117MAIN 3 22.74-68.221904,320.43 May 25, 2025: 3 @ 22.74
Aug. 10, 2025issueSO-250810-624MAIN 27 22.74-613.961934,388.65 May 25, 2025: 27 @ 22.74
Aug. 2, 2025issueSO-250802-757MAIN 14 22.74-318.352205,002.60 May 25, 2025: 14 @ 22.74
July 26, 2025issueSO-250726-668MAIN 8 22.74-181.912345,320.95 May 25, 2025: 8 @ 22.74
July 23, 2025issueSO-250723-435EAST 17 22.74-386.562425,502.86 May 25, 2025: 17 @ 22.74
July 10, 2025issueSO-250710-518EAST 6 22.74-136.432595,889.43 May 25, 2025: 6 @ 22.74
July 9, 2025issueSO-250709-779MAIN 6 22.74-136.432656,025.86 May 25, 2025: 6 @ 22.74
July 5, 2025issueSO-250705-776MAIN 4 22.74-90.962716,162.30 May 25, 2025: 4 @ 22.74
July 2, 2025issueSO-250702-299EAST 26 22.74-591.222756,253.25 May 25, 2025: 26 @ 22.74
June 22, 2025issueSO-250622-744MAIN 38 22.74-864.093016,844.47 May 25, 2025: 38 @ 22.74
June 18, 2025returnRMAMAIN 1 22.7422.743397,708.55
June 15, 2025issueSO-250615-616EAST 19 22.74-432.043387,685.82 May 25, 2025: 19 @ 22.74
June 13, 2025issueSO-250613-741MAIN 3 22.74-68.223578,117.86 May 25, 2025: 3 @ 22.74
June 5, 2025issueSO-250605-961MAIN 4 22.56-90.233608,186.08 Jan. 21, 2025: 4 @ 22.56
May 31, 2025issueSO-250531-441MAIN 1 22.56-22.563648,276.31 Jan. 21, 2025: 1 @ 22.56
May 28, 2025issueSO-250528-104MAIN 20 22.56-451.173658,298.87 Jan. 21, 2025: 20 @ 22.56
May 25, 2025transferTRFMAIN → EAST 75 warehouse transfer, no cost effect
May 25, 2025receiptPO-000573MAIN 360 22.748,186.083858,750.04
May 24, 2025issueSO-250524-723MAIN 9 22.56-203.0325563.97 Jan. 21, 2025: 9 @ 22.56
May 14, 2025issueSO-250514-664MAIN 25 22.56-563.9734767.00 Jan. 21, 2025: 25 @ 22.56
May 2, 2025issueSO-250502-184MAIN 10 22.56-225.59591,330.96 Jan. 21, 2025: 10 @ 22.56
May 1, 2025issueSO-250501-330MAIN 32 22.56-721.88691,556.55 Jan. 21, 2025: 32 @ 22.56
April 22, 2025issueSO-250422-903MAIN 4 22.56-90.231012,278.43 Jan. 21, 2025: 4 @ 22.56
April 19, 2025issueSO-250419-272MAIN 1 22.56-22.561052,368.66 Jan. 21, 2025: 1 @ 22.56
April 18, 2025issueSO-250418-406MAIN 8 22.56-180.471062,391.22 Jan. 21, 2025: 8 @ 22.56
April 17, 2025issueSO-250417-867MAIN 1 22.56-22.561142,571.69 Jan. 21, 2025: 1 @ 22.56
April 7, 2025issueSO-250407-922MAIN 56 22.56-1,263.291152,594.25 Jan. 21, 2025: 56 @ 22.56
March 21, 2025issueSO-250321-372MAIN 24 22.56-541.411713,857.54 Jan. 21, 2025: 24 @ 22.56
March 20, 2025issueSO-250320-382MAIN 1 22.56-22.561954,398.95 Jan. 21, 2025: 1 @ 22.56
March 18, 2025issueSO-250318-599MAIN 5 22.56-112.791964,421.51 Jan. 21, 2025: 5 @ 22.56
March 1, 2025issueSO-250301-810MAIN 50 22.56-1,127.942014,534.30 Jan. 21, 2025: 50 @ 22.56
Feb. 23, 2025issueSO-250223-833MAIN 18 22.56-406.062515,662.23 Jan. 21, 2025: 18 @ 22.56
Feb. 20, 2025issueSO-250220-163MAIN 54 22.56-1,218.172696,068.29 Jan. 21, 2025: 54 @ 22.56
Feb. 19, 2025issueSO-250219-852MAIN 19 22.56-428.623237,286.46 Jan. 21, 2025: 19 @ 22.56
Feb. 5, 2025issueSO-250205-542MAIN 13 22.56-293.263427,715.08 Jan. 21, 2025: 13 @ 22.56
Jan. 30, 2025issueSO-250130-932MAIN 1 22.56-22.563558,008.34 Jan. 21, 2025: 1 @ 22.56
Jan. 29, 2025issueSO-250129-773MAIN 47 22.70-1,066.963568,030.90 Oct. 1, 2024: 43 @ 22.71; Jan. 21, 2025: 4 @ 22.56
Jan. 21, 2025receiptPO-000202MAIN 360 22.568,121.134039,097.86
Jan. 10, 2025issueSO-250110-578MAIN 22 22.71-499.7243976.72 Oct. 1, 2024: 22 @ 22.71
Jan. 5, 2025issueSO-250105-396MAIN 11 22.71-249.86651,476.44 Oct. 1, 2024: 11 @ 22.71
Dec. 31, 2024issueSO-241231-344MAIN 19 22.71-431.58761,726.30 Oct. 1, 2024: 19 @ 22.71
Dec. 24, 2024issueSO-241224-670MAIN 12 22.71-272.57952,157.88 Oct. 1, 2024: 12 @ 22.71
Dec. 23, 2024issueSO-241223-421MAIN 1 22.71-22.711072,430.45 Oct. 1, 2024: 1 @ 22.71
Dec. 22, 2024issueSO-241222-907MAIN 15 22.71-340.721082,453.17 Oct. 1, 2024: 15 @ 22.71
Dec. 14, 2024issueSO-241214-473MAIN 1 22.71-22.711232,793.88 Oct. 1, 2024: 1 @ 22.71
Dec. 12, 2024issueSO-241212-156MAIN 28 22.71-636.011242,816.60 Oct. 1, 2024: 28 @ 22.71
Dec. 8, 2024issueSO-241208-703MAIN 1 22.71-22.711523,452.60 Oct. 1, 2024: 1 @ 22.71
Nov. 24, 2024issueSO-241124-904MAIN 20 22.71-454.291533,475.32 Oct. 1, 2024: 20 @ 22.71
Nov. 21, 2024issueSO-241121-639MAIN 51 22.71-1,158.441733,929.61 Oct. 1, 2024: 51 @ 22.71
Nov. 19, 2024issueSO-241119-542MAIN 10 22.71-227.142245,088.05 Oct. 1, 2024: 10 @ 22.71
Nov. 2, 2024issueSO-241102-331MAIN 46 22.71-1,044.872345,315.19 Oct. 1, 2024: 46 @ 22.71
Oct. 20, 2024issueSO-241020-524MAIN 66 22.71-1,499.162806,360.06 Oct. 1, 2024: 66 @ 22.71
Oct. 14, 2024issueSO-241014-714MAIN 14 22.71-318.003467,859.22 Oct. 1, 2024: 14 @ 22.71
Oct. 1, 2024receiptPO-000001MAIN 360 22.718,177.223608,177.22