Can you solve by excel solver please?

1. Formulate a model and make the calculation for the problem. A logistics company has a large business of transporting materials from A1,A2,A3 to various destinations B1,B2,B3 ... ,B6 .Daily supply, Daily demand, unit transportation cost from A1,A2,A3 to B1,B2,B3..,B6 is shown in Table. Table Daily supply, Daily demand, unit transportation cost What is the optimal transportation plan to minimize its total transportation cost? 2. Formulate a model and make the calculation for the problem. A factory is ready to produce three products, A, B, and C, which all consume labor and materials, as shown in the table below: Establish a linear programming model for the production plan of the product that can achieve the maximum profit to obtain the optimal solution. And then make the calculation for the