Emergency Operations Plan

/in /by

Instructions

EDMG220 W6 EOP Assignment: Emergency Operations Plan

Write an all-hazards Emergency Operations Plan (EOP) for the fictional location of Bobsville. Create only the “Basic Plan”

As the basis for your basic all-hazards EOP, use the description of the town, and the Hazard Vulnerability Assessment (HVA) you created in EDMG101. If you have not taken EDMG101, use the sample provided in the attactmect 

You are allowed to reference other sample EOPs as a reference to create yours but should be altering the details to fit to the specific location you are addressing. You will use this document and execute this plan in future classes so help yourself by being thorough.

 

The elements in your Basic EOP should be:

  1. Basic Plan
    1. Introductory Material
      1. Table of Contents
      2. Approval and Implementation Plan
        1. Whose buy-in and support you need to ensure the effectiveness of the plan and how you propose to secure it.
        2. How to share this plan with city/county officials, response organizations, and the public. Would there be opportunity for feedback?
    2. Purpose, Scope, Situation Overview, and Assumptions
      1. Purpose
      2. Scope
      3. Situation Overview
        1. Hazard Analysis Summary
        2. Capability Assessment
        3. Mitigation Overview
      4. Planning Assumptions
    3. Concept of Operations
    4. Organization and Assignment Responsibilities
    5. Direction, Control, and Coordination
    6. Information Collection, Analysis, and Dissemination
    7. Communication
    8. Administration, Finance, and Logistics
    9. Plan Development and Maintenance

Please create your response in a Microsoft word document, and upload as an attachment for submission. Papers are to use Verdana 12 point font text and 1 inch margins.

Please view attachment

Cover

Hazard Vulnerability Assessment
Location: Bobsville, OK
Date Updated: 7/17/20XX
Completed by: APUS
Adapted from FEMA IS-559 Toolkit

Matrix-Nat

Hazard Vulnerability Matrix – Natural
Location: Bobsville, OK
Date Completed: 7/17/20XX
Completed by: APUS
Hazard Probability Impact Frequency Distribution
List specific hazards which could occur in your community. Include only natural hazards. High Major 50 yrs Regional
Moderate Minor 10 yrs County-wide
Low None 5-10 yrs Localized
None 2-3 yrs N/A
every year
several times per year
Winter Storm High Major 2-3 yrs Localized
Severe Thunderstorm High Minor several times per year County-wide
Tornadoes Moderate Major 2-3 yrs Localized
Drought Moderate Major 5-10 yrs Regional
Wildfire Moderate Minor 5-10 yrs Localized
Dust Storm Moderate Minor 10 yrs Regional
Earthquakes Moderate None several times per year Localized
Heat Wave Low Minor 2-3 yrs Regional
Flooding Low Minor 5-10 yrs County-wide
Hurricane Low Minor 50 yrs Regional
Adapted from FEMA IS-559 Toolkit

Matrix-Tech

Hazard Vulnerability Matrix – Technological
Location: Bobsville, OK
Date Completed: 7/17/20XX
Completed by: APUS
Hazard Probability Impact Frequency Distribution
List specific hazards which could occur in your community. Include only technology-caused hazards. High Major 50 yrs Regional
Moderate Minor 10 yrs County-wide
Low None 5-10 yrs Localized
None 2-3 yrs N/A
every year
several times per year
Information Technology Failure High Minor several times per year Localized
Communications High Minor every year Localized
Water Moderate Major 5-10 yrs Localized
Power Moderate Minor 2-3 yrs County-wide
Gas Moderate Minor 10 yrs Localized
Sewage Moderate Minor 50 yrs Localized
Hazardous Materials Release Low Major 50 yrs County-wide
Radiological Accident Low Major 50 yrs Regional
Structural Failure/Collapse Low Minor 50 yrs Localized
Supply Chain Interruption Low Minor 2-3 yrs Localized
Aircraft Crash Low Minor 10 yrs Regional
Adapted from FEMA IS-559 Toolkit

Matrix-Man

Hazard Vulnerability Matrix – Human
Location: Bobsville, OK
Date Completed: 7/17/20XX
Completed by: APUS
Hazard Probability Impact Frequency Distribution
List specific hazards which could occur in your community. Include only adversarial or human-caused hazards on this tab. High Major 50 yrs Regional
Moderate Minor 10 yrs County-wide
Low None 5-10 yrs Localized
None 2-3 yrs N/A
every year
several times per year
Cow Chip Festival High Major every year Localized
State High School Rowing Championship High Major every year Localized
Transportation Accidents High Minor several times per year Localized
Theft/vandalism Moderate Minor several times per year Localized
Civil Disturbance Moderate Minor several times per year Localized
Cybercrime Moderate Minor every year Regional
Pollution (Air, Water, Land) Moderate Minor every year County-wide
Entrapment/Rescue Moderate Minor every year Localized
Lost/Abuducted Child/Elderly Moderate Minor 2-3 yrs County-wide
Infectious disease outbreak Low Major 5-10 yrs County-wide
Terrorism CBRNE, ECO Low Major 50 yrs Regional
Active shooter Low Major 50 yrs Localized
Arson Low Minor 10 yrs Localized
Supermax Prison Low Minor 50 yrs Regional
Hostage Incident Low Minor 50 yrs Localized
Adapted from FEMA IS-559 Toolkit

Vuln-Nat

Hazard Vulnerability Spreadsheet – Natural
Location: Bobsville, OK
Date Completed: 7/17/20XX
Completed by: APUS
Type of Hazard Historical Occurrence Probability of Occurence Human Impact Property Impact Business Impact Mitigation Activities Internal Resources External Resources Total
Sourced from Hazard Vulnerability Matrix Has not occurred – 1 < 5% – 1 Low – 1 Low – 1 Low – 1 Low – 1 Low – 1 Low – 1 Low: < 2.0
Every 51-100 yrs – 2 5-10% – 2 Low – 2 Low – 2 Low – 2 Low – 2 Low – 2 Low – 2
Every 11-50 yrs – 3 10-20% – 3 Med – 3 Med – 3 Med – 3 Med – 3 Med – 3 Med – 3 Med: 2.1-3.5
Every 5-10 yrs – 4 20-40% – 4 High – 4 High – 4 High – 4 High – 4 High – 4 High – 4 High: > 3.5
Every 1-4 yrs – 5 > 40% – 5 High – 5 High – 5 High – 5 High – 5 High – 5 High – 5
Winter Storm 5 5 4 2 5 5 2 3 3.625
Severe Thunderstorm 5 5 3 2 2 5 2 3 3.125
Tornadoes 5 5 5 5 5 5 1 3 4.25
Drought 4 4 3 2 2 4 2 2 3.125
Wildfire 3 3 3 5 1 3 2 2 3.25
Dust Storm 1 2 1 4 2 3 1 2 2.75
Earthquakes 4 3 1 1 1 1 1 1 3.125
Heat Wave 2 3 2 1 2 2 2 3 2.625
Flooding 4 4 2 3 3 3 1 3 3.375
Hurricane 1 1 1 1 1 1 1 1 2.5
Adapted from FEMA IS-559 Toolkit

Vuln-Tech

Hazard Vulnerability Spreadsheet – Technological
Location: Bobsville, OK
Date Completed: 7/17/20XX
Completed by: APUS
Type of Hazard Historical Occurrence Probability of Occurence Human Impact Property Impact Business Impact Mitigation Activities Internal Resources External Resources Total
Sourced from Hazard Vulnerability Matrix Has not occurred – 1 < 5% – 1 Low – 1 Low – 1 Low – 1 Low – 1 Low – 1 Low – 1 Low: < 2.0
Every 51-100 yrs – 2 5-10% – 2 Low – 2 Low – 2 Low – 2 Low – 2 Low – 2 Low – 2
Every 11-50 yrs – 3 10-20% – 3 Med – 3 Med – 3 Med – 3 Med – 3 Med – 3 Med – 3 Med: 2.1-3.5
Every 5-10 yrs – 4 20-40% – 4 High – 4 High – 4 High – 4 High – 4 High – 4 High – 4 High: > 3.5
Every 1-4 yrs – 5 > 40% – 5 High – 5 High – 5 High – 5 High – 5 High – 5 High – 5
Information Technology Failure 5 5 2 1 5 3 2 3 3.5
Communications 5 5 2 1 5 3 2 3 3.5
Water 3 3 5 1 5 5 5 3 2.75
Power 1 5 5 1 5 3 1 4 3.375
Gas 3 2 4 1 3 2 1 3 3.125
Sewage 3 2 4 2 5 2 2 2 3.5
Hazardous Materials Release 2 2 4 3 4 2 2 4 3.125
Radiological Accident 1 1 5 3 4 1 1 4 3.25
Structural Failure/Collapse 2 2 3 5 3 2 3 3 3.125
Supply Chain Interruption 1 3 3 1 5 4 3 3 2.625
Aircraft Crash 4 1 1 1 1 3 3 1 2.375
Adapted from FEMA IS-559 Toolkit

Vuln-Man

Hazard Vulnerability Spreadsheet – Human
Location: Bobsville, OK
Date Completed: 7/17/20XX
Completed by: APUS
Type of Hazard Historical Occurrence Probability of Occurence Human Impact Property Impact Business Impact Mitigation Activities Internal Resources External Resources Total
Sourced from Hazard Vulnerability Matrix Has not occurred – 1 < 5% – 1 Low – 1 Low – 1 Low – 1 Low – 1 Low – 1 Low – 1 Low: < 2.0
Every 51-100 yrs – 2 5-10% – 2 Low – 2 Low – 2 Low – 2 Low – 2 Low – 2 Low – 2
Every 11-50 yrs – 3 10-20% – 3 Med – 3 Med – 3 Med – 3 Med – 3 Med – 3 Med – 3 Med: 2.1-3.5
Every 5-10 yrs – 4 20-40% – 4 High – 4 High – 4 High – 4 High – 4 High – 4 High – 4 High: > 3.5
Every 1-4 yrs – 5 > 40% – 5 High – 5 High – 5 High – 5 High – 5 High – 5 High – 5
Cow Chip Festival 5 5 5 2 5 5 4 3 3.5
State High School Rowing Championship 5 5 5 2 5 5 4 3 3.5
Transportation Accidents 5 5 3 2 2 3 2 3 3.375
Theft/vandalism 5 5 1 2 3 3 1 1 3.625
Civil Disturbance 4 3 1 1 3 3 1 2 3
Cybercrime 5 4 2 1 3 1 1 3 3.5
Pollution (Air, Water, Land) 5 4 2 2 2 1 1 3 3.5
Entrapment/Rescue 5 3 3 1 1 3 3 2 2.875
Lost/Abuducted Child/Elderly 5 2 2 1 1 3 3 2 2.625
Infectious disease outbreak 3 2 5 1 3 2 2 4 3
Terrorism CBRNE, ECO 1 1 4 2 4 1 1 3 3.125
Active shooter 1 1 4 1 3 1 2 1 3
Arson 1 1 3 5 3 1 3 3 3
Supermax Prison 3 1 2 1 1 1 1 3 2.625
Hostage Incident 1 1 3 1 1 1 3 3 2.25
Adapted from FEMA IS-559 Toolkit

RiskIdx-Nat

Hazard Vulnerability Matrix – Natural
Location: Bobsville, OK
Date Completed: 7/17/20XX
Completed by: APUS
Hazard Frequency Magnitude Warning Time Severity Special Characteristics & Planning Considerations Risk Priority
Sourced from Hazard Vulnerability Matrix Unlikely Negligible 24+ hours Negligible Low
Possible Limited 12-24 hours Limited Medium
Likely Critical 6-12 hours Critical High
Highly Likely Catastrophic Minimal Catastrophic
Winter Storm Highly Likely Catastrophic 12-24 hours Critical DOT & private snow removal, power/gas grid High
Severe Thunderstorm Likely Catastrophic 12-24 hours Critical Early Warning System, building codes Medium
Tornadoes Likely Critical 6-12 hours Catastrophic Early Warning System, building codes High
Drought Possible Catastrophic 24+ hours Limited Water rationing Low
Wildfire Possible Catastrophic Minimal Catastrophic Agricultural land High
Dust Storm Possible Catastrophic 12-24 hours Limited Agricultural land Low
Earthquakes Possible Catastrophic Minimal Negligible Tower, bridge Low
Heat Wave Possible Catastrophic 24+ hours Limited Power grid overload, Marina access Low
Flooding Likely Limited 6-12 hours Critical Bobsville creek bridge Medium
Hurricane Unlikely Negligible 24+ hours Negligible Coastal Refugee housing Low
Adapted from FEMA IS-559 Toolkit

RiskIdx-Tech

Hazard Vulnerability Matrix – Technological
Location: Bobsville, OK
Date Completed: 7/17/20XX
Completed by: APUS
Hazard Frequency Magnitude Warning Time Severity Special Characteristics & Planning Considerations Risk Priority
Sourced from Hazard Vulnerability Matrix Unlikely Negligible 24+ hours Negligible Low
Possible Limited 12-24 hours Limited Medium
Likely Critical 6-12 hours Critical High
Highly Likely Catastrophic Minimal Catastrophic
Information Technology Failure Possible Limited Minimal Limited Backup battery power supply and generator Low
Communications Possible Critical Minimal Critical Backup battery power supply and generator Medium
Water Possible Catastrophic Minimal Catastrophic Backup generator for reservoir treatment High
Power Likely Catastrophic Minimal Critical Backup power generators High
Gas Unlikely Critical Minimal Critical Medium
Sewage Possible Critical Minimal Critical Backup generator for treatment plant Medium
Hazardous Materials Release Possible Limited Minimal Catastrophic Hazmat training, basic PPE Medium
Radiological Accident Unlikely Catastrophic Minimal Catastrophic Disaster Co Nuclear Power Plant, maintain evacuation route Low
Structural Failure/Collapse Unlikely Limited Minimal Critical Tower, bridge Low
Supply Chain Interruption Possible Critical 12-24 hours Critical Interstate ramps, bridge Low
Aircraft Crash Possible Limited Minimal Limited National Guard & Private Airlines Low
Adapted from FEMA IS-559 Toolkit

RiskIdx-Man

Hazard Vulnerability Matrix – Human
Location: Bobsville, OK
Date Completed: 7/17/20XX
Completed by: APUS
Hazard Frequency Magnitude Warning Time Severity Special Characteristics & Planning Considerations Risk Priority
Sourced from Hazard Vulnerability Matrix Unlikely Negligible 24+ hours Negligible Low
Possible Limited 12-24 hours Limited Medium
Likely Critical 6-12 hours Critical High
Highly Likely Catastrophic Minimal Catastrophic
Cow Chip Festival Highly Likely Critical Minimal Critical Established event, mutual aid arrangements High
State High School Rowing Championship Highly Likely Critical Minimal Critical Established event, mutual aid arrangements High
Transportation Accidents Likely Negligible Minimal Limited Bridge, maintain evacuation route. Race track Medium
Theft/vandalism Likely Negligible Minimal Negligible Low
Civil Disturbance Possible Limited Minimal Limited Town Hall meetings Low
Cybercrime Possible Negligible Minimal Limited Govt offices, university Low
Pollution (Air, Water, Land) Possible Critical 12-24 hours Limited Lake/Reservoir, agricultural byproduct Low
Entrapment/Rescue Possible Negligible Minimal Limited Creek rapids, lake, livestock Low
Lost/Abuducted Child/Elderly Unlikely Negligible Minimal Limited Low
Infectious disease outbreak Possible Critical 24+ hours Critical Transport to larger hospitals Medium
Terrorism CBRNE, ECO Unlikely Limited Minimal Critical Mass gatherings, Govt Offices, Schools, Ag land Medium
Active shooter Possible Limited Minimal Critical Mass gatherings, Govt Offices, Schools Medium
Arson Unlikely Limited Minimal Limited Mass gatherings, Govt Offices, Schools Medium
Supermax Prison Unlikely Critical 6-12 hours Limited Alert system Low
Hostage Incident Unlikely Negligible Minimal Limited Govt offices, university Low
Adapted from FEMA IS-559 Toolkit

Assignment 2 – Online And TradOnline

/in /by

Grading Sheet

Major Assignment 2 Grading Sheet
Competency Requirements for full credit (optional for student use) Did you meet the requirements? Points possible Your points Scoring comments
Savings and Loan Analysis Name You have entered your full name in the field provided. 1
Interests Rates The interest rates you have entered come from the mortgage rates table and match those for the months and years provided. 3
You have explicitly formatted the cells to display as Percentage with 2 decimal places of precision. 3
Monthly Costs and Savings Your Electric, Gas, Water, and Other entries are reasonable values, with at least two nonzero entries. For zero entries, you have explicitly entered values of 0. 4
Your Total Cost and Monthly Savings formulas are correct and use appropriate cell references. 4
All cost cells are formatted as Currency showing the $ symbol and with 2 decimal places of precision. 6
Savings Table You have brought forward your monthly savings amount, using Excel formulas. 3
Your number of contributions per year and number of years entries are correct. 6
Your formulas for total amount saved, total contributions, and total accrued interest are correct and use cell references. 18
All cells are explicitly formatted with the format given in the last column of the table. 18
Loan Table You have entered the correct number of contributions per year and number of years. 6
Your formulas for payment amount, total amount paid, and total amount of interest paid are correct and use cell references as inputs. 18
All cells are explicitly formatted with the format given in the last column of the table. 15
Comparison You have correctly brought forward your savings and loan amounts, using cell references. 6
Your savings and loan cells are explicitly formatted with the format given in the last column of the table. 6
You have answered the comparison questions correctly, answering either “yes” or “no” for each one. 3
Subtotals 120 0
Budget Cost Projection Inflation Rate Calculation Your reference CPI is correct for the month and year given. 1
Your next-year CPI, month, and year are correct. 3
Your inflation rate calculation is correct. 3
Your CPI values and inflation rate are explicitly formatted as indicated in the instructions. 3
Budget Projections You have correctly entered your Budget Total from cell G21 of the Monthly Budget sheet from your Major Assignment 1. 2
Your “value of t” entries are correct. 3
Your 1-year, 5-year, and 10-year projections are correct Excel formulas using cell references. 6
Your percent increase calculations are correct Excel formulas using cell references. 6
Your Current Budget, Projected Budget and Percent Increase cells are formatted as indicated in the instructions. 7
Subtotals 34 0
Conversions Monthly Savings You have brought forward your monthly savings amount from the Savings and Loan Analysis sheet, using an Excel formula with a sheet and cell reference. 2
Currency Conversions You have entered the first two letters of your first and last names, using the letter M if one or both names consist of only one letter. 4
You have chosen appropriate countries from the list provided below the table, using the procedure described in the instructions. 4
You have entered the date(s) on which you looked up the exchange rates for your currencies, and all dates are within 2 weeks of the due date of your assignment. 4
You have entered both the full name of your country’s currency and the correct currency code as indicated on the website. 8
You have provided each exchange rate to at least 5 significant digits, and the exchange rate matches the rate for the date you looked it up. 4
Your savings amount in the foreign currency is a correct Excel formula, using cell references. 8
Your calculation of the value of foreign currency units into dollars are correct Excel formulas, using cell references. (Note that the amount to convert is autogenerated and may differ from the amount shown in assignment resources.) 8
The cells containing your dates, savings amounts, and value of foreign currency converted to dollars are correctly formatted as specified in the last column of the table. 12
Subtotals 54 0
Totals 208 0
Percentage 100.00% 0.00%
Scaled out of 100 100.00 0.00

Savings and Loan Analysis

2 Enter your full name here (If fewer than 9 letters, add additional arbitrary letters) Assignment Advisory: You must use the latest desktop version of Excel for Microsoft 365 for this assigment. (This is provided free by GCU; contact the Help Desk for more information and help installing the software.) Using an earlier version of Excel or a different spreadsheet program may result in missing or corrupted template elements. Copying cells from or into this template may likewise result in corrupted data.
Savings
3 Look up three interest rates from the historical mortgage rate table, formatting them as Percentage with 2 decimal places. Make sure to enter these as percentage values. For example, 4.03 in the table is 4.03% or 0.0403. APR Year Your full name entry must be longer Your full name entry must be longer Your full name entry must be longer
APR Month Your full name entry must be longer Your full name entry must be longer Your full name entry must be longer
Interest Rate
4 Enter, or estimate, your monthly utility costs, then calculate your total monthly cost and monthly savings. Format all cells as Currency showing the $ symbol and with 2 decimals of precision. Electric Legend
Gas If a cell is shaded You should
Water Blue Enter a text response
Other Green Enter a number
Total Cost Gold Enter an Excel formula
Monthly Percent Savings Complete the first interest rate entry in section 3 above Any other color Make no changes
Monthly Savings (total cost times percent savings)
5 Complete this table for your 5-year, 10-year, and 15-year savings Calculation #1 (5-year savings) Calculation #2 (10-year savings) Calculation #3 (15-year savings) Format the entries in each row as…
Contribution amount (P) (Bring forward your Monthly Savings amount, using a formula, for each entry) …Currency with 2 decimal places
APR from the table (r) Complete the second interest rate entry in section 3 above Complete the second interest rate entry in section 3 above Complete the second interest rate entry in section 3 above
Number of contributions per year (n) …a Number with 0 decimal places
Number of years (t) …a Number with 0 decimal places
Total amount saved (A): …Currency with 2 decimal places
Total contributions: …Currency with 2 decimal places
Total accrued interest: …Currency with 2 decimal places
Loan
6 Continue by completing this table for your 5-year, 10-year, and 15-year loans, based on the principal and interest rates given with monthly payments Calculation #1 (5-year loan) Calculation #2 (10-year loan) Calculation #3 (15-year loan) Format the entries in each row as…
Loan principal (P) Your full name entry must be longer Your full name entry must be longer Your full name entry must be longer
APR from the table (r), with a slightly higher rate for longer loans Complete the third interest rate entry in section 3 above Complete the third interest rate entry in section 3 above Complete the third interest rate entry in section 3 above
Number of contributions per year (n) …a Number with 0 decimal places
Number of years (t) …a Number with 0 decimal places
Payment amount (PMT): …Currency with 2 decimal places
Total amount paid over the time of the loan: …Currency with 2 decimal places
Total amount of interest paid: …Currency with 2 decimal places
Comparison
7 Use Excel formulas to transfer your amounts from above After 5 years After 10 years After 15 years Format the entries in each row as…
Total savings from energy improvements …Currency with 2 decimal places
Total loan payments …Currency with 2 decimal places
Have you broken even at this point (yes or no)? (“Breaking even” here means that your total savings outweigh your total loan payments.)

1 In Major Assignment 1, you created a monthly budget, which included a recurring cost for utilities. Here, you’ll consider making some energy-saving home improvements and compare your potential savings against paying off the cost of those improvements. Below, you’ll start by entering and adding up the costs of your electric, gas, water, and other energy utilities. Then, given a percent savings due to your energy-saving improvements, you’ll calculate how much you’ll save over the next 5, 10, and 15 years if you contribute your monthly savings into an account with a given APR. Here, you’ll use the following formula for your calculations: given an amount P contributed at the end of each of n periods per year for t years and earning interest at an annual percentage rate of r, the total amount A accrued after t years is given by (in Excel format): A = P*((1+r/n)^(n*t)-1)/(r/n) Next, you’ll develop a cost to install energy-efficient improvements (installing energy-efficient doors and windows, adding insulation, upgrading to more efficient appliances or lights, and so on) and then calculate a monthly payment if you were to finance the installation cost by a loan of 5, 10, or 15 years. Here, you will use this formula: given a loan principal amount P and an annual interest rate of r, the payment amount PMT required to pay off the loan with n payments per year for t years (with payments made at the end of each period) is given by (in Excel format): PMT = P*(r/n)/(1-(1+r/n)^(-n*t)) For all the above calculations, you will look up rates in the following historical table of 30-year fixed mortgage rates, based on the years and months specified in step 6 below. http://www.freddiemac.com/pmms/pmms30.html

(Mortgage Rates)

http://www.freddiemac.com/pmms/pmms30.html

Budget Cost Projection

Your name (brought forward from the Savings and Loan Analysis sheet): 0
CPI Value Month Year
Reference CPI Your full name entry must be longer Your full name entry must be longer Legend
CPI one year later If a cell is shaded You should
Yearly inflation rate (r) Blue Enter a text response
Green Enter a number
Gold Enter an Excel formula
Any other color Make no changes
Value of t Projected Budget Percent Increase over Current Budget
Current Monthly Budget (B)
Monthly Budget next year
Monthly Budget in 5 years
Monthly Budget in 10 years

8 On the Monthly Budget sheet in Major Assignment 1, you evaluated your current expenses. Here, you will project your budget costs forward, using an inflation rate that you develop from values in the Consumer Price Index. As a first step, look up the CPI value for the given month and year as well as the CPI value one year later; then, calculate a yearly inflation rate based on those CPI values. Use this procedure to look up the CPI value: 1. Go to Bureau of Labor Statistics page link https://data.bls.gov/cgi-bin/surveymost?cu (or use link below) 2. Check the box to the left of text “U.S. city average, All items – CUUR0000SA0” 3. Press the “Retrieve Data” button at the bottom of the list. This should take you to a CPI table for about the last 10 years. Here, format your CPI entries as Number with 3 decimals of precision, and format your yearly inflation rate as a Percentage with 2 decimals of precision.

9 Next, enter your budget total from cell G21 of the Monthly Budget sheet from your Major Assignment 1. Then, use the following formula to project your monthly budget forward 1, 5, and 10 years into the future: A = B*(1+r)^t where A is the budget after t years; B is the initial budget; and r is the yearly inflation rate. Here, also calculate how much larger each budget is in percent than your initial budget. Format your Projected Budget entries as Currency with the $ symbol and 2 decimals of precision; format your Percent Increase cells as Percentages with 2 decimals of precision.

(CPI Values)

https://data.bls.gov/cgi-bin/surveymost?cu

Conversions

Your monthly savings in dollars Legend
If a cell is shaded You should
Blue Enter a text response
Green Enter a number
Gold Enter an Excel formula
Any other color Make no changes
Example First letter of your first name Second letter of your first name First letter of your last name Second letter of your last name Format this entry as
The letter T
Country starting with the letter (or next available letter) Tajikistan
The date that you looked up the conversion rate (must be within 2 weeks of your assignment due date) 5/23/20 Date
Full name of the country’s currency as listed on the XE website Tajikistani somoni
Currency code (ISO-4217) TJS
Exchange rate for the currency to at least 5 significant digits (or exact rate if there are fewer than 5 significant digits) 10.2686311694
Your savings in the country’s currency. Note that you must enter a formula here and then format the cell to display the currency code; do not enter text in this cell. [$TJS] 0.00 Currency with the country’s currency code as a symbol
Your full name entry must be longer $97.38 Currency with the $ symbol
Choose your countries from this list
Afghanistan Cambodia Guatemala Lebanon Pakistan Switzerland
Albania Canada Guernsey (UK) Liberia Papua New Guinea Syria
Algeria Cayman Islands (UK) Guinea Libya Paraguay Taiwan
Angola Chile Guyana Macau (China) Peru Tanzania
Argentina China Haiti Madagascar Philippines Thailand
Armenia Colombia Honduras Malawi Poland Tonga
Aruba (Netherlands) Comoros Hong Kong (China) Malaysia Qatar Trinidad and Tobago
Australia Congo, Democratic Republic of the Hungary Maldives Romania Tunisia
Azerbaijan Costa Rica Iceland Mauritania Russia Turkey
Bahamas Croatia India Mauritius Rwanda Turkmenistan
Bahrain Cuba Indonesia Mexico Saint Helena (UK) Uganda
Bangladesh Czechia International Monetary Fund (IMF) Moldova Samoa Ukraine
Barbados Denmark Iran Mongolia Sao Tome and Principe United Arab Emirates
Belarus Djibouti Iraq Morocco Saudi Arabia United Kingdom
Belize Dominica Isle of Man (UK) Mozambique Serbia Uruguay
Bermuda (UK) Dominican Republic Israel Myanmar (formerly Burma) Seychelles Uzbekistan
Bhutan Egypt Jamaica Namibia Sierra Leone Vanuatu
Bolivia Eritrea Japan Nepal Singapore Venezuela
Bosnia and Herzegovina Ethiopia Jersey (UK) New Zealand Somalia Vietnam
Botswana Falkland Islands (UK) Jordan Nicaragua South Africa Wallis and Futuna (France)
Brazil Fiji Kazakhstan Nigeria South Korea Yemen
Brunei Gambia Kenya North Korea Sri Lanka Zambia
Bulgaria Georgia Kuwait North Macedonia (formerly Macedonia) Sudan
Burundi Ghana Kyrgyzstan Norway Suriname
Cabo Verde Gibraltar (UK) Laos Oman Sweden

10 On this second conversion sheet, you will convert your monthly savings into the equivalent amounts in several foreign currencies and convert a given amount of the local currency into the equivalent number of US dollars. Start by transferring your monthly savings from the Savings and Loan Analysis sheet, using an Excel formula that references the appropriate cell directly:

For each country, identify the name of the country’s currency, the currency code (based on the ISO-4217 standard), and the exchange rate for $1, using the following web page: https://www.xe.com/currencyconverter

11 Now, from the list below the table below, select four countries that start with the first two letters of your first and last names. If your first or last name is only one letter long, use the letter M as the second letter of each name that is one letter long. If there is no country starting with a particular letter or you have run out of countries to choose from for a particular letter, go to the next letter of the alphabet that you still have available choices for and select a country starting with that letter. (If you are at the letter Z, go back to A.)

(Currency Converter)

https://www.xe.com/currencyconverterThen, convert your monthly savings above into this currency and a given number of units of the local currency into dollars. These calculations must be Excel formulas that use a cell reference for the exchange rate; you may not use the currency converter link for this calculation (although you’re welcome to check your calculation there). Add special formatting as indicated in the last column of the table. Other entries may use general formatting. An example is provided for you. Note that this country is not available for you to choose from the list.

Professional Reflection

/in /by

HCM 490 Final Project Rubric

Overview The final project for this course is the creation of a Strategic Plan Presentation and Professional Reflection. The healthcare industry is constantly changing and healthcare professionals should be prepared for the challenge. As the final stop in your journey toward your Bachelor of Science in Healthcare Administration, you will integrate the knowledge and skills you have developed in previous coursework and over the duration of the term into a Capstone Assessment. Your assessment will consist of two components that will allow you to evidence knowledge, skills, abilities, and dispositional growth you have experienced during your program. In the first component, you will select an existing healthcare organization that fits one of the following areas of opportunity and develop a comprehensive strategic plan for this change.

1. Option 1: Organization is Offering a New Service – Create a strategic plan that will guide the organization in bringing to fruition a new service, such as offering portable MRIs, starting a new urgent care clinic, opening a new outpatient surgery center, etc.

2. Option 2: Organization is Expanding an Existing Service Area – Create a strategic plan that will guide the organization in expanding an existing service to an underserved population that needs attention in this area. Examples include: population that has limited access to primary care services, population-to-provider ratio indicating a shortage, groups of persons who face economic, cultural, or linguistic barriers to healthcare in the local area and reside in a specific geographic area, and so on

The second component of your Capstone assessment is a professional reflection, in which you will reflect upon your capstone, program, and professional experiences and draw connections and inferences about your growth, ethical practice, and professional goals. Evaluation of Capstone This capstone will be assessed somewhat differently than other courses you have taken online at SNHU. There are two (2) separate components which will be submitted at different times during the course; however, they all operate together to comprise the whole capstone experience and are not assessed separately. You will be evaluated on both as a unit in determining whether you have demonstrated proficiency in each outcome. Your instructor will guide you through this process, keeping a running narrative of your strengths and weaknesses in relation to the outcomes as you progress through the class. You must demonstrate proficiency in all six (6) outcomes to pass this capstone course. Your work is expected to meet the highest professional standards. The project is divided into five milestones, which will be submitted at various points throughout the course to scaffold learning and ensure quality final submissions. These milestones will be submitted in Modules One, Two, Three, Four, and Five. The final product will be submitted in Module Seven and Eight. In this assignment, you will demonstrate your mastery of the following course outcomes:

 

 

 

HCM-490-01: Engage diverse healthcare stakeholders using communications that reflect keen interpersonal skills, effective collaboration practices, and deep cultural competence

HCM-490-02: Demonstrate knowledge of microeconomic, macroeconomic and financial principles through monitoring and utilization of financial and economic data for decision-making and strategic planning

HCM-490-03: Utilize principles and functions of management to interpret market analyses for strategic planning and to foster organizational development, promote effective use of human resources, and enhance operations

HCM-490-04: Propose recommendations to improve the effectiveness and integration of information management systems at the various levels of healthcare organizations and achieve organizational goals

HCM-490-05: Assess contemporary policies, regulations, and governance structures relevant to the United States healthcare delivery system for their impacts to populations’ health and their implications for ethical decision-making

HCM-490-06: Promote dynamic organizational cultures that establish strategic visions, methodically analyze and interpret data based on sound epidemiological and statistical principles, and embrace change for continuous healthcare quality improvement

 

Prompt After choosing the topic for your course project, you will work to develop the three phases of your strategic plan: the introduction and assessment phase, the implementation, communication, and management phase, and finally the evaluation phase. The final strategic plan consists of a PowerPoint presentation including speaker notes and voice over. This first component will also inform your professional reflection, in which you will evaluate your experiences in this program, capstone experience, and field of interest, and discuss the importance and impact of ethical practice in healthcare. Capstone Component 1: Strategic Plan Your strategic plan must be submitted in the form of a comprehensive presentation to the Board of Directors of your selected institution for approval and buy- in. You have the flexibility to utilize PowerPoint or another comparable presentation tool as long as your instructor approves the submission file. Your presentation is expected be professionally crafted to the needs and specifications appropriate for the discipline, area of interest, and type of initiative you are proposing. Because your strategic plan will be different from others’ in your capstone experience, you will likely include different additional resources, information, visuals, and strategies for progress. At minimum, your presentation must address/include the following:

I. Phase I – Introduction and Assessment — In this section you will give background on your organization, introduce the project that precipitates the strategic plan and what your assessment tools and approach will be. Your introduction and assessment should include:

a. The mission, vision, values statements, structure, and current community position of the organization. b. Project topic that is the focus of the strategic plan, including the goal(s) of this project. c. An appropriate analysis tool to assess the impact of your project on your organization. d. The effect of internal and external factors on the feasibility and development of the project.

II. Phase II – Implementation and Communication Plans

a. Implementation Plan: Provide a comprehensive plan for implementation that includes: i. Target area or intended population and establish the goals.

 

 

 

ii. The timeline and implementation milestones of the initiative. iii. Financial impact of the initiative, including any necessary capital expenditures, necessary fundraising, or potential financial benefits. iv. Resources needed to effectively implement the initiative, including staffing, equipment, technology needs, and so forth. v. Compliance with all federal and state regulations relevant to the proposed plan.

vi. Potential ethical challenges and formulate plans for monitoring behavior, practices, procedures, and so forth. b. Communication and Management Strategy: Your total communication plan should address the strategies and practices you will employ to

communicate to the proper stakeholders at the proper times. In this section you should detail your comprehensive approach for how you will communicate this change and its impact, how you will keep people informed of the project’s progress, and how you will keep them informed of the project’s ongoing results.

III. Phase III – Evaluation Strategy: This plan for managing and measuring progress and success of your initiative should include the following: a. A discussion of the specific goals and milestones of implementation of the initiative. Lay out your goals in a clear, obtainable fashion and to

ensure that progress milestones are clear, reasonable, and consistent. b. Specific definitions of measures of progress towards obtaining the intended goals and a description of the tools that you would use to measure

progress. What strategies will be used to measure success, and how will adjustments be made should progress towards these goals fall short or change?

c. How do you intend to collect and analyze information to ascertain stakeholder satisfaction with the initiative? What information will be looked at, and who are the stakeholders that will be considered?

Capstone Component 2: Professional Reflection For the second and final component of your capstone, you will write an essay in which you discuss the process and outcomes of this project and your overall Healthcare Administration Program journey and experiences. You will also speak more specifically about how the project relates to your area of expertise/interest and your desired career path. Writing reflectively allows you to think deeply and consciously about your experiences, which is invaluable to successful practice in the field of healthcare administration. You should envision this component as a personal reflection on the capstone and your experience in the Healthcare Administration program as a whole. For instance, relative to the capstone, you could discuss what you did—or intended to do—and then consider what worked well, what challenges you faced, and what you would change or do differently to make your experience better. In reflecting on your time here at SNHU, you might discuss where you started, where you have ended up, where you see yourself going, etc. Note that this component is not about evaluating the capstone itself, but rather, your experience within the capstone project. Some of the issues to address in this final component of this capstone may include, but are not limited to:

● Overall, what was your capstone experience like? ● Reflect on the significance of the capstone in relation to your own experience at SNHU. ● How will you relate cultural competence or maintain cultural principles in your profession? ● How does your application of interpersonal skills and collaborative processes relate to your professional goals?

 

 

 

● How will you promote continuous healthcare quality improvement in your professional life?

Milestones Milestone One: Topic Selection Journal In Module One, you will submit your selected topic. In this journal, you will choose your topic and see if it is a viable issue for your Strategic Plan Presentation. This milestone will be graded with the Milestone One Rubric. Milestone Two: Introduction to Organization and Project In Module Two, you will submit your introduction to the organization and the specific need or issue your project will be addressing. This milestone will be graded with the Milestone Two Rubric. Milestone Three: Assessment Analysis In Module Three, you will submit the assessment analysis of your project on the organization. This milestone will be graded with the Milestone Three Rubric. Milestone Four: Implementation Plan In Module Four, you will submit the implementation plan for your project. This milestone will be graded with the Milestone Four Rubric. Milestone Five: Communication and Evaluation Plan In Module Five, you will submit your communication and evaluation plan for your project. This milestone will be graded with the Milestone Five Rubric. Final Submission: Strategic Plan Presentation In Module Seven, you will submit your strategic plan presentation. It should be a complete, polished artifact containing all of the critical elements of the final product. It should reflect the incorporation of feedback gained throughout the course. This submission will be graded with the Final Project Rubric. Final Submission: Professional Reflection In Module Eight, you will submit your professional reflection. It should be a complete, polished artifact containing all of the critical elements of the final product. It should reflect the incorporation of feedback gained throughout the course. This submission will be graded with the Final Project Rubric.

Deliverables Milestone Deliverable Module Due Grading

One Topic Selection Journal One Graded separately; Milestone One Rubric

Two Introduction to Organization and Project Two Graded separately; Milestone Two Rubric

Three Assessment Analysis Three Graded separately; Milestone Three Rubric

 

 

 

Four Implementation Plan Four Graded separately; Milestone Four Rubric

Five Communication and Evaluation Plan Five Graded separately; Milestone Five Rubric

Final Submission: Strategic Plan Presentation

Seven Graded separately; Final Project Rubric

Final Submission: Professional Reflection Eight Graded separately; Final Project Rubric

 

Final Project Rubric Guidelines for Submission: Your Strategic Plan will be submitted in the form of a presentation. You may use any media to prepare the visuals for your presentation, such as PowerPoint or prezi. You also have the ability to submit presentation speaker notes in place of audio recording, if approved by your instructor. Your Professional Reflection should be submitted in the form of a well-crafted, reflective essay, most likely consisting of 3 pages. For both submission artifacts, you should properly cite research and references in discipline-appropriate format. The “Possible Indicators of Success” are examples for you and the instructor of the types of concepts to look for to demonstrate proficiency. They are neither exhaustive nor prescriptive, and should be used as guides for illustrating how your capstone embodies the outcome. You must show proficiency in all six (6) outcomes to be successful in the capstone course.

HCM-490-01: Engage diverse healthcare stakeholders using communications that reflect keen interpersonal skills, effective collaboration practices, and deep cultural competence

Proficient 100%

Not Proficient 0%

Possible Indicators of Success

Does the student demonstrate the ability to create buy-in among internal and external stakeholders for their proposed initiative?

Does the student demonstrate the ability to apply ethical and cultural principles to their program planning, implementation and evaluation processes?

Does the student demonstrate the ability to collaborate with others working toward a common healthcare goal?

Does the student demonstrate the ability to recognize the importance of developing their own interpersonal skills?

HCM-490-02: Demonstrate knowledge of microeconomic, macroeconomic and financial principles through monitoring and utilization of financial and economic data for decision-making and strategic planning

Proficient 100%

Not Proficient 0%

 

 

 

Possible Indicators of Success

Does the student demonstrate the ability to effectively establish estimates of financial impacts of health initiatives?

Does the student demonstrate the ability to evaluate resources needed to effectively implement the project?

Does the student demonstrate the ability to work collaboratively with leadership and other key figures in the projects development and implementation in designing and delivering an effective initiative?

Does the student demonstrate the ability to illustrate the important data points required to support the financial decision making process?

HCM-490-03: Utilize principles and functions of management to interpret market analyses for strategic planning and to foster organizational development, promote effective use of human resources, and enhance operations

Proficient 100%

Not Proficient 0%

Possible Indicators of Success

Does the student demonstrate the ability to formulate a target area or population?

Does the student demonstrate the ability to develop a project timeline and establish goals?

Does the student demonstrate the ability to evaluate findings and develop specific action plans intended to improve initiative outcomes/goals?

Does the student demonstrate the ability to effectively show the steps involved to change/enhance a service?

HCM-490-04: Propose recommendations to improve the effectiveness and integration of information management systems at the various levels of healthcare organizations and achieve organizational goals

Proficient 100%

Not Proficient 0%

Possible Indicators of Success

Does the student demonstrate the ability to identify internal and external strengths and weaknesses that could impact project outcomes?

Does the student demonstrate the ability to develop a project timeline with integrated milestone completion dates?

Does the student demonstrate the ability to apply evidence-based practices and tools in creating an initiative to achieve organizational goals?

HCM-490-05: Assess contemporary policies, regulations, and governance structures relevant to the United States healthcare delivery system for their impacts to populations’ health and their

Proficient 100%

Not Proficient 0%

 

 

 

implications for ethical decision-making

Possible Indicators of Success

Does the student demonstrate the ability to assess federal and state regulations relevant to the project and their potential impacts?

Does the student demonstrate the ability to use evidence-based ethical decision-making and critical thinking to support outcomes and goals?

Does the student demonstrate the ability to address potential ethical challenges?

Does the student demonstrate the ability to employ communications skills that consider and are sensitive to stakeholders and those impacted by the initiative?

HCM-490-06: Promote dynamic organizational cultures that establish strategic visions, methodically analyze and interpret data based on sound epidemiological and statistical principles, and embrace change for continuous healthcare quality improvement

Proficient 100%

Not Proficient 0%

Possible Indicators of Success

Does the student demonstrate the ability to integrate the organization’s mission, vision, and values into the project goals?

Does the student demonstrate the ability to define measures of progress towards intended goals?

Does the student demonstrate the ability to evaluate needs and formulate initiatives for improvement within the changing world of healthcare?

 

 

 

  • HCM 490 Final Project Rubric
    • Overview
    • Prompt
    • Milestones
    • Deliverables
    • Final Project Rubric

SPC M2:Discussion

/in /by

Using Chapter 5 from the textbook as a basis, answer ONE of the following questions and use AT LEAST 2 TERMS FROM THE TEXTBOOK in your initial post. Make sure to CITE the textbook as a source.

  • The Sapir-Whorf hypothesis says that our language shapes our reality. Please reflect on ONE of the following questions:
    • There are indigenous languages in North and South America that lack possessive and perosnal pronouns (which means th elanguage does not have words for “I”, “you”, “mine” or “yours”). Based on the Sapir-Whorf hypothesis, what does that tell us about the respective culture in which the language is spoken?
    • If you speak more than one language, have you ever come across words that are difficult to translate into another language? Have yo uencountered words that seem to be “missing” in another language? What does that say about the two cultures in which the languages are spoken?
    • In the English language, we have many more negative words to describe women than men, and many names for professions/jobs do not have a feminine form of the word at all. Based on the Sapir-Whorf hypothesis, what does that say about how English-speaking people think about women?