Items / FAN-0026
Ceiling Fan 1200mm Elite FAN-0026 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)10MAIN 10
Value (FIFO)2,295.62avg 229.56
ClassAY / FCV 0.68
Turnover11.9xlast issue 12 days ago
Days of cover17lead time 22d
Reorder suggested: 41 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 | 18.08 / 30.4375 | 0.594 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 12.37 / 5.517 | 2.243 |
| 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 * 2.243^2 + 0.594^2 * 7.4^2) | 23.2 |
| Reorder point | d * LT + safety stock | 0.594 * 21.5 + 23.2 | 36.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 36.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 217/yr, S = 45.00, h = 20%, price = 236.60 | 20.3 |
| Inventory position | on hand + on order | 10 + 0 | 10 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 236.60 | 20 | 52,268 | yes (chosen if cheapest) |
MOQ 10, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 29, 2026 | 10 / 33 | 229.56 | 2,295.62 |
Movement ledger 111 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 4, 2026 | issue | SO-261004-850 | MAIN | 3 | 229.56 | -688.69 | 10 | 2,295.62 | Aug. 29, 2026: 3 @ 229.56 |
| Oct. 1, 2026 | issue | SO-261001-577 | MAIN | 3 | 229.56 | -688.69 | 13 | 2,984.31 | Aug. 29, 2026: 3 @ 229.56 |
| Sept. 30, 2026 | issue | SO-260930-346 | MAIN | 3 | 229.56 | -688.69 | 16 | 3,673.00 | Aug. 29, 2026: 3 @ 229.56 |
| Sept. 23, 2026 | issue | SO-260923-325 | MAIN | 3 | 229.56 | -688.69 | 19 | 4,361.68 | Aug. 29, 2026: 3 @ 229.56 |
| Sept. 21, 2026 | issue | SO-260921-293 | MAIN | 1 | 229.56 | -229.56 | 22 | 5,050.37 | Aug. 29, 2026: 1 @ 229.56 |
| Sept. 19, 2026 | issue | SO-260919-640 | MAIN | 1 | 229.56 | -229.56 | 23 | 5,279.93 | Aug. 29, 2026: 1 @ 229.56 |
| Sept. 11, 2026 | issue | SO-260911-682 | MAIN | 1 | 229.56 | -229.56 | 24 | 5,509.50 | Aug. 29, 2026: 1 @ 229.56 |
| Sept. 9, 2026 | issue | SO-260909-753 | MAIN | 1 | 229.56 | -229.56 | 25 | 5,739.06 | Aug. 29, 2026: 1 @ 229.56 |
| Sept. 4, 2026 | issue | SO-260904-472 | MAIN | 2 | 229.56 | -459.12 | 26 | 5,968.62 | Aug. 29, 2026: 2 @ 229.56 |
| Aug. 31, 2026 | issue | SO-260831-737 | MAIN | 6 | 230.20 | -1,381.20 | 28 | 6,427.74 | June 7, 2026: 1 @ 233.39; Aug. 29, 2026: 5 @ 229.56 |
| Aug. 29, 2026 | receipt | PO-001758 | MAIN | 33 | 229.56 | 7,575.56 | 34 | 7,808.95 | |
| Aug. 23, 2026 | issue | SO-260823-280 | MAIN | 6 | 233.39 | -1,400.34 | 1 | 233.39 | June 7, 2026: 6 @ 233.39 |
| Aug. 18, 2026 | issue | SO-260818-711 | MAIN | 2 | 233.39 | -466.78 | 7 | 1,633.73 | June 7, 2026: 2 @ 233.39 |
| Aug. 15, 2026 | issue | SO-260815-746 | MAIN | 1 | 233.39 | -233.39 | 9 | 2,100.52 | June 7, 2026: 1 @ 233.39 |
| Aug. 6, 2026 | issue | SO-260806-485 | MAIN | 1 | 233.39 | -233.39 | 10 | 2,333.91 | June 7, 2026: 1 @ 233.39 |
| Aug. 5, 2026 | issue | SO-260805-923 | MAIN | 1 | 233.39 | -233.39 | 11 | 2,567.30 | June 7, 2026: 1 @ 233.39 |
| July 29, 2026 | adjustment | Cycle count | MAIN | -1 | 233.39 | -233.39 | 12 | 2,800.69 | June 7, 2026: 1 @ 233.39 |
| July 23, 2026 | issue | SO-260723-414 | MAIN | 4 | 233.39 | -933.56 | 13 | 3,034.08 | June 7, 2026: 4 @ 233.39 |
| July 21, 2026 | issue | SO-260721-402 | MAIN | 16 | 233.39 | -3,734.25 | 17 | 3,967.64 | June 7, 2026: 16 @ 233.39 |
| July 17, 2026 | issue | SO-260717-932 | MAIN | 5 | 233.39 | -1,166.95 | 33 | 7,701.89 | June 7, 2026: 5 @ 233.39 |
| July 10, 2026 | issue | SO-260710-107 | MAIN | 9 | 233.39 | -2,100.52 | 38 | 8,868.85 | June 7, 2026: 9 @ 233.39 |
| June 29, 2026 | issue | SO-260629-665 | MAIN | 4 | 233.39 | -933.56 | 47 | 10,969.36 | June 7, 2026: 4 @ 233.39 |
| June 27, 2026 | issue | SO-260627-546 | MAIN | 1 | 233.39 | -233.39 | 51 | 11,902.93 | June 7, 2026: 1 @ 233.39 |
| June 27, 2026 | issue | SO-260627-546 | EAST | 23 | 233.39 | -5,367.99 | 52 | 12,136.32 | June 7, 2026: 23 @ 233.39 |
| June 7, 2026 | transfer | TRF | MAIN → EAST | 23 | warehouse transfer, no cost effect | ||||
| June 7, 2026 | receipt | PO-001554 | MAIN | 75 | 233.39 | 17,504.30 | 75 | 17,504.30 | |
| June 4, 2026 | issue | SO-260604-654 | MAIN | 1 | 237.76 | -237.76 | 0 | 0.00 | April 16, 2026: 1 @ 237.76 |
| June 1, 2026 | issue | SO-260601-941 | MAIN | 6 | 237.76 | -1,426.58 | 1 | 237.76 | April 16, 2026: 6 @ 237.76 |
| May 31, 2026 | issue | SO-260531-888 | MAIN | 28 | 237.76 | -6,657.39 | 7 | 1,664.35 | April 16, 2026: 28 @ 237.76 |
| May 17, 2026 | issue | SO-260517-875 | MAIN | 3 | 237.76 | -713.29 | 35 | 8,321.74 | April 16, 2026: 3 @ 237.76 |
| May 17, 2026 | issue | SO-260517-875 | EAST | 5 | 237.76 | -1,188.82 | 38 | 9,035.04 | April 16, 2026: 5 @ 237.76 |
| April 17, 2026 | issue | SO-260417-482 | MAIN | 11 | 236.42 | -2,600.60 | 43 | 10,223.86 | March 6, 2026: 4 @ 234.74; March 11, 2026: 1 @ 235.04; April 16, 2026: 6 @ 237.76 |
| April 16, 2026 | receipt | PO-001413 | MAIN | 49 | 237.76 | 11,650.44 | 54 | 12,824.45 | |
| April 9, 2026 | issue | SO-260409-688 | MAIN | 19 | 234.74 | -4,460.10 | 5 | 1,174.01 | March 6, 2026: 19 @ 234.74 |
| April 4, 2026 | issue | SO-260404-317 | MAIN | 3 | 234.74 | -704.23 | 24 | 5,634.11 | March 6, 2026: 3 @ 234.74 |
| March 28, 2026 | issue | SO-260328-725 | EAST | 3 | 234.74 | -704.23 | 27 | 6,338.33 | March 6, 2026: 3 @ 234.74 |
| March 21, 2026 | issue | SO-260321-177 | EAST | 4 | 234.97 | -939.87 | 30 | 7,042.56 | Feb. 18, 2026: 3 @ 235.04; March 6, 2026: 1 @ 234.74 |
| March 11, 2026 | return | RMA | MAIN | 1 | 235.04 | 235.04 | 34 | 7,982.43 | |
| March 6, 2026 | transfer | TRF | MAIN → EAST | 10 | warehouse transfer, no cost effect | ||||
| March 6, 2026 | receipt | PO-001291 | MAIN | 30 | 234.74 | 7,042.26 | 33 | 7,747.39 | |
| March 4, 2026 | issue | SO-260304-340 | MAIN | 12 | 235.04 | -2,820.51 | 3 | 705.13 | Feb. 18, 2026: 12 @ 235.04 |
| Feb. 23, 2026 | issue | SO-260223-764 | EAST | 2 | 235.04 | -470.09 | 15 | 3,525.64 | Feb. 18, 2026: 2 @ 235.04 |
| Feb. 19, 2026 | issue | SO-260219-997 | EAST | 1 | 235.04 | -235.04 | 17 | 3,995.73 | Feb. 18, 2026: 1 @ 235.04 |
| Feb. 18, 2026 | transfer | TRF | MAIN → EAST | 5 | warehouse transfer, no cost effect | ||||
| Feb. 18, 2026 | receipt | PO-001236 | MAIN | 18 | 235.04 | 4,230.77 | 18 | 4,230.77 | |
| Feb. 6, 2026 | issue | SO-260206-717 | MAIN | 2 | 221.98 | -443.96 | 0 | 0.00 | July 24, 2025: 2 @ 221.98 |
| Feb. 2, 2026 | issue | SO-260202-208 | MAIN | 5 | 221.98 | -1,109.89 | 2 | 443.96 | July 24, 2025: 5 @ 221.98 |
| Jan. 30, 2026 | issue | SO-260130-873 | MAIN | 1 | 221.98 | -221.98 | 7 | 1,553.84 | July 24, 2025: 1 @ 221.98 |
| Jan. 29, 2026 | issue | SO-260129-100 | MAIN | 2 | 221.98 | -443.96 | 8 | 1,775.82 | July 24, 2025: 2 @ 221.98 |
| Jan. 26, 2026 | issue | SO-260126-893 | MAIN | 1 | 221.98 | -221.98 | 10 | 2,219.78 | July 24, 2025: 1 @ 221.98 |
| Jan. 20, 2026 | issue | SO-260120-100 | MAIN | 1 | 221.98 | -221.98 | 11 | 2,441.75 | July 24, 2025: 1 @ 221.98 |
| Jan. 14, 2026 | issue | SO-260114-638 | MAIN | 1 | 221.98 | -221.98 | 12 | 2,663.73 | July 24, 2025: 1 @ 221.98 |
| Jan. 11, 2026 | issue | SO-260111-513 | MAIN | 1 | 221.98 | -221.98 | 13 | 2,885.71 | July 24, 2025: 1 @ 221.98 |
| Jan. 3, 2026 | issue | SO-260103-100 | MAIN | 1 | 221.98 | -221.98 | 14 | 3,107.68 | July 24, 2025: 1 @ 221.98 |
| Dec. 27, 2025 | issue | SO-251227-900 | MAIN | 1 | 221.98 | -221.98 | 15 | 3,329.66 | July 24, 2025: 1 @ 221.98 |
| Dec. 17, 2025 | issue | SO-251217-179 | MAIN | 2 | 221.98 | -443.96 | 16 | 3,551.64 | July 24, 2025: 2 @ 221.98 |
| Dec. 3, 2025 | issue | SO-251203-475 | MAIN | 1 | 221.98 | -221.98 | 18 | 3,995.60 | July 24, 2025: 1 @ 221.98 |
| Nov. 16, 2025 | issue | SO-251116-787 | MAIN | 1 | 221.98 | -221.98 | 19 | 4,217.57 | July 24, 2025: 1 @ 221.98 |
| Nov. 13, 2025 | issue | SO-251113-920 | MAIN | 1 | 221.98 | -221.98 | 20 | 4,439.55 | July 24, 2025: 1 @ 221.98 |
| Nov. 11, 2025 | issue | SO-251111-520 | MAIN | 1 | 221.98 | -221.98 | 21 | 4,661.53 | July 24, 2025: 1 @ 221.98 |
| Oct. 25, 2025 | issue | SO-251025-655 | MAIN | 2 | 221.98 | -443.96 | 22 | 4,883.50 | July 24, 2025: 2 @ 221.98 |
| Oct. 24, 2025 | issue | SO-251024-877 | MAIN | 5 | 221.98 | -1,109.89 | 24 | 5,327.46 | July 24, 2025: 5 @ 221.98 |
| Sept. 25, 2025 | issue | SO-250925-149 | MAIN | 1 | 221.98 | -221.98 | 29 | 6,437.35 | July 24, 2025: 1 @ 221.98 |
| Sept. 19, 2025 | issue | SO-250919-921 | MAIN | 1 | 221.98 | -221.98 | 30 | 6,659.32 | July 24, 2025: 1 @ 221.98 |
| Sept. 15, 2025 | issue | SO-250915-186 | MAIN | 1 | 221.98 | -221.98 | 31 | 6,881.30 | July 24, 2025: 1 @ 221.98 |
| Sept. 12, 2025 | issue | SO-250912-917 | MAIN | 1 | 221.98 | -221.98 | 32 | 7,103.28 | July 24, 2025: 1 @ 221.98 |
| Sept. 4, 2025 | issue | SO-250904-305 | MAIN | 1 | 221.98 | -221.98 | 33 | 7,325.26 | July 24, 2025: 1 @ 221.98 |
| Sept. 3, 2025 | issue | SO-250903-142 | MAIN | 2 | 221.98 | -443.96 | 34 | 7,547.24 | July 24, 2025: 2 @ 221.98 |
| Sept. 2, 2025 | issue | SO-250902-684 | MAIN | 1 | 221.98 | -221.98 | 36 | 7,991.19 | July 24, 2025: 1 @ 221.98 |
| Aug. 31, 2025 | issue | SO-250831-896 | MAIN | 3 | 221.98 | -665.93 | 37 | 8,213.17 | July 24, 2025: 3 @ 221.98 |
| Aug. 30, 2025 | issue | SO-250830-682 | MAIN | 5 | 221.98 | -1,109.89 | 40 | 8,879.10 | July 24, 2025: 5 @ 221.98 |
| Aug. 26, 2025 | issue | SO-250826-922 | MAIN | 11 | 221.98 | -2,441.75 | 45 | 9,988.99 | July 24, 2025: 11 @ 221.98 |
| Aug. 20, 2025 | issue | SO-250820-763 | MAIN | 2 | 224.58 | -449.15 | 56 | 12,430.74 | May 24, 2025: 2 @ 224.58 |
| July 28, 2025 | issue | SO-250728-583 | MAIN | 19 | 224.58 | -4,266.96 | 58 | 12,879.89 | May 24, 2025: 19 @ 224.58 |
| July 27, 2025 | issue | SO-250727-190 | MAIN | 1 | 224.58 | -224.58 | 77 | 17,146.85 | May 24, 2025: 1 @ 224.58 |
| July 24, 2025 | receipt | PO-000730 | MAIN | 56 | 221.98 | 12,430.74 | 78 | 17,371.43 | |
| July 3, 2025 | issue | SO-250703-173 | MAIN | 15 | 224.58 | -3,368.65 | 22 | 4,940.69 | May 24, 2025: 15 @ 224.58 |
| June 23, 2025 | issue | SO-250623-130 | MAIN | 24 | 224.58 | -5,389.84 | 37 | 8,309.33 | May 24, 2025: 24 @ 224.58 |
| June 20, 2025 | issue | SO-250620-296 | MAIN | 3 | 224.58 | -673.73 | 61 | 13,699.17 | May 24, 2025: 3 @ 224.58 |
| June 13, 2025 | issue | SO-250613-485 | MAIN | 9 | 224.71 | -2,022.40 | 64 | 14,372.90 | April 14, 2025: 1 @ 225.79; May 24, 2025: 8 @ 224.58 |
| May 30, 2025 | issue | SO-250530-239 | MAIN | 8 | 225.79 | -1,806.32 | 73 | 16,395.31 | April 14, 2025: 8 @ 225.79 |
| May 24, 2025 | receipt | PO-000569 | MAIN | 72 | 224.58 | 16,169.52 | 81 | 18,201.63 | |
| May 14, 2025 | issue | SO-250514-896 | MAIN | 15 | 225.79 | -3,386.85 | 9 | 2,032.11 | April 14, 2025: 15 @ 225.79 |
| May 6, 2025 | issue | SO-250506-341 | MAIN | 1 | 225.79 | -225.79 | 24 | 5,418.96 | April 14, 2025: 1 @ 225.79 |
| May 1, 2025 | issue | SO-250501-106 | MAIN | 22 | 225.79 | -4,967.38 | 25 | 5,644.75 | April 14, 2025: 22 @ 225.79 |
| April 21, 2025 | issue | SO-250421-101 | MAIN | 2 | 225.79 | -451.58 | 47 | 10,612.13 | April 14, 2025: 2 @ 225.79 |
| April 14, 2025 | receipt | PO-000446 | MAIN | 49 | 225.79 | 11,063.71 | 49 | 11,063.71 | |
| April 3, 2025 | issue | SO-250403-519 | MAIN | 7 | 221.72 | -1,552.06 | 0 | 0.00 | March 7, 2025: 7 @ 221.72 |
| April 2, 2025 | issue | SO-250402-389 | MAIN | 7 | 221.72 | -1,552.06 | 7 | 1,552.06 | March 7, 2025: 7 @ 221.72 |
| March 21, 2025 | issue | SO-250321-380 | MAIN | 4 | 221.72 | -886.89 | 14 | 3,104.12 | March 7, 2025: 4 @ 221.72 |
| March 7, 2025 | receipt | PO-000325 | MAIN | 18 | 221.72 | 3,991.01 | 18 | 3,991.01 | |
| March 3, 2025 | issue | SO-250303-158 | MAIN | 1 | 224.77 | -224.77 | 0 | 0.00 | Oct. 1, 2024: 1 @ 224.77 |
| Feb. 28, 2025 | issue | SO-250228-901 | MAIN | 3 | 224.77 | -674.31 | 1 | 224.77 | Oct. 1, 2024: 3 @ 224.77 |
| Feb. 25, 2025 | issue | SO-250225-876 | MAIN | 1 | 224.77 | -224.77 | 4 | 899.08 | Oct. 1, 2024: 1 @ 224.77 |
| Feb. 21, 2025 | issue | SO-250221-697 | MAIN | 1 | 224.77 | -224.77 | 5 | 1,123.85 | Oct. 1, 2024: 1 @ 224.77 |
| Feb. 7, 2025 | issue | SO-250207-130 | MAIN | 6 | 224.77 | -1,348.62 | 6 | 1,348.62 | Oct. 1, 2024: 6 @ 224.77 |
| Feb. 5, 2025 | issue | SO-250205-242 | MAIN | 1 | 224.77 | -224.77 | 12 | 2,697.24 | Oct. 1, 2024: 1 @ 224.77 |
| Jan. 31, 2025 | issue | SO-250131-402 | MAIN | 1 | 224.77 | -224.77 | 13 | 2,922.01 | Oct. 1, 2024: 1 @ 224.77 |
| Jan. 30, 2025 | issue | SO-250130-632 | MAIN | 1 | 224.77 | -224.77 | 14 | 3,146.78 | Oct. 1, 2024: 1 @ 224.77 |
| Jan. 28, 2025 | issue | SO-250128-291 | MAIN | 2 | 224.77 | -449.54 | 15 | 3,371.55 | Oct. 1, 2024: 2 @ 224.77 |
| Jan. 4, 2025 | issue | SO-250104-650 | MAIN | 2 | 224.77 | -449.54 | 17 | 3,821.09 | Oct. 1, 2024: 2 @ 224.77 |
| Jan. 1, 2025 | issue | SO-250101-501 | MAIN | 2 | 224.77 | -449.54 | 19 | 4,270.63 | Oct. 1, 2024: 2 @ 224.77 |
| Dec. 9, 2024 | issue | SO-241209-805 | MAIN | 2 | 224.77 | -449.54 | 21 | 4,720.17 | Oct. 1, 2024: 2 @ 224.77 |
| Nov. 18, 2024 | issue | SO-241118-616 | MAIN | 2 | 224.77 | -449.54 | 23 | 5,169.71 | Oct. 1, 2024: 2 @ 224.77 |
| Nov. 11, 2024 | issue | SO-241111-488 | MAIN | 2 | 224.77 | -449.54 | 25 | 5,619.25 | Oct. 1, 2024: 2 @ 224.77 |
| Oct. 19, 2024 | issue | SO-241019-143 | MAIN | 1 | 224.77 | -224.77 | 27 | 6,068.79 | Oct. 1, 2024: 1 @ 224.77 |
| Oct. 19, 2024 | issue | SO-241019-143 | EAST | 2 | 224.77 | -449.54 | 28 | 6,293.56 | Oct. 1, 2024: 2 @ 224.77 |
| Oct. 7, 2024 | issue | SO-241007-557 | EAST | 6 | 224.77 | -1,348.62 | 30 | 6,743.10 | Oct. 1, 2024: 6 @ 224.77 |
| Oct. 4, 2024 | issue | SO-241004-343 | MAIN | 1 | 224.77 | -224.77 | 36 | 8,091.72 | Oct. 1, 2024: 1 @ 224.77 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 8 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000003 | MAIN | 37 | 224.77 | 8,316.49 | 37 | 8,316.49 | |