Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer Question A -E. i have provided a layout that i have that should help solve the problem . please show your work for

Please answer Question A -E. i have provided a layout that i have that should help solve the problem . please show your work for a thumbs up !
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Brockport's famous Bro Restaurant is open 24 hours a day. Full time servers report for duty at 7 AM, 11AM,3 PM, 7 PM, or 11PM, and each works an 8-hour shift. We can also add part-time servers who report to work at the beginning of any period and work only 4 hours. There are only up to 10 part-time servers available during this period. Each full-time server costs the business $20/hr and each part-time server costs $30/hr. The following table shows the minimum number of servers needed during the 6 periods into which the day isdivided: The company wishes to minimize cost. Formulate this as a linear programming problem, solve it in Excel, and answer the following questions: a) How may full-time servers should be used? b) How many part-time servers should be hired to work between 7pm and 11pm ? c) What is the minimum total cost? d) How many employees start to work at 11:00am? e) How many employees work during 7:00pm and 11:00pm? A) Boew iftey fylt-time seroert thoud bet used? (C) Hinw many a pluged start th work at 11 foom? A) How may full-time servers should be used? B) How many part-time servers should be hired to work between 7pm and 11 pm? C) What is the minimum total cost?. D) How many employees start to work at 11:00am? E) How many employees work during 7:00pm and 11:00pm? C2. Mahe Unconstrained Variables Noin-Negative Select a Solvine Methode Sotvine Nhethod smongth

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Project management the managerial process

Authors: Eric W Larson, Clifford F. Gray

5th edition

73403342, 978-0073403342

More Books

Students also viewed these General Management questions