Hello, Please help me with this Assignment. Your help is greatly appreciated
Hello, Please help me with this Assignment. Your help is greatly appreciated. Thank you.
Healthcare Financial Management and EconomicsWeek 8 Assignment 2 — Pacific Imaging CenterAssignment 2: Break-Even Point FormulasBefore making hiring or purchasing decisions, healthcare organizations must considerwhether the decision is financially profitable. By calculating break-even points,organizations are able to examine actual costs and make more sound financialdecisions. For this Assignment, you use data from the Pacific Imaging Center andcalculate break-even points.Scenario:Pacific Imaging Center is a small imaging center with two analogue film orscreen units. As the director of the center, Juanita Hernandez has been asked todetermine if it is financially profitable to hire additional technologists to their current staffof two technologists. She has analyzed the current costs and determined the following:Reimbursement per screen$75Equipment costs per month ($800 per machine)$1,600Technologists costs per mammography$20Technologists aide per mammography$4Variable cost per mammography$10Equipment maintenance per month per machine$700To prepare for the Assignment:Examine the Pacific Imaging Center scenario. Reflect on how you will use the providedfinancial data to calculate break-even points. Refer to Chapter 9 ofFinancialManagement of Health Care Organizations: An Introduction to Fundamental Tools,Concepts and Applicationsfor additional guidance.The Assignment:Given the above information, create an Excel spreadsheet showing the following:A. Solve for monthlyvolumeto break even.B. Solve for monthlyvolumeneeded to break even at desired $5,000 per monthprofit level.C. Solve forvolumeneeded to break even at new reimbursement of $55 per screenand no profit.D. Solve forvolumeneeded to break even with additional labor.Your Assignment is due byDay 7 of Week 8.© 2015 Laureate Education, Inc.Page 1 of 1
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
