Employment and Business entrepreneurship 

Starting and managing a practice

Independent contactor.

 

Presentation

Business Ideas for Nurse Practitioner

Entrepreneur

     

Nurse practitioners can practice in many locations and can be a clinical practice as well as a consulting business, educational business. Read through the list and use it to develop your own business plan presentation. The presentation must have no more than 15 slides including the title and reference page and must have the following headings:

1. Concept Statement: What are the benefits of your product or service? Presenting the practice idea, reason for selecting this area and summarizes the general plan.
2. Marketing Plan: What is the target market and how will you penetrate it? Presents the need for the practice, who it will be marketed to and why that group. Present a sample of a marketing strategy (i.e. magazine, tv or radio ad)
3. Development: How will you develop and produce the product or service? What are the risks of the venture and what can you do to reduce these risks?
4. Finance & Accounting: What are the financial implications of the plan? What resources, including funding, are required to successfully create the business plan? Show how you will support the business (billing). Expenses, contracts, building space et.  
5. Legal Considerations: Identify any legal considerations the business team might foresee. Collaboration, protocols, state regulations, local regulation, licenses, certifications needed the business.

   

Clinical   Practice

Consulting  

Educational  

Retail  

Other

A practice providing drug screening   (pre-employment, legal documentation, etc

Corporate Wellness Consultant

Continuing Education Provider – yourself as   the teacher, bring in other providers to do the teaching

Health and Beauty Spa providing aesthetic   skin care treatments and other services

Author

Aesthetics

Infection Control Consultant

Prep Courses for certificate and or   licensing exams

Nutritional and Herbal Supplements

Speaker

Corporate Practice o Wellness, Primary Care,   Occupational

Occupational Health Consultant

Training of nurses, NP’s (AED, PALS, ACLS,   EKGs, Specialty Procedures,, etc)

Health Food Retail Store

Radio Show Personality

Diabetes Specialty Practice

Case Manager – such as for Geriatrics, life   planning, estate planning

Public Health Education to the public

Fitness Facility/Spa

TV Show Personality

HIV/AIDS Specialty Care

Health Coach – shouldn’t this emerging   field belong to Nurses and Nurse Practitioners? o Wellness, Lifestyle   changes, Menopause, etc

 

Own a retail health clinic

Product Developer

Holistic/Alternative Health Care Practice

Staffing Agencies

 

 

Legal consultants

Holistic/Alternative Health Care Practice

Patient Care Navigator

 

 

Adult Day Care business

0

 

Classic Gardens and Landscapes counts responses to specialty promotions to determine effectiveness. You use SUMIFS and an IFS formula to complete the summary. You also calculate insurance statistics and display full names in one cell.

[Student Learning Outcomes 6.1, 6.2, 6.3, 6.6, 6.7]

File Needed: ClassicGardens-06.xlsx (Available from the Start File link.)

Completed Project File Name: [your name]-ClassicGardens-06.xlsx

Skills Covered in This Project

• Nest MATCH and INDEX functions.
• Create DSUM formulas.
• Build an IFS function.
• Build SUMIFS formulas.
• Use TEXTJOIN to join labels.

1. Open the ClassicGardens-06 start file. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
2. Create a nested INDEX and MATCH function to display the number of responses from a city.
   1. Click the Mailings sheet tab and select and name cells A3:D28 as Responses.
   2. Click the Mailing Stats sheet tab.
   3. Click cell B21 and type Carthage.
   4. Click cell C21, start an INDEX function, and select the first argument list option.
   5. Choose or type the Responses range name for the Array argument.
   6. Click the Row_num box and nest a MATCH function. Select cell B21 for the Lookup_value and cells A3:A28 on the Mailings sheet for the Lookup_array. Click the Match_type argument box and type 0.
   7. Click INDEX in the Formula bar. Click the Column_num box and nest a second MATCH function to look up cell D3 on the Mailings sheet in the lookup array A3:D3.
   8. Click the Match_type box and type 0 (Figure 6-106) and click OK. The result displays as 343.00.Figure 6-106 Nested MATCH and INDEX functions
   9. Format the results to show zero decimal places.
   10. Type Smyrna in cell B21.
3. Use DSUM to summarize mailing data.
   1. Select the Mailings sheet and note that number mailed is located in the third column and response data is in the fourth column.
   2. Click the Criteria sheet tab. Select cell B2 and type lan* to select data for the Landscape Design department.
   3. Type law* in cell B5 for the Lawn & Maintenance department.
   4. Type pat* in cell B8 for the Patio & Furniture department.
   5. Click the Mailing Stats sheet tab and select cell B7.
   6. Use DSUM with the range name Responses as the Database argument. Type 3 for the Field argument (# Mailed column), and enter an absolute reference to cells B1:B2 on the Criteria sheet as the Criteria argument.
   7. Copy the formula to cell C7 and edit the Field argument to use the fourth column (# Responses).
   8. Use DSUM in cells B8:C9 to calculate results for the two remaining departments.
4. Use SUM in cells B10:C10.
5. Format all values as Comma Style with no decimal places.
6. Create an IFS function to display a response rating. Note: If your version of Excel does not include the IFS function, build the following nested IF function =IF(C7/B7>=20%,$C$15,IF(C7/B7>=15%,$C$16,IF(C7/B7>=11%,$C$17,$C$18))) to display the rating.
   1. Click cell D7. The response rate and ratings are shown in rows 14:18.
   2. Start an IFS function and select C7 for the Logical_test1 argument. Type / for division and select cell B7. Type >=20% to complete the test.
   3. Click the Value_if_true1 box, select C15, and press F4 (FN+F4) (Figure 6-107).Figure 6-107 First Logical_test and Value_if_true arguments
   4. Click the Logical_test2 box, select C7, type /, select cell B7, and type >=15%.
   5. Click the Value_if_true2 box, click cell C16, and press F4 (FN+F4).
   6. Complete the third and fourth logical tests and Value_if_true arguments (Figure 6-108).Figure 6-108 Completed IFS function arguments
   7. Copy the formula in cell D7 to cells D8:D10.
7. Use SUMIFS to total insurance claims and dependents by city and department.
   1. Click the Employee Insurance sheet tab and select cell E25.
   2. Use SUMIFS with an absolute reference to cells F4:F23 as the Sum_range argument.
   3. The Criteria_range1 argument is an absolute reference to cells E4:E23. The Criteria1 argument is bre* to select the city of Brentwood.
   4. The Criteria_range2 argument is an absolute reference to cells D4:D23, the department column, with criteria of lan* to select the Landscape Design department.
   5. Click OK. The result for cell E25 is 10.
   6. Build SUMIFS formulas for cells E26:E28 based on the criteria displayed in cells C26:C28.
   7. Format borders to remove inconsistencies, if any, and adjust column widths to display data.
8. Use TEXTJOIN to display names. Note: If your version of Excel does not include the TEXTJOIN function, use CONCAT or CONCATENATE to build the function.
   1. Click the Full Names sheet tab and select cell E4.
   2. Start a TEXTJOIN function and press Spacebar for the Delimiter argument.
   3. Click the Text1 box and select cell C4.
   4. Complete the Text2 and Text3 arguments to show middle and last names and click OK (Figure 6-109).Figure 6-109 Delimiter is a space
   5. Copy the formula to display full names in column E.
9. Save and close the ClassicGardens-06 Excel workbook (Figure 6-110).

Find a peer-reviewed scholarly journal article discussing blockchain technology. Complete a review of the article by writing a 2-3 page overview of the article. This will be a detailed summary of the journal article, including concepts discussed and findings. Additionally, find one other source (it does not have to be a peer-reviewed journal article) that substantiates the findings in the article you are reviewing. 

You should use the UC library (https://www.ucumberlands.edu/library) and/or Google Scholar to find these types of articles (https://scholar.google.com/ )

Once you find the article, you will read it and write a review of it.  This is considered a research article review.

Your paper should meet these requirements: 

Be approximately four to six pages in length, not including the required cover page and reference page.

Follow APA 7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.

Support your answers with the readings from the course and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. The UC Library is a great place to find resources.

Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing.

Instructions: You are required to answer the following questions. You should save your answers in a Word document for submission. Please do not repeat the questions on your answer sheet. Instead, please list the answers numerically/sequentially by simply utilizing 1, 2, 3, and 4. Each assignment must have a cover page listing your name, the name of the assignment, and the date. The cover page does not count towards the word count. For each assignment, you are expected to answer the assigned questions in your own words. Each assignment paper should be at least 250 words. Papers less than the required 250 words will get zero. This does not mean each question requires a 250-word response; rather, the total number of words for answering the questions must total more than 250 words. Documents should include a Title Page, maintain double spacing with 12 pt. Times font and 1” margins. If you have questions related to formatting, please ask and I will gladly assist you. Note: The Title Page does NOT count as one of the pages of text. For each assignment you must answer the specified questions for the assignment. 

1. List and describe three of the classifications of special events. 

2. What are the four primary challenges for event planners and managers? List and describe them below. 

3. Distinguish between transactional and transformational leadership.

 4. Discuss the changing role of managers.

I. Answer the following multiple choice questions (2 points each):

1.  Fiscal Policy is __________.

a) Limits on the amount of a product imported

b) Recurring pattern of ups and downs in the nation’s business activity

c) Government’s taxing and spending decisions which are intended to improve the economy

d) Deep extended decline in the nation’s economy.

2. Which of the following is NOT an important U.S. import?

a) electronic products   b) motor vehicles  c) aircraft   d) coffee and tea

3. When a country spends more on imports than it earns on exports, it has a _________.

a)  trade deficit   b) trade surplus   c) balanced trade   d) shortage of trade

4. A tax on imported goods is called ________.

a) entrance tax    b) exit tax    c) tariff    d) excise tax

5. A deep, extended decline in a nation’s economy is a ________.

a) deficit  b) recession   c) depression   d) displacement

6.  When individual nations prosper, the world economy _______.

a) grows   b) declines   c) lapses   d) competes

7.  Goods and services sold by one country to another are called its________.

a) imports   b) exports  c) GDP   d) bartering

8.  The price of one currency in terms of another currency is the ________.

a) inflation  b) absolute rate   c) exchange rate   d) recession rate

9.  Countries do NOT usually benefit from trading with each other.  

True or false 

10. Monetary policy is _________.

a) Government’s efforts to help stabilize the economy by managing interest rates, the availability of loans, and the supply of money

b) Value of all nation’s exports minus the value of its imports

c) Tax on imported goods

d) The current value of all goods and services produced in a country in a year

II. Short Answer (20 points each)

1. The exchange rate for money entering Mexico is $1=10.80 pesos. During your visit to Mexico the exchange rate changes to $1=15.00 pesos. If you took $500 into the country exchanged it for pesos and then left with 500 pesos, how many dollars worth of pesos would you have when you exchanged it back into dollars?

2. Why do labor costs affect where multinational corporations choose to produce their goods?

3. How do changes in business activity in one nation affect other nations?

4. If the U.S. dollar increases in value how does that affect the American traveling in Europe? How would it affect the European visiting the United States?