stocksense

Items / FAN-0012

Table Fan 300mm Pro FAN-0012 · Ceiling Fans · CoolBreeze Appliances

On hand (EA)16MAIN 16
Value (FIFO)2,206.56avg 137.91
ClassAY / FCV 0.73
Turnover17.4xlast issue 0 days ago
Days of cover17lead time 22d

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

Demand and forecast

Monthly demand and forecast for FAN-00120.018.436.955.373.7Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 15.0Nov 24: 8.0Dec 24: 4.0Jan 25: 12.0Feb 25: 14.0Mar 25: 17.0Apr 25: 38.0May 25: 48.0Jun 25: 63.0Jul 25: 50.0Aug 25: 27.0Sep 25: 12.0Oct 25: 13.0Nov 25: 7.0Dec 25: 4.0Jan 26: 12.0Feb 26: 16.0Mar 26: 20.0Apr 26: 47.0May 26: 60.0Jun 26: 67.0Jul 26: 46.0Aug 26: 27.0Sep 26: 17.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.437528.00 / 30.43750.920
Daily demand sdmonthly sd / sqrt(30.4375)20.53 / 5.5173.721
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 * 3.721^2 + 0.920^2 * 7.4^2)38.1
Reorder pointd * LT + safety stock0.920 * 21.5 + 38.157.9
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days57.9
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 336/yr, S = 45.00, h = 20%, price = 141.2432.7
Inventory positionon hand + on order16 + 016

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

From qtyUnit costOrder qtyAnnual costFeasible
0141.243348,348yes (chosen if cheapest)

MOQ 12, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 25, 202615 / 26137.912,068.65
Oct. 11, 20261 / 1137.91137.91

Movement ledger 137 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026issueSO-261016-545MAIN 1 137.91-137.91162,206.56 Sept. 25, 2026: 1 @ 137.91
Oct. 11, 2026returnRMAMAIN 1 137.91137.91172,344.48
Oct. 10, 2026issueSO-261010-148MAIN 6 137.91-827.46162,206.56 Sept. 25, 2026: 6 @ 137.91
Oct. 9, 2026issueSO-261009-745MAIN 1 137.91-137.91223,034.03 Sept. 25, 2026: 1 @ 137.91
Oct. 6, 2026issueSO-261006-668MAIN 1 137.91-137.91233,171.94 Sept. 25, 2026: 1 @ 137.91
Oct. 5, 2026issueSO-261005-854MAIN 2 137.91-275.82243,309.85 Sept. 25, 2026: 2 @ 137.91
Oct. 3, 2026issueSO-261003-815MAIN 1 138.16-138.16263,585.67 June 20, 2026: 1 @ 138.16
Sept. 29, 2026issueSO-260929-669MAIN 3 138.16-414.47273,723.83 June 20, 2026: 3 @ 138.16
Sept. 26, 2026issueSO-260926-792MAIN 5 138.16-690.79304,138.30 June 20, 2026: 5 @ 138.16
Sept. 25, 2026receiptPO-001828MAIN 26 137.913,585.67354,829.09
Sept. 16, 2026issueSO-260916-663MAIN 1 138.16-138.1691,243.42 June 20, 2026: 1 @ 138.16
Sept. 15, 2026issueSO-260915-401MAIN 3 138.16-414.47101,381.58 June 20, 2026: 3 @ 138.16
Sept. 7, 2026issueSO-260907-720MAIN 1 138.16-138.16131,796.05 June 20, 2026: 1 @ 138.16
Sept. 4, 2026issueSO-260904-506MAIN 4 138.16-552.63141,934.21 June 20, 2026: 4 @ 138.16
Aug. 25, 2026issueSO-260825-627MAIN 1 138.16-138.16182,486.84 June 20, 2026: 1 @ 138.16
Aug. 11, 2026issueSO-260811-981MAIN 12 138.16-1,657.89192,625.00 June 20, 2026: 12 @ 138.16
Aug. 2, 2026issueSO-260802-718MAIN 8 138.16-1,105.26314,282.89 June 20, 2026: 8 @ 138.16
Aug. 1, 2026issueSO-260801-136MAIN 6 138.16-828.95395,388.15 June 20, 2026: 6 @ 138.16
July 20, 2026issueSO-260720-802MAIN 28 138.16-3,868.42456,217.10 June 20, 2026: 28 @ 138.16
July 15, 2026issueSO-260715-878MAIN 14 138.16-1,934.217310,085.51 June 20, 2026: 14 @ 138.16
July 5, 2026issueSO-260705-975MAIN 4 138.16-552.638712,019.72 June 20, 2026: 4 @ 138.16
June 28, 2026issueSO-260628-753MAIN 30 138.85-4,165.359112,572.35 April 25, 2026: 23 @ 139.05; June 20, 2026: 7 @ 138.16
June 27, 2026issueSO-260627-124MAIN 6 139.05-834.3312116,737.70 April 25, 2026: 6 @ 139.05
June 20, 2026receiptPO-001588MAIN 98 138.1613,539.4512717,572.03
June 16, 2026issueSO-260616-585MAIN 2 139.05-278.11294,032.57 April 25, 2026: 2 @ 139.05
June 14, 2026issueSO-260614-757MAIN 17 139.05-2,363.92314,310.68 April 25, 2026: 17 @ 139.05
June 6, 2026issueSO-260606-552MAIN 1 139.05-139.05486,674.60 April 25, 2026: 1 @ 139.05
June 2, 2026issueSO-260602-681MAIN 9 139.05-1,251.49496,813.66 April 25, 2026: 9 @ 139.05
June 2, 2026issueSO-260602-681EAST 2 139.05-278.11588,065.14 April 25, 2026: 2 @ 139.05
May 20, 2026issueSO-260520-561MAIN 31 139.05-4,310.68608,343.25 April 25, 2026: 31 @ 139.05
May 18, 2026issueSO-260518-896MAIN 29 137.09-3,975.679112,653.93 April 3, 2026: 26 @ 136.87; April 25, 2026: 3 @ 139.05
April 29, 2026issueSO-260429-400MAIN 8 136.87-1,094.9212016,629.60 April 3, 2026: 8 @ 136.87
April 25, 2026receiptPO-001436MAIN 94 139.0513,071.0912817,724.52
April 18, 2026issueSO-260418-705MAIN 8 136.87-1,094.92344,653.43 April 3, 2026: 8 @ 136.87
April 17, 2026issueSO-260417-988MAIN 6 136.87-821.19425,748.35 April 3, 2026: 6 @ 136.87
April 8, 2026issueSO-260408-624MAIN 4 136.87-547.46486,569.54 April 3, 2026: 4 @ 136.87
April 6, 2026issueSO-260406-607MAIN 21 135.63-2,848.29527,117.01 March 10, 2026: 9 @ 133.99; April 3, 2026: 12 @ 136.87
April 3, 2026receiptPO-001381MAIN 64 136.878,759.39739,965.30
March 31, 2026issueSO-260331-262MAIN 4 133.99-535.9691,205.91 March 10, 2026: 4 @ 133.99
March 24, 2026issueSO-260324-124MAIN 7 133.99-937.93131,741.87 March 10, 2026: 7 @ 133.99
March 23, 2026issueSO-260323-443MAIN 2 133.99-267.98202,679.79 March 10, 2026: 2 @ 133.99
March 18, 2026issueSO-260318-708MAIN 4 135.77-543.09222,947.77 Jan. 14, 2026: 1 @ 137.43; Jan. 18, 2026: 1 @ 137.68; March 10, 2026: 2 @ 133.99
March 10, 2026receiptPO-001304MAIN 24 133.993,215.75263,490.86
March 8, 2026issueSO-260308-225EAST 1 137.43-137.432275.11 Jan. 14, 2026: 1 @ 137.43
March 2, 2026issueSO-260302-191EAST 2 137.43-274.863412.54 Jan. 14, 2026: 2 @ 137.43
Feb. 27, 2026issueSO-260227-807EAST 1 137.43-137.435687.40 Jan. 14, 2026: 1 @ 137.43
Feb. 25, 2026issueSO-260225-671EAST 2 137.43-274.866824.83 Jan. 14, 2026: 2 @ 137.43
Feb. 25, 2026issueSO-260225-671MAIN 1 137.43-137.4381,099.69 Jan. 14, 2026: 1 @ 137.43
Feb. 7, 2026issueSO-260207-921MAIN 4 137.43-549.7291,237.12 Jan. 14, 2026: 4 @ 137.43
Feb. 1, 2026issueSO-260201-468MAIN 8 137.43-1,099.44131,786.84 Jan. 14, 2026: 8 @ 137.43
Jan. 31, 2026issueSO-260131-173MAIN 2 137.68-275.36212,886.27 Aug. 1, 2025: 1 @ 137.68; Oct. 22, 2025: 1 @ 137.68
Jan. 20, 2026issueSO-260120-198MAIN 1 137.68-137.68233,161.63 Aug. 1, 2025: 1 @ 137.68
Jan. 18, 2026returnRMAMAIN 1 137.68137.68243,299.31
Jan. 15, 2026issueSO-260115-110MAIN 4 137.68-550.71233,161.63 Aug. 1, 2025: 4 @ 137.68
Jan. 14, 2026issueSO-260114-804MAIN 1 137.68-137.68273,712.35 Aug. 1, 2025: 1 @ 137.68
Jan. 14, 2026receiptPO-001144MAIN 20 137.432,748.60283,850.03
Jan. 6, 2026issueSO-260106-521MAIN 5 137.68-688.3981,101.43 Aug. 1, 2025: 5 @ 137.68
Dec. 31, 2025issueSO-251231-802MAIN 2 137.68-275.36131,789.82 Aug. 1, 2025: 2 @ 137.68
Dec. 30, 2025issueSO-251230-976MAIN 1 137.68-137.68152,065.18 Aug. 1, 2025: 1 @ 137.68
Dec. 29, 2025issueSO-251229-517MAIN 1 137.68-137.68162,202.86 Aug. 1, 2025: 1 @ 137.68
Nov. 27, 2025issueSO-251127-172MAIN 1 137.68-137.68172,340.54 Aug. 1, 2025: 1 @ 137.68
Nov. 23, 2025issueSO-251123-809EAST 3 137.68-413.04182,478.22 Aug. 1, 2025: 3 @ 137.68
Nov. 14, 2025issueSO-251114-233MAIN 1 137.68-137.68212,891.25 Aug. 1, 2025: 1 @ 137.68
Nov. 8, 2025issueSO-251108-851EAST 1 137.68-137.68223,028.93 Aug. 1, 2025: 1 @ 137.68
Nov. 4, 2025issueSO-251104-876MAIN 1 137.68-137.68233,166.61 Aug. 1, 2025: 1 @ 137.68
Oct. 22, 2025returnRMAMAIN 1 137.68137.68243,304.29
Oct. 16, 2025issueSO-251016-316MAIN 3 137.68-413.04233,166.61 Aug. 1, 2025: 3 @ 137.68
Oct. 13, 2025issueSO-251013-179EAST 1 137.68-137.68263,579.65 Aug. 1, 2025: 1 @ 137.68
Oct. 12, 2025issueSO-251012-913EAST 1 137.68-137.68273,717.32 Aug. 1, 2025: 1 @ 137.68
Oct. 6, 2025issueSO-251006-481EAST 6 137.68-826.07283,855.00 Aug. 1, 2025: 6 @ 137.68
Oct. 2, 2025issueSO-251002-160MAIN 2 137.68-275.36344,681.08 Aug. 1, 2025: 2 @ 137.68
Oct. 1, 2025issueSO-251001-210MAIN 1 137.68-137.68364,956.43 Aug. 1, 2025: 1 @ 137.68
Sept. 20, 2025issueSO-250920-264MAIN 4 137.68-550.71375,094.11 Aug. 1, 2025: 4 @ 137.68
Sept. 8, 2025issueSO-250908-248MAIN 8 137.68-1,101.43415,644.83 Aug. 1, 2025: 8 @ 137.68
Aug. 24, 2025issueSO-250824-872MAIN 26 136.72-3,554.66496,746.26 June 1, 2025: 3 @ 129.35; Aug. 1, 2025: 23 @ 137.68
Aug. 2, 2025issueSO-250802-247MAIN 1 129.35-129.357510,300.92 June 1, 2025: 1 @ 129.35
Aug. 1, 2025transferTRFMAIN → EAST 20 warehouse transfer, no cost effect
Aug. 1, 2025receiptPO-000748MAIN 72 137.689,912.877610,430.27
July 24, 2025issueSO-250724-482MAIN 3 129.35-388.054517.41 June 1, 2025: 3 @ 129.35
July 21, 2025issueSO-250721-753MAIN 3 129.35-388.057905.46 June 1, 2025: 3 @ 129.35
July 6, 2025issueSO-250706-376MAIN 28 129.35-3,621.84101,293.52 June 1, 2025: 28 @ 129.35
July 4, 2025issueSO-250704-900MAIN 9 129.35-1,164.16384,915.36 June 1, 2025: 9 @ 129.35
July 1, 2025issueSO-250701-315MAIN 7 129.35-905.46476,079.53 June 1, 2025: 7 @ 129.35
June 29, 2025issueSO-250629-630MAIN 31 129.35-4,009.90546,984.99 June 1, 2025: 31 @ 129.35
June 19, 2025issueSO-250619-373MAIN 4 129.35-517.418510,994.89 June 1, 2025: 4 @ 129.35
June 17, 2025issueSO-250617-206MAIN 8 129.35-1,034.818911,512.29 June 1, 2025: 8 @ 129.35
June 11, 2025issueSO-250611-815MAIN 1 129.35-129.359712,547.11 June 1, 2025: 1 @ 129.35
June 11, 2025issueSO-250611-815EAST 14 129.02-1,806.299812,676.46 May 7, 2025: 14 @ 129.02
June 8, 2025issueSO-250608-334EAST 1 129.02-129.0211214,482.74 May 7, 2025: 1 @ 129.02
June 4, 2025issueSO-250604-981MAIN 2 129.02-258.0411314,611.76 May 7, 2025: 2 @ 129.02
June 3, 2025issueSO-250603-458MAIN 2 129.02-258.0411514,869.81 May 7, 2025: 2 @ 129.02
June 1, 2025receiptPO-000595MAIN 98 129.3512,676.4611715,127.85
May 25, 2025issueSO-250525-951MAIN 29 129.02-3,741.59192,451.39 May 7, 2025: 29 @ 129.02
May 16, 2025issueSO-250516-466MAIN 11 129.02-1,419.23486,192.98 May 7, 2025: 11 @ 129.02
May 8, 2025issueSO-250508-528MAIN 5 129.02-645.10597,612.21 May 7, 2025: 5 @ 129.02
May 7, 2025transferTRFMAIN → EAST 15 warehouse transfer, no cost effect
May 7, 2025receiptPO-000518MAIN 64 129.028,257.31648,257.31
May 2, 2025issueSO-250502-526MAIN 3 130.32-390.9500.00 March 25, 2025: 3 @ 130.32
April 30, 2025issueSO-250430-336MAIN 1 130.32-130.323390.95 March 25, 2025: 1 @ 130.32
April 11, 2025issueSO-250411-616MAIN 9 130.32-1,172.854521.27 March 25, 2025: 9 @ 130.32
April 8, 2025issueSO-250408-157MAIN 4 130.32-521.27131,694.11 March 25, 2025: 4 @ 130.32
April 3, 2025issueSO-250403-309MAIN 23 130.20-2,994.62172,215.38 March 11, 2025: 1 @ 127.66; March 25, 2025: 22 @ 130.32
April 3, 2025issueSO-250403-309EAST 1 127.66-127.66405,210.00 Feb. 12, 2025: 1 @ 127.66
March 30, 2025issueSO-250330-389EAST 1 127.66-127.66415,337.66 Feb. 12, 2025: 1 @ 127.66
March 25, 2025receiptPO-000377MAIN 39 130.325,082.34425,465.32
March 12, 2025issueSO-250312-343EAST 1 127.66-127.663382.98 Feb. 12, 2025: 1 @ 127.66
March 11, 2025returnRMAMAIN 1 127.66127.664510.64
March 9, 2025issueSO-250309-598EAST 1 127.66-127.663382.98 Feb. 12, 2025: 1 @ 127.66
March 7, 2025issueSO-250307-857EAST 1 127.66-127.664510.64 Feb. 12, 2025: 1 @ 127.66
March 4, 2025issueSO-250304-323EAST 6 127.66-765.965638.30 Feb. 12, 2025: 6 @ 127.66
March 2, 2025issueSO-250302-798EAST 1 127.66-127.66111,404.26 Feb. 12, 2025: 1 @ 127.66
March 2, 2025issueSO-250302-798MAIN 3 127.66-382.98121,531.92 Feb. 12, 2025: 3 @ 127.66
March 1, 2025issueSO-250301-544MAIN 4 127.66-510.64151,914.89 Feb. 12, 2025: 4 @ 127.66
Feb. 28, 2025issueSO-250228-219MAIN 5 127.66-638.30192,425.53 Feb. 12, 2025: 5 @ 127.66
Feb. 14, 2025issueSO-250214-971MAIN 6 134.18-805.07243,063.83 Oct. 1, 2024: 6 @ 134.18
Feb. 12, 2025transferTRFMAIN → EAST 6 warehouse transfer, no cost effect
Feb. 12, 2025receiptPO-000262MAIN 24 127.663,063.83303,868.90
Feb. 8, 2025issueSO-250208-181MAIN 1 134.18-134.186805.07 Oct. 1, 2024: 1 @ 134.18
Feb. 5, 2025issueSO-250205-348MAIN 1 134.18-134.187939.25 Oct. 1, 2024: 1 @ 134.18
Feb. 2, 2025issueSO-250202-527MAIN 1 134.18-134.1881,073.42 Oct. 1, 2024: 1 @ 134.18
Jan. 25, 2025issueSO-250125-592EAST 2 134.18-268.3691,207.60 Oct. 1, 2024: 2 @ 134.18
Jan. 16, 2025issueSO-250116-373EAST 1 134.18-134.18111,475.96 Oct. 1, 2024: 1 @ 134.18
Jan. 12, 2025issueSO-250112-588MAIN 2 134.18-268.36121,610.14 Oct. 1, 2024: 2 @ 134.18
Jan. 11, 2025issueSO-250111-806EAST 1 134.18-134.18141,878.49 Oct. 1, 2024: 1 @ 134.18
Jan. 8, 2025issueSO-250108-915MAIN 6 134.18-805.07152,012.67 Oct. 1, 2024: 6 @ 134.18
Dec. 31, 2024issueSO-241231-426EAST 1 134.18-134.18212,817.74 Oct. 1, 2024: 1 @ 134.18
Dec. 27, 2024issueSO-241227-650MAIN 1 134.18-134.18222,951.92 Oct. 1, 2024: 1 @ 134.18
Dec. 20, 2024issueSO-241220-233MAIN 2 134.18-268.36233,086.09 Oct. 1, 2024: 2 @ 134.18
Nov. 25, 2024issueSO-241125-232MAIN 1 134.18-134.18253,354.45 Oct. 1, 2024: 1 @ 134.18
Nov. 24, 2024issueSO-241124-694MAIN 1 134.18-134.18263,488.63 Oct. 1, 2024: 1 @ 134.18
Nov. 14, 2024issueSO-241114-741MAIN 5 134.18-670.89273,622.81 Oct. 1, 2024: 5 @ 134.18
Nov. 10, 2024issueSO-241110-908EAST 1 134.18-134.18324,293.70 Oct. 1, 2024: 1 @ 134.18
Oct. 31, 2024issueSO-241031-577EAST 1 134.18-134.18334,427.87 Oct. 1, 2024: 1 @ 134.18
Oct. 5, 2024issueSO-241005-223MAIN 5 134.18-670.89344,562.05 Oct. 1, 2024: 5 @ 134.18
Oct. 1, 2024issueSO-241001-754MAIN 9 134.18-1,207.60395,232.94 Oct. 1, 2024: 9 @ 134.18
Oct. 1, 2024transferTRFMAIN → EAST 13 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000003MAIN 48 134.186,440.54486,440.54