The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 398 Weeks Ago, 3 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
 I need to solve the following linear, integer and mixed integer programming problem in excel:
The restaurant is open from 11:00 a.m. to midnight every day of the week. Tony divided the workday into five shifts. The table below shows the minimum number of workers needed during the five shifts of time into which the workday is divided.
|
Shift |
Time |
      # of Staff Required |
|
1Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |
10:00 a.m. - 1:00 p.m. |
       3 |
|
2 |
1:00 p.m. - 4:00 p.m. |
       4 |
|
3 |
4:00 p.m. - 7:00 p.m. |
       6 |
|
4 |
7:00 p.m. - 10:00 p.m. |
       7 |
|
5 |
10:00 p.m. - 1:00 a.m. |
       4 |
Â
Â
The owners must find the right number of staff to report at each start time to ensure that there is sufficient coverage. The organization is trying to keep costs low and balance the number of staff with the size of the restaurant, so the total number of workers is constrained to 15. Based on these factors, recommend the staff for each shift to accommodate the minimum requirements for customer service.
Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â----------- -----------Â ----------- Â ----------- T-----------han-----------k Y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age-----------