For each alternative, calculate the following: (11 pts) Supplier Location Vancouver San Francisco Vancouver Beijing Hanoi Payment Currency CDN USD CDN CNY VND Unit Cost (CDN Equiv) $54.00 $50.00 $54.00 $48.00 $46.00 Order Process Automated Semi- Automated Automated Manual Manual Order Costs Method of Transport $30.00 $80.00 $50.00 $340.00 $630.00 Truck Rail Air Ship & Rail Normal Lead Time (days) 3 8 2 60 Ship & Rail 90 a. Economic Order Quantity b. Safety Stock Quantity c. Reorder Point d. Average Inventory Level e. Total Annual Cost Note: Do not round calculated values. For formatting purposes, display only one decimal for quantities, two decimals for dollar values. Include your formulas used in Microsoft Excel, Press CTRL + ` (grave accent). Don't replace the actual calculations - copy the formulas into a neighboring cell and display both. Activate the printing of the "row and column headings" in page setup. Which alternative would you recommend? Why? (5 pts)