Items / FAN-0016
Wall Fan 400mm Max FAN-0016 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)1MAIN 1
Value (FIFO)147.37avg 147.37
ClassBY / FCV 0.72
Turnover14.9xlast issue 12 days ago
Days of cover3lead time 22d
Reorder suggested: 20 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 | 9.58 / 30.4375 | 0.315 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 6.92 / 5.517 | 1.255 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.950) | 1.645 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.645 * sqrt(21.5 * 1.255^2 + 0.315^2 * 7.4^2) | 10.3 |
| Reorder point | d * LT + safety stock | 0.315 * 21.5 + 10.3 | 17.1 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 17.1 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 115/yr, S = 45.00, h = 20%, price = 137.73 | 20.0 |
| Inventory position | on hand + on order | 1 + 0 | 1 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 149.71 | 19 | 17,761 | no |
| 10 | 143.72 | 19 | 17,062 | yes |
| 20 | 137.73 | 20 | 16,363 | yes (chosen if cheapest) |
MOQ 5, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 17, 2026 | 1 / 17 | 147.37 | 147.37 |
Movement ledger 103 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 4, 2026 | issue | SO-261004-506 | MAIN | 2 | 147.37 | -294.73 | 1 | 147.37 | Aug. 17, 2026: 2 @ 147.37 |
| Oct. 3, 2026 | issue | SO-261003-553 | MAIN | 1 | 147.37 | -147.37 | 3 | 442.10 | Aug. 17, 2026: 1 @ 147.37 |
| Oct. 1, 2026 | issue | SO-261001-733 | MAIN | 1 | 147.37 | -147.37 | 4 | 589.46 | Aug. 17, 2026: 1 @ 147.37 |
| Sept. 29, 2026 | issue | SO-260929-335 | MAIN | 1 | 147.37 | -147.37 | 5 | 736.83 | Aug. 17, 2026: 1 @ 147.37 |
| Sept. 21, 2026 | issue | SO-260921-641 | MAIN | 3 | 147.37 | -442.10 | 6 | 884.20 | Aug. 17, 2026: 3 @ 147.37 |
| Sept. 10, 2026 | issue | SO-260910-804 | EAST | 2 | 147.37 | -294.73 | 9 | 1,326.29 | Aug. 17, 2026: 2 @ 147.37 |
| Sept. 6, 2026 | issue | SO-260906-772 | MAIN | 2 | 147.37 | -294.73 | 11 | 1,621.03 | Aug. 17, 2026: 2 @ 147.37 |
| Aug. 31, 2026 | issue | SO-260831-329 | EAST | 2 | 147.37 | -294.73 | 13 | 1,915.76 | Aug. 17, 2026: 2 @ 147.37 |
| Aug. 27, 2026 | issue | SO-260827-353 | MAIN | 2 | 147.37 | -294.73 | 15 | 2,210.49 | Aug. 17, 2026: 2 @ 147.37 |
| Aug. 17, 2026 | transfer | TRF | MAIN → EAST | 4 | warehouse transfer, no cost effect | ||||
| Aug. 17, 2026 | receipt | PO-001726 | MAIN | 17 | 147.37 | 2,505.22 | 17 | 2,505.22 | |
| Aug. 8, 2026 | issue | SO-260808-906 | MAIN | 2 | 146.43 | -292.86 | 0 | 0.00 | May 19, 2026: 2 @ 146.43 |
| July 29, 2026 | issue | SO-260729-712 | MAIN | 14 | 146.43 | -2,050.03 | 2 | 292.86 | May 19, 2026: 14 @ 146.43 |
| July 21, 2026 | issue | SO-260721-874 | MAIN | 2 | 146.43 | -292.86 | 16 | 2,342.89 | May 19, 2026: 2 @ 146.43 |
| June 24, 2026 | issue | SO-260624-128 | MAIN | 2 | 146.43 | -292.86 | 18 | 2,635.75 | May 19, 2026: 2 @ 146.43 |
| June 24, 2026 | issue | SO-260624-128 | EAST | 6 | 146.43 | -878.58 | 20 | 2,928.61 | May 19, 2026: 6 @ 146.43 |
| June 15, 2026 | issue | SO-260615-373 | MAIN | 1 | 146.43 | -146.43 | 26 | 3,807.20 | May 19, 2026: 1 @ 146.43 |
| June 3, 2026 | issue | SO-260603-245 | MAIN | 2 | 146.43 | -292.86 | 27 | 3,953.63 | May 19, 2026: 2 @ 146.43 |
| June 1, 2026 | issue | SO-260601-653 | EAST | 8 | 146.00 | -1,167.99 | 29 | 4,246.49 | April 11, 2026: 1 @ 142.97; May 19, 2026: 7 @ 146.43 |
| May 20, 2026 | issue | SO-260520-399 | MAIN | 2 | 142.97 | -285.94 | 37 | 5,414.48 | April 11, 2026: 2 @ 142.97 |
| May 19, 2026 | transfer | TRF | MAIN → EAST | 11 | warehouse transfer, no cost effect | ||||
| May 19, 2026 | receipt | PO-001507 | MAIN | 36 | 146.43 | 5,271.51 | 39 | 5,700.42 | |
| May 6, 2026 | issue | SO-260506-484 | EAST | 2 | 142.97 | -285.94 | 3 | 428.92 | April 11, 2026: 2 @ 142.97 |
| May 6, 2026 | issue | SO-260506-484 | MAIN | 21 | 143.22 | -3,007.55 | 5 | 714.86 | March 25, 2026: 1 @ 148.12; April 11, 2026: 20 @ 142.97 |
| April 22, 2026 | issue | SO-260422-662 | MAIN | 5 | 148.12 | -740.58 | 26 | 3,722.41 | March 25, 2026: 5 @ 148.12 |
| April 19, 2026 | issue | SO-260419-725 | EAST | 1 | 148.12 | -148.12 | 31 | 4,462.99 | March 25, 2026: 1 @ 148.12 |
| April 12, 2026 | issue | SO-260412-245 | EAST | 1 | 148.12 | -148.12 | 32 | 4,611.10 | March 25, 2026: 1 @ 148.12 |
| April 11, 2026 | issue | SO-260411-935 | EAST | 1 | 148.12 | -148.12 | 33 | 4,759.22 | March 25, 2026: 1 @ 148.12 |
| April 11, 2026 | transfer | TRF | MAIN → EAST | 8 | warehouse transfer, no cost effect | ||||
| April 11, 2026 | receipt | PO-001398 | MAIN | 25 | 142.97 | 3,574.30 | 34 | 4,907.33 | |
| April 10, 2026 | issue | SO-260410-329 | MAIN | 3 | 148.12 | -444.35 | 9 | 1,333.04 | March 25, 2026: 3 @ 148.12 |
| April 1, 2026 | issue | SO-260401-870 | MAIN | 3 | 148.12 | -444.35 | 12 | 1,777.39 | March 25, 2026: 3 @ 148.12 |
| March 25, 2026 | receipt | PO-001352 | MAIN | 15 | 148.12 | 2,221.73 | 15 | 2,221.73 | |
| March 3, 2026 | issue | SO-260303-283 | MAIN | 3 | 140.88 | -422.65 | 0 | 0.00 | Feb. 14, 2026: 3 @ 140.88 |
| March 1, 2026 | issue | SO-260301-883 | MAIN | 3 | 140.88 | -422.65 | 3 | 422.65 | Feb. 14, 2026: 3 @ 140.88 |
| Feb. 26, 2026 | issue | SO-260226-487 | MAIN | 2 | 140.88 | -281.77 | 6 | 845.30 | Feb. 14, 2026: 2 @ 140.88 |
| Feb. 21, 2026 | issue | SO-260221-212 | MAIN | 1 | 140.88 | -140.88 | 8 | 1,127.07 | Feb. 14, 2026: 1 @ 140.88 |
| Feb. 14, 2026 | receipt | PO-001230 | MAIN | 9 | 140.88 | 1,267.95 | 9 | 1,267.95 | |
| Feb. 12, 2026 | issue | SO-260212-873 | EAST | 1 | 141.77 | -141.77 | 0 | 0.00 | Nov. 10, 2025: 1 @ 141.77 |
| Feb. 7, 2026 | issue | SO-260207-143 | EAST | 1 | 141.77 | -141.77 | 1 | 141.77 | Aug. 20, 2025: 1 @ 141.77 |
| Jan. 17, 2026 | issue | SO-260117-848 | EAST | 1 | 141.77 | -141.77 | 2 | 283.55 | Aug. 2, 2025: 1 @ 141.77 |
| Jan. 12, 2026 | issue | SO-260112-695 | EAST | 1 | 141.77 | -141.77 | 3 | 425.32 | Aug. 2, 2025: 1 @ 141.77 |
| Jan. 5, 2026 | issue | SO-260105-489 | EAST | 1 | 141.77 | -141.77 | 4 | 567.09 | Aug. 2, 2025: 1 @ 141.77 |
| Jan. 2, 2026 | issue | SO-260102-134 | EAST | 1 | 141.77 | -141.77 | 5 | 708.86 | Aug. 2, 2025: 1 @ 141.77 |
| Jan. 2, 2026 | issue | SO-260102-134 | MAIN | 2 | 141.77 | -283.55 | 6 | 850.64 | Aug. 2, 2025: 2 @ 141.77 |
| Dec. 23, 2025 | issue | SO-251223-249 | MAIN | 2 | 141.77 | -283.55 | 8 | 1,134.18 | Aug. 2, 2025: 2 @ 141.77 |
| Dec. 17, 2025 | issue | SO-251217-711 | MAIN | 1 | 141.77 | -141.77 | 10 | 1,417.73 | Aug. 2, 2025: 1 @ 141.77 |
| Dec. 5, 2025 | issue | SO-251205-778 | MAIN | 1 | 141.77 | -141.77 | 11 | 1,559.50 | Aug. 2, 2025: 1 @ 141.77 |
| Nov. 23, 2025 | issue | SO-251123-595 | MAIN | 1 | 141.77 | -141.77 | 12 | 1,701.27 | Aug. 2, 2025: 1 @ 141.77 |
| Nov. 10, 2025 | return | RMA | MAIN | 1 | 141.77 | 141.77 | 13 | 1,843.05 | |
| Nov. 5, 2025 | issue | SO-251105-552 | MAIN | 1 | 141.77 | -141.77 | 12 | 1,701.27 | Aug. 2, 2025: 1 @ 141.77 |
| Oct. 20, 2025 | issue | SO-251020-516 | MAIN | 2 | 141.77 | -283.55 | 13 | 1,843.05 | Aug. 2, 2025: 2 @ 141.77 |
| Oct. 10, 2025 | issue | SO-251010-363 | MAIN | 1 | 141.77 | -141.77 | 15 | 2,126.59 | Aug. 2, 2025: 1 @ 141.77 |
| Oct. 9, 2025 | issue | SO-251009-746 | MAIN | 2 | 141.77 | -283.55 | 16 | 2,268.36 | Aug. 2, 2025: 2 @ 141.77 |
| Sept. 11, 2025 | issue | SO-250911-191 | MAIN | 3 | 141.77 | -425.32 | 18 | 2,551.91 | Aug. 2, 2025: 3 @ 141.77 |
| Sept. 7, 2025 | issue | SO-250907-275 | MAIN | 1 | 141.77 | -141.77 | 21 | 2,977.23 | Aug. 2, 2025: 1 @ 141.77 |
| Aug. 26, 2025 | issue | SO-250826-846 | MAIN | 1 | 141.77 | -141.77 | 22 | 3,119.00 | Aug. 2, 2025: 1 @ 141.77 |
| Aug. 21, 2025 | issue | SO-250821-765 | MAIN | 2 | 141.77 | -283.55 | 23 | 3,260.77 | Aug. 2, 2025: 2 @ 141.77 |
| Aug. 20, 2025 | return | RMA | MAIN | 1 | 141.77 | 141.77 | 25 | 3,544.32 | |
| Aug. 10, 2025 | issue | SO-250810-696 | MAIN | 1 | 141.77 | -141.77 | 24 | 3,402.54 | Aug. 2, 2025: 1 @ 141.77 |
| Aug. 7, 2025 | issue | SO-250807-334 | MAIN | 1 | 141.77 | -141.77 | 25 | 3,544.32 | Aug. 2, 2025: 1 @ 141.77 |
| Aug. 5, 2025 | issue | SO-250805-934 | EAST | 2 | 141.77 | -283.55 | 26 | 3,686.09 | Aug. 2, 2025: 2 @ 141.77 |
| Aug. 2, 2025 | transfer | TRF | MAIN → EAST | 8 | warehouse transfer, no cost effect | ||||
| Aug. 2, 2025 | receipt | PO-000751 | MAIN | 28 | 141.77 | 3,969.64 | 28 | 3,969.64 | |
| July 27, 2025 | issue | SO-250727-530 | MAIN | 7 | 140.39 | -982.76 | 0 | 0.00 | June 8, 2025: 7 @ 140.39 |
| July 24, 2025 | issue | SO-250724-384 | MAIN | 7 | 140.39 | -982.76 | 7 | 982.76 | June 8, 2025: 7 @ 140.39 |
| July 8, 2025 | issue | SO-250708-709 | MAIN | 2 | 140.39 | -280.79 | 14 | 1,965.52 | June 8, 2025: 2 @ 140.39 |
| June 27, 2025 | issue | SO-250627-915 | MAIN | 10 | 140.39 | -1,403.94 | 16 | 2,246.30 | June 8, 2025: 10 @ 140.39 |
| June 20, 2025 | issue | SO-250620-536 | MAIN | 1 | 140.39 | -140.39 | 26 | 3,650.24 | June 8, 2025: 1 @ 140.39 |
| June 19, 2025 | issue | SO-250619-283 | MAIN | 17 | 138.88 | -2,361.00 | 27 | 3,790.64 | May 4, 2025: 7 @ 136.72; June 8, 2025: 10 @ 140.39 |
| June 8, 2025 | receipt | PO-000617 | MAIN | 37 | 140.39 | 5,194.58 | 44 | 6,151.64 | |
| May 31, 2025 | issue | SO-250531-157 | MAIN | 8 | 136.72 | -1,093.79 | 7 | 957.06 | May 4, 2025: 8 @ 136.72 |
| May 27, 2025 | issue | SO-250527-525 | MAIN | 1 | 136.72 | -136.72 | 15 | 2,050.85 | May 4, 2025: 1 @ 136.72 |
| May 24, 2025 | issue | SO-250524-991 | MAIN | 2 | 136.72 | -273.45 | 16 | 2,187.57 | May 4, 2025: 2 @ 136.72 |
| May 24, 2025 | issue | SO-250524-991 | EAST | 9 | 136.72 | -1,230.51 | 18 | 2,461.02 | May 4, 2025: 9 @ 136.72 |
| May 18, 2025 | issue | SO-250518-363 | MAIN | 3 | 136.72 | -410.17 | 27 | 3,691.53 | May 4, 2025: 3 @ 136.72 |
| May 11, 2025 | issue | SO-250511-135 | MAIN | 4 | 136.72 | -546.89 | 30 | 4,101.70 | May 4, 2025: 4 @ 136.72 |
| May 10, 2025 | issue | SO-250510-197 | MAIN | 2 | 136.72 | -273.45 | 34 | 4,648.59 | May 4, 2025: 2 @ 136.72 |
| May 4, 2025 | transfer | TRF | MAIN → EAST | 9 | warehouse transfer, no cost effect | ||||
| May 4, 2025 | receipt | PO-000512 | MAIN | 36 | 136.72 | 4,922.04 | 36 | 4,922.04 | |
| April 24, 2025 | issue | SO-250424-786 | MAIN | 9 | 140.19 | -1,261.68 | 0 | 0.00 | March 25, 2025: 9 @ 140.19 |
| April 15, 2025 | issue | SO-250415-247 | MAIN | 6 | 140.19 | -841.12 | 9 | 1,261.68 | March 25, 2025: 6 @ 140.19 |
| March 31, 2025 | issue | SO-250331-425 | MAIN | 1 | 136.22 | -136.22 | 15 | 2,102.80 | Feb. 19, 2025: 1 @ 136.22 |
| March 28, 2025 | issue | SO-250328-780 | MAIN | 2 | 136.22 | -272.43 | 16 | 2,239.02 | Feb. 19, 2025: 2 @ 136.22 |
| March 25, 2025 | receipt | PO-000378 | MAIN | 15 | 140.19 | 2,102.80 | 18 | 2,511.45 | |
| March 19, 2025 | issue | SO-250319-193 | MAIN | 1 | 136.22 | -136.22 | 3 | 408.65 | Feb. 19, 2025: 1 @ 136.22 |
| March 13, 2025 | issue | SO-250313-731 | MAIN | 2 | 136.22 | -272.43 | 4 | 544.86 | Feb. 19, 2025: 2 @ 136.22 |
| March 3, 2025 | issue | SO-250303-574 | MAIN | 5 | 138.62 | -693.09 | 6 | 817.29 | Oct. 1, 2024: 1 @ 142.22; Jan. 27, 2025: 1 @ 142.22; Feb. 19, 2025: 3 @ 136.22 |
| Feb. 20, 2025 | issue | SO-250220-707 | MAIN | 1 | 142.22 | -142.22 | 11 | 1,510.38 | Oct. 1, 2024: 1 @ 142.22 |
| Feb. 19, 2025 | receipt | PO-000279 | MAIN | 9 | 136.22 | 1,225.94 | 12 | 1,652.61 | |
| Feb. 4, 2025 | issue | SO-250204-468 | MAIN | 1 | 142.22 | -142.22 | 3 | 426.67 | Oct. 1, 2024: 1 @ 142.22 |
| Feb. 1, 2025 | issue | SO-250201-119 | MAIN | 2 | 142.22 | -284.45 | 4 | 568.90 | Oct. 1, 2024: 2 @ 142.22 |
| Jan. 27, 2025 | return | RMA | MAIN | 1 | 142.22 | 142.22 | 6 | 853.35 | |
| Jan. 18, 2025 | issue | SO-250118-564 | MAIN | 1 | 142.22 | -142.22 | 5 | 711.12 | Oct. 1, 2024: 1 @ 142.22 |
| Jan. 17, 2025 | issue | SO-250117-473 | MAIN | 3 | 142.22 | -426.67 | 6 | 853.35 | Oct. 1, 2024: 3 @ 142.22 |
| Dec. 12, 2024 | issue | SO-241212-720 | EAST | 2 | 142.22 | -284.45 | 9 | 1,280.02 | Oct. 1, 2024: 2 @ 142.22 |
| Dec. 1, 2024 | issue | SO-241201-135 | MAIN | 1 | 142.22 | -142.22 | 11 | 1,564.47 | Oct. 1, 2024: 1 @ 142.22 |
| Nov. 6, 2024 | issue | SO-241106-234 | MAIN | 1 | 142.22 | -142.22 | 12 | 1,706.69 | Oct. 1, 2024: 1 @ 142.22 |
| Nov. 5, 2024 | issue | SO-241105-620 | MAIN | 1 | 142.22 | -142.22 | 13 | 1,848.92 | Oct. 1, 2024: 1 @ 142.22 |
| Oct. 8, 2024 | issue | SO-241008-472 | MAIN | 2 | 142.22 | -284.45 | 14 | 1,991.14 | Oct. 1, 2024: 2 @ 142.22 |
| Oct. 4, 2024 | issue | SO-241004-295 | EAST | 2 | 142.22 | -284.45 | 16 | 2,275.59 | Oct. 1, 2024: 2 @ 142.22 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 4 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000003 | MAIN | 18 | 142.22 | 2,560.04 | 18 | 2,560.04 | |