can you solve step by step and clearly please? and do not solve by excel. write question number top of the every answer please and write readable.

1) 4 different suppliers are shipping different products in volumes of 10000, 8000, 15000 and 7000 tons respectively to a manufacturing plant. The cost of LTL transportation from these suppliers to the manufacturing plant is 65, 55, 100 and 50 TL/ton respectively. If a consolidation center is built the cost of LTL transportation from these suppliers to consolidation center will be 25, 10, 40, 9 TL/ton respectively. Handling costs in the consolidation center is 5, 6, 4, 7 TL/ton respectively. FTL transportation cost from consolidation center to the manufacturing plant will be 30 TL/ton. Should the consolidation center be built? 2) ABC is a distribution company wishing to open a new distribution center in Tuzla. Maximum amount of materials inbound or outbound is forecasted as 700 palettes. Inbound and outbound logistics will be performed by using same type of vehicles with a handling capacity of 33 palettes at a time. Vehicle loading and unloading times are 45 minutes and door/ramp occupation time is assumed as 1 hour. It is known that a vehicle can be used for 7.5 hours per day. Find the number of doors/ramps for this distribution center