Purchase Solution

QM for windows or excel format of following problem

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

Solution Summary

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

Purchase this Solution


Free BrainMass Quizzes
Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.