Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please see image 6. Heather is the nurse manager of an orthopedic ambulatory surgery center. She has reviewed her budgets for the arthroscopy departrnent and
Please see image
6. Heather is the nurse manager of an orthopedic ambulatory surgery center. She has reviewed her budgets for the arthroscopy departrnent and found the following costs and revenues by month for the past two years: January February March April May June July August September October November December 2017 Revenues $310,054 305,682 315,741 299,497 300,026 312,985 319,952 325,896 329,872 341,529 346,003 355 234 Expenses $152,554 149,878 153,005 139,957 148,953 151,973 152,994 160,852 163,994 172,116 199,567 222 629 January February March April May June July August September October November December 2018 Revenues $340,059 332,250 344,315 330,447 330,029 345,284 341,947 358,486 372,859 375,682 395,603 420 029 Expenses $200,194 297,541 301,325 298,137 302,287 311,011 311,089 337,157 353,456 369,776 445,195 420 029 Totals a. b. c. d. Enter the data in Microsoft Excel. Then, graph these data using an Excel spreadsheet and the graph tools. Import a copy of the graph from Excel into this Word document. Discuss what you see on this graph. 1. What specifically identifies trends in revenues and expenses? 2. Interpret the information you see on the graph. Discuss the pattern in revenues and expenses you would predict for 2019 based on these data and explain your prediction. Discuss any actions the nurse manager should take based on these data for 2017 and 2018.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started