Question:
The assignment is based on the LCA example on the automotive "body-in-white". The main parameters from the Simapro model have been converted into an Excel file.
The basic model in the file includes the following for the steel body in white:
200 kg of hot-rolled steel
200 kg of sheet rolling
3 kg of zinc
203 kg of drawing (manufacture)
Additional materials for the heavier engine (combined together into a single unit)
Fuel use attributed to the weight of the steel BIW
Fuel use attributed to the additional engine weight
For the carbon-fibre composite BIW, the following are included:
43.45 kg of carbon fibre
35.55 kg of epoxy resin
79 kg of moulding
Fuel use attributed to the weight of the composite BIW
Waste treatment of the composite, made up of an incineration process, plus the heat saved from not needing to burn other fuels (assumed to be coal).
For both cases, fuel use is determined per litre of fuel attributed to the BIW weight over the lifetime of the car, which is taken as 200000 km.
Details of how fuel efficiency varies with weight are given in the case study lecture.
The Excel file has the following sheets:
1 The process mid-point values of impacts in each category, expressed in different units for each category. For instance climate change is expressed as kg CO2 equivalent.
In addition to the processes used above for the initial model, three extra processes that you could use are included. These are pyrolysis of carbon-fibre composite, electric motor and battery system.
2 The mid-point values calculated for the steel BIW.
3 The mid-point values calculated for the composite BIW.
4 The end-point values, grouped into Human Health, Ecosystem Loss and Resource Depletion for the steel BIW.
5 The end-point values for the composite BIW.
6 A set of conversion factors to convert from mid-point values to end-point values.
7 A set of normalisation values, for an individual''s annual impact in each category. These are done for an average European and for a worldwide average.
Your Tasks
You need to perform a quantitative and qualitative analysis of the following changes to the basic model.
A. A pyrolysis process has been developed that can recycle carbon fibre composites. The mid-point values for the process are included. You need to consider how you would change the model to account for the carbon fibres that are recycled out of this process. A quantitative analysis using the Excel file would be expected. If the recycled carbon fibres are not as strong as new fibres, consider how you might include this effect in the model.
B. With the basic model, calculate normalised values of the mid-point values. Compare these to normalised end-point values and discuss why there may be differences. Use European and Worldwide values.
The report for this should be in the form of a word document with accompanying Excel file and graphs. Try to be as concise as possible but clearly explain what you have done in doing the analyses.
The Question shown above must have 3000 words and all the quantitate and qualitative analysis done in excel file and show clearly what you have done and how? with graphs and other diagrams