Items / FAN-0023
Table Fan 300mm Nova FAN-0023 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)14MAIN 14
Value (FIFO)1,268.54avg 90.61
ClassBY / FCV 0.73
Turnover16.1xlast issue 0 days ago
Days of cover17lead time 22d
Reorder suggested: 39 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 | 25.00 / 30.4375 | 0.821 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 18.33 / 5.517 | 3.323 |
| 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.323^2 + 0.821^2 * 7.4^2) | 27.2 |
| Reorder point | d * LT + safety stock | 0.821 * 21.5 + 27.2 | 44.9 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 44.9 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 300/yr, S = 45.00, h = 20%, price = 91.32 | 38.4 |
| Inventory position | on hand + on order | 14 + 0 | 14 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 91.32 | 38 | 28,079 | yes (chosen if cheapest) |
MOQ 13, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| June 28, 2026 | 10 / 106 | 90.61 | 906.10 | |
| July 9, 2026 | 1 / 1 | 90.61 | 90.61 | |
| July 30, 2026 | 3 / 3 | 90.61 | 271.83 |
Movement ledger 132 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-353 | MAIN | 4 | 90.61 | -362.44 | 14 | 1,268.54 | June 28, 2026: 4 @ 90.61 |
| Oct. 8, 2026 | issue | SO-261008-651 | MAIN | 2 | 90.61 | -181.22 | 18 | 1,630.98 | June 28, 2026: 2 @ 90.61 |
| Oct. 6, 2026 | issue | SO-261006-804 | MAIN | 2 | 90.61 | -181.22 | 20 | 1,812.20 | June 28, 2026: 2 @ 90.61 |
| Oct. 3, 2026 | issue | SO-261003-987 | MAIN | 2 | 90.61 | -181.22 | 22 | 1,993.42 | June 28, 2026: 2 @ 90.61 |
| Oct. 2, 2026 | issue | SO-261002-565 | MAIN | 1 | 90.61 | -90.61 | 24 | 2,174.64 | June 28, 2026: 1 @ 90.61 |
| Oct. 1, 2026 | issue | SO-261001-411 | MAIN | 2 | 90.61 | -181.22 | 25 | 2,265.25 | June 28, 2026: 2 @ 90.61 |
| Sept. 30, 2026 | issue | SO-260930-440 | MAIN | 3 | 90.61 | -271.83 | 27 | 2,446.47 | June 28, 2026: 3 @ 90.61 |
| Sept. 27, 2026 | issue | SO-260927-146 | MAIN | 1 | 90.61 | -90.61 | 30 | 2,718.30 | June 28, 2026: 1 @ 90.61 |
| Sept. 22, 2026 | issue | SO-260922-525 | MAIN | 3 | 90.61 | -271.83 | 31 | 2,808.91 | June 28, 2026: 3 @ 90.61 |
| Sept. 19, 2026 | issue | SO-260919-434 | MAIN | 1 | 90.61 | -90.61 | 34 | 3,080.74 | June 28, 2026: 1 @ 90.61 |
| Sept. 16, 2026 | issue | SO-260916-751 | MAIN | 1 | 90.61 | -90.61 | 35 | 3,171.35 | June 28, 2026: 1 @ 90.61 |
| Sept. 2, 2026 | issue | SO-260902-883 | MAIN | 3 | 90.61 | -271.83 | 36 | 3,261.96 | June 28, 2026: 3 @ 90.61 |
| Sept. 1, 2026 | issue | SO-260901-157 | MAIN | 1 | 90.61 | -90.61 | 39 | 3,533.79 | June 28, 2026: 1 @ 90.61 |
| Aug. 24, 2026 | issue | SO-260824-241 | MAIN | 5 | 90.61 | -453.05 | 40 | 3,624.40 | June 28, 2026: 5 @ 90.61 |
| Aug. 20, 2026 | issue | SO-260820-576 | MAIN | 11 | 90.61 | -996.71 | 45 | 4,077.45 | June 28, 2026: 11 @ 90.61 |
| Aug. 15, 2026 | issue | SO-260815-116 | MAIN | 3 | 90.61 | -271.83 | 56 | 5,074.17 | June 28, 2026: 3 @ 90.61 |
| Aug. 12, 2026 | issue | SO-260812-843 | MAIN | 6 | 90.61 | -543.66 | 59 | 5,346.00 | June 28, 2026: 6 @ 90.61 |
| July 30, 2026 | return | RMA | MAIN | 3 | 90.61 | 271.83 | 65 | 5,889.66 | |
| July 21, 2026 | issue | SO-260721-532 | MAIN | 6 | 90.61 | -543.66 | 62 | 5,617.83 | June 28, 2026: 6 @ 90.61 |
| July 16, 2026 | issue | SO-260716-176 | MAIN | 9 | 90.61 | -815.49 | 68 | 6,161.49 | June 28, 2026: 9 @ 90.61 |
| July 15, 2026 | issue | SO-260715-234 | MAIN | 7 | 90.61 | -634.27 | 77 | 6,976.98 | June 28, 2026: 7 @ 90.61 |
| July 12, 2026 | issue | SO-260712-693 | MAIN | 5 | 90.61 | -453.05 | 84 | 7,611.25 | June 28, 2026: 5 @ 90.61 |
| July 9, 2026 | return | RMA | MAIN | 1 | 90.61 | 90.61 | 89 | 8,064.30 | |
| July 6, 2026 | issue | SO-260706-569 | MAIN | 12 | 90.61 | -1,087.32 | 88 | 7,973.69 | June 28, 2026: 12 @ 90.61 |
| July 4, 2026 | issue | SO-260704-657 | MAIN | 1 | 90.61 | -90.61 | 100 | 9,061.01 | June 28, 2026: 1 @ 90.61 |
| July 2, 2026 | issue | SO-260702-200 | MAIN | 5 | 90.61 | -453.05 | 101 | 9,151.62 | June 28, 2026: 5 @ 90.61 |
| June 28, 2026 | receipt | PO-001609 | MAIN | 106 | 90.61 | 9,604.67 | 106 | 9,604.67 | |
| June 22, 2026 | issue | SO-260622-655 | MAIN | 33 | 90.92 | -3,000.42 | 0 | 0.00 | April 22, 2026: 33 @ 90.92 |
| June 18, 2026 | issue | SO-260618-354 | MAIN | 17 | 90.92 | -1,545.67 | 33 | 3,000.42 | April 22, 2026: 17 @ 90.92 |
| June 9, 2026 | issue | SO-260609-553 | MAIN | 12 | 90.92 | -1,091.06 | 50 | 4,546.10 | April 22, 2026: 12 @ 90.92 |
| June 1, 2026 | issue | SO-260601-943 | MAIN | 1 | 90.92 | -90.92 | 62 | 5,637.16 | April 22, 2026: 1 @ 90.92 |
| May 25, 2026 | issue | SO-260525-522 | MAIN | 7 | 90.92 | -636.45 | 63 | 5,728.08 | April 22, 2026: 7 @ 90.92 |
| May 22, 2026 | issue | SO-260522-257 | MAIN | 22 | 90.92 | -2,000.28 | 70 | 6,364.53 | April 22, 2026: 22 @ 90.92 |
| May 18, 2026 | issue | SO-260518-596 | MAIN | 21 | 88.81 | -1,864.93 | 92 | 8,364.81 | March 18, 2026: 11 @ 86.88; April 22, 2026: 10 @ 90.92 |
| May 9, 2026 | issue | SO-260509-939 | MAIN | 3 | 86.88 | -260.65 | 113 | 10,229.74 | March 18, 2026: 3 @ 86.88 |
| May 5, 2026 | issue | SO-260505-524 | MAIN | 1 | 86.88 | -86.88 | 116 | 10,490.39 | March 18, 2026: 1 @ 86.88 |
| April 27, 2026 | issue | SO-260427-227 | MAIN | 1 | 86.88 | -86.88 | 117 | 10,577.27 | March 18, 2026: 1 @ 86.88 |
| April 26, 2026 | issue | SO-260426-249 | EAST | 10 | 86.88 | -868.82 | 118 | 10,664.15 | March 18, 2026: 10 @ 86.88 |
| April 23, 2026 | issue | SO-260423-330 | MAIN | 3 | 86.88 | -260.65 | 128 | 11,532.98 | March 18, 2026: 3 @ 86.88 |
| April 22, 2026 | receipt | PO-001431 | MAIN | 102 | 90.92 | 9,274.03 | 131 | 11,793.63 | |
| April 21, 2026 | issue | SO-260421-658 | MAIN | 7 | 86.88 | -608.18 | 29 | 2,519.59 | March 18, 2026: 7 @ 86.88 |
| April 13, 2026 | issue | SO-260413-361 | MAIN | 8 | 86.98 | -695.86 | 36 | 3,127.77 | March 1, 2026: 2 @ 87.28; March 18, 2026: 6 @ 86.88 |
| April 7, 2026 | issue | SO-260407-761 | EAST | 2 | 87.28 | -174.57 | 44 | 3,823.63 | March 1, 2026: 2 @ 87.28 |
| April 3, 2026 | issue | SO-260403-760 | MAIN | 1 | 87.28 | -87.28 | 46 | 3,998.20 | March 1, 2026: 1 @ 87.28 |
| March 18, 2026 | transfer | TRF | MAIN → EAST | 12 | warehouse transfer, no cost effect | ||||
| March 18, 2026 | receipt | PO-001332 | MAIN | 42 | 86.88 | 3,649.06 | 47 | 4,085.48 | |
| March 15, 2026 | issue | SO-260315-525 | MAIN | 8 | 87.28 | -698.27 | 5 | 436.42 | March 1, 2026: 8 @ 87.28 |
| March 11, 2026 | issue | SO-260311-196 | MAIN | 8 | 87.28 | -698.27 | 13 | 1,134.69 | March 1, 2026: 8 @ 87.28 |
| March 4, 2026 | issue | SO-260304-242 | MAIN | 2 | 87.28 | -174.57 | 21 | 1,832.96 | March 1, 2026: 2 @ 87.28 |
| March 1, 2026 | issue | SO-260301-697 | MAIN | 8 | 87.80 | -702.42 | 23 | 2,007.53 | Jan. 17, 2026: 5 @ 88.11; March 1, 2026: 3 @ 87.28 |
| March 1, 2026 | receipt | PO-001271 | MAIN | 26 | 87.28 | 2,269.38 | 31 | 2,709.95 | |
| Feb. 26, 2026 | issue | SO-260226-617 | MAIN | 2 | 88.11 | -176.23 | 5 | 440.57 | Jan. 17, 2026: 2 @ 88.11 |
| Feb. 20, 2026 | issue | SO-260220-928 | MAIN | 1 | 88.11 | -88.11 | 7 | 616.80 | Jan. 17, 2026: 1 @ 88.11 |
| Feb. 17, 2026 | issue | SO-260217-812 | EAST | 1 | 88.11 | -88.11 | 8 | 704.91 | Jan. 17, 2026: 1 @ 88.11 |
| Feb. 5, 2026 | issue | SO-260205-729 | MAIN | 8 | 88.11 | -704.91 | 9 | 793.02 | Jan. 17, 2026: 8 @ 88.11 |
| Feb. 2, 2026 | issue | SO-260202-670 | EAST | 2 | 88.11 | -176.23 | 17 | 1,497.93 | Jan. 17, 2026: 2 @ 88.11 |
| Jan. 29, 2026 | issue | SO-260129-286 | EAST | 2 | 88.11 | -176.23 | 19 | 1,674.16 | Jan. 17, 2026: 2 @ 88.11 |
| Jan. 17, 2026 | transfer | TRF | MAIN → EAST | 5 | warehouse transfer, no cost effect | ||||
| Jan. 17, 2026 | receipt | PO-001154 | MAIN | 21 | 88.11 | 1,850.39 | 21 | 1,850.39 | |
| Jan. 5, 2026 | issue | SO-260105-903 | EAST | 1 | 88.44 | -88.44 | 0 | 0.00 | Dec. 12, 2025: 1 @ 88.44 |