Project 4: Orange Inc.

Problem Description:

Orange Inc. is a popular electronics company which sells 5 different products: oMac, oPad, oPhone, oTv, and oWatch. Table 1 displays the information about these products. In that table, the first column displays the name of the product, the second column displays the per-unit price of the corresponding product, the third column represents the sales (number of units sold) of that particular product in the year 2018, and the fourth column represents the annual growth rate of sales. Thus, the unit price of the product oPhone is 900; there were 180 units sold in 2018 and the sales are expected to increase annually by 1%.

Product name Per-unit price Sales in 2018 Sales growth rate (annual)

oMac 1300 100 2.25%

oPad 350 150 3.5%

oPhone 900 180 1%

oTv 3000 120 4.2%

oWatch 250 50 0.5%

Table 1: Information about Orange Inc. products

As a star Business Analyst at Orange Inc., you are often consulted for analyzing different business strategies. You have the following two tasks to perform:

Task 1: You have to compute the revenue to Orange Inc. in the year 2018 from the above products. Next, using the annual growth rate for each product, compute the projected sales in the year 2025. Assuming the per-unit price remains the same in all the years, compute the projected revenue in the year 2025.

Hint for Task 1: Create three arrays of appropriate data-type: (i) productPrice, (ii) productSales, and (iii) productRevenue. You already know the elements in productPrice and productSales. Using a for-loop, compute the revenue for each product and store it in the productRevenue array. Sum the elements in productRevenue to calculate total revenue.

To calculate the revenue in 2025, you will first need to compute the projected sales of each product in 2025. Create a method ProjSales that takes three parameters as input: the base sales, the projected rate, and the number of years. The method then returns the projected sales using the following formula:

= (1 + 100 )

For example, if the sales in 2018 are 1000, the growth rate is 10.5%, then the projected sales after 10 years is simply: 1000(1+ 10.5/100)^10. Use Math.pow(a, b) function to compute a^b.

Once you create the method ProjSales, then you can compute the projected sales for each product in the year 2025 and store it in a new array, say productSales2025. Using the product prices from the productPrice array, compute the projected revenue for the year 2025.

Task 2: Your manager notices that oWatch is not an attractive product as the per-unit price is low, and the sales growth rate is not that attractive either. She is thinking to drop the product oWatch with immediate effect; that is, no oWatch will be sold from 2019 onwards. You are required to compute the revised projected revenue in the year 2025, assuming that no oWatch is sold 2019 onwards.

Hint for Task 2: Follow the same procedure as in Task 1, except that now you do not need to compute the projected sales for the fifth element (oWatch) in your array.

Deliverables:

Your .java file including:

The projected revenue in 2025 as computed in task 1 (as a comment on top of your code)

The projected revenue in 2025 as computed in task 2 (as a comment on top of your code)