Purchase Solution

Operations Research

Not what you're looking for?

Ask Custom Question

The Eastside Manufacturing Company produces four different aircraft components from fabricated sheet metal for several major aircraft companies. The manufacturing process consists of four operations - stamping, assembly, finishing, and packaging. The processing time per unit for each of the operations and total available hours per year to produce these components are given below.

(see chart in attached file)

The sheet metal required for each component, the estimated annual demand, and the profit contribution provided by each component, are as follows:

(see chart in attached file)

The company has 15,000 square feet of fabricated metal delivered each month. The company has the following prioritized production goals for these components:
? Avoid the use of overtime given the low profit margins.
? Meet all component demand.
? Achieve an annual profit contribution of at least $700,000
? Avoid additional material orders - pricing is dependent upon annual contracts with fixed amounts and delivery schedules

a. Formulate a linear programming model to determine the quantity of each component to produce to achieve the company's goals.

b. Determine the solution that will best achieve the company's goals in component production, including the quantity of each component produced, the annual profit contribution attained, and the levels of goal achievement.

c. Determine how the solution would be affected if the first two goal priorities were reversed

Attachments
Purchase this Solution

Solution Summary

Excel file contains formulation and optimal solution of a linear programming model to determine the quantity of each component to produce to achieve the company's goals.

Purchase this Solution


Free BrainMass Quizzes
Probability Quiz

Some questions on probability

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.