Items / FAN-0029
Decorative Ceiling Fan Classic FAN-0029 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)14MAIN 14
Value (FIFO)1,294.95avg 92.50
ClassAY / FCV 0.90
Turnover8.4xlast issue 1 days ago
Days of cover10lead time 22d
Reorder suggested: 144 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 | 40.92 / 30.4375 | 1.344 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 36.68 / 5.517 | 6.648 |
| 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 * 6.648^2 + 1.344^2 * 7.4^2) | 66.5 |
| Reorder point | d * LT + safety stock | 1.344 * 21.5 + 66.5 | 95.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 95.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 491/yr, S = 45.00, h = 20%, price = 84.87 | 72.0 |
| Inventory position | on hand + on order | 14 + 0 | 14 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 92.25 | 49 | 46,166 | no |
| 36 | 88.56 | 50 | 44,338 | yes |
| 72 | 84.87 | 72 | 42,560 | yes (chosen if cheapest) |
MOQ 18, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 7, 2026 | 14 / 26 | 92.50 | 1,294.95 |
Movement ledger 111 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 15, 2026 | issue | SO-261015-371 | MAIN | 1 | 92.50 | -92.50 | 14 | 1,294.95 | Oct. 7, 2026: 1 @ 92.50 |
| Oct. 12, 2026 | issue | SO-261012-548 | MAIN | 4 | 92.50 | -369.99 | 15 | 1,387.45 | Oct. 7, 2026: 4 @ 92.50 |
| Oct. 11, 2026 | issue | SO-261011-322 | MAIN | 1 | 92.50 | -92.50 | 19 | 1,757.43 | Oct. 7, 2026: 1 @ 92.50 |
| Oct. 8, 2026 | issue | SO-261008-575 | MAIN | 9 | 91.47 | -823.26 | 20 | 1,849.93 | June 23, 2026: 3 @ 89.43; Oct. 7, 2026: 6 @ 92.50 |
| Oct. 7, 2026 | receipt | PO-001855 | MAIN | 26 | 92.50 | 2,404.91 | 29 | 2,673.19 | |
| Sept. 30, 2026 | issue | SO-260930-468 | MAIN | 6 | 89.43 | -536.56 | 3 | 268.28 | June 23, 2026: 6 @ 89.43 |
| Sept. 29, 2026 | issue | SO-260929-757 | MAIN | 4 | 89.43 | -357.71 | 9 | 804.84 | June 23, 2026: 4 @ 89.43 |
| Sept. 15, 2026 | issue | SO-260915-497 | MAIN | 4 | 89.43 | -357.71 | 13 | 1,162.54 | June 23, 2026: 4 @ 89.43 |
| Sept. 13, 2026 | issue | SO-260913-768 | MAIN | 4 | 89.43 | -357.71 | 17 | 1,520.25 | June 23, 2026: 4 @ 89.43 |
| Sept. 10, 2026 | issue | SO-260910-278 | MAIN | 1 | 89.43 | -89.43 | 21 | 1,877.95 | June 23, 2026: 1 @ 89.43 |
| Sept. 7, 2026 | issue | SO-260907-340 | MAIN | 2 | 89.43 | -178.85 | 22 | 1,967.38 | June 23, 2026: 2 @ 89.43 |
| Sept. 3, 2026 | issue | SO-260903-937 | MAIN | 1 | 89.43 | -89.43 | 24 | 2,146.23 | June 23, 2026: 1 @ 89.43 |
| Aug. 17, 2026 | issue | SO-260817-580 | MAIN | 10 | 89.43 | -894.26 | 25 | 2,235.66 | June 23, 2026: 10 @ 89.43 |
| Aug. 17, 2026 | issue | SO-260817-580 | EAST | 16 | 89.43 | -1,430.82 | 35 | 3,129.92 | June 23, 2026: 16 @ 89.43 |
| Aug. 16, 2026 | issue | SO-260816-978 | MAIN | 16 | 89.43 | -1,430.82 | 51 | 4,560.75 | June 23, 2026: 16 @ 89.43 |
| July 30, 2026 | issue | SO-260730-891 | MAIN | 34 | 89.43 | -3,040.50 | 67 | 5,991.57 | June 23, 2026: 34 @ 89.43 |
| July 25, 2026 | issue | SO-260725-873 | MAIN | 4 | 89.43 | -357.71 | 101 | 9,032.07 | June 23, 2026: 4 @ 89.43 |
| July 22, 2026 | issue | SO-260722-706 | MAIN | 59 | 90.05 | -5,312.73 | 105 | 9,389.77 | May 12, 2026: 16 @ 91.71; June 23, 2026: 43 @ 89.43 |
| July 8, 2026 | issue | SO-260708-886 | EAST | 8 | 91.71 | -733.70 | 164 | 14,702.50 | May 12, 2026: 8 @ 91.71 |
| July 6, 2026 | issue | SO-260706-665 | EAST | 14 | 91.71 | -1,283.97 | 172 | 15,436.20 | May 12, 2026: 14 @ 91.71 |
| June 30, 2026 | issue | SO-260630-586 | MAIN | 10 | 91.71 | -917.12 | 186 | 16,720.17 | May 12, 2026: 10 @ 91.71 |
| June 23, 2026 | transfer | TRF | MAIN → EAST | 38 | warehouse transfer, no cost effect | ||||
| June 23, 2026 | receipt | PO-001596 | MAIN | 148 | 89.43 | 13,235.11 | 196 | 17,637.30 | |
| June 5, 2026 | issue | SO-260605-154 | MAIN | 12 | 91.71 | -1,100.55 | 48 | 4,402.19 | May 12, 2026: 12 @ 91.71 |
| June 2, 2026 | issue | SO-260602-537 | MAIN | 72 | 91.71 | -6,603.29 | 60 | 5,502.74 | May 12, 2026: 72 @ 91.71 |
| May 28, 2026 | issue | SO-260528-803 | MAIN | 30 | 92.04 | -2,761.20 | 132 | 12,106.02 | March 31, 2026: 20 @ 92.20; May 12, 2026: 10 @ 91.71 |
| May 27, 2026 | issue | SO-260527-134 | MAIN | 13 | 92.20 | -1,198.65 | 162 | 14,867.23 | March 31, 2026: 13 @ 92.20 |
| May 26, 2026 | issue | SO-260526-544 | MAIN | 4 | 92.20 | -368.82 | 175 | 16,065.88 | March 31, 2026: 4 @ 92.20 |
| May 23, 2026 | issue | SO-260523-451 | MAIN | 26 | 92.20 | -2,397.31 | 179 | 16,434.70 | March 31, 2026: 26 @ 92.20 |
| May 12, 2026 | receipt | PO-001486 | MAIN | 142 | 91.71 | 13,023.15 | 205 | 18,832.00 | |
| May 5, 2026 | issue | SO-260505-872 | MAIN | 6 | 92.20 | -553.22 | 63 | 5,808.86 | March 31, 2026: 6 @ 92.20 |
| April 28, 2026 | issue | SO-260428-134 | MAIN | 24 | 92.20 | -2,212.90 | 69 | 6,362.08 | March 31, 2026: 24 @ 92.20 |
| April 28, 2026 | issue | SO-260428-134 | EAST | 20 | 90.16 | -1,803.29 | 93 | 8,574.98 | July 3, 2025: 1 @ 89.65; Sept. 4, 2025: 1 @ 89.65; Oct. 5, 2025: 11 @ 89.65; Feb. 18, 2026: 3 @ 89.65; March 31, 2026: 4 @ 92.20 |
| April 27, 2026 | issue | SO-260427-767 | MAIN | 12 | 89.65 | -1,075.86 | 113 | 10,378.27 | July 3, 2025: 12 @ 89.65 |
| April 13, 2026 | adjustment | Cycle count | MAIN | -1 | 89.65 | -89.65 | 125 | 11,454.13 | July 3, 2025: 1 @ 89.65 |
| March 31, 2026 | transfer | TRF | MAIN → EAST | 20 | warehouse transfer, no cost effect | ||||
| March 31, 2026 | receipt | PO-001372 | MAIN | 97 | 92.20 | 8,943.80 | 126 | 11,543.78 | |
| March 25, 2026 | issue | SO-260325-914 | MAIN | 1 | 89.65 | -89.65 | 29 | 2,599.99 | July 3, 2025: 1 @ 89.65 |
| March 17, 2026 | issue | SO-260317-101 | MAIN | 4 | 89.65 | -358.62 | 30 | 2,689.64 | July 3, 2025: 4 @ 89.65 |
| March 13, 2026 | issue | SO-260313-884 | MAIN | 5 | 89.65 | -448.27 | 34 | 3,048.26 | July 3, 2025: 5 @ 89.65 |
| March 8, 2026 | issue | SO-260308-853 | MAIN | 2 | 89.65 | -179.31 | 39 | 3,496.53 | July 3, 2025: 2 @ 89.65 |
| March 6, 2026 | issue | SO-260306-466 | MAIN | 20 | 89.65 | -1,793.09 | 41 | 3,675.84 | July 3, 2025: 20 @ 89.65 |
| Feb. 18, 2026 | return | RMA | MAIN | 3 | 89.65 | 268.96 | 61 | 5,468.94 | |
| Feb. 17, 2026 | issue | SO-260217-408 | MAIN | 12 | 89.65 | -1,075.86 | 58 | 5,199.97 | July 3, 2025: 12 @ 89.65 |
| Feb. 7, 2026 | issue | SO-260207-801 | MAIN | 6 | 89.65 | -537.93 | 70 | 6,275.83 | July 3, 2025: 6 @ 89.65 |
| Feb. 4, 2026 | issue | SO-260204-751 | MAIN | 2 | 89.65 | -179.31 | 76 | 6,813.76 | July 3, 2025: 2 @ 89.65 |
| Jan. 31, 2026 | issue | SO-260131-673 | MAIN | 2 | 89.65 | -179.31 | 78 | 6,993.07 | July 3, 2025: 2 @ 89.65 |
| Jan. 29, 2026 | issue | SO-260129-854 | MAIN | 2 | 89.65 | -179.31 | 80 | 7,172.38 | July 3, 2025: 2 @ 89.65 |
| Jan. 27, 2026 | issue | SO-260127-477 | MAIN | 4 | 89.65 | -358.62 | 82 | 7,351.69 | July 3, 2025: 4 @ 89.65 |
| Jan. 25, 2026 | issue | SO-260125-457 | MAIN | 3 | 89.65 | -268.96 | 86 | 7,710.30 | July 3, 2025: 3 @ 89.65 |
| Jan. 10, 2026 | issue | SO-260110-377 | MAIN | 1 | 89.65 | -89.65 | 89 | 7,979.27 | July 3, 2025: 1 @ 89.65 |
| Jan. 7, 2026 | issue | SO-260107-407 | MAIN | 1 | 89.65 | -89.65 | 90 | 8,068.92 | July 3, 2025: 1 @ 89.65 |
| Jan. 3, 2026 | issue | SO-260103-710 | MAIN | 2 | 89.65 | -179.31 | 91 | 8,158.58 | July 3, 2025: 2 @ 89.65 |
| Dec. 22, 2025 | issue | SO-251222-437 | MAIN | 3 | 89.65 | -268.96 | 93 | 8,337.89 | July 3, 2025: 3 @ 89.65 |
| Dec. 15, 2025 | issue | SO-251215-845 | MAIN | 1 | 89.65 | -89.65 | 96 | 8,606.85 | July 3, 2025: 1 @ 89.65 |
| Dec. 14, 2025 | issue | SO-251214-551 | MAIN | 1 | 89.65 | -89.65 | 97 | 8,696.51 | July 3, 2025: 1 @ 89.65 |
| Nov. 24, 2025 | issue | SO-251124-322 | MAIN | 1 | 89.65 | -89.65 | 98 | 8,786.16 | July 3, 2025: 1 @ 89.65 |
| Nov. 22, 2025 | issue | SO-251122-943 | MAIN | 1 | 89.65 | -89.65 | 99 | 8,875.82 | July 3, 2025: 1 @ 89.65 |
| Nov. 19, 2025 | issue | SO-251119-436 | MAIN | 2 | 89.65 | -179.31 | 100 | 8,965.47 | July 3, 2025: 2 @ 89.65 |
| Nov. 2, 2025 | issue | SO-251102-921 | MAIN | 1 | 89.65 | -89.65 | 102 | 9,144.78 | July 3, 2025: 1 @ 89.65 |
| Oct. 22, 2025 | issue | SO-251022-942 | MAIN | 4 | 89.65 | -358.62 | 103 | 9,234.43 | July 3, 2025: 4 @ 89.65 |
| Oct. 19, 2025 | issue | SO-251019-653 | MAIN | 2 | 89.65 | -179.31 | 107 | 9,593.05 | July 3, 2025: 2 @ 89.65 |
| Oct. 10, 2025 | issue | SO-251010-497 | MAIN | 1 | 89.65 | -89.65 | 109 | 9,772.36 | July 3, 2025: 1 @ 89.65 |
| Oct. 6, 2025 | issue | SO-251006-621 | MAIN | 9 | 89.65 | -806.89 | 110 | 9,862.02 | July 3, 2025: 9 @ 89.65 |
| Oct. 5, 2025 | return | RMA | MAIN | 11 | 89.65 | 986.20 | 119 | 10,668.91 | |
| Sept. 29, 2025 | issue | SO-250929-716 | MAIN | 2 | 89.65 | -179.31 | 108 | 9,682.71 | July 3, 2025: 2 @ 89.65 |
| Sept. 19, 2025 | issue | SO-250919-107 | MAIN | 22 | 89.65 | -1,972.40 | 110 | 9,862.02 | July 3, 2025: 22 @ 89.65 |
| Sept. 4, 2025 | return | RMA | MAIN | 1 | 89.65 | 89.65 | 132 | 11,834.42 | |
| Aug. 26, 2025 | issue | SO-250826-256 | MAIN | 3 | 89.65 | -268.96 | 131 | 11,744.77 | July 3, 2025: 3 @ 89.65 |
| Aug. 21, 2025 | issue | SO-250821-135 | MAIN | 18 | 89.48 | -1,610.72 | 134 | 12,013.73 | June 4, 2025: 4 @ 88.89; July 3, 2025: 14 @ 89.65 |
| Aug. 9, 2025 | issue | SO-250809-963 | MAIN | 25 | 88.89 | -2,222.19 | 152 | 13,624.45 | June 4, 2025: 25 @ 88.89 |
| July 8, 2025 | issue | SO-250708-759 | MAIN | 3 | 88.89 | -266.66 | 177 | 15,846.64 | June 4, 2025: 3 @ 88.89 |
| July 7, 2025 | issue | SO-250707-310 | MAIN | 3 | 88.89 | -266.66 | 180 | 16,113.30 | June 4, 2025: 3 @ 88.89 |
| July 5, 2025 | issue | SO-250705-922 | MAIN | 15 | 88.89 | -1,333.31 | 183 | 16,379.96 | June 4, 2025: 15 @ 88.89 |
| July 4, 2025 | issue | SO-250704-192 | MAIN | 27 | 88.89 | -2,399.97 | 198 | 17,713.28 | June 4, 2025: 27 @ 88.89 |
| July 3, 2025 | receipt | PO-000679 | MAIN | 148 | 89.65 | 13,268.90 | 225 | 20,113.24 | |
| June 9, 2025 | issue | SO-250609-764 | MAIN | 36 | 88.89 | -3,199.95 | 77 | 6,844.35 | June 4, 2025: 36 @ 88.89 |
| June 4, 2025 | issue | SO-250604-161 | MAIN | 29 | 88.89 | -2,577.74 | 113 | 10,044.30 | June 4, 2025: 29 @ 88.89 |
| June 4, 2025 | receipt | PO-000603 | MAIN | 142 | 88.89 | 12,622.04 | 142 | 12,622.04 | |
| May 21, 2025 | issue | SO-250521-706 | MAIN | 25 | 88.73 | -2,218.34 | 0 | 0.00 | April 18, 2025: 25 @ 88.73 |
| May 16, 2025 | issue | SO-250516-550 | MAIN | 21 | 88.73 | -1,863.40 | 25 | 2,218.34 | April 18, 2025: 21 @ 88.73 |
| May 10, 2025 | issue | SO-250510-275 | MAIN | 30 | 88.73 | -2,662.00 | 46 | 4,081.74 | April 18, 2025: 30 @ 88.73 |
| May 8, 2025 | issue | SO-250508-676 | MAIN | 9 | 88.73 | -798.60 | 76 | 6,743.74 | April 18, 2025: 9 @ 88.73 |
| April 30, 2025 | issue | SO-250430-544 | MAIN | 1 | 88.73 | -88.73 | 85 | 7,542.34 | April 18, 2025: 1 @ 88.73 |
| April 19, 2025 | issue | SO-250419-206 | MAIN | 50 | 88.27 | -4,413.32 | 86 | 7,631.07 | March 5, 2025: 39 @ 88.13; April 18, 2025: 11 @ 88.73 |
| April 18, 2025 | receipt | PO-000459 | MAIN | 97 | 88.73 | 8,607.14 | 136 | 12,044.39 | |
| March 26, 2025 | issue | SO-250326-917 | MAIN | 4 | 88.13 | -352.54 | 39 | 3,437.25 | March 5, 2025: 4 @ 88.13 |
| March 20, 2025 | issue | SO-250320-544 | MAIN | 22 | 87.98 | -1,935.48 | 43 | 3,789.79 | Oct. 1, 2024: 7 @ 87.64; March 5, 2025: 15 @ 88.13 |
| March 5, 2025 | receipt | PO-000315 | MAIN | 58 | 88.13 | 5,111.81 | 65 | 5,725.28 | |
| Feb. 28, 2025 | issue | SO-250228-143 | MAIN | 2 | 87.64 | -175.28 | 7 | 613.46 | Oct. 1, 2024: 2 @ 87.64 |
| Feb. 17, 2025 | issue | SO-250217-721 | MAIN | 11 | 87.64 | -964.01 | 9 | 788.74 | Oct. 1, 2024: 11 @ 87.64 |
| Feb. 10, 2025 | issue | SO-250210-970 | MAIN | 2 | 87.64 | -175.28 | 20 | 1,752.75 | Oct. 1, 2024: 2 @ 87.64 |
| Feb. 2, 2025 | issue | SO-250202-867 | MAIN | 2 | 87.64 | -175.28 | 22 | 1,928.02 | Oct. 1, 2024: 2 @ 87.64 |
| Feb. 1, 2025 | issue | SO-250201-209 | MAIN | 2 | 87.64 | -175.28 | 24 | 2,103.30 | Oct. 1, 2024: 2 @ 87.64 |
| Jan. 26, 2025 | issue | SO-250126-990 | MAIN | 17 | 87.64 | -1,489.84 | 26 | 2,278.58 | Oct. 1, 2024: 17 @ 87.64 |
| Jan. 19, 2025 | issue | SO-250119-820 | MAIN | 3 | 87.64 | -262.91 | 43 | 3,768.41 | Oct. 1, 2024: 3 @ 87.64 |
| Dec. 31, 2024 | issue | SO-241231-322 | MAIN | 1 | 87.64 | -87.64 | 46 | 4,031.32 | Oct. 1, 2024: 1 @ 87.64 |
| Dec. 18, 2024 | issue | SO-241218-700 | MAIN | 2 | 87.64 | -175.28 | 47 | 4,118.96 | Oct. 1, 2024: 2 @ 87.64 |
| Dec. 17, 2024 | issue | SO-241217-309 | MAIN | 2 | 87.64 | -175.28 | 49 | 4,294.24 | Oct. 1, 2024: 2 @ 87.64 |
| Dec. 14, 2024 | issue | SO-241214-667 | MAIN | 1 | 87.64 | -87.64 | 51 | 4,469.51 | Oct. 1, 2024: 1 @ 87.64 |
| Dec. 4, 2024 | issue | SO-241204-402 | MAIN | 2 | 87.64 | -175.28 | 52 | 4,557.15 | Oct. 1, 2024: 2 @ 87.64 |
| Dec. 2, 2024 | issue | SO-241202-959 | MAIN | 1 | 87.64 | -87.64 | 54 | 4,732.42 | Oct. 1, 2024: 1 @ 87.64 |
| Nov. 24, 2024 | issue | SO-241124-378 | MAIN | 2 | 87.64 | -175.28 | 55 | 4,820.06 | Oct. 1, 2024: 2 @ 87.64 |
| Nov. 20, 2024 | issue | SO-241120-707 | MAIN | 1 | 87.64 | -87.64 | 57 | 4,995.34 | Oct. 1, 2024: 1 @ 87.64 |
| Nov. 19, 2024 | issue | SO-241119-968 | MAIN | 3 | 87.64 | -262.91 | 58 | 5,082.98 | Oct. 1, 2024: 3 @ 87.64 |
| Nov. 1, 2024 | issue | SO-241101-963 | MAIN | 1 | 87.64 | -87.64 | 61 | 5,345.89 | Oct. 1, 2024: 1 @ 87.64 |
| Oct. 19, 2024 | issue | SO-241019-421 | MAIN | 2 | 87.64 | -175.28 | 62 | 5,433.52 | Oct. 1, 2024: 2 @ 87.64 |
| Oct. 16, 2024 | issue | SO-241016-264 | MAIN | 1 | 87.64 | -87.64 | 64 | 5,608.80 | Oct. 1, 2024: 1 @ 87.64 |
| Oct. 14, 2024 | issue | SO-241014-908 | MAIN | 4 | 87.64 | -350.55 | 65 | 5,696.44 | Oct. 1, 2024: 4 @ 87.64 |
| Oct. 7, 2024 | issue | SO-241007-135 | MAIN | 3 | 87.64 | -262.91 | 69 | 6,046.99 | Oct. 1, 2024: 3 @ 87.64 |
| Oct. 1, 2024 | receipt | PO-000003 | MAIN | 72 | 87.64 | 6,309.90 | 72 | 6,309.90 | |