Question: hello its a example of my excel file i couldnt share the whole excel but here is the -- can you just take my example
hello its a example of my excel file i couldnt share the whole excel but here is the -- can you just take my example to a new excel and solve it on MATLAB please ty KDV is basically is a sales tax the translation says VAT value added tax
| Type | Product | Producer | Unit | Price | KDV | June1 | June2 | June3 | June4 | June5 | June6 | June7 | June8 | June9 | June10 | June11 | June12 | June13 | June14 | June15 | June16 | June17 | June18 | June19 | June20 | June21 | June22 | June23 | June24 | June25 | June26 | June27 | June28 | June29 | June30 |
| Bakliyat | Bulgur nce | Akyazm | 1 kg | 8,00 | 0,08 | 0,00 | 0,00 | 0,00 | 1,00 | 1,00 | 1,00 | 0,00 | 0,00 | 0,00 | 2,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 1,00 | 1,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 |
| Bakliyat | Bulgur Pilavlk | Akyazm | 1 kg | 8,00 | 0,08 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 |
| Bakliyat | Pirin | Ayhan Kaleli | 500 gr | 10,00 | 0,08 | 0,00 | 0,00 | 2,00 | 2,00 | 0,00 | 2,00 | 1,00 | 0,00 | 1,00 | 0,00 | 0,00 | 0,00 | 1,00 | 2,00 | 0,00 | 0,00 | 0,00 | 0,00 | 1,00 | 1,00 | 0,00 | 0,00 | 1,00 | 0,00 | 2,00 | 3,00 | 0,00 | 0,00 | 0,00 | 1,00 |
| Bakliyat | Krk Pirin | Ayhan Kaleli | 500 gr | 7,00 | 0,08 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 1,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 1,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 |
Monthly sales Read the excel file Sales.xlsx. This data shows the sales of Beikta Kooperatifi in June. Each row shows Type Product Producer Unit Price KDV followed by 30 days sales of the product. There are 9 different types of products: Bakliyat, Bal/reel ...etc. Note that some products are sold in two different Units. For example, Product "Fasulye" produced by "Ovack" comes with 3 kg and 1.5 kg packets. Price and KDV shows the sales price and ratio of KDV per unit product. For example, if the KDV is 0.08,8% KDV is included in the Price. In this question, you will read the file into Matlab, generate some reports and plots. Please note that all should be done with Matlab script. a) Read the file. Calculate the total income in June. (Note that you have to first calculate total sales per product in June) Monthly sales Read the excel file Sales.xlsx. This data shows the sales of Beikta Kooperatifi in June. Each row shows Type Product Producer Unit Price KDV followed by 30 days sales of the product. There are 9 different types of products: Bakliyat, Bal/reel ...etc. Note that some products are sold in two different Units. For example, Product "Fasulye" produced by "Ovack" comes with 3 kg and 1.5 kg packets. Price and KDV shows the sales price and ratio of KDV per unit product. For example, if the KDV is 0.08,8% KDV is included in the Price. In this question, you will read the file into Matlab, generate some reports and plots. Please note that all should be done with Matlab script. a) Read the file. Calculate the total income in June. (Note that you have to first calculate total sales per product in June)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts