Explore BrainMass
Share

# QM for windows or excel format of following problem

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

The Westfall Company has a contract to produce 10,000 garden hoses for a large discount chain. Westfall has four different machines that can produce this kind of hose. Because these machines are from different manufacturers and use differing technologies, their specifications are not the same.

Machine Fixed Cost 2 Set Up Production Run Variable Cost p/h Capacity
1 750 1.25 6000
2 500 1.50 7500
3 1000 1.00 4000
4 300 2.00 5000

a. This problem requires two different kinds of decision variables. Clearly define each kind.
b. The company wants to minimize total cost. Give the objective function.
c. Give the constraints for the problem.
d. Write a constraint to ensure that if machine 4 is used, machine 1 cannot be.

I need step by step guidance on how to set up this problem in QM for windows or in excel please.

#### Solution Summary

Each variable for the problem is defined. This allows for the company to minimize the total cost for the function.

\$2.19

## Solving Linear Programming using QM for windows or Solver in Excel

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.

Problem 1
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 ...
Problem 2
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 ...
Problem 3
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 ...
Problem 4
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.

View Full Posting Details