1. Time of the day analysis suggests that between 9 to 10 AM , the footfall is pretty low , close to zero . This means that the café could be shut down during this time of the day . But since shutting down would increase profits and not revenue , this time should be utilised to prepare for the day ahead.
2.Category Revenue Composition shows that 'tobacco' category is the highest contributor to the revenue followed by food .Thus it is recommended that a combo be made selecting one product each from 'tobacco' and 'food' category .
3.Weekly footfall analysis points out the fact that Saturday has the highest footfall. Hence products with low sales figures should be promoted on this day .
4.Quarterly revenue analysis data shows that the 2nd quarter ( Apr to June ) contributes the least to the total revenue(in terms of %age).It is recommended that during this period , more discounts and offers be given.
5.Wines is the smallest contributor to the revenue. Wines such as 'SULA CHENIN BLANC' and '2 OCEAN PINOTAGE' should be removed as only 1 of each is being sold . Doing this would simplify and reduce the inventory management process and thus increase revenue.