System analysis and design In this assignment, we have a website where we can book a flight for air transportation. we are going to develop our website by allowing the customers to book hotels additional to booking flights. Now for the Feasibility Study, economic part, we have to create Costs and Benefits of adding reserving hotel to our system.

Can you please create the Cost and Benefit excel of five years for this development?

I want you to summarize how much will be the cost of developing the system and how much will be the benefits within 5 years.

i will show you an example:

Increased sales Total Benefits PV of Benefits PV of All Benefits Domain Name Marketing Total Costs PV of Costs PV of All Costs Total Project Benefits-Costs Yearly NPV Cumulative NPV Return on Investment Break-Even Point 2020 15000 15000 14500 14500 35 45000 45035 43723 43723 -30035 -29160 -29160 2021 16500 16500 15900 30400 35 0 35 33 43756 16465 15520 -13640 2022 18150 18150 17650 48050 35 0 35 33 43789 18115 16578 2938 90.20% 2024 2025 Total 19965 21961.5 19965 21961.5 18900 20400 66950 87350 87350 35 35 0 0 35 35 33 33 43822 43855 43855 19930 21926.5 17707 18914 20645 39559 39559 2.82 years Increased sales Total Benefits PV of Benefits PV of All Benefits Domain Name Marketing Total Costs PV of Costs PV of All Costs Total Project Benefits-Costs Yearly NPV Cumulative NPV Return on Investment Break-Even Point 2020 15000 15000 14500 14500 35 45000 45035 43723 43723 -30035 -29160 -29160 2021 16500 16500 15900 30400 35 0 35 33 43756 16465 15520 -13640 2022 18150 18150 17650 48050 35 0 35 33 43789 18115 16578 2938 90.20% 2024 2025 Total 19965 21961.5 19965 21961.5 18900 20400 66950 87350 87350 35 35 0 0 35 35 33 33 43822 43855 43855 19930 21926.5 17707 18914 20645 39559 39559 2.82 years