Need help with the excel portion only need to plug in the correct numbers, please help with excel sectionThe Prompt Corporation purchases product from two suppliers, A and B$.$ Supplier A is located in Austin,TX$,$ and supplier B in Carthage, TN$.$ Supplier A supplies component a and supplier B supplies componentb. These components are used to make gizmos of two types, I and II$.$ Gizmo I is made in Helena, MT$,$ andGizmo II is made in Duluth, MN$.$ Each manufacturing plant makes $50$ gizmos a day. Each gizmo requires $1$unit each of components a and b$.$Currently loads are shipped full truckload from suppliers directly to plants. Trucks used have a capacityof $500$ units and cost $$2,500$ per truckload shipped. Holding cost per com$-$ ponent per day is $$0\mathrm{.}50.$Transit time per route is $4$ days.a$.$ Provide the total supply chain costs for this system.b$.$ Prompt has realized that it can obtain larger trucks with a capacity of $1,000$ units for a cost of$$3,500$ per route and the same transit time of $4$ days per route. If Prompt has these trucks,should all shipments be full truckload or less$-$than$-$full truckload? What will be the associatedtotal supply chain costs to use these trucks with the appropriate level of loads on these trucks?Are the costs lower than $(3$a$)?$ Explain why or why not.