show work clearly and use cell referencing plz

2 A B c D F G H K L M N You must do the necessary calculations in the answer cells. Simply providing a number in the answer cell will not receive any credit. When look at the answer cell, I want to see a number, when I click on the cell I want to see the excel formula, for example, if I asked you the sum of cells B5 through D5, this is what I want to see: 1234 2345 3456 7035.0 or 7035,0 Problem 1: Use the information below to complete the assignment 10 VanWerken's motor cycle company makes two motor cycles. The model "E" has a new engine and a low profile. Model " L " is larger, it uses an older engine and is specifically designed to appeal to women. VanWerken's produces the engines for both models at its faclities in Texas. Each model ' E ' engine requires 5 hours of manufacturing time and each model " L " engine requires 3 hours of manufacturing time. The manufacturing plant has 1600 hours of engine manufacturing time avalable for the next production peniod. The motor cyele frame supplier can provide at most, 150EEframes and the model " L " supplier can a maximum of 280 model " L " frames for the next production period. Final assembily and testing fequires 2 hours of each model " E ' and 2.5 hours of each model " L ". A maximum of 1000 hours of assembly and testing time are availoble for the next production period. The company's accounting department projects a profit contibution of $2400 for each model " E " produced and $2100 for each model " L " produced. \begin{tabular}{|l|} \hline 11 \\ 12 \\ \hline 13 \\ 14 \\ \hline 15 \\ 16 \\ 17 \\ 18 \\ 19 \\ \hline \end{tabular} \begin{tabular}{l} 11 \\ 12 \\ 13 \\ 14 \\ \hline 15 \\ 16 \\ 17 \\ 18 \\ 10 \\ 20 \end{tabular} 20 Please be sure to pasie a screen shot of the solver dialog box below, along with your other work A) Develop a complete linear programming formulation for this problem B) Using the "sover' tool in Excel, find the optimal amount of each motor cycle to produce, in order to maximize profits. Be sure to indicate the number of each motor cycle to produce and the focal profits that are expected. Do NOT round off final values of motorcycles to be produced. Do NOT use the integer constraint function in solver. Show all of your work below this line WOTE: Please round off the final values for the optimal solution and value of the objective function to 2 decimal points, e.9. 198.54