Part (a):
To determine: Dual prices of M1 and M2 and their feasibility ranges
Solution:
The feasibility range of M1 is obtained as follows:
The dual price of M1 is computed as follows:
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:
The dual price of M2 is computed as follows:
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:
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.
Therefore, if M2 availability is increased by 5 more units, the associated optimum revenue would be $11.65.
Can i have the complete solution for this? if needed using excel solver and the explanaition....
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 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 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 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 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 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 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, 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 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. 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...