Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need help asap Unit 6 Case Study-Project 8M PT Staff In this case study, you will use Solver and create Scenario Summaries for two options
Need help asap Unit 6 Case Study-Project 8M PT Staff In this case study, you will use Solver and create Scenario Summaries for two options to det ermine the optimum schedule for part-time servers by com pleting the following Open the file e08PM PM_Saff and using your own name, save it as Lastname_Firstname 8M_PT_Staff.xlsx. Be sure that Solver is in stalled. Use Solver to det ermine the opt im um schedule for part-time servers for the weekday schedule at the Raleigh, North Carolina rest aurant Solver for Option 1, in which you want the objective (Cell D16)to have the minim um (Min) number of employees scheduled by changing the number of employees (04:D9). The first constrant is to be sure that you have enough(#) employees (E11011) to meet expected dem and (E13:Q13) and the second constraint is to be sure that only whole numbers are used (because you cannot schedule part of a person to work) This solution used 97.00 hours and has 9 employees scheduled at 10:30 in the morning, which are 7 more than needed. Keep this solution, and solver for Option 2 by adding an additional constraint that allo ws no more than two em ployees to be scheduled for the first shift, (Hint: D4 2) This solution sets Tot al Hoursto 100.50. In this scenario, the greatest surplus of staff (7 employees)occurs bet ween 2:00 and 3:00. Keep this solution by clicking OK Create a Scenario Summ ary for the two options Select all sheets and insert the file name in the footer in center the sheets horizontally. Add appropriate inform ation to the includingthe tags weekday work schedule, part-time staff and submit by uploadingthe completed work sheet into Blackboard the left section. Set the orientation to Landscape, set the width to Ipage, and document properties File Needed: e08M_PT St aff.xis DELL e all photos Add to a creation Edit & Create v Weekday Work Schedule Servers 10:30- 11:00 1200- 1:00 2:00- 3:00. 4:00- 5:00- 6:00-7:00- 8:00-9:00 10:00 Start Time End Time Worked Employees 11:00 12:00 1:00 2:00 3:00 4:00 5:00600 00 8:00 9:00 10.00 10.30 Hours 10:30 AM 2:00 PM 3.5 0 0O O0 O0 0 11:00 AM 3:00 PM 4 12:00 PM 4:00 PM 4:00 PM 8:00 PM 5:00 PM 9:00 PM 4 6:00 PM 10:30 PM 4.5 12 12 84 Employees Scheduled 24 4 12 128 4 4 10 3 8 12 12 10 3 12 Employees Needed Surplus or (Shortage) 96.00 Total Hours DELL 12 F3 F1 Unit 6 Case Study-Project 8M PT Staff In this case study, you will use Solver and create Scenario Summaries for two options to det ermine the optimum schedule for part-time servers by com pleting the following Open the file e08PM PM_Saff and using your own name, save it as Lastname_Firstname 8M_PT_Staff.xlsx. Be sure that Solver is in stalled. Use Solver to det ermine the opt im um schedule for part-time servers for the weekday schedule at the Raleigh, North Carolina rest aurant Solver for Option 1, in which you want the objective (Cell D16)to have the minim um (Min) number of employees scheduled by changing the number of employees (04:D9). The first constrant is to be sure that you have enough(#) employees (E11011) to meet expected dem and (E13:Q13) and the second constraint is to be sure that only whole numbers are used (because you cannot schedule part of a person to work) This solution used 97.00 hours and has 9 employees scheduled at 10:30 in the morning, which are 7 more than needed. Keep this solution, and solver for Option 2 by adding an additional constraint that allo ws no more than two em ployees to be scheduled for the first shift, (Hint: D4 2) This solution sets Tot al Hoursto 100.50. In this scenario, the greatest surplus of staff (7 employees)occurs bet ween 2:00 and 3:00. Keep this solution by clicking OK Create a Scenario Summ ary for the two options Select all sheets and insert the file name in the footer in center the sheets horizontally. Add appropriate inform ation to the includingthe tags weekday work schedule, part-time staff and submit by uploadingthe completed work sheet into Blackboard the left section. Set the orientation to Landscape, set the width to Ipage, and document properties File Needed: e08M_PT St aff.xis DELL e all photos Add to a creation Edit & Create v Weekday Work Schedule Servers 10:30- 11:00 1200- 1:00 2:00- 3:00. 4:00- 5:00- 6:00-7:00- 8:00-9:00 10:00 Start Time End Time Worked Employees 11:00 12:00 1:00 2:00 3:00 4:00 5:00600 00 8:00 9:00 10.00 10.30 Hours 10:30 AM 2:00 PM 3.5 0 0O O0 O0 0 11:00 AM 3:00 PM 4 12:00 PM 4:00 PM 4:00 PM 8:00 PM 5:00 PM 9:00 PM 4 6:00 PM 10:30 PM 4.5 12 12 84 Employees Scheduled 24 4 12 128 4 4 10 3 8 12 12 10 3 12 Employees Needed Surplus or (Shortage) 96.00 Total Hours DELL 12 F3 F1
Need help asap
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started