Linear programming-production problem

Reference no: EM13176916

LoTech Manufacturing produces four different products. Each product requires material, labor, and machine time. The optimal combination of the four products is limited by the constraints of availability for these three resources. The formulation of the linear programming production problem is:

Maximize Z = 12x1 + 10x2 + 15x3 + 11x4 (objective function for profit)

Subject to the following constraints:

Material: 5x1 + 3x2 + 4x3 + 2x4 = 240 pounds
Machine time: 6x1 + 8x2 + 2x3 + 3x4 = 240 hours
Labor: 2x1 + 3x2 + 3x3 + 2x4 = 180 hours

Nonnegativity: x1, x2, x3, x4 = 0

Where: x1 = quantity of Product 1 produced
x2 = quantity of Product 2 produced
x3 = quantity of Product 3 produced
x4 = quantity of Product 4 produced

Use Excel and Solver to find the optimal solution for the production problem. Click here to download instructions on how to install Solver in Excel.

Include your interpretation of the results by stating:

How many of each product will be produced?
What is the profit for the optimal solution?

Submit the solution for the production problem in an Excel worksheet with proper labeling for columns and all required calculations. Submit your interpretations in a one-

Reference no: EM13176916

Questions Cloud

Define legal-procedural defense of statutes of limitations : Define the legal, procedural defense of statutes of limitations. Why are statutes of limitations a part of criminal law? Do you agree that there should be limits of when a crime can be prosecuted?

Concepts of actus reus and mens rea fit with inchoate offens : Provide your opinion of whether or not criminal liability and punishment for inchoate offenses are "fair" or not. How do the concepts of actus reus and mens rea fit with inchoate offenses?

Distinguish between the terms actus reus and mens rea : Distinguish between the terms actus reus and mens rea; how are they significant in criminal law? Which of the two is more difficult to prove in a trial, beyond a reasonable doubt?

Work should be monitored and rewarded : The methods of determining what aspects of the work should be monitored and rewarded.

Linear programming-production problem : LoTech Manufacturing produces four different products. Each product requires material, labor, and machine time. The optimal combination of the four products is limited by the constraints of availability for these three resources.

Definition of diversity : What is your definition of “diversity” and how must it be considered when hiring individuals for a human service organization?

Britain and the united states between 1783 and 1789 : Regarding trade between Britain and the United States between 1783 and 1789, it is true that:

Considering the acquisition of heavy crude container : A private energy trading company is considering the acquisition of a heavy crude container. This is to handle a variety of stocks that are expected to last for the next 5 years.

Human population-atmospheric pollution-water resources : Describe the specific issue (i.e. water pollution, erosion, etc) and the environmental impacts that it causes. Identify and provide a brief description of at least two different strategies/technologies that have been utilized or being developed to co..

User Account

All Pages