Items / FAN-0006
Decorative Ceiling Fan Pro FAN-0006 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)4MAIN 4
Value (FIFO)555.84avg 138.96
ClassBY / FCV 0.77
Turnover37.8xlast issue 0 days ago
Days of cover11lead time 22d
Reorder suggested: 24 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 | 11.00 / 30.4375 | 0.361 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 8.46 / 5.517 | 1.533 |
| 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.533^2 + 0.361^2 * 7.4^2) | 12.5 |
| Reorder point | d * LT + safety stock | 0.361 * 21.5 + 12.5 | 20.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 20.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 132/yr, S = 45.00, h = 20%, price = 127.49 | 24.0 |
| Inventory position | on hand + on order | 4 + 0 | 4 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 138.58 | 21 | 18,854 | no |
| 12 | 133.04 | 21 | 18,111 | yes |
| 24 | 127.49 | 24 | 17,371 | yes (chosen if cheapest) |
MOQ 6, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 28, 2026 | 4 / 19 | 138.96 | 555.84 |
Movement ledger 105 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 16, 2026 | issue | SO-261016-248 | MAIN | 1 | 138.96 | -138.96 | 4 | 555.84 | Aug. 28, 2026: 1 @ 138.96 |
| Oct. 14, 2026 | issue | SO-261014-632 | MAIN | 1 | 138.96 | -138.96 | 5 | 694.80 | Aug. 28, 2026: 1 @ 138.96 |
| Oct. 11, 2026 | issue | SO-261011-323 | MAIN | 2 | 138.96 | -277.92 | 6 | 833.76 | Aug. 28, 2026: 2 @ 138.96 |
| Oct. 1, 2026 | issue | SO-261001-786 | MAIN | 2 | 138.96 | -277.92 | 8 | 1,111.68 | Aug. 28, 2026: 2 @ 138.96 |
| Sept. 24, 2026 | issue | SO-260924-293 | MAIN | 1 | 138.96 | -138.96 | 10 | 1,389.60 | Aug. 28, 2026: 1 @ 138.96 |
| Sept. 23, 2026 | issue | SO-260923-314 | MAIN | 1 | 138.96 | -138.96 | 11 | 1,528.56 | Aug. 28, 2026: 1 @ 138.96 |
| Sept. 14, 2026 | issue | SO-260914-210 | MAIN | 2 | 138.96 | -277.92 | 12 | 1,667.52 | Aug. 28, 2026: 2 @ 138.96 |
| Sept. 8, 2026 | issue | SO-260908-840 | MAIN | 1 | 138.96 | -138.96 | 14 | 1,945.43 | Aug. 28, 2026: 1 @ 138.96 |
| Sept. 3, 2026 | issue | SO-260903-380 | MAIN | 3 | 138.96 | -416.88 | 15 | 2,084.39 | Aug. 28, 2026: 3 @ 138.96 |
| Aug. 29, 2026 | issue | SO-260829-517 | MAIN | 1 | 138.96 | -138.96 | 18 | 2,501.27 | Aug. 28, 2026: 1 @ 138.96 |
| Aug. 28, 2026 | receipt | PO-001754 | MAIN | 19 | 138.96 | 2,640.23 | 19 | 2,640.23 | |
| Aug. 8, 2026 | issue | SO-260808-261 | MAIN | 1 | 138.73 | -138.73 | 0 | 0.00 | June 13, 2026: 1 @ 138.73 |
| Aug. 2, 2026 | issue | SO-260802-563 | MAIN | 1 | 138.73 | -138.73 | 1 | 138.73 | June 13, 2026: 1 @ 138.73 |
| July 22, 2026 | issue | SO-260722-631 | MAIN | 2 | 138.73 | -277.46 | 2 | 277.46 | June 13, 2026: 2 @ 138.73 |
| July 21, 2026 | issue | SO-260721-625 | MAIN | 29 | 138.73 | -4,023.15 | 4 | 554.92 | June 13, 2026: 29 @ 138.73 |
| June 23, 2026 | issue | SO-260623-756 | MAIN | 9 | 138.73 | -1,248.56 | 33 | 4,578.07 | June 13, 2026: 9 @ 138.73 |
| June 22, 2026 | issue | SO-260622-838 | MAIN | 2 | 135.15 | -270.31 | 42 | 5,826.63 | May 4, 2026: 1 @ 131.58; June 13, 2026: 1 @ 138.73 |
| June 20, 2026 | issue | SO-260620-990 | MAIN | 1 | 131.58 | -131.58 | 44 | 6,096.94 | May 4, 2026: 1 @ 131.58 |
| June 18, 2026 | issue | SO-260618-623 | MAIN | 1 | 131.58 | -131.58 | 45 | 6,228.52 | May 4, 2026: 1 @ 131.58 |
| June 13, 2026 | receipt | PO-001570 | MAIN | 43 | 138.73 | 5,965.36 | 46 | 6,360.10 | |
| June 9, 2026 | issue | SO-260609-720 | MAIN | 1 | 131.58 | -131.58 | 3 | 394.74 | May 4, 2026: 1 @ 131.58 |
| June 9, 2026 | issue | SO-260609-720 | EAST | 1 | 131.58 | -131.58 | 4 | 526.32 | May 4, 2026: 1 @ 131.58 |
| June 1, 2026 | issue | SO-260601-882 | MAIN | 5 | 131.58 | -657.90 | 5 | 657.90 | May 4, 2026: 5 @ 131.58 |
| May 24, 2026 | issue | SO-260524-149 | EAST | 6 | 131.58 | -789.48 | 10 | 1,315.79 | May 4, 2026: 6 @ 131.58 |
| May 19, 2026 | issue | SO-260519-191 | MAIN | 11 | 131.58 | -1,447.37 | 16 | 2,105.27 | May 4, 2026: 11 @ 131.58 |
| May 6, 2026 | issue | SO-260506-615 | MAIN | 1 | 131.58 | -131.58 | 27 | 3,552.64 | May 4, 2026: 1 @ 131.58 |
| May 5, 2026 | issue | SO-260505-241 | MAIN | 1 | 138.59 | -138.59 | 28 | 3,684.22 | March 23, 2026: 1 @ 138.59 |
| May 4, 2026 | transfer | TRF | MAIN → EAST | 6 | warehouse transfer, no cost effect | ||||
| May 4, 2026 | receipt | PO-001463 | MAIN | 28 | 131.58 | 3,684.22 | 29 | 3,822.81 | |
| May 3, 2026 | issue | SO-260503-236 | EAST | 1 | 138.59 | -138.59 | 1 | 138.59 | March 23, 2026: 1 @ 138.59 |
| April 29, 2026 | issue | SO-260429-373 | EAST | 1 | 138.59 | -138.59 | 2 | 277.18 | March 23, 2026: 1 @ 138.59 |
| April 29, 2026 | issue | SO-260429-373 | MAIN | 1 | 138.59 | -138.59 | 3 | 415.76 | March 23, 2026: 1 @ 138.59 |
| April 23, 2026 | issue | SO-260423-419 | MAIN | 2 | 138.59 | -277.18 | 4 | 554.35 | March 23, 2026: 2 @ 138.59 |
| April 16, 2026 | issue | SO-260416-547 | MAIN | 3 | 138.59 | -415.76 | 6 | 831.53 | March 23, 2026: 3 @ 138.59 |
| April 9, 2026 | issue | SO-260409-539 | MAIN | 6 | 138.59 | -831.53 | 9 | 1,247.29 | March 23, 2026: 6 @ 138.59 |
| April 2, 2026 | issue | SO-260402-167 | MAIN | 3 | 137.79 | -413.36 | 15 | 2,078.82 | Feb. 6, 2026: 1 @ 136.19; March 23, 2026: 2 @ 138.59 |
| March 25, 2026 | issue | SO-260325-635 | MAIN | 7 | 136.19 | -953.31 | 18 | 2,492.18 | Feb. 6, 2026: 7 @ 136.19 |
| March 23, 2026 | receipt | PO-001344 | MAIN | 17 | 138.59 | 2,356.00 | 25 | 3,445.50 | |
| March 1, 2026 | issue | SO-260301-516 | MAIN | 2 | 136.19 | -272.38 | 8 | 1,089.50 | Feb. 6, 2026: 2 @ 136.19 |
| Feb. 15, 2026 | issue | SO-260215-561 | MAIN | 1 | 136.19 | -136.19 | 10 | 1,361.88 | Feb. 6, 2026: 1 @ 136.19 |
| Feb. 6, 2026 | transfer | TRF | MAIN → EAST | 3 | warehouse transfer, no cost effect | ||||
| Feb. 6, 2026 | receipt | PO-001201 | MAIN | 11 | 136.19 | 1,498.06 | 11 | 1,498.06 | |
| Feb. 1, 2026 | issue | SO-260201-693 | MAIN | 5 | 133.18 | -665.88 | 0 | 0.00 | Jan. 13, 2026: 5 @ 133.18 |
| Jan. 27, 2026 | issue | SO-260127-180 | MAIN | 2 | 133.18 | -266.35 | 5 | 665.88 | Jan. 13, 2026: 2 @ 133.18 |
| Jan. 13, 2026 | issue | SO-260113-370 | MAIN | 4 | 133.50 | -534.00 | 7 | 932.23 | Nov. 9, 2025: 2 @ 133.83; Jan. 13, 2026: 2 @ 133.18 |
| Jan. 13, 2026 | receipt | PO-001142 | MAIN | 9 | 133.18 | 1,198.58 | 11 | 1,466.24 | |
| Dec. 29, 2025 | issue | SO-251229-768 | MAIN | 2 | 133.83 | -267.65 | 2 | 267.65 | Nov. 9, 2025: 2 @ 133.83 |
| Dec. 27, 2025 | issue | SO-251227-615 | MAIN | 1 | 133.83 | -133.83 | 4 | 535.31 | Nov. 9, 2025: 1 @ 133.83 |
| Nov. 18, 2025 | issue | SO-251118-763 | MAIN | 1 | 133.83 | -133.83 | 5 | 669.13 | Nov. 9, 2025: 1 @ 133.83 |
| Nov. 18, 2025 | issue | SO-251118-763 | EAST | 1 | 132.00 | -132.00 | 6 | 802.96 | Aug. 2, 2025: 1 @ 132.00 |
| Nov. 9, 2025 | receipt | PO-000986 | MAIN | 6 | 133.83 | 802.96 | 7 | 934.96 | |
| Nov. 3, 2025 | issue | SO-251103-862 | EAST | 1 | 132.00 | -132.00 | 1 | 132.00 | Aug. 2, 2025: 1 @ 132.00 |
| Oct. 22, 2025 | issue | SO-251022-751 | EAST | 1 | 132.00 | -132.00 | 2 | 263.99 | Aug. 2, 2025: 1 @ 132.00 |
| Oct. 11, 2025 | issue | SO-251011-430 | EAST | 2 | 132.00 | -263.99 | 3 | 395.99 | Aug. 2, 2025: 2 @ 132.00 |
| Oct. 9, 2025 | issue | SO-251009-225 | MAIN | 3 | 132.00 | -395.99 | 5 | 659.98 | Aug. 2, 2025: 3 @ 132.00 |
| Oct. 8, 2025 | issue | SO-251008-195 | MAIN | 1 | 132.00 | -132.00 | 8 | 1,055.97 | Aug. 2, 2025: 1 @ 132.00 |
| Sept. 29, 2025 | issue | SO-250929-885 | MAIN | 4 | 132.00 | -527.99 | 9 | 1,187.97 | Aug. 2, 2025: 4 @ 132.00 |
| Sept. 20, 2025 | issue | SO-250920-213 | MAIN | 1 | 132.00 | -132.00 | 13 | 1,715.96 | Aug. 2, 2025: 1 @ 132.00 |
| Sept. 17, 2025 | issue | SO-250917-701 | MAIN | 1 | 132.00 | -132.00 | 14 | 1,847.96 | Aug. 2, 2025: 1 @ 132.00 |
| Sept. 14, 2025 | issue | SO-250914-971 | EAST | 1 | 132.00 | -132.00 | 15 | 1,979.95 | Aug. 2, 2025: 1 @ 132.00 |
| Sept. 7, 2025 | issue | SO-250907-788 | MAIN | 1 | 132.00 | -132.00 | 16 | 2,111.95 | Aug. 2, 2025: 1 @ 132.00 |
| Aug. 24, 2025 | issue | SO-250824-977 | EAST | 2 | 132.00 | -263.99 | 17 | 2,243.95 | Aug. 2, 2025: 2 @ 132.00 |
| Aug. 18, 2025 | issue | SO-250818-185 | EAST | 1 | 132.00 | -132.00 | 19 | 2,507.94 | Aug. 2, 2025: 1 @ 132.00 |
| Aug. 10, 2025 | issue | SO-250810-635 | MAIN | 3 | 132.00 | -395.99 | 20 | 2,639.94 | Aug. 2, 2025: 3 @ 132.00 |
| Aug. 6, 2025 | issue | SO-250806-719 | MAIN | 1 | 132.00 | -132.00 | 23 | 3,035.93 | Aug. 2, 2025: 1 @ 132.00 |
| Aug. 2, 2025 | issue | SO-250802-962 | MAIN | 8 | 132.00 | -1,055.97 | 24 | 3,167.92 | Aug. 2, 2025: 8 @ 132.00 |
| Aug. 2, 2025 | transfer | TRF | MAIN → EAST | 9 | warehouse transfer, no cost effect | ||||
| Aug. 2, 2025 | receipt | PO-000750 | MAIN | 32 | 132.00 | 4,223.90 | 32 | 4,223.90 | |
| July 16, 2025 | issue | SO-250716-660 | MAIN | 7 | 132.28 | -925.99 | 0 | 0.00 | May 1, 2025: 5 @ 132.44; May 16, 2025: 2 @ 131.90 |
| July 9, 2025 | issue | SO-250709-168 | MAIN | 1 | 132.44 | -132.44 | 7 | 925.99 | May 1, 2025: 1 @ 132.44 |
| June 30, 2025 | issue | SO-250630-802 | MAIN | 10 | 132.44 | -1,324.40 | 8 | 1,058.43 | May 1, 2025: 10 @ 132.44 |
| June 18, 2025 | issue | SO-250618-798 | MAIN | 3 | 132.44 | -397.32 | 18 | 2,382.82 | May 1, 2025: 3 @ 132.44 |
| June 15, 2025 | issue | SO-250615-979 | MAIN | 11 | 132.44 | -1,456.83 | 21 | 2,780.14 | May 1, 2025: 11 @ 132.44 |
| May 31, 2025 | issue | SO-250531-290 | MAIN | 2 | 132.44 | -264.88 | 32 | 4,236.98 | May 1, 2025: 2 @ 132.44 |
| May 26, 2025 | issue | SO-250526-904 | MAIN | 3 | 132.44 | -397.32 | 34 | 4,501.86 | May 1, 2025: 3 @ 132.44 |
| May 17, 2025 | issue | SO-250517-329 | MAIN | 3 | 132.44 | -397.32 | 37 | 4,899.17 | May 1, 2025: 3 @ 132.44 |
| May 16, 2025 | return | RMA | MAIN | 2 | 131.90 | 263.79 | 40 | 5,296.49 | |
| May 12, 2025 | issue | SO-250512-282 | MAIN | 4 | 131.90 | -527.58 | 38 | 5,032.70 | April 6, 2025: 1 @ 130.27; May 1, 2025: 3 @ 132.44 |
| May 7, 2025 | issue | SO-250507-996 | MAIN | 1 | 130.27 | -130.27 | 42 | 5,560.29 | April 6, 2025: 1 @ 130.27 |
| May 7, 2025 | issue | SO-250507-996 | EAST | 7 | 130.27 | -911.86 | 43 | 5,690.55 | April 6, 2025: 7 @ 130.27 |
| May 5, 2025 | issue | SO-250505-488 | MAIN | 5 | 130.27 | -651.33 | 50 | 6,602.42 | April 6, 2025: 5 @ 130.27 |
| May 1, 2025 | receipt | PO-000497 | MAIN | 41 | 132.44 | 5,430.02 | 55 | 7,253.75 | |
| April 21, 2025 | issue | SO-250421-858 | MAIN | 4 | 130.27 | -521.07 | 14 | 1,823.73 | April 6, 2025: 4 @ 130.27 |
| April 16, 2025 | issue | SO-250416-770 | MAIN | 4 | 130.27 | -521.07 | 18 | 2,344.79 | April 6, 2025: 4 @ 130.27 |
| April 14, 2025 | issue | SO-250414-418 | MAIN | 6 | 130.27 | -781.60 | 22 | 2,865.86 | April 6, 2025: 6 @ 130.27 |
| April 6, 2025 | transfer | TRF | MAIN → EAST | 7 | warehouse transfer, no cost effect | ||||
| April 6, 2025 | receipt | PO-000419 | MAIN | 28 | 130.27 | 3,647.46 | 28 | 3,647.46 | |
| April 1, 2025 | issue | SO-250401-628 | MAIN | 1 | 129.97 | -129.97 | 0 | 0.00 | Feb. 21, 2025: 1 @ 129.97 |
| March 25, 2025 | issue | SO-250325-330 | MAIN | 10 | 129.97 | -1,299.66 | 1 | 129.97 | Feb. 21, 2025: 10 @ 129.97 |
| March 8, 2025 | issue | SO-250308-213 | MAIN | 1 | 131.65 | -131.65 | 11 | 1,429.63 | Nov. 25, 2024: 1 @ 131.65 |
| Feb. 21, 2025 | receipt | PO-000287 | MAIN | 11 | 129.97 | 1,429.63 | 12 | 1,561.28 | |
| Feb. 14, 2025 | issue | SO-250214-582 | MAIN | 2 | 131.65 | -263.30 | 1 | 131.65 | Oct. 1, 2024: 2 @ 131.65 |
| Feb. 11, 2025 | issue | SO-250211-961 | MAIN | 1 | 131.65 | -131.65 | 3 | 394.95 | Oct. 1, 2024: 1 @ 131.65 |
| Feb. 5, 2025 | issue | SO-250205-213 | MAIN | 2 | 131.65 | -263.30 | 4 | 526.60 | Oct. 1, 2024: 2 @ 131.65 |
| Feb. 4, 2025 | issue | SO-250204-343 | MAIN | 1 | 131.65 | -131.65 | 6 | 789.91 | Oct. 1, 2024: 1 @ 131.65 |
| Jan. 31, 2025 | issue | SO-250131-757 | MAIN | 1 | 131.65 | -131.65 | 7 | 921.56 | Oct. 1, 2024: 1 @ 131.65 |
| Jan. 14, 2025 | issue | SO-250114-936 | MAIN | 4 | 131.65 | -526.60 | 8 | 1,053.21 | Oct. 1, 2024: 4 @ 131.65 |
| Jan. 10, 2025 | issue | SO-250110-481 | MAIN | 1 | 131.65 | -131.65 | 12 | 1,579.81 | Oct. 1, 2024: 1 @ 131.65 |
| Dec. 9, 2024 | issue | SO-241209-526 | MAIN | 1 | 131.65 | -131.65 | 13 | 1,711.46 | Oct. 1, 2024: 1 @ 131.65 |
| Nov. 25, 2024 | return | RMA | MAIN | 1 | 131.65 | 131.65 | 14 | 1,843.11 | |
| Nov. 14, 2024 | issue | SO-241114-676 | MAIN | 1 | 131.65 | -131.65 | 13 | 1,711.46 | Oct. 1, 2024: 1 @ 131.65 |
| Nov. 6, 2024 | issue | SO-241106-405 | MAIN | 1 | 131.65 | -131.65 | 14 | 1,843.11 | Oct. 1, 2024: 1 @ 131.65 |
| Oct. 20, 2024 | issue | SO-241020-675 | MAIN | 5 | 131.65 | -658.26 | 15 | 1,974.76 | Oct. 1, 2024: 5 @ 131.65 |
| Oct. 11, 2024 | issue | SO-241011-586 | MAIN | 1 | 131.65 | -131.65 | 20 | 2,633.02 | Oct. 1, 2024: 1 @ 131.65 |
| Oct. 1, 2024 | receipt | PO-000003 | MAIN | 21 | 131.65 | 2,764.67 | 21 | 2,764.67 | |