Reference no: EM1366927
Create a spreadsheet to address the following problem:
A. A hospital has an average accounts receivable balance of $20,000,000 and a collection period of 60 days.
B. 60 percent of receivables are not collected on time. The bills for those receivables must be reworked by the patient billing department and resubmitted to insurance companies for payment. Assume that the insurance companies did not pay the first submission because of data errors in the bills. The reworked bills adversely impact the average accounts receivable collection period.
C. The receivables that are not reworked (40% of the total) are all processed consistently without problems.
D. Fairview Health sells a system that will gradually reduce the number of data errors in the billing process. Assume that the system will have no impact in year 1 (during the implementation period), and that data errors are projected to be reduced by 25%, 50%, 70%, and 90% in years 2 through 5 respectively. The system will cost the hospital $2,000,000 in year 1 and $300,000 per year in years 2 through 5.
E. How would you project the financial benefits that the system could deliver to the hospital over 5 years and the return on investment for the system? If you need some additional information, identify what you need and then assume a value so that you can arrive at answers.
|
Influencing the future of public health
: How do you think this will affecting the future of public health? What advantages and challenges might develop?
|
|
Explain client-server architecture for serving client on pc
: When people explain client-server architecture, they are usually referring to a system in which a large server is serving a client on a PC. With X Window, reverse is frequently the case. Explain
|
|
Healthcare and the field of pharmacy
: Why is privacy such an significant issue in healthcare and the field of pharmacy? How does HIPAA protect a patient's privacy?
|
|
Determining demand for housing
: The demand for housing is often described as being highly cyclical and very sensitive to housing prices and interest rates. Given these characteristics describe the effect of each of the following terms of whether it would increase or decrease the..
|
|
Analysis of return on investment
: 60 percent of receivables are not collected on time. The bills for those receivables must be reworked by the patient billing department and resubmitted to insurance companies for pay.
|
|
Show the information about proposal writing
: Define a problem within your current work situation that requires action and the research to resolve and if you do not have a current position select something from an old employer or something you see in your community.
|
|
Idetifying financial markets
: Identify and describe the different financial markets, their functions, primary instruments, and the investor types. But, my initial answer to this question would have not been initially focused on the primary and secondary markets.
|
|
Write program that compute the amount person earn
: Write a program which computes the amount a person would earn over period of time if his or her salary is one penny the first day, two pennies second day.
|
|
Estimating equilibrium price and quantity
: What would be the equilibrium quantity and equilibrium price? Assume the Government imposes a $5 per unit tax on the seller, which equation would be affected and how?
|