i need solution in excel using solver thanks

TeoYCo is an Argentinean company that specializes in pet supplies, whose main product - their Comfy-mat - is manufactured in their plants in Bariloche, Salta, and Rosario city. From those facilities, they distribute the Comfy-mat to their biggest stores in the country located in Mendoza, Posadas, Ushuaia, and Crdoba.

As their supply chain manager, you oversee this products logistics, and your goal is to attend to the expected demand while minimizing its annual transportation cost.

The transportation costs associated with moving one unit of the product from each manufacturing facility to the stores are given below:

Facilities \ Stores	Mendoza	Posadas	Ushuaia	Crdoba
Bariloche	1.32	1.75	0.82	1.53
Salta	0.63	1.23	2.05	2.39
Rosario	0.58	0.37	1.72	0.73

The annual demand forecast of Comfy-mats from each store in number of units is shown below:

Store	Mendoza	Posadas	Ushuaia	Crdoba
Annual Demand in Units	6963	2537	9548	4267

Using your preferred optimization tool and based on the information provided,

1.What is the minimum annual transportation cost TeoYCo will have for this product?

2.How many units would the plant in Salta deliver to the Store in Posadas?

You decide to compare the optimized annual transportation cost with the model you designed to the companys historic data.

The cost seems to be too low, and after double-checking your analysis, you notice that you are missing the production capacity of manufacturing facilities.

After a few calls, your team gathered the data below.

Facility	Annual Capacity in Units
Bariloche	12000
Salta	13500
Rosario	7000

3.Using your preferred optimization tool and based on the provided information, what is the minimum annual transportation cost TeoYCo will have for this product?

After a few meetings with TeoYCo's top management, the team is informed that the plant in Rosario will remain closed for a full year to improve their capacity through capital investment on new equipment, and to increase its efficiency with digital technologies.

4.Using your preferred optimization tool and based on the information provided, how many units will be shipped from Bariloche to all the stores in the country?

Considering that you decide to keep all your manufacturing facilites open to plan for new scenarios (same as Question 2), which of the following alternatives is True (each to be considered independent of other options)?

Choose the best answer

A.Increasing Bariloche's capacity by 20% would affect the number of units that this facility distributes to all stores.

B.Increasing Rosario's facility capacity by 2% will reduce the total annual transportation cost.

C.If Salta offers a 25% reduction in their unit cost to Crdoba, this facility will ship more units to that store.

D.None of the above