Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
Question 1 Green Urban Solutions and Technology Pte Ltd (GUST) is a local business start-up that has chosen to focus on commercially viable sustainability solutions
Question 1 Green Urban Solutions and Technology Pte Ltd (GUST) is a local business start-up that has chosen to focus on commercially viable sustainability solutions for urban environments. In Budget 2021, the Singapore Government had announced that petroldriven cars would be completely phased out by 2040. New car registrations would only be for electric vehicles (EV). The Government had also set a target of installing 60,000 charging points (CP) by the year 2030 from some 1,900 CP's presently. These CP's will be operated by private enterprises. GUST decided to ptusue such an opportunity. GUST plans to roll out Type 3 superchargers that can recharge an EV from 0 to 80% in about 20 minutes. Each supercharger constitutes one CP. These chargers will be installed island-wide in clusters of 2 to 4 CP's per location. Every such CP will require a standard-size parking lot which GUST will rent from building owners and car-park operators. These CP's will operate on a self- service basis over 24x7 hours. EV customers will use a mobile phone app to operate the CP and pay for the charging service. Every customer will be allowed up to 30 minutes to charge their cars at a CP. Penalties will be imposed on those who stay beyond the 30minute charging timeslot. On a typical day, a GP can be used for up to 48 charging timeslots. EV cars and EV chargers have very few parts and are known to be robust and reliable, requiring very low maintenance, if any. The chargers can be operated continuously over 24 hours with almost no operational impediment. It is the ideal digital solution for sustainable urban transportation and GUST hopes to be a signicant player in this economic sector. This assignment requires you to apply spreadsheet modelling techniques to analyse and solve business problems in this case study. Note that all numerical results must be stated in words explicitly, and not left as-is in your models. (a) Develop a spreadsheet model that will enable GUST to analyse the number of Charging Points (CP) that it needs to install and the utilisation rate of these CP's
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/66780353daf47_20366780353b1afe.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started