Question: If you know how to solve this using tree plan and solver contact myinfacebeauty@gm ail.com willing to pay contact asap. Antigonish Restaurant is open from

If you know how to solve this using tree plan and solver contact

myinfacebeauty@gm ail.com willing to pay contact asap.

Antigonish Restaurant is open from 8:00 am to 10:00 pm daily. Besides the hours the restaurant is open for customers, workers are needed an hour before opening and an hour after closing for set up and cleanup activities. The restaurant operates with both full-time 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 restaurants periods from 11:am 1:00 pm and from 5:00 pm 7:00 pm. Formulate and LP for this problem with the objective of minimizing total daily labor costs. Implement your model in an Excel spreadsheet and use Solver to solve it. What is the optimal solution?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Up, Up, and Away! Event Planning and Production in Las Vegas Cheri A. Young, University of Denver Daniel E. Nelson, The International School of Hospitality Kathleen S. Nelson, University of Nevada...

I am dyslexic so it takes much longer for me to do any reading, so any and all help is greatly appreciated. I will be sure to thumbs up! Please I need help... Report Layout Structure Table of...

TACKLE ALL PARTSP5 Problem 1 The Airfare Problem1. You are trying to get the cheapest airfare that you can. You just called up and found that the ticket home will cost $400, and it cannot be refunded...

Financial things to consider: 1. What are the contribution margins of each category of membership? Is the $50 membership profitable to the museum? (obtained through direct mail) You need to calculate...

Hello this is one big hw assignment so i had to take picture one by one Customer Strategy To: New Convention Center Sales Trainee From: Michael Scott, Sales Manager Re: Proposal for Chris Finch Your...

Administrative Law 5 A dministrative law governs and defines the powers of government agencies. A number of political and technological factors have led to an explosion in the growth of government...

Prepare a pro forma income statement like that show in Exhibit 2 in the case which includes expected revenues and costs for 2005. In early 2005. Ashley Mercer, director of development and community...

You helped me a couple of weeks ago. I was wondering if i could setup a time for tomorrow that you could be available to help me with some questions. I will pay $20 per question. They are short and I...

S w 9B10D015 O PY SUNSET GRILL AT BLUE Jason Melhuish wrote this case under the supervision of Professors Dina Ribbink and John Haywood-Farmer solely to provide material for class discussion. The...

The Isle of Veritas has made it illegal to trade with the outside world. Only two commodities are consumed on this island, milk and wheat. On the north side of the island are 40 farms. Each of these...

You have developed a new product and you desperately want your company to sell the product. However top-level management will not approve the product because of its high breakeven point. You realize...

4 - 3 3 Under the modified accrual basis of accounting used by the General Fund, financial resources are considered available if the revenve or other financing source is expected to be collected...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...