Ms. Rupali ICICI Bank manager personnel & training division is in a fix purchasing certain Machines for branches across india Old machines can be brought at Rs 2 lakhs each while new machines cost Rs 5 lakhs each. The old machines produce 3 components /week while the new machines produce 5 components/week each component being worth Rs 30,000. A machine new/old costs Rs 1 lakh/week to maintain. The company has only Rs 80 lakhs to spend on machines. How many of each kind should the company buy to get a profit of more than Rs 6 lakhs/week. Assume that the company cannot house more than 20 machines. Suggest and Discuss as to how many machines of each type she should buy? on the above data you are to:
a) Assuming the cost of transportation to be Rs.7 per kilometre and per lakh you are to assist Sadhana in identifying the branches and the ATM’s they are to handle. You need to convert the above table into transportation matrix.(Do consider only demand in converting transportation matrix)
b) Use Vogel’s approximation method to arrive at the feasible solution.
c) Solve the transportation problem in excel solver and enclose the screenshots of each step of the process.
Identify at least two other situations at the branches where you can use the above methodology to obtain an optimal solution