stocksense

Items / LED-0005

LED Bulb 9W Elite LED-0005 · Lighting · BrightLine Lighting

On hand (EA)165MAIN 79, EAST 86
Value (FIFO)1,568.00avg 9.50
ClassCX / FCV 0.18
Turnover5.2xlast issue 4 days ago
Days of cover76lead time 10d

Demand and forecast

Monthly demand and forecast for LED-00050.036.673.2110146Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 92.0Nov 24: 83.0Dec 24: 108.0Jan 25: 84.0Feb 25: 133.0Mar 25: 78.0Apr 25: 41.0May 25: 51.0Jun 25: 77.0Jul 25: 45.0Aug 25: 93.0Sep 25: 62.0Oct 25: 50.0Nov 25: 45.0Dec 25: 80.0Jan 26: 71.0Feb 26: 88.0Mar 26: 68.0Apr 26: 53.0May 26: 68.0Jun 26: 64.0Jul 26: 66.0Aug 26: 69.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.437565.75 / 30.43752.160
Daily demand sdmonthly sd / sqrt(30.4375)11.52 / 5.5172.088
Service level / zz = Phi^-1(service level)Phi^-1(0.900)1.282
Safety stockz * sqrt(LT * sd_d^2 + d^2 * sd_LT^2)1.282 * sqrt(9.6 * 2.088^2 + 2.160^2 * 2.2^2)10.2
Reorder pointd * LT + safety stock2.160 * 9.6 + 10.230.9
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days30.9
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 788/yr, S = 45.00, h = 20%, price = 9.52193.1
Inventory positionon hand + on order165 + 0165

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

From qtyUnit costOrder qtyAnnual costFeasible
09.521937,874yes (chosen if cheapest)

MOQ 280, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 5, 2026165 / 2809.501,568.00

Movement ledger 135 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 12, 2026issueSO-261012-892MAIN 26 9.50-247.081651,568.00 Sept. 5, 2026: 26 @ 9.50
Oct. 11, 2026issueSO-261011-642MAIN 13 9.50-123.541911,815.07 Sept. 5, 2026: 13 @ 9.50
Oct. 10, 2026issueSO-261010-688MAIN 6 9.50-57.022041,938.61 Sept. 5, 2026: 6 @ 9.50
Oct. 9, 2026issueSO-261009-361MAIN 1 9.50-9.502101,995.63 Sept. 5, 2026: 1 @ 9.50
Oct. 5, 2026issueSO-261005-822MAIN 6 9.50-57.022112,005.13 Sept. 5, 2026: 6 @ 9.50
Oct. 4, 2026issueSO-261004-888MAIN 4 9.50-38.012172,062.15 Sept. 5, 2026: 4 @ 9.50
Sept. 22, 2026issueSO-260922-317MAIN 25 9.50-237.582212,100.16 Sept. 5, 2026: 25 @ 9.50
Sept. 17, 2026issueSO-260917-201EAST 1 9.50-9.502462,337.74 Sept. 5, 2026: 1 @ 9.50
Sept. 11, 2026issueSO-260911-776MAIN 14 9.50-133.042472,347.24 Sept. 5, 2026: 14 @ 9.50
Sept. 9, 2026issueSO-260909-879MAIN 27 9.53-257.272612,480.28 April 21, 2026: 8 @ 9.59; Sept. 5, 2026: 19 @ 9.50
Sept. 5, 2026transferTRFMAIN → EAST 87 warehouse transfer, no cost effect
Sept. 5, 2026receiptPO-001775MAIN 280 9.502,660.842882,737.55
Aug. 29, 2026issueSO-260829-352MAIN 11 9.59-105.48876.71 April 21, 2026: 11 @ 9.59
Aug. 29, 2026issueSO-260829-352EAST 33 9.59-316.4419182.19 April 21, 2026: 33 @ 9.59
Aug. 27, 2026issueSO-260827-463MAIN 7 9.59-67.1252498.64 April 21, 2026: 7 @ 9.59
Aug. 13, 2026issueSO-260813-745EAST 14 9.59-134.2559565.76 April 21, 2026: 14 @ 9.59
Aug. 1, 2026issueSO-260801-424EAST 4 9.59-38.3673700.01 April 21, 2026: 4 @ 9.59
July 28, 2026issueSO-260728-148MAIN 35 9.59-335.6277738.37 April 21, 2026: 35 @ 9.59
July 19, 2026issueSO-260719-777MAIN 11 9.59-105.481121,073.99 April 21, 2026: 11 @ 9.59
July 16, 2026issueSO-260716-312MAIN 4 9.59-38.361231,179.47 April 21, 2026: 4 @ 9.59
July 14, 2026issueSO-260714-384MAIN 4 9.59-38.361271,217.83 April 21, 2026: 4 @ 9.59
July 4, 2026issueSO-260704-357EAST 12 9.59-115.071311,256.19 April 21, 2026: 12 @ 9.59
June 11, 2026issueSO-260611-134MAIN 1 9.59-9.591431,371.26 April 21, 2026: 1 @ 9.59
June 8, 2026issueSO-260608-271MAIN 49 9.59-469.871441,380.84 April 21, 2026: 49 @ 9.59
June 5, 2026issueSO-260605-874MAIN 14 9.59-134.251931,850.72 April 21, 2026: 14 @ 9.59
May 30, 2026issueSO-260530-984MAIN 22 9.59-210.962071,984.96 April 21, 2026: 22 @ 9.59
May 21, 2026issueSO-260521-167EAST 1 9.59-9.592292,195.93 April 21, 2026: 1 @ 9.59
May 17, 2026issueSO-260517-625MAIN 6 9.59-57.542302,205.52 April 21, 2026: 6 @ 9.59
May 16, 2026issueSO-260516-851EAST 10 9.59-95.892362,263.05 April 21, 2026: 10 @ 9.59
May 6, 2026issueSO-260506-166EAST 16 9.59-153.432462,358.94 April 21, 2026: 16 @ 9.59
May 5, 2026issueSO-260505-284MAIN 13 9.59-124.662622,512.37 April 21, 2026: 13 @ 9.59
April 22, 2026issueSO-260422-904MAIN 5 9.59-47.952752,637.03 April 21, 2026: 5 @ 9.59
April 21, 2026transferTRFMAIN → EAST 90 warehouse transfer, no cost effect
April 21, 2026receiptPO-001424MAIN 280 9.592,684.982802,684.98
April 17, 2026issueSO-260417-240MAIN 36 9.34-336.2600.00 Dec. 15, 2025: 36 @ 9.34
April 11, 2026issueSO-260411-797MAIN 8 9.34-74.7236336.26 Dec. 15, 2025: 8 @ 9.34
April 6, 2026issueSO-260406-443MAIN 1 9.34-9.3444410.99 Dec. 15, 2025: 1 @ 9.34
April 2, 2026issueSO-260402-762MAIN 1 9.34-9.3445420.33 Dec. 15, 2025: 1 @ 9.34
April 1, 2026issueSO-260401-932MAIN 2 9.34-18.6846429.67 Dec. 15, 2025: 2 @ 9.34
March 30, 2026issueSO-260330-184MAIN 2 9.34-18.6848448.35 Dec. 15, 2025: 2 @ 9.34
March 16, 2026issueSO-260316-739MAIN 18 9.34-168.1350467.03 Dec. 15, 2025: 18 @ 9.34
March 15, 2026issueSO-260315-221MAIN 3 9.34-28.0268635.16 Dec. 15, 2025: 3 @ 9.34
March 12, 2026issueSO-260312-990MAIN 29 9.34-270.8871663.18 Dec. 15, 2025: 29 @ 9.34
March 1, 2026issueSO-260301-309MAIN 16 9.34-149.45100934.06 Dec. 15, 2025: 16 @ 9.34
Feb. 27, 2026issueSO-260227-423MAIN 28 9.34-261.541161,083.51 Dec. 15, 2025: 28 @ 9.34
Feb. 13, 2026issueSO-260213-505MAIN 7 9.34-65.381441,345.05 Dec. 15, 2025: 7 @ 9.34
Feb. 2, 2026issueSO-260202-482MAIN 18 9.34-168.131511,410.43 Dec. 15, 2025: 18 @ 9.34
Feb. 1, 2026issueSO-260201-824MAIN 35 9.34-326.921691,578.56 Dec. 15, 2025: 35 @ 9.34
Jan. 29, 2026issueSO-260129-658MAIN 6 9.34-56.042041,905.48 Dec. 15, 2025: 6 @ 9.34
Jan. 28, 2026issueSO-260128-556MAIN 34 9.34-317.582101,961.53 Dec. 15, 2025: 34 @ 9.34
Jan. 19, 2026issueSO-260119-721MAIN 31 9.34-289.562442,279.11 Dec. 15, 2025: 31 @ 9.34
Dec. 22, 2025issueSO-251222-209MAIN 5 9.34-46.702752,568.66 Dec. 15, 2025: 5 @ 9.34
Dec. 15, 2025receiptPO-001053MAIN 280 9.342,615.372802,615.37
Dec. 4, 2025issueSO-251204-410MAIN 17 8.86-150.6500.00 Aug. 12, 2025: 13 @ 8.86; Oct. 26, 2025: 4 @ 8.86
Dec. 2, 2025issueSO-251202-643MAIN 58 8.86-513.9717150.65 Aug. 12, 2025: 58 @ 8.86
Nov. 21, 2025issueSO-251121-949MAIN 3 8.86-26.5875664.62 Aug. 12, 2025: 3 @ 8.86
Nov. 14, 2025issueSO-251114-753MAIN 13 8.86-115.2078691.20 Aug. 12, 2025: 13 @ 8.86
Nov. 12, 2025issueSO-251112-652MAIN 12 8.86-106.3491806.41 Aug. 12, 2025: 12 @ 8.86
Nov. 6, 2025issueSO-251106-808MAIN 6 8.86-53.17103912.74 Aug. 12, 2025: 6 @ 8.86
Nov. 2, 2025issueSO-251102-109MAIN 4 8.86-35.45109965.91 Aug. 12, 2025: 4 @ 8.86
Nov. 1, 2025issueSO-251101-231MAIN 7 8.86-62.031131,001.36 Aug. 12, 2025: 7 @ 8.86
Oct. 28, 2025issueSO-251028-636MAIN 16 8.86-141.791201,063.39 Aug. 12, 2025: 16 @ 8.86
Oct. 27, 2025issueSO-251027-201MAIN 5 8.86-44.311361,205.18 Aug. 12, 2025: 5 @ 8.86
Oct. 26, 2025returnRMAMAIN 4 8.8635.451411,249.49
Oct. 25, 2025issueSO-251025-829MAIN 24 8.86-212.681371,214.04 Aug. 12, 2025: 24 @ 8.86
Oct. 22, 2025issueSO-251022-486MAIN 8 8.86-70.891611,426.72 Aug. 12, 2025: 8 @ 8.86
Oct. 4, 2025issueSO-251004-901MAIN 1 8.86-8.861691,497.61 Aug. 12, 2025: 1 @ 8.86
Sept. 24, 2025issueSO-250924-849MAIN 12 8.86-106.341701,506.47 Aug. 12, 2025: 12 @ 8.86
Sept. 23, 2025issueSO-250923-398MAIN 1 8.86-8.861821,612.81 Aug. 12, 2025: 1 @ 8.86
Sept. 11, 2025issueSO-250911-553MAIN 27 8.86-239.261831,621.67 Aug. 12, 2025: 27 @ 8.86
Sept. 5, 2025issueSO-250905-605MAIN 6 8.86-53.172101,860.94 Aug. 12, 2025: 6 @ 8.86
Sept. 3, 2025issueSO-250903-692MAIN 6 8.86-53.172161,914.11 Aug. 12, 2025: 6 @ 8.86
Sept. 2, 2025issueSO-250902-830MAIN 7 8.86-62.032221,967.28 Aug. 12, 2025: 7 @ 8.86
Sept. 1, 2025issueSO-250901-304MAIN 3 8.86-26.582292,029.31 Aug. 12, 2025: 3 @ 8.86
Aug. 26, 2025issueSO-250826-484MAIN 6 8.86-53.172322,055.89 Aug. 12, 2025: 6 @ 8.86
Aug. 23, 2025issueSO-250823-967MAIN 1 8.86-8.862382,109.06 Aug. 12, 2025: 1 @ 8.86
Aug. 16, 2025issueSO-250816-759MAIN 19 8.86-168.372392,117.92 Aug. 12, 2025: 19 @ 8.86
Aug. 15, 2025issueSO-250815-965MAIN 21 8.86-186.092582,286.29 Aug. 12, 2025: 21 @ 8.86
Aug. 14, 2025issueSO-250814-619MAIN 1 8.86-8.862792,472.39 Aug. 12, 2025: 1 @ 8.86
Aug. 12, 2025receiptPO-000772MAIN 280 8.862,481.252802,481.25
Aug. 9, 2025issueSO-250809-839MAIN 22 8.74-192.3800.00 March 24, 2025: 22 @ 8.74
Aug. 3, 2025issueSO-250803-121MAIN 23 8.74-201.1322192.38 March 24, 2025: 23 @ 8.74
July 28, 2025adjustmentCycle countMAIN -1 8.74-8.7445393.51 March 24, 2025: 1 @ 8.74
July 24, 2025issueSO-250724-450MAIN 19 8.74-166.1546402.26 March 24, 2025: 19 @ 8.74
July 17, 2025issueSO-250717-747MAIN 8 8.74-69.9665568.41 March 24, 2025: 8 @ 8.74
July 9, 2025issueSO-250709-961MAIN 18 8.74-157.4073638.36 March 24, 2025: 18 @ 8.74
June 29, 2025issueSO-250629-830MAIN 5 8.74-43.7291795.77 March 24, 2025: 5 @ 8.74
June 28, 2025issueSO-250628-264MAIN 30 8.74-262.3496839.49 March 24, 2025: 30 @ 8.74
June 19, 2025issueSO-250619-317MAIN 13 8.74-113.681261,101.83 March 24, 2025: 13 @ 8.74
June 11, 2025issueSO-250611-251MAIN 17 8.74-148.661391,215.51 March 24, 2025: 17 @ 8.74
June 6, 2025issueSO-250606-937MAIN 9 8.74-78.701561,364.17 March 24, 2025: 9 @ 8.74
June 4, 2025issueSO-250604-137MAIN 3 8.74-26.231651,442.88 March 24, 2025: 3 @ 8.74
May 27, 2025issueSO-250527-191MAIN 3 8.74-26.231681,469.11 March 24, 2025: 3 @ 8.74
May 27, 2025issueSO-250527-191EAST 5 8.74-43.721711,495.34 March 24, 2025: 5 @ 8.74
May 25, 2025issueSO-250525-115MAIN 7 8.74-61.211761,539.07 March 24, 2025: 7 @ 8.74
May 16, 2025issueSO-250516-946MAIN 4 8.74-34.981831,600.28 March 24, 2025: 4 @ 8.74
May 7, 2025issueSO-250507-481EAST 23 8.74-201.131871,635.26 March 24, 2025: 23 @ 8.74
May 6, 2025issueSO-250506-699EAST 1 8.74-8.742101,836.39 March 24, 2025: 1 @ 8.74
May 3, 2025issueSO-250503-844MAIN 8 8.74-69.962111,845.13 March 24, 2025: 8 @ 8.74
April 26, 2025issueSO-250426-164EAST 13 8.74-113.682191,915.09 March 24, 2025: 13 @ 8.74
April 23, 2025issueSO-250423-483MAIN 3 8.74-26.232322,028.77 March 24, 2025: 3 @ 8.74
April 16, 2025issueSO-250416-295EAST 7 8.74-61.212352,055.00 March 24, 2025: 7 @ 8.74
April 7, 2025issueSO-250407-564MAIN 18 8.74-157.402422,116.22 March 24, 2025: 18 @ 8.74
March 31, 2025issueSO-250331-935MAIN 2 8.74-17.492602,273.62 March 24, 2025: 2 @ 8.74
March 29, 2025issueSO-250329-732EAST 41 8.89-364.392622,291.11 Dec. 14, 2024: 23 @ 9.00; March 24, 2025: 18 @ 8.74
March 24, 2025transferTRFMAIN → EAST 90 warehouse transfer, no cost effect
March 24, 2025receiptPO-000373MAIN 280 8.742,448.523032,655.50
March 16, 2025issueSO-250316-270MAIN 35 9.00-314.9823206.98 Dec. 14, 2024: 35 @ 9.00
Feb. 27, 2025issueSO-250227-146MAIN 1 9.00-9.0058521.96 Dec. 14, 2024: 1 @ 9.00
Feb. 25, 2025issueSO-250225-102MAIN 30 9.00-269.9859530.96 Dec. 14, 2024: 30 @ 9.00
Feb. 11, 2025issueSO-250211-868MAIN 21 9.00-188.9989800.94 Dec. 14, 2024: 21 @ 9.00
Feb. 10, 2025issueSO-250210-202MAIN 31 9.00-278.98110989.92 Dec. 14, 2024: 31 @ 9.00
Feb. 2, 2025issueSO-250202-351MAIN 50 9.00-449.961411,268.90 Dec. 14, 2024: 50 @ 9.00
Jan. 31, 2025issueSO-250131-864MAIN 41 9.00-368.971911,718.87 Dec. 14, 2024: 41 @ 9.00
Jan. 20, 2025issueSO-250120-275MAIN 9 9.00-80.992322,087.84 Dec. 14, 2024: 9 @ 9.00
Jan. 10, 2025issueSO-250110-832MAIN 26 9.00-233.982412,168.83 Dec. 14, 2024: 26 @ 9.00
Jan. 5, 2025issueSO-250105-562MAIN 6 9.00-54.002672,402.81 Dec. 14, 2024: 6 @ 9.00
Jan. 4, 2025issueSO-250104-164MAIN 2 9.00-18.002732,456.81 Dec. 14, 2024: 2 @ 9.00
Dec. 21, 2024issueSO-241221-831MAIN 7 9.01-63.082752,474.81 Oct. 1, 2024: 2 @ 9.04; Dec. 14, 2024: 5 @ 9.00
Dec. 14, 2024issueSO-241214-883MAIN 2 9.04-18.092822,537.89 Oct. 1, 2024: 2 @ 9.04
Dec. 14, 2024receiptPO-000103MAIN 280 9.002,519.802842,555.98
Dec. 5, 2024issueSO-241205-352MAIN 22 9.04-198.97436.18 Oct. 1, 2024: 22 @ 9.04
Dec. 5, 2024issueSO-241205-352EAST 77 9.04-696.3926235.14 Oct. 1, 2024: 77 @ 9.04
Nov. 25, 2024adjustmentCycle countMAIN -2 9.04-18.09103931.53 Oct. 1, 2024: 2 @ 9.04
Nov. 23, 2024issueSO-241123-917EAST 2 9.04-18.09105949.62 Oct. 1, 2024: 2 @ 9.04
Nov. 20, 2024issueSO-241120-755MAIN 27 9.04-244.19107967.71 Oct. 1, 2024: 27 @ 9.04
Nov. 14, 2024issueSO-241114-805MAIN 4 9.04-36.181341,211.90 Oct. 1, 2024: 4 @ 9.04
Nov. 9, 2024issueSO-241109-273MAIN 5 9.04-45.221381,248.07 Oct. 1, 2024: 5 @ 9.04
Nov. 5, 2024issueSO-241105-898EAST 6 9.04-54.261431,293.29 Oct. 1, 2024: 6 @ 9.04
Nov. 2, 2024issueSO-241102-181MAIN 16 9.04-144.701491,347.56 Oct. 1, 2024: 16 @ 9.04
Nov. 1, 2024issueSO-241101-507MAIN 23 9.04-208.011651,492.26 Oct. 1, 2024: 23 @ 9.04
Oct. 20, 2024issueSO-241020-242MAIN 61 9.04-551.681881,700.27 Oct. 1, 2024: 61 @ 9.04
Oct. 5, 2024issueSO-241005-339MAIN 31 9.04-280.362492,251.96 Oct. 1, 2024: 31 @ 9.04
Oct. 1, 2024transferTRFMAIN → EAST 85 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000001MAIN 280 9.042,532.322802,532.32