Items / FAN-0004
Table Fan 300mm Nova FAN-0004 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)19MAIN 14, EAST 5
Value (FIFO)3,535.78avg 186.09
ClassAY / FCV 0.81
Turnover13.9xlast issue 9 days ago
Days of cover19lead time 22d
Reorder suggested: 60 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 | 30.33 / 30.4375 | 0.997 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 24.64 / 5.517 | 4.467 |
| 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 * 4.467^2 + 0.997^2 * 7.4^2) | 45.1 |
| Reorder point | d * LT + safety stock | 0.997 * 21.5 + 45.1 | 66.6 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 66.6 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 364/yr, S = 45.00, h = 20%, price = 183.42 | 29.9 |
| Inventory position | on hand + on order | 19 + 0 | 19 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 183.42 | 30 | 67,815 | yes (chosen if cheapest) |
MOQ 13, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 12, 2026 | 19 / 19 | 186.09 | 3,535.78 |
Movement ledger 117 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 12, 2026 | transfer | TRF | MAIN → EAST | 5 | warehouse transfer, no cost effect | ||||
| Oct. 12, 2026 | receipt | PO-001872 | MAIN | 19 | 186.09 | 3,535.78 | 19 | 3,535.78 | |
| Oct. 7, 2026 | issue | SO-261007-942 | MAIN | 2 | 179.18 | -358.36 | 0 | 0.00 | May 29, 2026: 2 @ 179.18 |
| Oct. 6, 2026 | issue | SO-261006-100 | MAIN | 2 | 179.18 | -358.36 | 2 | 358.36 | May 29, 2026: 2 @ 179.18 |
| Oct. 5, 2026 | issue | SO-261005-310 | MAIN | 3 | 179.18 | -537.54 | 4 | 716.72 | May 29, 2026: 3 @ 179.18 |
| Oct. 4, 2026 | issue | SO-261004-292 | MAIN | 1 | 179.18 | -179.18 | 7 | 1,254.27 | May 29, 2026: 1 @ 179.18 |
| Oct. 1, 2026 | issue | SO-261001-763 | MAIN | 1 | 179.18 | -179.18 | 8 | 1,433.45 | May 29, 2026: 1 @ 179.18 |
| Sept. 28, 2026 | issue | SO-260928-787 | MAIN | 12 | 179.18 | -2,150.17 | 9 | 1,612.63 | May 29, 2026: 12 @ 179.18 |
| Sept. 6, 2026 | issue | SO-260906-982 | MAIN | 3 | 179.18 | -537.54 | 21 | 3,762.80 | May 29, 2026: 3 @ 179.18 |
| Sept. 5, 2026 | issue | SO-260905-632 | MAIN | 6 | 179.18 | -1,075.09 | 24 | 4,300.35 | May 29, 2026: 6 @ 179.18 |
| Aug. 26, 2026 | issue | SO-260826-657 | MAIN | 5 | 179.18 | -895.91 | 30 | 5,375.43 | May 29, 2026: 5 @ 179.18 |
| Aug. 24, 2026 | issue | SO-260824-421 | MAIN | 2 | 179.18 | -358.36 | 35 | 6,271.34 | May 29, 2026: 2 @ 179.18 |
| Aug. 23, 2026 | issue | SO-260823-438 | MAIN | 1 | 179.18 | -179.18 | 37 | 6,629.70 | May 29, 2026: 1 @ 179.18 |
| Aug. 20, 2026 | issue | SO-260820-480 | MAIN | 4 | 179.18 | -716.72 | 38 | 6,808.88 | May 29, 2026: 4 @ 179.18 |
| Aug. 17, 2026 | issue | SO-260817-212 | MAIN | 3 | 179.18 | -537.54 | 42 | 7,525.61 | May 29, 2026: 3 @ 179.18 |
| Aug. 13, 2026 | issue | SO-260813-469 | MAIN | 5 | 179.18 | -895.91 | 45 | 8,063.15 | May 29, 2026: 5 @ 179.18 |
| July 29, 2026 | issue | SO-260729-150 | MAIN | 7 | 179.18 | -1,254.27 | 50 | 8,959.06 | May 29, 2026: 7 @ 179.18 |
| July 15, 2026 | issue | SO-260715-850 | MAIN | 21 | 179.18 | -3,762.80 | 57 | 10,213.32 | May 29, 2026: 21 @ 179.18 |
| July 7, 2026 | issue | SO-260707-747 | MAIN | 14 | 179.18 | -2,508.54 | 78 | 13,976.13 | May 29, 2026: 14 @ 179.18 |
| July 3, 2026 | issue | SO-260703-402 | MAIN | 5 | 179.18 | -895.91 | 92 | 16,484.66 | May 29, 2026: 5 @ 179.18 |
| June 6, 2026 | issue | SO-260606-640 | MAIN | 16 | 177.82 | -2,845.15 | 97 | 17,380.57 | May 10, 2026: 8 @ 176.46; May 29, 2026: 8 @ 179.18 |
| June 4, 2026 | issue | SO-260604-444 | MAIN | 40 | 176.46 | -7,058.52 | 113 | 20,225.72 | May 10, 2026: 40 @ 176.46 |
| May 29, 2026 | receipt | PO-001530 | MAIN | 105 | 179.18 | 18,814.02 | 153 | 27,284.23 | |
| May 15, 2026 | issue | SO-260515-149 | MAIN | 20 | 176.46 | -3,529.26 | 48 | 8,470.22 | May 10, 2026: 20 @ 176.46 |
| May 14, 2026 | issue | SO-260514-819 | MAIN | 7 | 176.46 | -1,235.24 | 68 | 11,999.48 | May 10, 2026: 7 @ 176.46 |
| May 10, 2026 | issue | SO-260510-802 | MAIN | 26 | 176.46 | -4,588.04 | 75 | 13,234.72 | May 10, 2026: 26 @ 176.46 |
| May 10, 2026 | receipt | PO-001479 | MAIN | 101 | 176.46 | 17,822.75 | 101 | 17,822.75 | |
| April 25, 2026 | issue | SO-260425-547 | MAIN | 39 | 174.86 | -6,819.45 | 0 | 0.00 | April 2, 2026: 39 @ 174.86 |
| April 17, 2026 | issue | SO-260417-804 | MAIN | 51 | 175.18 | -8,934.40 | 39 | 6,819.45 | March 2, 2026: 21 @ 175.65; April 2, 2026: 30 @ 174.86 |
| April 2, 2026 | receipt | PO-001375 | MAIN | 69 | 174.86 | 12,065.18 | 90 | 15,753.85 | |
| March 17, 2026 | issue | SO-260317-677 | MAIN | 3 | 175.65 | -526.95 | 21 | 3,688.67 | March 2, 2026: 3 @ 175.65 |
| March 8, 2026 | issue | SO-260308-585 | MAIN | 18 | 175.65 | -3,161.71 | 24 | 4,215.62 | March 2, 2026: 18 @ 175.65 |
| March 2, 2026 | receipt | PO-001274 | MAIN | 42 | 175.65 | 7,377.33 | 42 | 7,377.33 | |
| Feb. 23, 2026 | issue | SO-260223-266 | MAIN | 11 | 175.92 | -1,935.13 | 0 | 0.00 | Jan. 29, 2026: 11 @ 175.92 |
| Feb. 17, 2026 | issue | SO-260217-740 | MAIN | 3 | 175.92 | -527.76 | 11 | 1,935.13 | Jan. 29, 2026: 3 @ 175.92 |
| Feb. 4, 2026 | issue | SO-260204-331 | MAIN | 6 | 175.92 | -1,055.53 | 14 | 2,462.90 | Jan. 29, 2026: 6 @ 175.92 |
| Feb. 2, 2026 | issue | SO-260202-458 | MAIN | 1 | 175.92 | -175.92 | 20 | 3,518.43 | Jan. 29, 2026: 1 @ 175.92 |
| Jan. 29, 2026 | receipt | PO-001184 | MAIN | 21 | 175.92 | 3,694.35 | 21 | 3,694.35 | |
| Jan. 25, 2026 | issue | SO-260125-229 | MAIN | 4 | 174.10 | -696.39 | 0 | 0.00 | Oct. 12, 2025: 3 @ 174.10; Jan. 24, 2026: 1 @ 174.10 |
| Jan. 24, 2026 | return | RMA | MAIN | 1 | 174.10 | 174.10 | 4 | 696.39 | |
| Jan. 24, 2026 | issue | SO-260124-731 | MAIN | 2 | 174.10 | -348.20 | 3 | 522.29 | Oct. 12, 2025: 2 @ 174.10 |
| Jan. 20, 2026 | issue | SO-260120-330 | MAIN | 1 | 174.10 | -174.10 | 5 | 870.49 | Oct. 12, 2025: 1 @ 174.10 |
| Jan. 2, 2026 | issue | SO-260102-812 | MAIN | 7 | 174.10 | -1,218.69 | 6 | 1,044.59 | Oct. 12, 2025: 7 @ 174.10 |
| Dec. 31, 2025 | issue | SO-251231-650 | MAIN | 3 | 174.10 | -522.29 | 13 | 2,263.28 | Oct. 12, 2025: 3 @ 174.10 |
| Dec. 30, 2025 | issue | SO-251230-716 | MAIN | 1 | 174.10 | -174.10 | 16 | 2,785.57 | Oct. 12, 2025: 1 @ 174.10 |
| Dec. 15, 2025 | issue | SO-251215-149 | MAIN | 1 | 174.10 | -174.10 | 17 | 2,959.67 | Oct. 12, 2025: 1 @ 174.10 |
| Nov. 16, 2025 | issue | SO-251116-473 | MAIN | 1 | 174.10 | -174.10 | 18 | 3,133.77 | Oct. 12, 2025: 1 @ 174.10 |
| Nov. 8, 2025 | issue | SO-251108-519 | MAIN | 2 | 174.10 | -348.20 | 19 | 3,307.86 | Oct. 12, 2025: 2 @ 174.10 |
| Nov. 7, 2025 | issue | SO-251107-110 | MAIN | 1 | 174.10 | -174.10 | 21 | 3,656.06 | Oct. 12, 2025: 1 @ 174.10 |
| Nov. 6, 2025 | issue | SO-251106-180 | MAIN | 1 | 174.10 | -174.10 | 22 | 3,830.16 | Oct. 12, 2025: 1 @ 174.10 |
| Nov. 5, 2025 | issue | SO-251105-590 | MAIN | 1 | 174.10 | -174.10 | 23 | 4,004.26 | Oct. 12, 2025: 1 @ 174.10 |
| Oct. 25, 2025 | issue | SO-251025-457 | MAIN | 8 | 174.46 | -1,395.72 | 24 | 4,178.35 | May 31, 2025: 4 @ 174.83; Oct. 12, 2025: 4 @ 174.10 |
| Oct. 23, 2025 | issue | SO-251023-276 | MAIN | 2 | 174.83 | -349.66 | 32 | 5,574.07 | May 31, 2025: 2 @ 174.83 |
| Oct. 12, 2025 | receipt | PO-000913 | MAIN | 28 | 174.10 | 4,874.75 | 34 | 5,923.73 | |
| Oct. 3, 2025 | issue | SO-251003-422 | MAIN | 1 | 174.83 | -174.83 | 6 | 1,048.99 | May 31, 2025: 1 @ 174.83 |
| Sept. 20, 2025 | issue | SO-250920-516 | MAIN | 2 | 174.83 | -349.66 | 7 | 1,223.82 | May 31, 2025: 2 @ 174.83 |
| Sept. 9, 2025 | issue | SO-250909-954 | MAIN | 16 | 174.83 | -2,797.30 | 9 | 1,573.48 | May 31, 2025: 16 @ 174.83 |
| Aug. 30, 2025 | issue | SO-250830-608 | MAIN | 3 | 174.83 | -524.49 | 25 | 4,370.78 | May 31, 2025: 3 @ 174.83 |
| Aug. 30, 2025 | issue | SO-250830-608 | EAST | 3 | 174.83 | -524.49 | 28 | 4,895.27 | May 31, 2025: 3 @ 174.83 |
| Aug. 29, 2025 | issue | SO-250829-149 | EAST | 4 | 174.83 | -699.32 | 31 | 5,419.76 | May 31, 2025: 4 @ 174.83 |
| Aug. 27, 2025 | issue | SO-250827-598 | MAIN | 1 | 174.83 | -174.83 | 35 | 6,119.08 | May 31, 2025: 1 @ 174.83 |
| Aug. 24, 2025 | issue | SO-250824-320 | MAIN | 3 | 174.83 | -524.49 | 36 | 6,293.92 | May 31, 2025: 3 @ 174.83 |
| Aug. 21, 2025 | issue | SO-250821-271 | EAST | 1 | 174.83 | -174.83 | 39 | 6,818.41 | May 31, 2025: 1 @ 174.83 |
| Aug. 9, 2025 | issue | SO-250809-855 | EAST | 1 | 174.83 | -174.83 | 40 | 6,993.24 | May 31, 2025: 1 @ 174.83 |
| Aug. 5, 2025 | issue | SO-250805-668 | MAIN | 1 | 174.83 | -174.83 | 41 | 7,168.07 | May 31, 2025: 1 @ 174.83 |
| July 30, 2025 | issue | SO-250730-642 | MAIN | 12 | 174.83 | -2,097.97 | 42 | 7,342.90 | May 31, 2025: 12 @ 174.83 |
| July 19, 2025 | issue | SO-250719-136 | MAIN | 22 | 174.83 | -3,846.28 | 54 | 9,440.87 | May 31, 2025: 22 @ 174.83 |
| July 18, 2025 | issue | SO-250718-918 | MAIN | 6 | 174.83 | -1,048.99 | 76 | 13,287.16 | May 31, 2025: 6 @ 174.83 |
| July 11, 2025 | issue | SO-250711-214 | MAIN | 7 | 174.83 | -1,223.82 | 82 | 14,336.14 | May 31, 2025: 7 @ 174.83 |
| July 6, 2025 | issue | SO-250706-616 | MAIN | 6 | 174.83 | -1,048.99 | 89 | 15,559.96 | May 31, 2025: 6 @ 174.83 |
| July 3, 2025 | issue | SO-250703-135 | EAST | 1 | 174.83 | -174.83 | 95 | 16,608.94 | May 31, 2025: 1 @ 174.83 |
| June 26, 2025 | issue | SO-250626-135 | MAIN | 4 | 174.83 | -699.32 | 96 | 16,783.78 | May 31, 2025: 4 @ 174.83 |
| June 22, 2025 | issue | SO-250622-458 | MAIN | 30 | 175.21 | -5,256.32 | 100 | 17,483.10 | May 6, 2025: 25 @ 175.29; May 31, 2025: 5 @ 174.83 |
| June 7, 2025 | issue | SO-250607-779 | EAST | 18 | 175.29 | -3,155.16 | 130 | 22,739.42 | May 6, 2025: 18 @ 175.29 |
| May 31, 2025 | transfer | TRF | MAIN → EAST | 28 | warehouse transfer, no cost effect | ||||
| May 31, 2025 | receipt | PO-000592 | MAIN | 105 | 174.83 | 18,357.26 | 148 | 25,894.58 | |
| May 19, 2025 | issue | SO-250519-507 | MAIN | 1 | 175.29 | -175.29 | 43 | 7,537.32 | May 6, 2025: 1 @ 175.29 |
| May 14, 2025 | issue | SO-250514-810 | MAIN | 39 | 174.62 | -6,810.16 | 44 | 7,712.61 | April 3, 2025: 14 @ 173.43; May 6, 2025: 25 @ 175.29 |
| May 9, 2025 | adjustment | Cycle count | MAIN | -1 | 173.43 | -173.43 | 83 | 14,522.77 | April 3, 2025: 1 @ 173.43 |
| May 8, 2025 | issue | SO-250508-448 | MAIN | 9 | 173.43 | -1,560.85 | 84 | 14,696.19 | April 3, 2025: 9 @ 173.43 |
| May 6, 2025 | receipt | PO-000516 | MAIN | 69 | 175.29 | 12,094.78 | 93 | 16,257.04 | |
| May 5, 2025 | issue | SO-250505-193 | MAIN | 4 | 173.43 | -693.71 | 24 | 4,162.27 | April 3, 2025: 4 @ 173.43 |
| May 5, 2025 | issue | SO-250505-193 | EAST | 7 | 173.43 | -1,214.00 | 28 | 4,855.98 | April 3, 2025: 7 @ 173.43 |
| April 18, 2025 | issue | SO-250418-988 | MAIN | 2 | 173.43 | -346.86 | 35 | 6,069.98 | April 3, 2025: 2 @ 173.43 |
| April 9, 2025 | issue | SO-250409-991 | MAIN | 1 | 173.43 | -173.43 | 37 | 6,416.83 | April 3, 2025: 1 @ 173.43 |
| April 8, 2025 | issue | SO-250408-773 | EAST | 4 | 173.43 | -693.71 | 38 | 6,590.26 | April 3, 2025: 4 @ 173.43 |
| April 3, 2025 | transfer | TRF | MAIN → EAST | 11 | warehouse transfer, no cost effect | ||||
| April 3, 2025 | receipt | PO-000407 | MAIN | 42 | 173.43 | 7,283.97 | 42 | 7,283.97 | |
| April 1, 2025 | issue | SO-250401-305 | MAIN | 4 | 174.32 | -697.29 | 0 | 0.00 | March 5, 2025: 4 @ 174.32 |
| March 22, 2025 | issue | SO-250322-640 | MAIN | 3 | 174.32 | -522.97 | 4 | 697.29 | March 5, 2025: 3 @ 174.32 |
| March 21, 2025 | issue | SO-250321-818 | MAIN | 1 | 174.32 | -174.32 | 7 | 1,220.26 | March 5, 2025: 1 @ 174.32 |
| March 12, 2025 | issue | SO-250312-691 | MAIN | 5 | 174.32 | -871.62 | 8 | 1,394.59 | March 5, 2025: 5 @ 174.32 |
| March 10, 2025 | issue | SO-250310-507 | MAIN | 3 | 174.32 | -522.97 | 13 | 2,266.20 | March 5, 2025: 3 @ 174.32 |
| March 8, 2025 | issue | SO-250308-600 | MAIN | 5 | 174.32 | -871.62 | 16 | 2,789.17 | March 5, 2025: 5 @ 174.32 |
| March 8, 2025 | issue | SO-250308-600 | EAST | 6 | 174.31 | -1,045.87 | 21 | 3,660.79 | Oct. 1, 2024: 1 @ 174.25; March 5, 2025: 5 @ 174.32 |
| March 5, 2025 | transfer | TRF | MAIN → EAST | 6 | warehouse transfer, no cost effect | ||||
| March 5, 2025 | receipt | PO-000314 | MAIN | 26 | 174.32 | 4,532.41 | 27 | 4,706.65 | |
| Feb. 20, 2025 | issue | SO-250220-345 | MAIN | 9 | 174.25 | -1,568.24 | 1 | 174.25 | Oct. 1, 2024: 9 @ 174.25 |
| Feb. 18, 2025 | issue | SO-250218-192 | MAIN | 1 | 174.25 | -174.25 | 10 | 1,742.49 | Oct. 1, 2024: 1 @ 174.25 |
| Feb. 7, 2025 | issue | SO-250207-344 | MAIN | 2 | 174.25 | -348.50 | 11 | 1,916.74 | Oct. 1, 2024: 2 @ 174.25 |
| Feb. 6, 2025 | issue | SO-250206-502 | MAIN | 3 | 174.25 | -522.75 | 13 | 2,265.24 | Oct. 1, 2024: 3 @ 174.25 |
| Feb. 3, 2025 | issue | SO-250203-969 | MAIN | 4 | 174.25 | -697.00 | 16 | 2,787.98 | Oct. 1, 2024: 4 @ 174.25 |
| Jan. 28, 2025 | issue | SO-250128-849 | MAIN | 1 | 174.25 | -174.25 | 20 | 3,484.98 | Oct. 1, 2024: 1 @ 174.25 |
| Jan. 10, 2025 | issue | SO-250110-584 | MAIN | 2 | 174.25 | -348.50 | 21 | 3,659.23 | Oct. 1, 2024: 2 @ 174.25 |
| Jan. 4, 2025 | issue | SO-250104-336 | MAIN | 3 | 174.25 | -522.75 | 23 | 4,007.73 | Oct. 1, 2024: 3 @ 174.25 |
| Jan. 1, 2025 | issue | SO-250101-995 | MAIN | 2 | 174.25 | -348.50 | 26 | 4,530.47 | Oct. 1, 2024: 2 @ 174.25 |
| Dec. 23, 2024 | issue | SO-241223-931 | MAIN | 1 | 174.25 | -174.25 | 28 | 4,878.97 | Oct. 1, 2024: 1 @ 174.25 |
| Dec. 20, 2024 | issue | SO-241220-193 | MAIN | 1 | 174.25 | -174.25 | 29 | 5,053.22 | Oct. 1, 2024: 1 @ 174.25 |
| Dec. 9, 2024 | issue | SO-241209-523 | MAIN | 4 | 174.25 | -697.00 | 30 | 5,227.47 | Oct. 1, 2024: 4 @ 174.25 |
| Nov. 29, 2024 | issue | SO-241129-479 | MAIN | 2 | 174.25 | -348.50 | 34 | 5,924.47 | Oct. 1, 2024: 2 @ 174.25 |
| Nov. 19, 2024 | issue | SO-241119-616 | MAIN | 1 | 174.25 | -174.25 | 36 | 6,272.96 | Oct. 1, 2024: 1 @ 174.25 |
| Nov. 13, 2024 | issue | SO-241113-594 | MAIN | 3 | 174.25 | -522.75 | 37 | 6,447.21 | Oct. 1, 2024: 3 @ 174.25 |
| Oct. 25, 2024 | issue | SO-241025-561 | MAIN | 2 | 174.25 | -348.50 | 40 | 6,969.96 | Oct. 1, 2024: 2 @ 174.25 |
| Oct. 18, 2024 | issue | SO-241018-767 | MAIN | 5 | 174.25 | -871.24 | 42 | 7,318.46 | Oct. 1, 2024: 5 @ 174.25 |
| Oct. 17, 2024 | issue | SO-241017-370 | MAIN | 1 | 174.25 | -174.25 | 47 | 8,189.70 | Oct. 1, 2024: 1 @ 174.25 |
| Oct. 9, 2024 | issue | SO-241009-104 | MAIN | 3 | 174.25 | -522.75 | 48 | 8,363.95 | Oct. 1, 2024: 3 @ 174.25 |
| Oct. 1, 2024 | receipt | PO-000003 | MAIN | 51 | 174.25 | 8,886.70 | 51 | 8,886.70 | |