Question

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.

Starting with the original scenario, where A and B each make $1 profit, your supplier has up to 120 blobs and 120 globs available, but you can only store 200 total blobs and globs:

13. What is the most profit you can make?

14. What solution(s) produce maximum profit? What is the minimum number of each A and B that you must produce to achieve this profit?

15. Would you pay up to $5 for additional storage space for 40 blobs and globs?

16. If the profit on B increases to $2, is your optimal solution constrained by storage space?

17. Can you obtain more blobs and globs for product B by producing negative quantities of product A?

Homework Answers

Answer #1

If the company produce X units of A and Y units of B and each one yields a profit of 1

Objective function that maximises the profit is

Max ( X+Y)

such that

5X+3Y<=120 ( constraints related to blobs)

3X+5Y<=120 ( constraints relatd to glob)

Total of blobs / globs stored can be less than or equal to 200, which means

5X+3Y+3X+5Y<=200
X+Y<=25

The graph below shows the equation

The points of optimality are ( 0,24)(24,0) (2.5, 22.5) and (22.5,2.5)

Since both parts yield the same profit, the value of objective function will be the same at all four points ( It is not possible to make a fraction of item, hence the quantity made will be (22,2) or (2,22)

The company should make either 2X and 22Y or 2Y and 22X. The profitability will be same.

(iii) If the storage space increases to 240, the equation will be

8X+8Y<=240

X+Y<=30

Now, the points of intersection will be ( 15,15) and the new graph will be

The new points of optimality will be (0,24)(24,0) and (15.15)

Max profit will be at (15,15) which is

15+15=30

Since the profit increases by 6 with an investment of 5, the offer should be accpeted.

If the profit on B increases by 2 , the new objectie function will be

X+2Y

Value of OF

at (24,0) = 24

at(0,24)=48

at(15,15)= 15+30=45

The optimal solution is not constrained by the space now.

Note: As per policies, I can answer first 4 parts of a question. Inconvenience is regretted.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A company manufactures x units of Product A and y units of Product B, on two...
A company manufactures x units of Product A and y units of Product B, on two machines, I and II. It has been determined that the company will realize a profit of $4/unit of Product A and a profit of $3/unit of Product B. To manufacture a unit of Product A requires 6 min on Machine I and 5 min on Machine II. To manufacture a unit of Product B requires 9 min on Machine I and 4 min on...
A company manufactures two products, A and B, on two machines, I and II. The profit...
A company manufactures two products, A and B, on two machines, I and II. The profit is $3 on each unit of product A and $4 on each unit of product B. To manufacture a unit of product A requires 6 minutes on machine I and 5 minutes on machine II. To manufacture a unit of product B requires 9 minutes on machine I and 4 minutes on machine II. There are 300 minutes of machine time available on machine...
Linear Programming A company makes two products with a profit of one dollar per ton of...
Linear Programming A company makes two products with a profit of one dollar per ton of product A and two dollars per ton of product B. To produce one ton of product A two tons of water is needed and for one ton of product B one ton of water is needed. The factory only has 20 tons available to produce the products. The product needs a process of two steps. For the first step the company hires a person...
A firm produces three products: A, B, and C. Each requires 3 resources in the production...
A firm produces three products: A, B, and C. Each requires 3 resources in the production process: 1, 2, and 3. There are 15,000, units of resource 1 available. There are 17,000 units of resource 2 available. There are 19,000 units of resource 3 available. Product A requires 4 units of resource 1, 3 units of resource 2, and 5 units of resource 3. Product B requires 7 units of resource 1, 6 units of resource 2, and 5 units...
A company manufactures x units of Product A and y units of Product B, on two...
A company manufactures x units of Product A and y units of Product B, on two machines, I and II. It has been determined that the company will realize a profit of $5/unit of Product A and a profit of $2/unit of Product B. To manufacture a unit of Product A requires 6 min on Machine I and 5 min on Machine II. To manufacture a unit of Product B requires 9 min on Machine I and 4 min on...
A firm produces three products: A, B, and C. Each requires 3 resources in the production...
A firm produces three products: A, B, and C. Each requires 3 resources in the production process: 1, 2, and 3. There are 15,000, units of resource 1 available. There are 17,000 units of resource 2 available. There are 19,000 units of resource 3 available. Product A requires 4 units of resource 1, 3 units of resource 2, and 5 units of resource 3. Product B requires 7 units of resource 1, 6 units of resource 2, and 5 units...
A company manufactures two products: large fans and medium fans. Each large fan requires 3 hours...
A company manufactures two products: large fans and medium fans. Each large fan requires 3 hours of wiring and 2 hours of drilling. Each medium fan requires 2 hours of wiring and 1 hour of drilling. There are 480 hours of wiring time available and 280 hours of drilling time available. Each large fan yields a profit of $25. Each medium fan yields a profit of $18. The company wants to manufacture at least 20 large fans. The objective is...
1. A firm produces four products: Each unit of product 1 requires two hours of assembly,...
1. A firm produces four products: Each unit of product 1 requires two hours of assembly, one hour of painting and $50 of inventory, Each unit of product 2 requires one hour of assembly, three hours of painting and $75 of inventory, Each unit of product 3 requires 2.5 hours of assembly, 2.5 hours of painting and $20 of inventory, Each unit of product 4 requires 5 hours of assembly no painting and $100 of inventory. The firm has 140...
A manufacturing company has a pool of 50 labor hours. A customer has requested two products,...
A manufacturing company has a pool of 50 labor hours. A customer has requested two products, Product A and Product B, and has requested 15 and 20 of each respectively. It requires 2 hours of labor to produce Product A and 3 hours of labor to produce Product B. The company can obtain up to 50 additional hours of labor if required. In-house labor costs $25 per hour while contracted labor costs $45 per hour. Draw the network flow model...
A company manufactures Products A, B, and C. Each product is processed in three departments: I,...
A company manufactures Products A, B, and C. Each product is processed in three departments: I, II, and III. The total available labor-hours per week for Departments I, II, and III are 900, 1080, and 840, respectively. The time requirements (in hours per unit) and profit per unit for each product are as follows. (For example, to make 1 unit of product A requires 2 hours of work from Dept. I, 3 hours of work from Dept. II, and 2...