Items / FAN-0021
Wall Fan 400mm Pro FAN-0021 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)10MAIN 10
Value (FIFO)1,119.39avg 111.94
ClassAY / FCV 0.61
Turnover18.5xlast issue 1 days ago
Days of cover12lead time 22d
Reorder suggested: 72 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.33 / 30.4375 | 0.865 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 16.12 / 5.517 | 2.921 |
| 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 * 2.921^2 + 0.865^2 * 7.4^2) | 30.8 |
| Reorder point | d * LT + safety stock | 0.865 * 21.5 + 30.8 | 49.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 49.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 316/yr, S = 45.00, h = 20%, price = 110.25 | 35.9 |
| Inventory position | on hand + on order | 10 + 0 | 10 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 110.25 | 36 | 35,607 | yes (chosen if cheapest) |
MOQ 12, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 3, 2026 | 10 / 18 | 111.94 | 1,119.39 |
Movement ledger 140 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 15, 2026 | issue | SO-261015-526 | MAIN | 1 | 111.94 | -111.94 | 10 | 1,119.39 | Oct. 3, 2026: 1 @ 111.94 |
| Oct. 13, 2026 | issue | SO-261013-415 | MAIN | 1 | 111.94 | -111.94 | 11 | 1,231.33 | Oct. 3, 2026: 1 @ 111.94 |
| Oct. 12, 2026 | issue | SO-261012-721 | MAIN | 1 | 111.94 | -111.94 | 12 | 1,343.27 | Oct. 3, 2026: 1 @ 111.94 |
| Oct. 11, 2026 | issue | SO-261011-519 | MAIN | 1 | 111.94 | -111.94 | 13 | 1,455.21 | Oct. 3, 2026: 1 @ 111.94 |
| Oct. 9, 2026 | issue | SO-261009-280 | MAIN | 2 | 111.94 | -223.88 | 14 | 1,567.15 | Oct. 3, 2026: 2 @ 111.94 |
| Oct. 8, 2026 | issue | SO-261008-814 | MAIN | 1 | 111.94 | -111.94 | 16 | 1,791.02 | Oct. 3, 2026: 1 @ 111.94 |
| Oct. 4, 2026 | issue | SO-261004-825 | MAIN | 4 | 110.94 | -443.75 | 17 | 1,902.96 | Aug. 7, 2026: 3 @ 110.61; Oct. 3, 2026: 1 @ 111.94 |
| Oct. 3, 2026 | receipt | PO-001847 | MAIN | 18 | 111.94 | 2,014.90 | 21 | 2,346.72 | |
| Sept. 21, 2026 | issue | SO-260921-806 | MAIN | 1 | 110.61 | -110.61 | 3 | 331.82 | Aug. 7, 2026: 1 @ 110.61 |
| Sept. 15, 2026 | issue | SO-260915-176 | MAIN | 11 | 110.61 | -1,216.66 | 4 | 442.42 | Aug. 7, 2026: 11 @ 110.61 |
| Sept. 11, 2026 | issue | SO-260911-913 | MAIN | 1 | 110.61 | -110.61 | 15 | 1,659.08 | Aug. 7, 2026: 1 @ 110.61 |
| Sept. 9, 2026 | issue | SO-260909-298 | MAIN | 1 | 110.61 | -110.61 | 16 | 1,769.68 | Aug. 7, 2026: 1 @ 110.61 |
| Aug. 31, 2026 | issue | SO-260831-686 | MAIN | 1 | 110.61 | -110.61 | 17 | 1,880.29 | Aug. 7, 2026: 1 @ 110.61 |
| Aug. 28, 2026 | issue | SO-260828-555 | MAIN | 7 | 110.61 | -774.24 | 18 | 1,990.90 | Aug. 7, 2026: 7 @ 110.61 |
| Aug. 23, 2026 | issue | SO-260823-355 | MAIN | 2 | 110.61 | -221.21 | 25 | 2,765.13 | Aug. 7, 2026: 2 @ 110.61 |
| Aug. 12, 2026 | issue | SO-260812-218 | MAIN | 6 | 110.61 | -663.63 | 27 | 2,986.34 | Aug. 7, 2026: 6 @ 110.61 |
| Aug. 10, 2026 | issue | SO-260810-586 | MAIN | 7 | 110.61 | -774.24 | 33 | 3,649.97 | Aug. 7, 2026: 7 @ 110.61 |
| Aug. 8, 2026 | issue | SO-260808-181 | MAIN | 14 | 106.71 | -1,493.95 | 40 | 4,424.21 | May 30, 2026: 10 @ 105.15; Aug. 7, 2026: 4 @ 110.61 |
| Aug. 7, 2026 | receipt | PO-001702 | MAIN | 44 | 110.61 | 4,866.63 | 54 | 5,918.16 | |
| Aug. 4, 2026 | issue | SO-260804-230 | MAIN | 4 | 105.15 | -420.61 | 10 | 1,051.52 | May 30, 2026: 4 @ 105.15 |
| July 26, 2026 | issue | SO-260726-162 | MAIN | 28 | 105.15 | -2,944.27 | 14 | 1,472.13 | May 30, 2026: 28 @ 105.15 |
| July 14, 2026 | issue | SO-260714-353 | MAIN | 14 | 105.15 | -1,472.13 | 42 | 4,416.40 | May 30, 2026: 14 @ 105.15 |
| June 25, 2026 | issue | SO-260625-841 | MAIN | 3 | 105.15 | -315.46 | 56 | 5,888.53 | May 30, 2026: 3 @ 105.15 |
| June 14, 2026 | issue | SO-260614-988 | MAIN | 13 | 105.15 | -1,366.98 | 59 | 6,203.99 | May 30, 2026: 13 @ 105.15 |
| June 10, 2026 | issue | SO-260610-565 | MAIN | 27 | 105.15 | -2,839.11 | 72 | 7,570.97 | May 30, 2026: 27 @ 105.15 |
| June 8, 2026 | issue | SO-260608-630 | MAIN | 1 | 105.15 | -105.15 | 99 | 10,410.09 | May 30, 2026: 1 @ 105.15 |
| May 30, 2026 | receipt | PO-001535 | MAIN | 100 | 105.15 | 10,515.24 | 100 | 10,515.24 | |
| May 19, 2026 | issue | SO-260519-571 | MAIN | 17 | 104.64 | -1,778.91 | 0 | 0.00 | March 31, 2026: 17 @ 104.64 |
| May 13, 2026 | issue | SO-260513-941 | MAIN | 5 | 104.64 | -523.21 | 17 | 1,778.91 | March 31, 2026: 5 @ 104.64 |
| May 12, 2026 | issue | SO-260512-147 | MAIN | 21 | 104.64 | -2,197.48 | 22 | 2,302.12 | March 31, 2026: 21 @ 104.64 |
| May 11, 2026 | issue | SO-260511-265 | MAIN | 10 | 104.64 | -1,046.42 | 43 | 4,499.60 | March 31, 2026: 10 @ 104.64 |
| April 20, 2026 | issue | SO-260420-905 | MAIN | 3 | 104.64 | -313.93 | 53 | 5,546.02 | March 31, 2026: 3 @ 104.64 |
| April 18, 2026 | issue | SO-260418-272 | MAIN | 3 | 104.64 | -313.93 | 56 | 5,859.95 | March 31, 2026: 3 @ 104.64 |
| April 17, 2026 | issue | SO-260417-169 | MAIN | 2 | 104.64 | -209.28 | 59 | 6,173.87 | March 31, 2026: 2 @ 104.64 |
| April 6, 2026 | issue | SO-260406-174 | MAIN | 19 | 105.93 | -2,012.58 | 61 | 6,383.16 | March 13, 2026: 15 @ 106.27; March 31, 2026: 4 @ 104.64 |
| March 31, 2026 | receipt | PO-001370 | MAIN | 65 | 104.64 | 6,801.72 | 80 | 8,395.73 | |
| March 26, 2026 | issue | SO-260326-633 | MAIN | 17 | 106.27 | -1,806.54 | 15 | 1,594.01 | March 13, 2026: 17 @ 106.27 |
| March 23, 2026 | issue | SO-260323-930 | MAIN | 11 | 106.93 | -1,176.23 | 32 | 3,400.55 | Feb. 10, 2026: 3 @ 108.09; Feb. 25, 2026: 1 @ 108.09; March 13, 2026: 7 @ 106.27 |
| March 22, 2026 | issue | SO-260322-368 | MAIN | 1 | 108.09 | -108.09 | 43 | 4,576.78 | Feb. 10, 2026: 1 @ 108.09 |
| March 19, 2026 | issue | SO-260319-211 | MAIN | 3 | 108.09 | -324.27 | 44 | 4,684.87 | Feb. 10, 2026: 3 @ 108.09 |
| March 13, 2026 | receipt | PO-001313 | MAIN | 39 | 106.27 | 4,144.42 | 47 | 5,009.14 | |
| March 10, 2026 | issue | SO-260310-359 | MAIN | 2 | 108.09 | -216.18 | 8 | 864.71 | Feb. 10, 2026: 2 @ 108.09 |
| March 9, 2026 | issue | SO-260309-458 | MAIN | 3 | 108.09 | -324.27 | 10 | 1,080.89 | Feb. 10, 2026: 3 @ 108.09 |
| March 4, 2026 | issue | SO-260304-879 | MAIN | 3 | 108.09 | -324.27 | 13 | 1,405.16 | Feb. 10, 2026: 3 @ 108.09 |
| Feb. 27, 2026 | issue | SO-260227-598 | MAIN | 5 | 108.09 | -540.45 | 16 | 1,729.43 | Feb. 10, 2026: 5 @ 108.09 |
| Feb. 25, 2026 | return | RMA | MAIN | 1 | 108.09 | 108.09 | 21 | 2,269.88 | |
| Feb. 16, 2026 | issue | SO-260216-339 | MAIN | 4 | 108.09 | -432.36 | 20 | 2,161.79 | Feb. 10, 2026: 4 @ 108.09 |
| Feb. 11, 2026 | issue | SO-260211-192 | MAIN | 1 | 103.59 | -103.59 | 24 | 2,594.14 | Dec. 24, 2025: 1 @ 103.59 |
| Feb. 10, 2026 | receipt | PO-001214 | MAIN | 24 | 108.09 | 2,594.14 | 25 | 2,697.73 | |
| Feb. 3, 2026 | issue | SO-260203-837 | MAIN | 3 | 103.59 | -310.77 | 1 | 103.59 | Dec. 24, 2025: 3 @ 103.59 |
| Feb. 1, 2026 | issue | SO-260201-937 | MAIN | 1 | 103.59 | -103.59 | 4 | 414.36 | Dec. 24, 2025: 1 @ 103.59 |
| Jan. 30, 2026 | issue | SO-260130-614 | MAIN | 1 | 103.59 | -103.59 | 5 | 517.95 | Dec. 24, 2025: 1 @ 103.59 |
| Jan. 14, 2026 | issue | SO-260114-349 | MAIN | 8 | 103.59 | -828.72 | 6 | 621.54 | Dec. 24, 2025: 8 @ 103.59 |
| Jan. 13, 2026 | issue | SO-260113-970 | MAIN | 1 | 103.59 | -103.59 | 14 | 1,450.26 | Dec. 24, 2025: 1 @ 103.59 |
| Jan. 6, 2026 | issue | SO-260106-276 | MAIN | 4 | 103.59 | -414.36 | 15 | 1,553.85 | Dec. 24, 2025: 4 @ 103.59 |
| Jan. 5, 2026 | issue | SO-260105-538 | MAIN | 1 | 103.59 | -103.59 | 19 | 1,968.21 | Dec. 24, 2025: 1 @ 103.59 |
| Jan. 3, 2026 | issue | SO-260103-915 | MAIN | 3 | 105.03 | -315.08 | 20 | 2,071.80 | Aug. 22, 2025: 2 @ 105.03; Oct. 3, 2025: 1 @ 105.03 |
| Dec. 31, 2025 | issue | SO-251231-883 | MAIN | 4 | 105.03 | -420.11 | 23 | 2,386.88 | Aug. 22, 2025: 4 @ 105.03 |
| Dec. 24, 2025 | receipt | PO-001082 | MAIN | 20 | 103.59 | 2,071.80 | 27 | 2,806.99 | |
| Dec. 12, 2025 | issue | SO-251212-795 | MAIN | 1 | 105.03 | -105.03 | 7 | 735.20 | Aug. 22, 2025: 1 @ 105.03 |