Business Intelligence and Smart Connected Products

Running head: BUSINESS INTELLIGENCE
Business Intelligence
Assessment item 1 – Assignment 1
Student Name:
University Name:

1BUSINESS INTELLIGENCE
Table of Contents
Part – A............................................................................................................................................2
Question 1....................................................................................................................................2
Result analysis.........................................................................................................................3
Question 2....................................................................................................................................3
Result analysis.........................................................................................................................5
Question 3....................................................................................................................................5
Result analysis.........................................................................................................................7
Part – B............................................................................................................................................8
Demonstration 1...........................................................................................................................8
First dashboard.........................................................................................................................8
Second dashboard....................................................................................................................8
Answer to questions.................................................................................................................9
Demonstration 2...........................................................................................................................9
First dashboard.........................................................................................................................9
Second dashboard..................................................................................................................10
Answer to questions...............................................................................................................10
Part C – Analysis of Case Study....................................................................................................11
Bibliography..................................................................................................................................15

2BUSINESS INTELLIGENCE
Part – A
Question 1
NPV model
*Columns
*Years 2018,2021
*Rows
Initial investment needed(0) = 1750000.00 '.2
Market at time (0)= 420000
Market Growth = 0.15'.2
Market Share = 0.10'.2
Total market = Market at time;Total market(-1)*1.15
Sales Volume = Total Market*Market Share
Estimated selling price = 55.00 '.2
Cost of production = 25.00 '.2
Total Revenue = Sales Volume*Estimated selling Price '.2
Cost of Goods sold = Sales Volume*Cost of Production
Annual overhead cost = 210000
Cash Flow = Total Revenue-Cost of goods sold-Annual Overhead cost
Rate = 0.12'.2
NPV(0) = *NPV cash flow;rate

3BUSINESS INTELLIGENCE
Model Output
Result analysis
The Net Present Value (NPV) that has been calculated in the model is $5440551.00 and
the claim regarding NPV is correct. The NPV has been calculated for the first period only that is
2018 for decision-making using NPV (0) in Visual DSS. Hence, the claim that has been made
regarding NPV being above $2 million is correct.
Question 2
Monte Carlo Simulation Model
*Columns
*Years 2018,2021
*Rows
Initial investment needed(0) = UNI(100000.00,200000.00) '.2
Market at time (0)= 420000
Market Growth = 0.15'.2
Market Share = TRI(0.05,0.10,0.15)'.2
Total market = Market at time;Total market(-1)*1.15