Share
Explore BrainMass

Linear Programming

Linear Programming

The Pittsburg Chemical Company of Akron, Ohio, produces a variety of products within its four divisions for agricultural and industrial customers. Division II will produce only two products this week for sale to wholesale distributors and all production will be sold. Product 1 yields a contribution margin (contribution to prof

Linear programming model on excel is assessed.

The Bluegrass Distillery produces custom blended whiskey. A particular blend consists of rye and bourbon whiskey. The company has received an order for a minimum of 400 gallons of the custom blend. The customer specified that the order must contain at least 40% rye and not more than 250 gallons of bourbon. The customer also spec

Linear programming: Productions costs, Inventory, Demand for trucks and cars

See attached file for proper format of tables. Formulate the problem described here as a linear programming model. Do not use Solver to find an optimal solution. You can use WORD to type your answer and print it. You are planning production of trucks and cars in a plant over next two months (M1 and M2). Use X1 and X2 t

Quantitative Methods Optimal Solution a-j

Quality Air conditioning manufactures three hoe air conditioners: an economy model, a standard model, and a deluxe model. The profits per unit are $63, $95, and $135, respectively. The production requirements per unit are as follows: Number of Fans Number of Cooling Coils Manufacturing Time Economy 1

Optimal Work Flow

Please help with the following problem. Activity Immediate Predecessor Time A - 4 B - 3 C A 2 D B 7 E

corner point method

Consider the following linear program. Maximize Profit = 20X + 8Y Subject to: X + Y < 12 Constraint #1 X + 3Y < 27 Constraint #2 4X + 2Y < 40 Constraint #3 X, Y > 0

Setting up a Linear Program

** Please see the attached file for the complete problem description ** National Insurance Associates carries an investment portfolio of a variety of stocks, bonds, and other investment alternatives. Currently $200,000 of funds from a new client are available and must be used for new investment opportunities. The four stoc

Decision variables and linear program

1. Finer Furniture produces three types of furniture - tables, chairs, and bookcases. The production of each of these involves both a carpentry process and a finishing process. The time required in each of these as well as lumber requirements in each product are given below: Table Chair Bookcase Amount available Lumber

average cost of running for a congressional seat

9. To determine the average cost of running for a congressional seat, a random sample of 50 politicians are chosen and their records are examined. The cost figures of the sample show a mean of $125,000 with a standard deviation of $32,000. Find the 90% confidence interval estimate for the average cost of running for office.

Theory of Linear Programming

See the attached file. Sugarco can manufacture three types of candy bar. Each candy bar consists totally of sugar and chocolate. The compositions of each type of candy bar and the profit earned for each candy bar are shown in the following table. Bar Amount of Sugar (Ounces) Amount of Chocolate (Ounces) Price (Cents) 1

Linear Programming Model

A healthcare system is investigating various ways of staffing a new clinic with primary care providers. The facility can hire physicians, physician assistants, and nurse practitioners. Fractional individuals (Full Time Equivalent or FTE hours) are acceptable. The amount of money the facility will spend on salaries each year d

Linear Program Question

A linear program has the objective of maximizing profit = 12X + 8Y. The maximum profit is $8,000. Using a computer we find the upper bound for profit on X is 20 and the lower bound is 9. Discuss the changes to the optimal solution (the values of the variables and the profit) that would occur if the profit on X were increased to

Discuss linear programming.

Claims company processes insurance claims, their perm operators can process 16 claims/day and temp process 12/day and the average for the company is at least 450/day. They want to limit claims error to 25 per day total, and the perm generate .5 errors/day and temp generate 1.4 error per day. The perm operators are paid $465/da

Is the given Simplex Tableau in final form?

determine whether the given simplex tableau is in final form. if so,find the solution to the associated regular linear programming problem. if not, find the pivot element to be used in the next ileration of the simplex method. x y z u v w P constant 1/2 0 1/4 1 -1/4 0 0 19/2 1/2 1

Quantative methods for business are examined.

Innis Investments manages funds for a number of companies and wealthy clients. The investment strategy is tailored to each clientâ??s needs. For a new client, Innis has been authorized to invest up to $1.2 million in two investment funds: a stock fund and a money market fund. Each unit of the stock fund costs $50 and provid

Linear Programming - Max Cover

** Please see the attached file for the table ** Linear Programming - Max Cover DixieNet is an Internet service provider for residential customers in a southern state. The company is small now but plans to expand. Its first major goal is to establish a set of hubs throughout the state so that all residents of the state can

variables and constraints in this problem

Edmonds Paper Products manufactures a variety of products for commercial applications. In one of its processes, rolls of 100 inch wide paper are cut into smaller-width rolls of the same length. Orders for different width rolls are received at various times each week. Current economic conditions have forced Edmonds to abandon the

Linear programming using excel solver

The "Mill" produces five different fabrics. Each fabric can be woven on one or more of the mill's 38 looms. The sales department has forecast demand for the next month. The demand data are shown in Table 1.0, along with data on the selling price per yard, variable cost per yard, and purchase price per yard. The mill operates

decision variables, objective function, and all the constraints

A woman wants to set up a trust fund for her two children using $200,000. The trust fund has three investment options: a bond fund, a stock fund, and treasury bills fund. The projected returns over the life of the investments are 6% for the bond fund, 10% for the stock fund, and 8% for the treasury bills fund. She wants to inves

Linear Programming - Max Flow

The Kodiak Oil Company owns a pipeline network that is used to convey oil from its source (Node 1) to several storage locations. The network flow is shown on the attachment. Due to varying pipe sizes, the flow capacities vary (shown below in â??000s of gallons per hour). By selectively opening and closing sections of the pipeli

Linear programming problem using excel solver

Food Max The Food Max grocery store sells three brands of milk in half-gallon cartonsâ?"its own brand, a local dairy brand, and a national brand. The profit from its own brand is $0,97 per carton, the profit from the local dairy brand is $0,83 per carton, and the profit from the national brand is $0,69 carton. The total refr

Linear programming model

Formulate a linear programming model for this problem. As a result of a recently passed bill, a congressman's district has been allocated $4 million for programs and projects. It is up to the congressman to decide how to distribute the money. The congressman has decided to allocate the money to four ongoing programs because

Formulate a Linear Programming Model: TV Commercials

Please help with this solution An advertising campaign for a new breakfast bar will be conducted in Baltimore area and may use TV commercials, radio commercials, and newspaper commercials. Information about the three media (for each commercial) is shown below. Medium Cost Consumers Reached

Linear Programming for a Company

We are given the following linear programming problem: Mallory furniture buys 2 products for resale: big shelves (B) and medium shelves (M). Each big shelf costs $500 and requires 100 cubic feet of storage space, and each medium shelf costs $300 and requires 90 cubic feet of storage space. The company has $75000 to invest in

Linear Programming

1. A company must meet on time the following demands: quarter 1, 3000 units; quarter 2, 2000 units; quarter 3, 4000 units. Each quarter, up to 2700 units can be produced with regular-time labor, at a cost of $40 per unit. During each quarter, an unlimited number of units can be made with overtime labor, at a cost of $60 per un

Calculations with integer variables

During each four hour period, the Okinawa police force requires the following number of on-duty police officers: eight from midnight to 4 am; seven from 4 am to 8 am; six from 8 am to noon; six from noon to 4 pm; five from 4 pm to 8 pm; and four from 8 pm to midnight. Each police officer works two consecutive four-hour shifts.

Linear programming in excel 2007

Here is the problem: The offensive coordinator for the Chicago Bears football team is preparing a game plan for the upcoming game against the Green Bay Packers. A review of game tapes from previous Bears-Packers games provides data on the yardage gained for run plays and pass plays. Data show that when the Bears run against t