Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For Project oil, you will need the following file. e08M_PT_Staff You will save your workbook as: Lastname_Firstname_8M_PT_Staff Open the file e08M_PT_Staff and save it as

image text in transcribed
For Project oil, you will need the following file. e08M_PT_Staff You will save your workbook as: Lastname_Firstname_8M_PT_Staff Open the file e08M_PT_Staff and save it as Lastname_Firstname_8M_PT_Staff Be sure that Solver is installed. Use Solver to determine the optimum schedule for part-time servers for the weekday schedule at the Raleigh, North Carolina, restaurant. Solve 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). The first constraint is to be sure that you have enough (>=) employees (E1 1:Q11) to meet expected demand (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 uses 97.00 hours and has nine employees scheduled at 10:30 in the morning, which are seven more than needed. Keep this solution, and solve for Option 2 by adding an additional constraint that allows no more than two employees to be scheduled for the first shift. (Hint: D4

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

NY Algebra 2 And Trigonometry

Authors: McGraw Hill Education

1st Edition

9780078733185, 0078733189

More Books

Students also viewed these Mathematics questions