Mitra Corporation requires 2000 units of a certain item per year. The purchase price per unit is Rs 30, the carrying cost of inventory is 25% of the inventory value and the fixed cost per order is RS. 1000.

a) Determine the Economic Order Quantity.

b)What will be the Total Cost of Carrying and Ordering inventories when 4 Orders of equal size are placed?

solution without excel only