Question: please use excel to solve this problem (a) Formulate an algebraic model for the problem. Submit this in Word or pdf. (b) Use LINGO or


(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. 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)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
