stocksense

Items / FAN-0015

Ceiling Fan 1400mm Eco FAN-0015 · Ceiling Fans · CoolBreeze Appliances

On hand (EA)29MAIN 29
Value (FIFO)7,327.66avg 252.68
ClassAY / FCV 0.67
Turnover14.8xlast issue 7 days ago
Days of cover35lead time 22d

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

Demand and forecast

Monthly demand and forecast for FAN-00150.014.929.744.659.4Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 9.0Nov 24: 5.0Dec 24: 5.0Jan 25: 10.0Feb 25: 12.0Mar 25: 27.0Apr 25: 51.0May 25: 50.0Jun 25: 54.0Jul 25: 41.0Aug 25: 29.0Sep 25: 23.0Oct 25: 13.0Nov 25: 6.0Dec 25: 4.0Jan 26: 13.0Feb 26: 12.0Mar 26: 21.0Apr 26: 50.0May 26: 54.0Jun 26: 36.0Jul 26: 49.0Aug 26: 28.0Sep 26: 18.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.33 / 30.43750.832
Daily demand sdmonthly sd / sqrt(30.4375)17.07 / 5.5173.093
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.093^2 + 0.832^2 * 7.4^2)32.0
Reorder pointd * LT + safety stock0.832 * 21.5 + 32.050.0
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days50.0
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 304/yr, S = 45.00, h = 20%, price = 262.1722.8
Inventory positionon hand + on order29 + 029

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

From qtyUnit costOrder qtyAnnual costFeasible
0262.172380,842yes (chosen if cheapest)

MOQ 14, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Aug. 25, 202629 / 51252.687,327.66

Movement ledger 128 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 9, 2026issueSO-261009-366MAIN 9 252.68-2,274.10297,327.66 Aug. 25, 2026: 9 @ 252.68
Oct. 6, 2026issueSO-261006-287MAIN 1 252.68-252.68389,601.77 Aug. 25, 2026: 1 @ 252.68
Sept. 30, 2026issueSO-260930-191MAIN 8 252.68-2,021.42399,854.45 Aug. 25, 2026: 8 @ 252.68
Sept. 26, 2026issueSO-260926-919MAIN 5 254.36-1,271.784711,875.87 June 8, 2026: 1 @ 261.07; Aug. 25, 2026: 4 @ 252.68
Sept. 23, 2026issueSO-260923-836EAST 2 261.07-522.135213,147.65 June 8, 2026: 2 @ 261.07
Sept. 14, 2026issueSO-260914-508MAIN 1 261.07-261.075413,669.78 June 8, 2026: 1 @ 261.07
Sept. 5, 2026issueSO-260905-315EAST 2 261.07-522.135513,930.85 June 8, 2026: 2 @ 261.07
Aug. 31, 2026issueSO-260831-516EAST 7 261.07-1,827.465714,452.98 June 8, 2026: 7 @ 261.07
Aug. 25, 2026transferTRFMAIN → EAST 11 warehouse transfer, no cost effect
Aug. 25, 2026receiptPO-001746MAIN 51 252.6812,886.586416,280.45
Aug. 21, 2026issueSO-260821-241MAIN 2 261.07-522.13133,393.86 June 8, 2026: 2 @ 261.07
Aug. 13, 2026issueSO-260813-230MAIN 8 261.07-2,088.53153,916.00 June 8, 2026: 8 @ 261.07
Aug. 10, 2026issueSO-260810-304MAIN 11 261.07-2,871.73236,004.53 June 8, 2026: 11 @ 261.07
July 26, 2026issueSO-260726-592MAIN 8 261.07-2,088.53348,876.26 June 8, 2026: 8 @ 261.07
July 19, 2026issueSO-260719-198MAIN 8 261.07-2,088.534210,964.79 June 8, 2026: 8 @ 261.07
July 13, 2026issueSO-260713-896MAIN 1 261.07-261.075013,053.32 June 8, 2026: 1 @ 261.07
July 6, 2026issueSO-260706-270MAIN 3 261.07-783.205113,314.39 June 8, 2026: 3 @ 261.07
July 6, 2026issueSO-260706-270EAST 22 261.07-5,743.465414,097.59 June 8, 2026: 22 @ 261.07
July 2, 2026issueSO-260702-415MAIN 4 261.07-1,044.277619,841.05 June 8, 2026: 4 @ 261.07
July 1, 2026issueSO-260701-577EAST 3 261.07-783.208020,885.31 June 8, 2026: 3 @ 261.07
June 25, 2026issueSO-260625-567MAIN 1 261.07-261.078321,668.51 June 8, 2026: 1 @ 261.07
June 19, 2026issueSO-260619-915MAIN 27 261.07-7,048.798421,929.58 June 8, 2026: 27 @ 261.07
June 8, 2026transferTRFMAIN → EAST 25 warehouse transfer, no cost effect
June 8, 2026receiptPO-001559MAIN 111 261.0728,978.3711128,978.37
June 1, 2026issueSO-260601-920MAIN 8 263.37-2,106.9400.00 April 19, 2026: 8 @ 263.37
May 22, 2026issueSO-260522-802MAIN 12 263.37-3,160.4182,106.94 April 19, 2026: 12 @ 263.37
May 17, 2026issueSO-260517-766MAIN 22 263.37-5,794.09205,267.35 April 19, 2026: 22 @ 263.37
May 10, 2026issueSO-260510-309MAIN 7 263.37-1,843.574211,061.44 April 19, 2026: 7 @ 263.37
May 10, 2026issueSO-260510-309EAST 13 263.37-3,423.784912,905.01 April 19, 2026: 13 @ 263.37
April 27, 2026issueSO-260427-172EAST 8 263.37-2,106.946216,328.79 April 19, 2026: 8 @ 263.37
April 21, 2026issueSO-260421-433MAIN 27 257.22-6,945.017018,435.73 Feb. 16, 2026: 20 @ 255.67; Feb. 21, 2026: 1 @ 251.39; April 19, 2026: 6 @ 263.37
April 19, 2026transferTRFMAIN → EAST 21 warehouse transfer, no cost effect
April 19, 2026receiptPO-001423MAIN 76 263.3720,015.949725,380.75
April 3, 2026issueSO-260403-671MAIN 15 255.67-3,835.07215,364.81 Feb. 16, 2026: 15 @ 255.67
March 25, 2026issueSO-260325-301MAIN 11 255.67-2,812.38369,199.88 Feb. 16, 2026: 11 @ 255.67
March 25, 2026issueSO-260325-301EAST 5 251.39-1,256.934712,012.26 Feb. 1, 2026: 5 @ 251.39
March 18, 2026issueSO-260318-351MAIN 5 251.39-1,256.935213,269.19 Feb. 1, 2026: 5 @ 251.39
Feb. 22, 2026issueSO-260222-107MAIN 3 251.39-754.165714,526.11 Feb. 1, 2026: 3 @ 251.39
Feb. 21, 2026returnRMAMAIN 1 251.39251.396015,280.27
Feb. 21, 2026issueSO-260221-757MAIN 2 251.39-502.775915,028.88 Feb. 1, 2026: 2 @ 251.39
Feb. 20, 2026issueSO-260220-671MAIN 1 251.39-251.396115,531.65 Feb. 1, 2026: 1 @ 251.39
Feb. 18, 2026issueSO-260218-338MAIN 1 251.39-251.396215,783.04 Feb. 1, 2026: 1 @ 251.39
Feb. 17, 2026issueSO-260217-935EAST 1 251.39-251.396316,034.42 Feb. 1, 2026: 1 @ 251.39
Feb. 16, 2026receiptPO-001232MAIN 46 255.6711,760.886416,285.81
Feb. 11, 2026issueSO-260211-374MAIN 3 251.39-754.16184,524.93 Feb. 1, 2026: 3 @ 251.39
Feb. 1, 2026issueSO-260201-567MAIN 2 251.39-502.77215,279.09 Feb. 1, 2026: 2 @ 251.39
Feb. 1, 2026transferTRFMAIN → EAST 6 warehouse transfer, no cost effect
Feb. 1, 2026receiptPO-001190MAIN 23 251.395,781.86235,781.86
Jan. 26, 2026issueSO-260126-796MAIN 3 254.55-763.6600.00 Dec. 13, 2025: 3 @ 254.55
Jan. 24, 2026issueSO-260124-432MAIN 1 254.55-254.553763.66 Dec. 13, 2025: 1 @ 254.55
Jan. 22, 2026issueSO-260122-589MAIN 1 254.55-254.5541,018.21 Dec. 13, 2025: 1 @ 254.55
Jan. 21, 2026issueSO-260121-703MAIN 3 254.55-763.6651,272.76 Dec. 13, 2025: 3 @ 254.55
Jan. 15, 2026issueSO-260115-285MAIN 4 254.55-1,018.2182,036.42 Dec. 13, 2025: 4 @ 254.55
Jan. 5, 2026issueSO-260105-656MAIN 1 254.55-254.55123,054.63 Dec. 13, 2025: 1 @ 254.55
Dec. 30, 2025issueSO-251230-435MAIN 1 254.55-254.55133,309.18 Dec. 13, 2025: 1 @ 254.55
Dec. 13, 2025receiptPO-001048MAIN 14 254.553,563.73143,563.73
Dec. 4, 2025issueSO-251204-145EAST 1 243.55-243.5500.00 Aug. 22, 2025: 1 @ 243.55
Dec. 3, 2025issueSO-251203-550EAST 2 243.55-487.111243.55 Aug. 22, 2025: 2 @ 243.55
Nov. 18, 2025issueSO-251118-989EAST 1 243.55-243.553730.66 Aug. 22, 2025: 1 @ 243.55
Nov. 12, 2025issueSO-251112-751EAST 5 243.55-1,217.764974.21 Aug. 22, 2025: 5 @ 243.55
Oct. 30, 2025issueSO-251030-260EAST 3 243.55-730.6692,191.98 Aug. 22, 2025: 3 @ 243.55
Oct. 26, 2025issueSO-251026-692EAST 2 243.55-487.11122,922.64 Aug. 22, 2025: 2 @ 243.55
Oct. 12, 2025issueSO-251012-938EAST 3 243.55-730.66143,409.74 Aug. 22, 2025: 3 @ 243.55
Oct. 11, 2025issueSO-251011-516EAST 3 243.55-730.66174,140.40 Aug. 22, 2025: 3 @ 243.55
Oct. 6, 2025issueSO-251006-274MAIN 2 243.55-487.11204,871.06 Aug. 22, 2025: 2 @ 243.55
Sept. 29, 2025issueSO-250929-363MAIN 3 243.55-730.66225,358.17 Aug. 22, 2025: 3 @ 243.55
Sept. 23, 2025issueSO-250923-997MAIN 4 243.55-974.21256,088.82 Aug. 22, 2025: 4 @ 243.55
Sept. 21, 2025issueSO-250921-529MAIN 3 243.55-730.66297,063.04 Aug. 22, 2025: 3 @ 243.55
Sept. 20, 2025issueSO-250920-139MAIN 4 243.55-974.21327,793.70 Aug. 22, 2025: 4 @ 243.55
Sept. 14, 2025issueSO-250914-581EAST 4 243.55-974.21368,767.91 Aug. 22, 2025: 4 @ 243.55
Sept. 13, 2025issueSO-250913-494MAIN 2 243.55-487.11409,742.12 Aug. 22, 2025: 2 @ 243.55
Sept. 6, 2025issueSO-250906-712MAIN 3 243.55-730.664210,229.23 Aug. 22, 2025: 3 @ 243.55
Aug. 28, 2025issueSO-250828-472MAIN 13 244.54-3,179.044510,959.88 May 21, 2025: 7 @ 245.39; Aug. 22, 2025: 6 @ 243.55
Aug. 22, 2025transferTRFMAIN → EAST 17 warehouse transfer, no cost effect
Aug. 22, 2025receiptPO-000788MAIN 51 243.5512,421.205814,138.93
Aug. 20, 2025issueSO-250820-266EAST 5 245.39-1,226.9571,717.72 May 21, 2025: 5 @ 245.39
Aug. 12, 2025issueSO-250812-461EAST 5 245.39-1,226.95122,944.67 May 21, 2025: 5 @ 245.39
Aug. 12, 2025issueSO-250812-461MAIN 5 245.39-1,226.95174,171.61 May 21, 2025: 5 @ 245.39
Aug. 1, 2025issueSO-250801-398MAIN 1 245.39-245.39225,398.56 May 21, 2025: 1 @ 245.39
July 27, 2025issueSO-250727-527MAIN 12 245.39-2,944.67235,643.95 May 21, 2025: 12 @ 245.39
July 17, 2025issueSO-250717-168MAIN 29 245.39-7,116.28358,588.62 May 21, 2025: 29 @ 245.39
June 27, 2025issueSO-250627-334MAIN 8 245.39-1,963.116415,704.90 May 21, 2025: 8 @ 245.39
June 24, 2025issueSO-250624-420MAIN 22 245.39-5,398.567217,668.02 May 21, 2025: 22 @ 245.39
June 23, 2025issueSO-250623-775MAIN 9 245.39-2,208.509423,066.58 May 21, 2025: 9 @ 245.39
June 18, 2025issueSO-250618-300EAST 2 245.39-490.7810325,275.08 May 21, 2025: 2 @ 245.39
June 7, 2025issueSO-250607-448EAST 10 245.91-2,459.1210525,765.86 April 22, 2025: 4 @ 246.70; May 21, 2025: 6 @ 245.39
June 1, 2025issueSO-250601-873MAIN 3 246.70-740.0911528,224.97 April 22, 2025: 3 @ 246.70
May 21, 2025transferTRFMAIN → EAST 29 warehouse transfer, no cost effect
May 21, 2025receiptPO-000555MAIN 111 245.3927,238.1911828,965.06
May 10, 2025issueSO-250510-524MAIN 8 246.70-1,973.5671,726.87 April 22, 2025: 8 @ 246.70
May 5, 2025issueSO-250505-426MAIN 42 246.70-10,361.20153,700.43 April 22, 2025: 42 @ 246.70
April 24, 2025issueSO-250424-627MAIN 37 243.08-8,993.875714,061.63 Feb. 20, 2025: 18 @ 239.26; April 22, 2025: 19 @ 246.70
April 22, 2025receiptPO-000472MAIN 76 246.7018,748.849423,055.50
April 13, 2025issueSO-250413-967MAIN 9 239.26-2,153.33184,306.66 Feb. 20, 2025: 9 @ 239.26
April 9, 2025issueSO-250409-140MAIN 5 239.26-1,196.30276,460.00 Feb. 20, 2025: 5 @ 239.26
April 6, 2025adjustmentCycle countMAIN -1 239.26-239.26327,656.29 Feb. 20, 2025: 1 @ 239.26
March 29, 2025issueSO-250329-531EAST 10 239.26-2,392.59337,895.55 Feb. 20, 2025: 10 @ 239.26
March 24, 2025issueSO-250324-634MAIN 1 239.26-239.264310,288.14 Feb. 20, 2025: 1 @ 239.26
March 22, 2025adjustmentCycle countMAIN -1 239.26-239.264410,527.40 Feb. 20, 2025: 1 @ 239.26
March 20, 2025issueSO-250320-599MAIN 6 247.43-1,484.574510,766.66 Oct. 29, 2024: 4 @ 249.06; Feb. 18, 2025: 1 @ 249.06; Feb. 20, 2025: 1 @ 239.26
March 12, 2025issueSO-250312-976MAIN 6 249.06-1,494.375112,251.23 Oct. 1, 2024: 4 @ 249.06; Oct. 29, 2024: 2 @ 249.06
March 11, 2025issueSO-250311-258MAIN 1 249.06-249.065713,745.60 Oct. 1, 2024: 1 @ 249.06
March 6, 2025issueSO-250306-396EAST 3 249.06-747.185813,994.66 Oct. 1, 2024: 3 @ 249.06
Feb. 24, 2025issueSO-250224-279MAIN 1 249.06-249.066114,741.84 Oct. 1, 2024: 1 @ 249.06
Feb. 22, 2025issueSO-250222-690MAIN 1 249.06-249.066214,990.90 Oct. 1, 2024: 1 @ 249.06
Feb. 20, 2025issueSO-250220-914MAIN 6 249.06-1,494.376315,239.96 Oct. 1, 2024: 6 @ 249.06
Feb. 20, 2025transferTRFMAIN → EAST 13 warehouse transfer, no cost effect
Feb. 20, 2025receiptPO-000283MAIN 46 239.2611,005.926916,734.33
Feb. 18, 2025returnRMAMAIN 1 249.06249.06235,728.41
Feb. 15, 2025issueSO-250215-438MAIN 1 249.06-249.06225,479.35 Oct. 1, 2024: 1 @ 249.06
Feb. 3, 2025issueSO-250203-610MAIN 2 249.06-498.12235,728.41 Oct. 1, 2024: 2 @ 249.06
Feb. 2, 2025issueSO-250202-176MAIN 2 249.06-498.12256,226.54 Oct. 1, 2024: 2 @ 249.06
Jan. 5, 2025issueSO-250105-785MAIN 2 249.06-498.12276,724.66 Oct. 1, 2024: 2 @ 249.06
Jan. 4, 2025issueSO-250104-203MAIN 8 249.06-1,992.49297,222.78 Oct. 1, 2024: 8 @ 249.06
Dec. 31, 2024issueSO-241231-905MAIN 1 249.06-249.06379,215.28 Oct. 1, 2024: 1 @ 249.06
Dec. 21, 2024issueSO-241221-640MAIN 1 249.06-249.06389,464.34 Oct. 1, 2024: 1 @ 249.06
Dec. 16, 2024issueSO-241216-740MAIN 1 249.06-249.06399,713.40 Oct. 1, 2024: 1 @ 249.06
Dec. 8, 2024issueSO-241208-738MAIN 2 249.06-498.12409,962.46 Oct. 1, 2024: 2 @ 249.06
Nov. 26, 2024issueSO-241126-433MAIN 1 249.06-249.064210,460.58 Oct. 1, 2024: 1 @ 249.06
Nov. 20, 2024issueSO-241120-424MAIN 1 249.06-249.064310,709.64 Oct. 1, 2024: 1 @ 249.06
Nov. 11, 2024issueSO-241111-533MAIN 1 249.06-249.064410,958.71 Oct. 1, 2024: 1 @ 249.06
Nov. 5, 2024issueSO-241105-265MAIN 1 249.06-249.064511,207.77 Oct. 1, 2024: 1 @ 249.06
Nov. 2, 2024issueSO-241102-658MAIN 1 249.06-249.064611,456.83 Oct. 1, 2024: 1 @ 249.06
Oct. 29, 2024returnRMAMAIN 6 249.061,494.374711,705.89
Oct. 21, 2024issueSO-241021-115MAIN 13 249.06-3,237.804110,211.52 Oct. 1, 2024: 13 @ 249.06
Oct. 18, 2024issueSO-241018-612MAIN 1 249.06-249.065413,449.32 Oct. 1, 2024: 1 @ 249.06
Oct. 12, 2024issueSO-241012-834MAIN 1 249.06-249.065513,698.38 Oct. 1, 2024: 1 @ 249.06
Oct. 1, 2024receiptPO-000003MAIN 56 249.0613,947.445613,947.44