+61480015851
Everything-Connected Pty Ltd - IoT (Internet of Things) - IT/Computer Science Assessment Answer
Download Solution
Order New Solution
Internal Code: 1AGBID
IT/Computer Science Assessment Answer
Question 1
Everything-Connected Pty Ltd is a global leader in IoT (Internet of Things) applications. The company is planning to build a new product line to introduce IoT middleware products into the market in South Australia. Under an intensely competitive environment, the company engaged a consulting firm to conduct a feasibility study. Now senior management requires a thorough analysis of every new IoT product that is introduced to the market. As a senior business analyst, you have been appointed to advise the senior management on the feasibility of the new product. An initial analysis conducted by other analysts for the product claims the anticipated net present value (NPV) for the new product line is over $1 million and they have recommended the manufacture of the product based on this assessment. Your task is to use a decision support system (DSS) and report to the senior management on whether the claim of the NPV being over $1 million is correct or incorrect using the relevant information given in Table 1.
Your task:
- Develop a decision support model using Visual DSS using the variables described above. Include comments within your Visual DSS model to explain the variables and your calculations.
- Based on the result of your model, what is the net present value (NPV)? Explain whether the claim regarding the NPV being above $1 million is correct or incorrect.
Question 2
You are now asked to analyse the variations on the impact of market share, cost of producing, overheads and initial investment on the NPV. You need to conduct a risk analysis based on the information below:- a) Market share: normally distributed, mean of 18%, standard deviation of 5%.
- b) Unit costs can be described by triangular distribution – the range from $10 to 16 with $14 as the most likely cost.
- c) Overhead: could be as low as $100,000 per year or as high as $200,000 per year, but is most likely to be $150,000 per year. The distribution could be represented using a triangular distribution.
- d) Initial investment requirements can be uniformly distributed between $1,000,000 and $1,500,000.
Your task:
- You are required to use Visual DSS to run a Monte Carlo simulation (a Risk Analysis).
- Produce a cumulative probabilities report and graph for the above question. Based on results and the decision criteria, explain whether the senior management should accept or reject the proposed production of the product.
Question 3
When the above analysis reached the Chief Executive Officer (CEO) of your company, he became very concerned about the assumptions made in the model. His experience has taught him to consider the uncertainty associated with selling price and production costs more thoroughly. He required further analysis to be done by incorporating the following uncertainties to:-
-
- Selling price: uniformly distributed between $25 and $35.
- Unit costs: normally distributed, mean of $20, a standard deviation of $5.
-
Your task:
- You are required to use Visual DSS to run a Monte Carlo simulation (a Risk Analysis). Based on your results determine whether the CEO will proceed under these uncertainties.
- Produce a cumulative probabilities report and graph for the question. Based on results and the decision criteria, will the CEO accept or reject the proposed production of the product?
PART B:
In this part, you are required to demonstrate data validation by using Power BI. Power BI is a business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on information technology staff or database administrators.This Marketing Assignment has been solved by our Marketing experts at onlineassignmentbank. 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.