I'm modeling a fairly basic order and inventory management system but with a use case that doesn't seem very common (or at least hard to look up online and in books about operations): the order fulfillment date is specific and sometimes far in the future.
A simplified description: a hotel wants to sell items during or after the reservation process. A room can be reserved for the next day or the next year. The order fulfillment (= item delivery) is at check-in time. There is no shipping delay, as the stock is maintain at the hotel and delivered into the room in person.
I've been able to define some basic concepts to help figure out the scope of the system, specifically: orders with a scheduled fulfillment date (i.e. not "ASAP"), on-hand inventory, stock reservations, and a simple, low-scale replenishment process.
However, I'd like to better define an important operational aspect: reservations for 1 year in the future should not result in a stock reservation against on-hand inventory. This is for a few reasons:
- The hotel will definitely replenish the inventory before then
- If the on-hand inventory is reserved for 1 year in the future, it's inventory the hotel cannot sell and use to fulfill more recent orders with a near-future fulfillment date
- The inventory might be perishable
Are there any resources, best practices, case studies around these needs?
What concepts could help me define how far in the future an order results in a stock reservation against on-hand inventory vs. a reservation to be matched with inventory when the time comes?