Items / FAN-0022
Decorative Ceiling Fan Nova FAN-0022 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)3MAIN 3
Value (FIFO)562.34avg 187.45
ClassAY / FCV 0.71
Turnover18.1xlast issue 10 days ago
Days of cover5lead time 22d
Reorder suggested: 44 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 | 17.17 / 30.4375 | 0.564 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 12.16 / 5.517 | 2.204 |
| 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 * 2.204^2 + 0.564^2 * 7.4^2) | 22.7 |
| Reorder point | d * LT + safety stock | 0.564 * 21.5 + 22.7 | 34.8 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 34.8 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 206/yr, S = 45.00, h = 20%, price = 191.66 | 22.0 |
| Inventory position | on hand + on order | 3 + 0 | 3 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 191.66 | 22 | 40,298 | yes (chosen if cheapest) |
MOQ 9, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 1, 2026 | 3 / 31 | 187.45 | 562.34 |
Movement ledger 114 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 6, 2026 | issue | SO-261006-628 | MAIN | 1 | 187.45 | -187.45 | 3 | 562.34 | Aug. 1, 2026: 1 @ 187.45 |
| Oct. 4, 2026 | issue | SO-261004-784 | MAIN | 5 | 187.45 | -937.23 | 4 | 749.78 | Aug. 1, 2026: 5 @ 187.45 |
| Sept. 22, 2026 | issue | SO-260922-513 | MAIN | 7 | 187.45 | -1,312.12 | 9 | 1,687.01 | Aug. 1, 2026: 7 @ 187.45 |
| Sept. 3, 2026 | issue | SO-260903-125 | MAIN | 2 | 187.45 | -374.89 | 16 | 2,999.13 | Aug. 1, 2026: 2 @ 187.45 |
| Aug. 13, 2026 | issue | SO-260813-777 | MAIN | 2 | 187.45 | -374.89 | 18 | 3,374.02 | Aug. 1, 2026: 2 @ 187.45 |
| Aug. 8, 2026 | issue | SO-260808-940 | MAIN | 3 | 187.45 | -562.34 | 20 | 3,748.91 | Aug. 1, 2026: 3 @ 187.45 |
| Aug. 6, 2026 | issue | SO-260806-719 | MAIN | 2 | 187.45 | -374.89 | 23 | 4,311.25 | Aug. 1, 2026: 2 @ 187.45 |
| Aug. 5, 2026 | issue | SO-260805-681 | MAIN | 5 | 187.45 | -937.23 | 25 | 4,686.14 | Aug. 1, 2026: 5 @ 187.45 |
| Aug. 2, 2026 | issue | SO-260802-910 | MAIN | 3 | 186.60 | -559.80 | 30 | 5,623.37 | May 8, 2026: 2 @ 186.18; Aug. 1, 2026: 1 @ 187.45 |
| Aug. 1, 2026 | issue | SO-260801-308 | MAIN | 1 | 186.18 | -186.18 | 33 | 6,183.17 | May 8, 2026: 1 @ 186.18 |
| Aug. 1, 2026 | receipt | PO-001689 | MAIN | 31 | 187.45 | 5,810.82 | 34 | 6,369.35 | |
| July 23, 2026 | issue | SO-260723-960 | MAIN | 1 | 186.18 | -186.18 | 3 | 558.53 | May 8, 2026: 1 @ 186.18 |
| July 20, 2026 | issue | SO-260720-282 | MAIN | 1 | 186.18 | -186.18 | 4 | 744.71 | May 8, 2026: 1 @ 186.18 |
| July 17, 2026 | issue | SO-260717-550 | MAIN | 12 | 186.18 | -2,234.12 | 5 | 930.88 | May 8, 2026: 12 @ 186.18 |
| July 16, 2026 | issue | SO-260716-960 | MAIN | 18 | 186.18 | -3,351.17 | 17 | 3,165.00 | May 8, 2026: 18 @ 186.18 |
| June 30, 2026 | issue | SO-260630-930 | MAIN | 1 | 186.18 | -186.18 | 35 | 6,516.17 | May 8, 2026: 1 @ 186.18 |
| June 23, 2026 | issue | SO-260623-129 | MAIN | 5 | 186.18 | -930.88 | 36 | 6,702.35 | May 8, 2026: 5 @ 186.18 |
| June 16, 2026 | issue | SO-260616-845 | MAIN | 3 | 186.18 | -558.53 | 41 | 7,633.23 | May 8, 2026: 3 @ 186.18 |
| June 9, 2026 | issue | SO-260609-685 | MAIN | 23 | 186.18 | -4,282.05 | 44 | 8,191.76 | May 8, 2026: 23 @ 186.18 |
| June 8, 2026 | issue | SO-260608-463 | MAIN | 1 | 186.18 | -186.18 | 67 | 12,473.81 | May 8, 2026: 1 @ 186.18 |
| June 1, 2026 | issue | SO-260601-503 | MAIN | 1 | 183.75 | -183.75 | 68 | 12,659.99 | April 7, 2026: 1 @ 183.75 |
| May 26, 2026 | issue | SO-260526-112 | MAIN | 7 | 183.75 | -1,286.28 | 69 | 12,843.74 | April 7, 2026: 7 @ 183.75 |
| May 25, 2026 | issue | SO-260525-118 | MAIN | 9 | 183.75 | -1,653.79 | 76 | 14,130.02 | April 7, 2026: 9 @ 183.75 |
| May 25, 2026 | issue | SO-260525-118 | EAST | 19 | 183.75 | -3,491.33 | 85 | 15,783.81 | April 7, 2026: 19 @ 183.75 |
| May 8, 2026 | transfer | TRF | MAIN → EAST | 19 | warehouse transfer, no cost effect | ||||
| May 8, 2026 | receipt | PO-001476 | MAIN | 68 | 186.18 | 12,659.99 | 104 | 19,275.14 | |
| April 17, 2026 | issue | SO-260417-584 | MAIN | 4 | 183.75 | -735.02 | 36 | 6,615.15 | April 7, 2026: 4 @ 183.75 |
| April 16, 2026 | issue | SO-260416-342 | MAIN | 7 | 183.57 | -1,284.96 | 40 | 7,350.16 | March 17, 2026: 1 @ 182.44; April 7, 2026: 6 @ 183.75 |
| April 10, 2026 | issue | SO-260410-555 | MAIN | 3 | 182.44 | -547.31 | 47 | 8,635.12 | March 17, 2026: 3 @ 182.44 |
| April 8, 2026 | issue | SO-260408-464 | MAIN | 16 | 182.44 | -2,918.96 | 50 | 9,182.43 | March 17, 2026: 16 @ 182.44 |
| April 7, 2026 | receipt | PO-001390 | MAIN | 46 | 183.75 | 8,452.69 | 66 | 12,101.39 | |
| April 5, 2026 | issue | SO-260405-481 | MAIN | 2 | 182.44 | -364.87 | 20 | 3,648.70 | March 17, 2026: 2 @ 182.44 |
| March 24, 2026 | issue | SO-260324-540 | MAIN | 11 | 185.27 | -2,037.95 | 22 | 4,013.57 | Feb. 6, 2026: 3 @ 188.67; March 1, 2026: 2 @ 188.67; March 17, 2026: 6 @ 182.44 |
| March 24, 2026 | issue | SO-260324-540 | EAST | 2 | 188.67 | -377.34 | 33 | 6,051.53 | Feb. 6, 2026: 2 @ 188.67 |
| March 19, 2026 | issue | SO-260319-258 | MAIN | 1 | 188.67 | -188.67 | 35 | 6,428.86 | Feb. 6, 2026: 1 @ 188.67 |
| March 17, 2026 | issue | SO-260317-805 | EAST | 5 | 188.67 | -943.34 | 36 | 6,617.53 | Feb. 6, 2026: 5 @ 188.67 |
| March 17, 2026 | transfer | TRF | MAIN → EAST | 7 | warehouse transfer, no cost effect | ||||
| March 17, 2026 | receipt | PO-001328 | MAIN | 28 | 182.44 | 5,108.19 | 41 | 7,560.87 | |
| March 2, 2026 | issue | SO-260302-867 | MAIN | 1 | 188.67 | -188.67 | 13 | 2,452.69 | Feb. 6, 2026: 1 @ 188.67 |
| March 1, 2026 | return | RMA | MAIN | 2 | 188.67 | 377.34 | 14 | 2,641.35 | |
| Feb. 22, 2026 | issue | SO-260222-348 | EAST | 4 | 188.67 | -754.67 | 12 | 2,264.02 | Feb. 6, 2026: 4 @ 188.67 |
| Feb. 9, 2026 | issue | SO-260209-986 | MAIN | 1 | 188.67 | -188.67 | 16 | 3,018.69 | Feb. 6, 2026: 1 @ 188.67 |
| Feb. 6, 2026 | transfer | TRF | MAIN → EAST | 4 | warehouse transfer, no cost effect | ||||
| Feb. 6, 2026 | receipt | PO-001202 | MAIN | 17 | 188.67 | 3,207.36 | 17 | 3,207.36 | |
| Feb. 5, 2026 | issue | SO-260205-737 | EAST | 5 | 187.08 | -935.41 | 0 | 0.00 | July 17, 2025: 4 @ 187.08; Feb. 2, 2026: 1 @ 187.08 |
| Feb. 4, 2026 | issue | SO-260204-179 | MAIN | 1 | 187.08 | -187.08 | 5 | 935.41 | July 17, 2025: 1 @ 187.08 |
| Feb. 2, 2026 | return | RMA | MAIN | 1 | 187.08 | 187.08 | 6 | 1,122.49 | |
| Jan. 23, 2026 | issue | SO-260123-468 | EAST | 1 | 187.08 | -187.08 | 5 | 935.41 | July 17, 2025: 1 @ 187.08 |
| Jan. 18, 2026 | issue | SO-260118-463 | EAST | 2 | 187.08 | -374.16 | 6 | 1,122.49 | July 17, 2025: 2 @ 187.08 |
| Jan. 16, 2026 | issue | SO-260116-372 | EAST | 2 | 187.08 | -374.16 | 8 | 1,496.66 | July 17, 2025: 2 @ 187.08 |
| Jan. 13, 2026 | issue | SO-260113-571 | EAST | 1 | 187.08 | -187.08 | 10 | 1,870.82 | July 17, 2025: 1 @ 187.08 |
| Dec. 26, 2025 | issue | SO-251226-876 | EAST | 1 | 187.08 | -187.08 | 11 | 2,057.91 | July 17, 2025: 1 @ 187.08 |
| Dec. 25, 2025 | issue | SO-251225-118 | EAST | 1 | 187.08 | -187.08 | 12 | 2,244.99 | July 17, 2025: 1 @ 187.08 |
| Nov. 30, 2025 | issue | SO-251130-198 | EAST | 1 | 187.08 | -187.08 | 13 | 2,432.07 | July 17, 2025: 1 @ 187.08 |
| Nov. 21, 2025 | issue | SO-251121-841 | EAST | 2 | 187.08 | -374.16 | 14 | 2,619.15 | July 17, 2025: 2 @ 187.08 |
| Nov. 15, 2025 | issue | SO-251115-355 | EAST | 1 | 187.08 | -187.08 | 16 | 2,993.32 | July 17, 2025: 1 @ 187.08 |
| Oct. 26, 2025 | issue | SO-251026-447 | EAST | 1 | 187.08 | -187.08 | 17 | 3,180.40 | July 17, 2025: 1 @ 187.08 |
| Oct. 22, 2025 | issue | SO-251022-814 | EAST | 1 | 187.08 | -187.08 | 18 | 3,367.48 | July 17, 2025: 1 @ 187.08 |
| Oct. 20, 2025 | issue | SO-251020-850 | EAST | 1 | 187.08 | -187.08 | 19 | 3,554.56 | July 17, 2025: 1 @ 187.08 |
| Oct. 12, 2025 | issue | SO-251012-565 | EAST | 4 | 187.08 | -748.33 | 20 | 3,741.65 | July 17, 2025: 4 @ 187.08 |