**PLEASE USE A SPREADSHEET TO ANSWER AND SHOW FORMULAS/WORK THROUGHOUT**

**A link to the spredsheet for further study would also help a lot - thanks!**

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. Description Predecessor Task] A Roll out dough None B Place on tray A C Spread tomato sauce B D Spread cheese E Add Meat #1 D F Add Meat #2 D G Add onions D H Shrink wrap E.F.G 1 Pack in box H Total Time = Task Times (seconds) 50 5 25 15 12 10 15 18 15 165 Parta 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