SCENARIO: For a hypothetical package on a hypothetical project, we want to do a quick evaluation of five bids received. On this project located in the gulf coast region of the United States, assume that all purchases outside of the USA will be assessed a 15% tariff applied to the value of the goods. The current exchange rate from USD to Euros is 0.86. The jobsite needs these pieces of equipment in 42 weeks, otherwise they will have to pay an additional $150,000 per week for additional crane rental. 1. Using excel, insert formulas to complete the bid tabulation (multiply the quantities by unit prices for extended prices, sum totals, etc.) to compare the total costs of all bidders. 2. Highlight/Make a note of anything that raises a red flag that might require clarifications to the bidders to ensure an apples to apples comparison. 3. In a few sentences, write a recommendation and briefly summarize your reasoning for your supplier selection. 4. Take about 5-10 minutes to format the spreadsheet to be more presentable and easier to read. Project Location: Freeport, TX Required Delivery: Additional Weekly Crane Cost for late delivery: Tariff on Non-US Goods: Supplier 1 Manufacturing Location: USA Supplier 2 China Supplier 3 South Korea Supplier 4 North Korea Supplier 5 Spain Extended Price Description Quantity Unit Price Carbon Steel Vessels 3 $ 75,000.00 Stainless Steel Vessels 2 $ 125,000.00 Carbon Steel Tower 1 $ 250,000.00 Stainless Steel Tower 1 $ 300,000.00 Carbon Steel Drums 6 $ 65,000.00 Stainless Steel Drums 4 $ 98,000.00 Subtotal: Freight Cost: Tariffs: Other Cost: Grand Total: Extended Price Unit Price $ 50,000.00 $ 90,000.00 $ 200,000.00 $ 250,000.00 $ 50,000.00 $ $ 78,000.00 Extended Price Unit Price $ 55,000.00 $ 95,000.00 $ 210,000.00 $ 260,000.00 $ 159,000.00 $ 80,000.00 Extended Price Unit Price $ 45,000.00 $ 75,000.00 $ 180,000.00 $ 200,000.00 $ 45,000.00 $ 70,000.00 Extended Price Unit Price 65,000.00 115,000.00 225,000.00 275,000.00 60,000.00 92,000.00 Total Quoted Weight (tons) Freight cost per ton 1420 50.00 1400 400.00 1840 350.00 1400 300.00 1400 Included $ $ $ $ Lead time Freight Terms 44 weeks FCA, Houston TX 42 weeks FOB Shanghai port 37 weeks Ex Works - Ulsan Shop 32 weeks FOB Pyongyang Port 40 weeks DAP Jobsite Recommendation: SCENARIO: For a hypothetical package on a hypothetical project, we want to do a quick evaluation of five bids received. On this project located in the gulf coast region of the United States, assume that all purchases outside of the USA will be assessed a 15% tariff applied to the value of the goods. The current exchange rate from USD to Euros is 0.86. The jobsite needs these pieces of equipment in 42 weeks, otherwise they will have to pay an additional $150,000 per week for additional crane rental. 1. Using excel, insert formulas to complete the bid tabulation (multiply the quantities by unit prices for extended prices, sum totals, etc.) to compare the total costs of all bidders. 2. Highlight/Make a note of anything that raises a red flag that might require clarifications to the bidders to ensure an apples to apples comparison. 3. In a few sentences, write a recommendation and briefly summarize your reasoning for your supplier selection. 4. Take about 5-10 minutes to format the spreadsheet to be more presentable and easier to read. Project Location: Freeport, TX Required Delivery: Additional Weekly Crane Cost for late delivery: Tariff on Non-US Goods: Supplier 1 Manufacturing Location: USA Supplier 2 China Supplier 3 South Korea Supplier 4 North Korea Supplier 5 Spain Extended Price Description Quantity Unit Price Carbon Steel Vessels 3 $ 75,000.00 Stainless Steel Vessels 2 $ 125,000.00 Carbon Steel Tower 1 $ 250,000.00 Stainless Steel Tower 1 $ 300,000.00 Carbon Steel Drums 6 $ 65,000.00 Stainless Steel Drums 4 $ 98,000.00 Subtotal: Freight Cost: Tariffs: Other Cost: Grand Total: Extended Price Unit Price $ 50,000.00 $ 90,000.00 $ 200,000.00 $ 250,000.00 $ 50,000.00 $ $ 78,000.00 Extended Price Unit Price $ 55,000.00 $ 95,000.00 $ 210,000.00 $ 260,000.00 $ 159,000.00 $ 80,000.00 Extended Price Unit Price $ 45,000.00 $ 75,000.00 $ 180,000.00 $ 200,000.00 $ 45,000.00 $ 70,000.00 Extended Price Unit Price 65,000.00 115,000.00 225,000.00 275,000.00 60,000.00 92,000.00 Total Quoted Weight (tons) Freight cost per ton 1420 50.00 1400 400.00 1840 350.00 1400 300.00 1400 Included $ $ $ $ Lead time Freight Terms 44 weeks FCA, Houston TX 42 weeks FOB Shanghai port 37 weeks Ex Works - Ulsan Shop 32 weeks FOB Pyongyang Port 40 weeks DAP Jobsite Recommendation