Create the annual budget by month worksheet

Assignment Help Finance Basics
Reference no: EM131297936

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 1a Instructions:

Research wait times and the effect on bottom lines (profits) and patient satisfaction. Also, research the benefits of nurse practitioners to doctors' offices to determine if this would be the ideal solution for Physicians United. Then you should be able to explain the benefits of tablets (for the solution section).

Part 1b Instructions:

Prepare the white paper as outlined above. Assume you are hiring Jenna Thomas as the Nurse Practitioner for Physicians United.

Hint: Re-read the Background and Information to determine who your target audience is and what valuable information would help sell your business to potential new clients.

The structure of the Advertisement section should be as a flyer. As you are considering the layout of your flyer, think about flyers that you have seen in the past. Remember elements that captured your attention and elements that turn you away from reading the flyer.

Part 2a Instructions:

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:

Along with 25 patients, you will want to include

When the patient started with the practice, what  insurance the patient holds, 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).

Sort your patients by doctors and then by most recent visit.

The Patient and Forms List should be professional formatted.

Part 2b Instructions:

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).

Part 2c Instructions:

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.

The pie chart should not be located on the page with the monthly expenses. Instead, it should have its own tab.

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.

Part 3a Instructions:

Prepare a PowerPoint presentation that demonstrates the key attributes of your business. Ask yourself: 1) What services, programs, clinics, and characteristics sets Physicians United apart from other medical practices here in Ormond Beach? 2) Why should patients bring their business to Physicians United?

Utilize skills gained from the SIMnet lessons. Failure to do so will cause a reduction in grade.

Part 3b Instructions:

In addition to the PowerPoint, you decided to create a handout that the audience can take home with them. The choice of handout is up to you. It can be a flyer of key facts or some other type of item that will help the people remember Physicians United. Handout should be done using Word. This is a handout they will take home with them after the presentation so ensure that has necessary selling information on the business. Think about what you learned in Word section. Review your audience. Consider this handout might get laid down on someone's desk and picked up a week or two later, what about the handout would remind the person why they should think about setting an appointment with Physicians United?

Reference no: EM131297936

Questions Cloud

How many francs would a dollar buy tomorrow : Suppose that the exchange rate is 0.65 dollars per Swiss franc. If the franc appreciated 7% against the dollar, how many francs would a dollar buy tomorrow?
Organization system archetypes : For the fifth section of your Term Project you are to write a 3 page paper, APA formatted. The paper will include an effective Introduction and Conclusion.
What percentage of the organizational budget does us provide : What percentage of the organizational budget does the United States provide (see attached budget report)? What does this organization do? What is its mission?
Describe current global economic conditions : Describe current global economic conditions and their effect on local macroeconomic indicators in your selected country. Consider forecasts for population growth, GDP growth, GDP per capita growth, export growth, and sales growth
Create the annual budget by month worksheet : 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
What will be the impact of the inventory control problem : What specific actions should the company take in the area of inventory control? Support your recommendations with conceptual and economic analysis
How can credit terms be used in marketing : How can credit terms be used in marketing?- How can you influence the payment for your products? Is there any risk to extending credit?
What would be the consumer surplus : Big Top is the only circus in the nation. Table 2 sets out the demand schedule for circus tickets and the cost schedule for producing the circus.
Organization evaluates itself on the wrong things : What happens when an organization evaluates itself on the wrong things? How can this happen and how can organizations work early on in the process to avoid or minimize the issues?

Reviews

Write a Review

Finance Basics Questions & Answers

  What is the required return on the companys stock

Keenan Co. is expected to maintain a constant 6.0 percent growth rate in its dividends indefinitely. If the company has a dividend yield of 7.8 percent, what is the required return on the company's stock?

  Debt or equity

Assume you are the CFO of a major company who is deciding in whether to issue debt or equity in order to finance the firms operations which are growing more than 15 percent a year,

  What are the imperfections of accrual accounting is it

consider the following while accrual accounting information is imperfect ignoring it and making cash flows the basis

  Before completion of final accounts

The trial balance of M/s. J Ltd. on 31st March, 19x1 did not balance. The difference amount of Rs.76 was transferred to the credit of suspense account, and the accountant proceeded with the preparation of final account. Before completion of final acc..

  Should ellen take the cash or the note

The riskless rate is 3.4%. Find the value of the cash offer, and the value of the note. Should Ellen take the cash or the note?

  The internal rate of return irr of a capital investment

Assume that Goodhealth Clinic has fixed costs of $1,000,000 and a total cost forecast of $1,500,000 at a volume of 20,000 patient visits. What is the clinic's variable cost rate? a. $25 b. $20 c. $15 d. $10 e. $ 5 Question 2 Assume that John Richards..

  Assuming that one apple was rotten and he sells each of

a shopkeeper buys 10 apples at a certain price . but he steals three more from the dealer . assuming that one apple

  Preparation of budget for day care by municipality

Prepare the baseline 2000 monthly budget for the daycare. (You can assume a calendar year.) Determine the total surplus and deficit for each month

  Create a personal balance sheet for your assets

Create a personal balance sheet for your assets, liabilities, and net wort - create a personal cash flow statement with your total income, expenses and your net cash flow.

  Use the organization website or other published information

Locate an organization in the news. Is the organization validating its values by its actions? Use the organization's website or other published information to define the values and explain your answer.

  What is the bond''s coupon rate

1. Consider a bond with a price of $1,140.25, 10 years to maturity, $1,000 face value, pays quarterly coupons, and has a yield to maturity of 8.9%. What is the bond's coupon rate?2. Suppose a stock's beta decreases and the market risk premium is posi..

  Who can travel from the us to cuba under the current policy

Who can travel from the U.S. to Cuba under the current policy? Why are U.S. airlines eager to enter the Cuban market?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd