FREE Trial
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

International Accounting

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

7th Edition

0136111475, 9780136111474

More Books

Students also viewed these Accounting questions

Question

★★★★★
Holmes Manufacturing is considering a new machine that costs $250,000 and would reduce pretax manufacturing costs by $90,000 annually. Holmes would use the 3-year MACRS method to depreciate the...

Answered: 1 week ago

Question

★★★★★
Describe the historical roots of clinical psychology.

Answered: 1 week ago

Question

★★★★★
Jerry Stevenson is the manager of a medical clinic in Scottsdale, AZ. He wants to analyze patient data to identify high-risk patients for cardiovascular diseases. From medical literature, he learned...

Answered: 1 week ago

Question

★★★★★
A recent edition of The Wall Street Journal reported interest rates of 3.867 percent, 3.845 percent, 3.821 percent, and 3.638 percent for two-year, three-year, four-year, and five-year Treasury...

Answered: 1 week ago

Question

★★★★★
outline two ratios that can be used to identify resources required by an organisation to meet short-term and long-term obligations

Answered: 1 week ago

Question

★★★★★
The following is the -adrenergic receptor and a small G protein (shown in blue) oriented in the membrane. Answer parts (a)-(d) by using the options: Cytoplasm/ nucleus/ rough endoplasmic reticulum...

Answered: 1 week ago

Question

★★★★★
a) Specific ion channels and pumps regulate the resting membrane potential and action potential of aneuron. You treat a neuron in vitro (in a plate) with a reversible ATP synthase inhibitor. Would...

Answered: 1 week ago

Question

★★★★★
C. elegans shows ethanol-responsiveness through body-flattening. Loss-of-function mutants in the slo gene are resistant to ethanol and do not flatten their bodies. Null mutants in the npr gene show...

Answered: 1 week ago

Question

★★★★★
The following is the regulatory network that controls the activity of the mitotic regulatory kinase (Cdk-1) that is critical for the G2M phase transition of a cell during the cell cycle. DNA damage...

Answered: 1 week ago

Question

★★★★★
The following drawing represents a cardiac stem cell (CSC) lineage commitment and differentiation in mice. a) List two characteristics of CSC that qualifies them as stem cells. b) Briefly describe...

Answered: 1 week ago

Question

★★★★★
Explain the key functions of reward management and evaluate the approach to reward that seeks to align pay systems with an organizations business strategy

Answered: 1 week ago

Question

★★★★★
Do competency frameworks provide the best way of assessing and developing leaders and managers?

Answered: 1 week ago

Question

★★★★★
How would LMD in an architects firm differ from that in a financial services organization?

Answered: 1 week ago

Previous Question Next Question