stocksense

Items / LED-0025

LED Tube 18W Flex LED-0025 · Lighting · BrightLine Lighting

On hand (EA)169MAIN 119, EAST 50
Value (FIFO)3,306.20avg 19.56
ClassCX / FCV 0.23
Turnover5.7xlast issue 1 days ago
Days of cover114lead time 10d

Demand and forecast

Monthly demand and forecast for LED-00250.018.436.955.373.7Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 45.0Nov 24: 61.0Dec 24: 64.0Jan 25: 11.0Feb 25: 38.0Mar 25: 45.0Apr 25: 24.0May 25: 31.0Jun 25: 27.0Jul 25: 23.0Aug 25: 28.0Sep 25: 44.0Oct 25: 67.0Nov 25: 53.0Dec 25: 46.0Jan 26: 56.0Feb 26: 43.0Mar 26: 31.0Apr 26: 35.0May 26: 37.0Jun 26: 33.0Jul 26: 37.0Aug 26: 52.0Sep 26: 50.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.437545.00 / 30.43751.478
Daily demand sdmonthly sd / sqrt(30.4375)10.47 / 5.5171.898
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 * 1.898^2 + 1.478^2 * 2.2^2)8.6
Reorder pointd * LT + safety stock1.478 * 9.6 + 8.622.7
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days22.7
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 540/yr, S = 45.00, h = 20%, price = 20.06110.0
Inventory positionon hand + on order169 + 0169

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

From qtyUnit costOrder qtyAnnual costFeasible
020.0611011,266yes (chosen if cheapest)

MOQ 170, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 11, 2026169 / 17019.563,306.20

Movement ledger 132 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 15, 2026issueSO-261015-892MAIN 1 19.56-19.561693,306.20 Oct. 11, 2026: 1 @ 19.56
Oct. 11, 2026transferTRFMAIN → EAST 50 warehouse transfer, no cost effect
Oct. 11, 2026receiptPO-001868MAIN 170 19.563,325.761703,325.76
Oct. 2, 2026issueSO-261002-318MAIN 39 20.34-793.1000.00 July 11, 2026: 39 @ 20.34
Sept. 21, 2026issueSO-260921-704MAIN 3 20.34-61.0139793.10 July 11, 2026: 3 @ 20.34
Sept. 20, 2026issueSO-260920-226MAIN 2 20.34-40.6742854.11 July 11, 2026: 2 @ 20.34
Sept. 16, 2026issueSO-260916-316MAIN 2 20.34-40.6744894.78 July 11, 2026: 2 @ 20.34
Sept. 14, 2026issueSO-260914-316MAIN 3 20.34-61.0146935.46 July 11, 2026: 3 @ 20.34
Sept. 13, 2026issueSO-260913-363MAIN 18 20.34-366.0549996.46 July 11, 2026: 18 @ 20.34
Sept. 6, 2026issueSO-260906-457MAIN 1 20.34-20.34671,362.51 July 11, 2026: 1 @ 20.34
Sept. 4, 2026issueSO-260904-273MAIN 21 20.34-427.06681,382.85 July 11, 2026: 21 @ 20.34
Aug. 17, 2026issueSO-260817-955MAIN 5 20.34-101.68891,809.90 July 11, 2026: 5 @ 20.34
Aug. 17, 2026issueSO-260817-955EAST 34 20.34-691.42941,911.58 July 11, 2026: 34 @ 20.34
Aug. 2, 2026issueSO-260802-285MAIN 13 20.34-264.371282,603.01 July 11, 2026: 13 @ 20.34
July 31, 2026issueSO-260731-486MAIN 2 20.34-40.671412,867.38 July 11, 2026: 2 @ 20.34
July 26, 2026issueSO-260726-956MAIN 10 20.34-203.361432,908.05 July 11, 2026: 10 @ 20.34
July 20, 2026issueSO-260720-473MAIN 2 20.34-40.671533,111.41 July 11, 2026: 2 @ 20.34
July 11, 2026issueSO-260711-628MAIN 15 20.34-305.041553,152.08 July 11, 2026: 15 @ 20.34
July 11, 2026transferTRFMAIN → EAST 34 warehouse transfer, no cost effect
July 11, 2026receiptPO-001640MAIN 170 20.343,457.121703,457.12
July 2, 2026issueSO-260702-223MAIN 8 20.02-160.1600.00 Feb. 11, 2026: 5 @ 20.02; March 28, 2026: 1 @ 20.02; April 14, 2026: 1 @ 20.02; June 1, 2026: 1 @ 20.02
June 30, 2026issueSO-260630-133MAIN 13 20.02-260.268160.16 Feb. 11, 2026: 13 @ 20.02
June 28, 2026issueSO-260628-542MAIN 2 20.02-40.0421420.42 Feb. 11, 2026: 2 @ 20.02
June 26, 2026issueSO-260626-537MAIN 2 20.02-40.0423460.46 Feb. 11, 2026: 2 @ 20.02
June 20, 2026issueSO-260620-984MAIN 6 20.02-120.1225500.50 Feb. 11, 2026: 6 @ 20.02
June 15, 2026issueSO-260615-124MAIN 2 20.02-40.0431620.61 Feb. 11, 2026: 2 @ 20.02
June 11, 2026issueSO-260611-881MAIN 2 20.02-40.0433660.65 Feb. 11, 2026: 2 @ 20.02
June 10, 2026issueSO-260610-399MAIN 7 20.02-140.1435700.69 Feb. 11, 2026: 7 @ 20.02
June 1, 2026returnRMAMAIN 1 20.0220.0242840.83
May 26, 2026issueSO-260526-111MAIN 1 20.02-20.0241820.81 Feb. 11, 2026: 1 @ 20.02
May 24, 2026issueSO-260524-607MAIN 1 20.02-20.0242840.83 Feb. 11, 2026: 1 @ 20.02
May 17, 2026issueSO-260517-986MAIN 21 20.02-420.4243860.85 Feb. 11, 2026: 21 @ 20.02
May 13, 2026issueSO-260513-351MAIN 5 20.02-100.10641,281.27 Feb. 11, 2026: 5 @ 20.02
May 4, 2026issueSO-260504-365MAIN 2 20.02-40.04691,381.37 Feb. 11, 2026: 2 @ 20.02
May 3, 2026issueSO-260503-370MAIN 7 20.02-140.14711,421.41 Feb. 11, 2026: 7 @ 20.02
April 25, 2026issueSO-260425-208MAIN 11 20.02-220.22781,561.54 Feb. 11, 2026: 11 @ 20.02
April 23, 2026issueSO-260423-969MAIN 8 20.02-160.16891,781.76 Feb. 11, 2026: 8 @ 20.02
April 16, 2026issueSO-260416-937MAIN 1 20.02-20.02971,941.92 Feb. 11, 2026: 1 @ 20.02
April 14, 2026returnRMAMAIN 1 20.0220.02981,961.94
April 11, 2026issueSO-260411-214MAIN 6 20.02-120.12971,941.92 Feb. 11, 2026: 6 @ 20.02
April 5, 2026issueSO-260405-858MAIN 10 20.02-200.201032,062.04 Feb. 11, 2026: 10 @ 20.02
March 28, 2026returnRMAMAIN 1 20.0220.021132,262.24
March 27, 2026issueSO-260327-645MAIN 1 20.02-20.021122,242.22 Feb. 11, 2026: 1 @ 20.02
March 24, 2026issueSO-260324-167MAIN 1 20.02-20.021132,262.24 Feb. 11, 2026: 1 @ 20.02
March 19, 2026issueSO-260319-345MAIN 2 20.02-40.041142,282.26 Feb. 11, 2026: 2 @ 20.02
March 16, 2026issueSO-260316-556MAIN 6 20.02-120.121162,322.30 Feb. 11, 2026: 6 @ 20.02
March 14, 2026issueSO-260314-168MAIN 11 20.02-220.221222,442.42 Feb. 11, 2026: 11 @ 20.02
March 5, 2026issueSO-260305-879MAIN 6 20.02-120.121332,662.63 Feb. 11, 2026: 6 @ 20.02
March 2, 2026issueSO-260302-296MAIN 5 20.02-100.101392,782.75 Feb. 11, 2026: 5 @ 20.02
Feb. 22, 2026issueSO-260222-599MAIN 15 20.02-300.301442,882.85 Feb. 11, 2026: 15 @ 20.02
Feb. 15, 2026issueSO-260215-923MAIN 7 20.02-140.141593,183.15 Feb. 11, 2026: 7 @ 20.02
Feb. 11, 2026issueSO-260211-466MAIN 11 19.42-213.621663,323.29 Oct. 30, 2025: 2 @ 19.08; Jan. 8, 2026: 5 @ 19.08; Feb. 11, 2026: 4 @ 20.02
Feb. 11, 2026receiptPO-001215MAIN 170 20.023,403.371773,536.91
Feb. 10, 2026issueSO-260210-436MAIN 4 19.08-76.317133.54 Oct. 30, 2025: 4 @ 19.08
Feb. 4, 2026issueSO-260204-140MAIN 6 19.08-114.4711209.86 Oct. 30, 2025: 6 @ 19.08
Jan. 29, 2026issueSO-260129-769MAIN 19 19.08-362.4817324.32 Oct. 30, 2025: 19 @ 19.08
Jan. 27, 2026issueSO-260127-994MAIN 31 19.08-591.4136686.80 Oct. 30, 2025: 31 @ 19.08
Jan. 8, 2026returnRMAMAIN 5 19.0895.39671,278.21
Jan. 4, 2026issueSO-260104-290MAIN 11 19.08-209.86621,182.82 Oct. 30, 2025: 11 @ 19.08
Dec. 19, 2025issueSO-251219-577MAIN 6 19.08-114.47731,392.68 Oct. 30, 2025: 6 @ 19.08
Dec. 18, 2025issueSO-251218-699MAIN 40 19.08-763.11791,507.15 Oct. 30, 2025: 40 @ 19.08
Nov. 28, 2025issueSO-251128-606MAIN 21 19.08-400.631192,270.26 Oct. 30, 2025: 21 @ 19.08
Nov. 21, 2025issueSO-251121-754MAIN 1 19.08-19.081402,670.89 Oct. 30, 2025: 1 @ 19.08
Nov. 19, 2025issueSO-251119-727MAIN 6 19.08-114.471412,689.97 Oct. 30, 2025: 6 @ 19.08
Nov. 6, 2025issueSO-251106-387MAIN 18 19.08-343.401472,804.44 Oct. 30, 2025: 18 @ 19.08
Nov. 6, 2025issueSO-251106-387EAST 2 19.08-38.161653,147.84 Oct. 30, 2025: 2 @ 19.08
Nov. 5, 2025issueSO-251105-117MAIN 5 18.94-94.711673,185.99 July 27, 2025: 2 @ 18.74; Oct. 30, 2025: 3 @ 19.08
Oct. 30, 2025receiptPO-000963MAIN 170 19.083,243.231723,280.71
Oct. 19, 2025issueSO-251019-210EAST 2 18.74-37.48237.48 July 27, 2025: 2 @ 18.74
Oct. 19, 2025issueSO-251019-210MAIN 27 18.74-505.98474.96 June 16, 2025: 23 @ 18.74; July 27, 2025: 4 @ 18.74
Oct. 16, 2025issueSO-251016-923EAST 10 18.74-187.4031580.94 June 16, 2025: 10 @ 18.74
Oct. 4, 2025issueSO-251004-430MAIN 28 18.74-524.7241768.34 June 16, 2025: 28 @ 18.74
Sept. 10, 2025issueSO-250910-272EAST 12 18.74-224.88691,293.05 June 16, 2025: 12 @ 18.74
Sept. 9, 2025issueSO-250909-689MAIN 21 18.74-393.54811,517.93 June 16, 2025: 21 @ 18.74
Sept. 6, 2025issueSO-250906-568MAIN 11 18.74-206.141021,911.47 June 16, 2025: 11 @ 18.74
Aug. 19, 2025issueSO-250819-517EAST 10 18.74-187.401132,117.61 June 16, 2025: 10 @ 18.74
Aug. 18, 2025issueSO-250818-763MAIN 12 18.74-224.881232,305.01 June 16, 2025: 12 @ 18.74
Aug. 17, 2025issueSO-250817-446MAIN 2 18.74-37.481352,529.89 June 16, 2025: 2 @ 18.74
Aug. 7, 2025issueSO-250807-591MAIN 4 18.74-74.961372,567.37 June 16, 2025: 4 @ 18.74
July 27, 2025returnRMAMAIN 8 18.74149.921412,642.33
July 27, 2025issueSO-250727-483EAST 5 18.74-93.701332,492.41 June 16, 2025: 5 @ 18.74
July 23, 2025issueSO-250723-822MAIN 16 18.74-299.841382,586.11 June 16, 2025: 16 @ 18.74
July 20, 2025issueSO-250720-152EAST 1 18.74-18.741542,885.94 June 16, 2025: 1 @ 18.74
July 11, 2025issueSO-250711-561EAST 2 18.74-37.481552,904.68 June 16, 2025: 2 @ 18.74
July 2, 2025issueSO-250702-846EAST 7 18.74-131.181572,942.16 June 16, 2025: 7 @ 18.74
June 17, 2025issueSO-250617-637EAST 6 18.74-112.441643,073.34 June 16, 2025: 6 @ 18.74
June 16, 2025transferTRFMAIN → EAST 57 warehouse transfer, no cost effect
June 16, 2025receiptPO-000639MAIN 170 18.743,185.781703,185.78
June 9, 2025issueSO-250609-219MAIN 13 19.08-247.9800.00 Jan. 9, 2025: 5 @ 19.06; April 15, 2025: 8 @ 19.09
June 8, 2025issueSO-250608-125MAIN 8 19.06-152.4613247.98 Jan. 9, 2025: 8 @ 19.06
May 28, 2025issueSO-250528-873MAIN 3 19.09-57.2621400.43 Jan. 8, 2025: 3 @ 19.09
May 20, 2025issueSO-250520-523MAIN 12 19.09-229.0424457.69 Jan. 8, 2025: 12 @ 19.09
May 19, 2025issueSO-250519-708MAIN 4 19.09-76.3536686.73 Jan. 8, 2025: 4 @ 19.09
May 18, 2025issueSO-250518-826MAIN 7 19.09-133.6040763.07 Jan. 8, 2025: 7 @ 19.09
May 17, 2025issueSO-250517-767MAIN 1 19.09-19.0947896.68 Jan. 8, 2025: 1 @ 19.09
May 1, 2025issueSO-250501-339MAIN 4 19.09-76.3548915.76 Jan. 8, 2025: 4 @ 19.09
April 25, 2025issueSO-250425-985MAIN 14 19.09-267.2152992.11 Jan. 8, 2025: 14 @ 19.09
April 15, 2025returnRMAMAIN 8 19.09152.69661,259.31
April 10, 2025issueSO-250410-701MAIN 18 19.09-343.55581,106.62 Jan. 8, 2025: 18 @ 19.09
March 26, 2025issueSO-250326-890MAIN 17 19.09-324.47761,450.18 Jan. 8, 2025: 17 @ 19.09
March 7, 2025issueSO-250307-346MAIN 28 19.09-534.42931,774.64 Jan. 8, 2025: 28 @ 19.09
Feb. 25, 2025issueSO-250225-881MAIN 5 19.09-95.431212,309.06 Jan. 8, 2025: 5 @ 19.09
Feb. 24, 2025issueSO-250224-191MAIN 13 19.09-248.121262,404.49 Jan. 8, 2025: 13 @ 19.09
Feb. 23, 2025issueSO-250223-516MAIN 14 19.09-267.211392,652.61 Jan. 8, 2025: 14 @ 19.09
Feb. 16, 2025issueSO-250216-368MAIN 2 19.09-38.171532,919.82 Jan. 8, 2025: 2 @ 19.09
Feb. 9, 2025issueSO-250209-936MAIN 3 19.09-57.261552,958.00 Jan. 8, 2025: 3 @ 19.09
Feb. 2, 2025issueSO-250202-288MAIN 1 19.09-19.091583,015.25 Jan. 8, 2025: 1 @ 19.09
Jan. 26, 2025issueSO-250126-797MAIN 8 19.09-152.691593,034.34 Jan. 8, 2025: 8 @ 19.09
Jan. 22, 2025issueSO-250122-736MAIN 5 19.09-95.431673,187.03 Jan. 8, 2025: 5 @ 19.09
Jan. 13, 2025issueSO-250113-401MAIN 1 19.09-19.091723,282.46 Jan. 8, 2025: 1 @ 19.09
Jan. 12, 2025issueSO-250112-731MAIN 1 19.09-19.091733,301.55 Jan. 8, 2025: 1 @ 19.09
Jan. 10, 2025issueSO-250110-963MAIN 9 19.09-171.781743,320.64 Jan. 8, 2025: 9 @ 19.09
Jan. 9, 2025returnRMAMAIN 13 19.06247.741833,492.41
Jan. 8, 2025receiptPO-000170MAIN 170 19.093,244.671703,244.67
Dec. 30, 2024issueSO-241230-279MAIN 26 19.06-495.4800.00 Oct. 1, 2024: 26 @ 19.06
Dec. 28, 2024issueSO-241228-212MAIN 12 19.06-228.6826495.48 Oct. 1, 2024: 12 @ 19.06
Dec. 27, 2024issueSO-241227-377MAIN 2 19.06-38.1138724.17 Oct. 1, 2024: 2 @ 19.06
Dec. 22, 2024issueSO-241222-542MAIN 15 19.06-285.8640762.28 Oct. 1, 2024: 15 @ 19.06
Dec. 19, 2024issueSO-241219-629MAIN 3 19.06-57.17551,048.14 Oct. 1, 2024: 3 @ 19.06
Dec. 13, 2024issueSO-241213-871MAIN 6 19.06-114.34581,105.31 Oct. 1, 2024: 6 @ 19.06
Nov. 30, 2024issueSO-241130-945MAIN 7 19.06-133.40641,219.65 Oct. 1, 2024: 7 @ 19.06
Nov. 27, 2024issueSO-241127-931MAIN 8 19.06-152.46711,353.05 Oct. 1, 2024: 8 @ 19.06
Nov. 20, 2024issueSO-241120-128MAIN 1 19.06-19.06791,505.50 Oct. 1, 2024: 1 @ 19.06
Nov. 18, 2024issueSO-241118-369MAIN 9 19.06-171.51801,524.56 Oct. 1, 2024: 9 @ 19.06
Nov. 12, 2024issueSO-241112-951MAIN 6 19.06-114.34891,696.07 Oct. 1, 2024: 6 @ 19.06
Nov. 8, 2024issueSO-241108-632MAIN 4 19.06-76.23951,810.42 Oct. 1, 2024: 4 @ 19.06
Nov. 1, 2024issueSO-241101-476MAIN 26 19.06-495.48991,886.64 Oct. 1, 2024: 26 @ 19.06
Oct. 30, 2024issueSO-241030-528MAIN 14 19.06-266.801252,382.12 Oct. 1, 2024: 14 @ 19.06
Oct. 27, 2024issueSO-241027-834MAIN 4 19.06-76.231392,648.92 Oct. 1, 2024: 4 @ 19.06
Oct. 23, 2024issueSO-241023-775MAIN 17 19.06-323.971432,725.15 Oct. 1, 2024: 17 @ 19.06
Oct. 3, 2024issueSO-241003-949MAIN 10 19.06-190.571603,049.12 Oct. 1, 2024: 10 @ 19.06
Oct. 1, 2024receiptPO-000001MAIN 170 19.063,239.691703,239.69