Scenario: You are the CEO of Peace & Prosperity Hospital. As part of your duties, you are tasked to give a brief annual report to hospital administrators and managers. Your report focuses on cost, inpatient census, and patient satisfaction. You will create a brief PowerPoint presentation (no more than 10 slides) to illustrate the data for each topic. Data can be found in the file attached below titled “Team Project Data”. Use this data to create appropriate graphs to be inserted in the PowerPoint presentation. Groups will be assigned in Week Two (2). Submit one (1) single document for review.



  1. Slide #1: Title Page (Should represent an introductory slide, giving the title of the presentation, facility, and presenters).
  2. Slide #2: Provide an introduction to the three topics; cost, inpatient census, and patient satisfaction.
  3. Slide #3-4: Create and present a column graph of actual profit over the 12 months in the previous year. Add a line to the graph to show target profit. (Note: Target profit is based on historical data used to determine budgeting for the year.) Discuss the data.
  4. Slide #5-6: Create and present a column graph to illustrate hospital inpatient census over the same time period. Make sure key comments describing the data are included in the slides. Discuss trends seen in the data and any noticeable skew in the data.
  5. Slides #7-8: These slides will focus on patient satisfaction.
  6. Create and present a chart to show patient satisfaction per department.
  7. Describe your findings. What are your goals for the future?
  8. Slide #9: The last slide is dedicated to the overall conclusions.
  9. Slide #10: Reference Page (must adhere to APA formatting guidelines, provide a list of all resources and references utilized for the completion of the team project)

Hint: To add “Target Profit” as a line graph to the column graph for “Actual Profit”, you must first graph both data sets in one column graph. Then select the data series for “Target Profit” (click on the columns so that all columns for “target profit” are selected) and change the chart type to “line graph”. As long as only the data set for “Target Profit” is selected, the other data set will not change.

 ATTACHMENT PREVIEW Download attachment

Week 4 Team Project Data.xlsx

MonthJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecember Actual Profit$1,036,729$1,147,892$1,289,493$1,074,336$1,356,121$1,401,798$1,745,623$1,936,485$1,965,392$2,708,349$2,397,351$2,203,472 Target Profit$1,100,000$1,400,000$1,400,000$1,400,000$1,600,000$1,600,000$1,200,000$1,600,000$1,500,000$2,300,000$2,300,000$2,200,000 MonthJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecember Percentage of Beds Filled85%83%68%71%62%66%59%83%82%93%90%86% Day Percentage of Inpatient Falls1234567891011121314151617181920212223242526272829303132333435363738394041424344454647 0.9%1.3%1.8%3.8%4.2%6.9%1.8%0.6%1.3%1.7%7.1%5.7%1.1%1.6%4.2%7.8%6.7%5.7%7.1%7.9%1.1%7.8%2.2%3.3%7.5%0.1%6.7%4.1%5.3%3.1%0.6%7.4%5.0%0.5%5.3%1.6%7.4%0.2%3.8%7.4%6.3%2.1%0.2%3.3%7.3%6.5%1.4% 484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495 7.0%7.9%3.9%2.6%6.8%5.4%0.2%7.2%7.3%1.7%1.5%3.2%4.7%2.3%4.2%6.8%2.2%7.9%4.7%6.3%1.6%3.7%7.7%6.4%1.1%3.0%0.8%5.1%0.4%5.1%2.5%6.9%2.7%3.1%6.6%2.1%5.5%7.1%2.8%6.1%3.4%1.5%0.6%2.0%2.6%2.5%2.9%7.0% 96979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143 5.3%6.2%1.9%2.7%4.4%1.0%7.4%6.3%2.4%3.5%4.0%5.7%0.2%2.8%6.8%4.1%7.0%5.5%7.9%1.0%3.6%0.9%1.7%3.2%5.3%7.5%5.9%4.4%4.1%4.7%4.4%4.3%2.0%5.8%0.4%3.4%0.8%4.8%1.4%6.9%2.4%4.9%6.1%4.6%4.2%6.1%4.3%7.4% 144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191 2.6%5.6%6.3%6.1%7.2%2.7%6.9%1.7%5.1%5.5%5.9%6.9%5.9%5.2%5.9%0.6%4.1%5.8%4.8%4.8%4.2%1.4%8.0%3.3%2.2%5.8%5.6%8.0%4.0%1.7%4.7%6.6%6.0%3.1%4.5%3.2%4.6%1.7%5.0%4.1%5.2%6.6%1.1%1.1%2.8%5.5%5.0%5.4% 192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239 1.2%6.6%0.0%6.4%1.7%6.9%5.8%5.7%5.2%5.8%5.4%1.2%5.6%5.9%1.4%6.7%4.4%7.1%1.4%5.5%6.3%0.3%6.8%4.2%2.0%7.2%4.8%6.0%3.8%4.4%7.4%3.3%1.6%1.9%7.0%2.9%3.2%2.1%5.7%7.4%1.1%5.8%4.7%4.9%5.3%7.9%4.5%3.9% 240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287 3.0%3.9%0.3%5.3%5.1%6.2%7.1%3.2%2.4%4.8%2.2%3.9%0.3%5.8%3.2%2.2%7.7%2.6%3.1%0.5%0.5%5.4%2.8%1.2%5.8%0.2%6.9%2.8%5.5%2.5%0.1%1.8%1.2%5.0%0.5%6.4%7.9%0.3%1.3%1.4%7.5%6.2%6.6%4.1%5.9%2.9%6.7%1.2% 288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335 0.0%4.8%1.9%0.3%7.8%0.3%0.5%3.1%5.5%0.2%3.6%6.1%6.9%5.4%6.6%3.0%0.8%7.1%5.9%7.6%4.2%0.7%0.8%6.2%4.5%3.6%4.1%3.5%0.4%2.3%0.4%6.7%1.5%5.8%5.2%7.0%5.4%7.7%2.3%4.2%4.7%2.7%6.8%5.1%0.6%5.7%2.7%1.7% 336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365 5.9%0.3%0.2%3.2%5.3%7.0%1.3%0.6%7.0%6.2%0.4%2.0%1.9%7.7%7.1%0.3%5.2%4.4%3.2%4.3%4.1%5.5%4.0%2.9%2.0%5.6%0.4%1.4%7.6%5.8% DepartmentCardiac Intensive Care UnitIntensive Care UnitCardiac Step-Down UnitOrthopedicOncologyNephrology & RenalEmergency DepartmentPsychMaterinityNeurology Satisfaction87%85%92%88%80%83%52%77%95%87% Person Wait Time (in minutes)1234567891011121314151617181920212223242526272829303132333435363738394041424344454647 578183107144941905130931456811418887912313015315172271171731826193591719576241714213913494566640168102186104239578 484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495 566019521331291131455074991291839017188411221205580101108190166145491564895821199614515079631661121368869114163611388594 96979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143 1469762883715212513687898812914126305619512219416366115551485911312595949362126142161957116729724552178752913812217077 144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191 738319013364145621875465172782193179146111164964212096119591004010427182194100104857324504787355060277874132119152129 192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239 10818019115214046503421121163176561941451503768305418731112871102919281186136589618295771921744565103116181181441734775 240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287 104915069381108311456391831278815474121871591138887169182109241489911918247501071751145018011637178188441841491741276268122 288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335 4467236319194551213614462151138165157118169994616350155648112019152165163191968513885190601351147433354018539927636129 336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383 14314126321233418831175147201379916866161164170901093525158122186671688121164151193106162884259146193731717411812863116155160 384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431 104178146761408115601651209315210111216673148165168321231309498167178194571737818414816316038751481719114917186691696116618680 432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479 133788013369139110193714519289651771541421649815210672150451791021901942417227922310117318314515922100182112981134711555138167 480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527 1401871901117615411351781538080162987889170142151301168617814173107113836515821945483126105150156974718195133281721515655 528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575 181121872620266315316160351416610356535877804119193171221041495519511437169741093641130142833012867164531781676128114 576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623 61113133149191181858118051159106661371801091221211264562331651938087183421162445855797146571701409434129105351752818388176 624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671 161991006437813963193848418951787884136192545810817018634108142511188891194411647115511121168651097691137601159515183 672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719 721261161101865111412332843885104941671391121001852411221222116846111115150123661821861931281817014914987173134261041275219572 720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767 132102221951486250107103941774619515179178421091009715813718219218417718610318811315674147125158981699323171101211191291713610987 768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815 3418269214417020160177109108884113658179191791278617462618130193931951761393450177621441546213712519313360501141114881135 816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863 407211115021194821641416515869161977716115816613659381021351792128888312845391383947761059316119319216038190265340186155 864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911 171402214148211808817410516110178189981347293106832845186137981949799591901598518725188187134709014444130134125582119393 9
12913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959 10811217615218592191113421941031468218318013119393613213134171393932641903417916819415076175148153341491351531191161234769126164 9609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000 28128142173853310818110415872128482716014316932481639040116672553183129519216313826122868817815289154162

Leave a Reply

Your email address will not be published. Required fields are marked *