No one can predict the future, but accountants and financial managers must try and do exactly that!  By examining net revenue, costs, and cash flow, you can get a clearer picture of what to expect in your organization’s (or one with which you are familiar) fiscal future. Using these metrics to look forward will enable you to more effectively plan budgets that accomplish organizational goals.

When developing a budget, what variables do you have to take into account? In health care organizations, two of the largest groups of factors that you must consider are first, volume, and second, staffing and supply. The number of patients and tests performed each day, as well as employees and their pay rates are all crucial pieces of information when determining a budget.

In this Assignment, you address five scenarios: net revenue, fixed and variable costs, cash flow, volume budget, and staffing and supplies budget.

Note: For those Assignments in this course that require you to perform calculations you must:
Use the Excel spreadsheet template for the Week 5 assignment.
Show all your calculations and formulas in the spreadsheet.
Answer any questions included with the problems (as text in the Excel spreadsheet).

A title and reference page are NOT needed in this assignment.  Put your name and assignment at the top of the Excel spreadsheet.

For those not comfortable with the use of Microsoft Excel, this week’s Optional Resources suggest several tutorials.

To prepare:

  • Review the information in this week’s Learning Resources regarding net revenue, fixed and variable costs, and cash flow, and how they are used in financial decision making.
  • Review the budgeting information in Week 5 Learning Resources dealing with volume, staffing, and supplies budget.
  • Use the Week 5 Application Assignment Template, provided in this week’s Learning Resources, to complete this assignment. Carefully examine the information in each of the scenarios and provide the necessary calculations. Using this information will help you answer the questions.

Note: All the scenarios will be submitted as one document.  Each scenario will be on a different tab in the spreadsheet.

Scenario 1: Net Revenue Scenario

Your clinic provides four kinds of services:

  • Comprehensive initial medical consultation is priced at $250
  • Established patient limited visit is priced at $75
  • Established patient intermediate visit is priced at $125
  • Established patient comprehensive visit is priced at $250

Question: The profile of your patients is such that the average collection rate is 75%. Assuming you have 100 visits of each type each month, what amount of new revenue will you generate in the next 12 months?

Scenario 2: Fixed/Variable Cost Scenario

You have performed a cost analysis of your health care organization and have determined the following: based on the latest three years of information, your annual cost of operations is $1,600,000 with annual volume of 10,000 procedures. You have determined that certain of your supply items are fixed in nature (those marked with an F) while others are variable (marked with a V).

Question: An insurance company that is considering directing its 1,000 units per year of procedure business to your organization has approached you. For the last three years, you have been charging a price of $165 per procedure (with a 100% collection rate). Your board has mandated that you make $5 of profit from each of the procedures. You obviously want the highest possible price, but as you enter the negotiations, what is the lowest possible price you would be willing to accept from this payer?

Hint: Calculate the variable cost.

Scenario 3: Cash Flow Scenario

Your new business venture will begin operation on July 1, 20X2. You will hire staff effective January 1, 20X2 with a cost of $40,000 per month. You know from experience that collections lag billing by 3 months (in other words, once you bill for a service, you must wait 90 days for the payment to be received.) Your business volume is projected to be as follows:

Question: If you have $380,000 of cash on hand on January 1, 20X2, how much cash will you have at the end of June 20X3?  Assume a 100% collection rate.

Scenario 4: Volume Budget Scenario

You manage lab services in a large hospital. You have the following data on both the hospital’s budgeted patient days and visits for budget year 20XX along with the ratio of lab tests to patient days or visits.

Question: Based on this raw data provided , how many lab tests would you anticipate for the coming budget year? If each test is priced at $20.00, how much gross revenue would you budget? Assuming each full-time lab technician (FTE) can perform 200,000 tests each year, how many full-time lab technicians would you plan for?

Example on Template: 2 North Bldg calculated.  You will need to complete 2 South Bldg, ICU and OPD

Scenario 5: Staffing and Supply Budget Scenario

Calculate the supplies budget necessary to operate your unit for the fiscal year beginning January 1, 20X8. It is your expectation that you will perform 24,820 procedures in the budget year. The following spending data is available for the period January 1 to March 31, 20X7 during which time procedure volume amounted to 3,240. Items marked (F) are considered fixed, those marked (V) are considered variable. Inflation is planned at 4%.

In reviewing performance to date, you note that in January, you purchased $150,000 of D5W fluid replacement charged to IV solutions, which represents an entire year’s supply. In addition, you returned $2,800 of office supplies for credit from the vendor in Febuary. These supplies were purchased in a previous fiscal year.

You also need to prepare the salary budget for the same fiscal year. You have determined that staff needs are for 6.5 FTEs.

A pay raise will be given to all staff on October 1st of each year at a rate of 8 percent. In making your calculations, always round to the nearest whole dollar for annual salary amounts, but keep pennies in the hourly pay rates. New staff begins the new fiscal year at $16.00 per hour.

  • attachment

    week5excelsheet.xlsx

Click HERE to order a unique plagiarism free paper done by 

professional writers and delivered before your deadline

In the dynamic world we currently live in, it’s becoming increasingly difficult for students to balance academics, co-curricular activities and entertainment among others. Students are required to submit countless assignments in a short time frame. These assignments should not be taken lightly as they form a major part of the grade when it comes to the end of the semester. Understanding the value of education and how these grades are important to students, Infinite Essays has made it its mission in life to offer customized essays to students at an affordable cost.

Click HERE to order a unique plagiarism free paper done by 

professional writers and delivered before your deadline

There are plenty of reasons why you should order a paper with Infinite Essays. We have reliable writers who are also very competent. They have over the years managed to work under tight schedules and deadlines. Whenever you order an essay with Infinite Essays, you are guaranteed a fast turnaround of your project and this is done on time. Other than writing custom papers, our writers provide value added services that include academic assistance in the areas that they have specialized in. We ensure that the work that we offer is free of plagiarism. Infinite Essays does not condone plagiarism in whatsoever manner. Our writers are very experienced and can handle of sorts of formats such as Turabian, Chicago, Harvard as well as APA and MLA. Infinite Essays covers a wide range of topics. At the moment, we specialize with over 68 topics. We understand the importance of maintaining confidentiality when dealing with our clients. It’s for this reason that we will never reveal the identity of our clients to whoever may be interested. Finally, we offer the most competitive rates in the industry.

Click HERE to order a unique plagiarism free paper done by 

professional writers and delivered before your deadline

Whenever you want to make an order with us, you will use our automated online ordering system. If you are having some difficulties of any sort, feel free to contact our live support and they will be more than happy to assist you. Ensure that you fill all the relevant information regarding your order. This is the area where you have to include the deadline of your assignment, the formatting style to be used and even the kind of academic paper you desire. The more information you give to our writers, the better.

Click HERE to order a unique plagiarism free paper done by 

professional writers and delivered before your deadline

Brief explanations of how our services work 1. Provide us with the necessary instructions. Go to the Order Now page and click the order now button. This is the part where you have to attach all the relevant attachments. At the same time, remember to add the instructions sheet here. Once you are sure that you have submitted all relevant information, please submit the final draft to us. 2. The second step will involve paying for the services. This is where an invoice will be sent to you. However, the easiest process is clicking the payment link and following all the prompts that come along. At the moment, all payments are made through PayPal only. 3. Working on your paper. Once you have made the payment, we will assign the order to a writer who will follow the instructions. Remember that our writers will spend countless hour laboring to ensure that the work they provide is meticulously researched. 4. Download your paper. When the writer is finished with the assignment, they will submit it to our writers who will then go through the paper to ensure that the paper has followed all instructions and there are no grammatical errors. We will then forward a copy of the assignment to your email. 5. Tell your friends. We always happy to receive a referral. Whenever a friend tells us that you recommended our services to them, we will give you a 40 percent discount for your next order. Whenever you have provided us with the necessary details, we will forward them to qualified writers who will handle the assignment for you. Remember that the writers will begin working on the assignment immediately. This is the sole reason we encourage our clients to provide their exact specifications during the first time.

Click HERE to order a unique plagiarism free paper done by 

professional writers and delivered before your deadline

Tackling an order may be challenging but we always offer the best. Before the assignment can be passed to you by our writers, it will be passed through a team of qualified editors and proofreaders to ensure that the paper is accurate and of the required quality. Once the editors are satisfied with the assignment, they will forward the assignment to your account and a copy to your email.

Click HERE to order a unique plagiarism free paper done by 

professional writers and delivered before your deadline

Discounts We offer the best prices in the industry. We currently have a 20 percent discount for all of our customers. If you feel the budget is putting a strain on you, contact our live support and they might consider you case. We treat each case differently. Remember that our main goal is to continue with education transformation. At the moment, we only accept payments in form of PayPal.

Click HERE to order a unique plagiarism free paper done by 

professional writers and delivered before your deadline

Why Choose Us While there are many companies in the writing service industry claiming to offer platinum services, none can match the services offered by Infinite Essays. Some of our writers have been with us since 2010. The testimonials that have been written by some of our happy customers is an indication of the good services that we offer.

Click HERE to order a unique plagiarism free paper done by 

professional writers and delivered before your deadline