Solution-Data-driven decision making using microsoft excel

Data-driven decision making using microsoft excel

Assignment Help Business Management

Reference no: EM131091458

Data-Driven Decision Making Using Microsoft Excel [CLOs: 7, 9]

This assignment must be completed and submitted using a Microsoft Excel spreadsheet (.xls). Provide a source for each equation you use. Sources must be listed at the bottom of the spreadsheet. No title page or additional formatting is required.

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.
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.
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.
- 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.
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.

Reference no: EM131091458

Questions Cloud

Positive integer number : There is a homework to create a program that takes in a positive integer number from the user and searches for the number with the highest sum of divisors from the 1 to the user imputed number. The program then has to output the number in this range ..

Create a graphic organizer depicting : Assume that you are the owner of CDA Elevators a Large Regional Elevator Company that constructs and repairs elevators for new and existing construction. Assume further that you are trying to decide if you want to extend your business by adding an..

Consistence appraisal for the task being referred to : You are an outsider assessor, contracted to play out a consistence appraisal for the task being referred to. You are to be recognized for revealing this disaster, yet precisely how could you have been able to you isn't that right? Where did you be..

Reduce the government budget deficit : The US government decides to reduce the government budget deficit by increasing taxes and keeping government expenditures at the existing level. What are the effects of increasing taxes in the short and medium run for the US economy?

Data-driven decision making using microsoft excel : This assignment must be completed and submitted using a Microsoft Excel spreadsheet (.xls). Provide a source for each equation you use. Sources must be listed at the bottom of the spreadsheet. No title page or additional formatting is required.

What good for wal-mart : Is Walmart Good for America? Read John Miller, “What’s Good for Wal-Mart” (article 4.4 in Real World Micro). Are lower prices at Wal-Mart necessarily good? Would it be a good or bad thing if Wal-Mart raised wages and raised prices? What would you nee..

Describe a client reward system such as a loyalty program : What are some different ways that the hospitality, travel or tourism industries promote products and services? Describe a client reward system such as a loyalty program that you have encountered in the service industry

Describe how you plan to apply at least two strategies : Discuss two (2) ways in which this course has helped you adjust to being a college student. Then describe how you plan to apply at least two strategies to other areas of your life.

How population genetics relates to your topic : A balanced discussion of bioethical issues related to genetic analyses and manipulation concerning your topic. Be sure to provide multiple perspectives and take a pro or con position on the issue.

User Account

All Pages

Data-driven decision making using microsoft excel

Reference no: EM131091458

Reference no: EM131091458

Questions Cloud

Reviews

Write a Review

Business Management Questions & Answers

Caselet on michael porter’s value chain management

Mountain man brewing company

Mountain man brewing company

Analysis of the case using the doing ethics technique

Affiliations and partnerships

Innovation-friendly regulations

Effect of regional and corporate cultural issues

Structure of business plan

Identify the purposes of different types of organisations

Entrepreneur case study for analysis

Forecasting and business analysis

Educational instructional leadership

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT