You are conducting an LCA in 2026 to determine the environme…

You are conducting an LCA in 2026 to determine the environmental footprint of crystalline silicon (c-Si) solar photovoltaic (PV) modules manufactured in China. 90% of c-Si PV modules are manufactured in China. Industrial c-Si PV manufacturing began ramping up significantly in 2003. c-Si PV manufacturing consists of 7 key steps, out of which the most important step is the purification of metallurgical-grade silicon to solar-grade silicon The Siemens process, which purifies metallurgical-grade silicon into solar-grade silicon (the grade required to produce the wafer used in the PV module), accounts for 90% of the solar-grade silicon used by the Chinese PV industry. You obtain data (based on operations in 2013) from a PV manufacturing plant owned by ‘ABC Inc’, located in China, that uses a fluidized-bed reactor (FBR) process to produce solar-grade silicon.  Since the FBR process is a deviation from the market-dominant Siemen’s process to produce solar-grade silicon, you approach another PV manufacturing plant ‘XYZ Inc’ located in China to obtain material and energy inventory data for only the Siemen’s process. XYZ Inc provides you with the inventory data for only their Siemen’s process based on operations in 2013. In summary, you are collecting data from XYZ Inc for only the Siemens process and ABC Inc for the 6 remaining steps, i.e., the PV manufacturing steps outside of the Siemens process. Excluding the FBR process, the remaining 6 manufacturing processes used in ABC Inc. are identical to 1305 of the 1554 solar PV manufacturing plants located in China.  By collaborating with a 3rd-party consulting agency that is a world-leading expert in PV manufacturing, you have verified that the inventory data collected from ABC and XYZ Inc. is accurate.    a) Create a pedigree matrix with values to assess the data quality. Justify the values you have presented in the pedigree matrix. (15 points)    b) If the GSD for the basic uncertainty in the energy used in manufacturing the PV module is 1.05 (the standard deviation, MJ/m2), determine the total uncertainty based on the values you have chosen for the Pedigree Matrix. Provide the steps for the calculations (5 points)

The material requirements and the CO2 intensity of the mater…

The material requirements and the CO2 intensity of the materials used in the production of Product A are normally distributed and are as follows.  The normal distribution in excel can be simulated as follows  =NORMINV(RAND(),mean,sd) Please email an excel with file name “CEE582_Exam 2_FirstName_Lastname” and with the Montecarlo values and scatter and tornado plots. There should be two tabs in the excel: (i) “Exam 2 Q2 Scatter plot” (ii) “Exam 2 Q2 Tornado plot”   Input item Mass requirement – mean (kg per piece of product A) Mass requirement – sd (kg per piece of product A) CO2 intensity – mean (kg/kg item) CO2 intensity – sd (kg/kg item) Item 1 120 20 40 10 Item 2 60 15 30 3 Item 3 22 5 8 1 a) Using a Monte Carlo simulation of 2000 runs, plot a scatter plot of the total CO2 footprint of A versus the CO2 footprint of the three input items. Plot the X axis to vary from 0 to 14000 (item1, item 2 and item 3) and the Y axis (total CO2 footprint of A) from 0 to 14000. Based on a visual examination, determine which input item drives the total CO2 footprint of Product A the most. Justify your answer. (8 points) b) Using the mean values of the mass requirement and the CO2 intensity, plot a tornado plot and determine which input item drives the total CO2 footprint of Product A the most. Justify your answer (7 points) c) Is there is a discrepancy in your observations for the scatter and tornado plots. (yes or no)? If yes, which plot would you agree with? Please justify your answer (5 points).