section 1 and how should I put it into excel please

Section 1. Incremental Revenues and Cost Savings Craig Jones, the owner of Jones' Hotels (20 mid-size properties) is considering to replace the property management system (PMS) used in his hotels. IT department has been in search for a while for a cost-effective and efficient PMS to increase sales revenue and reduce labor cost. Recently, they have recommended Craig Jones a new sytem, Ultra PMS. Craig and his management team must evaluate the feasibility of this project. Consistent with all previous technology investments, no salvage value is presumed from the disposition of the proposed PMS at the end of its economic life of 10 years. Below is a cost break down of the new PMS rollover accross 20 properties of the company, if the company management decides to invest in this project: One Time Costs Initial Investment Cost $ 3,425,450 Annual Recurring Costs (Incremental) Annual system maintenance and updates Annual training and technical support Total Annual Recurring Costs $ $ $ 78,296 58,722 137,018 The sales and reservation team predicts that annual room sales revenue can be increased by 6% (incremental revenue) if the Ultra PMS is acqui They predict that labor cost in the sales and reservations office can be reduced by 7.5% each year (labor cost savings). Below is the most recent forecasts for room sales revenue and labor cost in the sales and reseravations office: The sales and reservation team predicts that annual room sales revenue can be increased by 6% (incremental revenue) if the Ultra PMS is acquired. They predict that labor cost in the sales and reservations office can be reduced by 7.5% each year (labor cost savings). Below is the most recent forecasts for room sales revenue and labor cost in the sales and reseravations office: Year 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Forecasted Room Sales Revenue 19,574,000.00 19,965,480.00 20,364,789.60 20,772,085.39 21,187,527.10 21,611,277.64 22,043,503.19 22,484,373.26 22,934,060.72 23,392,741.94 Forecasted Labor Cost in S&R Office 978,700.00 998,274.00 1,018,239.48 1,038,604.27 1,059,376.35 1,080,563.88 1,102,175.16 1,124,218.66 1,146,703.04 1,169,637.10 The goal of this analysis is to help Craig Jones decide whether the proposed PMS project is financially sound or not. To analyze whether the project is sound, you are required to complete a set of tasks provided below. You need to use the information provided and use Excel to complete all tasks. Please use the templates and space provided for your answers. Below are the required tasks to be completed: Required Tasks 1 Using the sales revenue and labor cost forecasts in the S&R office, calculate the incremental annual revenues and labor cost savings from the proposed PMS project. Please use the columns provided for your calculations. Current Sales Revneue and Labor Costs in the Sales and Reservations (S&R) Office Labor Cost Savings ? Year 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Forecasted Room Sales Revenue 19,574,000.00 19,965,480.00 20,364,789.60 20,772,085.39 21,187,527.10 21,611,277.64 22,043,503.19 22,484,373.26 22,934,060.72 23,392,741.94 Incremental Forecasted Labor Cost in S&R Office Project Revenue ? 978,700.00 ? 998,274.00 ? 1,018,239.48 ? 1,038,604.27 ? 1,059,376.35 ? 1,080,563.88 ? 1,102,175.16 ? 1,124,218.66 ? 1,146,703.04 ? 1,169,637.10