It is January 2, 2012 and you have started your first day of work as the Practice Administrator for the Tri-Cities Geriatric Center (a physician practice serving older adults).Your first job is to project a budget for calendar year 2012. In gathering information for this task, you come across budgets for the past 3 years.However, the former Director did not complete budget worksheets (maybe the reason he was fired), so you don't have complete information.

a.answer CY 2009, 2010, and 2011 budgets (Table 1a)

b.Construct a P&L statement for CY 2012, explaining why you projected EACH number.

c.Assume that it is now January 2, 2013 and the actual budget numbers were reported for CY 2012 in Table 1b.Perform a budget variance report for CY 2012.What does this variance report tell us about revenues and expenses (profit/loss)?What could you have done to increase profit or prevent loss?

Please provide formulas or equations so I can understand how it was done. (Preferably excel).