My first son was born on July 5, 2002. On the day he was born, I opened a 529 Plan for him and deposited $1,000. Every year on his birthday, I contributed $100 more than the previous year. I will make my last contribution this year on his 18^th birthday. As a conservative investor, I invested the money in a money market that paid 4% annually.

(b) How much money is in my son’s 529 Plan on his 18^th birthday (after I make my final contribution)?

(c) What single lump sum contribution could I have made on July 5, 2002, without any subsequent annual contributions, that would have resulted in the exact same account value on his 18^th birthday?

    Table Name: CUSTOMERS_1

CUST_NUM CUST_LNAME          CUST_FNAME          CUST_BAL

2001    James William           $2,999

2002    Crane Frasier             $983

    Table Name: CUSTOMERS_2

CUST_NUM

            CUST_LNAME          CUST_FNAME          CUST_BAL

1999    Anderson         Anne $510

2000    Bryant Juan     $21

2002    Crane Frasier             $983

2003    Dent    George            $1,790

    Table Name: CUST_INVOICES

INV_NUM     CUST_NUM INV_DATE    INV_AMOUNT

9000    2000    23-Mar-16       245

9001    2001    23-Mar-16       260

9002    2001    30-Mar-16       275

9003    1000    10-Apr-16       286

using this information, i need help formulating an sql query:

    Write a SQL code that will show CUST_NUM, CUST_LNAME, and CUST_FNAME for the one who has minimal INV_AMOUNT

Community health nurses practice in a variety of settings. Choose one of the following CH settings and describe what you have learned about the setting and the role(s) of the nurse in that setting (see Nies & McEwen, 2015, Chapters 29–33).

School nursing

Occupational health nursing

Faith-based or parish nursing

Home health nursing

Hospice nursing

Forensic nursing

Correctional nursing

The federal government developed Healthy People as a set of national health objectives that are revised every 10 years. These objectives are very specific in order to guide and measure our nation's progress related to public health. Please visit http://www.healthypeople.gov/2020/topicsobjectives2020/ (Links to an external site.)Links to an external site.. Click on a topic area that relates to a role you chose to discuss. Click on the green Objectives tab in that topic area to choose one Healthy People 2020objective.

Discuss one specific, numbered Healthy People 2020 objective (not a goal) related to this community health role.

How could a community health nurse help meet this objective?

Chapter 20 – Developing a Service Plan at the Case

Fundamentals of Case Management Practice, skills for the human services - 5th ed by Nancy Summers

Please read the following case study and answer the questions to the best of your ability.

Case 20.1: Developing Dave's Service Plan

Dave is a 49-year-old bartender who is currently going through a divorce initiated by his wife. Dave and his wife have two children: a boy, aged 6 and a girl, aged 9. Dave states that he and his wife decided to separate and then divorce after his wife complained on numerous occasions about his work responsibilities. He states that his wife told him that his work hours and the social contacts he made as a result of his job at the bar were incompatible with the kind of family life she wanted for herself and her children. Dave co-owns his home with his wife and is letting her have the house for the sake of the children. He has taken up with a woman who frequents his bar and recently moved in with her in a different part of the town, "giving me a place to put my things."

Dave is requesting help in restoring his marriage and is looking for marriage counseling. He is not sure his wife will agree. Additionally, Dave wants help in considering alternative training or education so that he is no longer dependent on his skills as a bartender for his income.

Dave has a high school diploma and has completed four college courses, all of them general education courses. Dave has a close relationship with his sister who lives in the same part of the town where he is currently living. "She gives me a lot of support." He is a member of the St. Paul's Methodist church but has not been to church in over a year. Dave indicates that he joined the church in order to please his wife but never got much out of going there, though he likes the minister at the church. Dave describes his relationship with his daughter as close. Since he left, his daughter calls him every night to go over homework. Unfortunately, his work schedule often cuts these calls short or he is not able to take the calls.

Dave is willing to begin seeing a counselor on his own in the hope that his wife will join him at some point.

1. Describe Dave's presenting needs and concerns.

2. Describe the strengths and supports that Dave has.

3. Describe the weaknesses and/or obstacles that Dave is facing.

4. The following Treasury bond quote appeared in The Wall Street Journal on May 11, 2004:

9.125               May 09            100.09375       100.12500       …         ‐2.15

Why would anyone buy this Treasury bond with a negative yield to maturity? How is this possible?

Compute and Interpret Z-score

Balance sheets and income statements for Lockheed Martin Corporation follow. Refer to these financial statements to answer the requirements.

As of December 31, there were the approximate shares outstanding:
2005 - 434,264,432
2004 - 440,445,630

As of December 31, the company's stock closed at the following values:
2005 - $63.63
2004 - $55.55

(a) Compute and compare the Altman Z-scores for both years. (Do not round until your final answer; then round your answers to two decimal places.)
2005 z-score = Answer

2004 z-score = Answer

Use the following information to work Problem1 a) and b).

Why the tepid response to higher gasoline prices?

Most studies report that when U.S. gas prices rise by 10 percent, the quantity purchased falls by 1 to 2 percent. In September 2005, the retail gasoline price was $2.90 a gallon, about $1.00 higher than in September 2004, but purchases of gasoline fell by only 3.5 percent.

Source: The New York Times, October 13, 2005

1.   (2 points) Calculate the price elasticity of demand for gasoline implied by what most studies have found.

2.   (2 points) Compare the elasticity implied by the data for the period from September 2004 to September 2005 with that implied by most studies. What might explain the difference?

Twelve-hour shifts are problematic for patient and nurse safety, yet hospitals continue to keep the 12-hour shift schedule. In 2004, the Institute of Medicine (Board on Health Care Services & Institute of Medicine, 2004) published a report that referred to studies as early as 1988 that discussed the negative effects of rotating shifts on intervention accuracy. Workers with 12-hour shifts experienced more fatigue than workers on 8-hour shifts. In another study done in Turkey by Ilhan, Durukan, Aras, Turkcuoglu, and Aygun (2006), factors relating to increased risk for injury were age of 24 years or younger, less than 4 years of nursing experience, working in surgical intensive care units, and working for more than 8 hours. As a clinician reading these studies, what would your next step be?

R code:

## 2. __Basic dplyr exercises__

## Install the package `fueleconomy` and load the dataset `vehicles`. Answer the following questions.
install.packages("fueleconomy")
library(fueleconomy)
library(dplyr)
library(tidyr)
data(vehicles)

e. Finally, for the years 1994, 1999, 2004, 2009, and 2014, find the average city mpg of midsize cars for each manufacturer for each year. Use tidyr to transform the resulting output so each manufacturer has one row, and five columns (a column for each year). I have included sample output for the first two rows.

Output should like :

# make 1994 1999 2004 2009 2014
# 1 Acura NA 16.50000 17.33333 17.00000 20.60000
# 2 Audi NA 15.25000 16.20000 15.83333 19.08333