stocksense

Items / LED-0003

Downlight 7W Nova LED-0003 · Lighting · BrightLine Lighting

On hand (EA)920MAIN 920
Value (FIFO)94,601.21avg 102.83
ClassAX / FCV 0.27
Turnover3.2xlast issue 3 days ago
Days of cover117lead time 10d

Demand and forecast

Monthly demand and forecast for LED-00030.099.6199299398Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 258.0Nov 24: 278.0Dec 24: 248.0Jan 25: 277.0Feb 25: 285.0Mar 25: 207.0Apr 25: 138.0May 25: 238.0Jun 25: 231.0Jul 25: 138.0Aug 25: 222.0Sep 25: 267.0Oct 25: 267.0Nov 25: 362.0Dec 25: 219.0Jan 26: 274.0Feb 26: 288.0Mar 26: 330.0Apr 26: 184.0May 26: 182.0Jun 26: 136.0Jul 26: 194.0Aug 26: 184.0Sep 26: 262.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.4375240.17 / 30.43757.890
Daily demand sdmonthly sd / sqrt(30.4375)64.98 / 5.51711.778
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 * 11.778^2 + 7.890^2 * 2.2^2)82.6
Reorder pointd * LT + safety stock7.890 * 9.6 + 82.6158.2
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days158.2
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 2880/yr, S = 45.00, h = 20%, price = 104.64111.3
Inventory positionon hand + on order920 + 0920

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

From qtyUnit costOrder qtyAnnual costFeasible
0104.64111303,695yes (chosen if cheapest)
1,940100.451,940308,866yes
3,88096.273,880314,642yes

MOQ 970, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 11, 2026920 / 970102.8394,601.21

Movement ledger 110 movements, latest 60 shown - show all

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 13, 2026issueSO-261013-645MAIN 81 103.31-8,368.2792094,601.21 May 15, 2026: 31 @ 104.09; Oct. 11, 2026: 50 @ 102.83
Oct. 11, 2026issueSO-261011-377MAIN 97 104.09-10,097.071,001102,969.48 May 15, 2026: 97 @ 104.09
Oct. 11, 2026receiptPO-001867MAIN 970 102.8399,742.581,098113,066.55
Oct. 10, 2026issueSO-261010-743MAIN 21 104.09-2,185.9612813,323.97 May 15, 2026: 21 @ 104.09
Sept. 26, 2026issueSO-260926-107MAIN 58 104.09-6,037.4214915,509.93 May 15, 2026: 58 @ 104.09
Sept. 22, 2026issueSO-260922-550MAIN 27 104.09-2,810.5220721,547.35 May 15, 2026: 27 @ 104.09
Sept. 20, 2026issueSO-260920-990MAIN 177 104.09-18,424.5523424,357.88 May 15, 2026: 177 @ 104.09
Aug. 29, 2026issueSO-260829-915MAIN 10 104.09-1,040.9441142,782.43 May 15, 2026: 10 @ 104.09
Aug. 25, 2026issueSO-260825-800MAIN 20 104.09-2,081.8742143,823.36 May 15, 2026: 20 @ 104.09
Aug. 23, 2026issueSO-260823-193MAIN 11 104.09-1,145.0344145,905.23 May 15, 2026: 11 @ 104.09
Aug. 20, 2026issueSO-260820-767MAIN 56 104.09-5,829.2445247,050.26 May 15, 2026: 56 @ 104.09
Aug. 17, 2026issueSO-260817-811MAIN 61 104.09-6,349.7050852,879.50 May 15, 2026: 61 @ 104.09
Aug. 9, 2026issueSO-260809-777MAIN 19 104.09-1,977.7856959,229.20 May 15, 2026: 19 @ 104.09
Aug. 6, 2026issueSO-260806-412MAIN 7 104.09-728.6558861,206.98 May 15, 2026: 7 @ 104.09
July 27, 2026issueSO-260727-510MAIN 102 104.09-10,617.5459561,935.63 May 15, 2026: 102 @ 104.09
July 20, 2026issueSO-260720-557MAIN 18 104.09-1,873.6869772,553.17 May 15, 2026: 18 @ 104.09
July 15, 2026issueSO-260715-597MAIN 3 104.09-312.2871574,426.85 May 15, 2026: 3 @ 104.09
July 1, 2026issueSO-260701-957MAIN 71 104.09-7,390.6471874,739.13 May 15, 2026: 71 @ 104.09
June 28, 2026issueSO-260628-846MAIN 42 104.09-4,371.9378982,129.77 May 15, 2026: 42 @ 104.09
June 26, 2026issueSO-260626-189MAIN 17 104.09-1,769.5983186,501.70 May 15, 2026: 17 @ 104.09
June 25, 2026issueSO-260625-243MAIN 46 104.09-4,788.3084888,271.29 May 15, 2026: 46 @ 104.09
June 15, 2026issueSO-260615-108MAIN 18 104.09-1,873.6889493,059.59 May 15, 2026: 18 @ 104.09
June 8, 2026issueSO-260608-380MAIN 13 104.09-1,353.2291294,933.27 May 15, 2026: 13 @ 104.09
May 26, 2026issueSO-260526-363MAIN 74 102.60-7,592.0692596,286.49 Jan. 20, 2026: 29 @ 100.27; May 15, 2026: 45 @ 104.09
May 24, 2026issueSO-260524-411MAIN 51 100.27-5,113.82999103,878.55 Jan. 20, 2026: 51 @ 100.27
May 15, 2026receiptPO-001494MAIN 970 104.09100,970.701,050108,992.37
May 14, 2026issueSO-260514-444MAIN 14 100.27-1,403.79808,021.67 Jan. 20, 2026: 14 @ 100.27
May 6, 2026issueSO-260506-305MAIN 43 100.27-4,311.65949,425.46 Jan. 20, 2026: 43 @ 100.27
May 1, 2026adjustmentCycle countMAIN -2 100.27-200.5413713,737.11 Jan. 20, 2026: 2 @ 100.27
April 15, 2026issueSO-260415-787MAIN 52 100.27-5,214.0913913,937.66 Jan. 20, 2026: 52 @ 100.27
April 7, 2026issueSO-260407-310MAIN 132 100.27-13,235.7619119,151.74 Jan. 20, 2026: 132 @ 100.27
March 24, 2026issueSO-260324-267MAIN 147 100.27-14,739.8232332,387.50 Jan. 20, 2026: 147 @ 100.27
March 10, 2026issueSO-260310-921MAIN 150 100.27-15,040.6447047,127.32 Jan. 20, 2026: 150 @ 100.27
March 3, 2026issueSO-260303-726MAIN 8 100.27-802.1762062,167.96 Jan. 20, 2026: 8 @ 100.27
March 2, 2026issueSO-260302-408MAIN 25 100.27-2,506.7762862,970.13 Jan. 20, 2026: 25 @ 100.27
Feb. 25, 2026issueSO-260225-356MAIN 69 100.27-6,918.6965365,476.90 Jan. 20, 2026: 69 @ 100.27
Feb. 21, 2026issueSO-260221-641MAIN 135 100.27-13,536.5772272,395.59 Jan. 20, 2026: 135 @ 100.27
Feb. 17, 2026issueSO-260217-211MAIN 84 100.27-8,422.7685785,932.16 Jan. 20, 2026: 84 @ 100.27
Jan. 31, 2026issueSO-260131-702MAIN 29 100.27-2,907.8694194,354.92 Jan. 20, 2026: 29 @ 100.27
Jan. 20, 2026receiptPO-001162MAIN 970 100.2797,262.7797097,262.77
Jan. 11, 2026issueSO-260111-360MAIN 245 100.04-24,510.8000.00 Oct. 7, 2025: 245 @ 100.04
Dec. 27, 2025issueSO-251227-797MAIN 48 100.04-4,802.1224524,510.80 Oct. 7, 2025: 48 @ 100.04
Dec. 14, 2025issueSO-251214-496MAIN 43 100.04-4,301.9029329,312.92 Oct. 7, 2025: 43 @ 100.04
Dec. 10, 2025issueSO-251210-993MAIN 87 100.04-8,703.8433633,614.82 Oct. 7, 2025: 87 @ 100.04
Dec. 6, 2025issueSO-251206-917MAIN 41 100.04-4,101.8142342,318.65 Oct. 7, 2025: 41 @ 100.04
Nov. 30, 2025issueSO-251130-253MAIN 98 100.04-9,804.3246446,420.46 Oct. 7, 2025: 98 @ 100.04
Nov. 26, 2025issueSO-251126-573MAIN 49 100.04-4,902.1656256,224.78 Oct. 7, 2025: 49 @ 100.04
Nov. 24, 2025issueSO-251124-285MAIN 177 100.04-17,707.8161161,126.95 Oct. 7, 2025: 177 @ 100.04
Nov. 19, 2025issueSO-251119-519MAIN 38 100.04-3,801.6878878,834.75 Oct. 7, 2025: 38 @ 100.04
Oct. 27, 2025issueSO-251027-206MAIN 8 100.04-800.3582682,636.43 Oct. 7, 2025: 8 @ 100.04
Oct. 23, 2025issueSO-251023-183MAIN 70 100.04-7,003.0983483,436.78 Oct. 7, 2025: 70 @ 100.04
Oct. 21, 2025issueSO-251021-483MAIN 18 100.04-1,800.7990490,439.87 Oct. 7, 2025: 18 @ 100.04
Oct. 14, 2025issueSO-251014-831MAIN 53 99.93-5,296.3892292,240.66 May 28, 2025: 5 @ 98.85; Oct. 7, 2025: 48 @ 100.04
Oct. 9, 2025issueSO-251009-191MAIN 50 98.85-4,942.6197597,537.04 May 28, 2025: 50 @ 98.85
Oct. 7, 2025receiptPO-000904MAIN 970 100.0497,042.781,025102,479.65
Oct. 2, 2025issueSO-251002-407MAIN 5 98.85-494.26555,436.87 May 28, 2025: 5 @ 98.85
Oct. 1, 2025issueSO-251001-689MAIN 63 98.85-6,227.69605,931.13 May 28, 2025: 63 @ 98.85
Sept. 28, 2025issueSO-250928-233MAIN 76 98.85-7,512.7712312,158.82 May 28, 2025: 76 @ 98.85
Sept. 24, 2025issueSO-250924-210MAIN 10 98.85-988.5219919,671.59 May 28, 2025: 10 @ 98.85
Sept. 23, 2025issueSO-250923-225MAIN 18 98.85-1,779.3420920,660.11 May 28, 2025: 18 @ 98.85