Instructions: Your hospital is considering the purchase of a CT scanner. You, as the administrator for the Imaging Department, have been asked to conduct a financial analysis on the proposed purchase. Given the information and assumptions below, use Microsoft Excel to conduct a net present value analysis of a capital equipment request. When complete, think of some areas of the analysis where you might be able to make changes to improve the performance of the project. What are your thoughts on how you can positively influence this project? The information below is provided for your use in conducting the analysis on the CT Scanner. All prices and expenses are current as of year 0. Any planned growth will occur in year 1. CT Scanner Initial Purchase price Delivery, installation, and training Annual maintenance contract Estimated annual volume Supply cost per scan¹ Technician salary and benefits² Average charge per scan³ Discount rate 4 1,750,000 175,000 25,000 2,000 130 84,000 325 - 8.00%…

1) A community pharmacy manager is evaluating their budget for the coming fiscal year. They decide to subscribe to a new Electronic Medical Record (EMR) service in order to be able to document and share e-Care plans with other providers. This will optimize the medication therapy management service at their pharmacy. In turn, the pharmacy will be reducing expenditures on vaccines by only ordering multi-dose vials in order to dedicate more funding to the new EMR. What purpose of budgeting systems is being fulfilled by making this decision? a) Allocating resources b) Controlling profit and operations c) Facilitating communication and coordination d) Evaluating performance and providing incentives   2) Which prospective budget is the most critical in ensuring the accuracy of the entire master budget? a) Inventory budget b) Sales revenue budget c) Cash budget d) Operational budget

County Community Clinic is made up of 5 departments: 3 Service Line (revenue generating) departments - Adult Health, Child Health and Mental Health. They also have 2 support departments - Administration and Finance. The Direct Costs for the 5 Departments are: Administration Finance Adult Health Child Health Mental Health Finance Adult Health Child Health Here is some other data on the County Community Clinic Departments Department FTE Visits Administration 3 2 $400,000 $100,000 10 8 Behavioral Health 2 $1,000,000 $400,000 $100,000 10,000 4,000 1,000 Revenue $3,000,000 $1,000,000 $200,000

Weekly cycle billing is recommended A. For a practice with a sizeable patient load B. To even out phone calls C. For a consistent cash flow D. All of the above

Determine if the selection of system 1 or 2 is sensitive to variation in the return required by management. The corporate MARR ranges from 8% to16% per year on different projects. Use tabulated factors or a spreadsheet, as requested by your instructor.

Long lines of patients wait for CAT scanning service in a hospital. Patients arrive for scans at a rate of 1.9 per hour. The average processing time for CAT service is 27 minutes per patient. Your summer internship is in the hospital where you are assigned to help analyze the bottleneck situation. One tool that you think can help evaluate the situation is a single server queueing model. Use the Single Server Queue Excel template to answer the following questions. Do not round intermediate calculations. Round your answers to three decimal places.   What is the probability that the system is empty?   What is the probability that a customer must wait for service?   What is the average number of customers waiting for service in the queue?  customer(s) What is the average wait time in the queue?  hour(s) What is the average time spent in the system?  hour(s)

a. Determine the activity cost per patient for the coronary bypass treatment. Activity cost per patient $ b. Assume the hospital was able to make improvements such that the average length of stay in the hospital for the bypass was reduced from 6 days to 5 days. Further assume that additional improvements in medical technology reduced the operating room time for a bypass to 2½ hours. Determine the activity cost per patient for the coronary bypass treatment under these revised conditions. What is the cost improvement? The cost of treating a patient for a coronary bypass declined from $ to $, or $.

Keating Hospital is considering two different low-field MRI systems: the Clearlook System and the Goodview System. The projected annual revenues, annual costs, capital outlays, and project life for each system (in after-tax cash flows) are as follows: Assume that the cost of capital for the company is 8 percent. Required: 1. Calculate the NPV for the Clearlook System. 2. Calculate the NPV for the Goodview System. Which MRI system would be chosen? 3. What if Keating Hospital wants to know why IRR is not being used for the investment analysis? Calculate the IRR for each project and explain why it is not suitable for choosing among mutually exclusive investments.

Think about how Jamie Lee Jackson’s scenario of goal setting, which is the Continuing Case located in Connect, applies to your daily life. Write a 150-200-word summary discussing the following items. Note: You can go over the word count if so desired. For this assignment, create and submit the following two items: Three S.M.A.R.T. financial goals, (one each) for short, intermediate, and long-term goal financial goals. Make sure that your goals meet the S.M.A.R.T. guidelines. Using your intermediate or long-term goal and the time value of money (TVM) equation, calculate how your money will grow based on two different time horizons or interest rates. Respond to the following questions after completing the two items above: How does the length of time affect the growth of the account? What steps do you need to take to determine how much to set aside today for a goal in the future to meet your own personal financial goals? How does inflation affect the growth of money over time?