Please solve the question in excel only, show all work/formulas.

5. The information relating to Current and Alternative Transportation will be used to analyze the choice between using Maersk (Ocean Freight) and UPS (AirExpress). What are the annual transportation-related costs for each of these options? Based on your answer above, which option would you recommend, and why? What are some other factors (such as inventory levels, safety stock, and the resulting costs) Transportation Information Similar to the changes that have been contemplated with regard to product sourcing, Throx would like to use a single-sourcing strategy for transportation. As an alternative to their current use of Maersk Ocean Freight, Throx would like to consider UPS AirExpress which would significantly reduce actual shipping time from Shanghai to Richmond. The table below provides information for evaluating a potential change of shipping from ocean to air. * No data is available about variation in transit times for air, so Throx assumes this is constant. NOTE: Ignore any current port capacity issues when making your decision/recommendation