MIS775 - Decision Modelling for Business Analytics & Acme Group Inc. Case Study Along With Business Analysis Report Writing - Management Assignment Help

Assignment Task -                 
 

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

Each division has provided Jane with the capital expenditures required for each project over the next three years and, based on the expected revenue to be generated by each project, the NPV of each project as shown below, and the ownership %. 

*The capital expenditures and NPV for each project are subject to the ownership %. For example, should project 5 be funded, capital expenditures for the Acme Group will amount to 75% of the stated figures, or $1.5M, $3.0M, and $6.0M over the three years, for an NPV of $1.65M. The other quarter of the expenditures will be funded strategically, which will be entitled to a quarter of the stated  NPV. By contrast, the Acme Group will provide 100% of the required capital expenditures for project 1, for an NPV of $0.6M. 

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 by the total capital expenditure for each project and report the ROI percentage. 

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.

This MIS775 - Management Assignment has been solved by our Management 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.