For each alternative, calculate the following: (11 pts) Supplier Location Vancouver San Francisco Vancouver Beijing Hanoi...

Transcribed Image Text:

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) 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)