Write 2 pages of self-critique the budget you prepare. One page for 12-month-budget based on the data using excel application.
Data:
1. Ages 65 and older CD cases per year = 1,500 hospitalized (IP) stays. Re-admissions in less
than 30 days for both areas is at 15%, and these are not paid by Medicare if re-admitted in less
than 30 days. Average cost for IP is $18,000 for the average three-day stay. In the first year,
20% of this entire population is willing to work with a nurse navigator currently based on
interviews and they project this to grow to 25% after the first year.
2. You are 1 FTE, paid $44 per hour as the manager plus a 33% benefits package, with $100
phone stipend, and no car or travel coverage.
3. Space, office equipment, office phones, and office supplies will be provided by the hospital for
free for three years.
4. The office has one staff assistant that takes messages and calls RNs when needed. Staff
assistant is paid $18 per hour, 33% benefit package, and works 2080 hours/yr.
5. Navigator on-going work load for one year is expected to be 100 clients.
6. One navigator will need 40 hours of classroom training on the program and practice model
before starting the workloads. The trainer can be the manager or an outside agency that costs
$1200 per nurse trained in a single week session and a minimum number of nurses per session
of 4.
7. FT Navigators will be given a $100 phone stipend for using their own cell phones. PT get $50
monthly stipend.
8. Navigators are experienced RNs who are paid $35 per hour plus a 33% benefit package for FT,
and $42 per hour without benefits for PT (you decide the best mix).
9. Navigators work (FT) 2080 hours per year. PT is up to 1040 maximum hours per year.
10. Navigators need supplies for home visits that equal $40 per home visit.
11. Transportation has three options you pick the option you want:
* OPTION #1: Leased hybrid cars for $225 per month with maintenance included and insurance
of $75 per month.
* OPTION #2: Use their own vehicle. Pay $0.55 per mile, plus personal car usage fee of $50
per month. If there is a car crash using their own vehicle, there is a 100% car repair or payoff
fee that is paid through underwriter insurance at $100/mo. per car.
* OPTION #3: Purchase cars at $22,000 per car, $75 per month insurance,(not-for-profit
institution). Depreciate at 10% per year for five years. (All options have the following: Fuel is
expected to cost $3.10/gal., hybrids get 45 miles per gallon, and personal cars get 20 miles
per gallon. Each navigator travels 250 miles per month on average.)
A. Using Excel: create a 12-month budget for the program based on the data above
B. Create a list of assumptions on which your budget is based. Ex: The budget is based on
Revenue and expenses
C. Self-critique the budget you prepare (2 pages). Please include the following in your self-critique:
1. State the level of confidence you propose in your estimates.
2. Can you predict or anticipate any possible deviations from your budget estimates? If so,
explain why.
3. Is your budget fixed/static (not adjusted for volume) or flexible (adjusted for volume) during
the year?
