The LP Problem formulation is given below which determines how many necklaces (X1), bracelets (X2), rings (X3) and ear rings (X4), a jewellery store should stock. The objective function measures profit; it is assumed that every piece stocked will be sold. Constraint 1 measures display space in units, Constraint 2 measures time to set up the display in minutes. Constraints 3 and 4 are marketing restrictions 1 and 2 respectively.




Max 100 X1 + 120 X2 + 150 X3 + 125 X4      
Subject to:            
  X1 + 2 X2 + 2X3 + 2X4      
  3X1 + 5 X2   + X4      
  X1   + X3        
    X2 + X3 125 X4 >=108    



Solve the problem in Excel and answer the following questions.

(First 10 are of 1 mark each and last 5 are of 2 Marks each)

A. What is the Number of necklaces to be stocked?

B. What should be the value of bracelet coefficient so that it appears in optimal solution?

C. What is the Number of rings to be stocked?

D. Which constraints are binding?

E. What is the value of optimal value of Profit?

F. What is theRange of optimality of necklaces?

G. How much space will be left unused?

H. How much time will be used?

I. What is theRange of optimality of ear rings?

J. What is theRange of Feasibility Display space?

K. What would the Profit be if theDisplay space is increased by 5 units?

L. What would the Profit be if thetime to set up the display is decreased by 10 units?

M. You are offered the chance to obtain more space. The offer is for 15 units and the total price is 1500. What should you do? Answer in yes or no

N. Which resource should the company work to increase, Space or Time.

O. Over what range of marketing restriction 1 is the dual price applicable?