YAYA - Branch Wastage Report July 2018.xlsx

YAYA - Branch Wastage Report July 2018.xlsx - BRANCH...

This preview shows page 1 out of 91 pages.

You've reached the end of this preview.

Unformatted text preview: BRANCH: DEPARTMENT: MAIN MENU Jul-18 DATE ITEMS 1ST chkn dhania guest walked out chicken salad c wrong order chicken n peanut soup left overs chips debries pancake mix left overs frying butter left overs chckn burrito not as expected t butter bgl guest walked out chicken salad c wrong order frying butter left overs chips debries pancake mix left overs avocadoes of steamed vegies left overs water melon of tomatoes rotten frying butter left overs chips debries spicy veg soup left overs chips debries mexican roast pork stale egg n chs croiss wrong order egg bac croisant wrong order eggs n toast wrong order guacamole left overs chips debries frying butter left overs homefries left overs chicken curry guest changed mind 2nd 3rd 4th 5th REASON UNIT OF MEASURE 6th 7th 8th pepper steak guest changed mind beef samosa guest changed mind roast chicken burnt chips debries frying butter left overs pancake mix left overs spicy veg soup left overs eggs n toast guest complained fluffy pancakes not as expected french beans of spicy chicken wings stale frying butter left overs chips debries mexican roast pork of chips regular chips spiced chicken curry steamed vegies water melon tomatoes frying butter chips spicy veg soup guest walked out guest walked out guest changed mind left overs of rotten left overs debries left overs Totals U QUANTITY UNIT COST TOTAL COST 1 205.3 205.30 1 93.8 93.80 1.5 315.8 473.70 1.9 112.55 213.85 1 233.5 233.50 0.7 31.4 21.98 1 185.9 185.90 1 17.9 17.90 1 93.8 93.80 0.32 31.4 10.05 0.82 112.55 92.29 0.5 233.5 116.75 1.2 118 141.60 3 37.9 113.70 4 66.55 266.20 1.2 89.99 107.99 0.12 31.4 3.77 0.745 112.55 83.85 4.8 76.5 367.20 1 112.55 112.55 0.42 767.94 322.53 1 89.4 89.40 1 130.1 130.10 1 45.5 45.50 0.72 199.4 143.57 0.92 112.55 103.55 0.65 31.4 20.41 1 76 76.00 1 200.4 200.40 1 421.3 421.30 1 73.1 73.10 1 257.7 257.70 0.872 112.55 98.14 0.238 31.4 7.47 0.5 233.5 116.75 3 76.5 229.50 2 18.3 36.60 1 69.2 69.20 0.5 100 50.00 0.1 851.37 85.14 0.5 31.4 15.70 1 112.55 112.55 0.6 767.94 460.76 2 2 3 3 4 1.2 0.12 0.745 4.8 26.46 26.7 200.4 37.9 66.55 89.99 31.4 112.55 76.5 52.92 53.40 601.20 113.70 266.20 107.99 3.77 83.85 367.20 - - - - - - 7,771.27 BRANCH: DEPARTMENT: COUNTER Jul-18 DATE ITEMS REASON 1st coffee wastages remains tea wastages remains masala wastages remains coffee wastages remains tea wastages remains masala wastages remains sgl americano guest walked out coffee wastages remains tea wastages remains masala wastages remains sgl reg tea not as expected coffee wastages remains tea wastages remains masala wastages remains coffee wastages tea wastages masala wastages coffee wastages tea wastages masala wastages dbl macchiato dbl masala tea coffee wastages tea wastages masala wastages coffee wastages tea wastages masala wastages remains remains remains remains remains remains guest changed mind guest walked out remains remains remains remains remains remains 2nd 3rd 4th 5th 6th 7th 8th UNIT OF MEASURE Totals QUANTITY UNIT COST TOTAL COST 0.7 64.2 44.94 0.5 41.2 20.60 71.02 0.6 71.02 42.61 64.2 0.6 64.2 38.52 41.2 0.6 41.2 24.72 0.4 71.02 28.41 1 10.8 10.80 0.861 64.2 55.28 0.432 41.2 17.80 0.517 71.02 36.72 1 6.87 6.87 0.7 64.2 44.94 0.3 41.2 12.36 0.6 71.02 42.61 0.5 0.4 0.4 0.301 0 0.255 1 1 0.8 0.362 0.426 0.8 0.362 0.426 64.2 41.2 71.02 64.2 41.2 71.02 19 28.8 64.2 41.2 71.02 64.2 41.2 71.02 32.10 16.48 28.41 19.32 18.11 19.00 28.80 51.36 14.91 30.25 51.36 14.91 30.25 - - - - - - - 782.45 BRANCH: DEPARTMENT: COUNTER Jul-18 DATE ITEMS REASON 1st new lemon poppy muffin 2nd 3rd 4th 5th UNIT OF MEASURE QUANTITY UNIT COST old stock 3.00 45.60 choc chip muffin old stock 1.00 49.83 spinach feta fold over old stock 1.00 79.93 cinnamon rolls old stock 1.00 38.15 banana bread old stock 3.00 19.06 forest berry danish old stock 1.00 80.38 apple cinnamon cake old stock 1.00 51.20 steak pie old stock 3.00 124.63 spinach feta fold over old stock 1.00 79.93 ginger scone old stock 1.00 55.85 orange chocolate cake old stock 2 98.32 mixed berry muffin old stock 2 106.57 new lemon poppy muffin old stock 2 45.6 new cheese pie old stock 2 51.89 steak pie old stock 3 124.63 plain croissant damaged 2 44.46 spinach feta fold over old stock 3 79.93 plain croissant sub standard 3 44.46 new york cheese cake damaged 2 135.62 chocolate fudge cake smashed 2 79.73 6th 8th chicken pie plain croissant apple cinnamon cake ginger scone choc chip muffin forest berry danish spinach feta fold over chocolate fudge cake new cheese pie ginger scone bran muffin banana bread cinnamon rolls guest changed mind old stock old stock old stock old stock old stock old stock old stock old stock old stock old stock old stock old stock 2 3 3 1 1 2 1 2 1 2 4 2 1 82.09 44.46 51.2 55.85 53.68 80.38 79.93 79.73 51.89 55.85 20.3 19.06 38.15 Totals TOTAL COST 136.80 49.83 79.93 38.15 57.18 80.38 51.20 373.89 79.93 55.85 196.64 213.14 91.20 103.78 373.89 88.92 239.79 133.38 271.24 159.46 164.18 133.38 153.60 55.85 53.68 160.76 79.93 159.46 51.89 111.70 81.20 38.12 38.15 - - - - - - - - - 3,289.12 BRANCH: DEPARTMENT: COUNTER Jul-18 DATE ITEMS REASON 1st 4th 7th mint juice mint juice sm orange juice sleep over sleep over not as expected Totals UNIT OF MEASURE QUANTITY UNIT COST 2.10 1.8 1 144.80 144.8 49.9 TOTAL COST 304.08 260.64 49.90 - 614.62 BRANCH: DEPARTMENT: COUNTER Jul-18 DATE 3rd ITEMS fanta black current fanta pineapple sprite REASON fell and chipped fell and chipped fell and chipped UNIT OF MEASURE Totals QUANTITY 3 2 1 UNIT COST 21.55 21.55 21.55 TOTAL COST 64.65 43.10 21.55 - - - - - - 129.30 BRANCH: DEPARTMENT: COUNTER Jul-18 DATE ITEMS Totals REASON UNIT OF MEASURE QUANTITY UNIT COST TOTAL COST - BRANCH: DEPARTMENT: COUNTER Jul-18 DATE 1st 4th ITEMS sparkling water .5 mineral water Totals REASON flat broken seal UNIT OF MEASURE QUANTITY 12/31/1899 2 UNIT COST 2/13/1900 25.00 TOTAL COST 45.25 50.00 95.25 BRANCH: DEPARTMENT: COUNTER Jul-18 DATE ITEMS Totals REASON UNIT OF MEASURE QUANTITY UNIT COST TOTAL COST - BRANCH: DEPARTMENT: gold tea Jul-18 DATE ITEMS REASON UNIT OF MEASURE Totals QUANTITY UNIT COST TOTAL COST accountant_2: kg - accountant_2: in kg - - - - - - Branch Name Wastages Analysis July-18 Category Wastages Net sales % Ratio Kitchen 7,771.27 1147839.81 1% Coffee Drinks 782.45 565286.82 0% Bakery 3,289.12 192203.9 2% Fresh Juices 614.62 102611.05 1% Sodas 129.30 17296.33 1% Ice Creams #DIV/0! Mineral water 95.25 31439.99 0% Merchandise #DIV/0! Teas #DIV/0! #DIV/0! Totals 12,682.02 2,056,677.90 1% 0.68 0.14 1.71 0.60 0.75 #DIV/0! 0.30 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! ...
View Full Document

  • Spring '16
  • KWAME
  • Cake

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern