Over the next 10 years from 2021 to 2030, GUST needs to plan out the number...

Transcribed Image Text:

Over the next 10 years from 2021 to 2030, GUST needs to plan out the number of charging points (CP) that it will install at various places. The number of CPs that will be viable clearly depends on the car population size and EV adoption rate. Future car population numbers are not known. However, the Land Transport Authority (LTA) has provided the car population figures for the last 10 years as shown in table 2 below. The number of EV cars may be assumed to be negligible over this period. Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Car Population 597746 606280 620011 623688 619023 604722 603763 614739 618055 632681 636180 Table 2: Car Population Numbers from 2010 to 2020 Nevertheless, GUST hopes to be able to project future demand for EV cars based on this historical data. Clearly, the number of EV cars on the road will translate into potential demand for its electrical charging services. (a) Describe four key insights disclosed by the set of car population figures shown in table 2. Your description must be supported and verified by a suitable spreadsheet model. Over the next 10 years from 2021 to 2030, GUST needs to plan out the number of charging points (CP) that it will install at various places. The number of CPs that will be viable clearly depends on the car population size and EV adoption rate. Future car population numbers are not known. However, the Land Transport Authority (LTA) has provided the car population figures for the last 10 years as shown in table 2 below. The number of EV cars may be assumed to be negligible over this period. Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Car Population 597746 606280 620011 623688 619023 604722 603763 614739 618055 632681 636180 Table 2: Car Population Numbers from 2010 to 2020 Nevertheless, GUST hopes to be able to project future demand for EV cars based on this historical data. Clearly, the number of EV cars on the road will translate into potential demand for its electrical charging services. (a) Describe four key insights disclosed by the set of car population figures shown in table 2. Your description must be supported and verified by a suitable spreadsheet model.

Answer rating: 100% (QA)

To analyze the car population figures shown in Table 2 and derive key insights lets create a spreadsheet model Well calculate the average annual growt... View the full answer