Develop two dimensional spreadsheet that contains constants

Assignment Help Other Subject
Reference no: EM132296321

Risk Management for Projects Assignment -

Module Aims - The module aims are to:

  • To develop a critical awareness of uncertainty and risk management theories and applications as an aid to decision making.
  • Place uncertainty and risk management within the decision making context of construction projects.

Learning Outcomes - On successful completion of the module the learner, operating autonomously and creatively, should be able to:

  • Demonstrate a critical understanding of theories and practical application of uncertainty and risk management systems and how they support the decision making process.
  • Design risk management systems that effectively identify, analyse and respond to project risk factors.
  • Develop numerical models that inform decision makers by identifying and measuring variables and simulating the decision and critically interpreting the models' outputs.
  • Communicate risks effectively and efficiently using suitable terminology.
  • Demonstrate self-reflection and the ability to identify and manage their own personal and professional development needs.

Assessment - The assessment for this module is made up of two problems and a reflective journal.

Problem 1: a qualitative scenario based project

Design and test a risk management system

An internal audit of your organisation has assessed itself to be at a risk maturity level 1 - "Ad Hock" (in accordance with the Risk Management Maturity Model (RMMM) from Risk Management Maturity Level Development April 2002 see the "assignments" section in Blackboard). The managing director has tasked you with the job of designing a risk management system that if implemented within the organisation would bring your organisation up to a maturity level 3 - "Repeatable" in the short term with the aim of level 4 - "Managed" in the longer term. The managing director has stressed that the system you design must be effective and efficient.

Once you have designed the system you are then to demonstrate its workings by applying it to the following project.

Project - Office development (shell and core) on a brownfield site (adjacent to the Thames) in docklands, London. Approx site area 14,500m2. A total pre-let has been agreed (tenant responsible for fit out). Basement car parking for 500 cars. Site access by road via University Way, access restricted by railway line. Site near London City Airport but not on the flight path. Initial discussions with local planning authority suggest they would not consider more than four stories high and that the building should not occupy more than 75% of the site. The Client wished to have a usable floor area of min. of 30,000m2. Design & Build is the Client's preferred procurement route. The scheme has just completed feasibility stage.

You are the project management team working for the Client and he has identified the following targets.

  • Handover to tenant 52 weeks from site possession.
  • Design costs and construction budget £40 million.
  • Must exceed planned government targets is respect to Co2 emissions in the building's construction and subsequent operations.
  • Meet specified quality criteria regarding the external aesthetics 'Striking Modern Architectural style'.
  • Meet functional performance set by tenant in regards flexibility and adaptability.

Problem 2: a quantitative simulation

Risk analysis simulation - Develop a two dimensional spreadsheet (the model) that contains mixtures of constants and variables. Compile data where possible for your input variables and identify distributions that reflects that data. Justify your selection. Using @RISK simulate the effect the selected distributions have on the outcome or outcomes and present the results using a variety of suitable graphs and reports. Critically interpret the results and comment on how the results could influence your risk management strategy.

Advice on developing the model. It is best to view the development of the model as an iterative process. Start with a simple speardsheet and add complexity as your understanding of the program, the inputs and outputs develop.

Try to avoid using Excel's functions in your model, use the basic formula.

Do not mix the model and the data; keep them both on separate sheets in the spreadsheets.

Specific Assessment Criteria - Along with the general assessment criteria listed above the following specific assessment criteria will be used in the assessment of this portfolio. Each criterion is allocated a percentage weighting to indicate its importance.

  • Quality and complexity of spreadsheet
  • Analysis of and identification of input distributions
  • Effective use of @RISK
  • Critical interpretation of output
  • Written and graphical presentation skills.

Note - Do only problem 2 Quantitative Simulation.

Attachment:- Assignment File.rar

Reference no: EM132296321

Questions Cloud

Podcast kent mcdonald about beyond requirements : listen to a podcast Kent McDonald about Beyond Requirements.
Role of creativity and innovation in frank successes-failure : What was the role of creativity and innovation in Frank's successes and failures?
Analysis and Design Definition in the BABOK : Analysis and Design Definition in the BABOK.
Negligent in manufacturing the deathtrap snow-blower : Can you successfully sue BigCorp? Why or why not? Does it matter whether BigCorp was negligent in manufacturing the “Deathtrap” snow-blower?
Develop two dimensional spreadsheet that contains constants : 7CNMN013W Risk Management for Projects Assignment - University of Westminster- WESTMINSTER BUISNESS SCHOOL, UK. Develop two dimensional spreadsheet
Healthcare industry definition and market analysis : Homework Assignment: Situational Analysis: Healthcare Industry Definition and Market Analysis
Southwest airlines-in different world : Return to HBS case reprint, "Southwest Airlines: In a Different World."
Identify service standards and best practice models : Elaborate on how to identify service standards and best practice models.
Developed monthly forecasts for family of products : A ?Juarez, Mexico, manufacturer of roofing supplies has developed monthly forecasts for a family of products.

Reviews

len2296321

4/29/2019 11:22:04 PM

Assignment is Quantitative Simulation on page 11 of attached PDF. A marking rubric for Problem 2 is posted on blackbard and appended to the handbook. The marking rubic will give you a greater insite into how this problem will be marked and it will form the basis of the feedback for this work once it has been marked. PLEASE NOTE: that the work is to be submitted on-line via Turnitin on Blackboard and the submission date is Tuesday 30th

len2296321

4/29/2019 11:21:59 PM

Assessment Criteria - Along with the general assessment criteria listed above the following specific assessment criteria will be used in the assessment of this journal. Each criterion is allocated a percentage weighting to indicate its importance. Clarity in presentation of events or issues. (25%) Honesty and self-assessment. (15%) Evidence of creative and critical thinking. (25%) Evidence of a willingness to revise ideas. (15%) Depth and detail of reflective account. (20%) A marking rubric for the reflective journal is posted on blackboard and appended to the handbook. The marking rubric will give you a greater insight into how this journal will be marked and will form the basis of the feedback for this work once it has been marked.

len2296321

4/29/2019 11:21:52 PM

Marking - The work, in the first instance, will be marked by Malcolm Smith. This mark will be subject to review by a second marker and the work may also be reviewed and inspected by the external examiners. Quality and complexity of spreadsheet. 15% Excellent - A multilayered, complex, appropriate model, clearly presented, explained and developed, with clear aims. The relationships between the variables / constants are clearly demonstrated. Analysis of, and identification of input distributions. 30% Excellent - In-depth critical discussion on the choices of the input distributions and their parameters, highlighting the distributions considered and reasons for selection or rejection.

len2296321

4/29/2019 11:21:46 PM

Effective use of @Risk. 10% Excellent - There is substantive evidence of effective use of the software with consideration being given to the various settings available. Critical interpretation of output. 30% Excellent - In-depth critical discussion on the interpretation of the output distributions and what they mean in terms of risk to the aims. You have fully engaged in the appropriate use of the statistical language. Written and graphical presentation skills. 15% Excellent - Presented in an innovative, creative, clear, logical manner fully utilising the appropriate outputs from the @Risk program. Evidence of extensive planning and summative evaluation.

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd