Question: please solve using lingo (a) Formulate an algebraic model for the problem. Submit this in Word or pdf. (b) Use LINGO or the Excel Solver

please solve using lingo please solve using lingo (a) Formulate an

(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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

please solve using lingo (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...

Its a Decision Modelling course. Is it possible to send me the actual word file and the excel sheet file in my email or here for this answer. thanks If you solve the models in Excel Solver, you will...

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...

3. A company makes robots, mostly for industrial use, but as a novelty item they also make robotic pets. These robotic cats and dogs are not aimed at children, but due to their high cost of...

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...

5. A machine shop makes pipes for the oil and gas industry in lengths of 250 cm and 400 cm. The shorter pipes give a profit of $140 each, while each long pipe gives a profit of $270. They can sell at...

1. A company blends two gasolines from Avalon Energy and Bonavista Petroleum (in- puts) into two commercial products, Premium and Regular gasoline (outputs). For the inputs, the octane ratings, the...

*****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...

Consider a CAPM economy that contains three risky assets with the information set out in the table below. Asset Expected return Standard deviation A B Risk-free A B 10% The correlation matrix is as...

Each of the following items must be considered in preparing a statement of cash flows (indirect method) for Duke Enterprises. (a) During the year, 50,000 shares of preferred stock with a par value of...

Ryan Richards, controller for Grange Retailers, has assembled the following data to assist in the preparation of a cash budget for the third quarter of the year: a. Sales: May (actual) $100,000 June...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...