Based on the information provided, the representative has asked that you provide a detailed financial analysis of each transportation option and prepare a report that recommends a preferred option from those available. The following requests have been made about the analysis and report: - The financial analysis is to be completed in Excel. The file is to be easily adjustable for different scenarios and all inputs must be in the one sheet called ‘Assumptions’ with the analysis of each option conducted on a separate sheet. - The report is to be short (600 words + 20% tolerance) and written in a manner that can be understood by a person with a basic understanding of financial terminologies and analytical tools. - The report sections to include: Summary, Methodology, Recommendations and Limitations. o Summary: outlines the task and advises of the recommendation. o Methodology: must explain and justify the methodology employed. o Recommendations: recommends a preferred option from those available. In addition, includes some further analysis on whether an assumption of $0 ‘wages’ would affect the recommendation. This additional analysis is requested given recent developments with automated trucks and trains in the mining sector. o Limitations: must identify key limitations with the analysis.