Pando Inc. is a fast food restaurant which offers 4 main types of sandwiches: Pando – classic (C), Pando – premium (P), Pando – exotic (E), and Pando – ultimate (U). Every day, the restaurant operates for 10 hours and it is expecting to sell 500 sandwiches. And from the past data, 30% of the demand is for C, 20% is for P, 45% is for E, and 5% is for U. There are up to five steps in the process of making sandwiches, listed below with activity times. 80% of customers want their sandwich toasted, no matter which sandwich is ordered.

Step

Classic

Premium

Exotic

Ultimate

Prepare bread

.75 minutes

.75 minutes

1.5 minutes

1.5 minutes

Prepare meat

.5 minutes

.8 minutes

1.5 minutes

1.5 minutes

Toast

.5 minutes

.5 minutes

.75 minutes

.75 minutes

Wrap

.5 minutes

.5 minutes

1 minute

.5 minutes

Checkout

.5 minutes

.5 minutes

.5 minutes

.5 minutes

Suppose that there is one worker at each step. Answer the following questions.

If you answer using Excel please show the steps. If you don’t just list the answers.

1. Defining one flow unit as one minute of work, what is the capacity per day for the worker at “Toast” step? Round your answer to the nearest integer. Your answer is . (1 point)

2. Defining one flow unit as one minute of work, what is the demand rate per day for the worker at “Toast” step? Round your answer to the nearest integer. Your answer is . (1 point)

3. The implied utilization rate for the worker at “Toast” step is . Ignore the percentage sign and round your answer to the nearest integer. For example, if your answer is 43.21%, input 43. (1 point)

4. The implied utilization rate for the worker at “prepare bread” step is . Ignore the percentage sign and round your answer to the nearest integer. For example, if your answer is 43.21%, input 43. (1 point)

5. The implied utilization rate for the worker at “prepare meat” step is . Ignore the percentage sign and round your answer to the nearest integer. For example, if your answer is 43.21%, input 43. (1 point)

6. The implied utilization rate for the worker at “Wrap” step is . Ignore the percentage sign and round your answer to the nearest integer. For example, if your answer is 43.21%, input 43. (1 point)

7. Worker at which step is the bottle neck resource? Input 1 for the worker at “prepare bread” step; input 2 for the worker at “prepare meat” step; input 3 for the worker at “toast” step; input 4 for the worker at “wrap” step; and input 5 for the worker at “checkout” step. Your answer is . (1 point)

8. The manager expects a demand increase for all sandwiches due to a promotion. The daily total demand is estimated at 600 sandwiches under this promotion. The demand distribution among the four types of sandwiches also shifts to 25%, 25%, 40%, and 10% for C, P, E, and U sandwiches. Other parameters stay the same. The implied utilization rate for the worker at “Toast” becomes . Ignore the percentage sign and round your answer to the nearest integer. For example, if your answer is 43.21%, input 43. (1 point)

9. Under the new demand distribution, worker at which step is the bottle neck resource? Input 1 for the worker at “prepare bread” step; input 2 for the worker at “prepare meat” step; input 3 for the worker at “toast” step; input 4 for the worker at “wrap” step; and input 5 for the worker at “checkout” step. Your answer is . (1 point)