Need help creating a graph in excel representing this budget.... Assignment: The text uses patient days to illustrate and explain budget concepts. Patient days are a critical metric in non-ambulatory settings. I also realize several in class are using the ambulatory setting for your budget examples. Figure 6.2 in the spreadsheets with our text is a good starting point. Use one GRAPH to illustrate the difference between years. You do not have to use Figure 6.2; you may use your previous budget submission for your graph example. The goal of this assignment is to practice creating a visual representation of the change in your budget. Please explain your assumptions. Use another graph to illustrate the percentage of your budget that are fixed costs and variable costs. Your goal is to explain to upper management both the changes in the budget and provide a picture of what makes up the budget. Need help creating a graph in excel representing this budget.... A1 x R Chapter 6 - Incremental Budgeting G H I J K L M N 1 Chapter 6-tremental Budgeting Table 6.2 - Medicare Expenditures (in millions) Figure 6.6. Medicare Expenditures in millions) NMON Medicare Expenditures 1990-2015 $300,000 $250,000 Year 1990 2000 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 Part A Part B $66,785 $44,118 132,803 93,180 172,649 139,300 187,456 153,553 198,164 170,460 209,466 183,678 225,568 183,514 239,348 205,857 245,445 215,327 257,556 226,280 263,861 240,427 270,105248,234 270,513 266,513 275,692 279,950 Part D $0 0 440 1,098 44,342 50,252 53,892 57,868 62,496 66,010 68,484 72,932 82,012 91,714 Total $110,903 225,983 312,389 342, 106 412,967 443,395 462,974 503,073 523,268 549,846 572,772 591,271 619.038 647,356 $200,000 $150,000 15 16 $100,000 19 20 $50,000 21 CGR 4.99% 7.61% 8.41% 7.27% 22 1990 2000 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015