Let me just start by saying that I'm not sure if this is even possible in Tableau...
But lets start with a more simple example of what I'm trying to do. In the spreadsheet you'll see that there are two different locations, and two different employee positions at those locations (plant manager, warehouse forklift). We can see how many employees are at each site, what the position's hourly wage is, total wages by position, and different measures of costs
In the workbook, I have started creating parameters and calculations for these variables
As an example, how would I create a workbook that shows a text table and parameters for the following? So, you could change the number of plant managers/warehouse forklifts and their wages (using parameter controls), and the total number of employees and total wage cost would vary accordingly:
# of plant managers
# of Warehouse Forklifts
Plant Manager wage
Total Wage Cost
The main point of the exercise is to allow someone to manipulate numbers using parameters controls. So, for example, using the parameter controls, what happens if we add two more plant managers to location 1 and another warehouse forklift to location 2, all while decreasing the hourly wage of plant manager at location 1 by .50 an hour? Keep in mind that the hour rates for the same position will vary across different locations, and that each location is its own entity - they have distinct costs, distinct positions and wages, etc. I imagine this means that there will need to be a different parameter for each variable at each location (Florida Location Position x, Florida Location Position x hourly wage, Florida energy cost, New Orleans location Position X, New Orleans Location Position x hourly wage)
In the end, and I say this in case it will help you understand the question, my hope is to model the current situation at multiple locations in regard to total labor costs broken down by position, total expenses, etc etc etc - basically a complete view at what owning location A costs. From that picture, you could then play with the total equation by making small changes to all of the variables. What happens if the energy costs here were lowered this much, I added four more plant managers and give them 2 dollar raises, and so on, eventually showing graphs and other visual displays in addition to the text table.
Please let me know if you have any questions, any ideas you guys have is most appreciated