Items / FAN-0012
Table Fan 300mm Pro FAN-0012 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)16MAIN 16
Value (FIFO)2,206.56avg 137.91
ClassAY / FCV 0.73
Turnover17.4xlast issue 0 days ago
Days of cover17lead time 22d
Reorder suggested: 66 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 | 28.00 / 30.4375 | 0.920 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 20.53 / 5.517 | 3.721 |
| 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.721^2 + 0.920^2 * 7.4^2) | 38.1 |
| Reorder point | d * LT + safety stock | 0.920 * 21.5 + 38.1 | 57.9 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 57.9 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 336/yr, S = 45.00, h = 20%, price = 141.24 | 32.7 |
| Inventory position | on hand + on order | 16 + 0 | 16 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 141.24 | 33 | 48,348 | yes (chosen if cheapest) |
MOQ 12, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 25, 2026 | 15 / 26 | 137.91 | 2,068.65 | |
| Oct. 11, 2026 | 1 / 1 | 137.91 | 137.91 |
Movement ledger 137 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 | issue | SO-261016-545 | MAIN | 1 | 137.91 | -137.91 | 16 | 2,206.56 | Sept. 25, 2026: 1 @ 137.91 |
| Oct. 11, 2026 | return | RMA | MAIN | 1 | 137.91 | 137.91 | 17 | 2,344.48 | |
| Oct. 10, 2026 | issue | SO-261010-148 | MAIN | 6 | 137.91 | -827.46 | 16 | 2,206.56 | Sept. 25, 2026: 6 @ 137.91 |
| Oct. 9, 2026 | issue | SO-261009-745 | MAIN | 1 | 137.91 | -137.91 | 22 | 3,034.03 | Sept. 25, 2026: 1 @ 137.91 |
| Oct. 6, 2026 | issue | SO-261006-668 | MAIN | 1 | 137.91 | -137.91 | 23 | 3,171.94 | Sept. 25, 2026: 1 @ 137.91 |
| Oct. 5, 2026 | issue | SO-261005-854 | MAIN | 2 | 137.91 | -275.82 | 24 | 3,309.85 | Sept. 25, 2026: 2 @ 137.91 |
| Oct. 3, 2026 | issue | SO-261003-815 | MAIN | 1 | 138.16 | -138.16 | 26 | 3,585.67 | June 20, 2026: 1 @ 138.16 |
| Sept. 29, 2026 | issue | SO-260929-669 | MAIN | 3 | 138.16 | -414.47 | 27 | 3,723.83 | June 20, 2026: 3 @ 138.16 |
| Sept. 26, 2026 | issue | SO-260926-792 | MAIN | 5 | 138.16 | -690.79 | 30 | 4,138.30 | June 20, 2026: 5 @ 138.16 |
| Sept. 25, 2026 | receipt | PO-001828 | MAIN | 26 | 137.91 | 3,585.67 | 35 | 4,829.09 | |
| Sept. 16, 2026 | issue | SO-260916-663 | MAIN | 1 | 138.16 | -138.16 | 9 | 1,243.42 | June 20, 2026: 1 @ 138.16 |
| Sept. 15, 2026 | issue | SO-260915-401 | MAIN | 3 | 138.16 | -414.47 | 10 | 1,381.58 | June 20, 2026: 3 @ 138.16 |
| Sept. 7, 2026 | issue | SO-260907-720 | MAIN | 1 | 138.16 | -138.16 | 13 | 1,796.05 | June 20, 2026: 1 @ 138.16 |
| Sept. 4, 2026 | issue | SO-260904-506 | MAIN | 4 | 138.16 | -552.63 | 14 | 1,934.21 | June 20, 2026: 4 @ 138.16 |
| Aug. 25, 2026 | issue | SO-260825-627 | MAIN | 1 | 138.16 | -138.16 | 18 | 2,486.84 | June 20, 2026: 1 @ 138.16 |
| Aug. 11, 2026 | issue | SO-260811-981 | MAIN | 12 | 138.16 | -1,657.89 | 19 | 2,625.00 | June 20, 2026: 12 @ 138.16 |
| Aug. 2, 2026 | issue | SO-260802-718 | MAIN | 8 | 138.16 | -1,105.26 | 31 | 4,282.89 | June 20, 2026: 8 @ 138.16 |
| Aug. 1, 2026 | issue | SO-260801-136 | MAIN | 6 | 138.16 | -828.95 | 39 | 5,388.15 | June 20, 2026: 6 @ 138.16 |
| July 20, 2026 | issue | SO-260720-802 | MAIN | 28 | 138.16 | -3,868.42 | 45 | 6,217.10 | June 20, 2026: 28 @ 138.16 |
| July 15, 2026 | issue | SO-260715-878 | MAIN | 14 | 138.16 | -1,934.21 | 73 | 10,085.51 | June 20, 2026: 14 @ 138.16 |
| July 5, 2026 | issue | SO-260705-975 | MAIN | 4 | 138.16 | -552.63 | 87 | 12,019.72 | June 20, 2026: 4 @ 138.16 |
| June 28, 2026 | issue | SO-260628-753 | MAIN | 30 | 138.85 | -4,165.35 | 91 | 12,572.35 | April 25, 2026: 23 @ 139.05; June 20, 2026: 7 @ 138.16 |
| June 27, 2026 | issue | SO-260627-124 | MAIN | 6 | 139.05 | -834.33 | 121 | 16,737.70 | April 25, 2026: 6 @ 139.05 |
| June 20, 2026 | receipt | PO-001588 | MAIN | 98 | 138.16 | 13,539.45 | 127 | 17,572.03 | |
| June 16, 2026 | issue | SO-260616-585 | MAIN | 2 | 139.05 | -278.11 | 29 | 4,032.57 | April 25, 2026: 2 @ 139.05 |
| June 14, 2026 | issue | SO-260614-757 | MAIN | 17 | 139.05 | -2,363.92 | 31 | 4,310.68 | April 25, 2026: 17 @ 139.05 |
| June 6, 2026 | issue | SO-260606-552 | MAIN | 1 | 139.05 | -139.05 | 48 | 6,674.60 | April 25, 2026: 1 @ 139.05 |
| June 2, 2026 | issue | SO-260602-681 | MAIN | 9 | 139.05 | -1,251.49 | 49 | 6,813.66 | April 25, 2026: 9 @ 139.05 |
| June 2, 2026 | issue | SO-260602-681 | EAST | 2 | 139.05 | -278.11 | 58 | 8,065.14 | April 25, 2026: 2 @ 139.05 |
| May 20, 2026 | issue | SO-260520-561 | MAIN | 31 | 139.05 | -4,310.68 | 60 | 8,343.25 | April 25, 2026: 31 @ 139.05 |
| May 18, 2026 | issue | SO-260518-896 | MAIN | 29 | 137.09 | -3,975.67 | 91 | 12,653.93 | April 3, 2026: 26 @ 136.87; April 25, 2026: 3 @ 139.05 |
| April 29, 2026 | issue | SO-260429-400 | MAIN | 8 | 136.87 | -1,094.92 | 120 | 16,629.60 | April 3, 2026: 8 @ 136.87 |
| April 25, 2026 | receipt | PO-001436 | MAIN | 94 | 139.05 | 13,071.09 | 128 | 17,724.52 | |
| April 18, 2026 | issue | SO-260418-705 | MAIN | 8 | 136.87 | -1,094.92 | 34 | 4,653.43 | April 3, 2026: 8 @ 136.87 |
| April 17, 2026 | issue | SO-260417-988 | MAIN | 6 | 136.87 | -821.19 | 42 | 5,748.35 | April 3, 2026: 6 @ 136.87 |
| April 8, 2026 | issue | SO-260408-624 | MAIN | 4 | 136.87 | -547.46 | 48 | 6,569.54 | April 3, 2026: 4 @ 136.87 |
| April 6, 2026 | issue | SO-260406-607 | MAIN | 21 | 135.63 | -2,848.29 | 52 | 7,117.01 | March 10, 2026: 9 @ 133.99; April 3, 2026: 12 @ 136.87 |
| April 3, 2026 | receipt | PO-001381 | MAIN | 64 | 136.87 | 8,759.39 | 73 | 9,965.30 | |
| March 31, 2026 | issue | SO-260331-262 | MAIN | 4 | 133.99 | -535.96 | 9 | 1,205.91 | March 10, 2026: 4 @ 133.99 |
| March 24, 2026 | issue | SO-260324-124 | MAIN | 7 | 133.99 | -937.93 | 13 | 1,741.87 | March 10, 2026: 7 @ 133.99 |
| March 23, 2026 | issue | SO-260323-443 | MAIN | 2 | 133.99 | -267.98 | 20 | 2,679.79 | March 10, 2026: 2 @ 133.99 |
| March 18, 2026 | issue | SO-260318-708 | MAIN | 4 | 135.77 | -543.09 | 22 | 2,947.77 | Jan. 14, 2026: 1 @ 137.43; Jan. 18, 2026: 1 @ 137.68; March 10, 2026: 2 @ 133.99 |
| March 10, 2026 | receipt | PO-001304 | MAIN | 24 | 133.99 | 3,215.75 | 26 | 3,490.86 | |
| March 8, 2026 | issue | SO-260308-225 | EAST | 1 | 137.43 | -137.43 | 2 | 275.11 | Jan. 14, 2026: 1 @ 137.43 |
| March 2, 2026 | issue | SO-260302-191 | EAST | 2 | 137.43 | -274.86 | 3 | 412.54 | Jan. 14, 2026: 2 @ 137.43 |
| Feb. 27, 2026 | issue | SO-260227-807 | EAST | 1 | 137.43 | -137.43 | 5 | 687.40 | Jan. 14, 2026: 1 @ 137.43 |
| Feb. 25, 2026 | issue | SO-260225-671 | EAST | 2 | 137.43 | -274.86 | 6 | 824.83 | Jan. 14, 2026: 2 @ 137.43 |
| Feb. 25, 2026 | issue | SO-260225-671 | MAIN | 1 | 137.43 | -137.43 | 8 | 1,099.69 | Jan. 14, 2026: 1 @ 137.43 |
| Feb. 7, 2026 | issue | SO-260207-921 | MAIN | 4 | 137.43 | -549.72 | 9 | 1,237.12 | Jan. 14, 2026: 4 @ 137.43 |
| Feb. 1, 2026 | issue | SO-260201-468 | MAIN | 8 | 137.43 | -1,099.44 | 13 | 1,786.84 | Jan. 14, 2026: 8 @ 137.43 |
| Jan. 31, 2026 | issue | SO-260131-173 | MAIN | 2 | 137.68 | -275.36 | 21 | 2,886.27 | Aug. 1, 2025: 1 @ 137.68; Oct. 22, 2025: 1 @ 137.68 |
| Jan. 20, 2026 | issue | SO-260120-198 | MAIN | 1 | 137.68 | -137.68 | 23 | 3,161.63 | Aug. 1, 2025: 1 @ 137.68 |
| Jan. 18, 2026 | return | RMA | MAIN | 1 | 137.68 | 137.68 | 24 | 3,299.31 | |
| Jan. 15, 2026 | issue | SO-260115-110 | MAIN | 4 | 137.68 | -550.71 | 23 | 3,161.63 | Aug. 1, 2025: 4 @ 137.68 |
| Jan. 14, 2026 | issue | SO-260114-804 | MAIN | 1 | 137.68 | -137.68 | 27 | 3,712.35 | Aug. 1, 2025: 1 @ 137.68 |
| Jan. 14, 2026 | receipt | PO-001144 | MAIN | 20 | 137.43 | 2,748.60 | 28 | 3,850.03 | |
| Jan. 6, 2026 | issue | SO-260106-521 | MAIN | 5 | 137.68 | -688.39 | 8 | 1,101.43 | Aug. 1, 2025: 5 @ 137.68 |
| Dec. 31, 2025 | issue | SO-251231-802 | MAIN | 2 | 137.68 | -275.36 | 13 | 1,789.82 | Aug. 1, 2025: 2 @ 137.68 |
| Dec. 30, 2025 | issue | SO-251230-976 | MAIN | 1 | 137.68 | -137.68 | 15 | 2,065.18 | Aug. 1, 2025: 1 @ 137.68 |
| Dec. 29, 2025 | issue | SO-251229-517 | MAIN | 1 | 137.68 | -137.68 | 16 | 2,202.86 | Aug. 1, 2025: 1 @ 137.68 |