BADM 3200- ASSIGNMENT 1
DATA COLLECTION AND ANALYSIS

Submission by: Giuseppe Minielli
Submitted to: Dr. Arthur Younger
Date: Feb 8, 2014

Introduction:
This analytical report outlines the government spending activity on a provincial level, coming from “The Government of Ontario”. The government funded organization under analysis is the Royal Ontario Museum. The purpose of this analysis is to identify the amount of funding coming into the organization from the government of Ontario along with other sources and to determine whether the organization would be able to function without government funding. The data sources for this assignment have been extracted from the annual reports of “Public Accounts of Ontario” and “The Royal Ontario Museum Reports” respectively. The data from annual reports are dated for a fifteen year period, beginning with 1999 and ending with 2013. All charts have a numbered timeline of “1-15”, the first signifies the first year of data, which in this case is “1999” and the final number on the sequence represents “2013”.
The Royal Ontario Museum (ROM) Funding Activity
Government of Ontario Grants for ROM 1999-2006
Year
1999
2000
2001
2002
2003
2004
2005
2006
Grants: Operating $ 18,708.00 $ 18,708.00 $ 18,518.00 $ 18,518.00 $ 18,518.00 $ 18,518.00 $ 19,834.00 $ 13,851.00
Grants: Other $ 130.00 $ 1,218.00 $ 256.00 $ 339.00 $ 1,465.00 $ 1,499.00 $ 1,294.00 $ 522.00

Government of Ontario Grants for ROM 2007-2013
Year
2007
2008
2009
2010
2011
2012
2013
Grants: Operating $ 18,518.00 $ 18,518.00 $ 18,518.00 $ 27,518.00 $ 28,273.00 $ 28,631.00 $ 27,725.00
Grants: Other $ 617.00 $ 13,222.00 $ 661.00 $ 7,858.00 $ 28.00 $ 32.00 $ 13.00

This graph depicts the amount of funding given to the Royal Ontario Museum (ROM) over a period of fifteen years. Based on this graph one can comprehend that the funding from the government has increased after the 10th year (2008). There was a drop from year 10 to year 11, this could have been due to the American Recession. There has ever since been a steady increase of funding from after year 11.
Government of Ontario Grant Trend Statistics:
The chart below displays a few basic descriptive statistics of the grants from the government of Ontario:
Descriptive Statistics

Mean
28,109.93333
Median
25,268
Skewness
0.750914078
Minimum
18,658
Maximum
40,460
Sum
421,649
Count
15

Government of Canada Grants for ROM 1999-2006
Year
1999
2000
2001
2002
2003
2004
2005
2006
Grants $ 280.00 $ 207.00 $ 88.00 $ 167.00 $ 92.00 $ 255.00 $ 173.00 $ 2,744.00

Government of Canada Grants for ROM 2007-2013
Year
2007
2008
2009
2010
2011
2012
2013
Grants
$ 5,142.00 $ 335.00 $ 91.00 $ 144.00 $ 416.00 $ 436.00 $ 36.00

This chart shows the amount funding the Canadian government has given in grants to the ROM and its operations. Year 8 and 9 show the most funding, with a collective total of about $8,000,000.

Royal Ontario Museum Foundation Funding 1999-2006
Year
1999
2000
2001
2002
2003
2004
2005
2006
Unrestricted Funds $ 210.00 $ 314.00 $ 683.00 $ 399.00 $ 335.00 $ 462.00 $ 509.00 $ 31.00
Restricted Funds

$ - Available currently $ 4,761.00 $ 5,867.00 $ 4,037.00 $ 5,885.00 $ 7,447.00 $ 7,432.00 $ 10,635.00 $ 13,816.50 Available at a future date $ 6,751.00 $ 9,023.00 $ 11,011.00 $ 11,346.00 $ 5,264.00 $ 5,578.00 $ -