stocksense

Items / FAN-0007

Wall Fan 400mm Elite FAN-0007 · Ceiling Fans · CoolBreeze Appliances

On hand (EA)50MAIN 50
Value (FIFO)5,092.30avg 101.85
ClassAY / FCV 0.90
Turnover4.7xlast issue 1 days ago
Days of cover52lead time 22d

Reorder suggested: 40 units (position at or below reorder point: order EOQ), stockout risk low.

Demand and forecast

Monthly demand and forecast for FAN-00070.028.356.785.0113Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 14.0Nov 24: 5.0Dec 24: 7.0Jan 25: 17.0Feb 25: 15.0Mar 25: 21.0Apr 25: 53.0May 25: 41.0Jun 25: 65.0Jul 25: 58.0Aug 25: 14.0Sep 25: 14.0Oct 25: 12.0Nov 25: 6.0Dec 25: 8.0Jan 26: 18.0Feb 26: 16.0Mar 26: 20.0Apr 26: 37.0May 26: 57.0Jun 26: 103.0Jul 26: 38.0Aug 26: 23.0Sep 26: 13.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.437529.25 / 30.43750.961
Daily demand sdmonthly sd / sqrt(30.4375)26.34 / 5.5174.775
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(21.5 * 4.775^2 + 0.961^2 * 7.4^2)47.8
Reorder pointd * LT + safety stock0.961 * 21.5 + 47.868.4
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days68.4
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 351/yr, S = 45.00, h = 20%, price = 101.7539.4
Inventory positionon hand + on order50 + 050

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

From qtyUnit costOrder qtyAnnual costFeasible
0101.753936,491yes (chosen if cheapest)

MOQ 16, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
July 1, 202650 / 96101.855,092.30

Movement ledger 125 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 15, 2026issueSO-261015-226MAIN 5 101.85-509.23505,092.30 July 1, 2026: 5 @ 101.85
Oct. 9, 2026issueSO-261009-292MAIN 4 101.85-407.38555,601.52 July 1, 2026: 4 @ 101.85
Oct. 4, 2026issueSO-261004-285MAIN 2 101.85-203.69596,008.91 July 1, 2026: 2 @ 101.85
Sept. 22, 2026issueSO-260922-544MAIN 2 101.85-203.69616,212.60 July 1, 2026: 2 @ 101.85
Sept. 9, 2026issueSO-260909-998MAIN 11 101.85-1,120.30636,416.29 July 1, 2026: 11 @ 101.85
Aug. 29, 2026issueSO-260829-273MAIN 6 101.85-611.08747,536.60 July 1, 2026: 6 @ 101.85
Aug. 29, 2026issueSO-260829-273EAST 6 101.85-611.08808,147.67 July 1, 2026: 6 @ 101.85
Aug. 5, 2026issueSO-260805-468EAST 11 101.74-1,119.14868,758.75 May 20, 2026: 1 @ 100.68; July 1, 2026: 10 @ 101.85
July 13, 2026issueSO-260713-422EAST 13 100.68-1,308.87979,877.89 May 20, 2026: 13 @ 100.68
July 12, 2026issueSO-260712-756MAIN 20 100.68-2,013.6511011,186.76 May 20, 2026: 20 @ 100.68
July 6, 2026issueSO-260706-640EAST 1 100.68-100.6813013,200.41 May 20, 2026: 1 @ 100.68
July 1, 2026issueSO-260701-399MAIN 4 100.68-402.7313113,301.09 May 20, 2026: 4 @ 100.68
July 1, 2026transferTRFMAIN → EAST 31 warehouse transfer, no cost effect
July 1, 2026receiptPO-001615MAIN 96 101.859,777.2113513,703.82
June 29, 2026issueSO-260629-718MAIN 96 100.62-9,659.60393,926.62 March 30, 2026: 9 @ 100.96; April 14, 2026: 2 @ 96.48; May 20, 2026: 85 @ 100.68
June 20, 2026issueSO-260620-970MAIN 7 100.96-706.7013513,586.21 March 30, 2026: 7 @ 100.96
May 24, 2026issueSO-260524-277MAIN 1 100.96-100.9614214,292.92 March 30, 2026: 1 @ 100.96
May 21, 2026issueSO-260521-422MAIN 6 100.96-605.7514314,393.88 March 30, 2026: 6 @ 100.96
May 21, 2026issueSO-260521-422EAST 5 100.96-504.7914914,999.62 March 30, 2026: 5 @ 100.96
May 20, 2026receiptPO-001511MAIN 124 100.6812,484.6315415,504.41
May 19, 2026issueSO-260519-247EAST 21 100.96-2,120.11303,019.78 March 30, 2026: 21 @ 100.96
May 13, 2026issueSO-260513-157EAST 1 100.96-100.96515,139.90 March 30, 2026: 1 @ 100.96
May 7, 2026issueSO-260507-337MAIN 8 100.96-807.66525,240.85 March 30, 2026: 8 @ 100.96
May 1, 2026issueSO-260501-104MAIN 15 100.96-1,514.37606,048.52 March 30, 2026: 15 @ 100.96
April 16, 2026issueSO-260416-559MAIN 17 99.55-1,692.36757,562.88 Aug. 3, 2025: 4 @ 95.97; Sept. 4, 2025: 1 @ 97.00; March 30, 2026: 12 @ 100.96
April 14, 2026returnRMAMAIN 2 96.48192.96929,255.24
April 14, 2026issueSO-260414-223MAIN 20 96.48-1,929.63909,062.28 July 6, 2025: 10 @ 97.00; Aug. 3, 2025: 10 @ 95.97
April 13, 2026issueSO-260413-704MAIN 2 97.00-193.9911010,991.91 July 6, 2025: 2 @ 97.00
March 30, 2026transferTRFMAIN → EAST 27 warehouse transfer, no cost effect
March 30, 2026receiptPO-001367MAIN 85 100.968,581.4111211,185.90
March 29, 2026issueSO-260329-664MAIN 4 97.00-387.99272,604.49 July 6, 2025: 4 @ 97.00
March 17, 2026issueSO-260317-300MAIN 14 97.00-1,357.95312,992.47 July 6, 2025: 14 @ 97.00
March 8, 2026issueSO-260308-468MAIN 2 97.00-193.99454,350.43 July 6, 2025: 2 @ 97.00
Feb. 27, 2026issueSO-260227-338MAIN 4 97.00-387.99474,544.42 July 6, 2025: 4 @ 97.00
Feb. 22, 2026issueSO-260222-269MAIN 3 97.00-290.99514,932.41 July 6, 2025: 3 @ 97.00
Feb. 20, 2026issueSO-260220-269MAIN 1 97.00-97.00545,223.40 July 6, 2025: 1 @ 97.00
Feb. 17, 2026issueSO-260217-437MAIN 8 97.00-775.97555,320.40 July 6, 2025: 8 @ 97.00
Jan. 30, 2026issueSO-260130-438MAIN 2 97.00-193.99636,096.37 July 6, 2025: 2 @ 97.00
Jan. 27, 2026issueSO-260127-652MAIN 7 97.00-678.98656,290.36 July 6, 2025: 7 @ 97.00
Jan. 24, 2026issueSO-260124-150MAIN 2 97.00-193.99726,969.34 July 6, 2025: 2 @ 97.00
Jan. 23, 2026issueSO-260123-741MAIN 5 97.00-484.98747,163.33 July 6, 2025: 5 @ 97.00
Jan. 7, 2026issueSO-260107-142MAIN 1 97.00-97.00797,648.32 July 6, 2025: 1 @ 97.00
Jan. 1, 2026issueSO-260101-667MAIN 1 97.00-97.00807,745.31 July 6, 2025: 1 @ 97.00
Dec. 31, 2025issueSO-251231-675MAIN 4 97.00-387.99817,842.31 July 6, 2025: 4 @ 97.00
Dec. 30, 2025issueSO-251230-369MAIN 1 97.00-97.00858,230.30 July 6, 2025: 1 @ 97.00
Dec. 22, 2025issueSO-251222-492MAIN 1 97.00-97.00868,327.29 July 6, 2025: 1 @ 97.00
Dec. 17, 2025issueSO-251217-544MAIN 1 97.00-97.00878,424.29 July 6, 2025: 1 @ 97.00
Dec. 14, 2025issueSO-251214-866MAIN 1 97.00-97.00888,521.29 July 6, 2025: 1 @ 97.00
Nov. 24, 2025issueSO-251124-895MAIN 2 97.00-193.99898,618.28 July 6, 2025: 2 @ 97.00
Nov. 3, 2025issueSO-251103-694MAIN 4 97.00-387.99918,812.28 July 6, 2025: 4 @ 97.00
Oct. 31, 2025issueSO-251031-228MAIN 2 97.00-193.99959,200.26 July 6, 2025: 2 @ 97.00
Oct. 28, 2025issueSO-251028-213MAIN 4 97.00-387.99979,394.26 July 6, 2025: 4 @ 97.00
Oct. 21, 2025issueSO-251021-873MAIN 3 97.00-290.991019,782.24 July 6, 2025: 3 @ 97.00
Oct. 10, 2025issueSO-251010-992MAIN 1 97.00-97.0010410,073.23 July 6, 2025: 1 @ 97.00
Oct. 3, 2025issueSO-251003-443MAIN 2 97.00-193.9910510,170.23 July 6, 2025: 2 @ 97.00
Sept. 26, 2025issueSO-250926-560MAIN 1 97.00-97.0010710,364.22 July 6, 2025: 1 @ 97.00
Sept. 23, 2025issueSO-250923-531MAIN 2 97.00-193.9910810,461.22 July 6, 2025: 2 @ 97.00
Sept. 15, 2025issueSO-250915-309MAIN 5 97.00-484.9811010,655.21 July 6, 2025: 5 @ 97.00
Sept. 14, 2025issueSO-250914-507MAIN 4 97.00-387.9911511,140.20 July 6, 2025: 4 @ 97.00
Sept. 12, 2025issueSO-250912-122MAIN 2 97.00-193.9911911,528.18 July 6, 2025: 2 @ 97.00
Sept. 6, 2025issueSO-250906-678MAIN 1 97.00-97.0012111,722.18 July 6, 2025: 1 @ 97.00
Sept. 4, 2025returnRMAMAIN 1 97.0097.0012211,819.17
Aug. 23, 2025issueSO-250823-770MAIN 3 97.00-290.9912111,722.18 July 6, 2025: 3 @ 97.00
Aug. 22, 2025issueSO-250822-696MAIN 4 97.00-387.9912412,013.17 July 6, 2025: 4 @ 97.00
Aug. 17, 2025issueSO-250817-892MAIN 2 97.00-193.9912812,401.15 July 6, 2025: 2 @ 97.00
Aug. 9, 2025issueSO-250809-870MAIN 12 97.00-1,163.9613012,595.15 July 6, 2025: 12 @ 97.00
Aug. 5, 2025issueSO-250805-897MAIN 3 96.65-289.9614213,759.11 May 13, 2025: 1 @ 95.97; July 6, 2025: 2 @ 97.00
Aug. 3, 2025returnRMAMAIN 14 95.971,343.5314514,049.07
Aug. 1, 2025issueSO-250801-840MAIN 4 95.97-383.8713112,705.54 May 13, 2025: 4 @ 95.97
July 29, 2025issueSO-250729-998MAIN 3 95.97-287.9013513,089.40 May 13, 2025: 3 @ 95.97
July 20, 2025issueSO-250720-770MAIN 10 95.97-959.6613813,377.30 May 13, 2025: 10 @ 95.97
July 18, 2025issueSO-250718-795MAIN 28 95.97-2,687.0614814,336.97 May 13, 2025: 28 @ 95.97
July 9, 2025issueSO-250709-328MAIN 2 95.97-191.9317617,024.03 May 13, 2025: 2 @ 95.97
July 6, 2025receiptPO-000687MAIN 130 97.0012,609.5717817,215.96
July 4, 2025issueSO-250704-473MAIN 7 95.97-671.77484,606.39 May 13, 2025: 7 @ 95.97
July 2, 2025issueSO-250702-380MAIN 8 95.97-767.73555,278.16 May 13, 2025: 8 @ 95.97
June 30, 2025issueSO-250630-986MAIN 7 95.97-671.77636,045.89 May 13, 2025: 7 @ 95.97
June 6, 2025issueSO-250606-780MAIN 7 95.97-671.77706,717.66 May 13, 2025: 7 @ 95.97
June 6, 2025issueSO-250606-780EAST 33 95.97-3,166.89777,389.42 May 13, 2025: 33 @ 95.97
June 4, 2025issueSO-250604-328MAIN 18 96.20-1,731.5211010,556.32 May 12, 2025: 4 @ 97.00; May 13, 2025: 14 @ 95.97
May 13, 2025transferTRFMAIN → EAST 33 warehouse transfer, no cost effect
May 13, 2025receiptPO-000534MAIN 124 95.9711,899.8512812,287.83
May 12, 2025returnRMAMAIN 4 97.00387.994387.99
May 12, 2025issueSO-250512-630MAIN 29 97.00-2,812.9000.00 March 31, 2025: 29 @ 97.00
May 3, 2025issueSO-250503-917MAIN 16 97.00-1,551.94292,812.90 March 31, 2025: 16 @ 97.00
April 26, 2025issueSO-250426-377MAIN 8 97.00-775.97454,364.84 March 31, 2025: 8 @ 97.00
April 14, 2025issueSO-250414-198MAIN 14 97.00-1,357.95535,140.81 March 31, 2025: 14 @ 97.00
April 13, 2025issueSO-250413-425MAIN 31 95.48-2,959.88676,498.77 March 16, 2025: 13 @ 93.38; March 31, 2025: 18 @ 97.00
March 31, 2025receiptPO-000396MAIN 85 97.008,244.70989,458.64
March 23, 2025issueSO-250323-819MAIN 4 93.38-373.52131,213.94 March 16, 2025: 4 @ 93.38
March 22, 2025issueSO-250322-653MAIN 1 93.38-93.38171,587.46 March 16, 2025: 1 @ 93.38
March 21, 2025issueSO-250321-223EAST 7 93.38-653.66181,680.84 March 16, 2025: 7 @ 93.38
March 19, 2025issueSO-250319-810MAIN 6 93.38-560.28252,334.50 March 16, 2025: 6 @ 93.38
March 16, 2025transferTRFMAIN → EAST 7 warehouse transfer, no cost effect
March 16, 2025receiptPO-000346MAIN 31 93.382,894.78312,894.78
March 12, 2025issueSO-250312-838MAIN 1 96.66-96.6600.00 Oct. 26, 2024: 1 @ 96.66
March 7, 2025issueSO-250307-652MAIN 2 96.66-193.32196.66 Oct. 1, 2024: 2 @ 96.66
Feb. 21, 2025issueSO-250221-142MAIN 2 96.66-193.323289.99 Oct. 1, 2024: 2 @ 96.66
Feb. 13, 2025issueSO-250213-777MAIN 7 96.66-676.645483.31 Oct. 1, 2024: 7 @ 96.66
Feb. 9, 2025issueSO-250209-146MAIN 2 96.66-193.32121,159.95 Oct. 1, 2024: 2 @ 96.66
Feb. 6, 2025issueSO-250206-643MAIN 2 96.66-193.32141,353.28 Oct. 1, 2024: 2 @ 96.66
Feb. 6, 2025issueSO-250206-643EAST 2 96.66-193.32161,546.60 Oct. 1, 2024: 2 @ 96.66
Jan. 27, 2025issueSO-250127-817MAIN 1 96.66-96.66181,739.92 Oct. 1, 2024: 1 @ 96.66
Jan. 23, 2025issueSO-250123-968MAIN 2 96.66-193.32191,836.59 Oct. 1, 2024: 2 @ 96.66
Jan. 22, 2025issueSO-250122-766MAIN 1 96.66-96.66212,029.91 Oct. 1, 2024: 1 @ 96.66
Jan. 17, 2025issueSO-250117-470MAIN 5 96.66-483.31222,126.58 Oct. 1, 2024: 5 @ 96.66
Jan. 7, 2025issueSO-250107-507MAIN 3 96.66-289.99272,609.89 Oct. 1, 2024: 3 @ 96.66
Jan. 4, 2025issueSO-250104-937EAST 5 96.66-483.31302,899.88 Oct. 1, 2024: 5 @ 96.66
Dec. 31, 2024issueSO-241231-543MAIN 1 96.66-96.66353,383.19 Oct. 1, 2024: 1 @ 96.66
Dec. 29, 2024issueSO-241229-192EAST 2 96.66-193.32363,479.85 Oct. 1, 2024: 2 @ 96.66
Dec. 26, 2024issueSO-241226-417MAIN 2 96.66-193.32383,673.18 Oct. 1, 2024: 2 @ 96.66
Dec. 17, 2024issueSO-241217-836MAIN 1 96.66-96.66403,866.50 Oct. 1, 2024: 1 @ 96.66
Dec. 10, 2024issueSO-241210-763EAST 1 96.66-96.66413,963.16 Oct. 1, 2024: 1 @ 96.66
Dec. 6, 2024adjustmentCycle countMAIN -2 96.66-193.32424,059.82 Oct. 1, 2024: 2 @ 96.66
Nov. 17, 2024issueSO-241117-238EAST 4 96.66-386.65444,253.15 Oct. 1, 2024: 4 @ 96.66
Nov. 10, 2024issueSO-241110-393MAIN 1 96.66-96.66484,639.80 Oct. 1, 2024: 1 @ 96.66
Oct. 26, 2024returnRMAMAIN 1 96.6696.66494,736.46
Oct. 21, 2024issueSO-241021-817MAIN 4 96.66-386.65484,639.80 Oct. 1, 2024: 4 @ 96.66
Oct. 19, 2024issueSO-241019-640EAST 1 96.66-96.66525,026.45 Oct. 1, 2024: 1 @ 96.66
Oct. 18, 2024issueSO-241018-474MAIN 4 96.66-386.65535,123.11 Oct. 1, 2024: 4 @ 96.66
Oct. 7, 2024issueSO-241007-930EAST 1 96.66-96.66575,509.76 Oct. 1, 2024: 1 @ 96.66
Oct. 6, 2024issueSO-241006-384MAIN 2 96.66-193.32585,606.42 Oct. 1, 2024: 2 @ 96.66
Oct. 3, 2024issueSO-241003-867MAIN 3 96.66-289.99605,799.75 Oct. 1, 2024: 3 @ 96.66
Oct. 1, 2024transferTRFMAIN → EAST 16 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000003MAIN 63 96.666,089.74636,089.74