please help

Part 3. Project a New Scorecard (based off your process revisions/improvements) Make an electronic copy of the original scorecard file (Save As). Use the copied file as a scorecard projection. Basically, show the reader what parts of the scorecard will be positively affected by your recommended process improvements (project results 6 months from now and highlight your projections in another color). Format the excel file any way you want to best convey to the reader your new projections. Try to stay realistic in your projections. Change takes time... There will be some guestimation here, Healthcare Department Balanced Scorecard Profit Net Revenue 17 EN w Actual $2,877,842 $3,266,667 Goal YTD Actual Goal 0.000 500.000 300.000 $200.000 310000 30 3.2% 3.0% 308 2.0 19 80 Few JA My Sep Oct Nov Des 40% Patient Satisfaction Actual Goal FT Admission Percentage YTD Actual 16% Goal 30% 30% 20% 889 90% som 10% 0% Jan Mar May Sep NOW Yay Our Cost Unit Increase in Admissions YTD Actual 10 120 YTD Actual Goal 83 100 Goal $134 $115 5250 $200 $150 $100 550 SO 30 Jan M May NON Customer Service Training Tests Actual 94% Go 50 Six Sigma Training Tests YTD Actus BOX Goal 90% ESSE Part 3. Project a New Scorecard (based off your process revisions/improvements) Make an electronic copy of the original scorecard file (Save As). Use the copied file as a scorecard projection. Basically, show the reader what parts of the scorecard will be positively affected by your recommended process improvements (project results 6 months from now and highlight your projections in another color). Format the excel file any way you want to best convey to the reader your new projections. Try to stay realistic in your projections. Change takes time... There will be some guestimation here, Healthcare Department Balanced Scorecard Profit Net Revenue 17 EN w Actual $2,877,842 $3,266,667 Goal YTD Actual Goal 0.000 500.000 300.000 $200.000 310000 30 3.2% 3.0% 308 2.0 19 80 Few JA My Sep Oct Nov Des 40% Patient Satisfaction Actual Goal FT Admission Percentage YTD Actual 16% Goal 30% 30% 20% 889 90% som 10% 0% Jan Mar May Sep NOW Yay Our Cost Unit Increase in Admissions YTD Actual 10 120 YTD Actual Goal 83 100 Goal $134 $115 5250 $200 $150 $100 550 SO 30 Jan M May NON Customer Service Training Tests Actual 94% Go 50 Six Sigma Training Tests YTD Actus BOX Goal 90% ESSE