Question: PLEASE ANSWER USING EXCEL Brockport's famous Bro Restaurant is open 24 hours a day. Full time servers report for duty at 7 AM, 11 AM,

PLEASE ANSWER USING EXCEL Brockport's famous Bro Restaurant is open 24 hours PLEASE ANSWER USING EXCEL

Brockport's famous Bro Restaurant is open 24 hours a day. Full time servers report for duty at 7 AM, 11 AM, 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

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!

Fill in the missing algebra leading to Eqs. (6.40) and (6.42). Eq. (40) ÎÎ± Î¼Î± = ( - gVÎ±),Î±). Eq. (42)

Please answer the following question. Wichita's famous Sethi Restaurant is open 24 hours a day. Servers report for duty at 3 A.M., 7 A.M., 11 A.M., 3 P.M., 7 P.M., or 11 P.M., and each works an...

answer all questions thanks Wichita's famous Sethi Restaurant is open 24 hours a day. Servers report for duty at 3 A.M., 7 A.M., 11 A.M. 3 P.M., 7 P.M. or 11 P.M, and each works an 8-hour shift. The...

PROVIDE THE EXCEL SOLUTION FOR ALL PARTS 6. The famous Changs Restaurant is open 24 hours a day. Waiters and busboys report for duty at 3 A.M., 7 A.M.,11 A.M., 3 P.M., 7 P.M., or 11 P.M., and each...

: The famous Changs Restaurant is open 24 hours a day. Waiters and busboys report for duty at 3 A.M., 7 A.M.,11 A.M., 3 P.M., 7 P.M., or 11 P.M., and each works an 8-hour shift. The following table...

Problem 6: (Restaurant work scheduling problem). The famous Changs Restaurant is open 24 hours a day. Waiters and busboys report for duty at 3 A.M., 7 A.M.,11 A.M., 3 P.M., 7 P.M., or 11 P.M., and...

The famous IHOP Restaurant is open 24 hours a day. Waiters and busboys report for duty at 6 A.M.,10 A.M., 2 P.M, or 10 P.M., and each works an 8-hour shift. The following table shows the minimum...

Complete on XCEL & show work B) Carl Spackler is the Assistant Groundskeeper at a local country club. He wants to develop a new fertilizer at minimum cost. To do so, he will combine two ingredients,...

Wichita's famous Sethi Restaurant is open 24 hours a day. Servers report for duty at 3 A.M., 7 A.M., 11 A.M., 3 P.M., 7 P.M., or 11 P.M., and each works an 8-hour shift. The following table shows the...

The plane z = 0 separates air (z 0, = ) from a conductor (z 0, = 100 ). The magnetic field in air is given by H = 10a x + 15a y - 3a z A/m Find the magnetic field in conductor and the angle it...

The net income reported on the income statement for the current year was $400,000. Depreciation recorded on store equipment for the year amounted to $16,000. Balances of the current asset and current...

Which of the following is true about an income statement? Multiple Choice 1 : 0 2 : 5 1 It does not include dividends paid. It reports activity for a period of time. All of the other answers are...

Create a C# application named SalesTransactionDemo that declares several SalesTransaction objects and displays their values and their sum. The SalesTransaction class contains the following fields:...