stocksense

Items / FAN-0025

Table Fan 300mm Elite FAN-0025 · Ceiling Fans · CoolBreeze Appliances

On hand (EA)2MAIN 2
Value (FIFO)180.95avg 90.47
ClassBY / FCV 0.75
Turnover25.9xlast issue 2 days ago
Days of cover3lead time 22d

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

Demand and forecast

Monthly demand and forecast for FAN-00250.018.737.456.174.8Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 12.0Nov 24: 2.0Dec 24: 6.0Jan 25: 10.0Feb 25: 15.0Mar 25: 22.0Apr 25: 68.0May 25: 57.0Jun 25: 51.0Jul 25: 30.0Aug 25: 26.0Sep 25: 17.0Oct 25: 9.0Nov 25: 6.0Dec 25: 9.0Jan 26: 10.0Feb 26: 10.0Mar 26: 24.0Apr 26: 23.0May 26: 54.0Jun 26: 66.0Jul 26: 27.0Aug 26: 28.0Sep 26: 22.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.437524.00 / 30.43750.789
Daily demand sdmonthly sd / sqrt(30.4375)17.94 / 5.5173.251
Service level / zz = Phi^-1(service level)Phi^-1(0.950)1.645
Safety stockz * sqrt(LT * sd_d^2 + d^2 * sd_LT^2)1.645 * sqrt(21.5 * 3.251^2 + 0.789^2 * 7.4^2)26.6
Reorder pointd * LT + safety stock0.789 * 21.5 + 26.643.6
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days43.6
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 288/yr, S = 45.00, h = 20%, price = 90.3737.9
Inventory positionon hand + on order2 + 02

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

From qtyUnit costOrder qtyAnnual costFeasible
090.373826,693yes (chosen if cheapest)

MOQ 13, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
July 8, 20261 / 7990.4790.47
Oct. 16, 20261 / 190.4790.47

Movement ledger 125 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026returnRMAMAIN 1 90.4790.472180.95
Oct. 14, 2026issueSO-261014-782MAIN 2 90.47-180.95190.47 July 8, 2026: 2 @ 90.47
Oct. 12, 2026issueSO-261012-355MAIN 2 90.47-180.953271.42 July 8, 2026: 2 @ 90.47
Oct. 6, 2026issueSO-261006-331MAIN 2 90.47-180.955452.37 July 8, 2026: 2 @ 90.47
Oct. 2, 2026issueSO-261002-314MAIN 4 90.47-361.907633.32 July 8, 2026: 4 @ 90.47
Sept. 29, 2026issueSO-260929-546MAIN 8 90.47-723.7911995.21 July 8, 2026: 8 @ 90.47
Sept. 28, 2026issueSO-260928-892MAIN 3 90.47-271.42191,719.00 July 8, 2026: 3 @ 90.47
Sept. 21, 2026issueSO-260921-720MAIN 1 90.47-90.47221,990.42 July 8, 2026: 1 @ 90.47
Sept. 15, 2026issueSO-260915-310MAIN 7 90.47-633.32232,080.90 July 8, 2026: 7 @ 90.47
Sept. 11, 2026issueSO-260911-883MAIN 1 90.47-90.47302,714.21 July 8, 2026: 1 @ 90.47
Sept. 9, 2026issueSO-260909-156MAIN 1 90.47-90.47312,804.69 July 8, 2026: 1 @ 90.47
Sept. 7, 2026issueSO-260907-327MAIN 1 90.47-90.47322,895.16 July 8, 2026: 1 @ 90.47
Aug. 19, 2026issueSO-260819-968MAIN 4 90.47-361.90332,985.64 July 8, 2026: 4 @ 90.47
Aug. 17, 2026issueSO-260817-283MAIN 13 90.47-1,176.16373,347.53 July 8, 2026: 13 @ 90.47
Aug. 13, 2026issueSO-260813-106MAIN 3 90.47-271.42504,523.69 July 8, 2026: 3 @ 90.47
Aug. 10, 2026issueSO-260810-404MAIN 6 90.47-542.84534,795.11 July 8, 2026: 6 @ 90.47
Aug. 9, 2026issueSO-260809-597MAIN 2 90.47-180.95595,337.95 July 8, 2026: 2 @ 90.47
July 29, 2026issueSO-260729-297MAIN 18 90.47-1,628.53615,518.90 July 8, 2026: 18 @ 90.47
July 8, 2026receiptPO-001634MAIN 79 90.477,147.43797,147.43
July 2, 2026issueSO-260702-459MAIN 3 88.91-266.7300.00 April 30, 2026: 3 @ 88.91
July 1, 2026issueSO-260701-789MAIN 6 88.91-533.463266.73 April 30, 2026: 6 @ 88.91
June 26, 2026issueSO-260626-721MAIN 13 88.91-1,155.849800.19 April 30, 2026: 13 @ 88.91
June 20, 2026issueSO-260620-216MAIN 6 88.91-533.46221,956.03 April 30, 2026: 6 @ 88.91
June 19, 2026issueSO-260619-471MAIN 47 88.91-4,178.79282,489.49 April 30, 2026: 47 @ 88.91
May 31, 2026issueSO-260531-345MAIN 4 88.91-355.64756,668.29 April 30, 2026: 4 @ 88.91
May 26, 2026issueSO-260526-391MAIN 15 88.91-1,333.66797,023.93 April 30, 2026: 15 @ 88.91
May 23, 2026issueSO-260523-468MAIN 10 88.85-888.52948,357.59 March 31, 2026: 2 @ 88.62; April 30, 2026: 8 @ 88.91
May 9, 2026issueSO-260509-260MAIN 25 88.62-2,215.481049,246.11 March 31, 2026: 25 @ 88.62
April 30, 2026receiptPO-001453MAIN 102 88.919,068.8712911,461.59
April 28, 2026issueSO-260428-861MAIN 3 88.62-265.86272,392.72 March 31, 2026: 3 @ 88.62
April 21, 2026issueSO-260421-153MAIN 2 88.62-177.24302,658.58 March 31, 2026: 2 @ 88.62
April 19, 2026issueSO-260419-436MAIN 3 88.62-265.86322,835.81 March 31, 2026: 3 @ 88.62
April 18, 2026issueSO-260418-222MAIN 3 88.62-265.86353,101.67 March 31, 2026: 3 @ 88.62
April 17, 2026issueSO-260417-183MAIN 1 88.62-88.62383,367.53 March 31, 2026: 1 @ 88.62
April 15, 2026issueSO-260415-599MAIN 9 87.76-789.88393,456.15 March 2, 2026: 6 @ 87.34; March 31, 2026: 3 @ 88.62
April 8, 2026issueSO-260408-767MAIN 2 87.34-174.67484,246.02 March 2, 2026: 2 @ 87.34
March 31, 2026issueSO-260331-161MAIN 4 87.34-349.35504,420.70 March 2, 2026: 4 @ 87.34
March 31, 2026receiptPO-001371MAIN 42 88.623,722.01544,770.04
March 29, 2026issueSO-260329-782MAIN 1 87.34-87.34121,048.04 March 2, 2026: 1 @ 87.34
March 26, 2026issueSO-260326-595MAIN 1 87.34-87.34131,135.37 March 2, 2026: 1 @ 87.34
March 12, 2026issueSO-260312-613MAIN 5 87.34-436.68141,222.71 March 2, 2026: 5 @ 87.34
March 9, 2026issueSO-260309-592MAIN 4 87.34-349.35191,659.39 March 2, 2026: 4 @ 87.34
March 3, 2026issueSO-260303-178MAIN 2 87.34-174.67232,008.74 March 2, 2026: 2 @ 87.34
March 2, 2026issueSO-260302-568MAIN 7 87.27-610.88252,183.41 Dec. 24, 2025: 6 @ 87.26; March 2, 2026: 1 @ 87.34
March 2, 2026receiptPO-001275MAIN 26 87.342,270.75322,794.29
Feb. 20, 2026issueSO-260220-623MAIN 2 87.26-174.516523.54 Dec. 24, 2025: 2 @ 87.26
Feb. 14, 2026issueSO-260214-741MAIN 1 87.26-87.268698.06 Dec. 24, 2025: 1 @ 87.26
Feb. 8, 2026issueSO-260208-647MAIN 2 87.26-174.519785.31 Dec. 24, 2025: 2 @ 87.26
Feb. 8, 2026issueSO-260208-647EAST 1 87.26-87.2611959.83 Dec. 24, 2025: 1 @ 87.26
Feb. 4, 2026issueSO-260204-736MAIN 4 87.26-349.03121,047.09 Dec. 24, 2025: 4 @ 87.26
Jan. 17, 2026issueSO-260117-397EAST 2 87.26-174.51161,396.12 Dec. 24, 2025: 2 @ 87.26
Jan. 16, 2026issueSO-260116-959MAIN 8 86.63-693.03181,570.63 July 27, 2025: 5 @ 86.25; Dec. 24, 2025: 3 @ 87.26
Dec. 27, 2025issueSO-251227-677EAST 3 86.25-258.76262,263.66 July 27, 2025: 3 @ 86.25
Dec. 26, 2025issueSO-251226-647MAIN 2 86.25-172.50292,522.42 July 27, 2025: 2 @ 86.25
Dec. 24, 2025transferTRFMAIN → EAST 6 warehouse transfer, no cost effect
Dec. 24, 2025receiptPO-001082MAIN 21 87.261,832.40312,694.93
Dec. 15, 2025issueSO-251215-526MAIN 1 86.25-86.2510862.52 July 27, 2025: 1 @ 86.25
Dec. 8, 2025issueSO-251208-642MAIN 1 86.25-86.2511948.78 July 27, 2025: 1 @ 86.25
Dec. 1, 2025issueSO-251201-622MAIN 2 86.25-172.50121,035.03 July 27, 2025: 2 @ 86.25
Nov. 24, 2025issueSO-251124-809MAIN 1 86.25-86.25141,207.53 July 27, 2025: 1 @ 86.25
Nov. 22, 2025issueSO-251122-256MAIN 2 86.25-172.50151,293.79 July 27, 2025: 2 @ 86.25
Nov. 9, 2025issueSO-251109-226MAIN 3 86.25-258.76171,466.29 July 27, 2025: 3 @ 86.25
Oct. 25, 2025issueSO-251025-858MAIN 1 86.25-86.25201,725.05 July 27, 2025: 1 @ 86.25
Oct. 9, 2025issueSO-251009-691MAIN 1 86.25-86.25211,811.30 July 27, 2025: 1 @ 86.25
Oct. 5, 2025issueSO-251005-464MAIN 6 86.25-517.51221,897.55 July 27, 2025: 6 @ 86.25
Oct. 1, 2025issueSO-251001-257MAIN 1 86.25-86.25282,415.07 July 27, 2025: 1 @ 86.25
Sept. 27, 2025issueSO-250927-252MAIN 3 86.25-258.76292,501.32 July 27, 2025: 3 @ 86.25
Sept. 26, 2025issueSO-250926-818MAIN 3 86.25-258.76322,760.08 July 27, 2025: 3 @ 86.25
Sept. 24, 2025issueSO-250924-494MAIN 2 86.25-172.50353,018.83 July 27, 2025: 2 @ 86.25
Sept. 21, 2025issueSO-250921-161MAIN 1 86.25-86.25373,191.34 July 27, 2025: 1 @ 86.25
Sept. 12, 2025issueSO-250912-584MAIN 1 86.25-86.25383,277.59 July 27, 2025: 1 @ 86.25
Sept. 8, 2025issueSO-250908-735MAIN 7 86.25-603.77393,363.84 July 27, 2025: 7 @ 86.25
Aug. 24, 2025issueSO-250824-699MAIN 15 86.25-1,293.79463,967.61 July 27, 2025: 15 @ 86.25
Aug. 17, 2025issueSO-250817-686MAIN 1 86.25-86.25615,261.40 July 27, 2025: 1 @ 86.25
Aug. 15, 2025issueSO-250815-510MAIN 5 86.25-431.26625,347.65 July 27, 2025: 5 @ 86.25
Aug. 11, 2025issueSO-250811-383MAIN 5 86.25-431.26675,778.91 July 27, 2025: 5 @ 86.25
July 27, 2025issueSO-250727-199MAIN 7 86.25-603.77726,210.17 July 27, 2025: 7 @ 86.25
July 27, 2025receiptPO-000738MAIN 79 86.256,813.94796,813.94
July 13, 2025issueSO-250713-517MAIN 21 84.94-1,783.8300.00 May 12, 2025: 19 @ 84.94; May 19, 2025: 1 @ 85.04; July 10, 2025: 1 @ 84.94
July 10, 2025returnRMAMAIN 1 84.9484.94211,783.83
July 5, 2025issueSO-250705-357MAIN 3 84.94-254.82201,698.89 May 12, 2025: 3 @ 84.94
June 30, 2025issueSO-250630-796MAIN 5 84.94-424.70231,953.70 May 12, 2025: 5 @ 84.94
June 27, 2025issueSO-250627-174MAIN 22 84.94-1,868.66282,378.40 May 12, 2025: 22 @ 84.94
June 23, 2025issueSO-250623-347MAIN 2 84.94-169.88504,247.06 May 12, 2025: 2 @ 84.94
June 10, 2025issueSO-250610-698MAIN 19 84.94-1,613.84524,416.94 May 12, 2025: 19 @ 84.94
June 7, 2025issueSO-250607-468MAIN 3 84.94-254.82716,030.79 May 12, 2025: 3 @ 84.94
May 30, 2025issueSO-250530-738MAIN 4 84.94-339.76746,285.60 May 12, 2025: 4 @ 84.94
May 25, 2025issueSO-250525-620MAIN 20 84.94-1,698.78786,625.36 May 12, 2025: 20 @ 84.94
May 22, 2025issueSO-250522-795MAIN 10 84.99-849.90988,324.14 April 9, 2025: 5 @ 85.04; May 12, 2025: 5 @ 84.94
May 20, 2025issueSO-250520-599MAIN 8 85.04-680.331089,174.05 April 9, 2025: 8 @ 85.04
May 19, 2025returnRMAMAIN 1 85.0485.041169,854.38
May 17, 2025issueSO-250517-263MAIN 15 85.04-1,275.631159,769.34 April 9, 2025: 15 @ 85.04
May 12, 2025receiptPO-000530MAIN 102 84.948,663.8013011,044.97
May 11, 2025issueSO-250511-634MAIN 1 85.04-85.04282,381.17 April 9, 2025: 1 @ 85.04
April 19, 2025issueSO-250419-541MAIN 56 84.24-4,717.22292,466.21 Feb. 23, 2025: 15 @ 82.03; April 9, 2025: 41 @ 85.04
April 14, 2025issueSO-250414-352MAIN 7 82.03-574.24857,183.43 Feb. 23, 2025: 7 @ 82.03
April 14, 2025issueSO-250414-352EAST 5 82.03-410.17927,757.67 Feb. 23, 2025: 5 @ 82.03
April 9, 2025receiptPO-000430MAIN 70 85.045,952.93978,167.84
March 27, 2025issueSO-250327-568MAIN 5 82.03-410.17272,214.91 Feb. 23, 2025: 5 @ 82.03
March 22, 2025issueSO-250322-583EAST 2 82.03-164.07322,625.08 Feb. 23, 2025: 2 @ 82.03
March 20, 2025issueSO-250320-135MAIN 6 82.03-492.20342,789.15 Feb. 23, 2025: 6 @ 82.03
March 11, 2025issueSO-250311-998MAIN 1 82.03-82.03403,281.35 Feb. 23, 2025: 1 @ 82.03
March 10, 2025issueSO-250310-220EAST 2 83.94-167.89413,363.38 Nov. 17, 2024: 1 @ 85.85; Feb. 23, 2025: 1 @ 82.03
March 4, 2025issueSO-250304-932MAIN 6 85.85-515.11433,531.27 Oct. 1, 2024: 5 @ 85.85; Nov. 17, 2024: 1 @ 85.85
Feb. 28, 2025issueSO-250228-984MAIN 1 85.85-85.85494,046.38 Oct. 1, 2024: 1 @ 85.85
Feb. 25, 2025issueSO-250225-785MAIN 1 85.85-85.85504,132.23 Oct. 1, 2024: 1 @ 85.85
Feb. 23, 2025transferTRFMAIN → EAST 9 warehouse transfer, no cost effect
Feb. 23, 2025receiptPO-000295MAIN 42 82.033,445.42514,218.08
Feb. 22, 2025issueSO-250222-578MAIN 2 85.85-171.709772.66 Oct. 1, 2024: 2 @ 85.85
Feb. 21, 2025issueSO-250221-648MAIN 8 85.85-686.8111944.37 Oct. 1, 2024: 8 @ 85.85
Feb. 12, 2025issueSO-250212-977MAIN 1 85.85-85.85191,631.18 Oct. 1, 2024: 1 @ 85.85
Feb. 4, 2025issueSO-250204-265MAIN 2 85.85-171.70201,717.03 Oct. 1, 2024: 2 @ 85.85
Jan. 12, 2025issueSO-250112-759MAIN 6 85.85-515.11221,888.73 Oct. 1, 2024: 6 @ 85.85
Jan. 6, 2025issueSO-250106-455MAIN 2 85.85-171.70282,403.84 Oct. 1, 2024: 2 @ 85.85
Jan. 2, 2025issueSO-250102-218MAIN 2 85.85-171.70302,575.54 Oct. 1, 2024: 2 @ 85.85
Dec. 26, 2024issueSO-241226-403MAIN 1 85.85-85.85322,747.25 Oct. 1, 2024: 1 @ 85.85
Dec. 13, 2024issueSO-241213-959MAIN 2 85.85-171.70332,833.10 Oct. 1, 2024: 2 @ 85.85
Dec. 4, 2024issueSO-241204-905MAIN 1 85.85-85.85353,004.80 Oct. 1, 2024: 1 @ 85.85
Dec. 2, 2024issueSO-241202-616MAIN 2 85.85-171.70363,090.65 Oct. 1, 2024: 2 @ 85.85
Nov. 20, 2024issueSO-241120-960MAIN 2 85.85-171.70383,262.36 Oct. 1, 2024: 2 @ 85.85
Nov. 19, 2024issueSO-241119-879MAIN 2 85.85-171.70403,434.06 Oct. 1, 2024: 2 @ 85.85
Nov. 17, 2024returnRMAMAIN 2 85.85171.70423,605.76
Oct. 29, 2024issueSO-241029-713MAIN 4 85.85-343.41403,434.06 Oct. 1, 2024: 4 @ 85.85
Oct. 16, 2024issueSO-241016-831MAIN 8 85.85-686.81443,777.47 Oct. 1, 2024: 8 @ 85.85
Oct. 1, 2024receiptPO-000003MAIN 52 85.854,464.28524,464.28