stocksense

Items / LED-0034

LED Tube 18W Classic LED-0034 · Lighting · BrightLine Lighting

On hand (EA)383MAIN 326, EAST 57
Value (FIFO)64,500.99avg 168.41
ClassAX / FCV 0.13
Turnover6.0xlast issue 6 days ago
Days of cover60lead time 10d

Demand and forecast

Monthly demand and forecast for LED-00340.095.4191286382Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 168.0Nov 24: 229.0Dec 24: 347.0Jan 25: 224.0Feb 25: 178.0Mar 25: 237.0Apr 25: 172.0May 25: 203.0Jun 25: 115.0Jul 25: 116.0Aug 25: 222.0Sep 25: 210.0Oct 25: 253.0Nov 25: 176.0Dec 25: 212.0Jan 26: 178.0Feb 26: 199.0Mar 26: 198.0Apr 26: 176.0May 26: 176.0Jun 26: 167.0Jul 26: 191.0Aug 26: 229.0Sep 26: 177.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.4375194.33 / 30.43756.385
Daily demand sdmonthly sd / sqrt(30.4375)24.71 / 5.5174.478
Service level / zz = Phi^-1(service level)Phi^-1(0.980)2.054
Safety stockz * sqrt(LT * sd_d^2 + d^2 * sd_LT^2)2.054 * sqrt(9.6 * 4.478^2 + 6.385^2 * 2.2^2)40.2
Reorder pointd * LT + safety stock6.385 * 9.6 + 40.2101.3
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days101.3
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 2330/yr, S = 45.00, h = 20%, price = 168.4678.9
Inventory positionon hand + on order383 + 0383

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

From qtyUnit costOrder qtyAnnual costFeasible
0168.4679395,238yes (chosen if cheapest)

MOQ 770, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Aug. 29, 2026373 / 770168.4162,816.89
Sept. 12, 202610 / 10168.411,684.10

Movement ledger 122 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 10, 2026issueSO-261010-480MAIN 35 168.41-5,894.3538364,500.99 Aug. 29, 2026: 35 @ 168.41
Oct. 6, 2026issueSO-261006-168MAIN 59 168.41-9,936.1841870,395.34 Aug. 29, 2026: 59 @ 168.41
Oct. 3, 2026issueSO-261003-727MAIN 160 168.41-26,945.5847780,331.52 Aug. 29, 2026: 160 @ 168.41
Sept. 28, 2026issueSO-260928-843MAIN 13 168.41-2,189.33637107,277.11 Aug. 29, 2026: 13 @ 168.41
Sept. 18, 2026issueSO-260918-928EAST 1 168.41-168.41650109,466.44 Aug. 29, 2026: 1 @ 168.41
Sept. 16, 2026issueSO-260916-831MAIN 26 168.41-4,378.66651109,634.84 Aug. 29, 2026: 26 @ 168.41
Sept. 14, 2026issueSO-260914-307MAIN 39 168.41-6,567.99677114,013.50 Aug. 29, 2026: 39 @ 168.41
Sept. 12, 2026returnRMAMAIN 10 168.411,684.10716120,581.49
Sept. 9, 2026issueSO-260909-915MAIN 6 168.41-1,010.46706118,897.39 Aug. 29, 2026: 6 @ 168.41
Sept. 7, 2026issueSO-260907-428EAST 21 168.41-3,536.61712119,907.85 Aug. 29, 2026: 21 @ 168.41
Sept. 4, 2026issueSO-260904-714EAST 81 169.10-13,696.89733123,444.46 May 5, 2026: 36 @ 169.68; June 4, 2026: 8 @ 169.68; Aug. 29, 2026: 37 @ 168.41
Aug. 29, 2026transferTRFMAIN → EAST 160 warehouse transfer, no cost effect
Aug. 29, 2026receiptPO-001756MAIN 770 168.41129,675.62814137,141.34
Aug. 25, 2026issueSO-260825-415MAIN 4 169.68-678.70447,465.72 May 5, 2026: 4 @ 169.68
Aug. 20, 2026issueSO-260820-400MAIN 97 169.68-16,458.52488,144.42 May 5, 2026: 97 @ 169.68
Aug. 13, 2026issueSO-260813-201MAIN 5 169.68-848.3814524,602.95 May 5, 2026: 5 @ 169.68
Aug. 12, 2026issueSO-260812-203MAIN 47 169.68-7,974.7515025,451.32 May 5, 2026: 47 @ 169.68
Aug. 7, 2026issueSO-260807-745MAIN 76 169.68-12,895.3419733,426.07 May 5, 2026: 76 @ 169.68
July 30, 2026issueSO-260730-291MAIN 16 169.68-2,714.8127346,321.41 May 5, 2026: 16 @ 169.68
July 29, 2026issueSO-260729-602MAIN 37 169.68-6,277.9928949,036.22 May 5, 2026: 37 @ 169.68
July 22, 2026issueSO-260722-130MAIN 49 169.68-8,314.1032655,314.21 May 5, 2026: 49 @ 169.68
July 7, 2026issueSO-260707-619MAIN 39 169.68-6,617.3437563,628.31 May 5, 2026: 39 @ 169.68
July 6, 2026issueSO-260706-125MAIN 50 169.68-8,483.7841470,245.66 May 5, 2026: 50 @ 169.68
June 29, 2026issueSO-260629-695MAIN 23 169.68-3,902.5446478,729.43 May 5, 2026: 23 @ 169.68
June 28, 2026issueSO-260628-381MAIN 35 169.68-5,938.6448782,631.97 May 5, 2026: 35 @ 169.68
June 16, 2026issueSO-260616-877MAIN 77 169.68-13,065.0152288,570.61 May 5, 2026: 77 @ 169.68
June 11, 2026issueSO-260611-314MAIN 40 169.68-6,787.02599101,635.62 May 5, 2026: 40 @ 169.68
June 4, 2026returnRMAMAIN 8 169.681,357.40639108,422.64
May 29, 2026issueSO-260529-213MAIN 90 169.68-15,270.80631107,065.24 May 5, 2026: 90 @ 169.68
May 28, 2026issueSO-260528-207MAIN 17 169.68-2,884.48721122,336.04 May 5, 2026: 17 @ 169.68
May 27, 2026issueSO-260527-778MAIN 11 169.68-1,866.43738125,220.52 May 5, 2026: 11 @ 169.68
May 25, 2026issueSO-260525-882MAIN 4 169.68-678.70749127,086.95 May 5, 2026: 4 @ 169.68
May 20, 2026issueSO-260520-957MAIN 17 169.68-2,884.48753127,765.65 May 5, 2026: 17 @ 169.68
May 5, 2026receiptPO-001464MAIN 770 169.68130,650.14770130,650.14
May 4, 2026issueSO-260504-814MAIN 37 159.61-5,905.5800.00 Dec. 27, 2025: 16 @ 161.58; Jan. 1, 2026: 17 @ 157.29; Feb. 3, 2026: 4 @ 161.58
April 26, 2026issueSO-260426-209MAIN 97 161.58-15,673.39375,905.58 Dec. 27, 2025: 97 @ 161.58
April 11, 2026issueSO-260411-737MAIN 22 161.58-3,554.7913421,578.97 Dec. 27, 2025: 22 @ 161.58
April 8, 2026issueSO-260408-516MAIN 13 161.58-2,100.5615625,133.76 Dec. 27, 2025: 13 @ 161.58
April 8, 2026issueSO-260408-516EAST 40 161.58-6,463.2516927,234.31 Dec. 27, 2025: 40 @ 161.58
April 3, 2026issueSO-260403-184MAIN 4 161.58-646.3320933,697.57 Dec. 27, 2025: 4 @ 161.58
March 29, 2026issueSO-260329-169EAST 57 161.58-9,210.1321334,343.89 Dec. 27, 2025: 57 @ 161.58
March 27, 2026issueSO-260327-574EAST 97 161.58-15,673.3927043,554.03 Dec. 27, 2025: 97 @ 161.58
March 22, 2026issueSO-260322-997MAIN 15 161.58-2,423.7236759,227.41 Dec. 27, 2025: 15 @ 161.58
March 19, 2026issueSO-260319-542MAIN 10 161.58-1,615.8138261,651.13 Dec. 27, 2025: 10 @ 161.58
March 16, 2026issueSO-260316-403MAIN 5 161.58-807.9139263,266.94 Dec. 27, 2025: 5 @ 161.58
March 14, 2026issueSO-260314-207MAIN 14 161.58-2,262.1439764,074.85 Dec. 27, 2025: 14 @ 161.58
Feb. 23, 2026issueSO-260223-626MAIN 78 161.58-12,603.3441166,336.99 Dec. 27, 2025: 78 @ 161.58
Feb. 21, 2026issueSO-260221-346EAST 63 161.58-10,179.6248978,940.33 Dec. 27, 2025: 63 @ 161.58
Feb. 19, 2026issueSO-260219-511MAIN 62 161.58-10,018.0455289,119.95 Dec. 27, 2025: 62 @ 161.58
Feb. 3, 2026returnRMAMAIN 4 161.58646.3361499,137.99
Jan. 31, 2026issueSO-260131-201MAIN 3 161.58-484.7461098,491.67 Dec. 27, 2025: 3 @ 161.58
Jan. 20, 2026issueSO-260120-154MAIN 90 161.58-14,542.3261398,976.41 Dec. 27, 2025: 90 @ 161.58
Jan. 19, 2026issueSO-260119-429MAIN 47 161.58-7,594.32703113,518.73 Dec. 27, 2025: 47 @ 161.58
Jan. 18, 2026issueSO-260118-419MAIN 41 161.16-6,607.67750121,113.05 Sept. 4, 2025: 4 @ 157.29; Dec. 27, 2025: 37 @ 161.58
Jan. 14, 2026issueSO-260114-332MAIN 8 157.29-1,258.33791127,720.72 Sept. 4, 2025: 8 @ 157.29
Jan. 5, 2026issueSO-260105-167MAIN 6 157.29-943.75799128,979.06 Sept. 4, 2025: 6 @ 157.29
Jan. 1, 2026returnRMAMAIN 17 157.292,673.96805129,922.81
Dec. 27, 2025transferTRFMAIN → EAST 257 warehouse transfer, no cost effect
Dec. 27, 2025receiptPO-001093MAIN 770 161.58124,417.60788127,248.85
Dec. 17, 2025issueSO-251217-773MAIN 177 157.29-27,840.61182,831.25 Sept. 4, 2025: 177 @ 157.29
Dec. 12, 2025issueSO-251212-886MAIN 35 157.29-5,505.2119530,671.86 Sept. 4, 2025: 35 @ 157.29
Nov. 27, 2025issueSO-251127-328MAIN 22 157.29-3,460.4223036,177.07 Sept. 4, 2025: 22 @ 157.29
Nov. 25, 2025issueSO-251125-988MAIN 19 157.29-2,988.5425239,637.48 Sept. 4, 2025: 19 @ 157.29
Nov. 18, 2025issueSO-251118-386MAIN 25 157.29-3,932.2927142,626.02 Sept. 4, 2025: 25 @ 157.29
Nov. 11, 2025issueSO-251111-798MAIN 12 157.29-1,887.5029646,558.31 Sept. 4, 2025: 12 @ 157.29
Nov. 6, 2025issueSO-251106-848MAIN 59 157.29-9,280.2030848,445.81 Sept. 4, 2025: 59 @ 157.29
Nov. 3, 2025issueSO-251103-167MAIN 32 157.29-5,033.3336757,726.02 Sept. 4, 2025: 32 @ 157.29
Nov. 1, 2025issueSO-251101-979MAIN 7 157.29-1,101.0439962,759.35 Sept. 4, 2025: 7 @ 157.29
Oct. 25, 2025issueSO-251025-329MAIN 17 157.29-2,673.9640663,860.39 Sept. 4, 2025: 17 @ 157.29
Oct. 13, 2025issueSO-251013-135MAIN 236 157.29-37,120.8242366,534.35 Sept. 4, 2025: 236 @ 157.29
Sept. 28, 2025issueSO-250928-370MAIN 100 157.29-15,729.16659103,655.16 Sept. 4, 2025: 100 @ 157.29
Sept. 28, 2025issueSO-250928-370EAST 36 157.87-5,683.23759119,384.32 April 11, 2025: 25 @ 158.12; Sept. 4, 2025: 11 @ 157.29
Sept. 9, 2025issueSO-250909-962MAIN 74 158.12-11,700.95795125,067.56 April 11, 2025: 74 @ 158.12
Sept. 4, 2025receiptPO-000814MAIN 770 157.29121,114.53869136,768.51
Aug. 23, 2025issueSO-250823-591MAIN 53 158.12-8,380.419915,653.98 April 11, 2025: 53 @ 158.12
Aug. 7, 2025issueSO-250807-744MAIN 169 158.12-26,722.4515224,034.39 April 11, 2025: 169 @ 158.12
July 28, 2025issueSO-250728-425MAIN 29 158.12-4,585.5132150,756.84 April 11, 2025: 29 @ 158.12
July 27, 2025issueSO-250727-728MAIN 1 158.12-158.1235055,342.35 April 11, 2025: 1 @ 158.12
July 10, 2025issueSO-250710-296MAIN 7 158.12-1,106.8535155,500.47 April 11, 2025: 7 @ 158.12
July 7, 2025issueSO-250707-934MAIN 60 158.12-9,487.2635856,607.32 April 11, 2025: 60 @ 158.12
July 4, 2025issueSO-250704-976EAST 19 158.12-3,004.3041866,094.58 April 11, 2025: 19 @ 158.12
June 27, 2025issueSO-250627-481EAST 26 158.12-4,111.1543769,098.88 April 11, 2025: 26 @ 158.12
June 24, 2025issueSO-250624-223MAIN 9 158.12-1,423.0946373,210.02 April 11, 2025: 9 @ 158.12
June 22, 2025issueSO-250622-426MAIN 31 158.12-4,901.7547274,633.11 April 11, 2025: 31 @ 158.12
June 16, 2025issueSO-250616-232MAIN 23 158.12-3,636.7850379,534.86 April 11, 2025: 23 @ 158.12
June 13, 2025issueSO-250613-211MAIN 10 158.12-1,581.2152683,171.65 April 11, 2025: 10 @ 158.12
June 11, 2025issueSO-250611-207MAIN 5 158.12-790.6053684,752.86 April 11, 2025: 5 @ 158.12
June 6, 2025issueSO-250606-369MAIN 11 158.12-1,739.3354185,543.46 April 11, 2025: 11 @ 158.12
May 19, 2025issueSO-250519-523MAIN 38 158.12-6,008.6055287,282.79 April 11, 2025: 38 @ 158.12
May 12, 2025issueSO-250512-959MAIN 63 158.12-9,961.6259093,291.39 April 11, 2025: 63 @ 158.12
May 3, 2025issueSO-250503-792MAIN 102 158.12-16,128.34653103,253.01 April 11, 2025: 102 @ 158.12
April 15, 2025issueSO-250415-533MAIN 96 155.42-14,920.08755119,381.36 Dec. 22, 2024: 81 @ 154.92; April 11, 2025: 15 @ 158.12
April 11, 2025receiptPO-000435MAIN 770 158.12121,753.17851134,301.43
April 3, 2025issueSO-250403-521EAST 32 154.92-4,957.348112,548.26 Dec. 22, 2024: 32 @ 154.92
April 3, 2025issueSO-250403-521MAIN 44 154.92-6,816.3411317,505.60 Dec. 22, 2024: 44 @ 154.92
March 24, 2025issueSO-250324-697MAIN 63 154.92-9,759.7615724,321.94 Dec. 22, 2024: 63 @ 154.92
March 13, 2025issueSO-250313-489MAIN 21 154.92-3,253.2522034,081.70 Dec. 22, 2024: 21 @ 154.92
March 8, 2025issueSO-250308-148MAIN 99 154.92-15,336.7624137,334.95 Dec. 22, 2024: 99 @ 154.92
March 6, 2025issueSO-250306-747MAIN 11 154.92-1,704.0834052,671.71 Dec. 22, 2024: 11 @ 154.92
March 1, 2025issueSO-250301-348MAIN 43 154.92-6,661.4235154,375.80 Dec. 22, 2024: 43 @ 154.92
Feb. 26, 2025issueSO-250226-756MAIN 35 154.92-5,422.0939461,037.22 Dec. 22, 2024: 35 @ 154.92
Feb. 22, 2025issueSO-250222-609MAIN 30 154.92-4,647.5042966,459.31 Dec. 22, 2024: 30 @ 154.92
Feb. 18, 2025issueSO-250218-200MAIN 28 154.92-4,337.6745971,106.81 Dec. 22, 2024: 28 @ 154.92
Feb. 7, 2025issueSO-250207-444EAST 85 154.92-13,167.9348775,444.48 Dec. 22, 2024: 85 @ 154.92
Jan. 31, 2025issueSO-250131-808MAIN 42 154.92-6,506.5157288,612.41 Dec. 22, 2024: 42 @ 154.92
Jan. 12, 2025issueSO-250112-852MAIN 19 154.92-2,943.4261495,118.92 Dec. 22, 2024: 19 @ 154.92
Jan. 5, 2025issueSO-250105-462MAIN 69 154.92-10,689.2663398,062.33 Dec. 22, 2024: 69 @ 154.92
Jan. 1, 2025issueSO-250101-455MAIN 94 156.33-14,695.30702108,751.59 Oct. 1, 2024: 26 @ 160.04; Dec. 22, 2024: 68 @ 154.92
Dec. 31, 2024issueSO-241231-354EAST 7 160.04-1,120.26796123,446.90 Oct. 1, 2024: 7 @ 160.04
Dec. 23, 2024issueSO-241223-239MAIN 31 160.04-4,961.15803124,567.16 Oct. 1, 2024: 31 @ 160.04
Dec. 22, 2024transferTRFMAIN → EAST 205 warehouse transfer, no cost effect
Dec. 22, 2024receiptPO-000125MAIN 770 154.92119,285.94834129,528.30
Dec. 20, 2024issueSO-241220-925MAIN 66 160.04-10,562.446410,242.37 Oct. 1, 2024: 66 @ 160.04
Dec. 13, 2024issueSO-241213-780MAIN 157 160.04-25,125.8113020,804.81 Oct. 1, 2024: 157 @ 160.04
Dec. 11, 2024issueSO-241211-208MAIN 86 160.04-13,763.1828745,930.62 Oct. 1, 2024: 86 @ 160.04
Nov. 10, 2024issueSO-241110-128MAIN 104 160.04-16,643.8537359,693.80 Oct. 1, 2024: 104 @ 160.04
Nov. 2, 2024issueSO-241102-605MAIN 125 160.04-20,004.6247776,337.65 Oct. 1, 2024: 125 @ 160.04
Oct. 31, 2024issueSO-241031-757MAIN 140 160.04-22,405.1860296,342.27 Oct. 1, 2024: 140 @ 160.04
Oct. 18, 2024issueSO-241018-491MAIN 3 160.04-480.11742118,747.45 Oct. 1, 2024: 3 @ 160.04
Oct. 12, 2024issueSO-241012-177MAIN 21 160.04-3,360.78745119,227.56 Oct. 1, 2024: 21 @ 160.04
Oct. 7, 2024issueSO-241007-535MAIN 4 160.04-640.15766122,588.34 Oct. 1, 2024: 4 @ 160.04
Oct. 1, 2024receiptPO-000001MAIN 770 160.04123,228.49770123,228.49