Answered step by step
Verified Expert Solution
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 !
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started