Excel File Edit View Insert Format Tools Data Window Help a 2 Mon Mar 21 12:29 PM ... AutoSave OFF ASP UL LP-2021-Fall Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments 9 Insert Y Y Y 87-0- O Delete Z Sort & Filter Find & Select Sensitivity Format Analyze Data N N O P Q R R S 7035.0 Arial 12 APA == 9. Wrap Text General Paste BTU CA = == + + Merge & Center $ % Conditional Format Cell Formatting as Table Styles AZ XVfx A B D E F G H 1 J K L M 1 Linear Programming Assignment 2 3 You must do the necessary calculations in the answer cells. Simply providing a number in the answer cell will not receive any credit. 4 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, 5 if I asked you the sum of cells B5 through D5, this is what I want to see: or 7035.0 6 1234 2345 3456 7 8 Problem 1: Use the information below to complete the assignment 9 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 he engines for both models at its facilities in Texas. Each model "E' engine requires 5 hours of manufacturing time und each model "L" engine requires 3 hours of manufacturing time. The manufacturing plant has 1800 hours of engine nariufacturing time available for the next production period. The motor cycle frarne supplier can provide at most, 150 E" fraries and the model "L" supplier can a maximum of 280 model "L" frames for the next production period. Final 1ssembly and testing requires 2 hours of each model "E" and 2.5 hours of each model "L". A maximum of 1000 hours f assembly and testing time are available for the next production period. The company's accounting department projects a profit contribution of $2400 for each model 'E' produced and $2100 for each model "L' produced. points points 11 Rubric possible earned 12 objective function 10 13 constraints 50 14 Develop a complete lincar prograrrirning formulation for this problem solution 40 15 3) Using the "solver tool in Excel, find the optimal amount of each motor cycle to produce, total 100 0 16 in order to maximize profits. Be sure to indicate the number of each motorcycle to produce and the total profits that are expected. 17 Do NOT round off final values of motorcycles to be produced. Do NOT use the 'integer' constraint function in solver 18 19 Show all of your work below this line 20 f you use "Solver", please be sure to paste a screen shot of the 'solver' dialog box below, along with your other work. 21 NOTE: Please round off the final values for the optimal solution and value of the objective function to 2 decimal points, e.g. 198.54 22 Sheet1 Ready + 130% 2. What is your subject? tv ISCI mp. N ? a