The Transportation Method of linear programming is a method that can be used to solve problems related to transportation from several locations to several destinations. While this can be done manually, it would take many hours even to do a simple transportation network. However, Excel is a master at helping solve problems like this. Please read through all sections before proceeding to the next page and refer back whenever necessary.Your boss has asked you to calculate the Economic Order Quantity (EOQ), Reorder Point, and Total Annual Cost for one of the major sub-components used by your firm. Your boss has provided you with an EOQ Excel Template that includes the data to use. Please note that you are not allowed to make changes to the template. Your boss wants you to build a single formula for each yellow box to perform the calculation. Once finished, then in simple language, you are to provide a short analysis of what these numbers indicate