Items / FAN-0018
Wall Fan 400mm Elite FAN-0018 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)35MAIN 21, EAST 14
Value (FIFO)3,598.50avg 102.81
ClassBY / FCV 0.67
Turnover9.7xlast issue 1 days ago
Days of cover44lead 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 | 24.42 / 30.4375 | 0.802 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 16.41 / 5.517 | 2.974 |
| 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.974^2 + 0.802^2 * 7.4^2) | 24.7 |
| Reorder point | d * LT + safety stock | 0.802 * 21.5 + 24.7 | 42.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 42.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 293/yr, S = 45.00, h = 20%, price = 107.44 | 35.0 |
| Inventory position | on hand + on order | 35 + 0 | 35 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 107.44 | 35 | 32,211 | yes (chosen if cheapest) |
MOQ 14, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| June 10, 2026 | 35 / 110 | 102.81 | 3,598.50 |
Movement ledger 136 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-647 | EAST | 3 | 102.81 | -308.44 | 35 | 3,598.50 | June 10, 2026: 3 @ 102.81 |
| Oct. 11, 2026 | issue | SO-261011-682 | MAIN | 7 | 102.81 | -719.70 | 38 | 3,906.94 | June 10, 2026: 7 @ 102.81 |
| Sept. 29, 2026 | issue | SO-260929-945 | MAIN | 5 | 102.81 | -514.07 | 45 | 4,626.64 | June 10, 2026: 5 @ 102.81 |
| Sept. 22, 2026 | issue | SO-260922-633 | MAIN | 6 | 102.81 | -616.89 | 50 | 5,140.71 | June 10, 2026: 6 @ 102.81 |
| Sept. 7, 2026 | issue | SO-260907-916 | MAIN | 1 | 102.81 | -102.81 | 56 | 5,757.60 | June 10, 2026: 1 @ 102.81 |
| Sept. 4, 2026 | issue | SO-260904-122 | MAIN | 2 | 102.81 | -205.63 | 57 | 5,860.41 | June 10, 2026: 2 @ 102.81 |
| Aug. 28, 2026 | issue | SO-260828-366 | MAIN | 1 | 102.81 | -102.81 | 59 | 6,066.04 | June 10, 2026: 1 @ 102.81 |
| Aug. 20, 2026 | issue | SO-260820-848 | EAST | 1 | 102.81 | -102.81 | 60 | 6,168.85 | June 10, 2026: 1 @ 102.81 |
| Aug. 17, 2026 | issue | SO-260817-888 | MAIN | 17 | 102.81 | -1,747.84 | 61 | 6,271.67 | June 10, 2026: 17 @ 102.81 |
| Aug. 14, 2026 | issue | SO-260814-698 | MAIN | 14 | 102.81 | -1,439.40 | 78 | 8,019.51 | June 10, 2026: 14 @ 102.81 |
| July 30, 2026 | issue | SO-260730-623 | MAIN | 15 | 102.81 | -1,542.21 | 92 | 9,458.91 | June 10, 2026: 15 @ 102.81 |
| July 28, 2026 | issue | SO-260728-312 | MAIN | 15 | 106.45 | -1,596.69 | 107 | 11,001.12 | April 27, 2026: 12 @ 107.35; June 10, 2026: 3 @ 102.81 |
| July 22, 2026 | issue | SO-260722-650 | MAIN | 8 | 107.35 | -858.83 | 122 | 12,597.81 | April 27, 2026: 8 @ 107.35 |
| July 17, 2026 | issue | SO-260717-154 | MAIN | 6 | 107.35 | -644.12 | 130 | 13,456.64 | April 27, 2026: 6 @ 107.35 |
| July 14, 2026 | issue | SO-260714-508 | MAIN | 1 | 107.35 | -107.35 | 136 | 14,100.76 | April 27, 2026: 1 @ 107.35 |
| June 19, 2026 | issue | SO-260619-528 | EAST | 8 | 107.35 | -858.83 | 137 | 14,208.11 | April 27, 2026: 8 @ 107.35 |
| June 15, 2026 | issue | SO-260615-235 | EAST | 7 | 107.35 | -751.48 | 145 | 15,066.94 | April 27, 2026: 7 @ 107.35 |
| June 10, 2026 | transfer | TRF | MAIN → EAST | 33 | warehouse transfer, no cost effect | ||||
| June 10, 2026 | receipt | PO-001567 | MAIN | 110 | 102.81 | 11,309.56 | 152 | 15,818.42 | |
| June 8, 2026 | issue | SO-260608-559 | MAIN | 7 | 107.35 | -751.48 | 42 | 4,508.86 | April 27, 2026: 7 @ 107.35 |
| June 5, 2026 | issue | SO-260605-482 | MAIN | 1 | 107.35 | -107.35 | 49 | 5,260.33 | April 27, 2026: 1 @ 107.35 |
| June 2, 2026 | issue | SO-260602-917 | MAIN | 35 | 107.35 | -3,757.38 | 50 | 5,367.68 | April 27, 2026: 35 @ 107.35 |
| May 27, 2026 | issue | SO-260527-774 | MAIN | 15 | 107.35 | -1,610.31 | 85 | 9,125.06 | April 27, 2026: 15 @ 107.35 |
| May 26, 2026 | issue | SO-260526-152 | MAIN | 1 | 107.35 | -107.35 | 100 | 10,735.37 | April 27, 2026: 1 @ 107.35 |
| May 21, 2026 | issue | SO-260521-107 | MAIN | 5 | 107.35 | -536.77 | 101 | 10,842.72 | April 27, 2026: 5 @ 107.35 |
| May 5, 2026 | issue | SO-260505-168 | MAIN | 17 | 103.76 | -1,764.00 | 106 | 11,379.49 | March 12, 2026: 15 @ 103.74; April 19, 2026: 2 @ 103.92 |
| May 1, 2026 | issue | SO-260501-813 | MAIN | 6 | 103.74 | -622.46 | 123 | 13,143.49 | March 12, 2026: 6 @ 103.74 |
| April 29, 2026 | issue | SO-260429-792 | MAIN | 13 | 103.74 | -1,348.67 | 129 | 13,765.95 | March 12, 2026: 13 @ 103.74 |
| April 29, 2026 | issue | SO-260429-792 | EAST | 2 | 103.74 | -207.49 | 142 | 15,114.62 | March 12, 2026: 2 @ 103.74 |
| April 27, 2026 | receipt | PO-001442 | MAIN | 106 | 107.35 | 11,379.49 | 144 | 15,322.10 | |
| April 26, 2026 | issue | SO-260426-429 | EAST | 1 | 103.74 | -103.74 | 38 | 3,942.61 | March 12, 2026: 1 @ 103.74 |
| April 24, 2026 | issue | SO-260424-293 | MAIN | 1 | 103.74 | -103.74 | 39 | 4,046.36 | March 12, 2026: 1 @ 103.74 |
| April 19, 2026 | return | RMA | MAIN | 2 | 103.92 | 207.85 | 40 | 4,150.10 | |
| April 18, 2026 | issue | SO-260418-641 | MAIN | 6 | 103.92 | -623.54 | 38 | 3,942.25 | Feb. 26, 2026: 1 @ 104.82; March 12, 2026: 5 @ 103.74 |
| April 4, 2026 | issue | SO-260404-815 | MAIN | 4 | 104.82 | -419.29 | 44 | 4,565.79 | Feb. 26, 2026: 4 @ 104.82 |
| April 3, 2026 | issue | SO-260403-440 | MAIN | 2 | 104.82 | -209.64 | 48 | 4,985.08 | Feb. 26, 2026: 2 @ 104.82 |
| March 31, 2026 | issue | SO-260331-990 | EAST | 6 | 104.82 | -628.93 | 50 | 5,194.72 | Feb. 26, 2026: 6 @ 104.82 |
| March 22, 2026 | issue | SO-260322-757 | MAIN | 2 | 104.82 | -209.64 | 56 | 5,823.65 | Feb. 26, 2026: 2 @ 104.82 |
| March 16, 2026 | issue | SO-260316-515 | MAIN | 1 | 104.82 | -104.82 | 58 | 6,033.30 | Feb. 26, 2026: 1 @ 104.82 |
| March 13, 2026 | issue | SO-260313-128 | MAIN | 7 | 104.82 | -733.75 | 59 | 6,138.12 | Feb. 26, 2026: 7 @ 104.82 |
| March 12, 2026 | receipt | PO-001308 | MAIN | 43 | 103.74 | 4,460.97 | 66 | 6,871.87 | |
| March 3, 2026 | issue | SO-260303-861 | MAIN | 3 | 104.82 | -314.47 | 23 | 2,410.90 | Feb. 26, 2026: 3 @ 104.82 |
| March 1, 2026 | issue | SO-260301-825 | MAIN | 3 | 106.24 | -318.72 | 26 | 2,725.36 | Jan. 5, 2026: 2 @ 106.95; Feb. 26, 2026: 1 @ 104.82 |
| Feb. 26, 2026 | transfer | TRF | MAIN → EAST | 7 | warehouse transfer, no cost effect | ||||
| Feb. 26, 2026 | receipt | PO-001261 | MAIN | 27 | 104.82 | 2,830.19 | 29 | 3,044.09 | |
| Feb. 25, 2026 | issue | SO-260225-791 | EAST | 1 | 106.95 | -106.95 | 2 | 213.90 | Jan. 5, 2026: 1 @ 106.95 |
| Feb. 23, 2026 | issue | SO-260223-658 | EAST | 3 | 106.95 | -320.85 | 3 | 320.85 | Jan. 5, 2026: 3 @ 106.95 |
| Feb. 23, 2026 | issue | SO-260223-658 | MAIN | 1 | 106.95 | -106.95 | 6 | 641.71 | Jan. 5, 2026: 1 @ 106.95 |
| Feb. 21, 2026 | issue | SO-260221-970 | EAST | 2 | 106.95 | -213.90 | 7 | 748.66 | Jan. 5, 2026: 2 @ 106.95 |
| Feb. 20, 2026 | issue | SO-260220-608 | MAIN | 1 | 106.95 | -106.95 | 9 | 962.56 | Jan. 5, 2026: 1 @ 106.95 |
| Feb. 13, 2026 | issue | SO-260213-405 | MAIN | 1 | 106.95 | -106.95 | 10 | 1,069.51 | Jan. 5, 2026: 1 @ 106.95 |
| Feb. 6, 2026 | issue | SO-260206-907 | MAIN | 6 | 106.95 | -641.71 | 11 | 1,176.46 | Jan. 5, 2026: 6 @ 106.95 |
| Jan. 24, 2026 | issue | SO-260124-699 | MAIN | 10 | 103.51 | -1,035.12 | 17 | 1,818.17 | Sept. 28, 2025: 5 @ 100.07; Jan. 5, 2026: 5 @ 106.95 |
| Jan. 7, 2026 | issue | SO-260107-863 | EAST | 2 | 100.07 | -200.14 | 27 | 2,853.28 | Sept. 28, 2025: 2 @ 100.07 |
| Jan. 5, 2026 | transfer | TRF | MAIN → EAST | 5 | warehouse transfer, no cost effect | ||||
| Jan. 5, 2026 | receipt | PO-001123 | MAIN | 22 | 106.95 | 2,352.92 | 29 | 3,053.43 | |
| Dec. 29, 2025 | issue | SO-251229-777 | MAIN | 2 | 100.07 | -200.14 | 7 | 700.51 | Sept. 28, 2025: 2 @ 100.07 |
| Dec. 28, 2025 | issue | SO-251228-331 | MAIN | 1 | 100.07 | -100.07 | 9 | 900.65 | Sept. 28, 2025: 1 @ 100.07 |
| Dec. 27, 2025 | issue | SO-251227-714 | MAIN | 1 | 100.07 | -100.07 | 10 | 1,000.72 | Sept. 28, 2025: 1 @ 100.07 |
| Dec. 17, 2025 | issue | SO-251217-593 | EAST | 1 | 100.07 | -100.07 | 11 | 1,100.79 | Sept. 28, 2025: 1 @ 100.07 |