stocksense

Items / FAN-0009

Decorative Ceiling Fan Flex FAN-0009 · Ceiling Fans · CoolBreeze Appliances

On hand (EA)34MAIN 34
Value (FIFO)8,447.11avg 248.44
ClassAY / FCV 0.71
Turnover13.5xlast issue 6 days ago
Days of cover49lead time 22d

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

Demand and forecast

Monthly demand and forecast for FAN-00090.016.232.548.764.9Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 10.0Nov 24: 4.0Dec 24: 7.0Jan 25: 15.0Feb 25: 10.0Mar 25: 13.0Apr 25: 26.0May 25: 57.0Jun 25: 59.0Jul 25: 37.0Aug 25: 23.0Sep 25: 16.0Oct 25: 8.0Nov 25: 7.0Dec 25: 6.0Jan 26: 11.0Feb 26: 12.0Mar 26: 20.0Apr 26: 40.0May 26: 40.0Jun 26: 56.0Jul 26: 21.0Aug 26: 18.0Sep 26: 16.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.25 / 30.43750.698
Daily demand sdmonthly sd / sqrt(30.4375)15.14 / 5.5172.745
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.745^2 + 0.698^2 * 7.4^2)28.2
Reorder pointd * LT + safety stock0.698 * 21.5 + 28.243.2
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days43.2
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 255/yr, S = 45.00, h = 20%, price = 237.1144.0
Inventory positionon hand + on order34 + 034

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

From qtyUnit costOrder qtyAnnual costFeasible
0257.732166,763yes
22247.422264,115yes
44237.114461,726yes (chosen if cheapest)

MOQ 11, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
June 10, 202634 / 90248.448,447.11

Movement ledger 128 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 10, 2026issueSO-261010-539MAIN 3 248.44-745.33348,447.11 June 10, 2026: 3 @ 248.44
Oct. 7, 2026issueSO-261007-689MAIN 5 248.44-1,242.22379,192.44 June 10, 2026: 5 @ 248.44
Oct. 6, 2026issueSO-261006-575MAIN 1 248.44-248.444210,434.66 June 10, 2026: 1 @ 248.44
Oct. 5, 2026issueSO-261005-745MAIN 1 248.44-248.444310,683.10 June 10, 2026: 1 @ 248.44
Sept. 30, 2026issueSO-260930-915MAIN 1 248.44-248.444410,931.55 June 10, 2026: 1 @ 248.44
Sept. 29, 2026issueSO-260929-818MAIN 6 248.44-1,490.674511,179.99 June 10, 2026: 6 @ 248.44
Sept. 22, 2026issueSO-260922-642MAIN 4 248.44-993.785112,670.66 June 10, 2026: 4 @ 248.44
Sept. 13, 2026issueSO-260913-791MAIN 1 248.44-248.445513,664.44 June 10, 2026: 1 @ 248.44
Sept. 10, 2026issueSO-260910-281MAIN 1 248.44-248.445613,912.88 June 10, 2026: 1 @ 248.44
Sept. 8, 2026issueSO-260908-146MAIN 2 248.44-496.895714,161.33 June 10, 2026: 2 @ 248.44
Sept. 2, 2026issueSO-260902-388MAIN 1 248.44-248.445914,658.21 June 10, 2026: 1 @ 248.44
Aug. 26, 2026issueSO-260826-830MAIN 10 248.44-2,484.446014,906.66 June 10, 2026: 10 @ 248.44
Aug. 15, 2026issueSO-260815-247MAIN 5 248.44-1,242.227017,391.10 June 10, 2026: 5 @ 248.44
Aug. 1, 2026issueSO-260801-119MAIN 3 248.44-745.337518,633.32 June 10, 2026: 3 @ 248.44
July 29, 2026issueSO-260729-605MAIN 2 248.44-496.897819,378.66 June 10, 2026: 2 @ 248.44
July 21, 2026issueSO-260721-219MAIN 7 248.44-1,739.118019,875.54 June 10, 2026: 7 @ 248.44
July 4, 2026issueSO-260704-642MAIN 12 253.04-3,036.468721,614.65 May 14, 2026: 9 @ 254.57; June 10, 2026: 3 @ 248.44
June 23, 2026issueSO-260623-310MAIN 11 254.57-2,800.279924,651.12 May 14, 2026: 11 @ 254.57
June 21, 2026issueSO-260621-426MAIN 23 254.57-5,855.1111027,451.39 May 14, 2026: 23 @ 254.57
June 11, 2026issueSO-260611-937MAIN 1 254.57-254.5713333,306.51 May 14, 2026: 1 @ 254.57
June 10, 2026receiptPO-001567MAIN 90 248.4422,359.9913433,561.08
June 4, 2026issueSO-260604-979MAIN 1 254.57-254.574411,201.09 May 14, 2026: 1 @ 254.57
June 2, 2026issueSO-260602-966MAIN 20 254.57-5,091.404511,455.66 May 14, 2026: 20 @ 254.57
May 22, 2026issueSO-260522-502MAIN 3 254.57-763.716516,547.06 May 14, 2026: 3 @ 254.57
May 17, 2026issueSO-260517-258MAIN 37 256.49-9,490.086817,310.77 April 4, 2026: 19 @ 258.31; May 14, 2026: 18 @ 254.57
May 14, 2026receiptPO-001492MAIN 86 254.5721,893.0410526,800.86
April 27, 2026issueSO-260427-488MAIN 5 258.31-1,291.53194,907.82 April 4, 2026: 5 @ 258.31
April 27, 2026issueSO-260427-488EAST 3 258.31-774.92246,199.35 April 4, 2026: 3 @ 258.31
April 26, 2026issueSO-260426-778MAIN 8 258.31-2,066.45276,974.27 April 4, 2026: 8 @ 258.31
April 24, 2026issueSO-260424-486EAST 12 258.31-3,099.67359,040.72 April 4, 2026: 12 @ 258.31
April 9, 2026issueSO-260409-925MAIN 12 258.31-3,099.674712,140.39 April 4, 2026: 12 @ 258.31
April 4, 2026transferTRFMAIN → EAST 15 warehouse transfer, no cost effect
April 4, 2026receiptPO-001383MAIN 59 258.3115,240.075915,240.07
March 14, 2026issueSO-260314-540MAIN 7 246.73-1,727.1200.00 Feb. 13, 2026: 7 @ 246.73
March 12, 2026issueSO-260312-165MAIN 9 246.73-2,220.5871,727.12 Feb. 13, 2026: 9 @ 246.73
March 12, 2026issueSO-260312-165EAST 4 246.73-986.92163,947.69 Feb. 13, 2026: 4 @ 246.73
Feb. 27, 2026issueSO-260227-468EAST 3 249.38-748.15204,934.62 Dec. 30, 2025: 1 @ 254.69; Feb. 13, 2026: 2 @ 246.73
Feb. 22, 2026issueSO-260222-307MAIN 6 254.69-1,528.15235,682.77 Dec. 30, 2025: 6 @ 254.69
Feb. 13, 2026transferTRFMAIN → EAST 7 warehouse transfer, no cost effect
Feb. 13, 2026receiptPO-001225MAIN 22 246.735,428.08297,210.93
Feb. 6, 2026issueSO-260206-144MAIN 1 254.69-254.6971,782.85 Dec. 30, 2025: 1 @ 254.69
Feb. 2, 2026issueSO-260202-677MAIN 2 254.69-509.3882,037.54 Dec. 30, 2025: 2 @ 254.69
Jan. 23, 2026issueSO-260123-787MAIN 1 254.69-254.69102,546.92 Dec. 30, 2025: 1 @ 254.69
Jan. 15, 2026issueSO-260115-885MAIN 1 254.69-254.69112,801.62 Dec. 30, 2025: 1 @ 254.69
Jan. 10, 2026issueSO-260110-630MAIN 2 254.69-509.38123,056.31 Dec. 30, 2025: 2 @ 254.69
Jan. 9, 2026issueSO-260109-891MAIN 6 253.56-1,521.37143,565.69 Nov. 24, 2025: 2 @ 251.30; Dec. 30, 2025: 4 @ 254.69
Jan. 3, 2026issueSO-260103-657MAIN 1 251.30-251.30205,087.06 Nov. 24, 2025: 1 @ 251.30
Dec. 30, 2025receiptPO-001105MAIN 18 254.694,584.46215,338.36
Dec. 23, 2025issueSO-251223-344MAIN 1 251.30-251.303753.89 Nov. 24, 2025: 1 @ 251.30
Dec. 13, 2025issueSO-251213-471MAIN 1 251.30-251.3041,005.19 Nov. 24, 2025: 1 @ 251.30
Dec. 10, 2025issueSO-251210-321MAIN 2 251.30-502.6051,256.49 Nov. 24, 2025: 2 @ 251.30
Dec. 5, 2025issueSO-251205-187MAIN 1 251.30-251.3071,759.09 Nov. 24, 2025: 1 @ 251.30
Dec. 2, 2025issueSO-251202-396MAIN 1 251.30-251.3082,010.38 Nov. 24, 2025: 1 @ 251.30
Nov. 29, 2025issueSO-251129-924MAIN 2 251.30-502.6092,261.68 Nov. 24, 2025: 2 @ 251.30
Nov. 24, 2025receiptPO-001018MAIN 11 251.302,764.28112,764.28
Nov. 21, 2025issueSO-251121-386MAIN 1 243.20-243.2000.00 Aug. 3, 2025: 1 @ 243.20
Nov. 15, 2025issueSO-251115-480MAIN 1 243.20-243.201243.20 Aug. 3, 2025: 1 @ 243.20
Nov. 12, 2025issueSO-251112-303MAIN 1 243.20-243.202486.40 Aug. 3, 2025: 1 @ 243.20
Nov. 3, 2025issueSO-251103-492MAIN 2 243.20-486.403729.59 Aug. 3, 2025: 2 @ 243.20
Oct. 15, 2025issueSO-251015-169MAIN 5 243.20-1,215.9951,215.99 Aug. 3, 2025: 5 @ 243.20
Oct. 3, 2025issueSO-251003-673MAIN 3 243.20-729.59102,431.98 Aug. 3, 2025: 3 @ 243.20
Sept. 18, 2025issueSO-250918-766MAIN 3 243.20-729.59133,161.58 Aug. 3, 2025: 3 @ 243.20
Sept. 12, 2025issueSO-250912-364MAIN 9 243.20-2,188.78163,891.17 Aug. 3, 2025: 9 @ 243.20
Sept. 11, 2025issueSO-250911-246MAIN 2 243.20-486.40256,079.95 Aug. 3, 2025: 2 @ 243.20
Sept. 9, 2025issueSO-250909-529MAIN 1 243.20-243.20276,566.35 Aug. 3, 2025: 1 @ 243.20
Sept. 4, 2025issueSO-250904-244MAIN 1 243.20-243.20286,809.55 Aug. 3, 2025: 1 @ 243.20
Aug. 24, 2025issueSO-250824-255MAIN 12 243.54-2,922.53297,052.74 June 9, 2025: 2 @ 245.28; Aug. 3, 2025: 10 @ 243.20
Aug. 9, 2025issueSO-250809-632MAIN 7 245.28-1,716.93419,975.28 June 9, 2025: 7 @ 245.28
Aug. 3, 2025issueSO-250803-282MAIN 4 245.28-981.104811,692.21 June 9, 2025: 4 @ 245.28
Aug. 3, 2025receiptPO-000754MAIN 39 243.209,484.735212,673.31
July 31, 2025issueSO-250731-243MAIN 5 245.28-1,226.38133,188.58 June 9, 2025: 5 @ 245.28
July 27, 2025issueSO-250727-915MAIN 2 245.28-490.55184,414.96 June 9, 2025: 2 @ 245.28
July 22, 2025issueSO-250722-868MAIN 5 245.28-1,226.38204,905.51 June 9, 2025: 5 @ 245.28
July 17, 2025issueSO-250717-224MAIN 12 245.28-2,943.31256,131.89 June 9, 2025: 12 @ 245.28
July 14, 2025issueSO-250714-938MAIN 1 245.28-245.28379,075.19 June 9, 2025: 1 @ 245.28
July 13, 2025issueSO-250713-653MAIN 2 245.28-490.55389,320.47 June 9, 2025: 2 @ 245.28
July 1, 2025issueSO-250701-392MAIN 10 245.28-2,452.76409,811.02 June 9, 2025: 10 @ 245.28
June 28, 2025issueSO-250628-375MAIN 23 245.28-5,641.345012,263.78 June 9, 2025: 23 @ 245.28
June 23, 2025issueSO-250623-627MAIN 5 245.28-1,226.387317,905.11 June 9, 2025: 5 @ 245.28
June 18, 2025issueSO-250618-312MAIN 1 245.28-245.287819,131.49 June 9, 2025: 1 @ 245.28
June 11, 2025issueSO-250611-880MAIN 3 245.28-735.837919,376.76 June 9, 2025: 3 @ 245.28
June 9, 2025issueSO-250609-519MAIN 9 244.66-2,201.918220,112.59 May 2, 2025: 1 @ 239.71; June 9, 2025: 8 @ 245.28
June 9, 2025receiptPO-000621MAIN 90 245.2822,074.809122,314.50
June 4, 2025issueSO-250604-178MAIN 16 239.71-3,835.351239.71 May 2, 2025: 16 @ 239.71
June 2, 2025issueSO-250602-639MAIN 2 239.71-479.42174,075.06 May 2, 2025: 2 @ 239.71
May 26, 2025issueSO-250526-550MAIN 27 239.71-6,472.15194,554.48 May 2, 2025: 27 @ 239.71
May 20, 2025issueSO-250520-359MAIN 7 239.71-1,677.974611,026.63 May 2, 2025: 7 @ 239.71
May 12, 2025issueSO-250512-484MAIN 7 239.84-1,678.865312,704.59 March 20, 2025: 1 @ 240.60; May 2, 2025: 6 @ 239.71
May 4, 2025issueSO-250504-128MAIN 1 240.60-240.606014,383.45 March 20, 2025: 1 @ 240.60
May 2, 2025issueSO-250502-509MAIN 8 240.60-1,924.806114,624.05 March 20, 2025: 8 @ 240.60
May 2, 2025receiptPO-000505MAIN 59 239.7114,142.856916,548.85
May 1, 2025issueSO-250501-799MAIN 7 240.60-1,684.20102,406.00 March 20, 2025: 7 @ 240.60
April 28, 2025issueSO-250428-200MAIN 1 240.60-240.60174,090.20 March 20, 2025: 1 @ 240.60
April 27, 2025issueSO-250427-677MAIN 8 240.60-1,924.80184,330.80 March 20, 2025: 8 @ 240.60
April 19, 2025issueSO-250419-761MAIN 3 240.60-721.80266,255.60 March 20, 2025: 3 @ 240.60
April 2, 2025issueSO-250402-232MAIN 7 240.60-1,684.20296,977.40 March 20, 2025: 7 @ 240.60
April 1, 2025issueSO-250401-486MAIN 3 236.09-708.26368,661.60 Feb. 19, 2025: 2 @ 236.09; March 9, 2025: 1 @ 236.09
April 1, 2025issueSO-250401-486EAST 4 236.09-944.34399,369.86 Feb. 19, 2025: 4 @ 236.09
March 30, 2025issueSO-250330-374MAIN 1 236.09-236.094310,314.20 Feb. 19, 2025: 1 @ 236.09
March 20, 2025issueSO-250320-755MAIN 2 236.09-472.174410,550.29 Feb. 19, 2025: 2 @ 236.09
March 20, 2025receiptPO-000358MAIN 36 240.608,661.604611,022.46
March 9, 2025returnRMAMAIN 1 236.09236.09102,360.85
March 9, 2025issueSO-250309-985MAIN 9 236.09-2,124.7792,124.77 Feb. 19, 2025: 9 @ 236.09
March 1, 2025issueSO-250301-519MAIN 2 236.09-472.17184,249.53 Feb. 19, 2025: 2 @ 236.09
Feb. 24, 2025issueSO-250224-311EAST 2 236.09-472.17204,721.70 Feb. 19, 2025: 2 @ 236.09
Feb. 19, 2025transferTRFMAIN → EAST 6 warehouse transfer, no cost effect
Feb. 19, 2025receiptPO-000277MAIN 22 236.095,193.87225,193.87
Feb. 15, 2025issueSO-250215-614MAIN 3 244.84-734.5300.00 Oct. 1, 2024: 3 @ 244.84
Feb. 12, 2025issueSO-250212-593MAIN 1 244.84-244.843734.53 Oct. 1, 2024: 1 @ 244.84
Feb. 7, 2025issueSO-250207-843EAST 2 244.84-489.694979.37 Oct. 1, 2024: 2 @ 244.84
Feb. 1, 2025issueSO-250201-942EAST 2 244.84-489.6961,469.06 Oct. 1, 2024: 2 @ 244.84
Jan. 29, 2025issueSO-250129-108MAIN 1 244.84-244.8481,958.75 Oct. 1, 2024: 1 @ 244.84
Jan. 21, 2025issueSO-250121-126MAIN 2 244.84-489.6992,203.59 Oct. 1, 2024: 2 @ 244.84
Jan. 18, 2025issueSO-250118-181MAIN 7 244.84-1,713.90112,693.28 Oct. 1, 2024: 7 @ 244.84
Jan. 14, 2025issueSO-250114-642EAST 2 244.84-489.69184,407.18 Oct. 1, 2024: 2 @ 244.84
Jan. 12, 2025issueSO-250112-871MAIN 3 244.84-734.53204,896.87 Oct. 1, 2024: 3 @ 244.84
Dec. 29, 2024issueSO-241229-298MAIN 2 244.84-489.69235,631.40 Oct. 1, 2024: 2 @ 244.84
Dec. 27, 2024issueSO-241227-301MAIN 1 244.84-244.84256,121.09 Oct. 1, 2024: 1 @ 244.84
Dec. 20, 2024issueSO-241220-814MAIN 1 244.84-244.84266,365.93 Oct. 1, 2024: 1 @ 244.84
Dec. 7, 2024issueSO-241207-123MAIN 3 244.84-734.53276,610.77 Oct. 1, 2024: 3 @ 244.84
Nov. 13, 2024issueSO-241113-241EAST 4 244.84-979.37307,345.30 Oct. 1, 2024: 4 @ 244.84
Oct. 26, 2024issueSO-241026-644MAIN 2 244.84-489.69348,324.68 Oct. 1, 2024: 2 @ 244.84
Oct. 22, 2024issueSO-241022-801MAIN 1 244.84-244.84368,814.37 Oct. 1, 2024: 1 @ 244.84
Oct. 17, 2024issueSO-241017-301MAIN 1 244.84-244.84379,059.21 Oct. 1, 2024: 1 @ 244.84
Oct. 15, 2024issueSO-241015-689MAIN 5 244.84-1,224.22389,304.05 Oct. 1, 2024: 5 @ 244.84
Oct. 14, 2024issueSO-241014-351EAST 1 244.84-244.844310,528.27 Oct. 1, 2024: 1 @ 244.84
Oct. 1, 2024transferTRFMAIN → EAST 11 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000003MAIN 44 244.8410,773.114410,773.11