As follows. Please ask if any questionsPROFESSIONAL PROJECT FOR ISM2000
Professional Project Part 2
(Medical Office Option)
Who You Are:
Physicians United of Ormond Beach
1234 Hospital Drive
Ormond Beach, Florida 32174
Telephone: 386-676-8900
Web address: PhysiciansUnitedofOrmondBeach.com
Email: wecare@PhysiciansUnitedOrmond.com
Background and Information:
Doctors Fred Smith and Julia Caring founded Physicians United of Ormond Beach in 2000 after they
completed their residencies in Tennessee. Dr. Smith specializes in Family Practice while Dr. Caring
specializes in Internal Medicine. The practice has grown over the years as Drs. Smith and Caring have
focused on treating families instead of one target population.
Recently, Drs. Smith and Caring decided to research hiring a Nurse Practitioner, Jenna Thomas, to help
with the volume of business.
Jenna Thomas has been a NP for the last 7 years and was a RN for 15 years prior to seeking her ARNP
(Advanced Registered Nurse Practitioner) degree. After receiving her ARNP license, Jenna worked as a
NP for an Emergency Room and then as a NP for Internal Medicine Group both in Atlanta, Georgia.
During her 15 years as a RN, Jenna worked in ICU, the ER, Ambulatory Care, and Pediatrics. She would
bring a wealth of experience and knowledge to Physicians United.
What you are to do:
As the Office Manager, you are responsible for designing a new spreadsheet that will keep patient
information as well as if all required forms are signed as mandated by Federal and Office Policies in
addition to other data. You also were asked in the last staff meeting to create a spreadsheet showing
the last 12 months of monthly expenses and a graphical depiction to present in next month’s staff
meeting.
Part 2a Instructions (worth 25 pts):
1.) Prepare a list of 25 patients (you make them up). Include in the list all pertinent information you
would need to collect on patients in a doctor’s office. (If in doubt, here are a couple of websites I
found helpful: http://ncfamilydoctor.com/registration-forms/ and
http://www.memorialcare.org/memorialcare-medical-group/guides-tools/patient-formsmemorialcare-medical-group )
2.) Along with 25 patients, you will want to include
a) When the patient started with the practice,
b) what insurance the patient holds,
c)
d)
e)
f)
g)
h)
i)
co-pay amount per office visit according to their insurance,
which doctor the patient sees,
date of last visit,
the invoice amount for the last visit,
co-payed amount paid,
amount remaining after co-pay, and
if the following signed form on file: HIPAA, Medical Release, Emergency Contact, and
Financial Responsibility. (Note: utilize what you learned by Excel Chapters 2, 3, and 4).
3.) Sort your patients by doctors and then by most recent visit.
4.) The Patient and Forms List should be professional formatted.
Part 2b Instructions (worth 25 points):
1.) Create the annual budget by month worksheet based on last year’s Actual Expenses
provided below and the expected changes for each of the expense categories. Without
additional data, assume even spread over the twelve months. Remember this should be
formatted in a professional way as it would be used in the Annual Budget meetings
between the business executives (assume it will be a printed document when
formatting).
Expenses
2015
Notes for new budget
Actual
Expenses
Salaries Expense
$220,000
Salaries for year expected to grow 4%
Payroll Taxes Expense
30,000
Payroll Taxes expected to grow 2%
Rent Expense
36,000
Expected to remain the same
Equipment Rental Expense
13,200
Expected to remain the same
Advertising Expense
10,800
Expected to remain the same
Insurance Expense
30,000
Insurance Expense expect to grow 10%
Office Supplies Expense
6,000
Expected to remain the same
Travel Expense
6,000
Expected to remain the same
Utility Expenses
12,000
Utility Expense expected to grow 5% for year.
Total Expenses
$364,000
Part 2c Instructions (worth 10 points):
1) Create a pie chart to illustrate your 12 month expense record (show what you spent for the year
in each expense category). You are interested in knowing how much you spend per year in each
type of expense.
2) The pie chart should not be located on the page with the monthly expenses. Instead, it should
have its own tab.
3) The pie chart should be professional as it will be used in monthly administrative meetings or
possibly included in your business plan being presented to a bank.
What is due?
You are to submit Parts 2a, 2b and 2c to the Dropbox assigned for Professional Project Part 2.
PROFESSIONAL PROJECT FOR ISM2000
Professional Project Part 2
(Medical Office Option)
Who You Are:
Physicians United of Ormond Beach
1234 Hospital Drive
Ormond Beach, Florida 32174
Telephone: 386-676-8900
Web address: PhysiciansUnitedofOrmondBeach.com
Email: wecare@PhysiciansUnitedOrmond.com
Background and Information:
Doctors Fred Smith and Julia Caring founded Physicians United of Ormond Beach in 2000 after they
completed their residencies in Tennessee. Dr. Smith specializes in Family Practice while Dr. Caring
specializes in Internal Medicine. The practice has grown over the years as Drs. Smith and Caring have
focused on treating families instead of one target population.
Recently, Drs. Smith and Caring decided to research hiring a Nurse Practitioner, Jenna Thomas, to help
with the volume of business.
Jenna Thomas has been a NP for the last 7 years and was a RN for 15 years prior to seeking her ARNP
(Advanced Registered Nurse Practitioner) degree. After receiving her ARNP license, Jenna worked as a
NP for an Emergency Room and then as a NP for Internal Medicine Group both in Atlanta, Georgia.
During her 15 years as a RN, Jenna worked in ICU, the ER, Ambulatory Care, and Pediatrics. She would
bring a wealth of experience and knowledge to Physicians United.
What you are to do:
As the Office Manager, you are responsible for designing a new spreadsheet that will keep patient
information as well as if all required forms are signed as mandated by Federal and Office Policies in
addition to other data. You also were asked in the last staff meeting to create a spreadsheet showing
the last 12 months of monthly expenses and a graphical depiction to present in next month’s staff
meeting.
Part 2a Instructions (worth 25 pts):
1.) Prepare a list of 25 patients (you make them up). Include in the list all pertinent information you
would need to collect on patients in a doctor’s office. (If in doubt, here are a couple of websites I
found helpful: http://ncfamilydoctor.com/registration-forms/ and
http://www.memorialcare.org/memorialcare-medical-group/guides-tools/patient-formsmemorialcare-medical-group )
2.) Along with 25 patients, you will want to include
a) When the patient started with the practice,
b) what insurance the patient holds,
c)
d)
e)
f)
g)
h)
i)
co-pay amount per office visit according to their insurance,
which doctor the patient sees,
date of last visit,
the invoice amount for the last visit,
co-payed amount paid,
amount remaining after co-pay, and
if the following signed form on file: HIPAA, Medical Release, Emergency Contact, and
Financial Responsibility. (Note: utilize what you learned by Excel Chapters 2, 3, and 4).
3.) Sort your patients by doctors and then by most recent visit.
4.) The Patient and Forms List should be professional formatted.
Part 2b Instructions (worth 25 points):
1.) Create the annual budget by month worksheet based on last year’s Actual Expenses
provided below and the expected changes for each of the expense categories. Without
additional data, assume even spread over the twelve months. Remember this should be
formatted in a professional way as it would be used in the Annual Budget meetings
between the business executives (assume it will be a printed document when
formatting).
Expenses
2015
Notes for new budget
Actual
Expenses
Salaries Expense
$220,000
Salaries for year expected to grow 4%
Payroll Taxes Expense
30,000
Payroll Taxes expected to grow 2%
Rent Expense
36,000
Expected to remain the same
Equipment Rental Expense
13,200
Expected to remain the same
Advertising Expense
10,800
Expected to remain the same
Insurance Expense
30,000
Insurance Expense expect to grow 10%
Office Supplies Expense
6,000
Expected to remain the same
Travel Expense
6,000
Expected to remain the same
Utility Expenses
12,000
Utility Expense expected to grow 5% for year.
Total Expenses
$364,000
Part 2c Instructions (worth 10 points):
1) Create a pie chart to illustrate your 12 month expense record (show what you spent for the year
in each expense category). You are interested in knowing how much you spend per year in each
type of expense.
2) The pie chart should not be located on the page with the monthly expenses. Instead, it should
have its own tab.
3) The pie chart should be professional as it will be used in monthly administrative meetings or
possibly included in your business plan being presented to a bank.
What is due?
You are to submit Parts 2a, 2b and 2c to the Dropbox assigned for Professional Project Part 2.

Purchase answer to see full
attachment




Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.