stocksense

Items / FAN-0014

Wall Fan 400mm Classic FAN-0014 · Ceiling Fans · CoolBreeze Appliances

On hand (EA)11MAIN 8, EAST 3
Value (FIFO)3,418.45avg 310.77
ClassAY / FCV 0.77
Turnover11.6xlast issue 2 days ago
Days of cover14lead time 22d

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

Demand and forecast

Monthly demand and forecast for FAN-00140.019.238.557.877.0Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 9.0Nov 24: 6.0Dec 24: 5.0Jan 25: 10.0Feb 25: 22.0Mar 25: 19.0Apr 25: 28.0May 25: 68.0Jun 25: 40.0Jul 25: 36.0Aug 25: 17.0Sep 25: 16.0Oct 25: 10.0Nov 25: 6.0Dec 25: 6.0Jan 26: 17.0Feb 26: 9.0Mar 26: 27.0Apr 26: 28.0May 26: 47.0Jun 26: 70.0Jul 26: 41.0Aug 26: 22.0Sep 26: 11.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.50 / 30.43750.805
Daily demand sdmonthly sd / sqrt(30.4375)18.81 / 5.5173.410
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.410^2 + 0.805^2 * 7.4^2)34.7
Reorder pointd * LT + safety stock0.805 * 21.5 + 34.752.0
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days52.0
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 294/yr, S = 45.00, h = 20%, price = 315.7820.5
Inventory positionon hand + on order11 + 011

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

From qtyUnit costOrder qtyAnnual costFeasible
0315.782094,068yes (chosen if cheapest)

MOQ 12, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 2, 202611 / 25310.773,418.45

Movement ledger 121 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 14, 2026issueSO-261014-966MAIN 1 310.77-310.77113,418.45 Sept. 2, 2026: 1 @ 310.77
Oct. 12, 2026issueSO-261012-403MAIN 1 310.77-310.77123,729.22 Sept. 2, 2026: 1 @ 310.77
Oct. 3, 2026issueSO-261003-212MAIN 1 310.77-310.77134,039.99 Sept. 2, 2026: 1 @ 310.77
Oct. 2, 2026issueSO-261002-338MAIN 6 310.77-1,864.61144,350.76 Sept. 2, 2026: 6 @ 310.77
Oct. 1, 2026issueSO-261001-612MAIN 2 310.77-621.54206,215.37 Sept. 2, 2026: 2 @ 310.77
Sept. 18, 2026issueSO-260918-583EAST 2 310.77-621.54226,836.90 Sept. 2, 2026: 2 @ 310.77
Sept. 15, 2026issueSO-260915-754EAST 1 310.77-310.77247,458.44 Sept. 2, 2026: 1 @ 310.77
Sept. 9, 2026issueSO-260909-556MAIN 1 317.78-317.78257,769.21 June 30, 2026: 1 @ 317.78
Sept. 6, 2026issueSO-260906-257MAIN 7 317.78-2,224.49268,086.99 June 15, 2026: 5 @ 317.78; June 30, 2026: 2 @ 317.78
Sept. 2, 2026transferTRFMAIN → EAST 6 warehouse transfer, no cost effect
Sept. 2, 2026receiptPO-001770MAIN 25 310.777,769.213310,311.49
Aug. 21, 2026issueSO-260821-181MAIN 7 317.78-2,224.4982,542.28 June 15, 2026: 7 @ 317.78
Aug. 12, 2026issueSO-260812-156MAIN 14 317.78-4,448.99154,766.77 June 15, 2026: 14 @ 317.78
Aug. 6, 2026issueSO-260806-736MAIN 1 317.78-317.78299,215.76 June 15, 2026: 1 @ 317.78
July 19, 2026issueSO-260719-318MAIN 14 317.78-4,448.99309,533.55 June 15, 2026: 14 @ 317.78
July 10, 2026issueSO-260710-558MAIN 4 317.78-1,271.144413,982.54 June 15, 2026: 4 @ 317.78
July 10, 2026issueSO-260710-558EAST 23 317.78-7,309.054815,253.68 June 15, 2026: 23 @ 317.78
June 30, 2026returnRMAMAIN 3 317.78953.357122,562.73
June 29, 2026issueSO-260629-916MAIN 1 317.78-317.786821,609.37 June 15, 2026: 1 @ 317.78
June 23, 2026issueSO-260623-438MAIN 4 317.78-1,271.146921,927.16 June 15, 2026: 4 @ 317.78
June 17, 2026issueSO-260617-148MAIN 14 317.78-4,448.997323,198.30 June 15, 2026: 14 @ 317.78
June 16, 2026issueSO-260616-798EAST 6 317.78-1,906.718727,647.29 June 15, 2026: 6 @ 317.78
June 15, 2026transferTRFMAIN → EAST 29 warehouse transfer, no cost effect
June 15, 2026receiptPO-001575MAIN 93 317.7829,554.009329,554.00
June 9, 2026issueSO-260609-790MAIN 13 309.78-4,027.1100.00 April 26, 2026: 13 @ 309.78
June 8, 2026issueSO-260608-860MAIN 35 309.78-10,842.22134,027.11 April 26, 2026: 35 @ 309.78
May 21, 2026issueSO-260521-444MAIN 23 309.78-7,124.894814,869.33 April 26, 2026: 23 @ 309.78
May 19, 2026issueSO-260519-205MAIN 3 309.78-929.337121,994.22 April 26, 2026: 3 @ 309.78
May 13, 2026issueSO-260513-875MAIN 2 309.78-619.567422,923.56 April 26, 2026: 2 @ 309.78
May 1, 2026issueSO-260501-114MAIN 19 306.37-5,821.007623,543.11 March 31, 2026: 6 @ 298.98; April 26, 2026: 13 @ 309.78
April 26, 2026receiptPO-001440MAIN 89 309.7827,570.229529,364.12
April 25, 2026issueSO-260425-756MAIN 27 298.98-8,072.5161,793.89 March 31, 2026: 27 @ 298.98
April 8, 2026issueSO-260408-603MAIN 1 298.98-298.98339,866.40 March 31, 2026: 1 @ 298.98
March 31, 2026issueSO-260331-973MAIN 8 309.11-2,472.903410,165.38 Feb. 19, 2026: 5 @ 315.19; March 31, 2026: 3 @ 298.98
March 31, 2026receiptPO-001369MAIN 37 298.9811,062.334212,638.29
March 30, 2026issueSO-260330-823MAIN 6 315.19-1,891.1551,575.96 Feb. 19, 2026: 6 @ 315.19
March 21, 2026issueSO-260321-784MAIN 1 315.19-315.19113,467.10 Feb. 19, 2026: 1 @ 315.19
March 20, 2026issueSO-260320-146MAIN 2 315.19-630.38123,782.29 Feb. 19, 2026: 2 @ 315.19
March 8, 2026issueSO-260308-878MAIN 9 315.19-2,836.72144,412.68 Feb. 19, 2026: 9 @ 315.19
March 4, 2026issueSO-260304-849MAIN 1 295.43-295.43237,249.40 June 23, 2025: 1 @ 295.43
Feb. 19, 2026receiptPO-001241MAIN 23 315.197,249.40247,544.83
Feb. 13, 2026issueSO-260213-262MAIN 1 295.43-295.431295.43 June 23, 2025: 1 @ 295.43
Feb. 10, 2026issueSO-260210-172MAIN 8 295.43-2,363.482590.87 June 23, 2025: 8 @ 295.43
Jan. 30, 2026issueSO-260130-700MAIN 4 295.43-1,181.74102,954.35 June 23, 2025: 4 @ 295.43
Jan. 22, 2026issueSO-260122-185MAIN 1 295.43-295.43144,136.09 June 23, 2025: 1 @ 295.43
Jan. 21, 2026issueSO-260121-255MAIN 4 295.43-1,181.74154,431.52 June 23, 2025: 4 @ 295.43
Jan. 12, 2026issueSO-260112-550MAIN 5 295.43-1,477.17195,613.26 June 23, 2025: 5 @ 295.43
Jan. 1, 2026issueSO-260101-761MAIN 3 295.43-886.30247,090.44 June 23, 2025: 3 @ 295.43
Dec. 27, 2025issueSO-251227-449MAIN 1 295.43-295.43277,976.74 June 23, 2025: 1 @ 295.43
Dec. 25, 2025issueSO-251225-809MAIN 2 295.43-590.87288,272.17 June 23, 2025: 2 @ 295.43
Dec. 16, 2025issueSO-251216-592MAIN 1 295.43-295.43308,863.04 June 23, 2025: 1 @ 295.43
Dec. 15, 2025issueSO-251215-510MAIN 1 295.43-295.43319,158.48 June 23, 2025: 1 @ 295.43
Dec. 4, 2025issueSO-251204-405MAIN 1 295.43-295.43329,453.91 June 23, 2025: 1 @ 295.43
Nov. 30, 2025issueSO-251130-149MAIN 1 295.43-295.43339,749.35 June 23, 2025: 1 @ 295.43
Nov. 29, 2025issueSO-251129-296MAIN 3 295.43-886.303410,044.78 June 23, 2025: 3 @ 295.43
Nov. 12, 2025issueSO-251112-427MAIN 1 295.43-295.433710,931.09 June 23, 2025: 1 @ 295.43
Nov. 6, 2025issueSO-251106-695MAIN 1 295.43-295.433811,226.52 June 23, 2025: 1 @ 295.43
Oct. 31, 2025issueSO-251031-394MAIN 4 295.43-1,181.743911,521.96 June 23, 2025: 4 @ 295.43
Oct. 6, 2025issueSO-251006-666MAIN 1 295.43-295.434312,703.70 June 23, 2025: 1 @ 295.43
Oct. 2, 2025issueSO-251002-279MAIN 4 295.43-1,181.744412,999.13 June 23, 2025: 4 @ 295.43
Oct. 1, 2025issueSO-251001-573MAIN 1 295.43-295.434814,180.87 June 23, 2025: 1 @ 295.43
Sept. 29, 2025issueSO-250929-103MAIN 2 295.43-590.874914,476.31 June 23, 2025: 2 @ 295.43
Sept. 22, 2025issueSO-250922-655MAIN 2 295.43-590.875115,067.17 June 23, 2025: 2 @ 295.43
Sept. 6, 2025issueSO-250906-340MAIN 5 295.43-1,477.175315,658.04 June 23, 2025: 5 @ 295.43
Sept. 3, 2025issueSO-250903-635MAIN 5 295.43-1,477.175817,135.22 June 23, 2025: 5 @ 295.43
Sept. 1, 2025issueSO-250901-551MAIN 2 295.43-590.876318,612.39 June 23, 2025: 2 @ 295.43
Aug. 23, 2025issueSO-250823-180MAIN 1 295.43-295.436519,203.26 June 23, 2025: 1 @ 295.43
Aug. 22, 2025issueSO-250822-326MAIN 7 295.43-2,068.046619,498.70 June 23, 2025: 7 @ 295.43
Aug. 6, 2025issueSO-250806-761MAIN 9 295.43-2,658.917321,566.74 June 23, 2025: 9 @ 295.43
July 31, 2025issueSO-250731-347MAIN 6 295.43-1,772.618224,225.65 June 23, 2025: 6 @ 295.43
July 25, 2025issueSO-250725-195MAIN 1 295.43-295.438825,998.26 June 23, 2025: 1 @ 295.43
July 17, 2025issueSO-250717-568MAIN 1 295.43-295.438926,293.70 June 23, 2025: 1 @ 295.43
July 15, 2025issueSO-250715-208MAIN 2 295.43-590.879026,589.13 June 23, 2025: 2 @ 295.43
July 13, 2025issueSO-250713-105MAIN 4 296.31-1,185.259227,180.00 May 22, 2025: 3 @ 296.60; June 23, 2025: 1 @ 295.43
July 4, 2025issueSO-250704-567MAIN 18 296.60-5,338.869628,365.25 May 22, 2025: 18 @ 296.60
July 3, 2025issueSO-250703-292MAIN 4 296.60-1,186.4111433,704.11 May 22, 2025: 4 @ 296.60
June 27, 2025issueSO-250627-558MAIN 3 296.60-889.8111834,890.52 May 22, 2025: 3 @ 296.60
June 24, 2025issueSO-250624-352MAIN 3 296.60-889.8112135,780.33 May 22, 2025: 3 @ 296.60
June 23, 2025receiptPO-000660MAIN 93 295.4327,475.4412436,670.14
June 20, 2025issueSO-250620-777MAIN 9 296.60-2,669.43319,194.71 May 22, 2025: 9 @ 296.60
June 18, 2025issueSO-250618-792MAIN 2 296.60-593.214011,864.14 May 22, 2025: 2 @ 296.60
June 2, 2025issueSO-250602-491MAIN 16 296.60-4,745.664212,457.35 May 22, 2025: 16 @ 296.60
June 1, 2025issueSO-250601-133MAIN 7 296.60-2,076.225817,203.00 May 22, 2025: 7 @ 296.60
May 30, 2025issueSO-250530-870MAIN 14 296.60-4,152.456519,279.23 May 22, 2025: 14 @ 296.60
May 27, 2025issueSO-250527-712MAIN 4 296.60-1,186.417923,431.68 May 22, 2025: 4 @ 296.60
May 23, 2025issueSO-250523-513MAIN 6 296.60-1,779.628324,618.09 May 22, 2025: 6 @ 296.60
May 22, 2025receiptPO-000562MAIN 89 296.6026,397.718926,397.71
May 15, 2025issueSO-250515-267MAIN 19 293.69-5,580.1200.00 April 6, 2025: 19 @ 293.69
May 9, 2025issueSO-250509-609MAIN 19 293.69-5,580.12195,580.12 April 6, 2025: 19 @ 293.69
May 9, 2025issueSO-250509-609EAST 6 293.69-1,762.143811,160.23 April 6, 2025: 6 @ 293.69
April 30, 2025issueSO-250430-623MAIN 25 293.72-7,343.004412,922.37 Feb. 24, 2025: 8 @ 293.78; April 6, 2025: 17 @ 293.69
April 26, 2025issueSO-250426-371MAIN 3 293.78-881.356920,265.38 Feb. 24, 2025: 3 @ 293.78
April 6, 2025receiptPO-000419MAIN 61 293.6917,915.117221,146.73
March 30, 2025issueSO-250330-970MAIN 8 293.78-2,350.27113,231.62 Feb. 24, 2025: 8 @ 293.78
March 29, 2025issueSO-250329-543EAST 3 293.78-881.35195,581.88 Feb. 24, 2025: 3 @ 293.78
March 18, 2025issueSO-250318-554MAIN 1 293.78-293.78226,463.23 Feb. 24, 2025: 1 @ 293.78
March 17, 2025issueSO-250317-431MAIN 1 293.78-293.78236,757.02 Feb. 24, 2025: 1 @ 293.78
March 10, 2025issueSO-250310-396MAIN 6 293.78-1,762.70247,050.80 Feb. 24, 2025: 6 @ 293.78
Feb. 28, 2025issueSO-250228-448MAIN 8 294.56-2,356.47308,813.50 Oct. 1, 2024: 1 @ 299.99; Feb. 24, 2025: 7 @ 293.78
Feb. 24, 2025transferTRFMAIN → EAST 9 warehouse transfer, no cost effect
Feb. 24, 2025receiptPO-000298MAIN 37 293.7810,869.993811,169.98
Feb. 18, 2025issueSO-250218-859EAST 3 299.99-899.971299.99 Oct. 1, 2024: 3 @ 299.99
Feb. 13, 2025issueSO-250213-427MAIN 3 299.99-899.9741,199.96 Oct. 1, 2024: 3 @ 299.99
Feb. 9, 2025issueSO-250209-532MAIN 8 299.99-2,399.9372,099.94 Oct. 1, 2024: 8 @ 299.99
Jan. 17, 2025issueSO-250117-764MAIN 1 299.99-299.99154,499.86 Oct. 1, 2024: 1 @ 299.99
Jan. 15, 2025issueSO-250115-864EAST 6 299.99-1,799.95164,799.86 Oct. 1, 2024: 6 @ 299.99
Jan. 12, 2025issueSO-250112-163MAIN 2 299.99-599.98226,599.80 Oct. 1, 2024: 2 @ 299.99
Jan. 9, 2025issueSO-250109-570MAIN 1 299.99-299.99247,199.78 Oct. 1, 2024: 1 @ 299.99
Dec. 22, 2024issueSO-241222-530EAST 1 299.99-299.99257,499.78 Oct. 1, 2024: 1 @ 299.99
Dec. 20, 2024issueSO-241220-342MAIN 1 299.99-299.99267,799.77 Oct. 1, 2024: 1 @ 299.99
Dec. 13, 2024issueSO-241213-807EAST 2 299.99-599.98278,099.76 Oct. 1, 2024: 2 @ 299.99
Dec. 8, 2024issueSO-241208-458MAIN 1 299.99-299.99298,699.74 Oct. 1, 2024: 1 @ 299.99
Nov. 26, 2024issueSO-241126-813MAIN 4 299.99-1,199.96308,999.73 Oct. 1, 2024: 4 @ 299.99
Nov. 18, 2024issueSO-241118-881MAIN 1 299.99-299.993410,199.69 Oct. 1, 2024: 1 @ 299.99
Nov. 10, 2024issueSO-241110-235EAST 1 299.99-299.993510,499.68 Oct. 1, 2024: 1 @ 299.99
Oct. 31, 2024issueSO-241031-502MAIN 5 299.99-1,499.963610,799.68 Oct. 1, 2024: 5 @ 299.99
Oct. 27, 2024issueSO-241027-574MAIN 1 299.99-299.994112,299.63 Oct. 1, 2024: 1 @ 299.99
Oct. 24, 2024issueSO-241024-780MAIN 1 299.99-299.994212,599.62 Oct. 1, 2024: 1 @ 299.99
Oct. 3, 2024issueSO-241003-849MAIN 2 299.99-599.984312,899.61 Oct. 1, 2024: 2 @ 299.99
Oct. 1, 2024transferTRFMAIN → EAST 13 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000003MAIN 45 299.9913,499.604513,499.60