Formulate an algebraic model for the problem. Use LINGO or the Excel Solver to solve this model, with your name and student number included in a comment line. Copy-and-paste the model and solution LINGO files. 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.

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 thirty dowels of length 95 cm, four- teen 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. The objective is to minimize the net cost (the cost of the dowels minus the credit for the recycled wood). You might wish to use Excel to help create the list of patterns needed in part (a)