It is not clear exactly what you want but here is what I think.
Base is the total inventory.
Hotel 1 and Hotel 2 are the counts of clean items that have been sent to each of those locations.
Laundry Soiled is the count of soiled linens that come back from Hotel 1 and Hotel 2 (combined).
On-Site is inventory still on site that has not been sent out.
Losses, therefore, is the count of what has gone out to the hotels minus what has come back soiled. That is Hotel 1 + Hotel 2 - Laundry Soiled. The formula for that is
Bookmarks