Data Review

Data Review

complete the data review exercise and answer the questions below using the attached data, dummy study design and partial case report form.  You can attach spreadsheets to show your work. Please be aware that this represents unclean data. Please respond no later than Thursday August 4th.

How many female subjects did not have a pregnancy test performed on the day of vaccination 1 or vaccination 2? Please explain how you reached this answer

How many subjects were not dosed on the same date as the date of visit? Please explain how you reached this answer

Using a pivot table summarize by SOC the number of subjects who experienced  related and unrelated events

How  many subjects had visit 2 performed out of window? Please explain how you reached this answer

Which project(s) to accept based on the cash flow forecasts

Which project(s) to accept based on the cash flow forecasts

Senior management asks you to recommend a decision on which project(s) to accept based on the cash flow forecasts provided.
Relevant information:
1. The firm uses a 3-year cutoff when using the payback method.
2. The hurdle rate used to evaluate capital budgeting projects is 15%.
The cash flows for projects A, B and C are provided in attachment below.
1. Assume the projects are independent and answer the following:
–Calculate the payback period for each project.
–Which project(s) would you accept based on the payback criterion?
Calculate the internal rate of return (IRR) for each project.
–Which projects would you accept based on the IRR criterion?
Calculate the net present value (NPV) for each project.
–Which projects would you accept based on the NPV criterion?
2. Assume the projects are mutually exclusive and answer the following:
Which project(s) would you accept based on the payback criterion?
Which projects would you accept based on the IRR criterion?
Which projects would you accept based on the NPV criterion?

Which project(s) to accept based on the cash flow forecasts

Which project(s) to accept based on the cash flow forecasts

Senior management asks you to recommend a decision on which project(s) to accept based on the cash flow forecasts provided.
Relevant information:
1. The firm uses a 3-year cutoff when using the payback method.
2. The hurdle rate used to evaluate capital budgeting projects is 15%.
The cash flows for projects A, B and C are provided in attachment below.
1. Assume the projects are independent and answer the following:
–Calculate the payback period for each project.
–Which project(s) would you accept based on the payback criterion?
Calculate the internal rate of return (IRR) for each project.
–Which projects would you accept based on the IRR criterion?
Calculate the net present value (NPV) for each project.
–Which projects would you accept based on the NPV criterion?
2. Assume the projects are mutually exclusive and answer the following:
Which project(s) would you accept based on the payback criterion?
Which projects would you accept based on the IRR criterion?
Which projects would you accept based on the NPV criterion?

Which project(s) to accept based on the cash flow forecasts

Which project(s) to accept based on the cash flow forecasts

Senior management asks you to recommend a decision on which project(s) to accept based on the cash flow forecasts provided.
Relevant information:
1. The firm uses a 3-year cutoff when using the payback method.
2. The hurdle rate used to evaluate capital budgeting projects is 15%.
The cash flows for projects A, B and C are provided in attachment below.
1. Assume the projects are independent and answer the following:
–Calculate the payback period for each project.
–Which project(s) would you accept based on the payback criterion?
Calculate the internal rate of return (IRR) for each project.
–Which projects would you accept based on the IRR criterion?
Calculate the net present value (NPV) for each project.
–Which projects would you accept based on the NPV criterion?
2. Assume the projects are mutually exclusive and answer the following:
Which project(s) would you accept based on the payback criterion?
Which projects would you accept based on the IRR criterion?
Which projects would you accept based on the NPV criterion?

MATT

MATT

There are several difficult concepts in Business Calculus.  Pick a concept, theory, or idea that you found particularly difficult or challenging.  Use your skills of surfing the web and find a video that explains that particular concept, theory, and/or idea.
please post the video as well.

1.  State concept, theory, and/or idea.

2.  Why it was a difficult concept for you.

3.  How the video was helpful.

Question

Question

Over the past decade, ABC Manufacturing has increased the number of safety inspections per month in hopes to decrease the number accidents on their production line.  Below is a list of how many inspections were conducted in a month and the corresponding number of accidents recorded.  Is there a correlation, and has this leadership decision been effective?

Inspections   Accidents

20                   181

24                  190

28                   167

40                    160

60                    120

64                  124

64                      118

68                    90

70                    94

72                     85

Question

Question

Over the past decade, ABC Manufacturing has increased the number of safety inspections per month in hopes to decrease the number accidents on their production line.  Below is a list of how many inspections were conducted in a month and the corresponding number of accidents recorded.  Is there a correlation, and has this leadership decision been effective?

Inspections   Accidents

20                   181

24                  190

28                   167

40                    160

60                    120

64                  124

64                      118

68                    90

70                    94

72                     85

discussion

discussion

Data Collection Practice

A maker of energy drinks is considering abandoning can containers and going exclusively to bottles because the sales manager believes customers prefer drinking from bottles. However, the vice president in charge of marketing is not convinced the sales manager is correct. Investigate this issue using statistical analysis.

1. Explain which data collection method you would use and what procedures you would follow to apply this method to this situation.
2. Propose which level of data measurement applies to the data collected. Justify your answer.
3. Determine whether the data is qualitative or quantitative.
4. Submit your work in a Word document.

discussion

discussion

Data Collection Practice

A maker of energy drinks is considering abandoning can containers and going exclusively to bottles because the sales manager believes customers prefer drinking from bottles. However, the vice president in charge of marketing is not convinced the sales manager is correct. Investigate this issue using statistical analysis.

1. Explain which data collection method you would use and what procedures you would follow to apply this method to this situation.
2. Propose which level of data measurement applies to the data collected. Justify your answer.
3. Determine whether the data is qualitative or quantitative.
4. Submit your work in a Word document.

Help Me!

Help Me!

1. Activity: Capital Budgeting Practice
Complete the following and submit it in a Word document. Be sure to show your process and calculations:

1. Assume you have just retired as the CEO of a successful company. A major publisher has offered you a book deal. The publisher will pay you \$1 million up front if you agree to write a book about your experiences. You estimate that it will take three years to write the book. The time you spend writing will cause you to give up speaking engagements amounting to \$500,000 per year. You estimate your opportunity cost to be 10%.
• Should you accept this deal? Plot a diagram that measures NPV (on the y-axis) vs. discount rate (on the x-axis) to solve this problem. (Hint: Have your scale on the x-axis go to 50% (discount rate)).
• Determine the IRR for this deal. (Hint: IRR is the point at which NPV = 0)
2. Suppose you inform the publisher that it needs to sweeten the deal before you will accept it. The publisher offers \$550,000 advance and \$1,000,000 in four years when the book is published.
• Should you accept or reject the new offer?  Again, plot a diagram that measures NVP (on the y-axis) vs. discount rate (on the x-axis) to solve this problem.  (Hint: Have your scale on the x-axis go to 50% (discount rate)).
• Determine the IRRs for this deal (Hint: There are two IRRs for this problem).
• Discuss if the IRR rule for making budgetary decisions can be used in this case.
3. Finally, you are able to get the publisher to increase your advance to \$750,000, in addition to the \$1 million when the book is published in four years.
• Should you accept or reject this new offer?  Again, plot a diagram that measures NVP (on the y-axis) vs. discount rate (on the x-axis) to solve this problem. (Hint: Have your scale on the x-axis go to 50% (discount rate)).
• Determine the IRR for this deal.
4. State three conclusions regarding the use of IRR vs. NPV that you can make from questions 2–4. Which is the stronger method to use (IRR or NPV), and why?