Items / FAN-0010
Decorative Ceiling Fan Pro FAN-0010 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)7MAIN 7
Value (FIFO)677.29avg 96.76
ClassBY / FCV 0.67
Turnover48.6xlast issue 0 days ago
Days of cover10lead time 22d
Reorder suggested: 35 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 | 21.75 / 30.4375 | 0.715 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 14.60 / 5.517 | 2.645 |
| 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.645^2 + 0.715^2 * 7.4^2) | 22.0 |
| Reorder point | d * LT + safety stock | 0.715 * 21.5 + 22.0 | 37.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 37.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 261/yr, S = 45.00, h = 20%, price = 98.30 | 34.6 |
| Inventory position | on hand + on order | 7 + 0 | 7 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 98.30 | 35 | 26,318 | yes (chosen if cheapest) |
MOQ 12, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 14, 2026 | 7 / 26 | 96.76 | 677.29 |
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-448 | MAIN | 6 | 96.76 | -580.54 | 7 | 677.29 | Sept. 14, 2026: 6 @ 96.76 |
| Oct. 6, 2026 | issue | SO-261006-233 | MAIN | 1 | 96.76 | -96.76 | 13 | 1,257.83 | Sept. 14, 2026: 1 @ 96.76 |
| Oct. 3, 2026 | issue | SO-261003-870 | MAIN | 1 | 96.76 | -96.76 | 14 | 1,354.58 | Sept. 14, 2026: 1 @ 96.76 |
| Sept. 28, 2026 | issue | SO-260928-286 | MAIN | 5 | 96.76 | -483.78 | 15 | 1,451.34 | Sept. 14, 2026: 5 @ 96.76 |
| Sept. 23, 2026 | issue | SO-260923-178 | MAIN | 5 | 96.76 | -483.78 | 20 | 1,935.12 | Sept. 14, 2026: 5 @ 96.76 |
| Sept. 16, 2026 | issue | SO-260916-282 | MAIN | 1 | 96.76 | -96.76 | 25 | 2,418.90 | Sept. 14, 2026: 1 @ 96.76 |
| Sept. 14, 2026 | receipt | PO-001800 | MAIN | 26 | 96.76 | 2,515.65 | 26 | 2,515.65 | |
| Sept. 5, 2026 | issue | SO-260905-397 | MAIN | 1 | 95.10 | -95.10 | 0 | 0.00 | June 7, 2026: 1 @ 95.10 |
| Aug. 24, 2026 | issue | SO-260824-988 | MAIN | 12 | 94.97 | -1,139.64 | 1 | 95.10 | June 3, 2026: 12 @ 94.97 |
| Aug. 17, 2026 | issue | SO-260817-581 | MAIN | 1 | 94.97 | -94.97 | 13 | 1,234.75 | June 3, 2026: 1 @ 94.97 |
| Aug. 14, 2026 | issue | SO-260814-939 | MAIN | 15 | 94.97 | -1,424.56 | 14 | 1,329.72 | June 3, 2026: 15 @ 94.97 |
| Aug. 6, 2026 | issue | SO-260806-222 | MAIN | 1 | 94.97 | -94.97 | 29 | 2,754.27 | June 3, 2026: 1 @ 94.97 |
| Aug. 3, 2026 | issue | SO-260803-469 | MAIN | 2 | 94.97 | -189.94 | 30 | 2,849.24 | June 3, 2026: 2 @ 94.97 |
| July 31, 2026 | issue | SO-260731-892 | MAIN | 25 | 94.97 | -2,374.26 | 32 | 3,039.18 | June 3, 2026: 25 @ 94.97 |
| July 14, 2026 | issue | SO-260714-749 | MAIN | 13 | 94.97 | -1,234.62 | 57 | 5,413.44 | June 3, 2026: 13 @ 94.97 |
| July 5, 2026 | issue | SO-260705-770 | MAIN | 5 | 94.97 | -474.85 | 70 | 6,648.06 | June 3, 2026: 5 @ 94.97 |
| June 18, 2026 | issue | SO-260618-827 | MAIN | 1 | 94.97 | -94.97 | 75 | 7,122.91 | June 3, 2026: 1 @ 94.97 |
| June 15, 2026 | issue | SO-260615-430 | MAIN | 10 | 94.97 | -949.70 | 76 | 7,217.88 | June 3, 2026: 10 @ 94.97 |
| June 10, 2026 | issue | SO-260610-821 | MAIN | 37 | 95.06 | -3,517.21 | 86 | 8,167.59 | April 12, 2026: 25 @ 95.10; June 3, 2026: 12 @ 94.97 |
| June 7, 2026 | return | RMA | MAIN | 1 | 95.10 | 95.10 | 123 | 11,684.80 | |
| June 3, 2026 | receipt | PO-001545 | MAIN | 97 | 94.97 | 9,212.13 | 122 | 11,589.69 | |
| May 31, 2026 | issue | SO-260531-303 | MAIN | 12 | 95.10 | -1,141.23 | 25 | 2,377.56 | April 12, 2026: 12 @ 95.10 |
| May 29, 2026 | issue | SO-260529-112 | MAIN | 7 | 95.10 | -665.72 | 37 | 3,518.80 | April 12, 2026: 7 @ 95.10 |
| May 24, 2026 | issue | SO-260524-885 | MAIN | 7 | 95.10 | -665.72 | 44 | 4,184.51 | April 12, 2026: 7 @ 95.10 |
| May 19, 2026 | issue | SO-260519-131 | MAIN | 3 | 95.10 | -285.31 | 51 | 4,850.23 | April 12, 2026: 3 @ 95.10 |
| May 9, 2026 | issue | SO-260509-110 | MAIN | 7 | 95.10 | -665.72 | 54 | 5,135.54 | April 12, 2026: 7 @ 95.10 |
| May 9, 2026 | issue | SO-260509-110 | EAST | 1 | 95.10 | -95.10 | 61 | 5,801.26 | April 12, 2026: 1 @ 95.10 |
| April 20, 2026 | issue | SO-260420-265 | MAIN | 2 | 94.84 | -189.69 | 62 | 5,896.36 | March 9, 2026: 1 @ 94.58; April 12, 2026: 1 @ 95.10 |
| April 19, 2026 | issue | SO-260419-958 | EAST | 1 | 94.58 | -94.58 | 64 | 6,086.05 | March 9, 2026: 1 @ 94.58 |
| April 16, 2026 | issue | SO-260416-731 | MAIN | 3 | 94.58 | -283.75 | 65 | 6,180.63 | March 9, 2026: 3 @ 94.58 |
| April 15, 2026 | issue | SO-260415-581 | EAST | 12 | 94.58 | -1,135.01 | 68 | 6,464.38 | March 9, 2026: 12 @ 94.58 |
| April 14, 2026 | issue | SO-260414-207 | MAIN | 2 | 94.58 | -189.17 | 80 | 7,599.39 | March 9, 2026: 2 @ 94.58 |
| April 12, 2026 | transfer | TRF | MAIN → EAST | 14 | warehouse transfer, no cost effect | ||||
| April 12, 2026 | receipt | PO-001402 | MAIN | 63 | 95.10 | 5,991.46 | 82 | 7,788.56 | |
| April 6, 2026 | issue | SO-260406-106 | MAIN | 1 | 94.58 | -94.58 | 19 | 1,797.09 | March 9, 2026: 1 @ 94.58 |
| April 3, 2026 | issue | SO-260403-101 | MAIN | 4 | 94.58 | -378.34 | 20 | 1,891.68 | March 9, 2026: 4 @ 94.58 |
| April 3, 2026 | issue | SO-260403-101 | EAST | 6 | 94.58 | -567.50 | 24 | 2,270.01 | March 9, 2026: 6 @ 94.58 |
| March 27, 2026 | issue | SO-260327-667 | MAIN | 3 | 94.58 | -283.75 | 30 | 2,837.51 | March 9, 2026: 3 @ 94.58 |
| March 26, 2026 | issue | SO-260326-901 | MAIN | 3 | 94.58 | -283.75 | 33 | 3,121.27 | March 9, 2026: 3 @ 94.58 |
| March 20, 2026 | issue | SO-260320-392 | EAST | 1 | 94.58 | -94.58 | 36 | 3,405.02 | March 9, 2026: 1 @ 94.58 |
| March 18, 2026 | issue | SO-260318-853 | EAST | 2 | 96.25 | -192.50 | 37 | 3,499.60 | March 4, 2026: 1 @ 97.92; March 9, 2026: 1 @ 94.58 |
| March 16, 2026 | issue | SO-260316-942 | MAIN | 2 | 97.92 | -195.84 | 39 | 3,692.10 | March 4, 2026: 2 @ 97.92 |
| March 11, 2026 | issue | SO-260311-369 | MAIN | 4 | 97.92 | -391.67 | 41 | 3,887.94 | Feb. 3, 2026: 3 @ 97.92; March 4, 2026: 1 @ 97.92 |
| March 9, 2026 | transfer | TRF | MAIN → EAST | 9 | warehouse transfer, no cost effect | ||||
| March 9, 2026 | receipt | PO-001299 | MAIN | 38 | 94.58 | 3,594.18 | 45 | 4,279.61 | |
| March 4, 2026 | return | RMA | MAIN | 4 | 97.92 | 391.67 | 7 | 685.42 | |
| March 4, 2026 | issue | SO-260304-911 | MAIN | 1 | 97.92 | -97.92 | 3 | 293.75 | Feb. 3, 2026: 1 @ 97.92 |
| Feb. 18, 2026 | issue | SO-260218-108 | MAIN | 8 | 97.92 | -783.34 | 4 | 391.67 | Feb. 3, 2026: 8 @ 97.92 |
| Feb. 12, 2026 | issue | SO-260212-770 | MAIN | 4 | 97.92 | -391.67 | 12 | 1,175.01 | Feb. 3, 2026: 4 @ 97.92 |
| Feb. 11, 2026 | issue | SO-260211-396 | MAIN | 2 | 97.92 | -195.84 | 16 | 1,566.68 | Feb. 3, 2026: 2 @ 97.92 |
| Feb. 8, 2026 | issue | SO-260208-585 | MAIN | 5 | 97.92 | -489.59 | 18 | 1,762.52 | Feb. 3, 2026: 5 @ 97.92 |
| Feb. 3, 2026 | receipt | PO-001195 | MAIN | 23 | 97.92 | 2,252.11 | 23 | 2,252.11 | |
| Jan. 21, 2026 | issue | SO-260121-549 | EAST | 1 | 94.26 | -94.26 | 0 | 0.00 | Nov. 2, 2025: 1 @ 94.26 |
| Jan. 19, 2026 | issue | SO-260119-648 | EAST | 2 | 94.26 | -188.51 | 1 | 94.26 | Nov. 2, 2025: 2 @ 94.26 |
| Jan. 17, 2026 | issue | SO-260117-283 | EAST | 1 | 94.26 | -94.26 | 3 | 282.77 | Nov. 2, 2025: 1 @ 94.26 |
| Jan. 17, 2026 | issue | SO-260117-283 | MAIN | 2 | 94.26 | -188.51 | 4 | 377.02 | Nov. 2, 2025: 2 @ 94.26 |
| Jan. 13, 2026 | issue | SO-260113-110 | MAIN | 5 | 94.26 | -471.28 | 6 | 565.53 | Nov. 2, 2025: 5 @ 94.26 |
| Dec. 10, 2025 | issue | SO-251210-107 | MAIN | 1 | 94.26 | -94.26 | 11 | 1,036.81 | Nov. 2, 2025: 1 @ 94.26 |
| Dec. 5, 2025 | issue | SO-251205-441 | MAIN | 2 | 94.26 | -188.51 | 12 | 1,131.06 | Nov. 2, 2025: 2 @ 94.26 |
| Dec. 1, 2025 | issue | SO-251201-316 | MAIN | 2 | 94.26 | -188.51 | 14 | 1,319.57 | Nov. 2, 2025: 2 @ 94.26 |