Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

hello its a example of my excel file i couldnt share the whole excel but here is the -- can you just take my example

image text in transcribedhello 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Accounting

Authors: Frederick D. S. Choi, Gary K. Meek

7th Edition

0136111475, 9780136111474

More Books

Students also viewed these Accounting questions

Question

Describe the historical roots of clinical psychology.

Answered: 1 week ago