please help part 3

Part I Future Targets - 18 months The State informs your facility that you are not in complace with current standards and ore thus "flagged" for an audit when new regulations come into force in two years. You will be audited after 18 months to make sure you wa be in complonce. The States capping occupancy for your locaties at chord 6825". You look at tumover numbers and decide that targeting on occupancy of 6800 will keep you well within this limit. The State is launching a 60-60 Vaccine Incentive Program. Some incentives are for achieving o 60% reduction in the number of Unvaccinated residents based on current levels The Incentive is pro-rated the focty achieves a maximum of 12% Unvaccinated rate without reaching this target. The more lucrative incentives are available for facilities that achieve a Fully Vaccinated status in at least 60% of residents. After discussions with the facilities Financial Manager, it is decided to forget 63% 10 make sure the facilities get this incentive. Future Targets: 6800 occupants. 60% decrease in Unvaccinated occupants from current levels, 63% of residents will be fully Vaccinated. Answers from this section will be entered into Table 2. First copy the "a" values from Table 1 column 5) to Table 2 column 3). h. What is the absolute reduction in occupancy from current levels 1. Find the percentage reduction in the number of occupants in your facilities j. Find the target number of Unvaccinated residents. k. Find the absolute reduction in the number of Unvaccinated residents Find the target number of Fully Vaccinated residents m. Find the target number and percentage of "In Progress" n. You can now complete the "Future" table on the last page with values calculated. This is the remaining UNshaded cells. You are prohibited by law from kicking residents out of your facilities so you will have to rely on usual turnover" without taking in new residents and/or incentivize residents to move out. The vaccines are quite expensive as well, so if you are able to have Unvaccinated residents move out this would be a plus. o. Is it possible to meet targets simply by having Unvaccinated residents move oute Address each of the three targets. p. How many more Unvaccinated residents could you have and still receive some incentive for this category BONUS: (Up to 30 Homework Points) The vaccines "In Progress" will all need to be updated by the 18 month audit in order to not revert to Unvaccinated Status. However they will become Fully Vaccinated. If you delay the first dose to the Unvaccinated residents past 6 months, they will be "In Progress" when the audit comes around. Let's assume you make the Occupancy limit of 6800 by the difference in residents comes entirely from the Unvaccinated residents. You will then "start" with: Unvaccinated In Progress, and Fully Vaccinated Find the minimum number of vaccines you would need to administer to bring your facilities into compliance with some Unvaccinated 60-60 VIP and just meeting the Fully Vaccinated standard of the 60-60 VIP. Discuss what your greatest considerations are. Comparison - Two Years Ago to Today e&fil&lv e&f i&li Frequency % Change in Percentage 1. Absolute il. % Relative mil. Absolute iv. % Relative Difference Change Difference Change Current Data 2 Years Ago TABLE 1 .. Relative Frequency Relative Frequency Frequency d. Frequency Vaccine Status 1563 16 Unvaccinated 2851 43 In Progress 2703 Pully Vaccinated 41 TOTAL 7120 Comparison - Today to 18 Mo. In Future TABLE Z 18 Month Projection Frequency % Change in Percentage Current Data COPY from Table 1 a. Relative Frequency Frequency Vaccine Status Frequency % Relative Frequency Absolute Difference % Relative Change Absolute Difference % Relative Change Unvaccinated 1563 In Progress 2851 m. m. Fully Vaccinated 2703 63% TOTAL 7120 6800 Fill in all unshaded spaces Complete this project in "Worksheet torm" by showing work in the space provided and copying the final answers designated place. For all calculations, show the formula used, the values substituted in and the calculated result rounded to the nearest cent. If you use a formula more than once there is no need to show that formula twice. Scenario You have been hired to assess the vaccination status of residents in a large group of residential facilities and bring them into compliance with impending State standards. The vaccine schedule requires two shots to be administered within 6 months to one year of each other for else you have to "start over" and the vaccine status reverts to unvaccinated). There is also a fair amount of turnover in the facilities. The last page of this document contains two summary tables (Table 1 and Table 2) that you can fill out as you go along to compare all of the data. The letter designations are in the spaces or column headings. For example you will copy your answers from Part la, to the 5th column from left of Table 1 and 3 column from left of Table 2. beginning in the cell right of the value 1563. Part 1 Current Status Vaccine Status Frequency You go through the medical records for all 7.120 current residents and construct the simple Frequency Distribution Table as shown at right. a. Find the Percent Relative Frequencies and complete the columns on Tables 1 & 2 (last page). Show one calculation here. Unvaccinated In Progress Fully Vaccinated 1563 2851 2703 b. Construct the Bar Chart Current Vaccin 45 40 35 30 25 Percent Relative Frequency 20 15 10 5 Uniscinated In Progress Fully Vaccinated Part 2 Past Status - 2 years ago Your predecessor left the job under some unfortunate circumstances and a lot of the records are missing. You are informed that the resident population increased 14% over the past two years. C. Find the resident population 2 years ago (round to integer). Show work here and enter the value Into the cell designated "c" in Table 1. Vaccination Status d. You are unable to locate any records, but found a report with the following Pie Chart Use the formula for the Percent Relative Frequency, and rearrange it to find the frequencies. Use the total from "c" above. 16% 41 33% Show one calculation here and fill in the three cells under the column heading d. Frequency" in Table 1 Unacciated In Progress Fully Vaccinated For parts e & show one calculation in the space provided and fill in all columns with headings "e & f" in Table 1. e. For Unvaccinated Residents, find The absolute increase in number of residents i. ii. The percent relative increase in number of residents . The absolute change in the percentage of unvaccinated residents iv. The percent change in the percentage of unvaccinated residents 1. Repeat "e" for In Progress and Fully Vaccinated Residents. No need to show work. 9. [You are bosically copying values from the table): Compared to two years ago. there are rum more/fewer facie) residents with fully Vaccinated status. However the vaccination rate in terms of percentage has gone from perconto percentage an absolute reduction in percentage percentagel. Based on the above, if your company is boasting an increase in Fully Vaccinated residents, what do you think they are referring to? Do you think this is an accurate portrayal of the vaccination program at your facility Explain Part I Future Targets - 18 months The State informs your facility that you are not in complace with current standards and ore thus "flagged" for an audit when new regulations come into force in two years. You will be audited after 18 months to make sure you wa be in complonce. The States capping occupancy for your locaties at chord 6825". You look at tumover numbers and decide that targeting on occupancy of 6800 will keep you well within this limit. The State is launching a 60-60 Vaccine Incentive Program. Some incentives are for achieving o 60% reduction in the number of Unvaccinated residents based on current levels The Incentive is pro-rated the focty achieves a maximum of 12% Unvaccinated rate without reaching this target. The more lucrative incentives are available for facilities that achieve a Fully Vaccinated status in at least 60% of residents. After discussions with the facilities Financial Manager, it is decided to forget 63% 10 make sure the facilities get this incentive. Future Targets: 6800 occupants. 60% decrease in Unvaccinated occupants from current levels, 63% of residents will be fully Vaccinated. Answers from this section will be entered into Table 2. First copy the "a" values from Table 1 column 5) to Table 2 column 3). h. What is the absolute reduction in occupancy from current levels 1. Find the percentage reduction in the number of occupants in your facilities j. Find the target number of Unvaccinated residents. k. Find the absolute reduction in the number of Unvaccinated residents Find the target number of Fully Vaccinated residents m. Find the target number and percentage of "In Progress" n. You can now complete the "Future" table on the last page with values calculated. This is the remaining UNshaded cells. You are prohibited by law from kicking residents out of your facilities so you will have to rely on usual turnover" without taking in new residents and/or incentivize residents to move out. The vaccines are quite expensive as well, so if you are able to have Unvaccinated residents move out this would be a plus. o. Is it possible to meet targets simply by having Unvaccinated residents move oute Address each of the three targets. p. How many more Unvaccinated residents could you have and still receive some incentive for this category BONUS: (Up to 30 Homework Points) The vaccines "In Progress" will all need to be updated by the 18 month audit in order to not revert to Unvaccinated Status. However they will become Fully Vaccinated. If you delay the first dose to the Unvaccinated residents past 6 months, they will be "In Progress" when the audit comes around. Let's assume you make the Occupancy limit of 6800 by the difference in residents comes entirely from the Unvaccinated residents. You will then "start" with: Unvaccinated In Progress, and Fully Vaccinated Find the minimum number of vaccines you would need to administer to bring your facilities into compliance with some Unvaccinated 60-60 VIP and just meeting the Fully Vaccinated standard of the 60-60 VIP. Discuss what your greatest considerations are. Comparison - Two Years Ago to Today e&fil&lv e&f i&li Frequency % Change in Percentage 1. Absolute il. % Relative mil. Absolute iv. % Relative Difference Change Difference Change Current Data 2 Years Ago TABLE 1 .. Relative Frequency Relative Frequency Frequency d. Frequency Vaccine Status 1563 16 Unvaccinated 2851 43 In Progress 2703 Pully Vaccinated 41 TOTAL 7120 Comparison - Today to 18 Mo. In Future TABLE Z 18 Month Projection Frequency % Change in Percentage Current Data COPY from Table 1 a. Relative Frequency Frequency Vaccine Status Frequency % Relative Frequency Absolute Difference % Relative Change Absolute Difference % Relative Change Unvaccinated 1563 In Progress 2851 m. m. Fully Vaccinated 2703 63% TOTAL 7120 6800 Fill in all unshaded spaces Complete this project in "Worksheet torm" by showing work in the space provided and copying the final answers designated place. For all calculations, show the formula used, the values substituted in and the calculated result rounded to the nearest cent. If you use a formula more than once there is no need to show that formula twice. Scenario You have been hired to assess the vaccination status of residents in a large group of residential facilities and bring them into compliance with impending State standards. The vaccine schedule requires two shots to be administered within 6 months to one year of each other for else you have to "start over" and the vaccine status reverts to unvaccinated). There is also a fair amount of turnover in the facilities. The last page of this document contains two summary tables (Table 1 and Table 2) that you can fill out as you go along to compare all of the data. The letter designations are in the spaces or column headings. For example you will copy your answers from Part la, to the 5th column from left of Table 1 and 3 column from left of Table 2. beginning in the cell right of the value 1563. Part 1 Current Status Vaccine Status Frequency You go through the medical records for all 7.120 current residents and construct the simple Frequency Distribution Table as shown at right. a. Find the Percent Relative Frequencies and complete the columns on Tables 1 & 2 (last page). Show one calculation here. Unvaccinated In Progress Fully Vaccinated 1563 2851 2703 b. Construct the Bar Chart Current Vaccin 45 40 35 30 25 Percent Relative Frequency 20 15 10 5 Uniscinated In Progress Fully Vaccinated Part 2 Past Status - 2 years ago Your predecessor left the job under some unfortunate circumstances and a lot of the records are missing. You are informed that the resident population increased 14% over the past two years. C. Find the resident population 2 years ago (round to integer). Show work here and enter the value Into the cell designated "c" in Table 1. Vaccination Status d. You are unable to locate any records, but found a report with the following Pie Chart Use the formula for the Percent Relative Frequency, and rearrange it to find the frequencies. Use the total from "c" above. 16% 41 33% Show one calculation here and fill in the three cells under the column heading d. Frequency" in Table 1 Unacciated In Progress Fully Vaccinated For parts e & show one calculation in the space provided and fill in all columns with headings "e & f" in Table 1. e. For Unvaccinated Residents, find The absolute increase in number of residents i. ii. The percent relative increase in number of residents . The absolute change in the percentage of unvaccinated residents iv. The percent change in the percentage of unvaccinated residents 1. Repeat "e" for In Progress and Fully Vaccinated Residents. No need to show work. 9. [You are bosically copying values from the table): Compared to two years ago. there are rum more/fewer facie) residents with fully Vaccinated status. However the vaccination rate in terms of percentage has gone from perconto percentage an absolute reduction in percentage percentagel. Based on the above, if your company is boasting an increase in Fully Vaccinated residents, what do you think they are referring to? Do you think this is an accurate portrayal of the vaccination program at your facility Explain