Question: Not just the answer but the solution also, please! Thank you so much CASE INFORMATION Section 1. Incremental Revenues and Cost Savings Craig Jones, the

Not just the answer but the solution also, please! Thank you so muchNot just the answer but the solution also, please! Thank you somuch CASE INFORMATION Section 1. Incremental Revenues and Cost Savings Craig Jones,

CASE INFORMATION 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 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 Forecasted Labor Cost Sales Revenue in S&R Office 19,574,000.00 978,700.00 19,965,480.00 998,274.00 20,364,789.60 1,018,239.48 20,772,085.39 1,038,604.27 21,187,527.10 1,059,376.35 21,611,277.64 1,080,563.88 22,043,503.19 1,102,175.16 22,484,373.26 1,124,218.66 22,934,060.72 1,146,703.04 23,392,741.94 1,169,637.10 REQUIREMENTS: 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 Forecasted Labor Cost in S&R Office Incremental Project Revenue Year 2021 2022 2023 Labor Cost Savings ? ? ? ? 2024 2025 2026 2027 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 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 ? ? ? ? ? ? ? ? ? ? ? 2028 2029 2030

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!