Sky Taxi Project: Project Management, Gantt Charts, Financial Analysis

This project report provides a comprehensive analysis of a Sky Taxi project, detailing project planning, execution, and financial aspects. The project is broken down into various tasks, including material procurement, site mobilization, installation of essential systems (landing pads, fire sprinklers, air conditioning, and control equipment), VTOL craft testing, and communication setup. The report includes Gantt charts, AOA diagrams, and critical path analysis to determine the project's timeline and dependencies. Financial calculations, such as cash flow statements, expense breakdowns, and rate per kilometer are also presented, alongside ratio analysis to evaluate the company's performance and financial position. The project is estimated to be completed in approximately 7.5 years, with a critical path duration of 91 weeks. The analysis includes various tables with duration, start and finish dates of each task.

Project-sky taxi
1

Table of Contents
INTRODUCTION...........................................................................................................................3
TASK 1........................................................................................................................................3
TASK 2........................................................................................................................................8
TASK 3........................................................................................................................................9
TASK 4......................................................................................................................................10
TASK 5......................................................................................................................................11
TASK 6......................................................................................................................................12
TASK 7......................................................................................................................................12
TASK 8......................................................................................................................................12
TASK 9......................................................................................................................................12
CONCLUSION..............................................................................................................................14
2

INTRODUCTION
In very project it is required to proper planning and breaking of project so that activities are
specified properly. It enables in preparing of schedule and assigning of start and end date of each
activity. For that it requires project management to be followed in it. It is process of leading team
to attain project goals. There are various tools available of project management which can be
used. But it entirely depends on nature and type of project.
This report is about a sky taxi project which is being undertaken. It will discuss about ghantt
chart and AOA diagram of project. besides critical path will be developed and some financial
calculation is done.
TASK 1
Task Name Duration Start Finish
Confirm order all materials
from the design bill of
quantities
2 wks Fri 1/1/21 Thu 1/14/21
Catalogue and deliver all
materials to appropriate
sites
3 wks Fri 1/15/21 Thu 2/4/21
Mobilise personnel to site
office(s) 2 wks Fri 2/5/21 Thu 2/18/21
Install the landing pads and
pressure sensors to
specifications
3 wks Fri 2/19/21 Thu 3/11/21
Install fire sprinkler systems
at docking stations 4 wks Fri 3/12/21 Thu 4/8/21
Install air conditioning and
control systems 5 wks Fri 4/9/21 Thu 5/13/21
Install all control and
signaling equipment 6 wks Fri 5/14/21 Thu 6/24/21
Take delivery and test all
the ten VTOL craft 4 wks Fri 6/25/21 Thu 7/22/21
Install the required control
equipment for the solar
panel
4 wks Fri 7/23/21 Thu 8/19/21
Ensure all sensor data is
being received back at the
control room
15 wks Fri 8/20/21 Thu 12/2/21
Work with CASA to limit the
VTOL rotor blade speed for
noise
6 wks Fri 12/3/21 Thu 1/13/22
3

Test the VTOL craft under
rotor failure and write up
emergency
4 wks Fri 1/14/22 Thu 2/10/22
Final testing commissioning
and formal handover 5 wks Fri 2/11/22 Thu 3/17/22
4

Table 6
Task Name Duration Start Finish
Confirm order all materials
from the design bill of
quantities
2 wks Fri 3/18/22 Thu 3/31/22
Catalogue and deliver all
materials to appropriate
sites
2 wks Fri 4/1/22 Thu 4/14/22
Mobilise personnel to site
office(s) 2 wks Fri 4/15/22 Thu 4/28/22
Install all security cameras 10 wks Fri 4/29/22 Thu 7/7/22
Install the optic fiber cable 14 wks Fri 7/8/22 Thu 10/13/22
Install the router system 7 wks Fri 10/14/22 Thu 12/1/22
Installation of mobile
towers 5 wks Fri 12/2/22 Thu 1/5/23
Install GSM5 mobile
equipmen 6 wks Fri 1/6/23 Thu 2/16/23
Setup the backup comms 3 wks Fri 2/17/23 Thu 3/9/23
Install the security
microphone 5 wks Fri 3/10/23 Thu 4/13/23
Install the remotely
controlled 6 wks Fri 4/14/23 Thu 5/25/23
Final testing commissioning 5 wks Fri 5/26/23 Thu 6/29/23
5

Table 7
Task Name Duration Start Finish
Confirm order all materials 3 wks Fri 6/30/23 Thu 7/20/23
Prepare final as built
drawing 3 wks Fri 7/21/23 Thu 8/10/23
Mobilise personnel to site
office(s) 4 wks Fri 8/11/23 Thu 9/7/23
6

Relocate existing electrical
infrastructure 4 wks Fri 9/8/23 Thu 10/5/23
Upgrade a 66kV substation 3 wks Fri 10/6/23 Thu 10/26/23
Install all the solar array
panels 4 wks Fri 10/27/23 Thu 11/23/23
Terminate the diverse 66kV 4 wks Fri 11/24/23 Thu 12/21/23
Equip the switch room 5 wks Fri 12/22/23 Thu 1/25/24
Install all sub switchboards 4 wks Fri 1/26/24 Thu 2/22/24
Install the interruptible
power supply 4 wks Fri 2/23/24 Thu 3/21/24
Install all the wiring
reticulation 3 wks Fri 3/22/24 Thu 4/11/24
Install the protection 4 wks Fri 4/12/24 Thu 5/9/24
Install all LED lighting 6 wks Fri 5/10/24 Thu 6/20/24
Install lightning and surge
protection 8 wks Fri 6/21/24 Thu 8/15/24
Test primary and secondary
power supply. 8 wks Fri 8/16/24 Thu 10/10/24
Test that all lighting 3 wks Fri 10/11/24 Thu 10/31/24
Final testing commissioning 8 wks Fri 11/1/24 Thu 12/26/24
Install all landing pad lights 3 wks Fri 12/27/24 Thu 1/16/25
Test that all lighting and
security 4 wks Fri 1/17/25 Thu 2/13/25
Final testing commissioning 6 wks Fri 2/14/25 Thu 3/27/25
7

TASK 2
a) Critical path
duration = 91 weeks
8

b) 32 weeks
c) 31 weeks
d) 49 weeks
e) 21 weeks
TASK 3
Task Name Duration Start Finish
Prepare concept plan broad
scope of the project 14 wks Fri 1/1/21 Thu 4/8/21
Seek Public Consultation 8 wks Fri 4/9/21 Thu 6/3/21
Prepare Business Case 15 wks Fri 6/4/21 Thu 9/16/21
Commence and Close the
Tender Period 15 wks Fri 9/17/21 Thu 12/30/21
Analyse and award contract 13 wks Fri 12/31/21 Thu 3/31/22
Analyse and award contract 22 wks Fri 4/1/22 Thu 9/1/22
9

Ordering of all materials 18 wks Fri 9/2/22 Thu 1/5/23
Ordering of the ten VTOL
crafts 14 wks Fri 1/6/23 Thu 4/13/23
Completion of the
Construction Phase 38 wks Fri 4/14/23 Thu 1/4/24
Completion of the
Construction Phase – 221 wks Fri 1/5/24 Thu 3/30/28
Final Commissioning 20 wks Fri 3/31/28 Thu 8/17/28
TASK 4
The project completion time is around 7.5 years.
a) weeks to complete 5 docking stations will be 398 weeks
b) Total annual revenue
10

TASK 5
Cash Inflows
Distance Passengers Total km
Fare 3 per
km
Cash Inflows
To Perth City 15 210000 3150000 9450000
To Fremantle 30 65000 1950000 5850000
To Karryinup 14 29055 406770 1220310
To Booragoon 16 19000 304000 912000
Total Inflows from taxi 17432310
Cash Flow statement
Loan 4000000
Sales 17432310
Revenue from Advertising 200000
Total Inflows 21632310
Cash Outflows
Operation and Maint cost 10000000
Power supply and usage
cost 4000000
Salaries and wages 200000
Interest 750000
Total Outflows 14950000
11

Net Flow 6682310
TASK 6
Total expenses per year 14875000
Loan repayment year 2466666.7
Total Kms 5810770.0
Expense per km 3.0
Rate/ Km 2.98
Workings
Loan 25000000
Years 15
Loan repayment per year 1666666.7
Interest @ 3.2% 800000.0
Total 2466666.7
Rate /km = 2.98
TASK 7
VTOL to be purchased
Loan 25000000.00
Years 15.00
Loan repayment per year 1666666.67
12

Interest @ 3.8% 950000.00
Total 2616666.67
Total expenses per year 14875000
Loan repayment year 2616666.66666667
Total Kms 5810770
Expense per km 3.01021494
Rate/ Km 3
Loan 25000000
Total Kms (one way) 5810770
Number of VTOL 4.3023557979
For 2 ways 8.6047115959
Number of VTOL 9
TASK 8
Total kms 5810770
Rate/ Km 3
Total Inflows 17432310
Total expenses per year 14875000
Net Flow 2557310
13

Year 1 2 3 4 5 6 7
Loan 25000000
2500000
0
2500000
0
2500000
0
2500000
0
2500000
0
2500000
0
Maturity period 13 13 13 13 13 13 13
Yearly repayment 2400000 2500000 2450000 2300000 2430000 2350000 2480000
The interest rate 3.53% 4.21% 3.87% 2.83% 3.73% 3.18% 4.07%
TASK 9
AAA BBB
Particulars Formula 2020 2019 2020 2019
Profitability Ratios
Return on capital
employed
Net
operating
profit/Empl
oyed
Capital 52.16% 33.68% 24.93% 36.47%
Employed Capital
Total assets
– Current
liabilities 5537 4023 4167 3935
Net operating
profit 2888 1355 1039 1435
Return on Equity
Net Income
/
Shareholde
r's Equity 65.55% 44.66% 35.62% 48.89%
14

Net Income 2888 1355 1039 1435
Shareholder's
Equity 4406 3034 2917 2935
Gross profit
margin
Total Sales
–
COGS/Tota
l Sales 19.66% 16.22% 15.79% 17.78%
COS 28200 25426 29105 24538
Sales 35100 30350 34564 29845
Net profit margin
Operating
Income/
Net Sales 8.23% 4.46% 3.01% 4.81%
Net Income 2888 1355 1039 1435
Revenues 35100 30350 34564 29845
Liquidity Ratios
Current assets 5330 3003 3505 3202
Current liabilities 4000 3113 3545 3400
Inventory 139 127 142 131
Quick assets 5191 2876 3363 3071
Current ratio
Current
assets /
current
liabilities 1.33 0.96 0.99 0.94
Quick ratio Current
assets -
1.30 0.92 0.95 0.90
15

(stock +
prepaid
expenses)
Solvency Ratio
Long-term debt 1131 989 1250 1000
Shareholder's equity 4406 3034 2917 2935
Debt-equity ratio 0.26 0.33 0.43 0.34
The performance and position of the companies could be evaluated using ratio analysis. It
could be evaluated from the above ratio analysis. Profitability ratios are used for measuring the
performance of company and to identify whether the company is efficiently managing the
resources to generate returns or not.
The ROCE of AAA has raised from 33.68% to over 52.16% and of BBB from 36.47% to
24.93%. It could be seen that there has been significant rise in the return over capital employed
due to increase in profit of AAA where the profits of BBB have declined. ROE of AAA has risen
where of BBB has fallen. This shows that performance of BBB is degrading as compared with
the last year and that of AAA is improving. Gross profit margins and the net profit margins of
company BBB are going downwards where of AAA are showing growth. It could be evaluated
that company AAA is becoming more efficient and growing in terms of profitability that reflects
that it is more efficiently utilising its resources.
The liquidity position of company AAA is becoming strong and where of BBB has
remained below the required industry standard. Liquidity position reflects that the company is
able to carry out the operations of business efficiently without taking funds from external
sources. In the case of AAA it will not be required to provide take funds from outside and due to
this it will be able to provide services at lower prices as compared with BBB that is not having
enough funds and the interest cost will increase the prices.
Solvency ratio also shows that AAA has reduced the debts from last year. On the other
BBB has increased the debts which shows that it is not able to manage the operation from the
cash flows generated from company.
16

Therefore, due to the above reasons AAA should be chosen as it will be more beneficial
for the entity.
CONCLUSION
From above it is summarised that the sky taxi project will be completed within 7.5 years
with all docking stations. The project is broken down into 3 parts that is mechanical, IT and
communication and electrical. Moreover, the duration of critical path is 91 weeks. The cash
inflow is fare, etc. of taxi and outflow are payment of tax, wages, etc. Also, a master plan is
developed as well of entire project. however, there are certain activities like switch room,
installing of power supply, and other which can be delayed without affecting completion time of
project.
17