Items / FAN-0025
Table Fan 300mm Elite FAN-0025 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)2MAIN 2
Value (FIFO)180.95avg 90.47
ClassBY / FCV 0.75
Turnover25.9xlast issue 2 days ago
Days of cover3lead time 22d
Reorder suggested: 76 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 | 24.00 / 30.4375 | 0.789 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 17.94 / 5.517 | 3.251 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.950) | 1.645 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.645 * sqrt(21.5 * 3.251^2 + 0.789^2 * 7.4^2) | 26.6 |
| Reorder point | d * LT + safety stock | 0.789 * 21.5 + 26.6 | 43.6 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 43.6 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 288/yr, S = 45.00, h = 20%, price = 90.37 | 37.9 |
| Inventory position | on hand + on order | 2 + 0 | 2 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 90.37 | 38 | 26,693 | yes (chosen if cheapest) |
MOQ 13, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 8, 2026 | 1 / 79 | 90.47 | 90.47 | |
| Oct. 16, 2026 | 1 / 1 | 90.47 | 90.47 |
Movement ledger 125 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 16, 2026 | return | RMA | MAIN | 1 | 90.47 | 90.47 | 2 | 180.95 | |
| Oct. 14, 2026 | issue | SO-261014-782 | MAIN | 2 | 90.47 | -180.95 | 1 | 90.47 | July 8, 2026: 2 @ 90.47 |
| Oct. 12, 2026 | issue | SO-261012-355 | MAIN | 2 | 90.47 | -180.95 | 3 | 271.42 | July 8, 2026: 2 @ 90.47 |
| Oct. 6, 2026 | issue | SO-261006-331 | MAIN | 2 | 90.47 | -180.95 | 5 | 452.37 | July 8, 2026: 2 @ 90.47 |
| Oct. 2, 2026 | issue | SO-261002-314 | MAIN | 4 | 90.47 | -361.90 | 7 | 633.32 | July 8, 2026: 4 @ 90.47 |
| Sept. 29, 2026 | issue | SO-260929-546 | MAIN | 8 | 90.47 | -723.79 | 11 | 995.21 | July 8, 2026: 8 @ 90.47 |
| Sept. 28, 2026 | issue | SO-260928-892 | MAIN | 3 | 90.47 | -271.42 | 19 | 1,719.00 | July 8, 2026: 3 @ 90.47 |
| Sept. 21, 2026 | issue | SO-260921-720 | MAIN | 1 | 90.47 | -90.47 | 22 | 1,990.42 | July 8, 2026: 1 @ 90.47 |
| Sept. 15, 2026 | issue | SO-260915-310 | MAIN | 7 | 90.47 | -633.32 | 23 | 2,080.90 | July 8, 2026: 7 @ 90.47 |
| Sept. 11, 2026 | issue | SO-260911-883 | MAIN | 1 | 90.47 | -90.47 | 30 | 2,714.21 | July 8, 2026: 1 @ 90.47 |
| Sept. 9, 2026 | issue | SO-260909-156 | MAIN | 1 | 90.47 | -90.47 | 31 | 2,804.69 | July 8, 2026: 1 @ 90.47 |
| Sept. 7, 2026 | issue | SO-260907-327 | MAIN | 1 | 90.47 | -90.47 | 32 | 2,895.16 | July 8, 2026: 1 @ 90.47 |
| Aug. 19, 2026 | issue | SO-260819-968 | MAIN | 4 | 90.47 | -361.90 | 33 | 2,985.64 | July 8, 2026: 4 @ 90.47 |
| Aug. 17, 2026 | issue | SO-260817-283 | MAIN | 13 | 90.47 | -1,176.16 | 37 | 3,347.53 | July 8, 2026: 13 @ 90.47 |
| Aug. 13, 2026 | issue | SO-260813-106 | MAIN | 3 | 90.47 | -271.42 | 50 | 4,523.69 | July 8, 2026: 3 @ 90.47 |
| Aug. 10, 2026 | issue | SO-260810-404 | MAIN | 6 | 90.47 | -542.84 | 53 | 4,795.11 | July 8, 2026: 6 @ 90.47 |
| Aug. 9, 2026 | issue | SO-260809-597 | MAIN | 2 | 90.47 | -180.95 | 59 | 5,337.95 | July 8, 2026: 2 @ 90.47 |
| July 29, 2026 | issue | SO-260729-297 | MAIN | 18 | 90.47 | -1,628.53 | 61 | 5,518.90 | July 8, 2026: 18 @ 90.47 |
| July 8, 2026 | receipt | PO-001634 | MAIN | 79 | 90.47 | 7,147.43 | 79 | 7,147.43 | |
| July 2, 2026 | issue | SO-260702-459 | MAIN | 3 | 88.91 | -266.73 | 0 | 0.00 | April 30, 2026: 3 @ 88.91 |
| July 1, 2026 | issue | SO-260701-789 | MAIN | 6 | 88.91 | -533.46 | 3 | 266.73 | April 30, 2026: 6 @ 88.91 |
| June 26, 2026 | issue | SO-260626-721 | MAIN | 13 | 88.91 | -1,155.84 | 9 | 800.19 | April 30, 2026: 13 @ 88.91 |
| June 20, 2026 | issue | SO-260620-216 | MAIN | 6 | 88.91 | -533.46 | 22 | 1,956.03 | April 30, 2026: 6 @ 88.91 |
| June 19, 2026 | issue | SO-260619-471 | MAIN | 47 | 88.91 | -4,178.79 | 28 | 2,489.49 | April 30, 2026: 47 @ 88.91 |
| May 31, 2026 | issue | SO-260531-345 | MAIN | 4 | 88.91 | -355.64 | 75 | 6,668.29 | April 30, 2026: 4 @ 88.91 |
| May 26, 2026 | issue | SO-260526-391 | MAIN | 15 | 88.91 | -1,333.66 | 79 | 7,023.93 | April 30, 2026: 15 @ 88.91 |
| May 23, 2026 | issue | SO-260523-468 | MAIN | 10 | 88.85 | -888.52 | 94 | 8,357.59 | March 31, 2026: 2 @ 88.62; April 30, 2026: 8 @ 88.91 |
| May 9, 2026 | issue | SO-260509-260 | MAIN | 25 | 88.62 | -2,215.48 | 104 | 9,246.11 | March 31, 2026: 25 @ 88.62 |
| April 30, 2026 | receipt | PO-001453 | MAIN | 102 | 88.91 | 9,068.87 | 129 | 11,461.59 | |
| April 28, 2026 | issue | SO-260428-861 | MAIN | 3 | 88.62 | -265.86 | 27 | 2,392.72 | March 31, 2026: 3 @ 88.62 |
| April 21, 2026 | issue | SO-260421-153 | MAIN | 2 | 88.62 | -177.24 | 30 | 2,658.58 | March 31, 2026: 2 @ 88.62 |
| April 19, 2026 | issue | SO-260419-436 | MAIN | 3 | 88.62 | -265.86 | 32 | 2,835.81 | March 31, 2026: 3 @ 88.62 |
| April 18, 2026 | issue | SO-260418-222 | MAIN | 3 | 88.62 | -265.86 | 35 | 3,101.67 | March 31, 2026: 3 @ 88.62 |
| April 17, 2026 | issue | SO-260417-183 | MAIN | 1 | 88.62 | -88.62 | 38 | 3,367.53 | March 31, 2026: 1 @ 88.62 |
| April 15, 2026 | issue | SO-260415-599 | MAIN | 9 | 87.76 | -789.88 | 39 | 3,456.15 | March 2, 2026: 6 @ 87.34; March 31, 2026: 3 @ 88.62 |
| April 8, 2026 | issue | SO-260408-767 | MAIN | 2 | 87.34 | -174.67 | 48 | 4,246.02 | March 2, 2026: 2 @ 87.34 |
| March 31, 2026 | issue | SO-260331-161 | MAIN | 4 | 87.34 | -349.35 | 50 | 4,420.70 | March 2, 2026: 4 @ 87.34 |
| March 31, 2026 | receipt | PO-001371 | MAIN | 42 | 88.62 | 3,722.01 | 54 | 4,770.04 | |
| March 29, 2026 | issue | SO-260329-782 | MAIN | 1 | 87.34 | -87.34 | 12 | 1,048.04 | March 2, 2026: 1 @ 87.34 |
| March 26, 2026 | issue | SO-260326-595 | MAIN | 1 | 87.34 | -87.34 | 13 | 1,135.37 | March 2, 2026: 1 @ 87.34 |
| March 12, 2026 | issue | SO-260312-613 | MAIN | 5 | 87.34 | -436.68 | 14 | 1,222.71 | March 2, 2026: 5 @ 87.34 |
| March 9, 2026 | issue | SO-260309-592 | MAIN | 4 | 87.34 | -349.35 | 19 | 1,659.39 | March 2, 2026: 4 @ 87.34 |
| March 3, 2026 | issue | SO-260303-178 | MAIN | 2 | 87.34 | -174.67 | 23 | 2,008.74 | March 2, 2026: 2 @ 87.34 |
| March 2, 2026 | issue | SO-260302-568 | MAIN | 7 | 87.27 | -610.88 | 25 | 2,183.41 | Dec. 24, 2025: 6 @ 87.26; March 2, 2026: 1 @ 87.34 |
| March 2, 2026 | receipt | PO-001275 | MAIN | 26 | 87.34 | 2,270.75 | 32 | 2,794.29 | |
| Feb. 20, 2026 | issue | SO-260220-623 | MAIN | 2 | 87.26 | -174.51 | 6 | 523.54 | Dec. 24, 2025: 2 @ 87.26 |
| Feb. 14, 2026 | issue | SO-260214-741 | MAIN | 1 | 87.26 | -87.26 | 8 | 698.06 | Dec. 24, 2025: 1 @ 87.26 |
| Feb. 8, 2026 | issue | SO-260208-647 | MAIN | 2 | 87.26 | -174.51 | 9 | 785.31 | Dec. 24, 2025: 2 @ 87.26 |
| Feb. 8, 2026 | issue | SO-260208-647 | EAST | 1 | 87.26 | -87.26 | 11 | 959.83 | Dec. 24, 2025: 1 @ 87.26 |
| Feb. 4, 2026 | issue | SO-260204-736 | MAIN | 4 | 87.26 | -349.03 | 12 | 1,047.09 | Dec. 24, 2025: 4 @ 87.26 |
| Jan. 17, 2026 | issue | SO-260117-397 | EAST | 2 | 87.26 | -174.51 | 16 | 1,396.12 | Dec. 24, 2025: 2 @ 87.26 |
| Jan. 16, 2026 | issue | SO-260116-959 | MAIN | 8 | 86.63 | -693.03 | 18 | 1,570.63 | July 27, 2025: 5 @ 86.25; Dec. 24, 2025: 3 @ 87.26 |
| Dec. 27, 2025 | issue | SO-251227-677 | EAST | 3 | 86.25 | -258.76 | 26 | 2,263.66 | July 27, 2025: 3 @ 86.25 |
| Dec. 26, 2025 | issue | SO-251226-647 | MAIN | 2 | 86.25 | -172.50 | 29 | 2,522.42 | July 27, 2025: 2 @ 86.25 |
| Dec. 24, 2025 | transfer | TRF | MAIN → EAST | 6 | warehouse transfer, no cost effect | ||||
| Dec. 24, 2025 | receipt | PO-001082 | MAIN | 21 | 87.26 | 1,832.40 | 31 | 2,694.93 | |
| Dec. 15, 2025 | issue | SO-251215-526 | MAIN | 1 | 86.25 | -86.25 | 10 | 862.52 | July 27, 2025: 1 @ 86.25 |
| Dec. 8, 2025 | issue | SO-251208-642 | MAIN | 1 | 86.25 | -86.25 | 11 | 948.78 | July 27, 2025: 1 @ 86.25 |
| Dec. 1, 2025 | issue | SO-251201-622 | MAIN | 2 | 86.25 | -172.50 | 12 | 1,035.03 | July 27, 2025: 2 @ 86.25 |
| Nov. 24, 2025 | issue | SO-251124-809 | MAIN | 1 | 86.25 | -86.25 | 14 | 1,207.53 | July 27, 2025: 1 @ 86.25 |