Formulate a linear programming model for the below set of problems. For those problems, solve the linear programming model by using the computer. You can use either QM for Windows or Solver (in Excel) to solve these problems.
If using QM for Windows, you can capture the results and a graph in one of two ways:
? By doing a "Print Screen," you capture the screen image. You can now copy directly to Word (or to Paint, and then to Word).
? Or you can save data from QM for Windows as an HTML file. You can only save data one window at a time. Highlight the QM for Windows output window you want to save and select Save As HTML. You can then edit the HTML file in Word to your liking, or you can copy it directly to Word.
? If you use QM for Windows, please include the results screen and the Graph in the Word document you create. Follow the format of the examples that were posted in the Doc Sharing tab. Include the model formulation or a window showing the constraints. Save the resulting file as a Word file.
If using Solver, please submit the Excel file (include the model formulation on the worksheet). If using an Excel document, put one problem per worksheet, label all worksheets and put all problems in one file.
A company produces two products that are processed on two assembly lines. Assembly line 1 has 100 available hours, and assembly line 2 has 42 available hours. Each product requires ...
A company makes fertilizer using two chemicals that provide nitrogen, phosphate and potassium. A pound of ingredient 1 contributes 10 ounces of nitrogen and 6 ounces of phosphate, while a pound of ingredient ...
A drug company produces drug from two ingredients. Each ingredient contains the same three antibiotics, in different proportions. One gram of ingredient 1 contributes 3 units and 1 gram of ingredient 2 contributes ...
A clothier makes coats and slacks. The two resources required are wool cloth and labor. The clothier has 150 square yards of wool and 200 hours of labor available. Each cost requires 3 square yards of wool ...
I am looking for solutions for these four problems using QM for windows or Solver in Excel. If I can get a detailed solution with explantion I will be grateful.
Complete, Neat and Step-by-step Solutions are provided in the attached file.