Question

1. A company manufactures two products, A and B. The unit revenues are $2 and $3, respectively. Two raw materials, M1 and M2,
Can i have the complete solution for this?
if needed using excel solver and the explanaition.
thank you!!!
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Part (a):

To determine: Dual prices of M1 and M2 and their feasibility ranges

Solution:

The feasibility range of M1 is obtained as follows:

(6.0)→2(6)+2(0)=12:(0,3) ► 2(0)+2(3)=6;639, 512

The dual price of M1 is computed as follows:

Dual price of M1-(12-9) (12-6) = $0.50

Therefore, the feasibility range of M1 and its dual price is 6 ≤ q1 ≤ 12 and $0.50, respectively.

The feasibility range of M2 is obtained as follows:

(4,0) +3(4) +6(0)=12:(0,4) +3(0) +6(4)=6:12 59, 524

The dual price of M2 is computed as follows:

Dual price of M2 (24-12) = $0.33

Therefore, the feasibility range of M2 and its dual price is 12 ≤ q2 ≤ 24 and $0.33, respectively.

________________________________________________________________

Part (b):

Yes, it would be recommended to make the additional purchase if 4 additional units of M1 can be purchased at a cost of 30 cents per unit, as 8 and 4 would give 12 which is still in the range and $0.30 would be less than $0.50.

________________________________________________________________

Part (c):

The most the company needs to pay per unit of M2 would be the dual price of M2. The dual price of M2 is calculated below:

(12-8) Dual price of M2= (24-12) = $0.33

Therefore, the most the company needs to pay per unit of M2 is $0.33.

_______________________________________________________________

Part (d):

To determine: Associated optimum revenue

Solution: Calculate the optimum revenue.

Optimum revenue = $10+5(0.33) = $11.65

Therefore, if M2 availability is increased by 5 more units, the associated optimum revenue would be $11.65.

Add a comment
Know the answer?
Add Answer to:
Can i have the complete solution for this? if needed using excel solver and the explanaition....
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • please solve it manually 1. A company produces two products, A and B. The unit revenues...

    please solve it manually 1. A company produces two products, A and B. The unit revenues are $2 and $3, respective- ly. Two raw materials, M1 and M2, used in the manufacture of the two products have re- spective daily availabilities of 8 and 18 units. One unit of A uses 2 units of M1 and 2 units of M2, and 1 unit of B uses 3 units of M1 and 6 units of M2. (a) Determine the dual prices...

  • Problem 4: Sensitivity Analysis (Total 25 points) Consider the following linear program. Solve using the graphical...

    Problem 4: Sensitivity Analysis (Total 25 points) Consider the following linear program. Solve using the graphical method. A company manufactures two products, A and B. The unit revenues are $5 and $8, respectively. Two raw materials, M1 and M2 are used. The supply of M1 and M2 are 4 and 12 units, respectively. Maximize z= 5x1 + 8x2 Subject to M1 2x1 + x2 <4 3x1 + 6x2 < 12 X1, x2 > 0 M2 a) Changes in Constraint RHS...

  • Solve with excel solver and share in excel file MULTI-PERIOD PRODUCTION-SMOOTHINGG MODEL Example 2.4.4 on page...

    Solve with excel solver and share in excel file MULTI-PERIOD PRODUCTION-SMOOTHINGG MODEL Example 2.4.4 on page 65 of Taha's book A company will manufacture a product for the next four months: March, April, May, and June The demands for each month are 520, 720, 520, and 620 units, respectively. • The company has a steady work force of 10 employees but can meet fluctuating production needs by hiring and firing temporary workers at the beginning of each month, if necessary...

  • please solve this question excel solver and to excel file MULTI-PERIOD PRODUCTION-SMOOTHINGG MODEL Example 2.4.4 on...

    please solve this question excel solver and to excel file MULTI-PERIOD PRODUCTION-SMOOTHINGG MODEL Example 2.4.4 on page 65 of Taha's book • A company will manufacture a product for the next four months: March, April, May, and June. The demands for each month are 520, 720, 520, and 620 units, respectively. • The company has a steady work force of 10 employees but can meet fluctuating production needs by hiring and firing temporary workers at the beginning of each month,...

  • Hello, I need help with the following problem: 1. Multi-period production problem. Formulate the production and...

    Hello, I need help with the following problem: 1. Multi-period production problem. Formulate the production and inventory problem at XXI Company using Excel. See narrative below Solve the problem in Excel XX1 Company Production and Inventory Problem Narrative A company named XX1 has contracted to produce products A and B, over the months of June, July and August. The total production capacity (expressed in hours) varies monthly. The following table provides the basic data for the situation. June July August...

  • please solve this question excel solver MULTI-PERIOD PRODUCTION-SMOOTHINGG MODEL Example 2.4.4 on page 65 of Taha's...

    please solve this question excel solver MULTI-PERIOD PRODUCTION-SMOOTHINGG MODEL Example 2.4.4 on page 65 of Taha's book A company will manufacture a product for the next four months: March, April, May, and June The demands for each month are 520, 720, 520, and 620 units, respectively. • The company has a steady work force of 10 employees but can meet fluctuating production needs by hiring and firing temporary workers at the beginning of each month, if necessary The extra costs...

  • Using the simplex method, find the optimal solution to the following LP: A company manufactures three...

    Using the simplex method, find the optimal solution to the following LP: A company manufactures three products, A,B, and C. The sales volume for A is at least 50% of the total sales of all three products. However, the company cannot sell more than 75 units of A per day. The three products use one raw material, of which the maximum daily availability is 240 pounds. The usage rates of the raw material are 2 lb per unit of A,...

  • A company that manufactures three products, A. & and using three machines, M1, M2, and M3,...

    A company that manufactures three products, A. & and using three machines, M1, M2, and M3, wants to determine the optimal production schedule the maximizes the total profit. Product A has to be processed by machines M1, M2, and M3, product B requires M1 and M3, while product requires M1 and M2. The unit profits on the three products are $5,54 and 56, respectively. The following linear program is formulated to determine the optimal product mic Maximize S. Z-5x -...

  • A company that manufactures the products, and closing three machines M1, M2, and wants to determine...

    A company that manufactures the products, and closing three machines M1, M2, and wants to determine the optimal production schedule that maximizes the total profic Product A has to be processed by machines M1, M2, and Ms product requires M1 and M3, while product requires M1 and M2. The unit profits on the three products are 36, 36, and S7, respectively. The following linear program is formulated to determine the optimal product mix Maxme st ZH66x + 7x x +...

  • Please help me I need this completed by midnight. Please compute in Microsoft Excel as well....

    Please help me I need this completed by midnight. Please compute in Microsoft Excel as well. Thank you. Homework #3 Instructions: Use MS Excel to produce the computations to support your answers to Problems,, IV and V Problem l: In a wine-making factory, a bottling machine that has an efficiency rating of 87 percent can fill 50 bottles in 24 minutes. The daily production rate is 21,000 bottles. How many bottling machines are needed? (Assume an 8-hour working day). Problem...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT