Exercise 27: Database analysis with Excel
Database analysis with Excel
Picture above present Product Database with theoretical values of moving stock for few of available Jera products. As small business model Jera do not have great amount of stock, however even that little number can create over double profit in comparison to costs.
Below are presented 2 charts. Line chart present overall stock, where we can clearly see differences of costs to profit. Costs values are constant, however is due to theoretical numbers which are even for each product – reality might be much different.
Pie chart might be one the most useful tool for future for brand. Not only to clearly state which product is the most profitable but to:
· Observe and predict trends
· Helps seasonal marketing strategies
· Thanks to observing it you can create brands Iconic products in future
Comments
Post a Comment