stocksense

Items / FAN-0008

Pedestal Fan Pro FAN-0008 · Ceiling Fans · CoolBreeze Appliances

On hand (EA)28MAIN 28
Value (FIFO)6,290.07avg 224.65
ClassAY / FCV 0.79
Turnover6.6xlast issue 0 days ago
Days of cover45lead time 22d

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

Demand and forecast

Monthly demand and forecast for FAN-00080.015.130.345.460.5Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 8.0Nov 24: 4.0Dec 24: 4.0Jan 25: 10.0Feb 25: 10.0Mar 25: 16.0Apr 25: 29.0May 25: 40.0Jun 25: 37.0Jul 25: 29.0Aug 25: 18.0Sep 25: 14.0Oct 25: 7.0Nov 25: 2.0Dec 25: 3.0Jan 26: 7.0Feb 26: 15.0Mar 26: 19.0Apr 26: 23.0May 26: 55.0Jun 26: 41.0Jul 26: 19.0Aug 26: 21.0Sep 26: 14.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.437518.83 / 30.43750.619
Daily demand sdmonthly sd / sqrt(30.4375)14.93 / 5.5172.706
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 * 2.706^2 + 0.619^2 * 7.4^2)27.4
Reorder pointd * LT + safety stock0.619 * 21.5 + 27.440.7
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days40.7
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 226/yr, S = 45.00, h = 20%, price = 227.1221.2
Inventory positionon hand + on order28 + 028

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

From qtyUnit costOrder qtyAnnual costFeasible
0227.122152,255yes (chosen if cheapest)

MOQ 10, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
July 23, 202628 / 59224.656,290.07

Movement ledger 124 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026issueSO-261016-190EAST 7 224.65-1,572.52286,290.07 July 23, 2026: 7 @ 224.65
Oct. 12, 2026issueSO-261012-763MAIN 1 224.65-224.65357,862.58 July 23, 2026: 1 @ 224.65
Oct. 10, 2026issueSO-261010-591MAIN 1 224.65-224.65368,087.23 July 23, 2026: 1 @ 224.65
Oct. 8, 2026issueSO-261008-704MAIN 1 224.65-224.65378,311.87 July 23, 2026: 1 @ 224.65
Oct. 3, 2026issueSO-261003-188MAIN 1 224.65-224.65388,536.52 July 23, 2026: 1 @ 224.65
Oct. 2, 2026issueSO-261002-470MAIN 1 224.65-224.65398,761.16 July 23, 2026: 1 @ 224.65
Sept. 29, 2026issueSO-260929-614EAST 3 224.65-673.94408,985.81 July 23, 2026: 3 @ 224.65
Sept. 12, 2026issueSO-260912-897MAIN 2 224.65-449.29439,659.74 July 23, 2026: 2 @ 224.65
Sept. 10, 2026issueSO-260910-353MAIN 4 224.65-898.584510,109.03 July 23, 2026: 4 @ 224.65
Sept. 9, 2026issueSO-260909-648MAIN 1 224.65-224.654911,007.61 July 23, 2026: 1 @ 224.65
Sept. 5, 2026issueSO-260905-327EAST 4 224.65-898.585011,232.26 July 23, 2026: 4 @ 224.65
Aug. 15, 2026issueSO-260815-235EAST 1 224.65-224.655412,130.84 July 23, 2026: 1 @ 224.65
Aug. 10, 2026issueSO-260810-704MAIN 11 220.49-2,425.395512,355.49 May 26, 2026: 7 @ 218.11; July 23, 2026: 4 @ 224.65
Aug. 7, 2026issueSO-260807-710MAIN 4 218.11-872.466614,780.87 May 26, 2026: 4 @ 218.11
Aug. 2, 2026issueSO-260802-389MAIN 5 218.11-1,090.577015,653.33 May 26, 2026: 5 @ 218.11
July 23, 2026transferTRFMAIN → EAST 15 warehouse transfer, no cost effect
July 23, 2026receiptPO-001665MAIN 59 224.6513,254.077516,743.91
July 22, 2026issueSO-260722-645MAIN 6 218.11-1,308.69163,489.84 May 26, 2026: 6 @ 218.11
July 15, 2026issueSO-260715-237MAIN 9 218.11-1,963.03224,798.53 May 26, 2026: 9 @ 218.11
July 5, 2026issueSO-260705-292MAIN 4 218.11-872.46316,761.56 May 26, 2026: 4 @ 218.11
June 27, 2026issueSO-260627-959MAIN 11 218.11-2,399.26357,634.02 May 26, 2026: 11 @ 218.11
June 26, 2026issueSO-260626-677MAIN 1 218.11-218.114610,033.29 May 26, 2026: 1 @ 218.11
June 20, 2026issueSO-260620-936MAIN 4 218.11-872.464710,251.40 May 26, 2026: 4 @ 218.11
June 14, 2026issueSO-260614-746MAIN 19 218.11-4,144.185111,123.86 May 26, 2026: 19 @ 218.11
June 11, 2026issueSO-260611-381MAIN 2 218.11-436.237015,268.04 May 26, 2026: 2 @ 218.11
June 4, 2026issueSO-260604-719MAIN 4 218.11-872.467215,704.27 May 26, 2026: 4 @ 218.11
May 31, 2026issueSO-260531-257MAIN 14 222.51-3,115.197616,576.73 April 29, 2026: 11 @ 223.71; May 26, 2026: 3 @ 218.11
May 30, 2026issueSO-260530-119MAIN 9 223.71-2,013.429019,691.92 April 29, 2026: 9 @ 223.71
May 29, 2026issueSO-260529-438MAIN 17 223.71-3,803.129921,705.34 April 29, 2026: 17 @ 223.71
May 26, 2026receiptPO-001524MAIN 79 218.1117,231.0811625,508.46
May 18, 2026issueSO-260518-539MAIN 5 223.71-1,118.57378,277.38 April 29, 2026: 5 @ 223.71
May 17, 2026issueSO-260517-878MAIN 4 223.71-894.85429,395.95 April 29, 2026: 4 @ 223.71
May 15, 2026issueSO-260515-290MAIN 6 223.71-1,342.284610,290.80 April 29, 2026: 6 @ 223.71
April 29, 2026receiptPO-001450MAIN 52 223.7111,633.085211,633.08
April 24, 2026issueSO-260424-982MAIN 3 218.44-655.3100.00 Feb. 26, 2026: 3 @ 218.44
April 23, 2026issueSO-260423-229MAIN 1 218.44-218.443655.31 Feb. 26, 2026: 1 @ 218.44
April 19, 2026issueSO-260419-644MAIN 4 218.44-873.754873.75 Feb. 26, 2026: 4 @ 218.44
April 16, 2026issueSO-260416-985MAIN 2 218.44-436.8781,747.50 Feb. 26, 2026: 2 @ 218.44
April 12, 2026issueSO-260412-780MAIN 4 218.44-873.75102,184.37 Feb. 26, 2026: 4 @ 218.44
April 8, 2026issueSO-260408-987MAIN 3 218.44-655.31143,058.12 Feb. 26, 2026: 3 @ 218.44
April 1, 2026issueSO-260401-771MAIN 6 218.44-1,310.62173,713.43 Feb. 26, 2026: 6 @ 218.44
March 29, 2026issueSO-260329-390MAIN 2 218.44-436.87235,024.06 Feb. 26, 2026: 2 @ 218.44
March 25, 2026issueSO-260325-813MAIN 3 218.44-655.31255,460.93 Feb. 26, 2026: 3 @ 218.44
March 23, 2026issueSO-260323-644MAIN 2 218.44-436.87286,116.24 Feb. 26, 2026: 2 @ 218.44
March 22, 2026issueSO-260322-522MAIN 3 217.78-653.33306,553.12 Aug. 14, 2025: 2 @ 217.44; Feb. 26, 2026: 1 @ 218.44
March 17, 2026issueSO-260317-710MAIN 2 217.44-434.89337,206.44 Aug. 14, 2025: 2 @ 217.44
March 11, 2026issueSO-260311-851MAIN 2 217.44-434.89357,641.33 July 13, 2025: 2 @ 217.44
March 10, 2026issueSO-260310-553MAIN 5 217.44-1,087.22378,076.22 July 13, 2025: 5 @ 217.44
Feb. 26, 2026issueSO-260226-814MAIN 3 217.44-652.33429,163.45 July 13, 2025: 3 @ 217.44
Feb. 26, 2026receiptPO-001260MAIN 31 218.446,771.55459,815.78
Feb. 10, 2026issueSO-260210-644MAIN 1 217.44-217.44143,044.23 July 13, 2025: 1 @ 217.44
Feb. 4, 2026issueSO-260204-624MAIN 11 217.44-2,391.89153,261.67 July 13, 2025: 11 @ 217.44
Jan. 27, 2026issueSO-260127-894MAIN 1 217.44-217.44265,653.56 July 13, 2025: 1 @ 217.44
Jan. 22, 2026issueSO-260122-901MAIN 1 217.44-217.44275,871.01 July 13, 2025: 1 @ 217.44
Jan. 19, 2026issueSO-260119-210MAIN 1 217.44-217.44286,088.45 July 13, 2025: 1 @ 217.44
Jan. 10, 2026issueSO-260110-742MAIN 3 217.44-652.33296,305.90 July 13, 2025: 3 @ 217.44
Jan. 1, 2026issueSO-260101-105MAIN 1 217.44-217.44326,958.23 July 13, 2025: 1 @ 217.44
Dec. 28, 2025issueSO-251228-712MAIN 2 217.44-434.89337,175.68 July 13, 2025: 2 @ 217.44
Dec. 25, 2025issueSO-251225-829MAIN 1 217.44-217.44357,610.57 July 13, 2025: 1 @ 217.44
Nov. 11, 2025issueSO-251111-725MAIN 1 217.44-217.44367,828.01 July 13, 2025: 1 @ 217.44
Nov. 1, 2025issueSO-251101-856MAIN 1 217.44-217.44378,045.46 July 13, 2025: 1 @ 217.44
Oct. 29, 2025issueSO-251029-865MAIN 6 217.44-1,304.67388,262.90 July 13, 2025: 6 @ 217.44
Oct. 11, 2025issueSO-251011-144MAIN 1 217.44-217.44449,567.57 July 13, 2025: 1 @ 217.44
Sept. 24, 2025issueSO-250924-498MAIN 4 217.44-869.78459,785.02 July 13, 2025: 4 @ 217.44
Sept. 23, 2025issueSO-250923-169MAIN 1 217.44-217.444910,654.80 July 13, 2025: 1 @ 217.44
Sept. 20, 2025issueSO-250920-635MAIN 6 217.44-1,304.675010,872.24 July 13, 2025: 6 @ 217.44
Sept. 16, 2025issueSO-250916-725MAIN 3 217.44-652.335612,176.91 July 13, 2025: 3 @ 217.44
Aug. 26, 2025issueSO-250826-835MAIN 10 217.44-2,174.455912,829.24 July 13, 2025: 10 @ 217.44
Aug. 14, 2025returnRMAMAIN 4 217.44869.786915,003.69
Aug. 12, 2025issueSO-250812-369MAIN 3 217.44-652.336514,133.91 July 13, 2025: 3 @ 217.44
Aug. 7, 2025issueSO-250807-527MAIN 5 217.44-1,087.226814,786.25 July 13, 2025: 5 @ 217.44
Aug. 6, 2025issueSO-250806-653MAIN 4 217.44-869.787315,873.47 July 13, 2025: 4 @ 217.44
July 29, 2025issueSO-250729-896MAIN 8 210.18-1,681.477716,743.25 May 8, 2025: 6 @ 207.76; July 13, 2025: 2 @ 217.44
July 20, 2025issueSO-250720-412MAIN 21 207.76-4,363.048518,424.72 May 8, 2025: 21 @ 207.76
July 13, 2025receiptPO-000705MAIN 79 217.4417,178.1410622,787.77
June 29, 2025issueSO-250629-381MAIN 1 207.76-207.76275,609.63 May 8, 2025: 1 @ 207.76
June 19, 2025issueSO-250619-814MAIN 2 207.76-415.53285,817.39 May 8, 2025: 2 @ 207.76
June 8, 2025issueSO-250608-313MAIN 16 207.76-3,324.22306,232.92 May 8, 2025: 16 @ 207.76
June 4, 2025issueSO-250604-582MAIN 2 207.76-415.53469,557.14 May 8, 2025: 2 @ 207.76
June 2, 2025issueSO-250602-439MAIN 9 207.76-1,869.88489,972.67 May 8, 2025: 9 @ 207.76
June 2, 2025issueSO-250602-439EAST 7 207.76-1,454.355711,842.55 May 8, 2025: 7 @ 207.76
May 14, 2025issueSO-250514-293EAST 4 207.76-831.066413,296.90 May 8, 2025: 4 @ 207.76
May 13, 2025issueSO-250513-898MAIN 11 208.76-2,296.356814,127.95 April 26, 2025: 3 @ 211.41; May 8, 2025: 8 @ 207.76
May 10, 2025issueSO-250510-204EAST 15 211.41-3,171.177916,424.30 March 27, 2025: 15 @ 211.41
May 8, 2025transferTRFMAIN → EAST 26 warehouse transfer, no cost effect
May 8, 2025receiptPO-000524MAIN 76 207.7615,790.069419,595.47
May 7, 2025issueSO-250507-290MAIN 10 211.41-2,114.11183,805.40 March 27, 2025: 10 @ 211.41
April 26, 2025returnRMAMAIN 3 211.41634.23285,919.51
April 17, 2025issueSO-250417-218MAIN 14 211.41-2,959.76255,285.28 March 27, 2025: 14 @ 211.41
April 13, 2025issueSO-250413-679MAIN 6 211.41-1,268.47398,245.04 March 27, 2025: 6 @ 211.41
April 7, 2025issueSO-250407-627MAIN 4 211.41-845.64459,513.50 March 27, 2025: 4 @ 211.41
April 5, 2025issueSO-250405-543MAIN 1 211.41-211.414910,359.15 March 27, 2025: 1 @ 211.41
April 5, 2025issueSO-250405-543EAST 7 214.60-1,502.205010,570.56 Feb. 17, 2025: 4 @ 215.90; March 1, 2025: 1 @ 215.76; March 27, 2025: 2 @ 211.41
March 29, 2025issueSO-250329-443EAST 4 215.90-863.615712,072.76 Feb. 17, 2025: 4 @ 215.90
March 27, 2025transferTRFMAIN → EAST 11 warehouse transfer, no cost effect
March 27, 2025receiptPO-000387MAIN 52 211.4110,993.386112,936.38
March 15, 2025issueSO-250315-695MAIN 13 215.88-2,806.4791,942.99 Oct. 1, 2024: 1 @ 215.76; Feb. 13, 2025: 1 @ 215.76; Feb. 17, 2025: 11 @ 215.90
March 1, 2025returnRMAMAIN 1 215.76215.76224,749.46
Feb. 28, 2025issueSO-250228-916MAIN 1 215.76-215.76214,533.70 Oct. 1, 2024: 1 @ 215.76
Feb. 21, 2025issueSO-250221-352MAIN 2 215.76-431.53224,749.46 Oct. 1, 2024: 2 @ 215.76
Feb. 19, 2025issueSO-250219-697MAIN 1 215.76-215.76245,180.99 Oct. 1, 2024: 1 @ 215.76
Feb. 17, 2025receiptPO-000272MAIN 19 215.904,102.17255,396.75
Feb. 13, 2025returnRMAMAIN 1 215.76215.7661,294.58
Feb. 10, 2025issueSO-250210-841EAST 2 215.76-431.5351,078.82 Oct. 1, 2024: 2 @ 215.76
Feb. 5, 2025issueSO-250205-511EAST 2 215.76-431.5371,510.35 Oct. 1, 2024: 2 @ 215.76
Feb. 4, 2025issueSO-250204-989EAST 3 215.76-647.2991,941.88 Oct. 1, 2024: 3 @ 215.76
Jan. 30, 2025issueSO-250130-893MAIN 1 215.76-215.76122,589.17 Oct. 1, 2024: 1 @ 215.76
Jan. 28, 2025issueSO-250128-854MAIN 2 215.76-431.53132,804.93 Oct. 1, 2024: 2 @ 215.76
Jan. 21, 2025issueSO-250121-190MAIN 3 215.76-647.29153,236.46 Oct. 1, 2024: 3 @ 215.76
Jan. 17, 2025issueSO-250117-924EAST 1 215.76-215.76183,883.75 Oct. 1, 2024: 1 @ 215.76
Jan. 5, 2025issueSO-250105-877EAST 2 215.76-431.53194,099.52 Oct. 1, 2024: 2 @ 215.76
Jan. 4, 2025issueSO-250104-231MAIN 1 215.76-215.76214,531.04 Oct. 1, 2024: 1 @ 215.76
Dec. 27, 2024issueSO-241227-365MAIN 1 215.76-215.76224,746.81 Oct. 1, 2024: 1 @ 215.76
Dec. 13, 2024issueSO-241213-695EAST 1 215.76-215.76234,962.57 Oct. 1, 2024: 1 @ 215.76
Dec. 7, 2024issueSO-241207-255MAIN 2 215.76-431.53245,178.34 Oct. 1, 2024: 2 @ 215.76
Nov. 23, 2024issueSO-241123-342MAIN 1 215.76-215.76265,609.86 Oct. 1, 2024: 1 @ 215.76
Nov. 7, 2024issueSO-241107-693MAIN 2 215.76-431.53275,825.63 Oct. 1, 2024: 2 @ 215.76
Nov. 3, 2024issueSO-241103-768MAIN 1 215.76-215.76296,257.16 Oct. 1, 2024: 1 @ 215.76
Oct. 25, 2024issueSO-241025-806MAIN 1 215.76-215.76306,472.92 Oct. 1, 2024: 1 @ 215.76
Oct. 23, 2024issueSO-241023-599MAIN 2 215.76-431.53316,688.68 Oct. 1, 2024: 2 @ 215.76
Oct. 10, 2024issueSO-241010-886MAIN 3 215.76-647.29337,120.21 Oct. 1, 2024: 3 @ 215.76
Oct. 9, 2024issueSO-241009-539MAIN 2 215.76-431.53367,767.50 Oct. 1, 2024: 2 @ 215.76
Oct. 1, 2024transferTRFMAIN → EAST 11 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000003MAIN 38 215.768,199.03388,199.03