Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Seating Capacity
Hello,
Basically, I want to maximize seating capacity... Below is a sample data... A B C D E SEAT Hrs Operation Work Hours No of work days no of Employees 100 18 9 5 ? I want to see how many employees can be hired given the following conditions OR/AND perhaps how many seats are needed if I have x number of employees, x hrs of operation, x Work Hours etc... Your help is greatly appreciated! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Seating Capacity
What are the conditions?
"al_ba" <al_814 wrote in message ... Hello, Basically, I want to maximize seating capacity... Below is a sample data... A B C D E SEAT Hrs Operation Work Hours No of work days no of Employees 100 18 9 5 ? I want to see how many employees can be hired given the following conditions OR/AND perhaps how many seats are needed if I have x number of employees, x hrs of operation, x Work Hours etc... Your help is greatly appreciated! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Seating Capacity
The conditions are the data listed below... Given samples...
Seat available=100 Hrs of Operation=18 Work Hrs of Employee=9 Days of Work=5 Days Employees to be hired is what I need. Thanks. "Test" wrote: What are the conditions? "al_ba" <al_814 wrote in message ... Hello, Basically, I want to maximize seating capacity... Below is a sample data... A B C D E SEAT Hrs Operation Work Hours No of work days no of Employees 100 18 9 5 ? I want to see how many employees can be hired given the following conditions OR/AND perhaps how many seats are needed if I have x number of employees, x hrs of operation, x Work Hours etc... Your help is greatly appreciated! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Seating Capacity
What does the number of work days have to do with this? Are you working
people only 1 day a week? Very simply, if you have 18 hours of available time and each shift is a max of 9 hours you can get two shifts in per day. If you have 100 seats that means you can hire 2*100 = 200 employees. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "al_ba" wrote: The conditions are the data listed below... Given samples... Seat available=100 Hrs of Operation=18 Work Hrs of Employee=9 Days of Work=5 Days Employees to be hired is what I need. Thanks. "Test" wrote: What are the conditions? "al_ba" <al_814 wrote in message ... Hello, Basically, I want to maximize seating capacity... Below is a sample data... A B C D E SEAT Hrs Operation Work Hours No of work days no of Employees 100 18 9 5 ? I want to see how many employees can be hired given the following conditions OR/AND perhaps how many seats are needed if I have x number of employees, x hrs of operation, x Work Hours etc... Your help is greatly appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
seating chart | New Users to Excel | |||
design a seating plan | Excel Discussion (Misc queries) | |||
How do I set up a wedding seating chart? | New Users to Excel | |||
formula for a seating chart | Excel Worksheet Functions | |||
seating chart | Excel Worksheet Functions |