uantitative business analysis A computer manufacturing company wants to develop a monthly plan for shipping finished products from three of its manufacturing facilities to three regional warehouses. (SOLVE IN EXCEL) Data on transportationcosts (in dollars per unit) Warehouse Plant 1 2 3 Capacities A 2.41 1.63 2.09 4,000 B 3.18 5.62 1.74 6,000 C 4.12 3.16 3.09 3,000 Requirement 8,000 2,000 3,000 a. Develop the model b. How many variables are involved in the LP formulation? c. How many constraints are there in this problem? d. What is the constraint corresponding to Plant B? e. What is the constraint corresponding to Warehouse 3