Determine the optimum schedule for part-time servers

Reference no: EM132389469

Unit Case Study – Project 8M PT Staff

In this case study, you will use Solver and create Scenario Summaries for two options to determine the optimum schedule for part-time servers by completing the following:

Open the file e08PM_PM_Staff and using your own name, save it as

Lastname_Firstname_8M_PT_Staff.xlsx. 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.

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).

The first constraint is to be sure that you have enough (>=) employees (E11: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 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 allows no more than two employees to be scheduled for the first shift, (Hint: D4<=2). This solution sets Total Hours to 100.50. In this scenario, the greatest surplus of staff (7 employees) occurs
between 2:00 and 3:00. Keep this solution by clicking OK.

Create a Scenario Summary for the two options. Select all sheets and insert the file name in the footer in the left section. Set the orientation to Landscape, set the width to 1page, and center the sheets horizontally. Add appropriate information to the document properties, including the tags weekday work schedule, part-time staff and submit by uploading the completed worksheet into Blackboard.

Attachment:- Work Schedule.rar

Reference no: EM132389469

Questions Cloud

Absolute advantage and comparative advantage : 1. What is the difference between absolute advantage and comparative advantage?

Disadvantages of government money borrowing : What are the advantages and disadvantages of government money borrowing?

Explain the true cost to society associated : Explain the "true cost" to society associated with monopolies

Respond to disease with the causes and risk factors : Topic: Endometriosis. Please respond to your disease with the causes/risk factors, pathophysiology, diagnostics, labs, and treatment

Determine the optimum schedule for part-time servers : Create a Scenario Summary for the two options. Select all sheets and insert the file name in the footer in the left section. Determine the optimum schedule.

Mechanical Assignment - Gear Box Questions : Mechanical Assignment - Gear Box Questions. Explaining what need the design will satisfy. Define the primary function of the design

Explain the benefits of using health care expenditure : Explain the benefits of using health care expenditure as a percentage of a nation's gross domestic product over per capita health care

Population growth rate affect economic growth : Why do countries like the United States, Germany, and Japan all seem to be converging to the same level of per capita GDP? Explain.

What explains the long-run growth of aggregate gdp : What explains the long-run growth of aggregate GDP? Is it possible for an economy to continue growing forever solely by accumulating more capital?

User Account

All Pages