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? Group of answer choices:

a. 6

b. 12

c. 3

d. 9

Homework Answers

Answer #1

A be resource 1, B be resource 2, C be resource 3

Constraints:

  1. 4A + 3B + 5C <= 1200
  2. 7A + 6B + 5C <= 1200
  3. 6A + 5B + 4C <= 1200
  4. 4A + 3B + 5C >= 500
  5. 7A + 6B + 5C >= 500
  6. 6A + 5B + 4C >= 500
  7. A <= 15000
  8. B <= 17000
  9. C <= 19000
  10. A >= 0
  11. B >= 0
  12. C >= 0

There are 12 constraints. Since it is mentioned that if we were using solver on excel, we choose the option " Make Unconstrained values non-negative" which saves us using the last 3 constraints. So I'll go with only 9 constraints for solver on excel. ( Choose 12 incase 9 is incorrect, this happens often whenever the question is made confusing about considering the binding constraints and moreover when a vague condition like "using solver" is given.)

Answer : OPTION D

PLEASE LEAVE A LIKE. IT REALLY HELPS ME A LOT. THANK YOU!!!

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...
QDM Question 5 (17 marks): A company is attempting to decide the mix of products which...
QDM Question 5 : A company is attempting to decide the mix of products which it should produce next week. It has six products, each with a unit profit (unit profit =selling price –variable cost per unit) and a unit production time as shown below: Product Profit ($/unit) Production time (hours/unit) 1 10 1 2 22 2 3 35 1.7 4 19 2.4 5 55 4.5 6 115 9.5 The company has 720 hours available next week. The company has...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT