Items / FAN-0020
Ceiling Fan 1200mm Pro FAN-0020 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)32MAIN 32
Value (FIFO)3,327.95avg 104.00
ClassBY / FCV 0.72
Turnover14.3xlast issue 0 days ago
Days of cover54lead time 22d
Reorder suggested: 36 units (position at or below reorder point: order EOQ), stockout risk low.
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 | 18.17 / 30.4375 | 0.597 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 13.08 / 5.517 | 2.370 |
| 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 * 2.370^2 + 0.597^2 * 7.4^2) | 19.5 |
| Reorder point | d * LT + safety stock | 0.597 * 21.5 + 19.5 | 32.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 32.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 218/yr, S = 45.00, h = 20%, price = 98.68 | 36.0 |
| Inventory position | on hand + on order | 32 + 0 | 32 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 107.26 | 30 | 24,015 | no |
| 18 | 102.97 | 31 | 23,067 | yes |
| 36 | 98.68 | 36 | 22,125 | yes (chosen if cheapest) |
MOQ 9, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 3, 2026 | 21 / 74 | 104.00 | 2,183.97 | |
| July 10, 2026 | 7 / 7 | 104.00 | 727.99 | |
| Sept. 2, 2026 | 4 / 4 | 104.00 | 415.99 |
Movement ledger 124 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-376 | MAIN | 1 | 104.00 | -104.00 | 32 | 3,327.95 | July 3, 2026: 1 @ 104.00 |
| Oct. 14, 2026 | issue | SO-261014-236 | MAIN | 1 | 104.00 | -104.00 | 33 | 3,431.95 | July 3, 2026: 1 @ 104.00 |
| Oct. 4, 2026 | issue | SO-261004-857 | MAIN | 2 | 104.00 | -208.00 | 34 | 3,535.95 | July 3, 2026: 2 @ 104.00 |
| Oct. 3, 2026 | issue | SO-261003-410 | MAIN | 1 | 104.00 | -104.00 | 36 | 3,743.94 | July 3, 2026: 1 @ 104.00 |
| Oct. 1, 2026 | issue | SO-261001-390 | MAIN | 2 | 104.00 | -208.00 | 37 | 3,847.94 | July 3, 2026: 2 @ 104.00 |
| Sept. 20, 2026 | issue | SO-260920-932 | MAIN | 11 | 104.00 | -1,143.98 | 39 | 4,055.94 | July 3, 2026: 11 @ 104.00 |
| Sept. 15, 2026 | issue | SO-260915-944 | MAIN | 3 | 104.00 | -312.00 | 50 | 5,199.92 | July 3, 2026: 3 @ 104.00 |
| Sept. 2, 2026 | return | RMA | MAIN | 4 | 104.00 | 415.99 | 53 | 5,511.92 | |
| Aug. 26, 2026 | issue | SO-260826-104 | MAIN | 1 | 104.00 | -104.00 | 49 | 5,095.92 | July 3, 2026: 1 @ 104.00 |
| Aug. 24, 2026 | issue | SO-260824-728 | MAIN | 2 | 104.00 | -208.00 | 50 | 5,199.92 | July 3, 2026: 2 @ 104.00 |
| Aug. 22, 2026 | issue | SO-260822-661 | MAIN | 9 | 104.00 | -935.99 | 52 | 5,407.92 | July 3, 2026: 9 @ 104.00 |
| Aug. 20, 2026 | issue | SO-260820-777 | MAIN | 1 | 104.00 | -104.00 | 61 | 6,343.90 | July 3, 2026: 1 @ 104.00 |
| Aug. 17, 2026 | issue | SO-260817-629 | MAIN | 2 | 104.00 | -208.00 | 62 | 6,447.90 | July 3, 2026: 2 @ 104.00 |
| Aug. 15, 2026 | issue | SO-260815-333 | MAIN | 3 | 104.00 | -312.00 | 64 | 6,655.90 | July 3, 2026: 3 @ 104.00 |
| July 10, 2026 | return | RMA | MAIN | 7 | 104.00 | 727.99 | 67 | 6,967.89 | |
| July 3, 2026 | issue | SO-260703-495 | MAIN | 14 | 104.00 | -1,455.98 | 60 | 6,239.90 | July 3, 2026: 14 @ 104.00 |
| July 3, 2026 | receipt | PO-001623 | MAIN | 74 | 104.00 | 7,695.88 | 74 | 7,695.88 | |
| July 1, 2026 | issue | SO-260701-563 | MAIN | 14 | 102.29 | -1,432.05 | 0 | 0.00 | May 16, 2026: 14 @ 102.29 |
| June 6, 2026 | issue | SO-260606-113 | MAIN | 26 | 102.29 | -2,659.52 | 14 | 1,432.05 | May 16, 2026: 26 @ 102.29 |
| June 5, 2026 | issue | SO-260605-427 | MAIN | 22 | 102.29 | -2,250.36 | 40 | 4,091.57 | May 16, 2026: 22 @ 102.29 |
| May 30, 2026 | issue | SO-260530-809 | MAIN | 2 | 102.29 | -204.58 | 62 | 6,341.93 | May 16, 2026: 2 @ 102.29 |
| May 20, 2026 | issue | SO-260520-300 | MAIN | 7 | 102.29 | -716.02 | 64 | 6,546.51 | May 16, 2026: 7 @ 102.29 |
| May 16, 2026 | receipt | PO-001499 | MAIN | 71 | 102.29 | 7,262.53 | 71 | 7,262.53 | |
| May 8, 2026 | issue | SO-260508-820 | MAIN | 6 | 107.12 | -642.70 | 0 | 0.00 | March 27, 2026: 6 @ 107.12 |
| May 3, 2026 | issue | SO-260503-592 | MAIN | 3 | 107.12 | -321.35 | 6 | 642.70 | March 27, 2026: 3 @ 107.12 |
| May 2, 2026 | issue | SO-260502-806 | MAIN | 12 | 107.12 | -1,285.41 | 9 | 964.05 | March 27, 2026: 12 @ 107.12 |
| April 19, 2026 | issue | SO-260419-718 | MAIN | 16 | 107.12 | -1,713.88 | 21 | 2,249.46 | March 27, 2026: 16 @ 107.12 |
| April 19, 2026 | issue | SO-260419-718 | EAST | 11 | 107.12 | -1,178.29 | 37 | 3,963.34 | March 27, 2026: 11 @ 107.12 |
| April 6, 2026 | issue | SO-260406-586 | MAIN | 8 | 105.23 | -841.84 | 48 | 5,141.63 | Feb. 26, 2026: 8 @ 105.23 |
| March 30, 2026 | issue | SO-260330-645 | MAIN | 1 | 105.23 | -105.23 | 56 | 5,983.46 | Feb. 26, 2026: 1 @ 105.23 |
| March 27, 2026 | transfer | TRF | MAIN → EAST | 11 | warehouse transfer, no cost effect | ||||
| March 27, 2026 | receipt | PO-001360 | MAIN | 48 | 107.12 | 5,141.63 | 57 | 6,088.69 | |
| March 22, 2026 | issue | SO-260322-404 | MAIN | 1 | 105.23 | -105.23 | 9 | 947.07 | Feb. 26, 2026: 1 @ 105.23 |
| March 21, 2026 | issue | SO-260321-890 | MAIN | 6 | 105.23 | -631.38 | 10 | 1,052.30 | Feb. 26, 2026: 6 @ 105.23 |
| March 20, 2026 | issue | SO-260320-720 | MAIN | 4 | 105.23 | -420.92 | 16 | 1,683.68 | Feb. 26, 2026: 4 @ 105.23 |
| March 13, 2026 | issue | SO-260313-945 | MAIN | 1 | 105.23 | -105.23 | 20 | 2,104.60 | Feb. 26, 2026: 1 @ 105.23 |
| March 8, 2026 | issue | SO-260308-712 | MAIN | 8 | 105.23 | -841.84 | 21 | 2,209.83 | Feb. 26, 2026: 8 @ 105.23 |
| Feb. 26, 2026 | receipt | PO-001260 | MAIN | 29 | 105.23 | 3,051.66 | 29 | 3,051.66 | |
| Feb. 17, 2026 | issue | SO-260217-221 | EAST | 1 | 102.24 | -102.24 | 0 | 0.00 | Jan. 13, 2026: 1 @ 102.24 |
| Feb. 16, 2026 | issue | SO-260216-267 | EAST | 1 | 102.24 | -102.24 | 1 | 102.24 | Jan. 13, 2026: 1 @ 102.24 |
| Feb. 16, 2026 | issue | SO-260216-267 | MAIN | 5 | 102.24 | -511.20 | 2 | 204.48 | Jan. 13, 2026: 5 @ 102.24 |
| Feb. 13, 2026 | issue | SO-260213-644 | MAIN | 3 | 102.24 | -306.72 | 7 | 715.68 | Jan. 13, 2026: 3 @ 102.24 |
| Jan. 24, 2026 | issue | SO-260124-634 | MAIN | 3 | 102.24 | -306.72 | 10 | 1,022.39 | Jan. 13, 2026: 3 @ 102.24 |
| Jan. 18, 2026 | issue | SO-260118-850 | EAST | 1 | 102.24 | -102.24 | 13 | 1,329.11 | Jan. 13, 2026: 1 @ 102.24 |
| Jan. 14, 2026 | issue | SO-260114-573 | EAST | 1 | 102.24 | -102.24 | 14 | 1,431.35 | Jan. 13, 2026: 1 @ 102.24 |
| Jan. 13, 2026 | transfer | TRF | MAIN → EAST | 4 | warehouse transfer, no cost effect | ||||
| Jan. 13, 2026 | receipt | PO-001143 | MAIN | 15 | 102.24 | 1,533.59 | 15 | 1,533.59 | |
| Jan. 7, 2026 | issue | SO-260107-658 | MAIN | 4 | 104.44 | -417.77 | 0 | 0.00 | Oct. 29, 2025: 4 @ 104.44 |
| Dec. 21, 2025 | issue | SO-251221-350 | MAIN | 1 | 104.44 | -104.44 | 4 | 417.77 | Oct. 29, 2025: 1 @ 104.44 |
| Dec. 6, 2025 | issue | SO-251206-251 | MAIN | 3 | 104.44 | -313.33 | 5 | 522.21 | Oct. 29, 2025: 3 @ 104.44 |
| Nov. 22, 2025 | issue | SO-251122-602 | MAIN | 1 | 104.44 | -104.44 | 8 | 835.54 | Oct. 29, 2025: 1 @ 104.44 |
| Nov. 4, 2025 | issue | SO-251104-281 | MAIN | 1 | 104.44 | -104.44 | 9 | 939.98 | Oct. 29, 2025: 1 @ 104.44 |
| Nov. 3, 2025 | issue | SO-251103-570 | MAIN | 2 | 104.44 | -208.88 | 10 | 1,044.42 | Oct. 29, 2025: 2 @ 104.44 |
| Oct. 29, 2025 | issue | SO-251029-403 | MAIN | 1 | 104.44 | -104.44 | 12 | 1,253.30 | Oct. 29, 2025: 1 @ 104.44 |
| Oct. 29, 2025 | receipt | PO-000961 | MAIN | 13 | 104.44 | 1,357.75 | 13 | 1,357.75 | |
| Oct. 13, 2025 | issue | SO-251013-610 | EAST | 2 | 99.91 | -199.82 | 0 | 0.00 | July 21, 2025: 1 @ 99.91; Sept. 5, 2025: 1 @ 99.91 |
| Oct. 10, 2025 | issue | SO-251010-488 | EAST | 5 | 99.91 | -499.54 | 2 | 199.82 | July 21, 2025: 5 @ 99.91 |
| Sept. 28, 2025 | issue | SO-250928-543 | EAST | 2 | 99.63 | -199.26 | 7 | 699.36 | June 21, 2025: 2 @ 99.63 |
| Sept. 24, 2025 | issue | SO-250924-564 | EAST | 6 | 99.63 | -597.79 | 9 | 898.62 | June 21, 2025: 6 @ 99.63 |
| Sept. 18, 2025 | issue | SO-250918-284 | EAST | 1 | 99.91 | -99.91 | 15 | 1,496.41 | June 20, 2025: 1 @ 99.91 |