Develop And Solve Business Problems With Advanced Decision Modeling Techniques & Technical Report Writing - IT Assignment Help

Assignment 

Description
This assignment is designed to let you explore a simulation approach to choosing a set of projects to invest in, and then write up your findings in a technical report. As explained in Assessment Task 1, Acme Group Inc. is a multinational strategy consultancy with global headquarters in Melbourne, Australia. The company offers strategic solutions to its clients and has an annual revenue of $500M. In order to maintain its competitive position in the marketplace, Acme Group needs to continually look for opportunities to invest in new technologies. The Chief Information Officer, Jane Porter, is currently considering twelve technology proposals put forth by three divisions within the Group – Marketing, R&D, and HR. Each division has provided Jane with the capital expenditures required for each project over the next three years and the expected revenue to be generated by each project, but this time a number of the proposals are for joint projects. These joint projects are intended to be undertaken with partner organizations that Acme Group already has well-established strategic alliances. 

As before, Jane has an overall three-year budget of $100 million for the set of projects she approves, with a maximum of $40 million available in any one year.
Jane has decided to dispense with the idea of scalability. If she decides to invest in a project, then it will be to the full extent of the company’s ownership percentage. Jane has now tasked you with developing a spreadsheet?based decision model that she can use to explore the twelve investment alternatives and their associated risks. As a starting point, she wants you to develop a spreadsheet model using the Deterministic model worksheet provided in the assignment spreadsheet. This worksheet has four sections: Inputs, Decisions, Calculated values, and Summary values and Outputs.
Jane wants the spreadsheet to automatically update all tables and results each time she enters 0s and 1s in cells O26:O37. In that way, so can see the results for any set of projects that she wants to consider funding.
The information that Jane is particularly interested in is the following:
1.Number of projects undertaken in each division
2.Capital expenditures ($M) - company-wide and by division. Jane also wants to see the calculated values in cells P26:AA37 in case she needs to see a full breakdown of capital expenditure.
3.Whether any expenditure limits are exceeded.
4.Table of ROI by the project. Jane prefers to compare percentages rather than absolute numbers. For this reason, she wants you to divide each of the project NPVs through by the total capital expenditure for each project and report the ROI percentage.
When you have completed the deterministic decision model, Jane wants you to use this as the basis for developing a spreadsheet-based stochastic decision model in the other worksheet.
In this Stochastic model worksheet, she wants you to apply triangular distributions to each capital expenditure and to each NPV. Jane wants you to treat all of the capital expenditures in the page 1 table as the most likely values. Jane then wants you to set the minimum and maximum values at 15% below and 30% above the most likely values, to counter the common bias of underestimating costs.
She also wants you to treat all of the NPVs in the page 1 table as the most likely values. She then wants the minimum and maximum values set at 20% below and 15% above the most likely values, to counter the common bias of over-estimating the NPV.
Once you have completed the development of your Stochastic model, Jane wants you to do some preliminary analysis for her.
She wants you to consider three sets of projects that satisfy the four budget constraints and look promising in terms of total NPV. Her one stipulation is that each set must include at least a project from each division. She wants you to perform a comparative analysis of the three sets and write up your findings in a PowerPoint
report. In particular, she wants you to provide a clear analysis of the risks faced with each of the three sets of projects.

Learning Outcomes
This task allows you to demonstrate your achievement towards the unit learning outcomes. The ULOs are aligned with specific graduate learning outcomes – that is, the skills and knowledge graduates are expected to have upon completion of their studies – and this assessment task is an important tool in determining
the achievement of those outcomes. If you do not demonstrate achievement of the unit learning outcomes, you will not be successful in this unit. It is good practice to familiarise yourself with the ULOs and GLOs as they provide guidance on the knowledge, understanding, and skills you’re expected to demonstrate upon completion of the unit. 
In this way, they can be used to guide your study
ULO 1: Conceptualise, formulate and represent a business problem as a decision mode.
ULO 2: Develop and solve business problems using advanced decision modeling techniques such as optimization, stochastic modeling, and risk analysis in spreadsheets.
ULO 3: Interpret and analyze the results; investigate the sensitivity of the solutions to the assumptions of the decision mode.

This IT Assignment has been Solved by our IT Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.