Post University Employees Scheduled Management Worksheet

User Generated

w_onvyrl32

Other

Post University

Description

Unformatted Attachment Preview

Weekday Work Schedule Start Time 10:30 AM 11:00 AM 12:00 PM 4:00 PM 5:00 PM 6:00 PM Servers Hours End Time Worked 2:00 PM 3:00 PM 4:00 PM 8:00 PM 9:00 PM 10:30 PM 3.5 4 4 4 4 4.5 Employees Scheduled Employees 10:00 10:30 4 4 4 4 4 4 1 0 0 0 0 0 1 1 0 0 0 0 1 1 1 0 0 0 1 1 1 0 0 0 0 1 1 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 1 1 0 0 0 0 1 1 1 0 0 0 1 1 1 0 0 0 0 1 1 0 0 0 0 0 1 0 0 0 0 0 1 24 4 8 12 12 8 4 4 8 12 12 8 4 4 2 2 6 2 12 0 10 2 3 5 2 2 3 1 8 0 12 0 12 0 10 -2 3 1 2 2 Employees Needed Surplus or (Shortage) Total Hours 10:30 - 11:00 - 12:00 - 1:00 - 2:00 - 3:00 - 4:00 - 5:00 - 6:00 - 7:00 - 8:00 - 9:00 11:00 12:00 1:00 2:00 3:00 4:00 5:00 6:00 7:00 8:00 9:00 10:00 96.00 CIS250 – Advanced Excel Case Study 3 Due Date: 11:59 pm EST Sunday of Unit 5 Points: 100 Overview: In this case study, you will use Solver and create Scenario Summaries for two options to determine the optimum schedule for part-time servers. Instructions: Using Solver 1. Open the file CaseStudy3_Staff.xlxs and using your own name, save it as Lastname_Firstname_CaseStudy3_Staff.xlsx. 2. Be sure that Solver is installed. 3. Use Solver to determine the optimum schedule for part-time servers for the weekday schedule at the Raleigh, North Carolina restaurant. 4. Solver for Option 1, in which you want the objective (Cell D16) to have the minimum (Min) number of employees scheduled by changing the number of employees (D4:D9). Make sure to add the constraints below: a. The first constraint is to be sure that you have enough (>=) employees (E11:Q11) to meet expected demand (E13:Q13) b. The second constraint is to be sure that only whole numbers are used for the Employees (D4:D9) (because you cannot schedule part of a person to work). Copyright 2022 Post University, ALL RIGHTS RESERVED 5. Make sure you see this solution: This solution used 97.00 hours and has 9 employees scheduled at 10:30 in the morning, which are 7 more than needed. If you do not, please try again. 6. Keep the Solver Solution by generating an Answer Report. This will create a new sheet titled Answer Report 1. Rename the sheet to Option 1 and change the color to Yellow. 7. Keep this solution, and solver for Option 2 by adding an additional constraint that allows no more than two employees to be scheduled for the first shift, (Hint: D4
Purchase answer to see full attachment
Explanation & Answer:
Worksheet
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

View attached explanation and answer. Let me know if you have any questions.Hii Buddy! Please Check the answer. Feel free to ask any question you have about the solution.I doubly checked the criteria of file which was given in pdf file, and covered all the points :) :)Please change the file name in the following formatLastname_Firstname_CaseStudy3_Staff :) :)

Microsoft Excel 16.0 Answer Report
Worksheet: [attachment_1 (4).xlsx]Raleigh Schedule
Report Created: 6/4/2022 11:00:14 PM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: GRG Nonlinear
Solution Time: 0.297 Seconds.
Iterations: 7 Subproblems: 0
Solver Options
Max Time 100 sec, Iterations 100, Precision 0.000001
Convergence 0.0001, Population Size 100, Random Seed 0, D...


Anonymous
Great! Studypool always delivers quality work.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags