Items / FAN-0013
Ceiling Fan 1400mm Prime FAN-0013 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)5MAIN 5
Value (FIFO)555.35avg 111.07
ClassAY / FCV 0.76
Turnover22.3xlast issue 0 days ago
Days of cover6lead time 22d
Reorder suggested: 73 units (position at or below reorder point: order EOQ), stockout risk high.
Demand and forecast
actual forecast 90% prediction interval
No forecast run yet for this item. Run forecasts. Policy numbers use trailing 12-month demand.
Policy numbers explained
| Metric | Formula | Substituted | Result |
|---|---|---|---|
| Daily demand d | monthly mean / 30.4375 | 26.92 / 30.4375 | 0.884 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 20.49 / 5.517 | 3.714 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.980) | 2.054 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 2.054 * sqrt(21.5 * 3.714^2 + 0.884^2 * 7.4^2) | 37.8 |
| Reorder point | d * LT + safety stock | 0.884 * 21.5 + 37.8 | 56.9 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 56.9 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 323/yr, S = 45.00, h = 20%, price = 111.82 | 36.0 |
| Inventory position | on hand + on order | 5 + 0 | 5 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 111.82 | 36 | 36,899 | yes (chosen if cheapest) |
MOQ 13, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 22, 2026 | 5 / 80 | 111.07 | 555.35 |
Movement ledger 116 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 16, 2026 | issue | SO-261016-261 | MAIN | 1 | 111.07 | -111.07 | 5 | 555.35 | July 22, 2026: 1 @ 111.07 |
| Oct. 15, 2026 | issue | SO-261015-671 | MAIN | 1 | 111.07 | -111.07 | 6 | 666.42 | July 22, 2026: 1 @ 111.07 |
| Oct. 14, 2026 | issue | SO-261014-657 | MAIN | 2 | 111.07 | -222.14 | 7 | 777.49 | July 22, 2026: 2 @ 111.07 |
| Oct. 13, 2026 | issue | SO-261013-458 | MAIN | 1 | 111.07 | -111.07 | 9 | 999.64 | July 22, 2026: 1 @ 111.07 |
| Oct. 12, 2026 | issue | SO-261012-772 | MAIN | 11 | 111.07 | -1,221.78 | 10 | 1,110.71 | July 22, 2026: 11 @ 111.07 |
| Oct. 10, 2026 | issue | SO-261010-796 | MAIN | 2 | 111.07 | -222.14 | 21 | 2,332.48 | July 22, 2026: 2 @ 111.07 |
| Sept. 29, 2026 | issue | SO-260929-973 | MAIN | 3 | 111.07 | -333.21 | 23 | 2,554.63 | July 22, 2026: 3 @ 111.07 |
| Sept. 21, 2026 | issue | SO-260921-811 | MAIN | 2 | 111.07 | -222.14 | 26 | 2,887.84 | July 22, 2026: 2 @ 111.07 |
| Sept. 17, 2026 | issue | SO-260917-945 | MAIN | 2 | 111.07 | -222.14 | 28 | 3,109.98 | July 22, 2026: 2 @ 111.07 |
| Sept. 11, 2026 | issue | SO-260911-984 | MAIN | 3 | 111.07 | -333.21 | 30 | 3,332.12 | July 22, 2026: 3 @ 111.07 |
| Sept. 10, 2026 | issue | SO-260910-366 | MAIN | 1 | 111.07 | -111.07 | 33 | 3,665.33 | July 22, 2026: 1 @ 111.07 |
| Sept. 4, 2026 | issue | SO-260904-202 | MAIN | 7 | 111.07 | -777.49 | 34 | 3,776.40 | July 22, 2026: 7 @ 111.07 |
| Aug. 20, 2026 | issue | SO-260820-128 | MAIN | 13 | 111.07 | -1,443.92 | 41 | 4,553.90 | July 22, 2026: 13 @ 111.07 |
| Aug. 9, 2026 | issue | SO-260809-210 | MAIN | 16 | 111.07 | -1,777.13 | 54 | 5,997.82 | July 22, 2026: 16 @ 111.07 |
| Aug. 6, 2026 | issue | SO-260806-235 | MAIN | 2 | 111.07 | -222.14 | 70 | 7,774.95 | July 22, 2026: 2 @ 111.07 |
| Aug. 2, 2026 | issue | SO-260802-834 | MAIN | 3 | 111.07 | -333.21 | 72 | 7,997.09 | July 22, 2026: 3 @ 111.07 |
| July 25, 2026 | issue | SO-260725-853 | MAIN | 46 | 108.78 | -5,004.08 | 75 | 8,330.30 | May 19, 2026: 40 @ 108.51; June 25, 2026: 1 @ 108.51; July 22, 2026: 5 @ 111.07 |
| July 22, 2026 | receipt | PO-001661 | MAIN | 80 | 111.07 | 8,885.66 | 121 | 13,334.39 | |
| July 5, 2026 | issue | SO-260705-919 | MAIN | 6 | 108.51 | -651.03 | 41 | 4,448.73 | May 19, 2026: 6 @ 108.51 |
| June 30, 2026 | issue | SO-260630-622 | MAIN | 8 | 108.51 | -868.04 | 47 | 5,099.76 | May 19, 2026: 8 @ 108.51 |
| June 25, 2026 | return | RMA | MAIN | 1 | 108.51 | 108.51 | 55 | 5,967.81 | |
| June 25, 2026 | issue | SO-260625-644 | MAIN | 20 | 108.51 | -2,170.11 | 54 | 5,859.30 | May 19, 2026: 20 @ 108.51 |
| June 7, 2026 | issue | SO-260607-990 | MAIN | 23 | 108.51 | -2,495.63 | 74 | 8,029.41 | May 19, 2026: 23 @ 108.51 |
| June 5, 2026 | issue | SO-260605-230 | MAIN | 1 | 108.51 | -108.51 | 97 | 10,525.04 | May 19, 2026: 1 @ 108.51 |
| May 25, 2026 | issue | SO-260525-514 | MAIN | 23 | 107.73 | -2,477.75 | 98 | 10,633.55 | April 8, 2026: 18 @ 107.51; May 19, 2026: 5 @ 108.51 |
| May 25, 2026 | issue | SO-260525-514 | EAST | 2 | 107.51 | -215.03 | 121 | 13,111.30 | April 8, 2026: 2 @ 107.51 |
| May 19, 2026 | receipt | PO-001506 | MAIN | 103 | 108.51 | 11,176.08 | 123 | 13,326.33 | |
| May 8, 2026 | issue | SO-260508-629 | MAIN | 21 | 107.51 | -2,257.76 | 20 | 2,150.25 | April 8, 2026: 21 @ 107.51 |
| May 4, 2026 | issue | SO-260504-358 | MAIN | 14 | 107.51 | -1,505.18 | 41 | 4,408.02 | April 8, 2026: 14 @ 107.51 |
| May 1, 2026 | issue | SO-260501-957 | MAIN | 9 | 107.51 | -967.61 | 55 | 5,913.19 | April 8, 2026: 9 @ 107.51 |
| April 26, 2026 | issue | SO-260426-849 | MAIN | 8 | 107.71 | -861.64 | 64 | 6,880.81 | March 6, 2026: 2 @ 108.28; April 8, 2026: 6 @ 107.51 |
| April 24, 2026 | issue | SO-260424-205 | EAST | 22 | 108.28 | -2,382.23 | 72 | 7,742.45 | March 6, 2026: 22 @ 108.28 |
| April 21, 2026 | issue | SO-260421-242 | EAST | 1 | 108.28 | -108.28 | 94 | 10,124.68 | March 6, 2026: 1 @ 108.28 |
| April 8, 2026 | transfer | TRF | MAIN → EAST | 23 | warehouse transfer, no cost effect | ||||
| April 8, 2026 | receipt | PO-001392 | MAIN | 70 | 107.51 | 7,525.88 | 95 | 10,232.96 | |
| April 3, 2026 | issue | SO-260403-356 | EAST | 6 | 108.28 | -649.70 | 25 | 2,707.08 | March 6, 2026: 6 @ 108.28 |
| March 20, 2026 | issue | SO-260320-301 | MAIN | 7 | 108.28 | -757.98 | 31 | 3,356.78 | March 6, 2026: 7 @ 108.28 |
| March 10, 2026 | issue | SO-260310-226 | EAST | 4 | 108.28 | -433.13 | 38 | 4,114.77 | March 6, 2026: 4 @ 108.28 |
| March 6, 2026 | transfer | TRF | MAIN → EAST | 12 | warehouse transfer, no cost effect | ||||
| March 6, 2026 | receipt | PO-001290 | MAIN | 42 | 108.28 | 4,547.90 | 42 | 4,547.90 | |
| March 5, 2026 | issue | SO-260305-596 | MAIN | 9 | 109.25 | -983.23 | 0 | 0.00 | Jan. 22, 2026: 9 @ 109.25 |
| Feb. 22, 2026 | issue | SO-260222-592 | MAIN | 9 | 109.25 | -983.23 | 9 | 983.23 | Jan. 22, 2026: 9 @ 109.25 |
| Feb. 13, 2026 | issue | SO-260213-573 | MAIN | 3 | 109.25 | -327.74 | 18 | 1,966.45 | Jan. 22, 2026: 3 @ 109.25 |
| Jan. 26, 2026 | issue | SO-260126-787 | MAIN | 1 | 105.89 | -105.89 | 21 | 2,294.19 | Oct. 27, 2025: 1 @ 105.89 |
| Jan. 25, 2026 | issue | SO-260125-741 | MAIN | 4 | 105.89 | -423.54 | 22 | 2,400.08 | July 23, 2025: 3 @ 105.89; Oct. 27, 2025: 1 @ 105.89 |
| Jan. 22, 2026 | receipt | PO-001170 | MAIN | 21 | 109.25 | 2,294.19 | 26 | 2,823.62 | |
| Jan. 17, 2026 | issue | SO-260117-242 | MAIN | 1 | 105.89 | -105.89 | 5 | 529.43 | July 23, 2025: 1 @ 105.89 |
| Jan. 10, 2026 | issue | SO-260110-577 | MAIN | 4 | 105.89 | -423.54 | 6 | 635.31 | July 23, 2025: 4 @ 105.89 |
| Jan. 5, 2026 | issue | SO-260105-559 | MAIN | 1 | 105.89 | -105.89 | 10 | 1,058.85 | July 23, 2025: 1 @ 105.89 |
| Jan. 4, 2026 | issue | SO-260104-241 | MAIN | 2 | 105.89 | -211.77 | 11 | 1,164.74 | July 23, 2025: 2 @ 105.89 |
| Dec. 30, 2025 | issue | SO-251230-816 | MAIN | 1 | 105.89 | -105.89 | 13 | 1,376.51 | July 23, 2025: 1 @ 105.89 |
| Dec. 24, 2025 | issue | SO-251224-108 | MAIN | 2 | 105.89 | -211.77 | 14 | 1,482.40 | July 23, 2025: 2 @ 105.89 |
| Dec. 20, 2025 | issue | SO-251220-653 | MAIN | 1 | 105.89 | -105.89 | 16 | 1,694.17 | July 23, 2025: 1 @ 105.89 |
| Dec. 7, 2025 | issue | SO-251207-340 | MAIN | 1 | 105.89 | -105.89 | 17 | 1,800.05 | July 23, 2025: 1 @ 105.89 |
| Nov. 6, 2025 | issue | SO-251106-992 | MAIN | 1 | 105.89 | -105.89 | 18 | 1,905.94 | July 23, 2025: 1 @ 105.89 |
| Nov. 2, 2025 | issue | SO-251102-181 | MAIN | 3 | 105.89 | -317.66 | 19 | 2,011.82 | July 23, 2025: 3 @ 105.89 |
| Oct. 27, 2025 | return | RMA | MAIN | 2 | 105.89 | 211.77 | 22 | 2,329.48 | |
| Oct. 24, 2025 | issue | SO-251024-979 | MAIN | 1 | 105.89 | -105.89 | 20 | 2,117.71 | July 23, 2025: 1 @ 105.89 |
| Oct. 22, 2025 | issue | SO-251022-250 | MAIN | 5 | 105.89 | -529.43 | 21 | 2,223.59 | July 23, 2025: 5 @ 105.89 |
| Oct. 3, 2025 | issue | SO-251003-130 | MAIN | 4 | 105.89 | -423.54 | 26 | 2,753.02 | July 23, 2025: 4 @ 105.89 |
| Sept. 30, 2025 | issue | SO-250930-273 | MAIN | 2 | 105.89 | -211.77 | 30 | 3,176.56 | July 23, 2025: 2 @ 105.89 |
| Sept. 23, 2025 | issue | SO-250923-890 | MAIN | 9 | 105.89 | -952.97 | 32 | 3,388.33 | July 23, 2025: 9 @ 105.89 |
| Sept. 15, 2025 | issue | SO-250915-476 | MAIN | 2 | 105.89 | -211.77 | 41 | 4,341.30 | July 23, 2025: 2 @ 105.89 |
| Aug. 31, 2025 | issue | SO-250831-846 | MAIN | 4 | 105.89 | -423.54 | 43 | 4,553.07 | July 23, 2025: 4 @ 105.89 |
| Aug. 20, 2025 | issue | SO-250820-945 | MAIN | 12 | 105.89 | -1,270.62 | 47 | 4,976.61 | July 23, 2025: 12 @ 105.89 |
| Aug. 4, 2025 | issue | SO-250804-942 | MAIN | 8 | 105.89 | -847.08 | 59 | 6,247.24 | July 23, 2025: 8 @ 105.89 |
| July 28, 2025 | issue | SO-250728-365 | MAIN | 5 | 105.89 | -529.43 | 67 | 7,094.32 | July 23, 2025: 5 @ 105.89 |
| July 27, 2025 | issue | SO-250727-448 | MAIN | 3 | 105.89 | -317.66 | 72 | 7,623.75 | July 23, 2025: 3 @ 105.89 |
| July 24, 2025 | issue | SO-250724-578 | MAIN | 5 | 105.89 | -529.43 | 75 | 7,941.40 | July 23, 2025: 5 @ 105.89 |
| July 23, 2025 | receipt | PO-000728 | MAIN | 80 | 105.89 | 8,470.83 | 80 | 8,470.83 | |
| July 20, 2025 | issue | SO-250720-987 | MAIN | 5 | 106.13 | -530.67 | 0 | 0.00 | June 29, 2025: 5 @ 106.13 |
| July 17, 2025 | issue | SO-250717-119 | MAIN | 4 | 106.13 | -424.53 | 5 | 530.67 | June 29, 2025: 4 @ 106.13 |
| July 7, 2025 | issue | SO-250707-962 | MAIN | 19 | 106.13 | -2,016.54 | 9 | 955.20 | May 17, 2025: 4 @ 106.13; June 29, 2025: 15 @ 106.13 |
| July 2, 2025 | issue | SO-250702-833 | MAIN | 4 | 106.13 | -424.53 | 28 | 2,971.74 | May 17, 2025: 4 @ 106.13 |
| June 29, 2025 | return | RMA | MAIN | 24 | 106.13 | 2,547.21 | 32 | 3,396.28 | |
| June 21, 2025 | issue | SO-250621-940 | MAIN | 48 | 106.13 | -5,094.42 | 8 | 849.07 | May 17, 2025: 48 @ 106.13 |
| June 21, 2025 | issue | SO-250621-940 | EAST | 36 | 106.13 | -3,820.81 | 56 | 5,943.49 | May 17, 2025: 36 @ 106.13 |
| June 16, 2025 | adjustment | Cycle count | MAIN | -1 | 106.13 | -106.13 | 92 | 9,764.30 | May 17, 2025: 1 @ 106.13 |
| June 5, 2025 | issue | SO-250605-199 | MAIN | 2 | 106.13 | -212.27 | 93 | 9,870.43 | May 17, 2025: 2 @ 106.13 |
| May 28, 2025 | issue | SO-250528-698 | MAIN | 20 | 104.79 | -2,095.81 | 95 | 10,082.70 | April 22, 2025: 12 @ 103.90; May 17, 2025: 8 @ 106.13 |
| May 17, 2025 | transfer | TRF | MAIN → EAST | 36 | warehouse transfer, no cost effect | ||||
| May 17, 2025 | receipt | PO-000543 | MAIN | 103 | 106.13 | 10,931.77 | 115 | 12,178.51 | |
| May 6, 2025 | issue | SO-250506-527 | MAIN | 39 | 103.90 | -4,051.92 | 12 | 1,246.74 | April 22, 2025: 39 @ 103.90 |
| April 28, 2025 | issue | SO-250428-915 | MAIN | 27 | 103.48 | -2,793.98 | 51 | 5,298.66 | Feb. 19, 2025: 8 @ 102.50; April 22, 2025: 19 @ 103.90 |
| April 26, 2025 | issue | SO-250426-968 | MAIN | 6 | 102.50 | -614.98 | 78 | 8,092.64 | Feb. 19, 2025: 6 @ 102.50 |
| April 22, 2025 | receipt | PO-000471 | MAIN | 70 | 103.90 | 7,272.67 | 84 | 8,707.62 | |
| March 30, 2025 | issue | SO-250330-817 | MAIN | 4 | 102.50 | -409.99 | 14 | 1,434.95 | Feb. 19, 2025: 4 @ 102.50 |
| March 27, 2025 | issue | SO-250327-519 | MAIN | 8 | 102.50 | -819.97 | 18 | 1,844.93 | Feb. 19, 2025: 8 @ 102.50 |
| March 26, 2025 | issue | SO-250326-913 | MAIN | 1 | 102.50 | -102.50 | 26 | 2,664.90 | Feb. 19, 2025: 1 @ 102.50 |
| March 21, 2025 | issue | SO-250321-758 | MAIN | 6 | 102.50 | -614.98 | 27 | 2,767.40 | Feb. 19, 2025: 6 @ 102.50 |
| March 18, 2025 | issue | SO-250318-929 | MAIN | 1 | 102.50 | -102.50 | 33 | 3,382.38 | Feb. 19, 2025: 1 @ 102.50 |
| March 13, 2025 | issue | SO-250313-149 | MAIN | 5 | 102.50 | -512.48 | 34 | 3,484.87 | Feb. 19, 2025: 5 @ 102.50 |
| March 2, 2025 | issue | SO-250302-706 | MAIN | 6 | 104.36 | -626.18 | 39 | 3,997.36 | Oct. 1, 2024: 3 @ 106.23; Feb. 19, 2025: 3 @ 102.50 |
| Feb. 26, 2025 | issue | SO-250226-792 | MAIN | 1 | 106.23 | -106.23 | 45 | 4,623.53 | Oct. 1, 2024: 1 @ 106.23 |
| Feb. 22, 2025 | issue | SO-250222-505 | MAIN | 3 | 106.23 | -318.69 | 46 | 4,729.76 | Oct. 1, 2024: 3 @ 106.23 |
| Feb. 20, 2025 | issue | SO-250220-709 | MAIN | 2 | 106.23 | -212.46 | 49 | 5,048.45 | Oct. 1, 2024: 2 @ 106.23 |
| Feb. 19, 2025 | receipt | PO-000278 | MAIN | 42 | 102.50 | 4,304.84 | 51 | 5,260.91 | |
| Feb. 17, 2025 | issue | SO-250217-905 | MAIN | 6 | 106.23 | -637.37 | 9 | 956.06 | Oct. 1, 2024: 6 @ 106.23 |
| Feb. 15, 2025 | issue | SO-250215-665 | MAIN | 1 | 106.23 | -106.23 | 15 | 1,593.44 | Oct. 1, 2024: 1 @ 106.23 |
| Jan. 17, 2025 | issue | SO-250117-511 | MAIN | 1 | 106.23 | -106.23 | 16 | 1,699.66 | Oct. 1, 2024: 1 @ 106.23 |
| Jan. 8, 2025 | issue | SO-250108-327 | MAIN | 7 | 106.23 | -743.60 | 17 | 1,805.89 | Oct. 1, 2024: 7 @ 106.23 |
| Jan. 5, 2025 | issue | SO-250105-210 | MAIN | 2 | 106.23 | -212.46 | 24 | 2,549.50 | Oct. 1, 2024: 2 @ 106.23 |
| Dec. 30, 2024 | issue | SO-241230-896 | MAIN | 1 | 106.23 | -106.23 | 26 | 2,761.95 | Oct. 1, 2024: 1 @ 106.23 |
| Dec. 24, 2024 | issue | SO-241224-456 | MAIN | 1 | 106.23 | -106.23 | 27 | 2,868.18 | Oct. 1, 2024: 1 @ 106.23 |
| Dec. 17, 2024 | issue | SO-241217-421 | MAIN | 1 | 106.23 | -106.23 | 28 | 2,974.41 | Oct. 1, 2024: 1 @ 106.23 |
| Dec. 16, 2024 | issue | SO-241216-815 | MAIN | 2 | 106.23 | -212.46 | 29 | 3,080.64 | Oct. 1, 2024: 2 @ 106.23 |
| Nov. 19, 2024 | issue | SO-241119-936 | MAIN | 2 | 106.23 | -212.46 | 31 | 3,293.10 | Oct. 1, 2024: 2 @ 106.23 |
| Nov. 15, 2024 | issue | SO-241115-827 | MAIN | 4 | 106.23 | -424.92 | 33 | 3,505.56 | Oct. 1, 2024: 4 @ 106.23 |
| Nov. 6, 2024 | issue | SO-241106-980 | MAIN | 2 | 106.23 | -212.46 | 37 | 3,930.47 | Oct. 1, 2024: 2 @ 106.23 |
| Nov. 1, 2024 | issue | SO-241101-895 | MAIN | 1 | 106.23 | -106.23 | 39 | 4,142.93 | Oct. 1, 2024: 1 @ 106.23 |
| Oct. 28, 2024 | issue | SO-241028-176 | MAIN | 1 | 106.23 | -106.23 | 40 | 4,249.16 | Oct. 1, 2024: 1 @ 106.23 |
| Oct. 19, 2024 | issue | SO-241019-669 | MAIN | 4 | 106.23 | -424.92 | 41 | 4,355.39 | Oct. 1, 2024: 4 @ 106.23 |
| Oct. 11, 2024 | issue | SO-241011-447 | MAIN | 1 | 106.23 | -106.23 | 45 | 4,780.30 | Oct. 1, 2024: 1 @ 106.23 |
| Oct. 9, 2024 | issue | SO-241009-380 | MAIN | 4 | 106.23 | -424.92 | 46 | 4,886.53 | Oct. 1, 2024: 4 @ 106.23 |
| Oct. 1, 2024 | issue | SO-241001-662 | MAIN | 2 | 106.23 | -212.46 | 50 | 5,311.45 | Oct. 1, 2024: 2 @ 106.23 |
| Oct. 1, 2024 | receipt | PO-000003 | MAIN | 52 | 106.23 | 5,523.91 | 52 | 5,523.91 | |