stocksense

Items / LED-0007

Street Light 90W Pro LED-0007 · Lighting · BrightLine Lighting

On hand (EA)185MAIN 185
Value (FIFO)28,798.37avg 155.67
ClassAX / FCV 0.27
Turnover4.3xlast issue 12 days ago
Days of cover88lead time 10d

Demand and forecast

Monthly demand and forecast for LED-00070.027.855.683.3111Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 92.0Nov 24: 101.0Dec 24: 78.0Jan 25: 87.0Feb 25: 84.0Mar 25: 82.0Apr 25: 39.0May 25: 61.0Jun 25: 50.0Jul 25: 46.0Aug 25: 45.0Sep 25: 47.0Oct 25: 86.0Nov 25: 58.0Dec 25: 81.0Jan 26: 68.0Feb 26: 95.0Mar 26: 49.0Apr 26: 79.0May 26: 50.0Jun 26: 63.0Jul 26: 49.0Aug 26: 49.0Sep 26: 38.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.437563.75 / 30.43752.094
Daily demand sdmonthly sd / sqrt(30.4375)17.22 / 5.5173.121
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 * 3.121^2 + 2.094^2 * 2.2^2)21.9
Reorder pointd * LT + safety stock2.094 * 9.6 + 21.942.0
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days42.0
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 764/yr, S = 45.00, h = 20%, price = 152.4747.5
Inventory positionon hand + on order185 + 0185

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

From qtyUnit costOrder qtyAnnual costFeasible
0152.4748118,008yes (chosen if cheapest)

MOQ 260, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Aug. 27, 2026179 / 260155.7727,882.51
Sept. 12, 20266 / 6152.64915.86

Movement ledger 130 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 4, 2026issueSO-261004-341MAIN 2 155.77-311.5418528,798.37 Aug. 27, 2026: 2 @ 155.77
Oct. 3, 2026issueSO-261003-426MAIN 53 155.77-8,255.7118729,109.91 Aug. 27, 2026: 53 @ 155.77
Sept. 25, 2026issueSO-260925-755MAIN 12 155.77-1,869.2224037,365.62 Aug. 27, 2026: 12 @ 155.77
Sept. 21, 2026issueSO-260921-874MAIN 4 155.77-623.0725239,234.84 Aug. 27, 2026: 4 @ 155.77
Sept. 13, 2026issueSO-260913-181MAIN 9 155.77-1,401.9125639,857.91 Aug. 27, 2026: 9 @ 155.77
Sept. 12, 2026returnRMAMAIN 6 152.64915.8626541,259.83
Sept. 12, 2026issueSO-260912-563MAIN 2 152.64-305.2925940,343.96 April 22, 2026: 1 @ 149.52; Aug. 27, 2026: 1 @ 155.77
Sept. 8, 2026issueSO-260908-540MAIN 4 149.52-598.0826140,649.25 April 22, 2026: 4 @ 149.52
Sept. 6, 2026issueSO-260906-943MAIN 13 149.52-1,943.7526541,247.33 April 22, 2026: 13 @ 149.52
Aug. 29, 2026issueSO-260829-953MAIN 12 149.52-1,794.2327843,191.08 April 22, 2026: 12 @ 149.52
Aug. 27, 2026receiptPO-001750MAIN 260 155.7740,499.7329044,985.30
Aug. 22, 2026issueSO-260822-581MAIN 1 149.52-149.52304,485.57 April 22, 2026: 1 @ 149.52
Aug. 15, 2026issueSO-260815-105MAIN 5 149.52-747.60314,635.09 April 22, 2026: 5 @ 149.52
Aug. 11, 2026issueSO-260811-572MAIN 2 149.52-299.04365,382.69 April 22, 2026: 2 @ 149.52
Aug. 9, 2026issueSO-260809-615MAIN 28 149.52-4,186.53385,681.73 April 22, 2026: 28 @ 149.52
Aug. 6, 2026issueSO-260806-702MAIN 1 149.52-149.52669,868.26 April 22, 2026: 1 @ 149.52
July 17, 2026issueSO-260717-663MAIN 1 149.52-149.526710,017.78 April 22, 2026: 1 @ 149.52
July 15, 2026issueSO-260715-159MAIN 14 149.52-2,093.276810,167.30 April 22, 2026: 14 @ 149.52
July 13, 2026issueSO-260713-414MAIN 24 149.52-3,588.468212,260.57 April 22, 2026: 24 @ 149.52
July 9, 2026issueSO-260709-925MAIN 3 149.52-448.5610615,849.02 April 22, 2026: 3 @ 149.52
July 3, 2026issueSO-260703-899MAIN 1 149.52-149.5210916,297.58 April 22, 2026: 1 @ 149.52
July 1, 2026issueSO-260701-827MAIN 6 149.52-897.1111016,447.10 April 22, 2026: 6 @ 149.52
June 20, 2026issueSO-260620-646MAIN 16 149.52-2,392.3111617,344.22 April 22, 2026: 16 @ 149.52
June 11, 2026issueSO-260611-203MAIN 36 149.52-5,382.6913219,736.52 April 22, 2026: 36 @ 149.52
June 2, 2026issueSO-260602-552MAIN 11 149.52-1,644.7116825,119.21 April 22, 2026: 11 @ 149.52
May 26, 2026issueSO-260526-393MAIN 4 149.52-598.0817926,763.92 April 22, 2026: 4 @ 149.52
May 17, 2026issueSO-260517-660MAIN 24 149.52-3,588.4618327,362.00 April 22, 2026: 24 @ 149.52
May 10, 2026issueSO-260510-723MAIN 1 149.52-149.5220730,950.45 April 22, 2026: 1 @ 149.52
May 5, 2026issueSO-260505-749MAIN 21 149.52-3,139.9020831,099.97 April 22, 2026: 21 @ 149.52
April 22, 2026issueSO-260422-381MAIN 31 149.52-4,635.0922934,239.87 April 22, 2026: 31 @ 149.52
April 22, 2026receiptPO-001429MAIN 260 149.5238,874.9726038,874.97
April 14, 2026issueSO-260414-687MAIN 42 146.67-6,160.3000.00 Jan. 1, 2026: 38 @ 146.67; Feb. 11, 2026: 4 @ 146.67
April 14, 2026issueSO-260414-687EAST 6 146.67-880.04426,160.30 Jan. 1, 2026: 6 @ 146.67
April 7, 2026adjustmentCycle countMAIN -2 146.67-293.35487,040.34 Jan. 1, 2026: 2 @ 146.67
March 29, 2026issueSO-260329-240MAIN 4 146.67-586.70507,333.69 Jan. 1, 2026: 4 @ 146.67
March 16, 2026issueSO-260316-330MAIN 30 146.67-4,400.21547,920.39 Jan. 1, 2026: 30 @ 146.67
March 7, 2026issueSO-260307-533EAST 15 146.67-2,200.118412,320.60 Jan. 1, 2026: 15 @ 146.67
Feb. 21, 2026issueSO-260221-367MAIN 56 146.67-8,213.739914,520.71 Jan. 1, 2026: 56 @ 146.67
Feb. 17, 2026issueSO-260217-681MAIN 1 146.67-146.6715522,734.44 Jan. 1, 2026: 1 @ 146.67
Feb. 12, 2026issueSO-260212-434MAIN 7 146.67-1,026.7215622,881.11 Jan. 1, 2026: 7 @ 146.67
Feb. 11, 2026returnRMAMAIN 4 146.67586.7016323,907.83
Feb. 8, 2026issueSO-260208-677EAST 31 146.67-4,546.8915923,321.13 Jan. 1, 2026: 31 @ 146.67
Feb. 5, 2026issueSO-260205-996MAIN 4 146.67-586.7019027,868.02 Jan. 1, 2026: 4 @ 146.67
Feb. 4, 2026adjustmentCycle countMAIN -1 146.67-146.6719428,454.72 Jan. 1, 2026: 1 @ 146.67
Jan. 30, 2026issueSO-260130-990EAST 9 146.67-1,320.0619528,601.39 Jan. 1, 2026: 9 @ 146.67
Jan. 29, 2026issueSO-260129-151MAIN 2 146.67-293.3520429,921.46 Jan. 1, 2026: 2 @ 146.67
Jan. 28, 2026issueSO-260128-173MAIN 9 146.67-1,320.0620630,214.80 Jan. 1, 2026: 9 @ 146.67
Jan. 22, 2026issueSO-260122-803MAIN 14 146.67-2,053.4321531,534.87 Jan. 1, 2026: 14 @ 146.67
Jan. 13, 2026issueSO-260113-166EAST 24 146.67-3,520.1722933,588.30 Jan. 1, 2026: 24 @ 146.67
Jan. 11, 2026issueSO-260111-898MAIN 8 146.89-1,175.1325337,108.47 Nov. 27, 2025: 1 @ 148.41; Jan. 1, 2026: 7 @ 146.67
Jan. 6, 2026issueSO-260106-348MAIN 2 148.41-296.8226138,283.60 Nov. 27, 2025: 2 @ 148.41
Jan. 1, 2026transferTRFMAIN → EAST 85 warehouse transfer, no cost effect
Jan. 1, 2026receiptPO-001109MAIN 260 146.6738,135.1926338,580.42
Dec. 31, 2025issueSO-251231-967MAIN 20 148.41-2,968.223445.23 Sept. 3, 2025: 1 @ 148.41; Oct. 9, 2025: 5 @ 148.41; Nov. 27, 2025: 14 @ 148.41
Dec. 29, 2025issueSO-251229-768MAIN 5 148.41-742.06233,413.46 Sept. 3, 2025: 5 @ 148.41
Dec. 22, 2025issueSO-251222-672MAIN 11 148.41-1,632.52284,155.51 Sept. 3, 2025: 11 @ 148.41
Dec. 21, 2025issueSO-251221-602MAIN 11 148.41-1,632.52395,788.04 Sept. 3, 2025: 11 @ 148.41
Dec. 18, 2025issueSO-251218-601MAIN 16 148.41-2,374.58507,420.56 Sept. 3, 2025: 16 @ 148.41
Dec. 9, 2025issueSO-251209-170MAIN 11 148.41-1,632.52669,795.14 Sept. 3, 2025: 11 @ 148.41
Dec. 2, 2025issueSO-251202-142MAIN 7 148.41-1,038.887711,427.66 Sept. 3, 2025: 7 @ 148.41
Nov. 30, 2025issueSO-251130-159MAIN 2 148.41-296.828412,466.54 Sept. 3, 2025: 2 @ 148.41
Nov. 27, 2025returnRMAMAIN 17 148.412,522.998612,763.36
Nov. 17, 2025issueSO-251117-294MAIN 35 148.41-5,194.396910,240.37 Sept. 3, 2025: 35 @ 148.41
Nov. 14, 2025issueSO-251114-852MAIN 13 148.41-1,929.3510415,434.76 Sept. 3, 2025: 13 @ 148.41
Nov. 3, 2025issueSO-251103-350MAIN 25 148.41-3,710.2811717,364.11 Sept. 3, 2025: 25 @ 148.41
Oct. 23, 2025issueSO-251023-913MAIN 23 148.41-3,413.4614221,074.39 Sept. 3, 2025: 23 @ 148.41
Oct. 19, 2025issueSO-251019-276MAIN 13 148.41-1,929.3516524,487.85 Sept. 3, 2025: 13 @ 148.41
Oct. 9, 2025returnRMAMAIN 5 148.41742.0617826,417.19
Oct. 4, 2025issueSO-251004-984MAIN 28 148.41-4,155.5117325,675.14 Sept. 3, 2025: 28 @ 148.41
Oct. 3, 2025issueSO-251003-111MAIN 10 148.41-1,484.1120129,830.65 Sept. 3, 2025: 10 @ 148.41
Oct. 1, 2025issueSO-251001-707MAIN 17 148.41-2,522.9921131,314.76 Sept. 3, 2025: 17 @ 148.41
Sept. 27, 2025issueSO-250927-206MAIN 20 148.41-2,968.2222833,837.75 Sept. 3, 2025: 20 @ 148.41
Sept. 24, 2025issueSO-250924-652MAIN 1 148.41-148.4124836,805.98 Sept. 3, 2025: 1 @ 148.41
Sept. 23, 2025issueSO-250923-651MAIN 9 148.41-1,335.7024936,954.39 Sept. 3, 2025: 9 @ 148.41
Sept. 13, 2025issueSO-250913-524MAIN 13 142.40-1,851.2425838,290.09 March 18, 2025: 10 @ 141.31; June 18, 2025: 1 @ 141.31; Sept. 3, 2025: 2 @ 148.41
Sept. 8, 2025issueSO-250908-681MAIN 4 141.31-565.2427140,141.33 March 18, 2025: 4 @ 141.31
Sept. 3, 2025receiptPO-000812MAIN 260 148.4138,586.9127540,706.57
Aug. 31, 2025issueSO-250831-347MAIN 21 141.31-2,967.52152,119.66 March 18, 2025: 21 @ 141.31
Aug. 25, 2025issueSO-250825-603MAIN 7 141.31-989.17365,087.18 March 18, 2025: 7 @ 141.31
Aug. 25, 2025issueSO-250825-603EAST 8 141.31-1,130.48436,076.35 March 18, 2025: 8 @ 141.31
Aug. 22, 2025issueSO-250822-848EAST 5 141.31-706.55517,206.84 March 18, 2025: 5 @ 141.31
Aug. 19, 2025issueSO-250819-951MAIN 4 141.31-565.24567,913.39 March 18, 2025: 4 @ 141.31
July 29, 2025issueSO-250729-222MAIN 9 141.31-1,271.79608,478.63 March 18, 2025: 9 @ 141.31
July 25, 2025issueSO-250725-649MAIN 2 141.31-282.62699,750.42 March 18, 2025: 2 @ 141.31
July 23, 2025issueSO-250723-480MAIN 1 141.31-141.317110,033.05 March 18, 2025: 1 @ 141.31
July 18, 2025issueSO-250718-615MAIN 8 141.31-1,130.487210,174.36 March 18, 2025: 8 @ 141.31
July 6, 2025issueSO-250706-433MAIN 8 141.31-1,130.488011,304.84 March 18, 2025: 8 @ 141.31
July 4, 2025issueSO-250704-353MAIN 18 141.31-2,543.598812,435.32 March 18, 2025: 18 @ 141.31
June 26, 2025issueSO-250626-974EAST 4 141.31-565.2410614,978.91 March 18, 2025: 4 @ 141.31
June 20, 2025issueSO-250620-667MAIN 8 141.31-1,130.4811015,544.16 March 18, 2025: 8 @ 141.31
June 18, 2025returnRMAMAIN 1 141.31141.3111816,674.64
June 16, 2025issueSO-250616-349MAIN 21 141.31-2,967.5211716,533.33 March 18, 2025: 21 @ 141.31
June 15, 2025issueSO-250615-355EAST 3 141.31-423.9313819,500.85 March 18, 2025: 3 @ 141.31
June 10, 2025issueSO-250610-388MAIN 10 141.31-1,413.1014119,924.78 March 18, 2025: 10 @ 141.31
June 8, 2025issueSO-250608-907MAIN 5 141.31-706.5515121,337.89 March 18, 2025: 5 @ 141.31
May 22, 2025issueSO-250522-305MAIN 14 141.31-1,978.3515622,044.44 March 18, 2025: 14 @ 141.31
May 17, 2025issueSO-250517-605MAIN 34 141.31-4,804.5617024,022.78 March 18, 2025: 34 @ 141.31
May 10, 2025issueSO-250510-498MAIN 9 141.31-1,271.7920428,827.34 March 18, 2025: 9 @ 141.31
May 8, 2025issueSO-250508-969EAST 1 141.31-141.3121330,099.14 March 18, 2025: 1 @ 141.31
May 7, 2025issueSO-250507-700MAIN 2 141.31-282.6221430,240.45 March 18, 2025: 2 @ 141.31
May 5, 2025issueSO-250505-440MAIN 1 141.31-141.3121630,523.07 March 18, 2025: 1 @ 141.31
April 27, 2025issueSO-250427-967EAST 4 141.31-565.2421730,664.38 March 18, 2025: 4 @ 141.31
April 24, 2025issueSO-250424-929EAST 33 141.31-4,663.2522131,229.62 March 18, 2025: 33 @ 141.31
April 21, 2025issueSO-250421-918MAIN 2 141.31-282.6225435,892.87 March 18, 2025: 2 @ 141.31
March 27, 2025issueSO-250327-586MAIN 4 141.31-565.2425636,175.49 March 18, 2025: 4 @ 141.31
March 18, 2025transferTRFMAIN → EAST 58 warehouse transfer, no cost effect
March 18, 2025receiptPO-000350MAIN 260 141.3136,740.7326036,740.73
March 5, 2025issueSO-250305-468MAIN 78 141.48-11,035.3100.00 Dec. 16, 2024: 78 @ 141.48
Feb. 28, 2025issueSO-250228-878MAIN 28 141.48-3,961.397811,035.31 Dec. 16, 2024: 28 @ 141.48
Feb. 26, 2025issueSO-250226-937MAIN 23 141.48-3,254.0010614,996.70 Dec. 16, 2024: 23 @ 141.48
Feb. 20, 2025issueSO-250220-424MAIN 16 141.48-2,263.6512918,250.70 Dec. 16, 2024: 16 @ 141.48
Feb. 19, 2025issueSO-250219-771MAIN 8 141.48-1,131.8314520,514.35 Dec. 16, 2024: 8 @ 141.48
Feb. 17, 2025issueSO-250217-648MAIN 6 141.48-848.8715321,646.18 Dec. 16, 2024: 6 @ 141.48
Feb. 8, 2025issueSO-250208-212MAIN 2 141.48-282.9615922,495.05 Dec. 16, 2024: 2 @ 141.48
Feb. 2, 2025issueSO-250202-438MAIN 1 141.48-141.4816122,778.01 Dec. 16, 2024: 1 @ 141.48
Jan. 26, 2025issueSO-250126-391MAIN 72 141.48-10,186.4416222,919.48 Dec. 16, 2024: 72 @ 141.48
Jan. 24, 2025issueSO-250124-611MAIN 10 141.48-1,414.7823433,105.92 Dec. 16, 2024: 10 @ 141.48
Jan. 3, 2025issueSO-250103-354MAIN 5 141.48-707.3924434,520.71 Dec. 16, 2024: 5 @ 141.48
Dec. 18, 2024issueSO-241218-193MAIN 2 141.48-282.9624935,228.10 Dec. 16, 2024: 2 @ 141.48
Dec. 17, 2024issueSO-241217-804MAIN 9 141.48-1,273.3025135,511.05 Dec. 16, 2024: 9 @ 141.48
Dec. 16, 2024receiptPO-000108MAIN 260 141.4836,784.3626036,784.36
Dec. 7, 2024issueSO-241207-809MAIN 2 144.85-289.6900.00 Oct. 1, 2024: 2 @ 144.85
Dec. 5, 2024issueSO-241205-225MAIN 60 144.85-8,690.792289.69 Oct. 1, 2024: 60 @ 144.85
Dec. 2, 2024issueSO-241202-990MAIN 5 144.85-724.23628,980.48 Oct. 1, 2024: 5 @ 144.85
Nov. 4, 2024issueSO-241104-717MAIN 66 144.85-9,559.87679,704.72 Oct. 1, 2024: 66 @ 144.85
Nov. 2, 2024issueSO-241102-756MAIN 35 144.85-5,069.6313319,264.58 Oct. 1, 2024: 35 @ 144.85
Oct. 27, 2024issueSO-241027-784MAIN 22 144.85-3,186.6216824,334.21 Oct. 1, 2024: 22 @ 144.85
Oct. 19, 2024issueSO-241019-212MAIN 19 144.85-2,752.0819027,520.84 Oct. 1, 2024: 19 @ 144.85
Oct. 4, 2024issueSO-241004-452MAIN 51 144.85-7,387.1720930,272.92 Oct. 1, 2024: 51 @ 144.85
Oct. 1, 2024receiptPO-000001MAIN 260 144.8537,660.0926037,660.09