Answer Question 4 and follow the instructions

(iv) For each question, do the following: (a) Formulate an algebraic model for the problem. If you wish to 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. Submit the algebraic model in the single Word or pdf file. (b) Use LINGO or the Excel Solver to solve this model. Imbed the LINGO model and solution report files, or tabs of the model and Answer Report from the Excel file, into the single Word or pdi submission file. 4. A lumber store stocks dowels in one standard length of 150cm. Each dowel costs \$20. A customer wants the store to cut him at minimal cost twenty dowels of length 67cm, eighty dowels of length 51cm, sixty dowels of length 28cm, and forty dowels of length 15cm. You might wish to use Excel to help create a list of patterns when beginning part (a). Make a formula to be copied for all patterns which will calculate the waste. The pattern must be discarded if this calculated number is negative or if it's greater than the smallest dowel size sought by the customer ( 15cm in this example)