Consider the following problem for which the LP formulation is given below. 3 courier companies have a total of 450 items to deliver to destinations within the city for a certain organisation. Fast couriers charge 8 dollar per item, Speedy couriers charge 9 dollar per item while Reliable couriers charge 8.50 dollar per item. Fast and Speedy together can deliver up to 350 items. Organisation wants to arrange the allocation of work to the courier companies so that no two companies together earn more than $2600. Formulate and solve this problem by means of the SOLVER tool of Excel.
Formulation:
Let
X1=NUMBER OF ITEMS DELIVERED BY FAST COURIERS
X2=NUMBER OF ITEMS DELIVERED BY SPEEDY COURIERS
X3=NUMBER OF ITEMS DELIVERED BY RELIABLE COURIERS
WHAT IS THE COST, NUMBER OF ITEMS DELIVERED BY FAST, SPEEDY AND RELIABLE COURIERS?