*Write each step in a paragraph

*can you explain step by step how will you do Excel?

Question #2. (3 Marks) Al-Haya Medical Company produces precision medical diagnostic equipment at two factories. Three pharmacies have placed orders for this month's production output. The table below shows what the cost would be for shipping each unit from each factory to each of these pharmacies. Also shown are the number of units that will be produced at each factory and the number of units ordered by each pharmacy. From Factory 1 Factory 2 Order size Unit Shipping Cost Pharmacy 1 Pharmacy 2 Pharmacy 3 $300 $400 $400 $200 $500 $300 150 units 200 units 200 units Factory Output 300 units 250 units A decision now needs to be made about the shipping plan for how many units to ship from each factory to each customer. a. [1 Mark] Formulate a linear programming model for this problem. b. [1 Mark] Solve the problem and discuss the optimal solution obtained upon solving (show the output of the software you used). c. [0.5 Mark] What is the optimal solution to the problem? d. [0.5 Mark] What is the optimal objective value