stocksense

Items / FAN-0023

Table Fan 300mm Nova FAN-0023 · Ceiling Fans · CoolBreeze Appliances

On hand (EA)14MAIN 14
Value (FIFO)1,268.54avg 90.61
ClassBY / FCV 0.73
Turnover16.1xlast issue 0 days ago
Days of cover17lead time 22d

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

Demand and forecast

Monthly demand and forecast for FAN-00230.017.334.752.069.3Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 11.0Nov 24: 5.0Dec 24: 3.0Jan 25: 8.0Feb 25: 11.0Mar 25: 24.0Apr 25: 51.0May 25: 35.0Jun 25: 47.0Jul 25: 37.0Aug 25: 31.0Sep 25: 18.0Oct 25: 12.0Nov 25: 7.0Dec 25: 6.0Jan 26: 7.0Feb 26: 14.0Mar 26: 26.0Apr 26: 32.0May 26: 54.0Jun 26: 63.0Jul 26: 41.0Aug 26: 25.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.437525.00 / 30.43750.821
Daily demand sdmonthly sd / sqrt(30.4375)18.33 / 5.5173.323
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.323^2 + 0.821^2 * 7.4^2)27.2
Reorder pointd * LT + safety stock0.821 * 21.5 + 27.244.9
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days44.9
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 300/yr, S = 45.00, h = 20%, price = 91.3238.4
Inventory positionon hand + on order14 + 014

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

From qtyUnit costOrder qtyAnnual costFeasible
091.323828,079yes (chosen if cheapest)

MOQ 13, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
June 28, 202610 / 10690.61906.10
July 9, 20261 / 190.6190.61
July 30, 20263 / 390.61271.83

Movement ledger 132 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026issueSO-261016-353MAIN 4 90.61-362.44141,268.54 June 28, 2026: 4 @ 90.61
Oct. 8, 2026issueSO-261008-651MAIN 2 90.61-181.22181,630.98 June 28, 2026: 2 @ 90.61
Oct. 6, 2026issueSO-261006-804MAIN 2 90.61-181.22201,812.20 June 28, 2026: 2 @ 90.61
Oct. 3, 2026issueSO-261003-987MAIN 2 90.61-181.22221,993.42 June 28, 2026: 2 @ 90.61
Oct. 2, 2026issueSO-261002-565MAIN 1 90.61-90.61242,174.64 June 28, 2026: 1 @ 90.61
Oct. 1, 2026issueSO-261001-411MAIN 2 90.61-181.22252,265.25 June 28, 2026: 2 @ 90.61
Sept. 30, 2026issueSO-260930-440MAIN 3 90.61-271.83272,446.47 June 28, 2026: 3 @ 90.61
Sept. 27, 2026issueSO-260927-146MAIN 1 90.61-90.61302,718.30 June 28, 2026: 1 @ 90.61
Sept. 22, 2026issueSO-260922-525MAIN 3 90.61-271.83312,808.91 June 28, 2026: 3 @ 90.61
Sept. 19, 2026issueSO-260919-434MAIN 1 90.61-90.61343,080.74 June 28, 2026: 1 @ 90.61
Sept. 16, 2026issueSO-260916-751MAIN 1 90.61-90.61353,171.35 June 28, 2026: 1 @ 90.61
Sept. 2, 2026issueSO-260902-883MAIN 3 90.61-271.83363,261.96 June 28, 2026: 3 @ 90.61
Sept. 1, 2026issueSO-260901-157MAIN 1 90.61-90.61393,533.79 June 28, 2026: 1 @ 90.61
Aug. 24, 2026issueSO-260824-241MAIN 5 90.61-453.05403,624.40 June 28, 2026: 5 @ 90.61
Aug. 20, 2026issueSO-260820-576MAIN 11 90.61-996.71454,077.45 June 28, 2026: 11 @ 90.61
Aug. 15, 2026issueSO-260815-116MAIN 3 90.61-271.83565,074.17 June 28, 2026: 3 @ 90.61
Aug. 12, 2026issueSO-260812-843MAIN 6 90.61-543.66595,346.00 June 28, 2026: 6 @ 90.61
July 30, 2026returnRMAMAIN 3 90.61271.83655,889.66
July 21, 2026issueSO-260721-532MAIN 6 90.61-543.66625,617.83 June 28, 2026: 6 @ 90.61
July 16, 2026issueSO-260716-176MAIN 9 90.61-815.49686,161.49 June 28, 2026: 9 @ 90.61
July 15, 2026issueSO-260715-234MAIN 7 90.61-634.27776,976.98 June 28, 2026: 7 @ 90.61
July 12, 2026issueSO-260712-693MAIN 5 90.61-453.05847,611.25 June 28, 2026: 5 @ 90.61
July 9, 2026returnRMAMAIN 1 90.6190.61898,064.30
July 6, 2026issueSO-260706-569MAIN 12 90.61-1,087.32887,973.69 June 28, 2026: 12 @ 90.61
July 4, 2026issueSO-260704-657MAIN 1 90.61-90.611009,061.01 June 28, 2026: 1 @ 90.61
July 2, 2026issueSO-260702-200MAIN 5 90.61-453.051019,151.62 June 28, 2026: 5 @ 90.61
June 28, 2026receiptPO-001609MAIN 106 90.619,604.671069,604.67
June 22, 2026issueSO-260622-655MAIN 33 90.92-3,000.4200.00 April 22, 2026: 33 @ 90.92
June 18, 2026issueSO-260618-354MAIN 17 90.92-1,545.67333,000.42 April 22, 2026: 17 @ 90.92
June 9, 2026issueSO-260609-553MAIN 12 90.92-1,091.06504,546.10 April 22, 2026: 12 @ 90.92
June 1, 2026issueSO-260601-943MAIN 1 90.92-90.92625,637.16 April 22, 2026: 1 @ 90.92
May 25, 2026issueSO-260525-522MAIN 7 90.92-636.45635,728.08 April 22, 2026: 7 @ 90.92
May 22, 2026issueSO-260522-257MAIN 22 90.92-2,000.28706,364.53 April 22, 2026: 22 @ 90.92
May 18, 2026issueSO-260518-596MAIN 21 88.81-1,864.93928,364.81 March 18, 2026: 11 @ 86.88; April 22, 2026: 10 @ 90.92
May 9, 2026issueSO-260509-939MAIN 3 86.88-260.6511310,229.74 March 18, 2026: 3 @ 86.88
May 5, 2026issueSO-260505-524MAIN 1 86.88-86.8811610,490.39 March 18, 2026: 1 @ 86.88
April 27, 2026issueSO-260427-227MAIN 1 86.88-86.8811710,577.27 March 18, 2026: 1 @ 86.88
April 26, 2026issueSO-260426-249EAST 10 86.88-868.8211810,664.15 March 18, 2026: 10 @ 86.88
April 23, 2026issueSO-260423-330MAIN 3 86.88-260.6512811,532.98 March 18, 2026: 3 @ 86.88
April 22, 2026receiptPO-001431MAIN 102 90.929,274.0313111,793.63
April 21, 2026issueSO-260421-658MAIN 7 86.88-608.18292,519.59 March 18, 2026: 7 @ 86.88
April 13, 2026issueSO-260413-361MAIN 8 86.98-695.86363,127.77 March 1, 2026: 2 @ 87.28; March 18, 2026: 6 @ 86.88
April 7, 2026issueSO-260407-761EAST 2 87.28-174.57443,823.63 March 1, 2026: 2 @ 87.28
April 3, 2026issueSO-260403-760MAIN 1 87.28-87.28463,998.20 March 1, 2026: 1 @ 87.28
March 18, 2026transferTRFMAIN → EAST 12 warehouse transfer, no cost effect
March 18, 2026receiptPO-001332MAIN 42 86.883,649.06474,085.48
March 15, 2026issueSO-260315-525MAIN 8 87.28-698.275436.42 March 1, 2026: 8 @ 87.28
March 11, 2026issueSO-260311-196MAIN 8 87.28-698.27131,134.69 March 1, 2026: 8 @ 87.28
March 4, 2026issueSO-260304-242MAIN 2 87.28-174.57211,832.96 March 1, 2026: 2 @ 87.28
March 1, 2026issueSO-260301-697MAIN 8 87.80-702.42232,007.53 Jan. 17, 2026: 5 @ 88.11; March 1, 2026: 3 @ 87.28
March 1, 2026receiptPO-001271MAIN 26 87.282,269.38312,709.95
Feb. 26, 2026issueSO-260226-617MAIN 2 88.11-176.235440.57 Jan. 17, 2026: 2 @ 88.11
Feb. 20, 2026issueSO-260220-928MAIN 1 88.11-88.117616.80 Jan. 17, 2026: 1 @ 88.11
Feb. 17, 2026issueSO-260217-812EAST 1 88.11-88.118704.91 Jan. 17, 2026: 1 @ 88.11
Feb. 5, 2026issueSO-260205-729MAIN 8 88.11-704.919793.02 Jan. 17, 2026: 8 @ 88.11
Feb. 2, 2026issueSO-260202-670EAST 2 88.11-176.23171,497.93 Jan. 17, 2026: 2 @ 88.11
Jan. 29, 2026issueSO-260129-286EAST 2 88.11-176.23191,674.16 Jan. 17, 2026: 2 @ 88.11
Jan. 17, 2026transferTRFMAIN → EAST 5 warehouse transfer, no cost effect
Jan. 17, 2026receiptPO-001154MAIN 21 88.111,850.39211,850.39
Jan. 5, 2026issueSO-260105-903EAST 1 88.44-88.4400.00 Dec. 12, 2025: 1 @ 88.44
Jan. 5, 2026issueSO-260105-903MAIN 3 88.44-265.33188.44 Aug. 29, 2025: 3 @ 88.44
Jan. 3, 2026issueSO-260103-730EAST 1 88.44-88.444353.77 Aug. 29, 2025: 1 @ 88.44
Dec. 26, 2025issueSO-251226-204MAIN 1 88.44-88.445442.21 Aug. 29, 2025: 1 @ 88.44
Dec. 23, 2025issueSO-251223-267MAIN 2 88.44-176.896530.66 Aug. 29, 2025: 2 @ 88.44
Dec. 15, 2025issueSO-251215-253MAIN 1 88.44-88.448707.54 Aug. 29, 2025: 1 @ 88.44
Dec. 12, 2025returnRMAMAIN 1 88.4488.449795.98
Dec. 1, 2025issueSO-251201-597MAIN 3 88.44-265.338707.54 Aug. 29, 2025: 3 @ 88.44
Nov. 27, 2025issueSO-251127-796MAIN 2 88.44-176.8911972.87 Aug. 29, 2025: 2 @ 88.44
Nov. 12, 2025issueSO-251112-504MAIN 2 88.44-176.89131,149.76 Aug. 29, 2025: 2 @ 88.44
Nov. 11, 2025issueSO-251111-258MAIN 1 88.44-88.44151,326.64 Aug. 29, 2025: 1 @ 88.44
Nov. 6, 2025issueSO-251106-208MAIN 2 88.44-176.89161,415.08 Aug. 29, 2025: 2 @ 88.44
Oct. 27, 2025issueSO-251027-585MAIN 2 88.44-176.89181,591.97 Aug. 29, 2025: 2 @ 88.44
Oct. 23, 2025issueSO-251023-924EAST 5 88.44-442.21201,768.85 Aug. 29, 2025: 5 @ 88.44
Oct. 1, 2025issueSO-251001-914MAIN 5 88.44-442.21252,211.07 Aug. 29, 2025: 5 @ 88.44
Sept. 23, 2025issueSO-250923-214EAST 5 88.44-442.21302,653.28 Aug. 29, 2025: 5 @ 88.44
Sept. 17, 2025issueSO-250917-456EAST 1 88.44-88.44353,095.49 Aug. 29, 2025: 1 @ 88.44
Sept. 14, 2025issueSO-250914-474MAIN 3 88.44-265.33363,183.94 Aug. 29, 2025: 3 @ 88.44
Sept. 12, 2025issueSO-250912-543MAIN 7 88.44-619.10393,449.27 Aug. 29, 2025: 7 @ 88.44
Sept. 10, 2025issueSO-250910-355MAIN 1 88.21-88.21464,068.36 May 20, 2025: 1 @ 88.21
Sept. 9, 2025issueSO-250909-458MAIN 1 88.21-88.21474,156.57 May 20, 2025: 1 @ 88.21
Aug. 29, 2025transferTRFMAIN → EAST 13 warehouse transfer, no cost effect
Aug. 29, 2025receiptPO-000801MAIN 46 88.444,068.36484,244.77
Aug. 23, 2025issueSO-250823-791MAIN 1 88.21-88.212176.41 May 20, 2025: 1 @ 88.21
Aug. 22, 2025issueSO-250822-537MAIN 2 88.21-176.413264.62 May 20, 2025: 2 @ 88.21
Aug. 7, 2025issueSO-250807-680MAIN 2 88.21-176.415441.03 May 20, 2025: 2 @ 88.21
Aug. 6, 2025issueSO-250806-658MAIN 3 88.21-264.627617.44 May 20, 2025: 3 @ 88.21
Aug. 5, 2025issueSO-250805-744MAIN 23 88.21-2,028.7210882.05 May 20, 2025: 23 @ 88.21
July 20, 2025issueSO-250720-251MAIN 8 88.21-705.64332,910.77 May 20, 2025: 8 @ 88.21
July 18, 2025issueSO-250718-566MAIN 6 88.21-529.23413,616.42 May 20, 2025: 6 @ 88.21
July 16, 2025issueSO-250716-405MAIN 20 88.21-1,764.11474,145.65 May 20, 2025: 20 @ 88.21
July 11, 2025issueSO-250711-314MAIN 1 88.21-88.21675,909.76 May 20, 2025: 1 @ 88.21
July 10, 2025issueSO-250710-436MAIN 2 88.21-176.41685,997.96 May 20, 2025: 2 @ 88.21
June 29, 2025issueSO-250629-874MAIN 5 88.21-441.03706,174.37 May 20, 2025: 5 @ 88.21
June 5, 2025issueSO-250605-967MAIN 42 87.11-3,658.48756,615.40 May 17, 2025: 15 @ 85.13; May 20, 2025: 27 @ 88.21
May 20, 2025receiptPO-000552MAIN 102 88.218,996.9411710,273.88
May 17, 2025returnRMAMAIN 15 85.131,276.94151,276.94
May 8, 2025issueSO-250508-756MAIN 7 85.13-595.9000.00 April 8, 2025: 7 @ 85.13
May 6, 2025issueSO-250506-763MAIN 9 85.13-766.167595.90 April 8, 2025: 9 @ 85.13
May 3, 2025issueSO-250503-992MAIN 4 85.13-340.52161,362.07 April 8, 2025: 4 @ 85.13
May 1, 2025issueSO-250501-592MAIN 30 85.13-2,553.88201,702.58 April 8, 2025: 30 @ 85.13
April 27, 2025issueSO-250427-622MAIN 30 85.97-2,579.05504,256.46 March 10, 2025: 11 @ 87.42; April 8, 2025: 19 @ 85.13
April 24, 2025issueSO-250424-832MAIN 19 87.42-1,660.93806,835.51 March 10, 2025: 19 @ 87.42
April 8, 2025receiptPO-000424MAIN 69 85.135,873.91998,496.43
April 3, 2025issueSO-250403-697MAIN 2 87.42-174.83302,622.52 March 10, 2025: 2 @ 87.42
March 24, 2025issueSO-250324-581MAIN 2 87.42-174.83322,797.35 March 10, 2025: 2 @ 87.42
March 21, 2025issueSO-250321-502MAIN 1 87.42-87.42342,972.19 March 10, 2025: 1 @ 87.42
March 18, 2025issueSO-250318-921MAIN 7 87.42-611.92353,059.61 March 10, 2025: 7 @ 87.42
March 10, 2025receiptPO-000333MAIN 42 87.423,671.53423,671.53
March 7, 2025issueSO-250307-229MAIN 12 86.75-1,041.0500.00 Oct. 1, 2024: 12 @ 86.75
March 6, 2025issueSO-250306-339MAIN 1 86.75-86.75121,041.05 Oct. 1, 2024: 1 @ 86.75
March 3, 2025issueSO-250303-760MAIN 1 86.75-86.75131,127.80 Oct. 1, 2024: 1 @ 86.75
Feb. 19, 2025issueSO-250219-470MAIN 1 86.75-86.75141,214.56 Oct. 1, 2024: 1 @ 86.75
Feb. 7, 2025issueSO-250207-376MAIN 2 86.75-173.51151,301.31 Oct. 1, 2024: 2 @ 86.75
Feb. 6, 2025issueSO-250206-530MAIN 1 86.75-86.75171,474.82 Oct. 1, 2024: 1 @ 86.75
Feb. 2, 2025issueSO-250202-523MAIN 2 86.75-173.51181,561.57 Oct. 1, 2024: 2 @ 86.75
Feb. 2, 2025issueSO-250202-523EAST 5 86.75-433.77201,735.08 Oct. 1, 2024: 5 @ 86.75
Jan. 25, 2025issueSO-250125-640MAIN 2 86.75-173.51252,168.85 Oct. 1, 2024: 2 @ 86.75
Jan. 20, 2025issueSO-250120-391MAIN 2 86.75-173.51272,342.36 Oct. 1, 2024: 2 @ 86.75
Jan. 15, 2025issueSO-250115-875MAIN 3 86.75-260.26292,515.87 Oct. 1, 2024: 3 @ 86.75
Jan. 2, 2025issueSO-250102-377EAST 1 86.75-86.75322,776.13 Oct. 1, 2024: 1 @ 86.75
Dec. 22, 2024issueSO-241222-693MAIN 1 86.75-86.75332,862.88 Oct. 1, 2024: 1 @ 86.75
Dec. 6, 2024issueSO-241206-330EAST 2 86.75-173.51342,949.64 Oct. 1, 2024: 2 @ 86.75
Nov. 19, 2024issueSO-241119-820EAST 1 86.75-86.75363,123.14 Oct. 1, 2024: 1 @ 86.75
Nov. 13, 2024issueSO-241113-170MAIN 4 86.75-347.02373,209.90 Oct. 1, 2024: 4 @ 86.75
Oct. 28, 2024issueSO-241028-132MAIN 1 86.75-86.75413,556.91 Oct. 1, 2024: 1 @ 86.75
Oct. 24, 2024issueSO-241024-575MAIN 1 86.75-86.75423,643.67 Oct. 1, 2024: 1 @ 86.75
Oct. 20, 2024issueSO-241020-286MAIN 2 86.75-173.51433,730.42 Oct. 1, 2024: 2 @ 86.75
Oct. 19, 2024issueSO-241019-977EAST 5 86.75-433.77453,903.93 Oct. 1, 2024: 5 @ 86.75
Oct. 14, 2024issueSO-241014-364EAST 1 86.75-86.75504,337.70 Oct. 1, 2024: 1 @ 86.75
Oct. 7, 2024issueSO-241007-419MAIN 1 86.75-86.75514,424.45 Oct. 1, 2024: 1 @ 86.75
Oct. 1, 2024transferTRFMAIN → EAST 15 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000003MAIN 52 86.754,511.21524,511.21