Question

In: Operations Management

Nada Dairy is contracted to receive daily 60,000 kg of ripe tomatoes at 7 cents per...

Nada Dairy is contracted to receive daily 60,000 kg of ripe tomatoes at 7 cents per kg from which it produces canned tomato juice, tomato sauce, and tomato paste. The canned products are packaged in 24-can cases. A can of juice uses 1 kg of fresh tomatoes, a can of sauce uses 1/2 kg, and a can of paste uses 3/4 kg. The company’s daily share of the market is limited to 2000 cases of juice, 5000 cases of sauce, and 6000 cases of paste. The wholesale prices per case of juice, sauce, and paste are SAR 21, SAR 9, and SAR 12, respectively.

a. [2 Marks] Develop a mathematical model that determine the optimum daily production program for the company.

b. [1 Mark] Solve it using software and show the results. c. [2 Mark] If the price per case for juice and paste remains fixed as given in the problem, use sensitivity analysis to determine the unit price range that the company should charge for a case of sauce to keep the optimum product mix unchanged.

Solutions

Expert Solution

(a)

Let 'J', 'S', and 'P' are the cases of Juice, Sauce, and Paste to be produced respectively.

Revenue = 21 * J + 9 * S + 12 * P
Cost = {1 * J + (1/2) * S + (3/4) * P} * 24 * 0.07

Max Z = Total profit = Revenue - Cost = (21 - 24*0.07)*J + (9 - 12*0.07)*S + (12 - 18*0.07)*P

or, Max Z = 19.32*J + 8.16*S + 10.74*P

Subject to,

1 * 24 * J + (1/2) * 24 * S + (3/4) * 24* P <= 60000 or, 24*J + 12*S + 18*P <= 60000

J <= 2000

S <= 5000

P <= 6000

J, S, P >= 0

(b)

Excel model

Solver inputs:

Solution (Answer report)

(c)

Sensitivity report:

The optimality range of profit is [-1, +1.5], the same will hold for selling price because we are not changing the cost of tomatoes.

So, the required range is [9-1, 9+1.5] i.e. [8, 10.5]


Related Solutions

A) An infant weighing 20 lbs is to receive Gantricin 75 mg/kg po daily in 6...
A) An infant weighing 20 lbs is to receive Gantricin 75 mg/kg po daily in 6 divided does. Gantricin is supplied as 0.5 g/5ml. How much will you administer with each dose? B)The physician orders diflucan (Fluconazole) 300 mg I.V.P.B. q8h. The drug is supplied as 300 mg diluted in 100 ml of D5W (300 mg/100 ml) and it is to be infused over 60 minutes. The drop factor is 20 gtts/ml. Calculate the rate in ml/hr. C)The doctor orders...
A patient is to receive 50 units per kg of IV Heparin x1 now. The patient...
A patient is to receive 50 units per kg of IV Heparin x1 now. The patient weighs 190 lbs. How many units of Heparin should the nurse prepare and administer?
Suppose you are going to receive $12,000 per year for 7 years. The appropriate interest rate...
Suppose you are going to receive $12,000 per year for 7 years. The appropriate interest rate is 9 percent. a. What is the present value of the payments if they are in the form of an ordinary annuity? b. What is the present value if the payments are an annuity due? c. Suppose you plan to invest the payments for 7 years, what is the future value if the payments are an ordinary annuity? d. Suppose you plan to invest...
Would you rather receive: $5,500 at the end of three years, $1,200 per year for 7...
Would you rather receive: $5,500 at the end of three years, $1,200 per year for 7 years or $750 per year for 15 years if the discount rate is 20%? 5a) Would your answer change if discount rate is 2%? If the answer does change, explain in a simple sentence “why”/what happened?
Suppose you are going to receive $11,000 per year for 7 years. The appropriate interest rate...
Suppose you are going to receive $11,000 per year for 7 years. The appropriate interest rate is 7 percent.    a. What is the present value of the payments if they are in the form of an ordinary annuity? b. What is the present value if the payments are an annuity due? c. Suppose you plan to invest the payments for 7 years, what is the future value if the payments are an ordinary annuity? d. Suppose you plan to...
7) Skinner’s Fish Market buys fresh Boston bluefish daily for $4.20 per pound and sells it...
7) Skinner’s Fish Market buys fresh Boston bluefish daily for $4.20 per pound and sells it for $5.70 per pound. At the end of each business day, any remaining bluefish is sold to a producer of cat food for $2.40 per pound. Daily demand can be approximated by a normal distribution with a mean of 47 pounds and a standard deviation of 16 pounds. What is the optimal stocking level? Round your answer to 2 decimal places.
Gregor will receive $20,000 at the end of 6 years. If the interest rate is 7% per year, what is the present value of this cash flow?
Gregor will receive $20,000 at the end of 6 years. If the interest rate is 7% per year, what is the present value of this cash flow?A perpetuity will pay you $400 per year, forever. If the discount rate is 8%, what is this perpetuity worth today? Nicole will need $22,000 in nine years. She currently has $10,000 to invest. At what interest rate must she invest the money?  
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT