Please solve in Excel and show which functions were inputted and how to input them

\( 4 \longdiv { \text { A PC company assembles Basic and XP computers. } } \) 5 Data on sales price, cost of components, assembly and testing time required for each is given in the table below 20 Find the optimal quantity that should be produced of each computer model to maximixe profit. 22 Note: When I open the Solver dialog box it should be populated. 23 24 A template is suggested below to develop your model but you are free to use your own. 25 Solution Template \begin{tabular}{|r|r|} \hline 26 & Cost of Assembly \\ \hline 27 & Cost of Testing \\ \hline 28 & \\ \hline 29 & \\ \hline 30 & \\ \hline 31 & \end{tabular}