DIMPY HANDA

Recommendations for Cafe Owner based on data

OBSERVATIONS AND RECOMMENDATIONS

  • June 27, 2017 at 10:12 AM
  • Visible to public
OBSERVATIONS DECEMBER HAS HIGHEST FOOTFALL WITH HIGHEST NO. OF ORDERS IS PLACED ON 31ST DECEMBER 2010 I.E. NEW YEAR. LOWEST FOOTFALL IS IN JUNE. THEREBY, 4TH QUARTER SHOWS HIGHEST FOOTFALL. MOST SOLD ITEM IS NIRVANA HOOKAH SINGLE HIGHEST NO. OF ORDERS PLACED AT 22:25:36.00 HIGHEST PER UNIT COST IS OF GOSSIPS CHARD AUS (BTL) WHICH IS SOLD ONLY ONCE. HIGHEST REVENUE IS FROM TOBACCO PRODUCTS. LEAST REVENUE IS FROM MERCHANDISE PRODUCTS. SALES ON ANY DAY ARE PICKING UP FROM 10:00AM AND FALLS AFTER 3:00 AM (CAFE OPERATES 24*7). MAJOR RUSH IS ON WEEKEND WITH HIGHEST ON SATURDAY. UNDER BEVERAGES: CAPPUCCINO HAS GAINED MAXIMUM REVENUE.                  MOCAFE HOT CHOCOLATE(SF) HAS GAINED MINIMUM REVENUE. UNDER LIQUOR:CARLSBERG HAS GAINED MAXIMUM REVENUE.             WHISKEY (SM) HAS GAINED MINIMUM REVENUE.                  UNDER MERCHANDISE:GREAT LAKES T-SHIRTS HAS GAINED MAXIMUM REVENUE.             CUTTING GLASS HAS GAINED MINIMUM REVENUE.       UNDER TOBACCO:NIRVANA HOOKAH SINGLE HAS GAINED MAXIMUM REVENUE.             GOLD FLAKE ULTRA LIGHTS(20) HAS GAINED MINIMUM REVENUE.       UNDER WINES:VLN CAB SAUV (GLS) HAS GAINED MAXIMUM REVENUE.             MANDALA VALLEY CHENIN BLANC(GL) HAS GAINED MINIMUM REVENUE. UNDER WINES:ADD ON S HAS GAINED MAXIMUM REVENUE.             ROMA TOMATO & JALAPENO CROQUE HAS GAINED MINIMUM REVENUE. UNDER FOOD:GREAT LAKES SHAKE HAS GAINED MAXIMUM REVENUE.             NONVEG PASTA PESTO HAS GAINED MINIMUM REVENUE. UNDER FOOD:BEER HOOKAH HAS GAINED MAXIMUM REVENUE.             2 DOM BEER + 1PREM SHEESHA HAS GAINED MINIMUM REVENUE. RECOMMENDATIONS: CAFE MAY DISCONTINUE THE MINIMUM REVENUE GENERATING ITEMS FROM THE MENU FROM EACH CATEGORY. CAFE MUST DISCONTINUE THE FOLLOWING ITEMS AS THEY HAVE BEEN ORDERED ONLY ONCE DURING THE WHOLE YEAR: 1.  1+1 VLN CAB SAUV (BTL) 2.  1+1 VLN SAUV BLANC (BTL) 3.  2 AXE TWIST 4.  2 OCEAN PINOTAGE (BTL) 5.  4 SEASONS CLAS SYRAH(BTL) 6.  ADD BUTTERED TOAST 7.  AL SIKANDARI HOOKAH DOUBLE 8.  ASH TRAYS 9.  AVALANCHE BOWL 10.         B1G1 4SEASON CLAS SAUV(BTL) 11.         B1G1 4SEASON CLAS SAUV(GLS) 12.         BEACH GREEN 13.         BENARAS BLUE 14.         CAPONATA 15.         CH CRICKET NOTEBOOK 16.         CH TIN SMALL 17.         CHAIRMAN COOL 18.         CLASSIC REGULAR 19.         COUNTRY LEMONADE GLASS(HANSA) 20.         CUTTING GLASS 21.         DECAFFINATE COFFEE FRAPPE 22.         DHARMATEA LIGHT HOLDER 23.         DIP BOWL 24.         ETCHED LEAF TLIGHT HOLDER 25.         FLAVOR 1000 GMS 26.         GOLD FLAKE ULTRA LIGHTS(20) 27.         GOLDEN DELIGHT 1.1 28.         GOSSIPS CHARD AUS (BTL) 29.         GRAPPO SHEESHA 30.         GREAT LAKES MUG SINGLE 31.         GUERILLA COOL 32.         HOEGAARDEN GLS (2+1) 33.         HOEGAARDEN LTR MUGS (2+1) 34.         INDIA KINGS OCEAN BLUE 35.         KITSCH BLUE 36.         KITSCH PINK 37.         KONKAN STRIPE 38.         MANDALA VALLEY CHENIN BLANC(GL 39.         MANDALA VALLEY RED ZINFANDEL(G 40.         MANGO FLAVOUR SINGLE 41.         MATEUS ROSE PORTUGAL(BTL) 42.         MOCAFE HOT CHOCOLATE(SF) 43.         MODEL-P (IRON ASHTRAY) 44.         MUGS - PLAIN COLOUR 45.         ROCK THE BOAT TEA LIGHT HOLDER 46.         SCHNEIDER 2+1 47.         SHAKE GLASS 48.         SILVER STYLER 1.0 49.         SULA CHENIN BLANC (BTL) 50.         UDAIPUR LILY 51.         WHISKEY (SM) 52.         ZEN ROCK SQUARE VASE 53.         ZINZI WHITE (BTL) ONLY 0.2% OF ITEMS SOLD ARE ON DISCOUNT.DISCOUNT ON ITEMS MAY BE DISCOUNTINUED AS THEY ARE NOT BOOSTING THE QUANTITY SOLD. INSTEAD OF WORKING 24*7, CAFE MAY SCHEDULE ITS TIMING FROM 10:00AM TO 3:00 AM (OPEN ON ALL DAYS).