Application Assignment Net Revenue And Budgeting

Application Assignment Net Revenue And Budgeting

 

Application Assignment Net Revenue And Budgeting

Assignment: Looking Ahead: Application Assignment Net Revenue and Budgeting
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.
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.
 Be sure and include all of your calculations
Required Readings  Baker, J. J., Baker, R. W., & Dworkin, N. R.  (2018). Health care finance: Basic  tools for nonfinancial managers (5th ed.). Burlington, MA: Jones and  Bartlett Learning.  •Chapter 7, “Cost Classifications” (pp. 55-61)    In this chapter, you focus on the difference between direct and indirect costs and why it is crucial for financial managers to understand the difference.     •Chapter 8, “Cost Behavior and Break-Even Analysis” (pp. 65-78)    This chapter continues the discussion on costs. It describes the differences between fixed, variable, and semivariable costs. It demonstrates how to compute the cost-volume-profit (CVP) ratio and the profit-volume (PV) ratio.  Zelman, W., McCue, M., & Glick, N. (2009). Financial management of health care organizations: An introduction to fundamental tools, concepts, and applications (3rd ed.). Hoboken, NJ: Jossey-Bass.  Retrieved from the Walden Library databases.  •Chapter 3, “Principles and Practices of Health Care Accounting” (pp. 87–120)    Review: This chapter explores the accounting practices and principles of health care. The authors detail the rules for recording transactions and the process of recording and developing financial statements.     •Chapter 4, “Financial Statement Analysis” (pp. 121–186)
  • attachment

    Week_5_Application_Assignment_Template.xlsx

    ADDITIONAL INSTRUCTIONS FOR THE CLASS

    Who We Are 

    We are a professional custom writing website. If you have searched for a question and bumped into our website just know you are in the right place to get help with your coursework.

    Do you handle any type of coursework?

    Yes. We have posted our previous orders to display our experience. Since we have done this question before, we can also do it for you. To make sure we do it perfectly, please fill out our Order Form. Filling the order form correctly will assist our team in referencing, specifications, and future communication.

    Is it hard to Place an Order?

    • 1. Click on “Order Now” on the main Menu and a new page will appear with an order form to be filled.
    • 2. Fill in your paper’s requirements in the “PAPER INFORMATION” section and the system will calculate your order price/cost.
    • 3. Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
    • 4. Click “FINAL STEP” 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.
    • 5. 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.

    SCORE A+ WITH HELP FROM OUR PROFESSIONAL WRITERS: ORDER NOW FOR AN ORIGINAL PAPER ASSIGNMENT

    We will process your orders through multiple stages and checks to ensure that what we are delivering to you, in the end, is something that is precise as you envisioned it. All of our essay writing service products are 100% original, ensuring that there is no plagiarism in them. The sources are well-researched and cited so it is interesting. Our goal is to help as many students as possible with their assignments, i.e. our prices are affordable and services premium.

    • Discussion Questions (DQ)

    Initial responses to the DQ should address all components of the questions asked, including a minimum of one scholarly source, and be at least 250 words. Successful responses are substantive (i.e., add something new to the discussion, engage others in the discussion, well-developed idea) and include at least one scholarly source. One or two-sentence responses, simple statements of agreement or “good post,” and responses that are off-topic will not count as substantive. Substantive responses should be at least 150 words. I encourage you to incorporate the readings from the week (as applicable) into your responses.

    • Weekly Participation

    Your initial responses to the mandatory DQ do not count toward participation and are graded separately. In addition to the DQ responses, you must post at least one reply to peers (or me) on three separate days, for a total of three replies. Participation posts do not require a scholarly source/citation (unless you cite someone else’s work). Part of your weekly participation includes viewing the weekly announcement and attesting to watching it in the comments. These announcements are made to ensure you understand everything that is due during the week.

    • APA Format and Writing Quality

    Familiarize yourself with the APA format and practice using it correctly. It is used for most writing assignments for your degree. Visit the Writing Center in the Student Success Center, under the Resources tab in Loud-cloud for APA paper templates, citation examples, tips, etc. Points will be deducted for poor use of APA format or absence of APA format (if required). Cite all sources of information! When in doubt, cite the source. Paraphrasing also requires a citation. I highly recommend using the APA Publication Manual, 6th edition.

    • Use of Direct Quotes

    I discourage over-utilization of direct quotes in DQs and assignments at the Master’s level and deduct points accordingly. As Masters’ level students, it is important that you be able to critically analyze and interpret information from journal articles and other resources. Simply restating someone else’s words does not demonstrate an understanding of the content or critical analysis of the content. It is best to paraphrase content and cite your source.

    • LopesWrite Policy

    For assignments that need to be submitted to Lopes Write, please be sure you have received your report and Similarity Index (SI) percentage BEFORE you do a “final submit” to me. Once you have received your report, please review it. This report will show you grammatical, punctuation, and spelling errors that can easily be fixed. Take the extra few minutes to review instead of getting counted off for these mistakes. Review your similarities. Did you forget to cite something? Did you not paraphrase well enough? Is your paper made up of someone else’s thoughts more than your own? Visit the Writing Center in the Student Success Center, under the Resources tab in Loud-cloud for tips on improving your paper and SI score.

    • Late Policy

    The university’s policy on late assignments is a 10% penalty PER DAY LATE. This also applies to late DQ replies. Please communicate with me if you anticipate having to submit an assignment late. I am happy to be flexible, with advance notice. We may be able to work out an extension based on extenuating circumstances. If you do not communicate with me before submitting an assignment late, the GCU late policy will be in effect. I do not accept assignments that are two or more weeks late unless we have worked out an extension. As per policy, no assignments are accepted after the last day of class. Any assignment submitted after midnight on the last day of class will not be accepted for grading.

    • Communication

    Communication is so very important. There are multiple ways to communicate with me: Questions to Instructor Forum: This is a great place to ask course content or assignment questions. If you have a question, there is a good chance one of your peers does as well. This is a public forum for the class. Individual Forum: This is a private forum to ask me questions or send me messages. This will be checked at least once every 24 hours.

    • Guarantee

    • Zero Plagiarism
    • On-time delivery
    • A-Grade Papers
    • Free Revision
    • 24/7 Support
    • 100% Confidentiality
    • Professional Writers

    • Services Offered

    • Custom paper writing
    • Question and answers
    • Essay paper writing
    • Editing and proofreading
    • Plagiarism removal services
    • Multiple answer questions

    SCORE A+ WITH HELP FROM OUR PROFESSIONAL WRITERS: ORDER NOW FOR AN ORIGINAL PAPER ASSIGNMENT

    We will process your orders through multiple stages and checks to ensure that what we are delivering to you, in the end, is something that is precise as you envisioned it. All of our essay writing service products are 100% original, ensuring that there is no plagiarism in them. The sources are well-researched and cited so it is interesting. Our goal is to help as many students as possible with their assignments, i.e. our prices are affordable and services premium.

    Looking for a Similar Assignment? Order a custom-written, plagiarism-free paper

Comments are closed.