please help to solve this using excel

[a] Envelopes and bar code labels $18,000/ year, other supples $3,000/year. Assume 5% annual cost increase. [b] Service and maintenance costs are fixed for 10 years ( 552,000 per year). [c] Technician labor savings ( 5FTE ) is projected to increase at a rate of 4% each year, 512/hr.+30J benefits. [d) Pharmacist labor savings (1 FTt) is projected at rate of 4N exch year. Average salary of 554/hr+30% benefits. [e] ADE cost-avoidance calculations are as follows: 1. Avoids 25,000 dispensing errors per are via improving dispensing accuracy from 98.9$ after pharmacy double-check to 99.9%. 2. Assumption is that 1 in 1,000 dispensing errors result in a preventable ADE. 3. System implementation will avoid 25 preventable ADEs per year. 4. Cost of a preventable ADE to the hospital is 54.500. 5. Annual cost-avoldance to the hospital is In the attached "ROI Analysis Home Assignment" document, you will find thirteen different and discrete assignments. Please note there is one assignment per page on each of the 13 pages in the attachment. Refer to the attached "Student Assignment Page Number" document for your specific assignment (page). Each person only has to do one assignment. ROI Analysis Home Assignment Student Assignment Page Number There are two parts that need to be completed for each assignment. Each part is valued at 2.5 points and there will be no partial credit. 1. Perform a Return on Investment (ROI) Analysis using Excel. 2. Analyze and comment on the results of your ROI (minimum 150 words and maximum 300 words) to show how these results can be applied in practice using a word document. Type all your answers and document all and any references you use. Please indicate your assigned page number. Only typed assignments will be graded (no handwritten assignments will be graded). As always, please contact me if you have any questions regarding the assignment. Reoards [a] Envelopes and bar code labels $18,000/ year, other supples $3,000/year. Assume 5% annual cost increase. [b] Service and maintenance costs are fixed for 10 years ( 552,000 per year). [c] Technician labor savings ( 5FTE ) is projected to increase at a rate of 4% each year, 512/hr.+30J benefits. [d) Pharmacist labor savings (1 FTt) is projected at rate of 4N exch year. Average salary of 554/hr+30% benefits. [e] ADE cost-avoidance calculations are as follows: 1. Avoids 25,000 dispensing errors per are via improving dispensing accuracy from 98.9$ after pharmacy double-check to 99.9%. 2. Assumption is that 1 in 1,000 dispensing errors result in a preventable ADE. 3. System implementation will avoid 25 preventable ADEs per year. 4. Cost of a preventable ADE to the hospital is 54.500. 5. Annual cost-avoldance to the hospital is In the attached "ROI Analysis Home Assignment" document, you will find thirteen different and discrete assignments. Please note there is one assignment per page on each of the 13 pages in the attachment. Refer to the attached "Student Assignment Page Number" document for your specific assignment (page). Each person only has to do one assignment. ROI Analysis Home Assignment Student Assignment Page Number There are two parts that need to be completed for each assignment. Each part is valued at 2.5 points and there will be no partial credit. 1. Perform a Return on Investment (ROI) Analysis using Excel. 2. Analyze and comment on the results of your ROI (minimum 150 words and maximum 300 words) to show how these results can be applied in practice using a word document. Type all your answers and document all and any references you use. Please indicate your assigned page number. Only typed assignments will be graded (no handwritten assignments will be graded). As always, please contact me if you have any questions regarding the assignment. Reoards