Please show on excel

You need the weekly rated capacity \& "effective number of hours per day per machine" for the Cap-load profiles. Number of Identical Department Work Center Machines/Workers Hours per Shift Shifts/Day Days/Week Utilization Efficiency Weekly Rate Capacity Standard daily hours per machine Available Hours Weekly Rated Capacity = \# of resources x Hours per Shift x Shifts / Day x Days / Week x Utilization x Efficiency Weekly Rated Capacity = Available Hours x Utilization x Efficiency Make capacity-load charts for Work Centers A, B, C, D, E and F based on the work center information here as well as the orders on the next tab. Note: the relevant time range for the work centers are: \begin{tabular}{|l|l|} \hline A & 115135 \\ \hlineB & 125145 \\ \hline C & 130150 \\ \hline D & 140155 \\ \hline E & 150165 \\ \hline F & 160175 \end{tabular}