The objective of minimizing total daily labor costs

Assignment Help Operation Management
Reference no: EM131372115

Snookers Restaurant is open from 7 am to 10:00 pm Monday to Sunday. 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

6:00 am – 10:00 pm $40

6:00 am - 2:00 pm $80

10:00 am – 2:00 pm $40

10:00 am – 6:00 pm $80

2:00 pm – 6:00 pm $40

2:00 pm – 10:00 pm $80

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

Hours Workers needed

6:00 am – 10:00 am 9

10:00 am – 1:00 pm 18

1:00 pm – 4:00 pm 11

4:00 pm – 7:00 pm 16

7:00 pm – 11:00 pm 5

At least one full-time worker must be available during the hour before opening and after closing. Additionally, at least 20% of the employees should be full-time (8-hour) workers during the restaurant’s busy periods from 10:00 am–1:00 pm and 4: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 for this problem?

Reference no: EM131372115

Product design and product selection

Evaluate two to four (2-4) weaknesses that are evident in the selected organization's product life cycle. Generate a new product design and product selection, and then deter

Return the title and songyear from the songs table

Return the title and songyear from the songs table. Return title, songyear, price that were made in the year 1986. Return title, songrating for all songs that were made in yea

Convicted of driving under the influence

Two individuals were convicted of driving under the influence (DUI). Adam, a first offender, received the following sentence: five days in jail, a $4000 fine, loss of driver's

Describe all the types of metadata

As the data warehouse administrator, describe all the types of metadata you would need for performing your job. Explain how these types would assist you. Please DO NOT restate

Company makes cereal from several ingredients

The Charm City Cereal Company makes a cereal from several ingredients. Two of the ingredients, oats and rice, provide vitamins A and B. Define the decision variables. Determin

Municipality to proposal bid for parking garage contract

Corecast Contractors has been requested by a municipality to submit a proposal bid for a parking garage contract. In the past, the cost of preparing bids has been about 2 perc

Presentation of ideal performance management system

Create a presentation of an ideal performance management system (PMS) that you would implement as the human resources (HR) manager of an organization (fictional or real). Be s

Acquiring an unproven lease that had delinquent taxes

E&P Oil Company, Inc. became interested in acquiring an unproven lease that had delinquent taxes of $3,450 due and a past due mortgage payment of $1,645. An agreement was writ


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd