Items / FAN-0026
Ceiling Fan 1200mm Elite FAN-0026 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)10MAIN 10
Value (FIFO)2,295.62avg 229.56
ClassAY / FCV 0.68
Turnover11.9xlast issue 12 days ago
Days of cover17lead time 22d
Reorder suggested: 41 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 | 18.08 / 30.4375 | 0.594 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 12.37 / 5.517 | 2.243 |
| 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.243^2 + 0.594^2 * 7.4^2) | 23.2 |
| Reorder point | d * LT + safety stock | 0.594 * 21.5 + 23.2 | 36.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 36.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 217/yr, S = 45.00, h = 20%, price = 236.60 | 20.3 |
| Inventory position | on hand + on order | 10 + 0 | 10 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 236.60 | 20 | 52,268 | yes (chosen if cheapest) |
MOQ 10, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 29, 2026 | 10 / 33 | 229.56 | 2,295.62 |
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. 4, 2026 | issue | SO-261004-850 | MAIN | 3 | 229.56 | -688.69 | 10 | 2,295.62 | Aug. 29, 2026: 3 @ 229.56 |
| Oct. 1, 2026 | issue | SO-261001-577 | MAIN | 3 | 229.56 | -688.69 | 13 | 2,984.31 | Aug. 29, 2026: 3 @ 229.56 |
| Sept. 30, 2026 | issue | SO-260930-346 | MAIN | 3 | 229.56 | -688.69 | 16 | 3,673.00 | Aug. 29, 2026: 3 @ 229.56 |
| Sept. 23, 2026 | issue | SO-260923-325 | MAIN | 3 | 229.56 | -688.69 | 19 | 4,361.68 | Aug. 29, 2026: 3 @ 229.56 |
| Sept. 21, 2026 | issue | SO-260921-293 | MAIN | 1 | 229.56 | -229.56 | 22 | 5,050.37 | Aug. 29, 2026: 1 @ 229.56 |
| Sept. 19, 2026 | issue | SO-260919-640 | MAIN | 1 | 229.56 | -229.56 | 23 | 5,279.93 | Aug. 29, 2026: 1 @ 229.56 |
| Sept. 11, 2026 | issue | SO-260911-682 | MAIN | 1 | 229.56 | -229.56 | 24 | 5,509.50 | Aug. 29, 2026: 1 @ 229.56 |
| Sept. 9, 2026 | issue | SO-260909-753 | MAIN | 1 | 229.56 | -229.56 | 25 | 5,739.06 | Aug. 29, 2026: 1 @ 229.56 |
| Sept. 4, 2026 | issue | SO-260904-472 | MAIN | 2 | 229.56 | -459.12 | 26 | 5,968.62 | Aug. 29, 2026: 2 @ 229.56 |
| Aug. 31, 2026 | issue | SO-260831-737 | MAIN | 6 | 230.20 | -1,381.20 | 28 | 6,427.74 | June 7, 2026: 1 @ 233.39; Aug. 29, 2026: 5 @ 229.56 |
| Aug. 29, 2026 | receipt | PO-001758 | MAIN | 33 | 229.56 | 7,575.56 | 34 | 7,808.95 | |
| Aug. 23, 2026 | issue | SO-260823-280 | MAIN | 6 | 233.39 | -1,400.34 | 1 | 233.39 | June 7, 2026: 6 @ 233.39 |
| Aug. 18, 2026 | issue | SO-260818-711 | MAIN | 2 | 233.39 | -466.78 | 7 | 1,633.73 | June 7, 2026: 2 @ 233.39 |
| Aug. 15, 2026 | issue | SO-260815-746 | MAIN | 1 | 233.39 | -233.39 | 9 | 2,100.52 | June 7, 2026: 1 @ 233.39 |
| Aug. 6, 2026 | issue | SO-260806-485 | MAIN | 1 | 233.39 | -233.39 | 10 | 2,333.91 | June 7, 2026: 1 @ 233.39 |
| Aug. 5, 2026 | issue | SO-260805-923 | MAIN | 1 | 233.39 | -233.39 | 11 | 2,567.30 | June 7, 2026: 1 @ 233.39 |
| July 29, 2026 | adjustment | Cycle count | MAIN | -1 | 233.39 | -233.39 | 12 | 2,800.69 | June 7, 2026: 1 @ 233.39 |
| July 23, 2026 | issue | SO-260723-414 | MAIN | 4 | 233.39 | -933.56 | 13 | 3,034.08 | June 7, 2026: 4 @ 233.39 |
| July 21, 2026 | issue | SO-260721-402 | MAIN | 16 | 233.39 | -3,734.25 | 17 | 3,967.64 | June 7, 2026: 16 @ 233.39 |
| July 17, 2026 | issue | SO-260717-932 | MAIN | 5 | 233.39 | -1,166.95 | 33 | 7,701.89 | June 7, 2026: 5 @ 233.39 |
| July 10, 2026 | issue | SO-260710-107 | MAIN | 9 | 233.39 | -2,100.52 | 38 | 8,868.85 | June 7, 2026: 9 @ 233.39 |
| June 29, 2026 | issue | SO-260629-665 | MAIN | 4 | 233.39 | -933.56 | 47 | 10,969.36 | June 7, 2026: 4 @ 233.39 |
| June 27, 2026 | issue | SO-260627-546 | MAIN | 1 | 233.39 | -233.39 | 51 | 11,902.93 | June 7, 2026: 1 @ 233.39 |
| June 27, 2026 | issue | SO-260627-546 | EAST | 23 | 233.39 | -5,367.99 | 52 | 12,136.32 | June 7, 2026: 23 @ 233.39 |
| June 7, 2026 | transfer | TRF | MAIN → EAST | 23 | warehouse transfer, no cost effect | ||||
| June 7, 2026 | receipt | PO-001554 | MAIN | 75 | 233.39 | 17,504.30 | 75 | 17,504.30 | |
| June 4, 2026 | issue | SO-260604-654 | MAIN | 1 | 237.76 | -237.76 | 0 | 0.00 | April 16, 2026: 1 @ 237.76 |
| June 1, 2026 | issue | SO-260601-941 | MAIN | 6 | 237.76 | -1,426.58 | 1 | 237.76 | April 16, 2026: 6 @ 237.76 |
| May 31, 2026 | issue | SO-260531-888 | MAIN | 28 | 237.76 | -6,657.39 | 7 | 1,664.35 | April 16, 2026: 28 @ 237.76 |
| May 17, 2026 | issue | SO-260517-875 | MAIN | 3 | 237.76 | -713.29 | 35 | 8,321.74 | April 16, 2026: 3 @ 237.76 |
| May 17, 2026 | issue | SO-260517-875 | EAST | 5 | 237.76 | -1,188.82 | 38 | 9,035.04 | April 16, 2026: 5 @ 237.76 |
| April 17, 2026 | issue | SO-260417-482 | MAIN | 11 | 236.42 | -2,600.60 | 43 | 10,223.86 | March 6, 2026: 4 @ 234.74; March 11, 2026: 1 @ 235.04; April 16, 2026: 6 @ 237.76 |
| April 16, 2026 | receipt | PO-001413 | MAIN | 49 | 237.76 | 11,650.44 | 54 | 12,824.45 | |
| April 9, 2026 | issue | SO-260409-688 | MAIN | 19 | 234.74 | -4,460.10 | 5 | 1,174.01 | March 6, 2026: 19 @ 234.74 |
| April 4, 2026 | issue | SO-260404-317 | MAIN | 3 | 234.74 | -704.23 | 24 | 5,634.11 | March 6, 2026: 3 @ 234.74 |
| March 28, 2026 | issue | SO-260328-725 | EAST | 3 | 234.74 | -704.23 | 27 | 6,338.33 | March 6, 2026: 3 @ 234.74 |
| March 21, 2026 | issue | SO-260321-177 | EAST | 4 | 234.97 | -939.87 | 30 | 7,042.56 | Feb. 18, 2026: 3 @ 235.04; March 6, 2026: 1 @ 234.74 |
| March 11, 2026 | return | RMA | MAIN | 1 | 235.04 | 235.04 | 34 | 7,982.43 | |
| March 6, 2026 | transfer | TRF | MAIN → EAST | 10 | warehouse transfer, no cost effect | ||||
| March 6, 2026 | receipt | PO-001291 | MAIN | 30 | 234.74 | 7,042.26 | 33 | 7,747.39 | |
| March 4, 2026 | issue | SO-260304-340 | MAIN | 12 | 235.04 | -2,820.51 | 3 | 705.13 | Feb. 18, 2026: 12 @ 235.04 |
| Feb. 23, 2026 | issue | SO-260223-764 | EAST | 2 | 235.04 | -470.09 | 15 | 3,525.64 | Feb. 18, 2026: 2 @ 235.04 |
| Feb. 19, 2026 | issue | SO-260219-997 | EAST | 1 | 235.04 | -235.04 | 17 | 3,995.73 | Feb. 18, 2026: 1 @ 235.04 |
| Feb. 18, 2026 | transfer | TRF | MAIN → EAST | 5 | warehouse transfer, no cost effect | ||||
| Feb. 18, 2026 | receipt | PO-001236 | MAIN | 18 | 235.04 | 4,230.77 | 18 | 4,230.77 | |
| Feb. 6, 2026 | issue | SO-260206-717 | MAIN | 2 | 221.98 | -443.96 | 0 | 0.00 | July 24, 2025: 2 @ 221.98 |
| Feb. 2, 2026 | issue | SO-260202-208 | MAIN | 5 | 221.98 | -1,109.89 | 2 | 443.96 | July 24, 2025: 5 @ 221.98 |
| Jan. 30, 2026 | issue | SO-260130-873 | MAIN | 1 | 221.98 | -221.98 | 7 | 1,553.84 | July 24, 2025: 1 @ 221.98 |
| Jan. 29, 2026 | issue | SO-260129-100 | MAIN | 2 | 221.98 | -443.96 | 8 | 1,775.82 | July 24, 2025: 2 @ 221.98 |
| Jan. 26, 2026 | issue | SO-260126-893 | MAIN | 1 | 221.98 | -221.98 | 10 | 2,219.78 | July 24, 2025: 1 @ 221.98 |
| Jan. 20, 2026 | issue | SO-260120-100 | MAIN | 1 | 221.98 | -221.98 | 11 | 2,441.75 | July 24, 2025: 1 @ 221.98 |
| Jan. 14, 2026 | issue | SO-260114-638 | MAIN | 1 | 221.98 | -221.98 | 12 | 2,663.73 | July 24, 2025: 1 @ 221.98 |
| Jan. 11, 2026 | issue | SO-260111-513 | MAIN | 1 | 221.98 | -221.98 | 13 | 2,885.71 | July 24, 2025: 1 @ 221.98 |
| Jan. 3, 2026 | issue | SO-260103-100 | MAIN | 1 | 221.98 | -221.98 | 14 | 3,107.68 | July 24, 2025: 1 @ 221.98 |
| Dec. 27, 2025 | issue | SO-251227-900 | MAIN | 1 | 221.98 | -221.98 | 15 | 3,329.66 | July 24, 2025: 1 @ 221.98 |
| Dec. 17, 2025 | issue | SO-251217-179 | MAIN | 2 | 221.98 | -443.96 | 16 | 3,551.64 | July 24, 2025: 2 @ 221.98 |
| Dec. 3, 2025 | issue | SO-251203-475 | MAIN | 1 | 221.98 | -221.98 | 18 | 3,995.60 | July 24, 2025: 1 @ 221.98 |
| Nov. 16, 2025 | issue | SO-251116-787 | MAIN | 1 | 221.98 | -221.98 | 19 | 4,217.57 | July 24, 2025: 1 @ 221.98 |
| Nov. 13, 2025 | issue | SO-251113-920 | MAIN | 1 | 221.98 | -221.98 | 20 | 4,439.55 | July 24, 2025: 1 @ 221.98 |
| Nov. 11, 2025 | issue | SO-251111-520 | MAIN | 1 | 221.98 | -221.98 | 21 | 4,661.53 | July 24, 2025: 1 @ 221.98 |