Sunday, January 9, 2011
Tim Hortons map
I love Tims so in info class I made a chart for them.It's a bit hard to see but I've put some checkpoints like Sheridan on the main map. The main map shows the Timmies locations in Oakville and the smaller chart shows how much Tims coffee each province in Canada consumes yearly. For now I'm going to post some screen caps of my map until I find a computer that isn't so touchy or until I finally break down and try to reduce the file size.
For this I also had to come up with a formula to figure out how many litres and cups that each province in Canada drinks. I had to find the number of Tims in a province first (which did require additional counting) which I called A. Then I had to multiply that by the average sales revenue that one Tims makes in a year which is $202500. Then I had to multiply that by 0.5 (50% of sales come from coffee) and divide that by 1.22 (the cost of a medium coffee). Then I had to multiply by 10 (oz in a medium coffee) and that would equal the amount of coffee each province drinks annually (represented by B).
So the formula ends up looking like this:
A x 2025000 x 0.5 / 1.22 x 10 = B
and for conversion
B/160 = B in gallons
B x 28.41 = B in mL
B in mL/1000 = B in litres
I love math but it did take be a bit to get this all together.
It's awesome that Ontario alone drinks about 1,347,786,885 cups (382,906,254) of Timmy hoho coffee a year.
The coffee % of sales stat is from Lockyer, E.s. (2004, August). Tim Hortons sweet on expansion. Nations Resataurant News, 38(34), 72, 74. Retrieved from ABI?INFORM Global. (Document ID:690512841).
Financial stats are from the Tim Hortons annual report (you can find this on their site).
Stats on coffee prices are from http://ruk.ca/content/tim-hortons-cup-sizes-canada-vs-usa
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment