Share
Explore BrainMass

Linear Programming

Excel Solver

Instructions: Each of the following problems is to be solved using Solver in Excel. In order to receive proper and maximum credit, your spreadsheet(s) should show the formulation of your LP or ILP model, your assumptions, and the implementation of your model. Label appropriately. 2. A company needs to hire workers to cover a

Formulate a linear programming model for Julia

Julia is a senior at Tech, and she is investigating different ways to finance her final year at school. She is considering leasing a food booth outside the Tech stadium at home football games. Tech sells out every home game, and Julia knows, from attending the games herself, that everyone eats a lot of food. She has to pay $1

Linear Programming Formulation

Below is a linear programming formulation for a problem with two variables, a and b, and with three constraints, referred to as constraints #1, #2,and #3. Each of the three constraints is a ">=" (greater than or equal to) inequality; the objective is to minimize Z, where the objective function Z is shown in the formulation. M

Linear programming model help

A farmer has a 40-acre farm in Georgia. The farmer is using linear programming to determine how many acres of corn, peanuts, and cotton to plant. Each crop requires labor, fertilizer, and insecticide, and the farmer has formulated the linear programming model below, and solved it in excel solver, with the results and sensitivity

The Feed Company using percentage

I have this solution in excel, however, I would like to see it in QM. I have purchased a similar solution, however I was looking for the formulation and solution in QM. Linear programming #84515 Using Excel, please solve for the following: The Southfork Feed Company makes a feed mix from four ingredients-oats, corn, soy

Decision Variables - Formulate a BIP model.

A University of China professor will be spending a short sabbatical leave at the University of Iceland. She wishes to bring all needed items with her on the airplane. After collecting the professional items that she must have, she finds that airline regulations on space and weight for checked luggage will severely limit the clot

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

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

Economics example of linear programming optimization.

Let's say you own a company that makes bolts that are used on the International Space Station! These bolts have very specific requirements but two of the most important requirements are strength and heat resistance. NASA says that you must have a bolt that has the strength of at least X and a heat resistance of at least Y.

Linear Programming

Problem is attached. Please solve in linear programming model in Excel. Answer questions A & B and show work on how you came to solution. Thank you.

optimal solution for linear programs

Solve graphically for the optimal solution to the following linear program: 1. MIN 16X1 + 12X2 s.t. 8X1 + 4X2 <_ 36 X1 + X2 <_ 7 3X1 + 12X2 >_ 24 X1 + 5X2 >_ 20 X1, X2 >_ 0 2. MIN 18X1 + 12X2 s.t. 8X1 + 4X2 <_ 36 X1 + X2 <_ 7 3X1 + 1

Forecasting

Corporate Triple A Bond interest rates for 12 consecutive months are... a. Develop three- and four-month averages for this time series. Which moving average provides the better forecasts? Explain. b. What is the moving average forecast for the next month? The following data represent 15 quarters of manufacturing capacity ut