# Data-driven decision making using microsoft excel this assignment

[ad_1]

1. Channels of Communication
• It has been estimated that project managers spend up to 90% of their time communicating and your position at Roto Air is typical. Calculate the number of possible channels of communication if the project team were to grow to nine members, Important: show your work.
• The total number of stakeholders, including the project team, is estimated at 75 people. Calculate how many more possible channels of communication the additional stakeholders beyond the team members represent. Important: show your work.
2. Benefit Cost Ratio (BCR)
• Roto Air plans to spend \$1,000,000 on this project, resulting in a total savings of \$2,500,000 over the life of the project. Calculate the Benefit Cost Ratio. Important: show your work. Ignore any effects of the time value of money.
• Roto Air also considered another project that would have partially satisfied their needs. It would have required a \$750,000 investment and would result in a savings of \$125,000 per year for 10 years. Calculate the Benefit Cost Ratio. Important: show your work. Ignore any effects of the time value of money.
• Comparing only the BCRs, explain which project should Roto Air should have chosen. Ignore any effects of the time value of money.
3. Payback Period
• Calculate the payback period for the \$1,000,000 investment shown above. Important: show your work. Ignore any effects of the time value of money.
• Calculate the payback period for the \$750,000 investment shown above. Important: show your work. Ignore any effects of the time value of money.
• Comparing only on the payback periods, explain which project should Roto Air have chosen. Ignore any effects of the time value of money.
4. Net Present Value (NPV)
• Calculate the Net Present Value of Roto Air’s \$1,000,000 investment with a \$250,000 annual savings for 10 years when the interest rate averages 3% annually. Important: show your work.

Carefully review the Grading Rubric for the criteria that will be used to evaluate your assignment.

Description:

Total Possible Score: 10.00

### Calculates the Correct Answers for Problems

Total: 6.00

Distinguished – Calculates the correct answers for all four problems.

Proficient – Calculates the correct answers for three of the problems.

Basic – Calculates the correct answers for two of the problems.

Below Expectations – Calculates the correct answer for one of the problems.

Non-Performance – The calculations are either nonexistent or lack the components described in the assignment instructions.

### Utilizes a MS Excel Spreadsheet, Shows Work, and Provides Sources for the Equations Used

Total: 2.00

Distinguished – Utilizes a MS Excel spreadsheet, shows all work, and provides sources for the equations used.

Proficient – Utilizes a MS Excel spreadsheet, shows most work, and provides sources for some of the equations used.

Basic – Utilizes a MS Excel spreadsheet, shows some work, and provides sources for some of the equations used.

Below Expectations – Does not utilize a MS Excel spreadsheet, shows some work, and provides sources for some of the equations used.

Non-Performance – The spreadsheet, work, and sources are either nonexistent or lacks the components described in the assignment instructions.

### Quantitative Literacy: Representation

Total: 1.00

Distinguished – Proficiently converts pertinent information into an insightful mathematical representation in a way that contributes to a further or deeper understanding.

Proficient – Competently converts pertinent information into an appropriate mathematical representation.

Basic – Converts information, but the outcomes are only partially appropriate or accurate.

Below Expectations – Attempts to convert information, but the outcomes are inappropriate or inaccurate.

Non-Performance – The assignment is either nonexistent or lacks the components described in the instructions.

### Quantitative Literacy: Calculation

Total: 1.00

Distinguished – All calculations are correct and adequately all inclusive. Calculations are presented clearly and succinctly.

Proficient – Calculations are mostly accurate and adequately comprehensive to solve the problem.

Basic – Calculations are somewhat accurate and/or represent only a limited number of the calculations required to solve the problem.

Below Expectations – Calculations were attempted but are incorrect and are not comprehensive.

Non-Performance – The assignment is either nonexistent or lacks the components described in the instructions.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
\$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Australia Assessments
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Business and administrative studies
Good work.
Customer 463053, June 20th, 2022
Military
good job
Customer 456821, May 18th, 2022
Military
Good work.
Customer 456821, May 11th, 2022
Psychology
Thank you.
Customer 463363, September 23rd, 2022
Business and administrative studies
Excellent work!
Customer 452719, June 11th, 2022
Psychology
The paper was beautifully written with minor errors. Once again my expectations have been exceeded. Thank you to the writer for a beautifully written paper and thank you to the customer service department for ensuing the work of the highest quality.
Customer 452455, April 29th, 2023
Military
good job
Customer 456821, March 28th, 2022
Military
Very good job, thanks.
Customer 456821, December 20th, 2022
Finance/Acc related
Great job!
Customer 460073, August 14th, 2022
Psychology
Excellent.
Customer 463097, June 23rd, 2022
Computer science
Even though I received the paper on time, the person that I received the paper from kept telling that did submit the paper to me and there no link available to me to download and revise the paper until excessive close to the deadline. This is not good business, considering that there at least a week to write not to mention the support kept telling me that I was submitted when it wasnt...
Customer 452515, April 9th, 2020
Leadership Studies
It was really well written!
Customer 453975, February 28th, 2020
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat