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, latest 60 shown - show all
| 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 |