Green Urban Solutions and Technology Pte Ltd (GUST) is a local business start-up that has chosen...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 petrol-driven 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 pursue such an opportunity. GUST plans to roll out Type 3 superchargers that can re-charge 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 30-minute charging timeslot. On a typical day, a CP 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 significant 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. You may organise your model as shown in table 1 below. Cars to charge Per Day 10,000 No of CP points 800 No of Charging Slots 38,400 Utilisation 26.0% Table 1: Simple CP Analysis Model The example shows that if GUST had 800 CPs and 10,000 cars needed to be recharged. the utilisation rate of its infrastructure would be 26%. [Hint: Utilisation Rate = Number of Charging Slots Used/Total Number of Charging Slots Available* 100%] All the cells shown shaded (in yellow) must be automatically computed using appropriate Excel functions and formulae. Hardcoding is not permitted. From a business viewpoint, what would be the optimal number of CP's if 15,000 cars needed to be charged? Explain how you derive your answer using the model. (12 marks) (b) Develop a second model for GUST to determine the potential profit from this venture. You may copy your model from part (a) above and enhance it further for this part. You may wish to factor in the following parameters. The cost of electrical equipment for each CP is $90,000 inclusive of hardware, installation and maintenance by the supplier over a 10-year period. Rental for parking lot per CP is expected to be $500 per month. Cost of Electricity is $0.22 per kWh. The average charge per EV car is 40 kWh for each 30-minute slot. GUST plans to charge the customer $0.33 per kWh, which is a 50% premium. For this analysis, assume that GUST has 15,000 customers per day and has installed the optimal number of CPs from part (a). Equipment is evenly depreciated over 10 years. What is the optimal Annual Gross Profit? Is this optimal profit achievable? Why? [Hint: Gross Profit = Sales - CP Depreciation - Parking Lot Rental - Electricity Cost] Using your model and scenario for this part, what is the breakeven number of charging points needed? What is the corresponding utilisation rate? Explain how you obtain this answer. [Hint: At breakeven point, the Gross Profit is 0.] (20 marks) Presentation, layout and formatting Your models for Q1 must be neatly laid out and presented. You must apply appropriate colours, alignment, labels and formatting of numbers. Documentation and legend are expected. (8 marks) 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 petrol-driven 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 pursue such an opportunity. GUST plans to roll out Type 3 superchargers that can re-charge 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 30-minute charging timeslot. On a typical day, a CP 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 significant 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. You may organise your model as shown in table 1 below. Cars to charge Per Day 10,000 No of CP points 800 No of Charging Slots 38,400 Utilisation 26.0% Table 1: Simple CP Analysis Model The example shows that if GUST had 800 CPs and 10,000 cars needed to be recharged. the utilisation rate of its infrastructure would be 26%. [Hint: Utilisation Rate = Number of Charging Slots Used/Total Number of Charging Slots Available* 100%] All the cells shown shaded (in yellow) must be automatically computed using appropriate Excel functions and formulae. Hardcoding is not permitted. From a business viewpoint, what would be the optimal number of CP's if 15,000 cars needed to be charged? Explain how you derive your answer using the model. (12 marks) (b) Develop a second model for GUST to determine the potential profit from this venture. You may copy your model from part (a) above and enhance it further for this part. You may wish to factor in the following parameters. The cost of electrical equipment for each CP is $90,000 inclusive of hardware, installation and maintenance by the supplier over a 10-year period. Rental for parking lot per CP is expected to be $500 per month. Cost of Electricity is $0.22 per kWh. The average charge per EV car is 40 kWh for each 30-minute slot. GUST plans to charge the customer $0.33 per kWh, which is a 50% premium. For this analysis, assume that GUST has 15,000 customers per day and has installed the optimal number of CPs from part (a). Equipment is evenly depreciated over 10 years. What is the optimal Annual Gross Profit? Is this optimal profit achievable? Why? [Hint: Gross Profit = Sales - CP Depreciation - Parking Lot Rental - Electricity Cost] Using your model and scenario for this part, what is the breakeven number of charging points needed? What is the corresponding utilisation rate? Explain how you obtain this answer. [Hint: At breakeven point, the Gross Profit is 0.] (20 marks) Presentation, layout and formatting Your models for Q1 must be neatly laid out and presented. You must apply appropriate colours, alignment, labels and formatting of numbers. Documentation and legend are expected. (8 marks)
Expert Answer:
Answer rating: 100% (QA)
so the optimum number of CPs for 15000 cars is 313 Stepbystep explanation Lets first form a table Ca... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Matts Building Materials is a local business that still serves the Rio Grande Valley since 1969 and was the first one to serve its clients with lumber/hardware/flooring to Hispanic community in the...
-
Super Clean is a local business in the Tri-cities area. It provides cleaning services to residential households and commercial establishments. Both households and businesses sign contracts with Super...
-
Every winter a local recreation department fills a parking lot with water so that the water will freeze and people can ice skate on it. Although the weather does not get cold enough for the water to...
-
In Exercises, find the limit. x-4 lim x-00x + 1
-
Based on a sample on n observations, (x1, y1), (x2, y2), .. ,(xn, yn), the sample regression of y on x is calculated. Show that the sample regression line passes through the point (x = x-bar, y =...
-
A system has a transfer function Plot the response of the system when R(s) is a unit step for the parameter z = 5, 10, and 15. X(s) (20/z)(s + z) R(s) 23s 20 =
-
Find an example of plot displaying geographic data and click on the image. You can answer the following questions using either the default variables and cases, or else use the menu on the left to...
-
BrasPetro S.A., a large Brazilian petrochemical company, reported a balance of R$1,594.9 million in Accounts Receivable at the beginning of Year 7 and R$1,497.0 million at the end of Year 7. Its...
-
Melissa recently paid $660 for round-trip airfare to San Francisco to attend a business conference for three days. Melissa also paid the following expenses: $650 fee to register for the conference,...
-
Outside a home there is a keypad that will open the garage if the correct four-digit code is entered. (a) How many codes are possible? (b) What is the probability of entering the correct code on the...
-
Sort Nearly Sorted Array Description Given a k-sorted array of n elements, where each element is at most k steps away from its target position as it would have been in an array that is sorted in...
-
5. (3 points) The following routine takes as input a list of n numbers, and returns the first value of i for which L[i]
-
Write a MATLAB function called my mean which takes four ar- guments: a function name fun, a number a, another number b satisfying a
-
Establishing the Project Baseline Plan. Once we have developed our project budget and schedule, we must determine whether the project can be successfully executed within the required time using the...
-
Refer to the SUCCESS principles in the chapter for making a commercial stand out from the clutter. Choose three of your favorite television commercials for this assignment. Choose commercials that...
-
1. Consider the Algorithm ARRAYFIND, given below, which searches an array A for an element x. Input: An element x and an n-element array, A[0,..,n - 1]. (Indices start from 0.) Output: The index i...
-
PROMPT: Since Halloween just ended, I thought it would be fun to look at some statistics. Visit the link below...Is the sample size for this survey large enough? What else would you want to know...
-
Continuation of Exercise 4-83. (a) What is the probability that the first major crack occurs between 12 and 15 miles of the start of inspection? (b) What is the probability that there are no major...
-
Is sustainability a viable concept for Americas businesses?
-
How does Disneys cross-platform franchising help create sustainable competitive advantage?
-
Over 25 years ago, Tim and Nina Zagat began publishing leisure guides containing reviews of restaurants. Today, the renowned Zagat guides still contain reviews of restaurants, but they also rate...
-
Consider the following observations: a. Fit the nonlinear regression model \[ y=\theta_{1} e^{\theta_{2} x}+\varepsilon \] to these data. Discuss how you obtained the starting values. b. Test for...
-
For the models shown below, determine whether it is a linear model, an intrinsically linear model, or a nonlinear model. If the model is intrinsically linear, show how it can be linearized by a...
-
Sketch the expectation function for the logistic growth model (12.34) for \(\theta_{1}=1, \theta_{3}=1\), and values of \(\theta_{2}=1,4,8\), respectively. Overlay these plots on the same \(x-y\)...
Study smarter with the SolutionInn App