Alcohol StatisticsBy Nathan Dong

Analysis – RTD and Spirit The constraints of this graph is between 2002 and 2011.

In the Bureau of Statistics, the values for Spirit and RTD consumption were available from 2002 and onwards

However, it was able to be used to give the audience an idea of the rising spirit consumption and our current consumers think about spirit and RTD

The requirement of this graph is to prove that spirit consumption is on the rise and the tax on RTDs may influence the rise of spirit consumption.

This graph is for RTD industry and Alcohol and Violence Lobby who want to prove that spirit consumption is on the rise

Design – Evaluation Criteria The graph will be very useful against spirit consumption and it

would easily persuade audience due to the simplicity of the graph and the time of the data is recent enough to be relevant to the requirement.

The RTD can use this graph to focus on spirit drinkers and make ads that can persuade them

The Alcohol and Violence Lobby group can use this graph in their advertisement and as well use it for education purpose to prevent the increasing consumption of spirits and alcohol related violence

Design – Solution DesignLitres of pure alcohol ('000 litres)

Spirits RTDsTotal spirits and

RTDs(b)

2002-03 19,439 12,190 31,629

2003-04 19,336 13,589 32,925

2004-05 19,667 15,338 35,005

2005-06 19,154 16,383 35,537

2006-07 19,355 18,123 37,478

2007-08 20,160 18,693 38,853

2008-09 22,908 13,012 35,920

2009-10 23,015 12,811 35,826

2010-11 24,112 12,814 36,926

Per capita consumption (litres)(a)

 

 

Spirits RTDsTotal spirits and

RTDs(b)

2002-03 1.23 0.77 2.01

2003-04 1.21 0.85 2.06

2004-05 1.21 0.94 2.16

2005-06 1.16 0.99 2.15

2006-07 1.15 1.08 2.23

2007-08 1.18 1.09 2.26

2008-09 1.30 0.74 2.04

2009-10 1.28 0.71 2.00

2010-11 1.32 0.70 2.03

Design - Layout Diagram

Data from Australian Bureau of Statistics

Column headings: Arial, 8pt bold, align to the rightCharacter Data type

Data in cells are Arial, 8pt and is align to the right

Graph has no title on each axesThe bars has different

colour to compare two different data

The data in the cells are numerical integer type

This is the date data

Development - Manipulation

2002-03 2003-04 2004-05 2005-06 2006-07 2007-08 2008-09 2009-10 2010-110

5,000

10,000

15,000

20,000

25,000

Spirits and RTDs Consumption

Litres of Spirits ('000)

Litres of RTDs ('000)

Years

Consum

pti

on o

f alc

ohol

Alco Pop In-troduced

Development - Manipulation

52%48.11%

Spirits RTDs

2007-2008

64%

36.22%

2008-2009

Percentage between RTDs and Spirits

Development - Manipulation

2002-03 2003-04 2004-05 2005-06 2006-07 2007-08 2008-09 2009-10 2010-11

1.10

1.15

1.20

1.25

1.30

1.35 Per capita consumption of Spirits

Spirits

Year

Litre

Development - Manipulation

2002-03 2003-04 2004-05 2005-06 2006-07 2007-08 2008-09 2009-10 2010-1115,000

16,000

17,000

18,000

19,000

20,000

21,000

22,000

23,000

24,000

25,000

Spirits consumption over the years

Spirits

Year

Litre

Development - TestingItem tested Test Data Expected Data Actual Data

If the bar graph has the same data from the data cell

Spirit (2007-2011)

RTD (2007-2011)

20160, 22908, 23015, 24112

18693,13012,12811,12814

20160, 22908, 23015, 24112

18693,13012,12811,12814

Spirit and RTD report Since the introduction of the Alco Pop tax, there is an significant

drop on the consumption of RTDs.

It is likely that consumers are buying a cheaper substitute and hence a dramatic increase of spirit consumption

This statistic has made Ready To Drinks Association’s hypothesis much more stronger and a solid indication that Alco Pop tax should be lowered

This statistics also becomes a catalyst for Alcohol and Violence Lobby’s media campaign towards the increasing spirit sales.

Before the introduction of Alco Pop tax, The gap between RTDs and Alco Spirits are getting closer year after year. After the tax, spirits are outselling RTDs by around 50%

Analysis - Beer The constraints were 1960-2011

There was no data for wine, beer, spirit and RTD before 1960

The requirement is to prove that beer sales has gone down and whether less tax on beer would improve beer sales.

The graph will look if other alcohols are increasing its consumption over the years and if beer sales are declining over few years

Design - Solution Design The graph shows the progress of alcohol consumption and it useful

to analyse what ways to improve sales, how is time is having effect on sales and telling the perception of beer, wine, RTD and spirits

The can help the beer industry to shift focus on wine, RTD and spirit consumers and persuade them to drink more beer.

The beer industry can make ads that can target occasional beer drinkers

Beer industry can analyse why regular drinkers are more preferring wine, RTD and spirit

Litres of pure alcohol ('000 litres)  

Total beer

Total wine

Total spirits

and RTDs Total

1960-61 51,184 8,430 8,089 67,7031961-62 52,017 8,576 8,815 69,4081962-63 53,656 8,931 9,070 71,6571963-64 56,566 9,394 9,630 75,5901964-65 59,486 9,626 10,562 79,6741965-66 60,778 10,520 9,568 80,8661966-67 63,528 11,797 9,690 85,0151967-68 66,815 13,061 11,070 90,9461968-69 70,211 14,405 11,166 95,7821969-70 73,552 15,746 12,653 101,9511970-71 76,849 15,626 13,120 105,5951971-72 78,762 16,145 14,249 109,1561972-73 82,550 17,748 16,384 116,6821973-74 89,965 20,036 16,752 126,7531974-75 92,238 22,428 16,284 130,9501975-76 91,295 23,869 15,899 131,0631976-77 92,586 24,680 17,724 134,9901977-78 92,368 25,472 18,802 136,6421978-79 90,649 29,402 15,402 135,4531979-80 92,745 30,891 14,817 138,4531980-81 91,940 32,834 16,325 141,0991981-82 92,929 34,835 17,455 145,2191982-83 89,233 36,344 17,888 143,4651983-84 87,429 37,981 17,311 142,7211984-85 81,188 39,749 18,764 139,7011985-86 83,112 40,959 20,147 144,218

1986-87 81,527 40,448 18,997 140,9721987-88 84,133 40,697 20,275 145,1051988-89 85,819 38,493 21,488 145,8001989-90 86,019 37,727 21,629 145,3751990-91 84,257 37,059 20,232 141,5481991-92 79,008 39,263 19,450 137,7211992-93 75,714 39,104 20,511 135,3291993-94 76,403 40,228 24,284 140,9151994-95 76,602 40,433 22,934 139,9691995-96 75,715 40,903 23,055 139,6731996-97 76,535 42,933 24,713 144,1811997-98 76,237 45,452 26,518 148,2071998-99 75,607 46,540 26,298 148,4451999-2000 76,097 48,624 24,869 149,5902000-01 77,861 49,708 27,665 155,2342001-02 75,162 50,261 29,008 154,4312002-03 78,767 52,872 31,629 163,2682003-04 75,573 55,122 32,925 163,6202004-05 75,075 57,275 35,005 167,3552005-06 76,388 58,311 35,537 170,2362006-07 77,849 62,263 37,478 177,5902007-08 79,496 62,807 38,853 181,1562008-09 81,148 65,600 35,920 182,6682009-10 79,736 68,451 35,826 184,0132010-11 77,063 68,028 36,926 182,016

Litres of pure alcohol ('000 litres)  

Total beer

Total wine

Total spirits

and RTDs Total

Development - Manipulation

0

10,000

20,000

30,000

40,000

50,000

60,000

70,000

80,000

90,000

100,000

Alcohol Consumption over the years

Total Beer ConsumptionTotal Wine ConsumptionTotal Spirit and RTD Counsumption

Years

Litre

s ('0

00)

Development - Manipulation

65%

23%

12%60%

26%

14%

50%

32%

18%

42%

37%

20%

Percentage of omsumption of alcohol during the decades

Total beer Total wine Total spirits and RTDs

1980-1981

1990-1991

2000-2001

2010-2011

Development - TestingItem tested Test Data Expected

ResultActual Result

Checking if the my data cell is the exact duplicate from Bureau of Statistics

Beer (2007-2011)

Wine (1960-1964)

Spirit and RTD (1970-1974)

79496, 81148, 79736, 77063

8430, 8576, 8931, 9394

13120,14249,16384, 16752

79496, 81148, 79736, 77063

8430, 8576, 8931, 9394

13120,14249,16384,16752

Alcohol report Beer sales has gone down during the 1980s and 1990s, however there is no

significant drop of sales during the 1990s and 2000s.

There is no doubt that wine, spirit and RTD consumption are increasing and the gap between beer and other alcohols are getting closer

It is not recommend to have beer tax lowered because there is no significant drop of consumption of beer during 1990 and onwards.

A tax on other alcohol would likely to increase the consumption of beer