1. Business
  2. Operations Management
  3. please use excel and solver addon to solve following transportation...

Question: please use excel and solver addon to solve following transportation...

Question details

PLEASE USE EXCEL AND SOLVER ADD-ON TO SOLVE FOLLOWING TRANSPORTATION LP PROBLEM. PLEASE SHOW STEP-BY-STEP INSTRUCTIONS, AND INCLUDE SCREEN SHOT OF THE SOLVER ANSWER REPORT. THANK YOU.

A famous fast-food restaurant is open 24 hours a day. Waiters and busboys report for duty at 3 AM, 7 AM, 11 AM, 3 PM, 7 PM, or 11 PM, and each works an eight-hour shift. The following table illustrates the minimum number of workers needed during the six periods into which the day is divided. The restaurant’s scheduling problem is to determine how many waiters and busboys should report for work at the start of each time period in order to minimize the total staff required for one day’s operation. (Hint: Let xi equal the number of waiters and busboys beginning work in time period i, where i = 1, 2, 3, 4, 5, 6)

Period

Time

Number of waiters
and Busboys required

1

3 AM - 7 AM

3

2

7 AM - 11 AM

12

3

11 AM - 3 PM

16

4

3 PM - 7 PM

9

5

7 PM - 11 PM

11

6

11 PM 3 AM

4

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution