Share
Explore BrainMass

Linear Programming

Linear Programming in EXCEL

The Omega pharmaceutical firm has five salespersons, which the firm wants to assign to five sales regions. Given their various previous contacts, the salespersons are able to cover the regions in different amounts of time. The amount of time (days) required by each salesperson to cover each city is shown in the following table

Simplex Method Explained

Please state all your assumptions and show all your work. Define your decision variables clearly. Briefly explain your constraints and objective functions. Define all units of measure (e.g. hours, $, $/hour, etc) Explain what software package you used (e.g. LINDO, LINGO, EXCEL solver, etc). For EXCEL solver, be sure to give a se

Cost and Profit Functions

Please answer questions, listed below and also shown in original format in the attachment; show work and explain in Microsoft Word and Excel how you came to each solution. 1. As part of its planning process, the Sam Manufacturing Company must determine the mix of its products to be manufactured next year. The company produce

ACE's problem/solution

Part a ACE's four plants ship goods to 3 warehouses which in turn ship to 5 retailers The shipping costs per unit are: 4 5 Product Capacity Plant Salt Lake Dallas Cost/unit unit/week 1 LA 30 40 208 200 2 Kcity 25 45 214 300 3 Savannah 45 30 215 300 6 7 8 Wa

integer (linear) programming model problem

Solve the following integer (linear) programming model problem graphically by manual hand-drawn construction of the graph. Minimize 6X + 11Y Subject to 9X + 3Y > 27 7X + 6Y > 42

Linear Programming: Modeling Examples

A publishing house publishes three weekly magazines-daily life, agriculture today, and surf's up. Publication of one issue of each of the magazines requires the following amounts of production time and paper: Production (hr.) Paper (lbs.) Daily Life

All-integer Linear Program

Given the following all-integer linear program: MAX 3x1 + 2x2 such that 3x1 + x2 <= 9 x1 + 3x2 <= 7 -x1 + x2 <= 1 x1, x2 >= 0 and integer a. Solve the problem as a linear program ignoring the integer constraints. Show that the optimal solution to the linear program gives fractional valu

Linear Programming Question

Tots Toys makes a plastic tricycle that is composed of three major components: a handlebar-front wheel-pedal assembly, a seat and frame unit, and rear wheels. The company has orders for 12,000 of these trikes. As indicated in the table below, the company obviously does not have the resources available to manufacture everythi

Operations Research

State all the assumptions and show all the work. Define your decision variables clearly. Briefly explain the constraints and objectives functions and define all unit of measure. Consider the following linear programming problem: Max x + 3y s.t. -x +

Operations Research and Linear Programming

State all the assumptions and show all the work. Define your decision variables clearly. Briefly explain the constraints and objectives functions and define all unit of measure. You have been put in charge of the Davidson oil refinery. The refinery produces gas and heating oil from crude oil. Gas sells for $11 per barrel and

Operations Research - Linear Programming

State all the assumptions and show all the work. Define your decision variables clearly. Briefly explain the constraints and objectives functions and define all unit of measure. During the next three months Airco must meet (on time) the following demands for air conditioners: month 1, 300; month 2, 400; month 3, 500. Air cond

Operation Research Line Programming

State all the assumptions and show all the work. Define your decision variables clearly. Briefly explain the constraints and objectives functions and define all unit of measure. Consider the following LP model: Max Z = x1 + x2 s.t. x1 + 3x2 <=8 x1 + x2 <=4 x1 , x2 =>0 a) So

Linear Programming Type of Analysis

Suppose you are charged with doing a linear programming type of analysis at your job and come to the conclusion that there is no feasible solution to your problem. What do you do now? What are your recommendations to your superior going to be?

Linear Programming Example Problem: Finding the Dual

State the dual of the following linear programming problem. Minimize w = 5y_1 + 8y_2 Subject to: 2y_1 5y_2 ≥ 9 2y_1 + 3y_2 ≥ 11 7y_1 + 2y_2 ≥ 5 With y_1 ≥ o, y_2 ≥ 0. Please see attachment for better format.

Linear Programming: Finding the Optimal Solution Example Problem

Maximize the objective function 2x + 3y subject to the constraints that x + twice y is at most 6; and the sum of 5 times x and 3 times y is at most 15; with both decision variables non-negative. Find the optimal solution using linear programming and the graphical solution procedure. What is the value of the objective functio

Linear programming and sensitivity analysis

1. The binding constraints for this problem are the first and second. Min x1 + 2X2 s.t. x1 + x2> 300 2x1 + x2> 400 2x1 + 5x2> 750 x1, x2 > 0 a. Keeping cf2 fixed at 2, over what range can cf1 vary before there is a change in the optimal solution point? b. Keeping cf1 fixed at

Linear programming

1) Develop an LP model for the problem. 2) Solve the LP model using Solver in excel I have posted problem below: Questions Acme Mexico City purchases two products (Product 1 and Product 2) that it stocks from three different vendors (Vendor A, Vendor B and Vendor C). The suppliers have limited capacity

Linear Programming

A market research firm's three clients each requested that the firm conduct a sample survey. Four available statisticians can be assigned to these three projects; however, all four statisticians are busy, and therefore, each can handle only one client. The following data who the number of hours required for each statistician t

Optimum Gain Linear Programming

A manufacturer of electronic equipment produces 2 types of TVs: Plasma (X) and LCD (Y). In the first X, wins $ 500 and the second and wins $ 400. Both TVs are subjected to two manufacturing processes: Assembly (Assembly) and Test (Testing). Plasma is consumed in the 6 and 3 hours respectively and the LCD using 4 and 10 hours res

Objective Function Linear Programming

16)A manufacturer of electronic equipment produces 2 types of TVs: Plasma (X) and LCD (Y). In the first X, wins $ 500 and the second and wins $ 400. Both TVs are subjected to two manufacturing processes: Assembly (Assembly) and Test (Testing). Plasma is consumed in the 6 and 3 hours respectively and the LCD using 4 and 10 hours

Linear Programming

14)ABC Corporation, produces two types of drinks. For each of them should be made by 3 processes, which are: Distilling, Bottling and Packing. In the drink X is used in each process the next time: 6, 3 and 4 hours respectively. As for the drink and is used in the above processes 6, 6 and 2 hours respectively. The distillation p

Linear Programming: Evaluate the Extreme Point

13) ABC Corporation, produces two types of drinks. For each of them should be made by 3 processes, which are: Distilling, Bottling and Packing. In the drink X is used in each process the next time: 6, 3 and 4 hours respectively. As for the drink and is used in the above processes 6, 6 and 2 hours respectively. The distillation

Linear Programming

12) ABC Corporation, produces two types of drinks. For each of them should be made by 3 processes, which are: Distilling, Bottling and Packing. In the drink X is used in each process the next time: 6, 3 and 4 hours respectively. As for the drink and is used in the above processes 6, 6 and 2 hours respectively. The distillation

Linear Programming

9) ABC Corporation, produces two types of drinks. For each of them should be made by 3 processes, which are: Distilling, Bottling and Packing. In the drink X is used in each process the next time: 6, 3 and 4 hours respectively. As for the drink and is used in the above processes 6, 6 and 2 hours respectively. The distillation p