Please show Excel Calculations

Isabella has studied her current restaurant process & created a precedent chart with the order of task completion & time required except for the oven time. (See Case Pt#3 to type in the oven time chosen by your Crossover Point Analysis.)

Isabella knows her current process is inefficient. She tends to staff up to 8 employees per shift. She is not sure of the pizza output per hour & knows it could vary greatly, therefore she would like to base it on the highest sales month projected for 2022. Generally that is October, where the store is open for 12 hours per day & 20 days in October for a total of 240 hours of available work time.

For the analysis complete the following:

-Determine the available work time in minutes for Oct.

-Go to Case Part#1 & determine the number of pizzas that would be sold in October 2022. Enter this number in the chart.

-Go to Case Part#3 to determine the pizza oven baking time & enter this for Task H in the precedent chart.

-Calculate the remaining data for the Production Process Calculations.

-Create the process flow dragging the circles & setting up the arrows as per Precedent Chart.

- Assign the Work Stations by color coding the tasks.

-Fill in the Work Station Chart (You may or may not need all of the rows provided.)

-Determine the Process Work Station Bottleneck Time, Efficiency, & Total Idle Time

TASK ID	TASK	TIME (Minutes)	PRECEDENT TASK
A	Order Received by Phone or App	6.5	NONE
B	Shape Dough	1	NONE
C	Pre-Brown Dough	2.5	A, B
D	Prepare Toppings	1.5	A
E	Cover Dough with Sauce	0.5	C
F	Add Toppings to Dough	1.25	D, E
G	Add Cheese to Dough	1	F
H	Bake Pizza (Equipment Bake Time)	8	G
I	Retrieve Baked Pie & Slice	1.25	H
J	Final Inspection of Pizza	0.5	I
K	Prepare Box Set Up	2	NONE
L	Package Final Product	2	J, K

INITIAL PRODUCTION PROCESS DATA
CALCULATION OR DATA			UNITS
Available Work Time for Oct.		14400	Minutes
Pizzas Production Goal for month of Oct. 2021		1712	Number of Pizzas (Round to whole number)
				TAKT TIME =		8.41	Minutes to Produce One Pizza (Round 2 decimal places)
	Task Bottleneck Time =	8	MINUTES
Throughput =		28	MINUTES
# Work Stations =		12

FINAL LINE BALANCED PROCESS DATA
Work Station Bottleneck Time =			Minutes
Efficiency =			Percentage
Total Idle Time=			Minutes

Work Station	Assigned Tasks	Total Time	Idle Time/Work Station