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
| 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 |
| Aug. 8, 2025 | issue | SO-250808-732 | MAIN | 3 | 256.13 | -768.39 | 45 | 11,525.78 | June 20, 2025: 3 @ 256.13 |
| July 26, 2025 | issue | SO-250726-943 | EAST | 12 | 256.13 | -3,073.54 | 48 | 12,294.16 | June 20, 2025: 12 @ 256.13 |
| July 24, 2025 | issue | SO-250724-851 | EAST | 8 | 257.45 | -2,059.56 | 60 | 15,367.70 | May 18, 2025: 6 @ 257.88; June 20, 2025: 2 @ 256.13 |
| June 27, 2025 | issue | SO-250627-296 | MAIN | 1 | 257.88 | -257.88 | 68 | 17,427.27 | May 18, 2025: 1 @ 257.88 |
| June 22, 2025 | issue | SO-250622-851 | MAIN | 4 | 257.88 | -1,031.54 | 69 | 17,685.15 | May 18, 2025: 4 @ 257.88 |
| June 20, 2025 | transfer | TRF | MAIN → EAST | 20 | warehouse transfer, no cost effect | ||||
| June 20, 2025 | receipt | PO-000651 | MAIN | 62 | 256.13 | 15,879.96 | 73 | 18,716.69 | |
| June 5, 2025 | issue | SO-250605-726 | MAIN | 1 | 257.88 | -257.88 | 11 | 2,836.73 | May 18, 2025: 1 @ 257.88 |
| June 4, 2025 | issue | SO-250604-864 | MAIN | 6 | 257.88 | -1,547.31 | 12 | 3,094.61 | May 18, 2025: 6 @ 257.88 |
| June 3, 2025 | issue | SO-250603-663 | MAIN | 23 | 257.88 | -5,931.34 | 18 | 4,641.92 | May 18, 2025: 23 @ 257.88 |
| May 24, 2025 | issue | SO-250524-812 | MAIN | 8 | 257.88 | -2,063.08 | 41 | 10,573.26 | May 18, 2025: 8 @ 257.88 |
| May 23, 2025 | issue | SO-250523-247 | MAIN | 9 | 257.88 | -2,320.96 | 49 | 12,636.34 | May 18, 2025: 9 @ 257.88 |
| May 19, 2025 | issue | SO-250519-378 | MAIN | 1 | 257.88 | -257.88 | 58 | 14,957.30 | May 18, 2025: 1 @ 257.88 |
| May 18, 2025 | receipt | PO-000546 | MAIN | 59 | 257.88 | 15,215.19 | 59 | 15,215.19 | |
| May 9, 2025 | issue | SO-250509-131 | MAIN | 3 | 252.14 | -756.42 | 0 | 0.00 | April 15, 2025: 3 @ 252.14 |
| May 4, 2025 | issue | SO-250504-502 | MAIN | 10 | 252.14 | -2,521.40 | 3 | 756.42 | April 15, 2025: 10 @ 252.14 |
| May 2, 2025 | issue | SO-250502-239 | MAIN | 4 | 252.14 | -1,008.56 | 13 | 3,277.81 | April 15, 2025: 4 @ 252.14 |
| April 22, 2025 | adjustment | Cycle count | MAIN | -2 | 252.14 | -504.28 | 17 | 4,286.37 | April 15, 2025: 2 @ 252.14 |
| April 19, 2025 | issue | SO-250419-343 | MAIN | 21 | 252.14 | -5,294.93 | 19 | 4,790.65 | April 15, 2025: 21 @ 252.14 |
| April 15, 2025 | receipt | PO-000449 | MAIN | 40 | 252.14 | 10,085.58 | 40 | 10,085.58 | |
| March 28, 2025 | issue | SO-250328-795 | EAST | 1 | 251.68 | -251.68 | 0 | 0.00 | March 2, 2025: 1 @ 251.68 |
| March 25, 2025 | issue | SO-250325-970 | EAST | 4 | 251.68 | -1,006.73 | 1 | 251.68 | March 2, 2025: 4 @ 251.68 |
| March 25, 2025 | issue | SO-250325-970 | MAIN | 3 | 251.68 | -755.05 | 5 | 1,258.41 | March 2, 2025: 3 @ 251.68 |
| March 23, 2025 | issue | SO-250323-447 | MAIN | 3 | 251.68 | -755.05 | 8 | 2,013.46 | March 2, 2025: 3 @ 251.68 |
| March 18, 2025 | issue | SO-250318-820 | MAIN | 3 | 251.68 | -755.05 | 11 | 2,768.50 | March 2, 2025: 3 @ 251.68 |
| March 10, 2025 | issue | SO-250310-134 | MAIN | 1 | 251.68 | -251.68 | 14 | 3,523.55 | March 2, 2025: 1 @ 251.68 |
| March 2, 2025 | transfer | TRF | MAIN → EAST | 5 | warehouse transfer, no cost effect | ||||
| March 2, 2025 | receipt | PO-000307 | MAIN | 15 | 251.68 | 3,775.23 | 15 | 3,775.23 | |
| Feb. 23, 2025 | issue | SO-250223-994 | EAST | 1 | 256.63 | -256.63 | 0 | 0.00 | Oct. 1, 2024: 1 @ 256.63 |
| Feb. 23, 2025 | issue | SO-250223-994 | MAIN | 4 | 256.63 | -1,026.53 | 1 | 256.63 | Oct. 1, 2024: 4 @ 256.63 |
| Jan. 31, 2025 | issue | SO-250131-349 | MAIN | 3 | 256.63 | -769.90 | 5 | 1,283.16 | Oct. 1, 2024: 3 @ 256.63 |
| Jan. 29, 2025 | issue | SO-250129-926 | MAIN | 3 | 256.63 | -769.90 | 8 | 2,053.06 | Oct. 1, 2024: 3 @ 256.63 |
| Jan. 25, 2025 | issue | SO-250125-689 | MAIN | 1 | 256.63 | -256.63 | 11 | 2,822.96 | Oct. 1, 2024: 1 @ 256.63 |
| Jan. 16, 2025 | issue | SO-250116-624 | EAST | 1 | 256.63 | -256.63 | 12 | 3,079.60 | Oct. 1, 2024: 1 @ 256.63 |
| Jan. 3, 2025 | issue | SO-250103-830 | MAIN | 1 | 256.63 | -256.63 | 13 | 3,336.23 | Oct. 1, 2024: 1 @ 256.63 |
| Jan. 2, 2025 | issue | SO-250102-672 | MAIN | 1 | 256.63 | -256.63 | 14 | 3,592.86 | Oct. 1, 2024: 1 @ 256.63 |
| Dec. 25, 2024 | issue | SO-241225-683 | MAIN | 1 | 256.63 | -256.63 | 15 | 3,849.50 | Oct. 1, 2024: 1 @ 256.63 |
| Dec. 18, 2024 | issue | SO-241218-949 | EAST | 1 | 256.63 | -256.63 | 16 | 4,106.13 | Oct. 1, 2024: 1 @ 256.63 |
| Dec. 13, 2024 | issue | SO-241213-205 | EAST | 2 | 256.63 | -513.27 | 17 | 4,362.76 | Oct. 1, 2024: 2 @ 256.63 |
| Nov. 20, 2024 | issue | SO-241120-178 | MAIN | 1 | 256.63 | -256.63 | 19 | 4,876.03 | Oct. 1, 2024: 1 @ 256.63 |
| Nov. 19, 2024 | issue | SO-241119-953 | EAST | 1 | 256.63 | -256.63 | 20 | 5,132.66 | Oct. 1, 2024: 1 @ 256.63 |
| Nov. 2, 2024 | issue | SO-241102-216 | EAST | 1 | 256.63 | -256.63 | 21 | 5,389.29 | Oct. 1, 2024: 1 @ 256.63 |
| Oct. 23, 2024 | issue | SO-241023-669 | MAIN | 2 | 256.63 | -513.27 | 22 | 5,645.93 | Oct. 1, 2024: 2 @ 256.63 |
| Oct. 20, 2024 | issue | SO-241020-391 | EAST | 1 | 256.63 | -256.63 | 24 | 6,159.19 | Oct. 1, 2024: 1 @ 256.63 |
| Oct. 13, 2024 | issue | SO-241013-726 | MAIN | 1 | 256.63 | -256.63 | 25 | 6,415.82 | Oct. 1, 2024: 1 @ 256.63 |
| Oct. 11, 2024 | issue | SO-241011-402 | MAIN | 3 | 256.63 | -769.90 | 26 | 6,672.46 | Oct. 1, 2024: 3 @ 256.63 |
| Oct. 10, 2024 | issue | SO-241010-976 | MAIN | 1 | 256.63 | -256.63 | 29 | 7,442.36 | Oct. 1, 2024: 1 @ 256.63 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 8 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000003 | MAIN | 30 | 256.63 | 7,698.99 | 30 | 7,698.99 | |