Items / FAN-0011
Pedestal Fan Max FAN-0011 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)6MAIN 6
Value (FIFO)1,607.88avg 267.98
ClassAY / FCV 0.68
Turnover16.1xlast issue 11 days ago
Days of cover13lead time 22d
Reorder suggested: 32 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 | 14.50 / 30.4375 | 0.476 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 9.88 / 5.517 | 1.791 |
| 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 * 1.791^2 + 0.476^2 * 7.4^2) | 18.5 |
| Reorder point | d * LT + safety stock | 0.476 * 21.5 + 18.5 | 28.8 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 28.8 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 174/yr, S = 45.00, h = 20%, price = 248.53 | 32.0 |
| Inventory position | on hand + on order | 6 + 0 | 6 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 270.14 | 17 | 47,892 | no |
| 16 | 259.33 | 17 | 45,994 | yes |
| 32 | 248.53 | 32 | 44,254 | yes (chosen if cheapest) |
MOQ 8, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 11, 2026 | 6 / 27 | 267.98 | 1,607.88 |
Movement ledger 109 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 5, 2026 | issue | SO-261005-903 | MAIN | 3 | 267.98 | -803.94 | 6 | 1,607.88 | Aug. 11, 2026: 3 @ 267.98 |
| Oct. 2, 2026 | issue | SO-261002-340 | MAIN | 3 | 267.98 | -803.94 | 9 | 2,411.83 | Aug. 11, 2026: 3 @ 267.98 |
| Sept. 25, 2026 | issue | SO-260925-967 | MAIN | 3 | 267.98 | -803.94 | 12 | 3,215.77 | Aug. 11, 2026: 3 @ 267.98 |
| Sept. 16, 2026 | issue | SO-260916-346 | MAIN | 3 | 267.98 | -803.94 | 15 | 4,019.71 | Aug. 11, 2026: 3 @ 267.98 |
| Sept. 3, 2026 | issue | SO-260903-392 | MAIN | 5 | 267.98 | -1,339.90 | 18 | 4,823.65 | Aug. 11, 2026: 5 @ 267.98 |
| Aug. 29, 2026 | issue | SO-260829-665 | EAST | 8 | 268.40 | -2,147.21 | 23 | 6,163.56 | May 5, 2026: 4 @ 268.82; Aug. 11, 2026: 4 @ 267.98 |
| Aug. 17, 2026 | issue | SO-260817-437 | MAIN | 8 | 268.82 | -2,150.56 | 31 | 8,310.76 | May 5, 2026: 8 @ 268.82 |
| Aug. 14, 2026 | issue | SO-260814-739 | EAST | 1 | 268.82 | -268.82 | 39 | 10,461.33 | May 5, 2026: 1 @ 268.82 |
| Aug. 11, 2026 | transfer | TRF | MAIN → EAST | 9 | warehouse transfer, no cost effect | ||||
| Aug. 11, 2026 | receipt | PO-001713 | MAIN | 27 | 267.98 | 7,235.48 | 40 | 10,730.15 | |
| July 20, 2026 | issue | SO-260720-171 | MAIN | 2 | 268.82 | -537.64 | 13 | 3,494.67 | May 5, 2026: 2 @ 268.82 |
| July 15, 2026 | issue | SO-260715-627 | MAIN | 6 | 268.82 | -1,612.92 | 15 | 4,032.31 | May 5, 2026: 6 @ 268.82 |
| July 13, 2026 | issue | SO-260713-774 | MAIN | 15 | 268.82 | -4,032.31 | 21 | 5,645.23 | May 5, 2026: 15 @ 268.82 |
| June 28, 2026 | issue | SO-260628-456 | MAIN | 4 | 268.82 | -1,075.28 | 36 | 9,677.54 | May 5, 2026: 4 @ 268.82 |
| June 25, 2026 | issue | SO-260625-773 | MAIN | 1 | 268.82 | -268.82 | 40 | 10,752.82 | May 5, 2026: 1 @ 268.82 |
| June 14, 2026 | issue | SO-260614-904 | MAIN | 2 | 268.82 | -537.64 | 41 | 11,021.64 | May 5, 2026: 2 @ 268.82 |
| June 2, 2026 | issue | SO-260602-300 | MAIN | 15 | 268.82 | -4,032.31 | 43 | 11,559.29 | May 5, 2026: 15 @ 268.82 |
| June 2, 2026 | issue | SO-260602-300 | EAST | 1 | 268.82 | -268.82 | 58 | 15,591.59 | May 5, 2026: 1 @ 268.82 |
| May 19, 2026 | issue | SO-260519-259 | MAIN | 20 | 259.06 | -5,181.22 | 59 | 15,860.42 | April 10, 2026: 20 @ 259.06 |
| May 5, 2026 | receipt | PO-001466 | MAIN | 59 | 268.82 | 15,860.42 | 79 | 21,041.64 | |
| May 3, 2026 | issue | SO-260503-492 | MAIN | 18 | 259.06 | -4,663.10 | 20 | 5,181.22 | April 10, 2026: 18 @ 259.06 |
| April 28, 2026 | issue | SO-260428-783 | MAIN | 5 | 261.28 | -1,306.42 | 38 | 9,844.32 | Feb. 22, 2026: 3 @ 262.77; April 10, 2026: 2 @ 259.06 |
| April 26, 2026 | issue | SO-260426-852 | MAIN | 8 | 262.77 | -2,102.13 | 43 | 11,150.74 | Feb. 22, 2026: 8 @ 262.77 |
| April 18, 2026 | issue | SO-260418-600 | MAIN | 9 | 262.77 | -2,364.90 | 51 | 13,252.88 | Feb. 22, 2026: 9 @ 262.77 |
| April 10, 2026 | receipt | PO-001395 | MAIN | 40 | 259.06 | 10,362.44 | 60 | 15,617.77 | |
| March 26, 2026 | issue | SO-260326-189 | MAIN | 1 | 262.77 | -262.77 | 20 | 5,255.33 | Feb. 22, 2026: 1 @ 262.77 |
| March 22, 2026 | issue | SO-260322-488 | MAIN | 3 | 262.77 | -788.30 | 21 | 5,518.10 | Feb. 22, 2026: 3 @ 262.77 |
| March 16, 2026 | issue | SO-260316-358 | EAST | 4 | 263.60 | -1,054.39 | 24 | 6,306.40 | Feb. 11, 2026: 3 @ 266.09; Feb. 11, 2026: 1 @ 256.13 |
| March 7, 2026 | issue | SO-260307-177 | MAIN | 3 | 266.09 | -798.26 | 28 | 7,360.79 | Feb. 11, 2026: 3 @ 266.09 |
| Feb. 24, 2026 | issue | SO-260224-392 | EAST | 1 | 266.09 | -266.09 | 31 | 8,159.05 | Feb. 11, 2026: 1 @ 266.09 |
| Feb. 23, 2026 | issue | SO-260223-839 | EAST | 1 | 266.09 | -266.09 | 32 | 8,425.14 | Feb. 11, 2026: 1 @ 266.09 |
| Feb. 22, 2026 | transfer | TRF | MAIN → EAST | 7 | warehouse transfer, no cost effect | ||||
| Feb. 22, 2026 | receipt | PO-001250 | MAIN | 24 | 262.77 | 6,306.40 | 33 | 8,691.23 | |
| Feb. 13, 2026 | issue | SO-260213-344 | MAIN | 1 | 266.09 | -266.09 | 9 | 2,384.83 | Feb. 11, 2026: 1 @ 266.09 |
| Feb. 12, 2026 | issue | SO-260212-226 | MAIN | 3 | 266.09 | -798.26 | 10 | 2,650.92 | Feb. 11, 2026: 3 @ 266.09 |
| Feb. 11, 2026 | return | RMA | MAIN | 1 | 256.13 | 256.13 | 13 | 3,449.19 | |
| Feb. 11, 2026 | receipt | PO-001217 | MAIN | 12 | 266.09 | 3,193.06 | 12 | 3,193.06 | |
| Feb. 1, 2026 | issue | SO-260201-473 | MAIN | 1 | 256.13 | -256.13 | 0 | 0.00 | June 20, 2025: 1 @ 256.13 |
| Jan. 18, 2026 | issue | SO-260118-642 | MAIN | 3 | 256.13 | -768.39 | 1 | 256.13 | June 20, 2025: 3 @ 256.13 |
| Jan. 12, 2026 | issue | SO-260112-944 | MAIN | 2 | 256.13 | -512.26 | 4 | 1,024.51 | June 20, 2025: 2 @ 256.13 |
| Jan. 9, 2026 | issue | SO-260109-285 | MAIN | 1 | 256.13 | -256.13 | 6 | 1,536.77 | June 20, 2025: 1 @ 256.13 |
| Dec. 6, 2025 | issue | SO-251206-263 | MAIN | 1 | 256.13 | -256.13 | 7 | 1,792.90 | June 20, 2025: 1 @ 256.13 |
| Dec. 5, 2025 | issue | SO-251205-177 | MAIN | 1 | 256.13 | -256.13 | 8 | 2,049.03 | June 20, 2025: 1 @ 256.13 |
| Dec. 4, 2025 | issue | SO-251204-319 | MAIN | 1 | 256.13 | -256.13 | 9 | 2,305.16 | June 20, 2025: 1 @ 256.13 |
| Dec. 1, 2025 | issue | SO-251201-736 | MAIN | 2 | 256.13 | -512.26 | 10 | 2,561.28 | June 20, 2025: 2 @ 256.13 |
| Nov. 29, 2025 | issue | SO-251129-338 | MAIN | 3 | 256.13 | -768.39 | 12 | 3,073.54 | June 20, 2025: 3 @ 256.13 |
| Nov. 9, 2025 | issue | SO-251109-632 | MAIN | 1 | 256.13 | -256.13 | 15 | 3,841.93 | June 20, 2025: 1 @ 256.13 |
| Oct. 16, 2025 | issue | SO-251016-577 | MAIN | 1 | 256.13 | -256.13 | 16 | 4,098.05 | June 20, 2025: 1 @ 256.13 |
| Oct. 14, 2025 | issue | SO-251014-157 | MAIN | 3 | 256.13 | -768.39 | 17 | 4,354.18 | June 20, 2025: 3 @ 256.13 |
| Oct. 9, 2025 | adjustment | Cycle count | MAIN | -1 | 256.13 | -256.13 | 20 | 5,122.57 | June 20, 2025: 1 @ 256.13 |
| Oct. 9, 2025 | issue | SO-251009-369 | MAIN | 2 | 256.13 | -512.26 | 21 | 5,378.70 | June 20, 2025: 2 @ 256.13 |
| Oct. 4, 2025 | issue | SO-251004-576 | MAIN | 1 | 256.13 | -256.13 | 23 | 5,890.95 | June 20, 2025: 1 @ 256.13 |
| Oct. 2, 2025 | issue | SO-251002-981 | MAIN | 1 | 256.13 | -256.13 | 24 | 6,147.08 | June 20, 2025: 1 @ 256.13 |
| Sept. 19, 2025 | issue | SO-250919-506 | MAIN | 5 | 256.13 | -1,280.64 | 25 | 6,403.21 | June 20, 2025: 5 @ 256.13 |
| Sept. 15, 2025 | issue | SO-250915-369 | MAIN | 1 | 256.13 | -256.13 | 30 | 7,683.85 | June 20, 2025: 1 @ 256.13 |
| Sept. 1, 2025 | issue | SO-250901-569 | MAIN | 1 | 256.13 | -256.13 | 31 | 7,939.98 | June 20, 2025: 1 @ 256.13 |
| Aug. 28, 2025 | issue | SO-250828-466 | MAIN | 1 | 256.13 | -256.13 | 32 | 8,196.11 | June 20, 2025: 1 @ 256.13 |
| Aug. 23, 2025 | issue | SO-250823-622 | MAIN | 5 | 256.13 | -1,280.64 | 33 | 8,452.24 | June 20, 2025: 5 @ 256.13 |
| Aug. 16, 2025 | issue | SO-250816-858 | MAIN | 2 | 256.13 | -512.26 | 38 | 9,732.88 | June 20, 2025: 2 @ 256.13 |
| Aug. 15, 2025 | issue | SO-250815-888 | MAIN | 5 | 256.13 | -1,280.64 | 40 | 10,245.14 | June 20, 2025: 5 @ 256.13 |