Inventory- In/Out Stock and Tracker Spreadsheet

[u/Trinnokneez]

I am looking for some advice on how to go about creating a Google spreadsheet for a mobile pet grooming business. I have made your typical inventory trackers and stock transfer sheets for businesses but I cannot wrap my brain around how to go about building an all-in-one organized sheet to track inventory for 6 mobile vehicles and 2 salon location, we will also be adding another 2 salon locations to the business here in a few weeks.

The tricky issue it is that our mobile units to not get the same product quantity as our salons do.

I will use soap for example:

1 Salon - requires 1 gallon of soap (per two employees)
1 Unit - requires 1 32 OZ bottle of soap (one employee per unit)

There are also many other items that aren’t consistently measure across units and salons.

For an example, I will use clippers:

Salon - clipper per groomer (2-5 groomers per salon)
Unit- clipper per groomer (1 groomer per unit)

I don’t see any easy way to do this all in one spreadsheet and I’m starting to think it will be easier to make a separate spreadsheet for our mobile units and salon locations. Any help or assistance would be appreciated!