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.
Review the information in 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.
Week 10 Application Assignment Tutorial: Benefit-Cost Ratio
Week 10 Application Assignment Tutorial: Breakeven Analysis
Week 10 Application Assignment Tutorial: Expense Forecasting
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.