What is the optimal solution

Assignment Help Business Management

Reference no: EM13227700

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 cleanup activities. The restaurant operates with both full-time and part-time workers on the following shifts:

Shift: Daily Rate
7a-11a $32
7a-3p $80
11a-3p $32
11a-7p $80
3p-7p $32
3p-11p $80
7p-11p $32
The following number of workers are needed for each shift
7a-11a 11
7a-3p 24
11a-3p 16
11a-7p 10
3p-7p 22
3p-11p 17
7p-11p 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 hours) workers during the restaurant's busy periods from 11a-1p and 5p-7p.

1) Formulate an ILP for this problem with the objective of minimizing total daily labor costs
2) Implement your model in a spreadsheet and solve it
3) What is the optimal solution?

Reference no: EM13227700

Questions Cloud

What is your recommendation to management : Would you rate them low, medium, or high with respect to profitability? · Would you rate them low, medium, or high with respect to risk? · What is your recommendation to management? Why?

State the synthesis of 2-ethyl-2,4,5-trimethyl-1,3-dioxolane : Please provide a complete mechanism (using arrows and lone pairs) for the synthesis of 2-ethyl-2,4,5-trimethyl-1,3-dioxolane using 2-butanone and 2,3-butanediol in an acidic environment (H2SO4).

Design for a minimum number of logic gates : Include the unused states in the design, arranging the circuit to switch from any unused state to the 'main sequence' within one clock cycle, and show the state diagram that applies here. Clearly show all the steps of the design procedure used.

Explain what is the initial concentration of unknown acid : The solution filtered , then we took 25 mL of this unknown acid for titration. we use NaOH base for titration ,the volum of titrated base when it reach the equivalence point was 3.2 mL . and the concentration of NaOH is 0.1 M.

What is the optimal solution : 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 cleanup activities. The restaurant operates with both full-tim..

Define the critical path : The following is a table of activities associated with a project , their duration and what activities each must precede: Activity duration(weeks) precedes A start 1 B,C B 1 E C 4 F E 2 F F end 2 - .

Create the ladder diagram program to accomplish control : A control system is needed to control a small shopping center parking lot lighting system and the exterior lighting for the building. The design specifications require that the parking lot lighting and the exterior lighting turn on at dusk automat..

What are some of the barriers to advancement opportunities : What are some of the barriers to advancement opportunities for women and minorities in many organizations?

Compute the standard change of enthalpy for the combustion : From the following Information, calculate the standard change of enthalpy for the combustion of coal. Compound DeltaHf (kj/mol)

User Account

All Pages