stocksense

Items / FAN-0010

Decorative Ceiling Fan Pro FAN-0010 · Ceiling Fans · CoolBreeze Appliances

On hand (EA)7MAIN 7
Value (FIFO)677.29avg 96.76
ClassBY / FCV 0.67
Turnover48.6xlast issue 0 days ago
Days of cover10lead time 22d

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

Demand and forecast

Monthly demand and forecast for FAN-00100.016.031.947.963.8Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 11.0Nov 24: 7.0Dec 24: 5.0Jan 25: 11.0Feb 25: 16.0Mar 25: 18.0Apr 25: 40.0May 25: 18.0Jun 25: 58.0Jul 25: 46.0Aug 25: 23.0Sep 25: 6.0Oct 25: 8.0Nov 25: 5.0Dec 25: 5.0Jan 26: 11.0Feb 26: 19.0Mar 26: 12.0Apr 26: 31.0May 26: 37.0Jun 26: 47.0Jul 26: 43.0Aug 26: 31.0Sep 26: 12.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.437521.75 / 30.43750.715
Daily demand sdmonthly sd / sqrt(30.4375)14.60 / 5.5172.645
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 * 2.645^2 + 0.715^2 * 7.4^2)22.0
Reorder pointd * LT + safety stock0.715 * 21.5 + 22.037.3
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days37.3
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 261/yr, S = 45.00, h = 20%, price = 98.3034.6
Inventory positionon hand + on order7 + 07

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

From qtyUnit costOrder qtyAnnual costFeasible
098.303526,318yes (chosen if cheapest)

MOQ 12, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 14, 20267 / 2696.76677.29

Movement ledger 132 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026issueSO-261016-448MAIN 6 96.76-580.547677.29 Sept. 14, 2026: 6 @ 96.76
Oct. 6, 2026issueSO-261006-233MAIN 1 96.76-96.76131,257.83 Sept. 14, 2026: 1 @ 96.76
Oct. 3, 2026issueSO-261003-870MAIN 1 96.76-96.76141,354.58 Sept. 14, 2026: 1 @ 96.76
Sept. 28, 2026issueSO-260928-286MAIN 5 96.76-483.78151,451.34 Sept. 14, 2026: 5 @ 96.76
Sept. 23, 2026issueSO-260923-178MAIN 5 96.76-483.78201,935.12 Sept. 14, 2026: 5 @ 96.76
Sept. 16, 2026issueSO-260916-282MAIN 1 96.76-96.76252,418.90 Sept. 14, 2026: 1 @ 96.76
Sept. 14, 2026receiptPO-001800MAIN 26 96.762,515.65262,515.65
Sept. 5, 2026issueSO-260905-397MAIN 1 95.10-95.1000.00 June 7, 2026: 1 @ 95.10
Aug. 24, 2026issueSO-260824-988MAIN 12 94.97-1,139.64195.10 June 3, 2026: 12 @ 94.97
Aug. 17, 2026issueSO-260817-581MAIN 1 94.97-94.97131,234.75 June 3, 2026: 1 @ 94.97
Aug. 14, 2026issueSO-260814-939MAIN 15 94.97-1,424.56141,329.72 June 3, 2026: 15 @ 94.97
Aug. 6, 2026issueSO-260806-222MAIN 1 94.97-94.97292,754.27 June 3, 2026: 1 @ 94.97
Aug. 3, 2026issueSO-260803-469MAIN 2 94.97-189.94302,849.24 June 3, 2026: 2 @ 94.97
July 31, 2026issueSO-260731-892MAIN 25 94.97-2,374.26323,039.18 June 3, 2026: 25 @ 94.97
July 14, 2026issueSO-260714-749MAIN 13 94.97-1,234.62575,413.44 June 3, 2026: 13 @ 94.97
July 5, 2026issueSO-260705-770MAIN 5 94.97-474.85706,648.06 June 3, 2026: 5 @ 94.97
June 18, 2026issueSO-260618-827MAIN 1 94.97-94.97757,122.91 June 3, 2026: 1 @ 94.97
June 15, 2026issueSO-260615-430MAIN 10 94.97-949.70767,217.88 June 3, 2026: 10 @ 94.97
June 10, 2026issueSO-260610-821MAIN 37 95.06-3,517.21868,167.59 April 12, 2026: 25 @ 95.10; June 3, 2026: 12 @ 94.97
June 7, 2026returnRMAMAIN 1 95.1095.1012311,684.80
June 3, 2026receiptPO-001545MAIN 97 94.979,212.1312211,589.69
May 31, 2026issueSO-260531-303MAIN 12 95.10-1,141.23252,377.56 April 12, 2026: 12 @ 95.10
May 29, 2026issueSO-260529-112MAIN 7 95.10-665.72373,518.80 April 12, 2026: 7 @ 95.10
May 24, 2026issueSO-260524-885MAIN 7 95.10-665.72444,184.51 April 12, 2026: 7 @ 95.10
May 19, 2026issueSO-260519-131MAIN 3 95.10-285.31514,850.23 April 12, 2026: 3 @ 95.10
May 9, 2026issueSO-260509-110MAIN 7 95.10-665.72545,135.54 April 12, 2026: 7 @ 95.10
May 9, 2026issueSO-260509-110EAST 1 95.10-95.10615,801.26 April 12, 2026: 1 @ 95.10
April 20, 2026issueSO-260420-265MAIN 2 94.84-189.69625,896.36 March 9, 2026: 1 @ 94.58; April 12, 2026: 1 @ 95.10
April 19, 2026issueSO-260419-958EAST 1 94.58-94.58646,086.05 March 9, 2026: 1 @ 94.58
April 16, 2026issueSO-260416-731MAIN 3 94.58-283.75656,180.63 March 9, 2026: 3 @ 94.58
April 15, 2026issueSO-260415-581EAST 12 94.58-1,135.01686,464.38 March 9, 2026: 12 @ 94.58
April 14, 2026issueSO-260414-207MAIN 2 94.58-189.17807,599.39 March 9, 2026: 2 @ 94.58
April 12, 2026transferTRFMAIN → EAST 14 warehouse transfer, no cost effect
April 12, 2026receiptPO-001402MAIN 63 95.105,991.46827,788.56
April 6, 2026issueSO-260406-106MAIN 1 94.58-94.58191,797.09 March 9, 2026: 1 @ 94.58
April 3, 2026issueSO-260403-101MAIN 4 94.58-378.34201,891.68 March 9, 2026: 4 @ 94.58
April 3, 2026issueSO-260403-101EAST 6 94.58-567.50242,270.01 March 9, 2026: 6 @ 94.58
March 27, 2026issueSO-260327-667MAIN 3 94.58-283.75302,837.51 March 9, 2026: 3 @ 94.58
March 26, 2026issueSO-260326-901MAIN 3 94.58-283.75333,121.27 March 9, 2026: 3 @ 94.58
March 20, 2026issueSO-260320-392EAST 1 94.58-94.58363,405.02 March 9, 2026: 1 @ 94.58
March 18, 2026issueSO-260318-853EAST 2 96.25-192.50373,499.60 March 4, 2026: 1 @ 97.92; March 9, 2026: 1 @ 94.58
March 16, 2026issueSO-260316-942MAIN 2 97.92-195.84393,692.10 March 4, 2026: 2 @ 97.92
March 11, 2026issueSO-260311-369MAIN 4 97.92-391.67413,887.94 Feb. 3, 2026: 3 @ 97.92; March 4, 2026: 1 @ 97.92
March 9, 2026transferTRFMAIN → EAST 9 warehouse transfer, no cost effect
March 9, 2026receiptPO-001299MAIN 38 94.583,594.18454,279.61
March 4, 2026returnRMAMAIN 4 97.92391.677685.42
March 4, 2026issueSO-260304-911MAIN 1 97.92-97.923293.75 Feb. 3, 2026: 1 @ 97.92
Feb. 18, 2026issueSO-260218-108MAIN 8 97.92-783.344391.67 Feb. 3, 2026: 8 @ 97.92
Feb. 12, 2026issueSO-260212-770MAIN 4 97.92-391.67121,175.01 Feb. 3, 2026: 4 @ 97.92
Feb. 11, 2026issueSO-260211-396MAIN 2 97.92-195.84161,566.68 Feb. 3, 2026: 2 @ 97.92
Feb. 8, 2026issueSO-260208-585MAIN 5 97.92-489.59181,762.52 Feb. 3, 2026: 5 @ 97.92
Feb. 3, 2026receiptPO-001195MAIN 23 97.922,252.11232,252.11
Jan. 21, 2026issueSO-260121-549EAST 1 94.26-94.2600.00 Nov. 2, 2025: 1 @ 94.26
Jan. 19, 2026issueSO-260119-648EAST 2 94.26-188.51194.26 Nov. 2, 2025: 2 @ 94.26
Jan. 17, 2026issueSO-260117-283EAST 1 94.26-94.263282.77 Nov. 2, 2025: 1 @ 94.26
Jan. 17, 2026issueSO-260117-283MAIN 2 94.26-188.514377.02 Nov. 2, 2025: 2 @ 94.26
Jan. 13, 2026issueSO-260113-110MAIN 5 94.26-471.286565.53 Nov. 2, 2025: 5 @ 94.26
Dec. 10, 2025issueSO-251210-107MAIN 1 94.26-94.26111,036.81 Nov. 2, 2025: 1 @ 94.26
Dec. 5, 2025issueSO-251205-441MAIN 2 94.26-188.51121,131.06 Nov. 2, 2025: 2 @ 94.26
Dec. 1, 2025issueSO-251201-316MAIN 2 94.26-188.51141,319.57 Nov. 2, 2025: 2 @ 94.26
Nov. 27, 2025issueSO-251127-545MAIN 2 92.85-185.70161,508.08 Sept. 7, 2025: 1 @ 91.44; Nov. 2, 2025: 1 @ 94.26
Nov. 16, 2025issueSO-251116-248MAIN 1 91.44-91.44181,693.78 Sept. 7, 2025: 1 @ 91.44
Nov. 8, 2025issueSO-251108-414MAIN 2 91.44-182.88191,785.22 Sept. 7, 2025: 2 @ 91.44
Nov. 2, 2025transferTRFMAIN → EAST 4 warehouse transfer, no cost effect
Nov. 2, 2025receiptPO-000975MAIN 17 94.261,602.34211,968.10
Oct. 15, 2025issueSO-251015-219MAIN 5 95.04-475.184365.76 July 24, 2025: 5 @ 95.04
Oct. 8, 2025issueSO-251008-155MAIN 3 91.44-274.329840.94 July 7, 2025: 3 @ 91.44
Sept. 29, 2025issueSO-250929-269MAIN 4 91.44-365.76121,115.26 July 7, 2025: 4 @ 91.44
Sept. 28, 2025issueSO-250928-407MAIN 1 91.44-91.44161,481.03 July 7, 2025: 1 @ 91.44
Sept. 27, 2025issueSO-250927-794MAIN 1 91.44-91.44171,572.47 July 7, 2025: 1 @ 91.44
Sept. 26, 2025issueSO-250926-652MAIN 1 91.44-91.44181,663.91 July 7, 2025: 1 @ 91.44
Sept. 24, 2025issueSO-250924-864MAIN 1 91.44-91.44191,755.35 July 7, 2025: 1 @ 91.44
Sept. 7, 2025returnRMAMAIN 4 91.44365.76201,846.79
Sept. 4, 2025issueSO-250904-582MAIN 2 91.44-182.88161,481.03 July 7, 2025: 2 @ 91.44
Aug. 23, 2025issueSO-250823-618MAIN 9 91.44-822.97181,663.91 July 7, 2025: 9 @ 91.44
Aug. 7, 2025issueSO-250807-233MAIN 5 91.44-457.20272,486.87 July 7, 2025: 5 @ 91.44
Aug. 3, 2025issueSO-250803-348MAIN 9 91.44-822.97322,944.08 July 7, 2025: 9 @ 91.44
July 30, 2025issueSO-250730-491MAIN 41 91.97-3,770.64413,767.05 May 9, 2025: 6 @ 95.04; July 7, 2025: 35 @ 91.44
July 24, 2025returnRMAMAIN 5 95.04475.18827,537.69
July 10, 2025issueSO-250710-525MAIN 10 95.04-950.35777,062.51 May 9, 2025: 10 @ 95.04
July 7, 2025receiptPO-000690MAIN 71 91.446,492.30878,012.86
June 26, 2025issueSO-250626-190MAIN 6 95.04-570.21161,520.56 May 9, 2025: 6 @ 95.04
June 16, 2025issueSO-250616-721MAIN 12 95.04-1,140.42222,090.78 May 9, 2025: 12 @ 95.04
June 15, 2025issueSO-250615-227MAIN 8 95.04-760.28343,231.20 May 9, 2025: 8 @ 95.04
June 12, 2025issueSO-250612-628MAIN 25 95.04-2,375.88423,991.48 May 9, 2025: 25 @ 95.04
June 11, 2025issueSO-250611-778MAIN 7 95.04-665.25676,367.37 May 9, 2025: 7 @ 95.04
May 30, 2025issueSO-250530-416MAIN 17 95.04-1,615.60747,032.61 May 9, 2025: 17 @ 95.04
May 24, 2025issueSO-250524-996MAIN 1 95.04-95.04918,648.21 May 9, 2025: 1 @ 95.04
May 9, 2025receiptPO-000525MAIN 92 95.048,743.25928,743.25
April 28, 2025issueSO-250428-582MAIN 18 94.36-1,698.5400.00 March 17, 2025: 18 @ 94.36
April 20, 2025issueSO-250420-340MAIN 9 94.36-849.27181,698.54 March 17, 2025: 9 @ 94.36
April 16, 2025issueSO-250416-574MAIN 7 94.36-660.55272,547.82 March 17, 2025: 7 @ 94.36
April 12, 2025issueSO-250412-263MAIN 1 94.36-94.36343,208.36 March 17, 2025: 1 @ 94.36
April 11, 2025issueSO-250411-925MAIN 1 94.36-94.36353,302.73 March 17, 2025: 1 @ 94.36
April 3, 2025issueSO-250403-612MAIN 4 92.69-370.78363,397.09 Feb. 21, 2025: 2 @ 91.02; March 17, 2025: 2 @ 94.36
March 23, 2025issueSO-250323-799MAIN 1 91.02-91.02403,767.87 Feb. 21, 2025: 1 @ 91.02
March 17, 2025receiptPO-000347MAIN 38 94.363,585.82413,858.89
March 15, 2025issueSO-250315-361MAIN 9 91.02-819.223273.07 Feb. 21, 2025: 9 @ 91.02
March 11, 2025issueSO-250311-948MAIN 4 91.02-364.10121,092.30 Feb. 21, 2025: 4 @ 91.02
March 2, 2025issueSO-250302-911MAIN 4 91.02-364.10161,456.40 Feb. 21, 2025: 4 @ 91.02
Feb. 28, 2025issueSO-250228-202MAIN 2 91.02-182.05201,820.50 Feb. 21, 2025: 2 @ 91.02
Feb. 28, 2025issueSO-250228-202EAST 2 92.20-184.41222,002.55 Oct. 22, 2024: 1 @ 93.38; Feb. 21, 2025: 1 @ 91.02
Feb. 26, 2025issueSO-250226-457MAIN 1 93.38-93.38242,186.96 Oct. 1, 2024: 1 @ 93.38
Feb. 24, 2025issueSO-250224-641EAST 1 93.38-93.38252,280.34 Oct. 1, 2024: 1 @ 93.38
Feb. 21, 2025receiptPO-000288MAIN 23 91.022,093.57262,373.73
Feb. 15, 2025issueSO-250215-192EAST 4 93.38-373.543280.16 Oct. 1, 2024: 4 @ 93.38
Feb. 15, 2025issueSO-250215-192MAIN 1 93.38-93.387653.70 Oct. 1, 2024: 1 @ 93.38
Feb. 14, 2025issueSO-250214-530MAIN 3 93.38-280.168747.08 Oct. 1, 2024: 3 @ 93.38
Feb. 9, 2025issueSO-250209-262MAIN 1 93.38-93.38111,027.24 Oct. 1, 2024: 1 @ 93.38
Feb. 1, 2025issueSO-250201-804MAIN 1 93.38-93.38121,120.62 Oct. 1, 2024: 1 @ 93.38
Jan. 28, 2025issueSO-250128-996MAIN 6 93.38-560.31131,214.00 Oct. 1, 2024: 6 @ 93.38
Jan. 19, 2025issueSO-250119-733EAST 1 93.38-93.38191,774.32 Oct. 1, 2024: 1 @ 93.38
Jan. 17, 2025issueSO-250117-290MAIN 1 93.38-93.38201,867.70 Oct. 1, 2024: 1 @ 93.38
Jan. 15, 2025issueSO-250115-622MAIN 1 93.38-93.38211,961.08 Oct. 1, 2024: 1 @ 93.38
Jan. 2, 2025issueSO-250102-568MAIN 2 93.38-186.77222,054.47 Oct. 1, 2024: 2 @ 93.38
Dec. 25, 2024issueSO-241225-503EAST 1 93.38-93.38242,241.24 Oct. 1, 2024: 1 @ 93.38
Dec. 8, 2024issueSO-241208-184MAIN 4 93.38-373.54252,334.62 Oct. 1, 2024: 4 @ 93.38
Nov. 27, 2024issueSO-241127-985MAIN 2 93.38-186.77292,708.16 Oct. 1, 2024: 2 @ 93.38
Nov. 26, 2024issueSO-241126-811MAIN 1 93.38-93.38312,894.94 Oct. 1, 2024: 1 @ 93.38
Nov. 20, 2024issueSO-241120-534MAIN 2 93.38-186.77322,988.32 Oct. 1, 2024: 2 @ 93.38
Nov. 19, 2024issueSO-241119-937MAIN 1 93.38-93.38343,175.09 Oct. 1, 2024: 1 @ 93.38
Nov. 4, 2024issueSO-241104-361MAIN 1 93.38-93.38353,268.48 Oct. 1, 2024: 1 @ 93.38
Oct. 22, 2024returnRMAMAIN 1 93.3893.38363,361.86
Oct. 22, 2024issueSO-241022-991EAST 1 93.38-93.38353,268.48 Oct. 1, 2024: 1 @ 93.38
Oct. 19, 2024issueSO-241019-936MAIN 1 93.38-93.38363,361.86 Oct. 1, 2024: 1 @ 93.38
Oct. 16, 2024issueSO-241016-993EAST 1 93.38-93.38373,455.24 Oct. 1, 2024: 1 @ 93.38
Oct. 14, 2024issueSO-241014-321MAIN 6 93.38-560.31383,548.63 Oct. 1, 2024: 6 @ 93.38
Oct. 9, 2024issueSO-241009-989MAIN 1 93.38-93.38444,108.94 Oct. 1, 2024: 1 @ 93.38
Oct. 8, 2024issueSO-241008-999MAIN 1 93.38-93.38454,202.32 Oct. 1, 2024: 1 @ 93.38
Oct. 4, 2024issueSO-241004-628MAIN 1 93.38-93.38464,295.71 Oct. 1, 2024: 1 @ 93.38
Oct. 1, 2024transferTRFMAIN → EAST 11 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000003MAIN 47 93.384,389.10474,389.10