Part 1: Super Store Assume that you have a store of products to sell. This store has three kinds of products that are sold either in-store or online. An example sales data of the store for one month of a one-year period is as follows: Products A B Price TL 15 20 25 In-store Kg 20 15 18 Online Kg 35 42 38 You can find the dataset along with this document in Blackboard. The dataset consists of 12 .csv files, each corresponding to a month's worth of sales. Read each one and store the contents separately, The officials of the store wants to know certain information about the sales of these products: (1) The total sale amount that the store has completed for the full year, (2) The total in-store sales (TL) for a month, (3) The total online sales (TL) for a month, (4) The total in-store sales (TL) for a year, (5) The total online (TL) for a year and (6) The total sales for the particular products A, B and C for a year. You should use matrix operations in your Java application to solve these problem. For instance, if you use matrix multiplication and matrix addition for the amounts and prices of the products in the following format, then you will calculate the total sales in one month and one year as follows: Price Total Sales Amounts ABC In-store: 120 15 181 Online: 135 42 38 15 X 20 25 B- 120.15 + 15 - 20 + 18-25 135.15 + 42 20 + 38.25 11050 12315 Part 1: Super Store Assume that you have a store of products to sell. This store has three kinds of products that are sold either in-store or online. An example sales data of the store for one month of a one-year period is as follows: Products A B Price TL 15 20 25 In-store Kg 20 15 18 Online Kg 35 42 38 You can find the dataset along with this document in Blackboard. The dataset consists of 12 .csv files, each corresponding to a month's worth of sales. Read each one and store the contents separately, The officials of the store wants to know certain information about the sales of these products: (1) The total sale amount that the store has completed for the full year, (2) The total in-store sales (TL) for a month, (3) The total online sales (TL) for a month, (4) The total in-store sales (TL) for a year, (5) The total online (TL) for a year and (6) The total sales for the particular products A, B and C for a year. You should use matrix operations in your Java application to solve these problem. For instance, if you use matrix multiplication and matrix addition for the amounts and prices of the products in the following format, then you will calculate the total sales in one month and one year as follows: Price Total Sales Amounts ABC In-store: 120 15 181 Online: 135 42 38 15 X 20 25 B- 120.15 + 15 - 20 + 18-25 135.15 + 42 20 + 38.25 11050 12315
