Explore BrainMass

Linear Programming

Linear Program for Optimal Choice

Cranberries can be harvested using either a "wet" method or a "dry" method. Dry harvested cranberries can be sold at a premium, while wet harvested cranberries are used mainly for cranberry juice and bring in less revenue. Fresh Made Cranberry cooperative must decide how much of its cranberry crop should be harvested wet and how

Linear Programming: Examining an Oil Company

Linear Programming Question: A Southern Oil Company produces two grades of gasoline; Regular and Premium. The profit contributions are $0.30 per gallon for regular gasoline and $0.50 per gallon for premium gasoline. Each gallon of regular gasoline contains 0.3 gallons of grade A crude oil and each gallon of premium gasoline con

Calculating Budget Allocation

Problem: The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year's program. Advertising alternatives include television, radio, and newspaper. Audience estimates, costs, and maximum media usage limitations are as shown: (please refer

Optimizing Susan Wong's Personal Budget in Excel.

Please look at the attached document for problem details and solution. I need help with formulating the Objective function and constraints for it. After Susan Wong graduated from State University with a degree in Operations Research, she went to work for a computer systems development firm in the Washington, D.C., area. As a

Using Corner Point Method

1. Solve the following linear programming problem using the corner point method: Maximize 3 X + 5Y Subject to: 4X + 4Y 48 1X + 2Y 20 Y 2 X, Y 0 2. The Fido Dog Food Company wishes to introduce a new brand of dog biscuits (composed of chicken and liver-flavored biscuits) that

Linear Programming Formulation: Classical Business Problem

See the attached file. Imagine that you are hired as a supply chain expert to develop a linear programming formulation that is a mathematical representation (or estimate) of a classic business challenge for a large company that manufactures products that are sold directly to its customers. Through this exam exercise, you will

Linear Programming Model: McDonald and Thomas Advertising Agency

McDonald and Thomas Advertising Agency has been hired to put together an advertising plan for the Healthy Heart Charity Banquet. The advertising media under consideration are listed in the table below: Medium Cost Per Use Effective Audience Reached Maximum Number of times Available Outdoor $500

Introduction to Management Problems

Problem 1 A graphical representation of a linear program is shown in the attachment. The shaded area represents the feasible region, and the dashed line in the middle is the slope of the objective function. a) If this is maximization, which extreme point is the optimal solution? Explain your answer. b) If this is a minimiz

Creating a Linear Programming Model

Paperbank is starting a new credit card business operation during the next three months (Jan, Feb, and March). It must decide how many credit cards to issue each month. Two kinds of cards will be issued: regular and gold. The profit will be $50 per month for gold cards, and $20 per month for regular cards. In each month, 5%

Linear Programming Exercises

Please help me out with these three problems. Please note that these problems need to be completed manually. 7-14 The Electrocomp 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

Linear Programming in Excel/Solver

I'm looking for help using Solver to set up and solve the problem below. Please make sure to embed the formulation to the Linear Programming problem within the Excel solution. In addition to the typical supply and demand constraints that you need to include, please make sure to also account for the constraints which will ensure

Integer programning problem for Trapeze Investments

Trapeze Investments is a venture capital firm that is currently evaluating six different investment opportunities. There is not sufficient capital to invest in all of these, but more than one will be selected. A 0-1 integer programming model is planned to help determine which of the six opportunities to choose. Variables X?, X?

Widgets and Gadgets Linear Programming

Can you help with the following: PDQ Manufacturing Company produces two products, widgets and gadgets. To produce each widget and gadget requires several basic machining operations. PDQ has five different machining centers, and some of the required machining operations can be performed at more than one of the centers. Consequ

Hawaii Sugar Company Linear Programming Problem

I need some assistance with the following problem: Hawaii Sugar Company produces brown sugar, processed (white) sugar, powdered sugar and molasses from sugar cane syrup. The company purchases 4000 tons of syrup weekly and is contracted to deliver at least 25 tons weekly of each type of sugar. The production process starts by


TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. The most common quantitative causal model is regression analysis.

Linear Programming

A small shop located in Utica sells a variety of dried fruits and nuts. The shop caters to travelers of all types; it sells one-pound boxes of individual items, such as dried bananas, as well as two kinds of one-pound boxes of mixed fruits and nuts, called "Trail Mix" and "Subway Mix". Because of the health inspection issues,

Managerial Business

A farmer's family is making plans for the year's planting. Its members are considering planting corn, tomatoes, potatoes, and strawberries. They have 50 acres to plant on. The aim is to determine what it costs to plant an acre of each crop, computing the yield in bushels, forecasting the revenue for a bushel of each crop, and ch

Linear Problem Model Question

A production manager is faced with the question of how to allocate the manufacturing of a microwave oven between his own company and a subcontractor, because neither firm can handle the demand alone. Fabrication costs are $10 per unit within the company and $20 per unit from the subcontractor; assembly costs are $8 per unit

Solver application for linear programming

Problem 8-4. (Animal feed mix problem) The Battery Park Stable feeds and houses the horses used to pull tourist-filled carriages through the streets of Charleston's historic waterfront area. The stable owner, an ex-racehorse trainer, recognizes the need to set a nutritional diet for the horses in his care. At the same time, he w

Linear Programming Model: Example Problem

A company wants to offer their employees a three-day training program on team building and a two-day program on problem solving. They have requested at least 8 training sessions on team building and at least 10 training sessions on problem solving. Furthermore, the total number of training sessions offered must be 25. The tra

Controlling Inventory

Lila Battle has determined that the annual demand for number 6 screws is 100,000 screws. Lila, who works in her brother's hardware store, is in charge of purchasing. She estimates that it costs $10 every time an order is placed. This cost includes her wages, the cost of the forms used in placing the order, and so on. Furthermor

Linear programming in an Excel Solver

Need tutorial assistance involving Excel Solver. The city of Spring View is taking bids from six bus companies on the eight routes that must be driven in the surround school district. Each company enters a bid on how much it will charge to drive selected routes, although not all companies bit on all routes. The data are conta

Use exponential smoothing.

The following table lists the worldwide shipments of personal computers (in thousands) according to Dataquest. Year Shipments (in thousands) 1990 23,738 1991 26,966 1992 32,411 1993 38,851 1994 47,894 1995 60,171 1996 71,065 1997 82,400 1998 97,321 (a) Use exponential smoothing to determine the forecast of shipment

Non-linear scalar equation(Matlab only)

All the roots of the scalar equation x-4sin(2x)-3=0, are to be determined with at least 10 accurate digits, (n accurate digits is equivalent to a relative error smaller than 0.5 x 10^-n) 1) Using Matlab, plot f(x)=x-4sin(2x)-3. All the zero crossings should be in the plot. How many are there? 2) Write a program

Linear Programming: Inequalities

Question 2 A linear programming problem may have more than one set of solutions. Answer True False Question 3 In minimization LP problems the feasible region is always below the resource constraints. Answer True False Question 19 Consider the following minimization problem: Min z = x1 + 2x2 s.t.

optimum solutions in a linear programming

2. A company produces two products that are processed on two assembly lines. Assembly line 1 has 100 available hours, and assembly line 2 has 42 available hours. Each product requires 10 hours of processing time on line 1, while on line 2 products 1 requires 7 hours and product 2 requires 3 hours. The profit for product 1 is

Minimum sum of abssolute values & Min max of abssolute values

Hi, I need help with the following problem linear programming question that asks for two linear programming solutions for a timer series that Min sum of abs values & Min max of abs values. I have attached the detailed questions in the attached Word document. I have already solved question 1, which is attached in an Excel f

Use LP relaxation to solve Mix Integer programming problem

Consider the following all-integer linear program: Max 2x1+3x2 s.t. 4x1+9x2<36 7x1+5x2<35 1x1+2x2<10 X1,x2>0 and x1 integer a. Graph the constraints for this problem. Indicate on your graph all feasible mixed-integer solutions. b. Find the optimal solution to the LP Relaxation. Round the value of x1 down

Linear Programming

Missouri Mineral Products (MMP) purchases two unprocessed ores from Bolivia Mining, which it uses in the production of various compounds. Its current needs are for 800 pounds copper, 600 pounds of zinc, and 500 pounds of iron. The amount of each mineral found in each 100 pounds of the unprocessed ores and MMP's cost per 100 poun