Please show work & formulas in Excel - thanks!

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 Pay 40 sec Select & Order 45 sec Collect Sandwich 20 sec Prepare Sandwich 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