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

  How should the examinations be priced

If the goal of the practice is to earn a 20% profit margin on each examination, how should the examinations be priced?

  Explain what is meant by business risk and financial risk

Explain what is meant by business risk and financial risk. Suppose Firm A has greater business risk than Firm B. Is it true that Firm A also ha a higher cost of equity capital? Explain.

  Trend-adjusted exponential smoothing model

After plotting demand for four periods, an emergency room manager has concluded that a trend-adjusted exponential smoothing model is appropriate to predict future demand. The initial estimate of trend is based on the net change of 30 for the three..

  What is its roe

A firm has a profit margin of 2.5% and an equity multiplier of 1.5. Its sales are $440 million, and it has total assets of $220 million. What is its ROE? Round your answer to two decimal places.

  What is the difference between term life insurance and whole

What is the difference between term life insurance and whole life insurance?

  Evaluate how many shares will be repurchased

Evaluate how many shares will be repurchased and what is the value of equity after the repurchase has been completed? What is the price per share?

  What is the corresponding effect on foreign investments

If the United States imports more goods from abroad than it exports, foreigners will tend to have a surplus of U.S. dollars. What will this do to the value of the dollar with respect to foreign currencies? What is the corresponding effect on forei..

  Abc corp earned 700 per share last year the company plows

abc corp earned 7.00 per share last year. the company plows back 35 of its earnings into projects yielding 18.

  What is finance report

1. What is finance report? 2. Explain how finacial statements can be used in predicting the position of an organization as well as in making decisions by management.

  Milwaukee surgical suppliesinc sells on terms of 310 net 30

milwaukee surgical suppliesinc sells on terms of 310 net 30. gross sales for the year are 1200000 and the collections

  What is the value of a 1000 par value bond with annual

1. bond.what is the value of a 1000 par value bond with annual payments of ana. 11 coupon with a maturity of 20 years

  Question regarding the project operating cash flow

Interest expense 4 million. The company faces a 35% tax rate. What is the project's operating cash flow for the first year (t = 1)? Write out your answer completely. For example, 2 million should be entered as 2,000,000.

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