Items / FAN-0027
Decorative Ceiling Fan Plus FAN-0027 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)11MAIN 11
Value (FIFO)1,854.09avg 168.55
ClassBY / FCV 0.70
Turnover19.4xlast issue 0 days ago
Days of cover29lead time 22d
Reorder suggested: 19 units (position at or below reorder point: order EOQ), stockout risk medium.
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 | 11.42 / 30.4375 | 0.375 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 7.98 / 5.517 | 1.447 |
| 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 * 1.447^2 + 0.375^2 * 7.4^2) | 11.9 |
| Reorder point | d * LT + safety stock | 0.375 * 21.5 + 11.9 | 20.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 20.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 137/yr, S = 45.00, h = 20%, price = 171.36 | 19.0 |
| Inventory position | on hand + on order | 11 + 0 | 11 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 171.36 | 19 | 24,110 | yes (chosen if cheapest) |
MOQ 6, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 2, 2026 | 9 / 34 | 168.55 | 1,516.98 | |
| Oct. 4, 2026 | 2 / 2 | 168.55 | 337.11 |
Movement ledger 102 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 16, 2026 | issue | SO-261016-755 | MAIN | 1 | 168.55 | -168.55 | 11 | 1,854.09 | Aug. 2, 2026: 1 @ 168.55 |
| Oct. 15, 2026 | issue | SO-261015-969 | MAIN | 2 | 168.55 | -337.11 | 12 | 2,022.65 | Aug. 2, 2026: 2 @ 168.55 |
| Oct. 13, 2026 | issue | SO-261013-708 | MAIN | 1 | 168.55 | -168.55 | 14 | 2,359.75 | Aug. 2, 2026: 1 @ 168.55 |
| Oct. 12, 2026 | issue | SO-261012-486 | MAIN | 3 | 168.55 | -505.66 | 15 | 2,528.31 | Aug. 2, 2026: 3 @ 168.55 |
| Oct. 4, 2026 | return | RMA | MAIN | 2 | 168.55 | 337.11 | 18 | 3,033.97 | |
| Sept. 27, 2026 | issue | SO-260927-976 | MAIN | 1 | 168.55 | -168.55 | 16 | 2,696.86 | Aug. 2, 2026: 1 @ 168.55 |
| Sept. 19, 2026 | issue | SO-260919-432 | MAIN | 4 | 168.55 | -674.22 | 17 | 2,865.41 | Aug. 2, 2026: 4 @ 168.55 |
| Sept. 18, 2026 | issue | SO-260918-802 | MAIN | 1 | 168.55 | -168.55 | 21 | 3,539.63 | Aug. 2, 2026: 1 @ 168.55 |
| Sept. 8, 2026 | issue | SO-260908-431 | MAIN | 1 | 168.55 | -168.55 | 22 | 3,708.18 | Aug. 2, 2026: 1 @ 168.55 |
| Aug. 27, 2026 | issue | SO-260827-509 | MAIN | 6 | 168.55 | -1,011.32 | 23 | 3,876.74 | Aug. 2, 2026: 6 @ 168.55 |
| Aug. 22, 2026 | issue | SO-260822-398 | MAIN | 1 | 168.55 | -168.55 | 29 | 4,888.06 | Aug. 2, 2026: 1 @ 168.55 |
| Aug. 12, 2026 | issue | SO-260812-261 | MAIN | 5 | 167.85 | -839.24 | 30 | 5,056.61 | May 11, 2026: 1 @ 165.02; Aug. 2, 2026: 4 @ 168.55 |
| Aug. 2, 2026 | receipt | PO-001691 | MAIN | 34 | 168.55 | 5,730.83 | 35 | 5,895.85 | |
| July 31, 2026 | issue | SO-260731-187 | MAIN | 7 | 165.02 | -1,155.15 | 1 | 165.02 | May 11, 2026: 7 @ 165.02 |
| July 23, 2026 | issue | SO-260723-314 | MAIN | 1 | 165.02 | -165.02 | 8 | 1,320.18 | May 11, 2026: 1 @ 165.02 |
| July 9, 2026 | issue | SO-260709-118 | MAIN | 14 | 165.02 | -2,310.31 | 9 | 1,485.20 | May 11, 2026: 14 @ 165.02 |
| June 26, 2026 | issue | SO-260626-268 | MAIN | 9 | 165.02 | -1,485.20 | 23 | 3,795.51 | May 11, 2026: 9 @ 165.02 |
| June 23, 2026 | issue | SO-260623-651 | MAIN | 2 | 165.02 | -330.04 | 32 | 5,280.70 | May 11, 2026: 2 @ 165.02 |
| June 19, 2026 | issue | SO-260619-986 | MAIN | 3 | 165.02 | -495.07 | 34 | 5,610.75 | May 11, 2026: 3 @ 165.02 |
| June 15, 2026 | issue | SO-260615-813 | MAIN | 2 | 165.02 | -330.04 | 37 | 6,105.81 | May 11, 2026: 2 @ 165.02 |
| June 1, 2026 | issue | SO-260601-233 | MAIN | 8 | 165.25 | -1,322.03 | 39 | 6,435.86 | April 27, 2026: 3 @ 165.64; May 11, 2026: 5 @ 165.02 |
| May 22, 2026 | issue | SO-260522-155 | MAIN | 11 | 165.16 | -1,816.81 | 47 | 7,757.89 | April 4, 2026: 7 @ 164.89; April 27, 2026: 4 @ 165.64 |
| May 19, 2026 | issue | SO-260519-276 | MAIN | 8 | 164.89 | -1,319.14 | 58 | 9,574.69 | April 4, 2026: 8 @ 164.89 |
| May 11, 2026 | receipt | PO-001482 | MAIN | 44 | 165.02 | 7,260.97 | 66 | 10,893.83 | |
| May 6, 2026 | issue | SO-260506-436 | MAIN | 8 | 164.89 | -1,319.14 | 22 | 3,632.86 | April 4, 2026: 8 @ 164.89 |
| April 27, 2026 | return | RMA | MAIN | 7 | 165.64 | 1,159.48 | 30 | 4,952.00 | |
| April 24, 2026 | issue | SO-260424-679 | MAIN | 15 | 165.64 | -2,484.60 | 23 | 3,792.52 | Feb. 25, 2026: 8 @ 166.29; April 4, 2026: 7 @ 164.89 |
| April 4, 2026 | receipt | PO-001383 | MAIN | 30 | 164.89 | 4,946.77 | 38 | 6,277.12 | |
| March 17, 2026 | issue | SO-260317-659 | MAIN | 2 | 166.29 | -332.59 | 8 | 1,330.35 | Feb. 25, 2026: 2 @ 166.29 |
| March 16, 2026 | issue | SO-260316-865 | MAIN | 1 | 166.29 | -166.29 | 10 | 1,662.94 | Feb. 25, 2026: 1 @ 166.29 |
| March 9, 2026 | issue | SO-260309-273 | MAIN | 3 | 166.29 | -498.88 | 11 | 1,829.24 | Feb. 25, 2026: 3 @ 166.29 |
| March 6, 2026 | issue | SO-260306-892 | MAIN | 4 | 166.29 | -665.18 | 14 | 2,328.12 | Feb. 25, 2026: 4 @ 166.29 |
| Feb. 27, 2026 | issue | SO-260227-873 | MAIN | 1 | 165.83 | -165.83 | 18 | 2,993.30 | Jan. 26, 2026: 1 @ 165.83 |
| Feb. 25, 2026 | receipt | PO-001257 | MAIN | 18 | 166.29 | 2,993.30 | 19 | 3,159.13 | |
| Feb. 17, 2026 | issue | SO-260217-934 | MAIN | 1 | 165.83 | -165.83 | 1 | 165.83 | Jan. 26, 2026: 1 @ 165.83 |
| Feb. 14, 2026 | issue | SO-260214-612 | MAIN | 1 | 165.83 | -165.83 | 2 | 331.67 | Jan. 26, 2026: 1 @ 165.83 |
| Feb. 12, 2026 | issue | SO-260212-721 | MAIN | 1 | 165.83 | -165.83 | 3 | 497.50 | Jan. 26, 2026: 1 @ 165.83 |
| Feb. 9, 2026 | issue | SO-260209-536 | MAIN | 4 | 165.83 | -663.34 | 4 | 663.34 | Jan. 26, 2026: 4 @ 165.83 |
| Jan. 28, 2026 | issue | SO-260128-958 | MAIN | 1 | 165.83 | -165.83 | 8 | 1,326.67 | Jan. 26, 2026: 1 @ 165.83 |
| Jan. 26, 2026 | receipt | PO-001175 | MAIN | 9 | 165.83 | 1,492.51 | 9 | 1,492.51 | |
| Jan. 23, 2026 | issue | SO-260123-162 | MAIN | 1 | 169.00 | -169.00 | 0 | 0.00 | Nov. 20, 2025: 1 @ 169.00 |
| Jan. 15, 2026 | issue | SO-260115-148 | MAIN | 1 | 169.00 | -169.00 | 1 | 169.00 | Nov. 20, 2025: 1 @ 169.00 |
| Jan. 14, 2026 | issue | SO-260114-482 | MAIN | 1 | 169.00 | -169.00 | 2 | 337.99 | Nov. 20, 2025: 1 @ 169.00 |
| Jan. 6, 2026 | issue | SO-260106-539 | MAIN | 1 | 169.00 | -169.00 | 3 | 506.99 | Nov. 20, 2025: 1 @ 169.00 |
| Dec. 29, 2025 | issue | SO-251229-515 | MAIN | 1 | 169.00 | -169.00 | 4 | 675.99 | Nov. 20, 2025: 1 @ 169.00 |
| Dec. 10, 2025 | issue | SO-251210-468 | MAIN | 1 | 169.00 | -169.00 | 5 | 844.98 | Nov. 20, 2025: 1 @ 169.00 |
| Nov. 20, 2025 | receipt | PO-001012 | MAIN | 6 | 169.00 | 1,013.98 | 6 | 1,013.98 | |
| Nov. 15, 2025 | issue | SO-251115-673 | MAIN | 1 | 158.69 | -158.69 | 0 | 0.00 | June 22, 2025: 1 @ 158.69 |
| Nov. 2, 2025 | issue | SO-251102-303 | MAIN | 2 | 158.69 | -317.37 | 1 | 158.69 | June 22, 2025: 2 @ 158.69 |
| Oct. 31, 2025 | issue | SO-251031-835 | MAIN | 1 | 158.69 | -158.69 | 3 | 476.06 | June 22, 2025: 1 @ 158.69 |
| Oct. 16, 2025 | issue | SO-251016-746 | MAIN | 3 | 158.69 | -476.06 | 4 | 634.74 | June 22, 2025: 3 @ 158.69 |
| Oct. 13, 2025 | issue | SO-251013-721 | MAIN | 1 | 158.69 | -158.69 | 7 | 1,110.80 | June 22, 2025: 1 @ 158.69 |
| Oct. 9, 2025 | issue | SO-251009-442 | MAIN | 2 | 158.69 | -317.37 | 8 | 1,269.48 | June 22, 2025: 2 @ 158.69 |
| Oct. 2, 2025 | issue | SO-251002-878 | MAIN | 1 | 158.69 | -158.69 | 10 | 1,586.86 | June 22, 2025: 1 @ 158.69 |
| Oct. 1, 2025 | issue | SO-251001-328 | MAIN | 1 | 158.69 | -158.69 | 11 | 1,745.54 | June 22, 2025: 1 @ 158.69 |
| Sept. 30, 2025 | issue | SO-250930-883 | MAIN | 2 | 158.69 | -317.37 | 12 | 1,904.23 | June 22, 2025: 2 @ 158.69 |
| Sept. 24, 2025 | issue | SO-250924-203 | MAIN | 2 | 158.69 | -317.37 | 14 | 2,221.60 | June 22, 2025: 2 @ 158.69 |
| Sept. 18, 2025 | issue | SO-250918-667 | MAIN | 2 | 158.69 | -317.37 | 16 | 2,538.97 | June 22, 2025: 2 @ 158.69 |
| Aug. 30, 2025 | issue | SO-250830-294 | MAIN | 2 | 158.69 | -317.37 | 18 | 2,856.34 | June 22, 2025: 2 @ 158.69 |
| Aug. 29, 2025 | issue | SO-250829-343 | MAIN | 1 | 158.69 | -158.69 | 20 | 3,173.71 | June 22, 2025: 1 @ 158.69 |
| Aug. 27, 2025 | issue | SO-250827-196 | MAIN | 3 | 158.69 | -476.06 | 21 | 3,332.40 | June 22, 2025: 3 @ 158.69 |
| Aug. 9, 2025 | issue | SO-250809-553 | MAIN | 2 | 158.69 | -317.37 | 24 | 3,808.45 | June 22, 2025: 2 @ 158.69 |
| Aug. 3, 2025 | issue | SO-250803-663 | MAIN | 4 | 158.69 | -634.74 | 26 | 4,125.82 | June 22, 2025: 4 @ 158.69 |
| July 26, 2025 | issue | SO-250726-196 | MAIN | 13 | 158.69 | -2,062.91 | 30 | 4,760.56 | June 22, 2025: 13 @ 158.69 |
| July 24, 2025 | issue | SO-250724-364 | MAIN | 9 | 158.80 | -1,429.17 | 43 | 6,823.48 | May 15, 2025: 6 @ 158.85; June 22, 2025: 3 @ 158.69 |
| June 23, 2025 | issue | SO-250623-318 | MAIN | 4 | 158.85 | -635.41 | 52 | 8,252.65 | May 15, 2025: 4 @ 158.85 |
| June 22, 2025 | receipt | PO-000657 | MAIN | 46 | 158.69 | 7,299.53 | 56 | 8,888.06 | |
| June 11, 2025 | issue | SO-250611-129 | MAIN | 8 | 158.85 | -1,270.82 | 10 | 1,588.52 | May 15, 2025: 8 @ 158.85 |
| June 10, 2025 | issue | SO-250610-771 | MAIN | 5 | 158.85 | -794.26 | 18 | 2,859.34 | May 15, 2025: 5 @ 158.85 |
| June 6, 2025 | issue | SO-250606-975 | MAIN | 22 | 159.03 | -3,498.69 | 23 | 3,653.60 | April 16, 2025: 1 @ 162.79; May 15, 2025: 21 @ 158.85 |
| May 25, 2025 | issue | SO-250525-561 | MAIN | 14 | 162.79 | -2,279.10 | 45 | 7,152.29 | April 16, 2025: 14 @ 162.79 |
| May 18, 2025 | issue | SO-250518-271 | MAIN | 2 | 162.79 | -325.59 | 59 | 9,431.39 | April 16, 2025: 2 @ 162.79 |
| May 15, 2025 | issue | SO-250515-262 | MAIN | 1 | 162.79 | -162.79 | 61 | 9,756.98 | April 16, 2025: 1 @ 162.79 |
| May 15, 2025 | receipt | PO-000538 | MAIN | 44 | 158.85 | 6,989.50 | 62 | 9,919.77 | |
| May 11, 2025 | issue | SO-250511-571 | MAIN | 1 | 162.79 | -162.79 | 18 | 2,930.27 | April 16, 2025: 1 @ 162.79 |
| May 1, 2025 | issue | SO-250501-146 | MAIN | 3 | 162.79 | -488.38 | 19 | 3,093.07 | April 16, 2025: 3 @ 162.79 |
| April 27, 2025 | issue | SO-250427-996 | MAIN | 4 | 162.79 | -651.17 | 22 | 3,581.44 | April 16, 2025: 4 @ 162.79 |
| April 25, 2025 | issue | SO-250425-664 | MAIN | 8 | 161.08 | -1,288.66 | 26 | 4,232.62 | March 7, 2025: 3 @ 159.37; April 4, 2025: 1 @ 159.37; April 16, 2025: 4 @ 162.79 |
| April 24, 2025 | issue | SO-250424-418 | MAIN | 5 | 159.37 | -796.86 | 34 | 5,521.27 | March 7, 2025: 5 @ 159.37 |
| April 22, 2025 | issue | SO-250422-151 | MAIN | 1 | 159.37 | -159.37 | 39 | 6,318.13 | March 7, 2025: 1 @ 159.37 |
| April 16, 2025 | receipt | PO-000453 | MAIN | 30 | 162.79 | 4,883.79 | 40 | 6,477.50 | |
| April 8, 2025 | issue | SO-250408-371 | MAIN | 2 | 159.37 | -318.74 | 10 | 1,593.72 | March 7, 2025: 2 @ 159.37 |
| April 4, 2025 | return | RMA | MAIN | 1 | 159.37 | 159.37 | 12 | 1,912.46 | |
| March 26, 2025 | issue | SO-250326-187 | MAIN | 1 | 159.37 | -159.37 | 11 | 1,753.09 | March 7, 2025: 1 @ 159.37 |
| March 26, 2025 | issue | SO-250326-187 | EAST | 2 | 159.37 | -318.74 | 12 | 1,912.46 | March 7, 2025: 2 @ 159.37 |
| March 17, 2025 | issue | SO-250317-774 | EAST | 3 | 159.37 | -478.11 | 14 | 2,231.20 | March 7, 2025: 3 @ 159.37 |
| March 12, 2025 | issue | SO-250312-517 | MAIN | 1 | 159.37 | -159.37 | 17 | 2,709.32 | March 7, 2025: 1 @ 159.37 |
| March 7, 2025 | transfer | TRF | MAIN → EAST | 5 | warehouse transfer, no cost effect | ||||
| March 7, 2025 | receipt | PO-000326 | MAIN | 18 | 159.37 | 2,868.69 | 18 | 2,868.69 | |
| Feb. 15, 2025 | issue | SO-250215-115 | MAIN | 4 | 162.79 | -651.17 | 0 | 0.00 | Oct. 1, 2024: 4 @ 162.79 |
| Feb. 8, 2025 | issue | SO-250208-899 | MAIN | 2 | 162.79 | -325.58 | 4 | 651.17 | Oct. 1, 2024: 2 @ 162.79 |
| Jan. 12, 2025 | issue | SO-250112-422 | MAIN | 2 | 162.79 | -325.58 | 6 | 976.75 | Oct. 1, 2024: 2 @ 162.79 |
| Jan. 9, 2025 | issue | SO-250109-383 | MAIN | 2 | 162.79 | -325.58 | 8 | 1,302.34 | Oct. 1, 2024: 2 @ 162.79 |
| Dec. 16, 2024 | issue | SO-241216-317 | MAIN | 1 | 162.79 | -162.79 | 10 | 1,627.92 | Oct. 1, 2024: 1 @ 162.79 |
| Dec. 15, 2024 | issue | SO-241215-563 | MAIN | 1 | 162.79 | -162.79 | 11 | 1,790.71 | Oct. 1, 2024: 1 @ 162.79 |
| Dec. 7, 2024 | issue | SO-241207-910 | MAIN | 2 | 162.79 | -325.58 | 12 | 1,953.50 | Oct. 1, 2024: 2 @ 162.79 |
| Nov. 17, 2024 | issue | SO-241117-289 | MAIN | 2 | 162.79 | -325.58 | 14 | 2,279.09 | Oct. 1, 2024: 2 @ 162.79 |
| Nov. 15, 2024 | issue | SO-241115-941 | MAIN | 1 | 162.79 | -162.79 | 16 | 2,604.67 | Oct. 1, 2024: 1 @ 162.79 |
| Nov. 3, 2024 | issue | SO-241103-861 | MAIN | 1 | 162.79 | -162.79 | 17 | 2,767.46 | Oct. 1, 2024: 1 @ 162.79 |
| Oct. 26, 2024 | issue | SO-241026-477 | MAIN | 4 | 162.79 | -651.17 | 18 | 2,930.26 | Oct. 1, 2024: 4 @ 162.79 |
| Oct. 21, 2024 | issue | SO-241021-838 | MAIN | 1 | 162.79 | -162.79 | 22 | 3,581.42 | Oct. 1, 2024: 1 @ 162.79 |
| Oct. 1, 2024 | receipt | PO-000003 | MAIN | 23 | 162.79 | 3,744.22 | 23 | 3,744.22 | |