please show work with cell referencing

Linear Programming Assignment 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 BS through DS, this is what I want to see: 7035.0 or 7035.0 1234 2345 3456 Problem 1: Use the information below to complete the assignment VariWeiken's motor cyele company makes fwo motor cycles. The model "E" has a new engine and a fow profile. Model ' 2 ' is larger, it uses an oider engine and is specifically designed to appeal to women. VariWerken's produces the engines for both models at its facilities in Texas. Each model " E engine requires 5 hours of manutacturing time and each model " L " engine requires 3 hours of marufacturing time. The manufacturing plant has 1600 hours of engine manufacturing time avalable for the next production perod. The motor cycle frame suppler can provide at most, 150 " E " frames and the model " L " supplier can a maximum of 280 model " L " frames for the next production period. Final assembly and testing requires 2 hours of each model "E' and 2.5 hours of each model " L ". A maximum of 1000 hours of assertbly and testing time are avalable for the next production pecod. The corrpany's accounting department projects a profit contribution of $2400 for each model " E " produced and $2100 for each model "L" produced. 11 12 13 14 A) Develop a complite linear programming formulation for this probiem 15 B) Using the "solver tool in Excel, find the optimal amount of each motor cycle to produce, in oeder to maximize profits. Be sure to indicale the number of each motor cycle to produce and the total profiss that are expected. Do NOT round off fina values of motorycies to be produced. Do NOT use the integer' constraint function in solver. 18 19 Show al of your work below this ine 20 Please be sure to paste a screen shot of the 'solver dalog box below, along with your other work. 21 NOTE: Please pound of the fins values for the optimal solution and value of the objective function to 2 decimal points, e.g. 198.54