Please Fill this Excel Sheet Given Below as Solution
Refund the question please
Lab 1: Petro-powered car Assumption/ Scenario: 10L gasoline (e.g., in Australia) is consumed for driving a petro-powered car with distance of 100 km per day. Follow the steps to estimate: 1. Estimate the costs from crude oil extraction to the gasoline being used 2. Environmental concerns, e.g., the amount of CO2 emission, NO2 emission, etc. 1. Oil exploration & extraction 2. Transportation & oil refinery 3. Storage & oil station 4. Total costs (1+2+3+...) for driving a petro-powered car for 100km 5. CO2 emission during each 100km fx 4 c D E F F G H 1 Laboratory Work/Modelling Exercise-1: Petro-powered car (designed by Yujie Yuan-updated by Abdellah Shafieian) This is an individual exercise involves independent research and calculations. There will be a focus on Petro-powered car system. You are expected to estimate (1) the costs from crude oil extraction to the gasoline being used; and (2) CO2 essmision from the raw material to the final disposal. 2 3 4 Senario/Problem Context: If you use TOL gasoline (eg, in Australia) for driving a petro-powered car with a distance of 100 km per day (You may need to find out how much gasoline con be generated from a specific amount of crude oil. Objectives: 1. to calculate the cost for driving a gasoline-powered car 100 km per day: 2. to calculate CO2 emission. 3. to add other creteria items, e... 7), 8). - based on your research. 4. to calculate the total cost ("C11' and 'D11') and CO2 emission (D22) based on the concerns above. 5 6 AUD Results (AUD) 0 7 what is the cost involved to obtain 10L gasoline? 8 9 10 Economic Analysis Criteria for Lab 1) Cost of crude oil exploration & extraction to obtain gasoline 2) Cost of transportation & oil refinery to obtain gasoline 3) Cost of gasoline storage & Petrol Station 4).5) Total Cost Compare your results with the real Purchase for 10L gasoline 11 12 13 14 15 16 17 18 19 20 1. Search and input the cost to explore & extract It row oil, eg, in Australia 2.Search and input the cost to transport & refine lt row oil eg. in Australia Input cost for It gasoline Storage & oil station Criteria for Lob 1 Input CO2 emission Input CO2 emission of 1t gasoline for OL gasoline 21 22 23 24 The the amount of CO2 emission involved for 10L gasoline Environmental Concerns 6) the amount of CO2 emission 7)... 8) 25 26 27 Item Value 28 29 30 31 Specific energy of gasoline (MJ/kg) Energy input by burning 1OL gasoline Useful energy used by the cer Energy Efficiency 250 M) Energy Efficiency 32 33 34 35 36 37 38 40. 41 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 Lab 1 + Lab 1: Petro-powered car Assumption/ Scenario: 10L gasoline (e.g., in Australia) is consumed for driving a petro-powered car with distance of 100 km per day. Follow the steps to estimate: 1. Estimate the costs from crude oil extraction to the gasoline being used 2. Environmental concerns, e.g., the amount of CO2 emission, NO2 emission, etc. 1. Oil exploration & extraction 2. Transportation & oil refinery 3. Storage & oil station 4. Total costs (1+2+3+...) for driving a petro-powered car for 100km 5. CO2 emission during each 100km fx 4 c D E F F G H 1 Laboratory Work/Modelling Exercise-1: Petro-powered car (designed by Yujie Yuan-updated by Abdellah Shafieian) This is an individual exercise involves independent research and calculations. There will be a focus on Petro-powered car system. You are expected to estimate (1) the costs from crude oil extraction to the gasoline being used; and (2) CO2 essmision from the raw material to the final disposal. 2 3 4 Senario/Problem Context: If you use TOL gasoline (eg, in Australia) for driving a petro-powered car with a distance of 100 km per day (You may need to find out how much gasoline con be generated from a specific amount of crude oil. Objectives: 1. to calculate the cost for driving a gasoline-powered car 100 km per day: 2. to calculate CO2 emission. 3. to add other creteria items, e... 7), 8). - based on your research. 4. to calculate the total cost ("C11' and 'D11') and CO2 emission (D22) based on the concerns above. 5 6 AUD Results (AUD) 0 7 what is the cost involved to obtain 10L gasoline? 8 9 10 Economic Analysis Criteria for Lab 1) Cost of crude oil exploration & extraction to obtain gasoline 2) Cost of transportation & oil refinery to obtain gasoline 3) Cost of gasoline storage & Petrol Station 4).5) Total Cost Compare your results with the real Purchase for 10L gasoline 11 12 13 14 15 16 17 18 19 20 1. Search and input the cost to explore & extract It row oil, eg, in Australia 2.Search and input the cost to transport & refine lt row oil eg. in Australia Input cost for It gasoline Storage & oil station Criteria for Lob 1 Input CO2 emission Input CO2 emission of 1t gasoline for OL gasoline 21 22 23 24 The the amount of CO2 emission involved for 10L gasoline Environmental Concerns 6) the amount of CO2 emission 7)... 8) 25 26 27 Item Value 28 29 30 31 Specific energy of gasoline (MJ/kg) Energy input by burning 1OL gasoline Useful energy used by the cer Energy Efficiency 250 M) Energy Efficiency 32 33 34 35 36 37 38 40. 41 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 Lab 1 +
