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
| 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 |
| Oct. 2, 2025 | issue | SO-251002-728 | EAST | 1 | 187.08 | -187.08 | 24 | 4,489.98 | July 17, 2025: 1 @ 187.08 |
| Sept. 24, 2025 | issue | SO-250924-753 | EAST | 1 | 187.08 | -187.08 | 25 | 4,677.06 | July 17, 2025: 1 @ 187.08 |
| Sept. 17, 2025 | issue | SO-250917-504 | EAST | 1 | 187.08 | -187.08 | 26 | 4,864.14 | July 17, 2025: 1 @ 187.08 |
| Sept. 17, 2025 | issue | SO-250917-504 | MAIN | 4 | 187.08 | -748.33 | 27 | 5,051.22 | July 17, 2025: 4 @ 187.08 |
| Sept. 14, 2025 | issue | SO-250914-214 | MAIN | 3 | 187.08 | -561.25 | 31 | 5,799.55 | July 17, 2025: 3 @ 187.08 |
| Sept. 13, 2025 | issue | SO-250913-325 | MAIN | 2 | 187.08 | -374.16 | 34 | 6,360.80 | July 17, 2025: 2 @ 187.08 |
| Aug. 21, 2025 | issue | SO-250821-907 | MAIN | 10 | 187.08 | -1,870.82 | 36 | 6,734.96 | July 17, 2025: 10 @ 187.08 |
| Aug. 19, 2025 | issue | SO-250819-638 | MAIN | 1 | 187.08 | -187.08 | 46 | 8,605.79 | July 17, 2025: 1 @ 187.08 |
| Aug. 12, 2025 | issue | SO-250812-190 | EAST | 1 | 187.08 | -187.08 | 47 | 8,792.87 | July 17, 2025: 1 @ 187.08 |
| Aug. 4, 2025 | issue | SO-250804-130 | MAIN | 6 | 184.89 | -1,109.36 | 48 | 8,979.95 | June 7, 2025: 2 @ 180.52; July 17, 2025: 4 @ 187.08 |
| July 24, 2025 | issue | SO-250724-674 | MAIN | 10 | 180.52 | -1,805.18 | 54 | 10,089.31 | June 7, 2025: 10 @ 180.52 |
| July 17, 2025 | issue | SO-250717-611 | EAST | 6 | 180.52 | -1,083.10 | 64 | 11,894.49 | June 7, 2025: 6 @ 180.52 |
| July 17, 2025 | transfer | TRF | MAIN → EAST | 16 | warehouse transfer, no cost effect | ||||
| July 17, 2025 | receipt | PO-000718 | MAIN | 52 | 187.08 | 9,728.28 | 70 | 12,977.59 | |
| July 15, 2025 | issue | SO-250715-227 | EAST | 1 | 180.52 | -180.52 | 18 | 3,249.32 | June 7, 2025: 1 @ 180.52 |
| July 10, 2025 | issue | SO-250710-368 | EAST | 11 | 180.52 | -1,985.69 | 19 | 3,429.83 | June 7, 2025: 11 @ 180.52 |
| July 8, 2025 | issue | SO-250708-123 | EAST | 1 | 180.52 | -180.52 | 30 | 5,415.52 | June 7, 2025: 1 @ 180.52 |
| July 1, 2025 | issue | SO-250701-327 | MAIN | 3 | 180.52 | -541.55 | 31 | 5,596.04 | June 7, 2025: 3 @ 180.52 |
| June 23, 2025 | issue | SO-250623-804 | MAIN | 24 | 180.52 | -4,332.42 | 34 | 6,137.60 | June 7, 2025: 24 @ 180.52 |
| June 16, 2025 | issue | SO-250616-376 | MAIN | 22 | 180.31 | -3,966.89 | 58 | 10,470.02 | April 30, 2025: 9 @ 180.02; June 7, 2025: 13 @ 180.52 |
| June 7, 2025 | transfer | TRF | MAIN → EAST | 22 | warehouse transfer, no cost effect | ||||
| June 7, 2025 | receipt | PO-000612 | MAIN | 71 | 180.52 | 12,816.74 | 80 | 14,436.91 | |
| June 5, 2025 | issue | SO-250605-123 | EAST | 1 | 180.02 | -180.02 | 9 | 1,620.17 | April 30, 2025: 1 @ 180.02 |
| May 25, 2025 | issue | SO-250525-671 | EAST | 6 | 180.02 | -1,080.11 | 10 | 1,800.19 | April 30, 2025: 6 @ 180.02 |
| May 25, 2025 | issue | SO-250525-671 | MAIN | 3 | 180.02 | -540.06 | 16 | 2,880.30 | April 30, 2025: 3 @ 180.02 |
| May 18, 2025 | issue | SO-250518-385 | MAIN | 13 | 180.02 | -2,340.24 | 19 | 3,420.35 | April 30, 2025: 13 @ 180.02 |
| May 13, 2025 | issue | SO-250513-681 | MAIN | 13 | 180.02 | -2,340.24 | 32 | 5,760.60 | April 30, 2025: 13 @ 180.02 |
| April 30, 2025 | issue | SO-250430-356 | MAIN | 1 | 180.02 | -180.02 | 45 | 8,100.84 | April 30, 2025: 1 @ 180.02 |
| April 30, 2025 | transfer | TRF | MAIN → EAST | 16 | warehouse transfer, no cost effect | ||||
| April 30, 2025 | receipt | PO-000494 | MAIN | 46 | 180.02 | 8,280.86 | 46 | 8,280.86 | |
| April 27, 2025 | issue | SO-250427-430 | MAIN | 3 | 182.03 | -546.10 | 0 | 0.00 | March 14, 2025: 3 @ 182.03 |
| April 22, 2025 | issue | SO-250422-397 | MAIN | 1 | 182.03 | -182.03 | 3 | 546.10 | March 14, 2025: 1 @ 182.03 |
| April 17, 2025 | issue | SO-250417-141 | MAIN | 7 | 182.03 | -1,274.23 | 4 | 728.13 | March 14, 2025: 7 @ 182.03 |
| April 12, 2025 | issue | SO-250412-522 | MAIN | 9 | 182.03 | -1,638.29 | 11 | 2,002.36 | March 14, 2025: 9 @ 182.03 |
| March 31, 2025 | issue | SO-250331-179 | MAIN | 7 | 182.03 | -1,274.23 | 20 | 3,640.65 | March 14, 2025: 7 @ 182.03 |
| March 29, 2025 | issue | SO-250329-352 | MAIN | 3 | 179.24 | -537.71 | 27 | 4,914.87 | Jan. 29, 2025: 2 @ 177.84; March 14, 2025: 1 @ 182.03 |
| March 22, 2025 | issue | SO-250322-684 | MAIN | 4 | 177.84 | -711.35 | 30 | 5,452.58 | Jan. 29, 2025: 4 @ 177.84 |
| March 14, 2025 | receipt | PO-000340 | MAIN | 28 | 182.03 | 5,096.91 | 34 | 6,163.94 | |
| March 13, 2025 | issue | SO-250313-925 | MAIN | 2 | 177.84 | -355.68 | 6 | 1,067.03 | Jan. 29, 2025: 2 @ 177.84 |
| March 4, 2025 | issue | SO-250304-635 | MAIN | 1 | 177.84 | -177.84 | 8 | 1,422.71 | Jan. 29, 2025: 1 @ 177.84 |
| Feb. 24, 2025 | issue | SO-250224-648 | MAIN | 9 | 179.72 | -1,617.50 | 9 | 1,600.55 | Oct. 1, 2024: 4 @ 182.08; Jan. 29, 2025: 5 @ 177.84 |
| Feb. 7, 2025 | issue | SO-250207-400 | MAIN | 2 | 182.08 | -364.15 | 18 | 3,218.05 | Oct. 1, 2024: 2 @ 182.08 |
| Jan. 30, 2025 | issue | SO-250130-278 | MAIN | 1 | 182.08 | -182.08 | 20 | 3,582.20 | Oct. 1, 2024: 1 @ 182.08 |
| Jan. 29, 2025 | receipt | PO-000228 | MAIN | 14 | 177.84 | 2,489.74 | 21 | 3,764.28 | |
| Jan. 10, 2025 | issue | SO-250110-388 | MAIN | 10 | 182.08 | -1,820.77 | 7 | 1,274.54 | Oct. 1, 2024: 10 @ 182.08 |
| Dec. 30, 2024 | issue | SO-241230-444 | MAIN | 1 | 182.08 | -182.08 | 17 | 3,095.31 | Oct. 1, 2024: 1 @ 182.08 |
| Dec. 17, 2024 | issue | SO-241217-193 | MAIN | 3 | 182.08 | -546.23 | 18 | 3,277.39 | Oct. 1, 2024: 3 @ 182.08 |
| Dec. 2, 2024 | issue | SO-241202-587 | MAIN | 1 | 182.08 | -182.08 | 21 | 3,823.62 | Oct. 1, 2024: 1 @ 182.08 |
| Nov. 29, 2024 | issue | SO-241129-631 | MAIN | 1 | 182.08 | -182.08 | 22 | 4,005.69 | Oct. 1, 2024: 1 @ 182.08 |
| Nov. 15, 2024 | issue | SO-241115-335 | MAIN | 3 | 182.08 | -546.23 | 23 | 4,187.77 | Oct. 1, 2024: 3 @ 182.08 |
| Nov. 3, 2024 | issue | SO-241103-699 | MAIN | 1 | 182.08 | -182.08 | 26 | 4,734.00 | Oct. 1, 2024: 1 @ 182.08 |
| Oct. 11, 2024 | issue | SO-241011-287 | MAIN | 5 | 182.08 | -910.38 | 27 | 4,916.08 | Oct. 1, 2024: 5 @ 182.08 |
| Oct. 2, 2024 | issue | SO-241002-144 | MAIN | 2 | 182.08 | -364.15 | 32 | 5,826.46 | Oct. 1, 2024: 2 @ 182.08 |
| Oct. 1, 2024 | receipt | PO-000003 | MAIN | 34 | 182.08 | 6,190.62 | 34 | 6,190.62 | |