Question: Complete the following problems in a single Excel file with each problem on a different sheet in the file. Problem 1 (10 points) EZS



Complete the following problems in a single Excel file with each problem

Complete the following problems in a single Excel file with each problem on a different sheet in the file. Problem 1 (10 points) EZS is a small fast food outlet located in midtown Manhattan and serving mainly the corporate clientele. EZS' main fare is a freshly prepared, customizable line of sandwiches. It is supplemented with an assortment of drinks, light salads, seasonal fruit and snacks. The restaurant is open 10:00AM to 10:00PM, but the peak demand is during lunch hours, 11:30 to 2:00PM. A customer joining the line makes a sandwich selection by consulting the billboard, marks her selection on a customized form, and hands the form to one of several assemblers who produce the sandwich. The customer does not wait for the sandwich to be assembled, but proceeds directly down the line to select additional items onto her tray. Next, the customer proceeds to pay at the cash register. Finally, (after the payment is completed) she collects her prepared sandwich at a designated location. Selecting the sandwich and marking the form takes 45 seconds. Assembling the sandwich requires 90 seconds. Selecting additional items takes 60 seconds. Paying at the cash register requires 40 seconds. Collecting the prepared sandwich requires 20 seconds. The restaurant employs 1 person to assist with selecting and ordering, 2 cash register operators to assist with Select additional Items 60 sec Select & Order 45 sec Prepare Sandwich Pay 40 sec Collect Sandwich 20 sec 90 sec selecting additional items and paying, 6 sandwich assemblers to prepare sandwiches, and one person to help the customer collect the sandwiches. The process map is given below: Build a spreadsheet model to answer the following questions (Make sure your answers are in text boxes independent of the spreadsheet model). a. What is the theoretical flow time of the process? b. What is the capacity of the process? c. During rush hour, demand exceeds capacity and long lines form. Does it make sense to add a sandwich preparer? Why or why not? d. If paying can be reduced to 20 seconds, what is the new theoretical flow time of the process? e. If paying can be reduced to 20 seconds, does your answer to part c change and why or why not?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To solve this problem lets break it down step by step using Excel a Theoretical Flow Time The theoretical flow time is the total time a customer spend... View full answer

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!