DSC 4100 Ashford University Linear Programming Production Project

User Generated


Business Finance

dsc 4100

ashford university



The UVI Corporation manufactures two electrical products: air conditioners and large fans. The assembly process for each is similar in that both require a certain amount of wiring and drilling. Each air conditioner takes 3 hours of wiring and 2 hours of drilling. Each fan must go through 2 hours of wiring and 1 hour of drilling. During the next production period, 240 hours of wiring time are available, and up to 140 hours of drilling time may be used. Each air conditioner sold yields a profit of $25. Each fan assembled may be sold for a $15 profit.

Using Excel QM, formulate and solve this LP production mix situation to find the best combination of air conditioners and fans that yields the highest profit. Use the corner point graphical approach.

Project Content:

The following must be contained in your project:

  • An introductory paragraph, describing the mathematical topic used in working with the project. Indicate the outcome you are trying to optimize.
  • Identify variables and quantities it represents
  • Create a table with relationships that involve the variables identified
  • Provide constraints and label the objective function
  • Determine and meet the objective and provide calculated evidence
  • A two-paragraph reflective essay that describes
  • Your experience with this project.
  • Your recommendation to management, considering real-world implications and parallel considerations to the US industry.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached. Please let me know if you have any questions or need revisions.



Linear Programming
Institutional Affiliation
Student's Name



Linear programming is a modeling method used to minimize or maximize a linear
objective function that is subjected to a variety of constraints. The objective function in linear
programming defines the quantities on which the optimization function should be applied and
the goal or objective intended to be attained by linear programming. The optimizable
amounts in linear programming are referred to as decision variables (Vanderbei, 2015).
Typically, the goal in management is to minimize costs or maximize yields. This project's
objective was to determine which product mix would yield the highest profit for UVI
corporation. Thus, the linear programming optimization function entailed maximizing
quantities of air conditioners and fans subject to the constraint of wiring and drilling capacity
in hours.
Identifying project variables and the relationships they present.
Two variables Y1 and Y2, were considered in the project. Variable Y1 represented
the number of air conditioners that can be manufactured within less than or equal to 240
hours of wiring and 140 hours of drilling. On the other hand, variable Y2 represented the
number of fans that can be manufactured within less than or equal to 240 hours of wiring and
140 hours of drilling. The factors relating to the variables that were under consideration in the
project included the number of hours used for ...

Really helpful material, saved me a great deal of time.


Similar Content

Related Tags