Question

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?

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.

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

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 20 minutes ago

asked 22 minutes ago

asked 22 minutes ago

asked 46 minutes ago

asked 46 minutes ago

asked 46 minutes ago

asked 49 minutes ago

asked 57 minutes ago

asked 58 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago