$1-$ Conduct capacity and utilization analysis and provide your own interpretation of Morrison$$s production capacity utilization.

Using the data provided to you in the spreadsheet and filling the missing information in the yellow$-$colored cells will help you answer the following specific capacity questions: $(30$ points$)$

$1.$a$)$ Based on overall capacity utilization, do you think they currently have a shortage in their production capacity?

$1.$b$)$ What is the utilization rate for each product type?

$1.$c$)$ If we separated the products based on standard and customized, what is the capacity utilization for each?

$1.$d$)$ Based on your analysis of the monthly capacity utilization rates, do you see fluctuations of under or over utilization? If you observed fluctuations, what do you think is causing it$?$

$1.$e$)$ Based on their compounded annual growth $($CAGR$),$ do they have enough capacity for the future?