Question

In: Statistics and Probability

1. Consider an LP where you have to determine how much/many of each product to manufacture;...

1. Consider an LP where you have to determine how much/many of each product to manufacture; there in all, TWO products made from three ingredients. The ingredient usage matrix is as follows. Ingredint1 ingredint2 ingredient3 Product1 1 5 2.5 Product2 4 3 3 Prices of products 1, and 2 are respectively, $65, $55 per unit. Prices of ingredients are respectively, $5, $2 and $4 per unit. You have to formulate an LP to maximize net profit. Product 1 cannot exceed 100 units; ingredient 2 cannot exceed 80 units in consumption.

(a) Define variables (10 points) (You will use these variables for (b)-(d))

(b) Write the objective function. (15)

(c) Write the constraint on the amount of product 1. (10)

(d) Write the constraint ensuring that you do not plan on using more of ingredient 2 than you have available.

Solutions

Expert Solution

a)

Decision variable => xi = number of units to produce for product i where i ={1,2}

b)
Per unit profit for product 1 => 65-1*5-5*2-2.5*4 = 40
Per unit profit for product 2 => 55-4*5-3*2-3*4 = 17

Objective function is to maximize profit = max 40x1+17x2

c)

Constraint for product 1 => x1 <= 100
d) Constraint for ingredient 2 => 5x1+3x2 <= 80

Solving in solver we get,

X1 = 16, X2 = 0 and maximized profit = 640

Solver screenshot

Solver formula

Solver window


Related Solutions

You manufacture two products, A and B, each of which you sell for $1 profit. Product...
You manufacture two products, A and B, each of which you sell for $1 profit. Product A requires 5 blobs and 3 globs, and product B requires 3 blobs and 5 globs. Your supplier has 120 blobs and 120 globs available. Use the Excel Solver (or graphical analysis) to answer the following questions. 9. If the profit on B increases to $2, can you increase profit by trading 30 blobs for 30 globs? 10. As the profit on B changes...
You manufacture two products, A and B, each of which you sell for $1 profit. Product...
You manufacture two products, A and B, each of which you sell for $1 profit. Product A requires 5 blobs and 3 globs, and product B requires 3 blobs and 5 globs. Your supplier has 120 blobs and 120 globs available. Use the Excel Solver (or graphical analysis) to answer the following questions. 17. Can you obtain more blobs and globs for product B by producing negative quantities of product A?
1. Consider a study where we use a person's education level to to predict how much...
1. Consider a study where we use a person's education level to to predict how much money they have invested. What type of variable is the dependent variable? Binary Discrete Continuous Qualitative 2. Consider an experiment where we use the amount of sugar in cereal to predict what shelf the cereal is placed on in the grocery store. What type of variable is the independent variable? A. Discrete B. Continuous C. Categorical D. Qualitative 3. You want to determine whether...
To determine how much money you have to invest, add up the investment for the 4...
To determine how much money you have to invest, add up the investment for the 4 projects. Multiple this total by 80% to get how much money your company has to spend. Choose the best combination of projects for the company to invest in. Show one break even analysis.   Total Investment = $198420.19 Projects: #1 Invest $60000 in a 3D Printer Training and installation $10000 Revenue per year $18000 Cost per year $3000 Market Value year 11 $30000 #2 Invest...
1. You are trying to determine how much you need in order to retire comfortably. You...
1. You are trying to determine how much you need in order to retire comfortably. You would like a monthly retirement income of $20,000 and anticipate living for 30 years in retirement. The first retirement check will come at the end of your first month of retirement. You have already saved $40,000. You expect to earn 6% on your investments. You have 40 years until you retire. How much must you save at the end of each month between now...
Monkey's Fist is trying to determine where to source their product. In the past, they have...
Monkey's Fist is trying to determine where to source their product. In the past, they have sourced solely domestically, but they have sufficiently grown to look at international suppliers. Next month's expected demand is 12,000 units. There are three suppliers to choose from, one domestic, the other two offshore. The table below contains all relevant cost data. Note that both international shipping and inland freight costs are a flat fee for a shipment of up to 12,000 units of demand—whether...
a) Describe how you could determine quantitate (determine how many) E. coli cells have been transformed?
  a) Describe how you could determine quantitate (determine how many) E. coli cells have been transformed? b) Briefly outline your experiment. You will need a control, or standard, to analyze your experimental results, make sure to indicate this in your answer – explain what the control/standard is and how you use it.
Stoichiometry question:  If you have a reaction that gives a 75% yield, how much product would you...
Stoichiometry question:  If you have a reaction that gives a 75% yield, how much product would you get if you add (for example:  3 g of vanillin + 3 mL of 10.6M acetic anhydride). First, determine which is the limiting reactant. Determine the molecular weight of the product. Determine how much product can be produced theoretically. Then, determine the actual yield when the reaction has a 75% yield.
how to determine if you have successfully synthesized the desired product in an sn2 reaction
how to determine if you have successfully synthesized the desired product in an sn2 reaction
1. Ann and Bill have formed a business partnership. They each have to decide how much...
1. Ann and Bill have formed a business partnership. They each have to decide how much effort to put into the business. Let x denote the amount of effort Ann puts into the business and let y denote the amount of effort Bill puts into the partnership. The profit of the business partnership depends on the amount of effort Ann and Bill put into the business. It is given by 2x + 2y + 0.5xy hundred thousand dollars. Ann and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT