Items / FAN-0007
Wall Fan 400mm Elite FAN-0007 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)50MAIN 50
Value (FIFO)5,092.30avg 101.85
ClassAY / FCV 0.90
Turnover4.7xlast issue 1 days ago
Days of cover52lead time 22d
Reorder suggested: 40 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 | 29.25 / 30.4375 | 0.961 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 26.34 / 5.517 | 4.775 |
| 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 * 4.775^2 + 0.961^2 * 7.4^2) | 47.8 |
| Reorder point | d * LT + safety stock | 0.961 * 21.5 + 47.8 | 68.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 68.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 351/yr, S = 45.00, h = 20%, price = 101.75 | 39.4 |
| Inventory position | on hand + on order | 50 + 0 | 50 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 101.75 | 39 | 36,491 | yes (chosen if cheapest) |
MOQ 16, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 1, 2026 | 50 / 96 | 101.85 | 5,092.30 |
Movement ledger 125 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-226 | MAIN | 5 | 101.85 | -509.23 | 50 | 5,092.30 | July 1, 2026: 5 @ 101.85 |
| Oct. 9, 2026 | issue | SO-261009-292 | MAIN | 4 | 101.85 | -407.38 | 55 | 5,601.52 | July 1, 2026: 4 @ 101.85 |
| Oct. 4, 2026 | issue | SO-261004-285 | MAIN | 2 | 101.85 | -203.69 | 59 | 6,008.91 | July 1, 2026: 2 @ 101.85 |
| Sept. 22, 2026 | issue | SO-260922-544 | MAIN | 2 | 101.85 | -203.69 | 61 | 6,212.60 | July 1, 2026: 2 @ 101.85 |
| Sept. 9, 2026 | issue | SO-260909-998 | MAIN | 11 | 101.85 | -1,120.30 | 63 | 6,416.29 | July 1, 2026: 11 @ 101.85 |
| Aug. 29, 2026 | issue | SO-260829-273 | MAIN | 6 | 101.85 | -611.08 | 74 | 7,536.60 | July 1, 2026: 6 @ 101.85 |
| Aug. 29, 2026 | issue | SO-260829-273 | EAST | 6 | 101.85 | -611.08 | 80 | 8,147.67 | July 1, 2026: 6 @ 101.85 |
| Aug. 5, 2026 | issue | SO-260805-468 | EAST | 11 | 101.74 | -1,119.14 | 86 | 8,758.75 | May 20, 2026: 1 @ 100.68; July 1, 2026: 10 @ 101.85 |
| July 13, 2026 | issue | SO-260713-422 | EAST | 13 | 100.68 | -1,308.87 | 97 | 9,877.89 | May 20, 2026: 13 @ 100.68 |
| July 12, 2026 | issue | SO-260712-756 | MAIN | 20 | 100.68 | -2,013.65 | 110 | 11,186.76 | May 20, 2026: 20 @ 100.68 |
| July 6, 2026 | issue | SO-260706-640 | EAST | 1 | 100.68 | -100.68 | 130 | 13,200.41 | May 20, 2026: 1 @ 100.68 |
| July 1, 2026 | issue | SO-260701-399 | MAIN | 4 | 100.68 | -402.73 | 131 | 13,301.09 | May 20, 2026: 4 @ 100.68 |
| July 1, 2026 | transfer | TRF | MAIN → EAST | 31 | warehouse transfer, no cost effect | ||||
| July 1, 2026 | receipt | PO-001615 | MAIN | 96 | 101.85 | 9,777.21 | 135 | 13,703.82 | |
| June 29, 2026 | issue | SO-260629-718 | MAIN | 96 | 100.62 | -9,659.60 | 39 | 3,926.62 | March 30, 2026: 9 @ 100.96; April 14, 2026: 2 @ 96.48; May 20, 2026: 85 @ 100.68 |
| June 20, 2026 | issue | SO-260620-970 | MAIN | 7 | 100.96 | -706.70 | 135 | 13,586.21 | March 30, 2026: 7 @ 100.96 |
| May 24, 2026 | issue | SO-260524-277 | MAIN | 1 | 100.96 | -100.96 | 142 | 14,292.92 | March 30, 2026: 1 @ 100.96 |
| May 21, 2026 | issue | SO-260521-422 | MAIN | 6 | 100.96 | -605.75 | 143 | 14,393.88 | March 30, 2026: 6 @ 100.96 |
| May 21, 2026 | issue | SO-260521-422 | EAST | 5 | 100.96 | -504.79 | 149 | 14,999.62 | March 30, 2026: 5 @ 100.96 |
| May 20, 2026 | receipt | PO-001511 | MAIN | 124 | 100.68 | 12,484.63 | 154 | 15,504.41 | |
| May 19, 2026 | issue | SO-260519-247 | EAST | 21 | 100.96 | -2,120.11 | 30 | 3,019.78 | March 30, 2026: 21 @ 100.96 |
| May 13, 2026 | issue | SO-260513-157 | EAST | 1 | 100.96 | -100.96 | 51 | 5,139.90 | March 30, 2026: 1 @ 100.96 |
| May 7, 2026 | issue | SO-260507-337 | MAIN | 8 | 100.96 | -807.66 | 52 | 5,240.85 | March 30, 2026: 8 @ 100.96 |
| May 1, 2026 | issue | SO-260501-104 | MAIN | 15 | 100.96 | -1,514.37 | 60 | 6,048.52 | March 30, 2026: 15 @ 100.96 |
| April 16, 2026 | issue | SO-260416-559 | MAIN | 17 | 99.55 | -1,692.36 | 75 | 7,562.88 | Aug. 3, 2025: 4 @ 95.97; Sept. 4, 2025: 1 @ 97.00; March 30, 2026: 12 @ 100.96 |
| April 14, 2026 | return | RMA | MAIN | 2 | 96.48 | 192.96 | 92 | 9,255.24 | |
| April 14, 2026 | issue | SO-260414-223 | MAIN | 20 | 96.48 | -1,929.63 | 90 | 9,062.28 | July 6, 2025: 10 @ 97.00; Aug. 3, 2025: 10 @ 95.97 |
| April 13, 2026 | issue | SO-260413-704 | MAIN | 2 | 97.00 | -193.99 | 110 | 10,991.91 | July 6, 2025: 2 @ 97.00 |
| March 30, 2026 | transfer | TRF | MAIN → EAST | 27 | warehouse transfer, no cost effect | ||||
| March 30, 2026 | receipt | PO-001367 | MAIN | 85 | 100.96 | 8,581.41 | 112 | 11,185.90 | |
| March 29, 2026 | issue | SO-260329-664 | MAIN | 4 | 97.00 | -387.99 | 27 | 2,604.49 | July 6, 2025: 4 @ 97.00 |
| March 17, 2026 | issue | SO-260317-300 | MAIN | 14 | 97.00 | -1,357.95 | 31 | 2,992.47 | July 6, 2025: 14 @ 97.00 |
| March 8, 2026 | issue | SO-260308-468 | MAIN | 2 | 97.00 | -193.99 | 45 | 4,350.43 | July 6, 2025: 2 @ 97.00 |
| Feb. 27, 2026 | issue | SO-260227-338 | MAIN | 4 | 97.00 | -387.99 | 47 | 4,544.42 | July 6, 2025: 4 @ 97.00 |
| Feb. 22, 2026 | issue | SO-260222-269 | MAIN | 3 | 97.00 | -290.99 | 51 | 4,932.41 | July 6, 2025: 3 @ 97.00 |
| Feb. 20, 2026 | issue | SO-260220-269 | MAIN | 1 | 97.00 | -97.00 | 54 | 5,223.40 | July 6, 2025: 1 @ 97.00 |
| Feb. 17, 2026 | issue | SO-260217-437 | MAIN | 8 | 97.00 | -775.97 | 55 | 5,320.40 | July 6, 2025: 8 @ 97.00 |
| Jan. 30, 2026 | issue | SO-260130-438 | MAIN | 2 | 97.00 | -193.99 | 63 | 6,096.37 | July 6, 2025: 2 @ 97.00 |
| Jan. 27, 2026 | issue | SO-260127-652 | MAIN | 7 | 97.00 | -678.98 | 65 | 6,290.36 | July 6, 2025: 7 @ 97.00 |
| Jan. 24, 2026 | issue | SO-260124-150 | MAIN | 2 | 97.00 | -193.99 | 72 | 6,969.34 | July 6, 2025: 2 @ 97.00 |
| Jan. 23, 2026 | issue | SO-260123-741 | MAIN | 5 | 97.00 | -484.98 | 74 | 7,163.33 | July 6, 2025: 5 @ 97.00 |
| Jan. 7, 2026 | issue | SO-260107-142 | MAIN | 1 | 97.00 | -97.00 | 79 | 7,648.32 | July 6, 2025: 1 @ 97.00 |
| Jan. 1, 2026 | issue | SO-260101-667 | MAIN | 1 | 97.00 | -97.00 | 80 | 7,745.31 | July 6, 2025: 1 @ 97.00 |
| Dec. 31, 2025 | issue | SO-251231-675 | MAIN | 4 | 97.00 | -387.99 | 81 | 7,842.31 | July 6, 2025: 4 @ 97.00 |
| Dec. 30, 2025 | issue | SO-251230-369 | MAIN | 1 | 97.00 | -97.00 | 85 | 8,230.30 | July 6, 2025: 1 @ 97.00 |
| Dec. 22, 2025 | issue | SO-251222-492 | MAIN | 1 | 97.00 | -97.00 | 86 | 8,327.29 | July 6, 2025: 1 @ 97.00 |
| Dec. 17, 2025 | issue | SO-251217-544 | MAIN | 1 | 97.00 | -97.00 | 87 | 8,424.29 | July 6, 2025: 1 @ 97.00 |
| Dec. 14, 2025 | issue | SO-251214-866 | MAIN | 1 | 97.00 | -97.00 | 88 | 8,521.29 | July 6, 2025: 1 @ 97.00 |
| Nov. 24, 2025 | issue | SO-251124-895 | MAIN | 2 | 97.00 | -193.99 | 89 | 8,618.28 | July 6, 2025: 2 @ 97.00 |
| Nov. 3, 2025 | issue | SO-251103-694 | MAIN | 4 | 97.00 | -387.99 | 91 | 8,812.28 | July 6, 2025: 4 @ 97.00 |
| Oct. 31, 2025 | issue | SO-251031-228 | MAIN | 2 | 97.00 | -193.99 | 95 | 9,200.26 | July 6, 2025: 2 @ 97.00 |
| Oct. 28, 2025 | issue | SO-251028-213 | MAIN | 4 | 97.00 | -387.99 | 97 | 9,394.26 | July 6, 2025: 4 @ 97.00 |
| Oct. 21, 2025 | issue | SO-251021-873 | MAIN | 3 | 97.00 | -290.99 | 101 | 9,782.24 | July 6, 2025: 3 @ 97.00 |
| Oct. 10, 2025 | issue | SO-251010-992 | MAIN | 1 | 97.00 | -97.00 | 104 | 10,073.23 | July 6, 2025: 1 @ 97.00 |
| Oct. 3, 2025 | issue | SO-251003-443 | MAIN | 2 | 97.00 | -193.99 | 105 | 10,170.23 | July 6, 2025: 2 @ 97.00 |
| Sept. 26, 2025 | issue | SO-250926-560 | MAIN | 1 | 97.00 | -97.00 | 107 | 10,364.22 | July 6, 2025: 1 @ 97.00 |
| Sept. 23, 2025 | issue | SO-250923-531 | MAIN | 2 | 97.00 | -193.99 | 108 | 10,461.22 | July 6, 2025: 2 @ 97.00 |
| Sept. 15, 2025 | issue | SO-250915-309 | MAIN | 5 | 97.00 | -484.98 | 110 | 10,655.21 | July 6, 2025: 5 @ 97.00 |
| Sept. 14, 2025 | issue | SO-250914-507 | MAIN | 4 | 97.00 | -387.99 | 115 | 11,140.20 | July 6, 2025: 4 @ 97.00 |
| Sept. 12, 2025 | issue | SO-250912-122 | MAIN | 2 | 97.00 | -193.99 | 119 | 11,528.18 | July 6, 2025: 2 @ 97.00 |