Question

Need help creating a graph in excel representing this budget.... Assignment: The text uses patient days to illustrate and exp
Use another graph to illustrate the percentage of your budget that are fixed costs and variable costs. Your goal is to explai
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 (i
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Year Part A Part B Part D Total
1990 66785 44118 0 110903
2000 132803 93180 0 225983
2004 172649 139300 440 312389
2005 187456 153553 1098 342107
2006 198164 170460 44342 412966
2007 209466 183678 50252 443396
2008 225568 183514 53892 462974
2009 239348 205857 57868 503073
2010 245445 215327 62496 523268
2011 257556 226280 66010 549846
2012 263861 240427 68484 572772
2013 270105 248234 72932 591271
2014 270513 266513 82012 619038
2015 275692 279950 91714 647356

Medicare Expenditures 700000 600000 500000 400000 300000 200000 100000 1985 1990 2015 2020 1995 Part A 2000 Part B 2005 -Part

Add a comment
Know the answer?
Add Answer to:
Need help creating a graph in excel representing this budget.... Assignment: The text uses patient days...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The following table reports on GDP and government budget surplus or deficit for France (measured in...

    The following table reports on GDP and government budget surplus or deficit for France (measured in dollars). a) For each year, calculate the surplus or deficit as a percentage of GDP. Instructions: Enter your responses rounded to two decimal places in the table below. If you are entering a negative number, use a negative (-) sign where appropriate. Fiscal Year GDP (Billions of dollars) Surplus or Deficit (−) (Billions of dollars) Surplus or Deficit as percentage of GDP 2006 2,160...

  • Construct a normal probability plot for the residuals. Comment on the normality assumption. Use MINITAB package software/other software to compute and plot your data (No manual calculation is required...

    Construct a normal probability plot for the residuals. Comment on the normality assumption. Use MINITAB package software/other software to compute and plot your data (No manual calculation is required) ​​​​​​​ Value of $1000 Year 2014 1863 2013 1639 Year-X (Independent) Value of $1000 Y-Dependent 2012 1239 2011 1068 2010 1046 2009 909 719 2008 2007 1141 2006 1081 2005 934 2004 890 803 2003 624 2002 801 2001 2000 909 Value of $1000 Year 2014 1863 2013 1639 Year-X (Independent)...

  • Using the Consumer Price Index (CPI) detailed in the table below, Year CPI CPI Year 2003...

    Using the Consumer Price Index (CPI) detailed in the table below, Year CPI CPI Year 2003 1989 1990 1991 1992 1993 1994 1995 124.0 130.7 136.2 140.3 144.5 148.2 152.4 156.9 160.5 163.0 2004 2005 2006 2007 2008 2009 2010 184.0 188.9 195.3 201.6 207.3 215.3 214.5 218.1 224.9 229.6 233.0 236.7 237.0 240.0 1996 1997 1998 1999 2000 2011 2012 2013 2014 166.6 172.2 177.1 179.7 2001 2002 2015 2016 Instructions: Enter your responses rounded to one decimal place...

  • Please provide a guided answer or a brief explanation, your help is very appreciated. The figure...

    Please provide a guided answer or a brief explanation, your help is very appreciated. The figure below illustrates nominal (in current prices) and real (in prices of previous year) GDP of Estonia in 2000- 2015, in billion euro. Estonia 30 25 20 15 10 0 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 BGDP (constant 2010 USS) GDP (current USS) a) b) c) Using the figure above, highlight 4 stages of business...

  • The table below reports the earnings per share of common stock for Home Depot Inc. for...

    The table below reports the earnings per share of common stock for Home Depot Inc. for 2003 through 2015. Year Earnings per Share 2003 $ 1.65 2004 1.95 2005 2.35 2006 2.73 2007 2.87 2008 2.42 2009 1.41 2010 1.60 2011 2.10 2012 2.52 2013 3.81 2014 7.14 2015 9.67 Click here for the Excel Data File Develop an index, with 2003 as the base, for earnings per share for years 2004 through 2015. (Round your answers to 1 decimal...

  • 7.9 3.3 2. Consider the following data from 2001 - 2017, column 1 is the year,...

    7.9 3.3 2. Consider the following data from 2001 - 2017, column 1 is the year, the 2nd column is the unemployment rate, and the 3rd column is the inflation rate. Plot the data using a scatter plot and argue whether in your opinion, the Phillips Curve has validity. 2001 5.7 1.6 2002 6.0 2.4 2003 5.7 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 4.1 3.0 0.7

  • The general fund budget for a state for 1988 (Period 1) to 2011 (Period 24) follows....

    The general fund budget for a state for 1988 (Period 1) to 2011 (Period 24) follows. vau AWN Year Period Budget ($billions) 1988 1 3.05 1989 3.29 1990 3 3.56 1991 4.31 1992 4.39 1993 4.54 1994 4.66 1995 5.19 1996 5.35 1997 5.69 1998 6.01 1999 12 2000 6.48 2001 6.65 2002 15 6.56 2003 6.78 2004 6.98 2005 18 2006 8.38 2007 8.57 2008 21 8.66 2009 8.43 2010 23 8.23 2011 24 8.76 6.2 7.65 a. Which...

  • Using data that obtained for Italy, plot openness (as a percentage) against GINI index for Italy...

    Using data that obtained for Italy, plot openness (as a percentage) against GINI index for Italy by using a Scatter graph. Put openness (as a percentage) on the vertical axis and GINI index on the horizontal axis. DATA have been attached. Year Openness GINI Index 2003 46.25% 34.9 2004 47.55% 34.3 2005 49.40% 33.8 2006 53.28% 33.7 2007 55.21% 32.9 2008 54.71% 33.8 2009 45.61% 33.8 2010 52.25% 34.7 2011 55.59% 35.1 2012 56.18% 35.2 2013 55.48% 34.9 2014 55.75%...

  • please answer and explain why of obesity 5) The graph below provides epidemiological data regarding the...

    please answer and explain why of obesity 5) The graph below provides epidemiological data regarding the among children and adolescents. SOCO its bio enoteloos nogooo poslo 6-11 years 12-19 years Percent 2-5 years 2003- 2004 2005- 2006 2007- 2008 2009- 2010 2011- 2012 a) incidence rate b) prevalence c) morbidity d) mortality e) etiology

  • Check my work mode : This shows what is correct or incorrect for the work you...

    Check my work mode : This shows what is correct or incorrect for the work you ha Cyclical Component Structural Component 178 129 -75 -271 -158 -413 -355 - 298 -259 -248 Fiscal Budget Year Balance 2000 236 2001 128 2002 2003 -378 2004 2005 -318 2006 2007 - 161 2008 -459 2009 -1,413 2010 -1,294 2011 -1,300 2012 -1,087 2013 -680 2014 -484 2015 -438 2016 -587 -178 -26 -433 -251 1.162 -300 -994 -254 -1,046 -896 -491 -338...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT