Results 1 to 14 of 14

Thread: Statistical analysis of coffee

  1. #1
    Senior Member
    Join Date
    Apr 2009
    Location
    Toronto, New South Wales, Australia, Australia
    Posts
    305

    Statistical analysis of coffee

    Gene Cafe Coffee Roaster $850 - Free Beans Free Freight
    So the past 2 shifts Ive been collecting my dockets to try and get more than just an intuitive sense of what coffees Im making. Comapring the quantities of different types of drinks, sale of small vs large (only 2 options being cup and mug), value-adding (extra shots, syrups) etc.

    There are two categories - what Ive rung up and made, and what someone else has rung up and Ive made. (Discovered Im the value adding queen I had a laugh... extra shot pusher).

    Additionally there is a time stamp on each docket, which Ive used to create a graph of coffees made over time which is an ok way to make use of the info, but Im wondering if anyone (and I know a few of you are into playing with raw data) have other ways I might be able to look at them.

    Have you ever done something similar? Was it useful or just a fun way to spend an afternoon (in a deliciously nerdy way)?

  2. #2
    Senior Member
    Join Date
    Jan 2008
    Location
    Brisbane, Queensland, Australia, Australia
    Posts
    1,756

    Re: Statistical analysis of coffee

    if ya want to forward me the detail, i love to play with data :D im on shift tonight and would love to see what i can come up with......something to do!!! yay :D

    great idea i reacon!!

  3. #3
    Senior Member
    Join Date
    Apr 2009
    Location
    Toronto, New South Wales, Australia, Australia
    Posts
    305

    Re: Statistical analysis of coffee

    Sweet! I just compiled a basic list of what was sold and when. Theres a few sales Im missing because if Im too quick making them then the cashier can bin the docket because its "not needed anymore" before I can grab it.

    Ill email you what Ive got and you can play all you like. One thing Ive noticed already is that there arent as many cups with special instructions attached (9 out of 51) on a Friday, which is my regular night, as opposed to Sunday (15 out of 46), which until 2 weeks ago I never worked. My regulars have faith in me to make it how they like? Sunday nighters are just fussier? Sense of doom for impending Monday?
    Anyways, anything you pick up on will be most helpful and interesting! I expect more questions raised than answered, but what sort of person doesnt enjoy questioning?

  4. #4
    Senior Member
    Join Date
    Jan 2008
    Location
    Brisbane, Queensland, Australia, Australia
    Posts
    1,756

    Re: Statistical analysis of coffee

    Hey Mel,
    With the data you sent me there wasnt too much i could do........except for pie graphs ::)

    Friday trade first, sunday second......






  5. #5
    Senior Member
    Join Date
    Jun 2009
    Posts
    214

    Re: Statistical analysis of coffee

    Excuse my ignorance but what is a "Black Vienna"?

  6. #6
    Senior Member
    Join Date
    Jul 2008
    Location
    Port Fairy
    Posts
    2,993

    Re: Statistical analysis of coffee

    Interesting stats and surprised at the number of Caps? I am thinking your customers are sitdowns mainly? And are they generally older?

    While I have no figures we run about 40% Lattes I reckon 25-30% Caps, 20% FWs and the rest Long or short blacks in the main plus Macs etc. Also interesting that in a holiday town with a more Melbourne based crowd in town the Espresso and long black percentage goes up compared to a more country crowd :)

  7. #7
    Senior Member
    Join Date
    Jan 2008
    Location
    Brisbane, Queensland, Australia, Australia
    Posts
    1,756

    Re: Statistical analysis of coffee

    Quote Originally Posted by 747B606C74717463150 link=1270426123/4#4 date=1270458068
    Excuse my ignorance but what is a "Black Vienna"?
    Correct me if im wrong but i think its a long black with creme....

    Served in a long glass, i like em :)

  8. #8
    Member
    Join Date
    May 2009
    Posts
    78

    Re: Statistical analysis of coffee

    This is really interesting data - the majority of drinks served are cappuccino. For the Melbourne CBD it would be cappuccino and caffe latte swapped around.

    Where do you work?

  9. #9
    Senior Member
    Join Date
    Apr 2009
    Location
    Toronto, New South Wales, Australia, Australia
    Posts
    305

    Re: Statistical analysis of coffee

    Quote Originally Posted by 7571574E4E4B54434C220 link=1270426123/6#6 date=1270459913
    Quote Originally Posted by 747B606C74717463150 link=1270426123/4#4 date=1270458068
    Excuse my ignorance but what is a "Black Vienna"?
    Correct me if im wrong but i think its a long black with creme....

    Served in a long glass, i like em :)
    Bam.

    Quote Originally Posted by 4047434C444E5B4B4C45220 link=1270426123/5#5 date=1270458806
    Interesting stats and surprised at the number of Caps? I am thinking your customers are sitdowns mainly? And are they generally older?

    While I have no figures we run about 40% Lattes I reckon 25-30% Caps, 20% FWs and the rest Long or short blacks in the main plus Macs etc. Also interesting that in a holiday town with a more Melbourne based crowd in town the Espresso and long black percentage goes up compared to a more country crowd :)
    Bam again - they are older, and it is a sailing club with a visiting tourist and sailing crowd around at the moment.

    Quote Originally Posted by 675152504751514D71414A4D4D4E220 link=1270426123/7#7 date=1270467888
    This is really interesting data - the majority of drinks served are cappuccino. For the Melbourne CBD it would be cappuccino and caffe latte swapped around.

    Where do you work?
    Newcastle.

    Thanks Sully, I little chart of total sales over time on paper. Was hard to give you any more info because its just hand compiled from scraps of paper, but Im glad its got us all thinking... a fun exercise! Got me all excited to gather more data next time Im in. Worked in the kitchen tonight so no figures :< but friday night Im in again and could do a post-Easter comparison.

  10. #10
    Senior Member
    Join Date
    Jan 2008
    Location
    Brisbane, Queensland, Australia, Australia
    Posts
    1,756

    Re: Statistical analysis of coffee

    PS mel.....that is a VERY interesting email addy you have ;)

  11. #11
    Senior Member
    Join Date
    Jul 2008
    Location
    Port Fairy
    Posts
    2,993

    Re: Statistical analysis of coffee

    Quote Originally Posted by 555D54515B51574D4B380 link=1270426123/8#8 date=1270470180
    they are older, and it is a sailing club with a visiting tourist and sailing crowd around at the moment.
    Well that explains the need for weak thermonuclear capps then ;D

  12. #12
    Senior Member
    Join Date
    Apr 2009
    Location
    Toronto, New South Wales, Australia, Australia
    Posts
    305

    Re: Statistical analysis of coffee

    Quote Originally Posted by 02062039393C23343B550 link=1270426123/9#9 date=1270470403
    PS mel.....that is a VERY interesting email addy you have ;)
    Haha, oooooooold account I had a laugh.

  13. #13
    ST
    ST is offline
    Member ST's Avatar
    Join Date
    Dec 2009
    Location
    Murray Bridge
    Posts
    63

    Re: Statistical analysis of coffee

    Quote Originally Posted by 74737778707A6F7F7871160 link=1270426123/10#10 date=1270470507
    Quote Originally Posted by 555D54515B51574D4B380 link=1270426123/8#8 date=1270470180
    they are older, and it is a sailing club with a visiting tourist and sailing crowd around at the moment. *
    Well that explains the need for weak thermonuclear capps then *;D *
    That would depend on the type of boat being sailed. *I do a bit of sailing and would much prefer a stronger cappuccino at the proper temp :P

  14. #14
    Senior Member
    Join Date
    Apr 2009
    Location
    Toronto, New South Wales, Australia, Australia
    Posts
    305

    Re: Statistical analysis of coffee

    Behmor Brazen - $249 - Free Freight
    2 different crowds - the regular old folks who love their lavacaps, and then theres the sailors who like their stronger, properly made coffees.



Similar Threads

  1. Palate Training & Sensory Analysis of Coffee; Perth?
    By Robstar in forum General Coffee Related...
    Replies: 1
    Last Post: 28th October 2009, 03:06 PM
  2. Palate Training & Sensory Analysis - July 19-20
    By Andy in forum General News
    Replies: 48
    Last Post: 27th December 2008, 07:20 PM
  3. Palate Training & Sensory Analysis - Oct 4-5
    By Andy in forum General Coffee Related...
    Replies: 52
    Last Post: 23rd October 2008, 08:21 AM
  4. Sunbeam EM5800 temperature analysis
    By Matt_King in forum Brewing Equipment (non-machine specific)
    Replies: 15
    Last Post: 26th June 2006, 11:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •