**PLEASE ANSWER USING A SPREADSHEET AND PROVIDE A LINK TO THE SPREADSHEET FOR FURTHER STUDY**

Problem 4 (24 points). Presto Frozen Pizza Company has determined that it needs an assembly line capable of producing 60 pizzas/hour. The following tasks, task times and precedence relationships for the process are given below. Task Description Predecessor Task Times (seconds) A Roll out dough None 50 B Place on tray A 5 C Spread tomato sauce B 25 D Spread cheese C 15 E Add Meat #1 D 12 F Add Meat #2 D 10 G Add onions D 15 H Shrink wrap E,F,G 18 Pack in box H 15 Total Time = 165 H Part a a. What is the takt (cycle) time for the current level of forecasted demand? b. What is the theoretical minimum number of workstations (do not round)? c. Use a table (like the one used in the homework) to assign the tasks to workstations using the "longest task time rule." Part b Answer the following questions again, but now assume a customer demand of 90 pizzas/hour. a. What is the takt (cycle) time for the current level of forecasted demand? b. What is the theoretical minimum number of workstations (do not round)? c. Use a table (like the one used in the homework) to assign the tasks to workstations using the "longest task time rule.&quot