please use lingo

the Excel Solver. In Assignments 2 to 6 inclusive, you will be asked only to use either LINGO or the Excel Solver. Based on your experience with Assignment 1, Question 5, do whichever you find easier. If you solve the models in Excel Solver, you will have to write them in standard form, i.e. all variables on the left-hand side, and a number of the right-hand side. If you use LINGO, you are not bound by this restriction. For each question, do the following: (a) Formulate an algebraic model for the problem. Submit this in Word or pdf. (b) Use LINGO or the Excel Solver to solve this model, including your name and student number on the model. If using LINGO, submit files for the model and the solution for each question. If using the Excel Solver, submit one file for all questions, using tabs for the model and the Answer Report (a total of ten tabs.) (c) State the solution in words. Submit this in Word or pdf. When you attempt to solve these models, you might receive a message about the solution being infeasible. While this is a theoretical possibility, it won't happen for any of these questions. It means that a mistake has been made in formulating the model. 4. A lumber store stocks dowels in one standard length of 200 cm. Each dowel costs $26.50. A customer wants the store to cut her at minimal cost thirty dowels of length 95 cm, fourteen dowels of length 63 cm, thirty-five dowels of length 37 cm, and fifty dowels of length 20 cm. She will receive a recycling credit of 5 cents per cm for any wood declared to be "waste". You might wish to use Excel to help create the list of patterns needed in part (a)