homework

profilesunil.kommuri
DatainExcelforHomework3.xlsx
Home>Computer Science homework help>homework

Homework 3

Q1 Q2 Q3 Q4
Department Budget Actual Budget Actual Budget Actual Budget Actual
Distribution 390,000 375,000 395,000 382,000 400,000 390,000 410,000 408,000
Facilities 675,000 693,000 800,000 837,000 750,000 713,000 750,000 790,000
Human Resources 350,000 346,000 350,000 342,000 350,000 340,000 350,000 367,000
Information Systems 950,000 925,000 850,000 890,000 875,000 976,000 900,000 930,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
TV Spots 20 25 20 30 30 30 30 20 15 25 30 35
Revenue 50,000 55,000 52,000 57,000 58,000 59,000 57,000 50,000 45,000 55,000 63,000 78,000
Year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
2008 50,000 52,000 55,000 51,000 52,000 55,000 48,000 49,000 50,000 53,000 56,000 62,000
2009 54,000 56,000 57,000 53,000 53,000 57,000 53,000 55,000 59,000 60,000 65,000 71,000
2010 61,000 60,000 65,000 62,000 64,000 68,000 59,000 60,000 65,000 67,000 70,000 75,000
2011 60,000 61,000 68,000 63,000 63,000 67,000 60,000 61,000 67,000 66,000 68,000 74,000

Sheet2

Sheet3