Question: Snookers Restaurant is open from 8:00 am to 10:00 pm daily. Besides the hours that they are open for business, workers are needed an hour

Snookers Restaurant is open from 8:00 am to 10:00 pm daily. Besides the hours that they are open for business, workers are needed an hour before opening and an hour after closing for setup and cleanup activities. The restaurant operates with both fulltime and part-time workers on the following shifts:

Shift Daily Pay Rate

7:00 am–11:00 am ..........$32

7:00 am–3:00 pm ............$80

11:00 am–3:00 pm ..........$32

11:00 am–7:00 pm ..........$80

3:00 pm–7:00 pm ...........$32

3:00 pm–11:00 pm ..........$80

7:00 pm–11:00 pm ..........$32

The following numbers of workers are needed during each of the indicated time blocks.

Hours Workers Needed

7:00 am–11:00 am ..........11

11:00 am–1:00 pm ..........24

1:00 pm–3:00 pm ...........16

3:00 pm–5:00 pm ...........10

5:00 pm–7:00 pm ...........22

7:00 pm–9:00 pm ...........17

9:00 pm–11:00 pm .......... 6

At least one full-time worker must be available during the hour before opening and after closing. Additionally, at least 30% of the employees should be full-time (8-hour) workers during the restaurant’s busy periods from 11:00 am–1:00 pm and 5:00 pm–7:00 pm.

a. Formulate an ILP for this problem with the objective of minimizing total daily labor costs.

b. Implement your model in a spreadsheet and solve it.

c. What is the optimal solution?

Step by Step Solution

★★★★★

3.49 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

This is a comprehensive problem involving Integer Linear Programming ILP to create an optimal shift schedule for Snookers Restaurant We will begin by ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

167-B-M-L-M-D-A (204).xlsx

300 KBs Excel File

Students Have Also Explored These Related Management Leadership Questions!

Professional Application Case: Madison Public Library The Madison Public Library (MPL) is an agency of the City of Madison, Wisconsin. The mission of the library is to provide free and equitable...

Write brief notes on ANY TWO of the following. Include diagrams, exam- ples and illustrations from the current environment in New Zealand where appropriate. (a) [5 marks] Using experimental methods...

We saw in lecture methods to store integers (both negative and non-negative) and real numbers as sequences of Os and 1s. Integers can be stored exactly (using binary numbers and/or 2's complement),...

The following are the numbers of hours that 10 police officers have spent being trained in how to handle encounters with people who are mentally ill. Calculate the (a) Range, (b) Inter-quartile...

Snookers Restaurant is open from 8:00 a.m. to 10:00 p.m. daily. Besides the hours they are open for business, workers are needed an hour before opening and an hour after closing for setup and clean...

Snookers Restaurant is open from 8:00 am to 10:00 pm daily. Besides the hours they are open for business, workers are needed an hour before opening and an hour after closing for setup and clean-up...

Snookers Restaurant is open from 8 : 0 0 am to 1 0 : 0 0 pm daily. Besides the hours they are open for business, workers are needed an hour before opening and an hour after closing for setup and...

using excel solver Snookers Restaurant is open from 8 : 0 0 a . m . to 1 0 : 0 0 p . m . daily. Besides the hours they are open for business, workers are needed an hour before opening and an hour...

HW# 5 HW# 5 from 9 th edition textbook: Problem 1 3 ( employee scheduling ) , Problem 2 0 ( NPV ) , 2 5 ( ILP ) , 3 1 ( cash flow investment ) Problem 1 3 : Snookers Restaurant is open from 8 : 0 0 a...

9. Snookers Restaurant is open from 8:00 am. to 10:00 pm. daily. Besides the hours the restaurant is open for business, workers are needed an hour before opening and an hour after closing for setup...

You have been recently hired by the Azad Inc., a manufacturing company to work as a cost analyst in the accounting department. The head of the department has asked you to examine the income statement...

The balance scales below all go together: What shapes or combinations of shapes will balance the last scale? In other words, what can you replace the question mark with? Can you find more than one...

Can you help me solve this problem, Ive been getting like 9 5 % of correct but it won't give me any credit unless I get the first part correct, which i havent so can you please help me solve it ....

(12) Gaseous fuel composed of 65% carbon, 30% hydrogen and 5% oxygen saturated with water vapor is burned with 20% excess air. Air is supplied at 70F, saturated with water vapor. Incomplete...

Let G = (V, E) be a graph with nonnegative edge weights ce for every edge e. The maximum weight matching problem is the problem of finding a matching of maximum weight. An edge-cover is a set of...

You may seek help from Wolfram alpha in solving this homework. 1. (10) Solve the following differential equation under the provided conditions. Plot pole locations (roots of denominator of LT), what...

3.4 Mean and median. Figure 3.5 displays three density curves, each with three points marked on them. .A.t which of these points on each curve do the mean and the median fall? AM A BC (a) B (b) () AB...

Bills Grill is a popular college restaurant that is famous for its hamburgers. The owner of the restaurant, Bill, mixes fresh ground beef and pork with a secret ingredient to make delicious...

Zippy motorcycle manufacturing produces two popular pocket bikes (miniature motorcycles with 49cc engines): the Razor and the Zoomer. In the coming week, the manufacturer wants to produce a total of...

The Quality Desk Company makes two types of computer desks from laminated particle board. The Presidential model requires 30 square feet of particle board, 1 keyboard sliding mechanism, and 5 hours...

Rust Industrial Systems Company is trying to decide between two different conveyor belt systems. System A costs $340,000, has a four-year life, and requires $133,000 in pretax annual operating costs....

A potential project with is expected to generate the following revenue per annum for the next 6 years with a after-tax operating cash flow margin of 20% (prior to consideration of working capital)...

can someone help ? The Great Glant Gorp has a management contract with its newly hired president. The contract requires a lump sum payment of $25,700,000 be paid to the president upon the completion...