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 asked you the sum of cells B5 through DS, this is what I want to see: 123423453456 7035.0or7035.0 Problem 1: Use the information below to complete the assignment VarWerken's motor cycle company makes two motor cyclos. The model 'E" his a new engine and a low proflile. Model "L" is larger, if usos an oldor engine and is spocifically designed to agpeal to women. VanWerken's protuces the engines for both models at its facilities in Texas. Each model " E engne requies 5 hours of manudacturing time and each model " L " engine requires 3 hours of manutacturing time. The manutacturing plant has 1600 hours of engne manutacturing time available for the next production poriod. The motor cycle frame supplier can provide at most, 150 "E' frames and the model " L " supplier can a maximum of 200 model " L " trames for the next production period. Final assembly and testing requires 2 hours of each model " " and 2.5 hours of each model " L ". A maximum of 1000 hours of assembly and testing time are avaliable for the next preduction period. The company's accounting department propocts a profit continbution of $2400 for each model 'E' produced and $2100 for each model "L' produced. in order to maximize profits. Be sure to indicate the mumber of edch motor cycle to produce and the tocal profits that are expected Do NOT round off final values of molorcycles to be produced. Do NoT use the integer constraint function in solver. Show all of your work below this line Pliase be sure to paste a screen shot of the 'solver dialog box below, along wih your other work: NOTE: Please found of the final values for the optimal solution and value of the cojective function to 2 decimal points, 0.9 198.54