Items / FAN-0001
Decorative Ceiling Fan Classic FAN-0001 · Ceiling Fans · CoolBreeze Appliances
On hand (EA)4MAIN 4
Value (FIFO)779.66avg 194.91
ClassBY / FCV 0.67
Turnover16.3xlast issue 6 days ago
Days of cover16lead 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 | 7.58 / 30.4375 | 0.249 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 5.09 / 5.517 | 0.923 |
| 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 * 0.923^2 + 0.249^2 * 7.4^2) | 7.7 |
| Reorder point | d * LT + safety stock | 0.249 * 21.5 + 7.7 | 13.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 13.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 91/yr, S = 45.00, h = 20%, price = 186.34 | 20.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 | 202.54 | 14 | 18,994 | no |
| 10 | 194.44 | 15 | 18,246 | yes |
| 20 | 186.34 | 20 | 17,522 | yes (chosen if cheapest) |
MOQ 5, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 11, 2026 | 4 / 26 | 194.91 | 779.66 |
Movement ledger 118 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 10, 2026 | issue | SO-261010-994 | MAIN | 1 | 194.91 | -194.91 | 4 | 779.66 | July 11, 2026: 1 @ 194.91 |
| Oct. 7, 2026 | issue | SO-261007-820 | MAIN | 1 | 194.91 | -194.91 | 5 | 974.57 | July 11, 2026: 1 @ 194.91 |
| Oct. 6, 2026 | issue | SO-261006-722 | MAIN | 1 | 194.91 | -194.91 | 6 | 1,169.49 | July 11, 2026: 1 @ 194.91 |
| Sept. 30, 2026 | issue | SO-260930-842 | MAIN | 1 | 194.91 | -194.91 | 7 | 1,364.40 | July 11, 2026: 1 @ 194.91 |
| Sept. 27, 2026 | issue | SO-260927-796 | MAIN | 3 | 194.91 | -584.74 | 8 | 1,559.32 | July 11, 2026: 3 @ 194.91 |
| Sept. 24, 2026 | issue | SO-260924-730 | MAIN | 1 | 194.91 | -194.91 | 11 | 2,144.06 | July 11, 2026: 1 @ 194.91 |
| Sept. 22, 2026 | issue | SO-260922-963 | MAIN | 1 | 194.91 | -194.91 | 12 | 2,338.97 | July 11, 2026: 1 @ 194.91 |
| Aug. 31, 2026 | issue | SO-260831-817 | MAIN | 3 | 194.91 | -584.74 | 13 | 2,533.89 | July 11, 2026: 3 @ 194.91 |
| Aug. 23, 2026 | issue | SO-260823-412 | MAIN | 1 | 194.91 | -194.91 | 16 | 3,118.63 | July 11, 2026: 1 @ 194.91 |
| Aug. 20, 2026 | issue | SO-260820-610 | MAIN | 3 | 194.91 | -584.74 | 17 | 3,313.54 | July 11, 2026: 3 @ 194.91 |
| Aug. 5, 2026 | issue | SO-260805-451 | MAIN | 3 | 194.91 | -584.74 | 20 | 3,898.29 | July 11, 2026: 3 @ 194.91 |
| July 31, 2026 | issue | SO-260731-171 | MAIN | 4 | 195.43 | -781.74 | 23 | 4,483.03 | June 24, 2026: 1 @ 196.99; July 11, 2026: 3 @ 194.91 |
| July 30, 2026 | issue | SO-260730-233 | MAIN | 1 | 196.99 | -196.99 | 27 | 5,264.77 | June 24, 2026: 1 @ 196.99 |
| July 28, 2026 | issue | SO-260728-702 | MAIN | 1 | 196.99 | -196.99 | 28 | 5,461.76 | June 24, 2026: 1 @ 196.99 |
| July 20, 2026 | issue | SO-260720-148 | MAIN | 1 | 196.99 | -196.99 | 29 | 5,658.75 | May 7, 2026: 1 @ 196.99 |
| July 11, 2026 | issue | SO-260711-389 | MAIN | 5 | 196.99 | -984.97 | 30 | 5,855.75 | May 7, 2026: 5 @ 196.99 |
| July 11, 2026 | receipt | PO-001641 | MAIN | 26 | 194.91 | 5,067.77 | 35 | 6,840.71 | |
| July 5, 2026 | issue | SO-260705-433 | MAIN | 3 | 196.99 | -590.98 | 9 | 1,772.94 | May 7, 2026: 3 @ 196.99 |
| July 3, 2026 | issue | SO-260703-508 | MAIN | 3 | 196.99 | -590.98 | 12 | 2,363.92 | May 7, 2026: 3 @ 196.99 |
| June 25, 2026 | issue | SO-260625-734 | MAIN | 1 | 196.99 | -196.99 | 15 | 2,954.90 | May 7, 2026: 1 @ 196.99 |
| June 24, 2026 | return | RMA | MAIN | 3 | 196.99 | 590.98 | 16 | 3,151.89 | |
| June 22, 2026 | issue | SO-260622-833 | MAIN | 1 | 196.99 | -196.99 | 13 | 2,560.91 | May 7, 2026: 1 @ 196.99 |
| June 14, 2026 | issue | SO-260614-631 | MAIN | 3 | 196.99 | -590.98 | 14 | 2,757.91 | May 7, 2026: 3 @ 196.99 |
| June 13, 2026 | issue | SO-260613-136 | MAIN | 6 | 196.99 | -1,181.96 | 17 | 3,348.89 | May 7, 2026: 6 @ 196.99 |
| June 11, 2026 | issue | SO-260611-288 | MAIN | 5 | 196.99 | -984.97 | 23 | 4,530.85 | May 7, 2026: 5 @ 196.99 |
| May 23, 2026 | issue | SO-260523-449 | MAIN | 1 | 196.99 | -196.99 | 28 | 5,515.81 | May 7, 2026: 1 @ 196.99 |
| May 21, 2026 | issue | SO-260521-261 | MAIN | 3 | 196.99 | -590.98 | 29 | 5,712.81 | May 7, 2026: 3 @ 196.99 |
| May 17, 2026 | issue | SO-260517-655 | MAIN | 1 | 196.99 | -196.99 | 32 | 6,303.79 | May 7, 2026: 1 @ 196.99 |
| May 7, 2026 | receipt | PO-001471 | MAIN | 33 | 196.99 | 6,500.78 | 33 | 6,500.78 | |
| May 6, 2026 | issue | SO-260506-440 | MAIN | 7 | 197.97 | -1,385.81 | 0 | 0.00 | March 20, 2026: 7 @ 197.97 |
| May 3, 2026 | issue | SO-260503-455 | MAIN | 1 | 197.97 | -197.97 | 7 | 1,385.81 | March 20, 2026: 1 @ 197.97 |
| May 2, 2026 | issue | SO-260502-461 | MAIN | 1 | 197.97 | -197.97 | 8 | 1,583.78 | March 20, 2026: 1 @ 197.97 |
| April 30, 2026 | issue | SO-260430-487 | MAIN | 1 | 197.97 | -197.97 | 9 | 1,781.75 | March 20, 2026: 1 @ 197.97 |
| April 26, 2026 | issue | SO-260426-783 | MAIN | 2 | 197.97 | -395.95 | 10 | 1,979.73 | March 20, 2026: 2 @ 197.97 |
| April 21, 2026 | issue | SO-260421-556 | MAIN | 1 | 197.97 | -197.97 | 12 | 2,375.67 | March 20, 2026: 1 @ 197.97 |
| April 19, 2026 | issue | SO-260419-625 | MAIN | 1 | 197.97 | -197.97 | 13 | 2,573.64 | March 20, 2026: 1 @ 197.97 |
| April 15, 2026 | issue | SO-260415-698 | MAIN | 4 | 199.04 | -796.15 | 14 | 2,771.62 | March 2, 2026: 4 @ 199.04 |
| March 20, 2026 | receipt | PO-001336 | MAIN | 14 | 197.97 | 2,771.62 | 18 | 3,567.77 | |
| March 10, 2026 | issue | SO-260310-712 | MAIN | 3 | 199.04 | -597.12 | 4 | 796.15 | March 2, 2026: 3 @ 199.04 |
| March 3, 2026 | issue | SO-260303-171 | MAIN | 4 | 198.70 | -794.81 | 7 | 1,393.27 | Jan. 30, 2026: 1 @ 198.37; Feb. 15, 2026: 1 @ 198.37; March 2, 2026: 2 @ 199.04 |
| March 2, 2026 | receipt | PO-001273 | MAIN | 9 | 199.04 | 1,791.35 | 11 | 2,188.08 | |
| Feb. 17, 2026 | issue | SO-260217-118 | MAIN | 1 | 198.37 | -198.37 | 2 | 396.73 | Jan. 21, 2026: 1 @ 198.37 |
| Feb. 15, 2026 | return | RMA | MAIN | 1 | 198.37 | 198.37 | 3 | 595.10 | |
| Feb. 12, 2026 | issue | SO-260212-177 | MAIN | 1 | 198.37 | -198.37 | 2 | 396.73 | Jan. 21, 2026: 1 @ 198.37 |
| Feb. 3, 2026 | issue | SO-260203-930 | MAIN | 2 | 198.37 | -396.73 | 3 | 595.10 | Jan. 21, 2026: 2 @ 198.37 |
| Feb. 2, 2026 | issue | SO-260202-920 | MAIN | 1 | 198.37 | -198.37 | 5 | 991.83 | Jan. 21, 2026: 1 @ 198.37 |
| Jan. 30, 2026 | return | RMA | MAIN | 1 | 198.37 | 198.37 | 6 | 1,190.20 | |
| Jan. 21, 2026 | issue | SO-260121-574 | MAIN | 2 | 198.37 | -396.73 | 5 | 991.83 | Jan. 21, 2026: 2 @ 198.37 |
| Jan. 21, 2026 | receipt | PO-001164 | MAIN | 7 | 198.37 | 1,388.57 | 7 | 1,388.57 | |
| Jan. 19, 2026 | issue | SO-260119-179 | MAIN | 1 | 198.68 | -198.68 | 0 | 0.00 | Sept. 26, 2025: 1 @ 198.68 |
| Dec. 31, 2025 | issue | SO-251231-672 | MAIN | 1 | 198.68 | -198.68 | 1 | 198.68 | Sept. 26, 2025: 1 @ 198.68 |
| Dec. 25, 2025 | issue | SO-251225-128 | MAIN | 2 | 198.68 | -397.36 | 2 | 397.36 | Sept. 26, 2025: 2 @ 198.68 |
| Nov. 6, 2025 | issue | SO-251106-710 | MAIN | 1 | 198.68 | -198.68 | 4 | 794.71 | Sept. 26, 2025: 1 @ 198.68 |
| Oct. 27, 2025 | issue | SO-251027-991 | MAIN | 2 | 198.68 | -397.36 | 5 | 993.39 | Sept. 26, 2025: 2 @ 198.68 |
| Oct. 21, 2025 | issue | SO-251021-706 | MAIN | 1 | 198.68 | -198.68 | 7 | 1,390.74 | Sept. 26, 2025: 1 @ 198.68 |
| Oct. 5, 2025 | issue | SO-251005-973 | MAIN | 1 | 198.68 | -198.68 | 8 | 1,589.42 | Sept. 26, 2025: 1 @ 198.68 |
| Sept. 26, 2025 | receipt | PO-000875 | MAIN | 9 | 198.68 | 1,788.10 | 9 | 1,788.10 | |
| Sept. 25, 2025 | issue | SO-250925-569 | MAIN | 1 | 194.24 | -194.24 | 0 | 0.00 | June 14, 2025: 1 @ 194.24 |
| Sept. 21, 2025 | issue | SO-250921-380 | MAIN | 1 | 194.24 | -194.24 | 1 | 194.24 | June 14, 2025: 1 @ 194.24 |
| Sept. 17, 2025 | issue | SO-250917-746 | MAIN | 2 | 194.24 | -388.48 | 2 | 388.48 | June 14, 2025: 2 @ 194.24 |
| Sept. 6, 2025 | issue | SO-250906-713 | MAIN | 1 | 194.24 | -194.24 | 4 | 776.96 | June 14, 2025: 1 @ 194.24 |
| Sept. 4, 2025 | issue | SO-250904-725 | MAIN | 1 | 194.24 | -194.24 | 5 | 971.20 | June 14, 2025: 1 @ 194.24 |
| Sept. 3, 2025 | issue | SO-250903-406 | MAIN | 1 | 194.24 | -194.24 | 6 | 1,165.44 | June 14, 2025: 1 @ 194.24 |
| Aug. 30, 2025 | issue | SO-250830-442 | MAIN | 2 | 194.24 | -388.48 | 7 | 1,359.67 | June 14, 2025: 2 @ 194.24 |
| Aug. 27, 2025 | issue | SO-250827-200 | MAIN | 1 | 194.24 | -194.24 | 9 | 1,748.15 | June 14, 2025: 1 @ 194.24 |
| Aug. 23, 2025 | issue | SO-250823-793 | MAIN | 1 | 194.24 | -194.24 | 10 | 1,942.39 | June 14, 2025: 1 @ 194.24 |
| Aug. 15, 2025 | issue | SO-250815-571 | MAIN | 2 | 194.24 | -388.48 | 11 | 2,136.63 | June 14, 2025: 2 @ 194.24 |
| Aug. 14, 2025 | issue | SO-250814-453 | MAIN | 1 | 194.24 | -194.24 | 13 | 2,525.11 | June 14, 2025: 1 @ 194.24 |
| Aug. 12, 2025 | issue | SO-250812-532 | MAIN | 3 | 194.24 | -582.72 | 14 | 2,719.35 | June 14, 2025: 3 @ 194.24 |
| Aug. 3, 2025 | issue | SO-250803-511 | MAIN | 1 | 194.24 | -194.24 | 17 | 3,302.07 | June 14, 2025: 1 @ 194.24 |
| July 30, 2025 | issue | SO-250730-544 | MAIN | 4 | 194.24 | -776.96 | 18 | 3,496.31 | June 14, 2025: 4 @ 194.24 |
| July 30, 2025 | issue | SO-250730-544 | EAST | 6 | 194.24 | -1,165.44 | 22 | 4,273.26 | June 14, 2025: 6 @ 194.24 |
| July 28, 2025 | issue | SO-250728-611 | MAIN | 1 | 194.24 | -194.24 | 28 | 5,438.70 | June 14, 2025: 1 @ 194.24 |
| July 15, 2025 | issue | SO-250715-517 | MAIN | 1 | 194.24 | -194.24 | 29 | 5,632.94 | June 14, 2025: 1 @ 194.24 |
| July 11, 2025 | issue | SO-250711-976 | MAIN | 2 | 194.24 | -388.48 | 30 | 5,827.18 | June 14, 2025: 2 @ 194.24 |
| July 3, 2025 | issue | SO-250703-133 | MAIN | 1 | 194.24 | -194.24 | 32 | 6,215.65 | June 14, 2025: 1 @ 194.24 |
| July 1, 2025 | issue | SO-250701-105 | EAST | 1 | 194.24 | -194.24 | 33 | 6,409.89 | June 14, 2025: 1 @ 194.24 |
| June 14, 2025 | issue | SO-250614-786 | MAIN | 2 | 193.90 | -387.80 | 34 | 6,604.13 | May 24, 2025: 1 @ 193.56; June 14, 2025: 1 @ 194.24 |
| June 14, 2025 | transfer | TRF | MAIN → EAST | 7 | warehouse transfer, no cost effect | ||||
| June 14, 2025 | receipt | PO-000635 | MAIN | 35 | 194.24 | 6,798.37 | 36 | 6,991.93 | |
| June 13, 2025 | issue | SO-250613-841 | MAIN | 9 | 193.56 | -1,742.02 | 1 | 193.56 | May 2, 2025: 8 @ 193.56; May 24, 2025: 1 @ 193.56 |
| June 6, 2025 | issue | SO-250606-419 | MAIN | 3 | 193.56 | -580.67 | 10 | 1,935.58 | May 2, 2025: 3 @ 193.56 |
| June 5, 2025 | issue | SO-250605-761 | MAIN | 4 | 193.56 | -774.23 | 13 | 2,516.25 | May 2, 2025: 4 @ 193.56 |
| May 24, 2025 | return | RMA | MAIN | 2 | 193.56 | 387.12 | 17 | 3,290.48 | |
| May 20, 2025 | issue | SO-250520-462 | MAIN | 4 | 193.56 | -774.23 | 15 | 2,903.37 | May 2, 2025: 4 @ 193.56 |
| May 2, 2025 | issue | SO-250502-120 | MAIN | 7 | 193.56 | -1,354.90 | 19 | 3,677.60 | May 2, 2025: 7 @ 193.56 |
| May 2, 2025 | issue | SO-250502-120 | EAST | 7 | 193.56 | -1,354.90 | 26 | 5,032.50 | May 2, 2025: 7 @ 193.56 |
| May 2, 2025 | transfer | TRF | MAIN → EAST | 7 | warehouse transfer, no cost effect | ||||
| May 2, 2025 | receipt | PO-000504 | MAIN | 33 | 193.56 | 6,387.41 | 33 | 6,387.41 | |
| April 22, 2025 | issue | SO-250422-415 | MAIN | 1 | 190.42 | -190.42 | 0 | 0.00 | March 22, 2025: 1 @ 190.42 |
| April 22, 2025 | issue | SO-250422-415 | EAST | 3 | 188.94 | -566.82 | 1 | 190.42 | March 8, 2025: 2 @ 188.20; March 22, 2025: 1 @ 190.42 |
| April 19, 2025 | issue | SO-250419-516 | MAIN | 9 | 188.20 | -1,693.81 | 4 | 757.25 | March 8, 2025: 9 @ 188.20 |
| March 25, 2025 | issue | SO-250325-717 | MAIN | 4 | 188.76 | -755.03 | 13 | 2,451.06 | Jan. 27, 2025: 1 @ 190.42; March 8, 2025: 3 @ 188.20 |
| March 22, 2025 | return | RMA | MAIN | 2 | 190.42 | 380.84 | 17 | 3,206.09 | |
| March 14, 2025 | issue | SO-250314-852 | MAIN | 4 | 190.42 | -761.69 | 15 | 2,825.24 | Jan. 27, 2025: 4 @ 190.42 |
| March 9, 2025 | issue | SO-250309-168 | MAIN | 1 | 190.42 | -190.42 | 19 | 3,586.93 | Jan. 27, 2025: 1 @ 190.42 |
| March 8, 2025 | transfer | TRF | MAIN → EAST | 3 | warehouse transfer, no cost effect | ||||
| March 8, 2025 | receipt | PO-000328 | MAIN | 14 | 188.20 | 2,634.82 | 20 | 3,777.35 | |
| March 7, 2025 | issue | SO-250307-199 | MAIN | 1 | 190.42 | -190.42 | 6 | 1,142.53 | Jan. 27, 2025: 1 @ 190.42 |
| Feb. 25, 2025 | issue | SO-250225-992 | MAIN | 1 | 190.42 | -190.42 | 7 | 1,332.95 | Jan. 27, 2025: 1 @ 190.42 |
| Feb. 6, 2025 | issue | SO-250206-792 | MAIN | 1 | 190.42 | -190.42 | 8 | 1,523.37 | Jan. 27, 2025: 1 @ 190.42 |
| Feb. 5, 2025 | issue | SO-250205-482 | MAIN | 1 | 192.41 | -192.41 | 9 | 1,713.79 | Oct. 1, 2024: 1 @ 192.41 |
| Feb. 2, 2025 | issue | SO-250202-381 | MAIN | 1 | 192.41 | -192.41 | 10 | 1,906.21 | Oct. 1, 2024: 1 @ 192.41 |
| Jan. 27, 2025 | receipt | PO-000223 | MAIN | 9 | 190.42 | 1,713.79 | 11 | 2,098.62 | |
| Jan. 17, 2025 | issue | SO-250117-921 | MAIN | 1 | 192.41 | -192.41 | 2 | 384.83 | Oct. 1, 2024: 1 @ 192.41 |
| Jan. 15, 2025 | issue | SO-250115-673 | MAIN | 1 | 192.41 | -192.41 | 3 | 577.24 | Oct. 1, 2024: 1 @ 192.41 |
| Jan. 14, 2025 | issue | SO-250114-991 | MAIN | 1 | 192.41 | -192.41 | 4 | 769.65 | Oct. 1, 2024: 1 @ 192.41 |
| Jan. 13, 2025 | issue | SO-250113-892 | MAIN | 1 | 192.41 | -192.41 | 5 | 962.06 | Oct. 1, 2024: 1 @ 192.41 |
| Jan. 13, 2025 | issue | SO-250113-892 | EAST | 2 | 192.41 | -384.83 | 6 | 1,154.48 | Oct. 1, 2024: 2 @ 192.41 |
| Jan. 7, 2025 | issue | SO-250107-564 | EAST | 1 | 192.41 | -192.41 | 8 | 1,539.30 | Oct. 1, 2024: 1 @ 192.41 |
| Dec. 6, 2024 | issue | SO-241206-168 | MAIN | 1 | 192.41 | -192.41 | 9 | 1,731.72 | Oct. 1, 2024: 1 @ 192.41 |
| Nov. 25, 2024 | issue | SO-241125-958 | MAIN | 2 | 192.41 | -384.83 | 10 | 1,924.13 | Oct. 1, 2024: 2 @ 192.41 |
| Nov. 23, 2024 | issue | SO-241123-995 | MAIN | 1 | 192.41 | -192.41 | 12 | 2,308.96 | Oct. 1, 2024: 1 @ 192.41 |
| Oct. 30, 2024 | issue | SO-241030-373 | MAIN | 1 | 192.41 | -192.41 | 13 | 2,501.37 | Oct. 1, 2024: 1 @ 192.41 |
| Oct. 20, 2024 | issue | SO-241020-308 | MAIN | 1 | 192.41 | -192.41 | 14 | 2,693.78 | Oct. 1, 2024: 1 @ 192.41 |
| Oct. 1, 2024 | issue | SO-241001-856 | EAST | 2 | 192.41 | -384.83 | 15 | 2,886.20 | Oct. 1, 2024: 2 @ 192.41 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 5 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000003 | MAIN | 17 | 192.41 | 3,271.02 | 17 | 3,271.02 | |