Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Read the excel file Sales.xlsx. This data shows the sales of Besikta Kooperatifi in June. Each row shows Type  

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 "Ovacik" 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) b) Calculate the total tax (KDV) that should be paid in June. c) Find the products that are not sold in June and write their Type Product Producer Unit in a file called NoSale.txt. d) Calculate the income per Type. Plot the result with a bar graph. Label xticks. Label y axis "TL". Insert an appropriate title to the graph. Export the figure for presentations. Insert it in your HW. Assume, you don't know the row order, use string operations. If you cannot search strings, then you can use the row numbers However, your grade will be decreased. e) There are 6 producers in Bal/Reel type. Show their share in Bal/Reel income using a pie chart. f) Plot number of "Ekmek Sade" sold by day. Use a star sign for plotting. Include only the days with "Ekmek Sade" sells. Set y limits to [06]. Label the axes. Give a title. Export the figure for presentations and include it in your HW. g) Calculate daily income. Plot its histogram. Comment on the histogram: how much money is the Kooperatif expected to make on a normal day? How much money do they make in a good day? How many good days are there in June? h) Assume Beikta Kooperatifi has 0 TL in their cash box on May 31. Animate the increase of money in the cash box starting from June 1st. You can use comet.

Step by Step Solution

3.36 Rating (152 Votes )

There are 3 Steps involved in it

Step: 1

Lets create these example plots with fabricated data A bar graph for sales per product t... 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

Statistics For Business And Economics

Authors: Paul Newbold, William Carlson, Betty Thorne

8th Edition

0132745658, 978-0132745659

More Books

Students also viewed these Physics questions

Question

What must a person do to apply?

Answered: 1 week ago

Question

8. What kinds of people are most likely to develop sleep apnea?

Answered: 1 week ago