Question

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 of resource 3. Product C requires 6 units of resource 1, 5 units of resource 2, and 4 units of resource 3. Product A has a net per unit profit of $125, product B has a net per unit profit of $150, and product C has a net per unit profit of $225. We must make at least 500 units of each product. However, we must not make more than 1,200 units of each product. Including each specific equation, how many constraints are there in this problem as if you were using solver on excel? Also if the goal of the firm is to maximize profits, how many units of product A, B, and C should be produced?

Homework Answers

Answer #1

There are 5 constraints in this problem.

The solver parameters are:

The solution is:

The solution is:

A = 0

B = 0

C = 1200

Z = 270000

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 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...
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 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...
13. In a company in the short run the production of a product requires one variable...
13. In a company in the short run the production of a product requires one variable input along with a fixed input. The total product of the units of the variable input from 0 to 5 are, respectively, 0, 10, 18, 24, 28, and 30. Each unit of the product can be sold for $3. The marginal product of the second unit of the resource is: A. 4 B. 6 C. 8 D. 10 14. In a company in the...
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...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit):...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit): Product A B C Selling price $ 84.00 $ 66.00 $ 74.00 Variable expenses: Direct materials 25.20 18.00 9.00 Other variable expenses 25.20 31.50 42.80 Total variable expenses 50.40 49.50 51.80 Contribution margin $ 33.60 $ 16.50 $ 22.20 Contribution margin ratio 40 % 25 % 30 % The company estimates that it can sell 850 units of each product per month. The same...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit):...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit): Product A B C Selling price $ 72.00 $ 60.00 $ 62.00 Variable expenses: Direct materials 21.60 18.00 9.00 Other variable expenses 21.60 27.00 34.40 Total variable expenses 43.20 45.00 43.40 Contribution margin $ 28.80 $ 15.00 $ 18.60 Contribution margin ratio 40 % 25 % 30 % The company estimates that it can sell 1,000 units of each product per month. The same...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit):...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit): Product A B C Selling price $ 84.00 $ 70.00 $ 74.00 Variable expenses: Direct materials 25.20 21.00 9.00 Other variable expenses 25.20 31.50 42.80 Total variable expenses 50.40 52.50 51.80 Contribution margin $ 33.60 $ 17.50 $ 22.20 Contribution margin ratio 40 % 25 % 30 % The company estimates that it can sell 750 units of each product per month. The same...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit):...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit): Product A B C Selling price $ 80.00 $ 60.00 $ 72.00 Variable expenses: Direct materials 24.00 15.00 9.00 Other variable expenses 24.00 33.00 45.00 Total variable expenses 48.00 48.00 54.00 Contribution margin $ 32.00 $ 12.00 $ 18.00 Contribution margin ratio 40 % 20 % 25 % The company estimates that it can sell 1,000 units of each product per month. The same...
XYZ makes three products A, B, & C that use compound W, the current constrained resource:...
XYZ makes three products A, B, & C that use compound W, the current constrained resource: A B C Selling price per unit $ 20 $ 30 $ 40 Variable cost per unit $ 12 $ 20 $ 20 Pounds of compound W per unit 2 4 4 A total of 2,000 pounds of compound W are available. The demand for each product is infinitely large. To generate the largest contribution margin, how many units of each product should XYZ...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT