DATA ANAYTICS WORKSHOP
I would like to give the following under mentioned set of recommendations to the owner of the Café Chain restaurant. Which will surely, help him to increase his revenues by minimizing cost and maximizing sales. These suggestions are based upon the provided POS data:- ·
I would like to give the following under mentioned set of recommendations to the owner of the Café Chain restaurant. Which will surely, help him to increase his revenues by minimizing cost and maximizing sales. These suggestions are based upon the provided POS data:- ·
- Quarterly revenue data reveals that quarter 2 i.e. April, May, June has the total revenue of only 71.6% which is very less in comparison with the subsequent quarters. Here we know that children usually have vacation during this time so my recommendation is convert few of the waiters into the cartoon characters (it won’t cost much as one has to only buy the costume) and if it works well then the restaurant can increase their horizon by incorporating some indoor game and rides. ·
- Days of the week analysis shows that there is heavy footfall on the weekend. Here, we need a idea which will give the customers a door to door service on the weekdays, as they are unable to walk into the restaurant. So, what the owner can do is he can give a free delivery service and on every order the customer will get some point which he can redeem on the weekends. ·
- The owner can cut-short his employee during the non –peak hours and can call them into shifts by doing this his cost of salary decreases, due to less working hours employees would be enthusiastic and would work in efficient and effective manner. ·
- As, we can infer from the data that the opening and closing time are somewhere around 9:30 in the late morning till 6 of the next morning and we can easily see that during 9:30 till 11 there are almost negligible customer same as after 2 in the night so, during this time owner can turn off his electronic gadget which will help him to minimize the electricity bill which ultimately leads to higher revenues. ·
- During the non-peak hour the owner can give discount and goodies to the customers. ·
- The owner can minimize their tax rate as the range of tax is from 0 to 2731.50 or also if someone buying more than 4 or 5 goods or say good of up to a certain amount then he/she will be given rebate in the tax along with this they will become their ‘PRIME CUSTOMER’. These prime customers are entails with certain benefits like if they visit the restaurant they need not have to wait for their order to be processed. It will be done on priority basis. ·
- Lastly, from the days of week analysis we can easily see that the footfall on Saturday is comparatively highly from other weekdays. So , what the owner can do is – he can slightly raise the price on the behalf social benefit to the deprived section of the society. Submitted by: PREETY SHARMA