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, latest 60 shown - show all
| 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 |