Fill in Order Details

  • Submit paper details for free using our simple order form

Make Payment Securely

  • Add funds to your account. There are no upfront payments. The writer will only be paid once you have approved your paper

Writing Process

  • The best qualified expert writer is assigned to work on your order
  • Your paper is written to standard and delivered as per your instructions

Download your paper

  • Download the completed paper from your online account or your email
  • You can request a plagiarism and quality report along with your paper

Assignment for NURS 6211 Wk 10

Assignment: Expense Forecasting and Benchmarking

Looking Ahead: Application Assignment: Expense Forecasting and Financial Analysis Cycle

You will begin this assignment in Week 9 and it will be due by Day 7 of Week 10.

Throughout this course, you’ve examined the importance of anticipating financial fluctuations that may impact your organization’s ability to provide services. While financial managers have no time machines or crystal balls, they do have expense forecasts. Expense forecasting is one of the preeminent tools that financial managers can use to prepare their organizations for future fiscal turbulence. In this Assignment, you will examine a scenario and generate a corresponding expense forecast in Excel.

Before pursuing an opportunity or making a major purchase, financial decision makers must first ascertain if the expenditures are justified. Determining whether a new process, system, or purchase will yield worthwhile returns is no easy task. However, managers have a variety of tools to help them decide whether the new expenditure is warranted. Analyzing a venture’s benefit/cost ratio, marginal profit and loss statement, and break-even points enable nurse managers to make educated decisions about how they choose to commit their funds.

Note: For those Assignments in this course that require you to perform calculations you must:

  • Use the Excel spreadsheet template for the Week 3 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 the Week 9 and 10 Learning Resources dealing with expense forecasting, profit and loss, break-even analysis, and benefit and cost ratio analysis. Focus on how they are calculated and how they can be used in decision making.

·       View the following tutorial videos, provided in this week’s Learning Resources.

o   Week 10 Application Assignment Tutorial: Benefit Cost Ratio

o   Week 10 Application Assignment Tutorial: Breakeven Analysis

o   Week 10 Application Assignment Tutorial: Expense Forecasting

o   Week 10 Application Assignment Tutorial: Profit and Loss Scenario

Use the Week 10 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.

Expense Forecasting

In this Application Assignment you calculate scenarios focusing on benefit/cost ratio analysis, marginal profit and loss statements, and break-even analysis. For these scenarios, you will utilize the provided figures to perform calculations and then make recommendations about the viability of the investment opportunities 

Expense Forecasting Scenario

Your department has performed 20,000 procedures during the first six months (January–June) of 20X1. Spending during that period of time was $210,000 for fixed expense items and $1,200,000 for variable expense items. Of those amounts, $50,000 of fixed expense money was spent on preparing for a Joint Commission survey. Volume is anticipated to be 10% higher in the second half of the year. On November 1st, two new procedure technicians will begin work. The salary and fringe benefit costs for each are $96,000/year. Based on the information provided, prepare an expense forecast for 20X1.

Financial Analysis Cycle

Marginal Profit and Loss Statement Scenario

You are examining a proposal for a new business opportunity – a new procedure for which demand is expected to be 1,400 units the first year, growing by 600 units a year thereafter. The price charged per procedure is $1,000. The collection rate is anticipated to be 80%. Each procedure consumes $300 of supplies. Salary cost is estimated to cost $540,000 each year, fringe benefits are 25% of salaries, rent for the facility is $55,000/yr and operating cost are $120,000/yr.

Questions:

1.    Develop a marginal profit and loss statement for this business opportunity.

Based on that analysis, should this opportunity be pursued?

Break-Even Analysis Scenario

You can charge $1,075 for a new service. Demand is anticipated to be 8,000 units a year. Your business is able to handle up to 16,500 units annually, so capacity should not be a problem. The average collection rate is 80%. The new service has annual fixed costs of $4,700,000. Variable cost per unit of service is $420.

Question: Use break-even analysis to determine if this new service is financially viable. If the business is not financially viable, what steps could you take to make a case to proceed with implementation?  Explain your decision.

Benefit/Cost Ratio Analysis Scenario

You are considering the acquisition of a new piece of equipment with a useful life of five years. This new technology will make your clinical operation more efficient and allow for a reduction of 10 FTEs. The equipment purchase price is $4,500,000 plus 10% installation fee. The purchase price includes service for the first year, an item that has an annual cost of $10,000. There is a potential for additional volume of 150,000 units in the first year, growing by 30,000 each year thereafter. The price charged per unit is $15.00 with a 50% collection rate. The staff being eliminated are paid $12.50 per hour. The fringe benefits rate is 20%. The hurdle rate is 7.5%.

Questions: After reviewing Dr. Ward’s Video and the calculations below, please answer the following questions:

·       What is meant by  benefit/cost ratio, average payback period and ROI  and why are the all  important to understand when purchasing new equipment?

·       Based on this information, would you pursue this opportunity?

·       Explain your decision  in 250-500 words in the text box below.

Link to video: Laureate Education (Producer). (2012). Expense forecasting. Baltimore, MD: Author. 

Link

WHAT OUR CURRENT CUSTOMERS SAY

  • Google Rating
  • Sitejabber
  • Trustpilot
Cindy L
Cindy L
You can't fault the paper quality and speed of delivery. I have been using these guys for the past 3 years and I not even once have they ever failed me. They deliver properly researched papers way ahead of time. Each time I think I have had the best their professional writers surprise me with even better quality work. Elite Academic Research is a true Gem among essay writing companies.
Samuel Y
Samuel Y
I really appreciate the work all your amazing writers do to ensure that my papers are always delivered on time and always of the highest quality. I was at a crossroads last semester and I almost dropped out of school because of the many issues that were bombarding but I am glad a friend referred me to you guys. You came up big for me and continue to do so. I just wish I knew about your services earlier.
Mindi D
Mindi D
Brilliant writers and awesome support team. You can tell by the depth of research and the quality of work delivered that the writers care deeply about delivering that perfect grade.
Stuart L
Stuart L
Thanks for keeping me sane for getting everything out of the way, I’ve been stuck working more than full time and balancing the rest but I’m glad you’ve been ensuring my school work is taken care of. I'll recommend Elite Academic Research to anyone who seeks quality academic help, thank you so much!
Zahraa S
Zahraa S
Absolutely spot on. I have had the best experience with Elite Academic Research and all my work have scored highly. Thank you for your professionalism and using expert writers with vast and outstanding knowledge in their fields. I highly recommend any day and time.

ORDER NOW

Consider Your Assignments Done

“All my friends and I are getting help from eliteacademicresearch. It’s every college student’s best kept secret!”

Jermaine Byrant
BSN

“I was apprehensive at first. But I must say it was a great experience and well worth the price. I got an A!”

Nicole Johnson
Finance & Economics

Our Top Experts

————-

See Why Our Clients Hire Us Again And Again!


OVER
10.3k
Reviews

RATING
4.89/5
Avg Rating

YEARS
12
Experience

Elite Academic Research Promises You:


Always on Time

If we are a minute late, the work is on us – it’s free!

Plagiarism-free

If the work we produce contains plagiarism we’ll pay out a £5,000 guarantee.

Quality

Providing quality work is core to our beliefs, which is why we will strive to give you exactly that, and more!

Written to Standard

All of our assignments go through a stringent quality checking process from start to finish.

Success Guarantee

When you order form the best, some of your greatest problems as a student are solved!

Reliable

Professional

Affordable

Quick

YOUR EDUCATION ON AUTOPILOT

Pay an expert to take your online class and say goodbye to poor grades, missed deadlines, and the struggles
of balancing your education with other work/life responsibilities. Life Is too Short to Spend on Classes
You Have No Interest In. Focus on what is really important in your life. Let our professional handle your class.

    Guaranteed A or B

    100% Confidential

    Experienced Tutors

    24/7 Support

Fill in free quote request

Tell us about your online class and what help you need. Try to give us the maximum information.

Agree on price

Our representative will contact you to discuss the details of your order and the rates for our assistance.

Pay and get help

When everything is agreed, you will receive an email with the invoice. After you pay, we start working on your task.