Explore BrainMass
Share

# 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

### Transportation Model (Linear programming model formulation)

Consider the following transportation problem ... Formulate this problem as a linear programming model and solve it by using Solver in Excel. (Please see the attached file).

### Linear Programming Help

Please find the problem statement in the attachment.

### 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

### Southern Air is considering purchase of new aircraft and has set aside \$1.5B dollars for this.

Southern Air is considering purchase of new aircraft and has set aside \$1.5B dollars for this. They have enough pilots to crew 30 new planes and enough maintence personnel to crew 40 new short range planes. Maint for long range planes is 1.67 times that for short range planes Maint for med range planes is 1.33 times th

### 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

Please solve this problem using excel solver.

### 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 or mathematical modeling to determine optimum staffing levels.

To the extent permitted by local law, each Acme Home Improvements store, including AMC, is open from 7 am - 11 pm every day. Acme Mexico City planners have provided the following table, which identifies the minimum number of customer service employees estimated to be needed on the floor of the store each hour of the day:

### 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