Monte Carlo Method

 

Assignment Preparation: Activities include completing the SkillSoft® courses, watching the Lynda.com® videos, independent student reading, and research.

 

• Complete the Skillsoft^® course, “Basic Statistics and Graphical Methods for Six Sigma.”
• Complete the Skillsoft^® course, “Risk Management: Assessing Risk.”
• Watch the Lynda.com video, “Up and Running with Excel What-If Analysis.”
• Watch the Lynda.com video, “What do you need to know to be an analytics professional?”
• Watch “Performing Monte Carlo Simulation” of the Lynda.com “Up and Running with Excel What-If Analysis,” video.

 

Assignment:

 

Recreate the simulation presented in the “Performing Monte Carlo Simulation” video.

 

Submit the Microsoft^® Excel^® spreadsheet along with a 1- to 2-page explanation on how the Monte Carlo tool can be used in risk assessment.

twenty students take a math test. The highest score is 98 points, and the range is 39. What is the lowest score?

For your final assignment in this course, you will create a project using the requirements outlined below. You may use your own place of business (preferred) or an existing business that will allow you to perform these exercises. Answers such as “Yes” or “No” are not sufficient to respond to these questions. Final Project Requirements Create an entire SDLC process that will bring added value to a business. Use of the following is mandatory: 1. Planning Phase a. Identify the project—what is it supposed to do? b. Determine the methodology to be used; describe, in detail, why you chose this methodology c. Define/determine business requirements and describe the techniques you will use to gather this information 2. Analysis Phase a. Describe how this project will bring added value to the business. This should be in the form of an actual presentation outline, such as one would read while doing a Power Point presentation to the Board i. Determine who the key players are ii. Describe any known or possible issues that might arise as to why the project will not be approved b. Along with the outline, prepare a Use Case diagram for the new system—ensure you consider staffing, budgets, training, maintenance, etc. 3. Design Phase a. Determine the hardware and software requirements i. Will the existing infrastructure support the project? 1. If not, describe in detail what will be needed. ii. Is new hardware required? iii. Is new software required? 1. If new software is required, how will it be obtained? 2. Is the existing database adequate? b. Create the Project work plan, complete with (projected) timelines using a Gantt chart. 4. Implementation Phase a. Describe how the system is to be implemented; Phased? Turn key? Mirrored? Parallel? b. Describe why the implementation you chose is the best for this project Make sure to include scholarly article to support your project and proper citations.

what is the volume of a shoe box 12 inches long, 6 inches wide, and 5 inches high

LASA 2—Genesis Capital Plan Report

The Genesis operations management team, nearing completion of its agreement with Sensible Essentials, was asked by senior management to present a capital plan for the operating expansion. The capital plan was not to be a wish list but an analysis of the necessary expenditures to successfully establish a fully equipped operating facility overseas.

In addition, senior management requested meaningful financial and operating metrics to ensure that the performance objectives for the facility were being met. The operations management team was given five days to accomplish the following:

1. Calculate the firm’s WACC.
2. Prepare and analyze each planned capital expenditure.
3. Evaluate, rank, and recommend the capital expenditures according to beneficial value to the organization, using evaluation tools NPV, payback, and IRR. Evaluation, ranking, and recommendations should be by category of expenditures. For example, facility, equipment 1, 2, and 3, and inspection.
4. Using the selected choices in part three, calculate the full cost of establishing a fully equipped facility. This would include the facility, equipment 1, 2, and 3, and inspection. In addition, calculate the payback, NPV, and IRR for the completed facility.
5. Construct and recommend between three and five metrics to measure the performance of the organization. At least one metric should be dividend decision-making driven.
6. Prepare an executive summary along with a separate document showing the calculations.

Following the example of the operations management team, do the following:

1. Download the Capital Budgeting spreadsheet, and compute the WACC for Genesis.
2. Using the information provided in the spreadsheet, analyze Genesis’s project options.
   Using the information provided, calculate the periodic and cumulative net cash flows for each potential project and its associated options. Please note that there are 5 projects (facility, equipment pieces 1, 2, and 3, and internal inspection) and that each project offers multiple configuration options (facility size, equipment type, etc.).
3. Evaluate, rank, and recommend a specific option for each capital project according to beneficial value to the organization, using evaluation tools NPV, payback, and IRR.
4. Construct and recommend between three and five metrics to measure the performance of the new operating strategy. At least one metric should reflect dividend policy as it relates to rewarding shareholders.
5. Prepare an executive summary describing your recommendations for each project and the overall cost, net cash flows, and expected returns of the operating configuration that you recommend. Be sure to justify your recommendations in terms of the investment criteria applied in Step 3 above. Be sure to report the full cost of the facility as it is configured per your recommendations. Present and justify your operating strategy performance metrics.

Your complete report should include all of your calculations as appendices (5 pages, or 1 page for each project).

Write a 5–6-page report in Word format. Apply APA standards to citation of sources. Use the following file naming convention: LastnameFirstinitial_M6_A2.doc.