SmartOp is a startup, which processes the customers' digital orders in four operations in a sequence: Operation $1$ to Operation $4.$ Each Operation's capacity rate is shown in the Excel template file Download Excel template file. The owners get some fund to support one and only one Operation's capacity expansion. Hence, they are considering four capacity expansion options corresponding to Operation $1$ to Operation $4$ respectively, with the specific capacity increment $\%$ in each option.

Please help the owners evaluate the four options for their resulted cycle times, capacity rates, takt times, and bottlenecks. Make sure to include the formulas in all the yellow shaded cells and generate the scenario summary to compare the original setting and the four options side by side. The original setting has $0\%$ capacity increment in all the four Operations. Upload your Excel file. Show formulas for each yellow cell, please

Option $1$ Operation $115\%$ Option $2$ Operation $210\%$ Option $3$ Operation $320\%$ Option $4$ Operation $45\%$

Q$1.$ According to your analysis in Q$1,$ how many options improve the cycle time of SmartOp's customer orders?

Q$2.$ According to your analysis, how many options improve the capacity rate of SmartOp's process?

Q$3.$ Which option will you recommend to the owners of SmartOp? Why?

Q$4.$ After the owners of SmartOp takes your advice, which Operation will you suggest them to focus on if they want to make further improvement in the future?