Loading
Home › Finance Help › Financial Management Try Using EXCEL SHEET Two assignment...
Status: Completed
 View Work

Financial Management Try Using EXCEL SHEET Two assignments The first one is very short (The instructions to it is in the instruction section below) and I need it by TOMORROW The second one (is an attached document) and I need it by FRIDAY

Date Posted: 14/02/2018
Category: Finance
Due Date: 14/02/2018
Instruction
Halfpipe Hospital is negotiating a new contract with Rocky Mountain Health Plan. The hospital had 25,000 discharges last year and is on pace to provide the same volume of services this year; You have an average length of stay of 4.25 days per discharge; Your actual costs to provide care (what you spend for salary, medicines, supplies and other items) average 80% of charges;  RMHP represents 20% of your total discharges; There is an average charge of $20,000 per discharge, for which your current contract requires you to give a 15% discount off of charges. Calculate net revenue from RMHP for Halfpipe You have been offered a per diem of $5,000 or a per discharge of $19,000. Which is better? At the last minute you see that LOS has decreased to 3.75 days. Does your answer change?
Attached
Download File 1 (docx)
Download File 2 (docx)
Download File 3 (docx)
Download File 4 (pdf)
Tutor Uploads
Download File 1 (xlsx)
Bidders
ExcellentTutor 8 years, 7 months ago
Rated 9.09 earned 174531.76 around 5422 assignments.
I can complete this assignment for you and deliver high quality work free from plagiarism.....thank you
$25.00
  • Hello, am, one of the company's top writers and I am interested in working on your paper. I will ensure the delivery of a high quality paper within the given deadline. I have worked on similar papers in the past and I can assure you of an A grade paper.
    ExcellentTutor | Feb 14, 2018, 06:10 AM
  • $20 please
    User_13208 | Feb 14, 2018, 06:26 AM
  • ypu need it tomorrow or friday?
    ExcellentTutor | Feb 14, 2018, 06:27 AM
  • 25 is good. let me start working on it
    ExcellentTutor | Feb 14, 2018, 06:29 AM
  • Try to upload the attachment again. I am unable to open it
    ExcellentTutor | Feb 14, 2018, 06:31 AM
  • my friend
    ExcellentTutor | Feb 14, 2018, 06:47 AM
  • can you upload the attachment please
    ExcellentTutor | Feb 14, 2018, 06:47 AM
  • I need this by tomorrow Halfpipe Hospital is negotiating a new contract with Rocky Mountain Health Plan. The hospital had 25,000 discharges last year and is on pace to provide the same volume of services this year; You have an average length of stay of 4.25 days per discharge; Your actual costs to provide care (what you spend for salary, medicines, supplies and other items) average 80% of charges; RMHP represents 20% of your total discharges; There is an average charge of $20,000 per discharge, for which your current contract requires you to give a 15% discount off of charges. Calculate net revenue from RMHP for Halfpipe You have been offered a per diem of $5,000 or a per discharge of $19,000. Which is better? At the last minute you see that LOS has decreased to 3.75 days. Does your answer change?
    User_13208 | Feb 14, 2018, 07:05 AM
  • and the attachment file on Friday
    User_13208 | Feb 14, 2018, 07:05 AM
  • the attachment is not opening. upload it again
    ExcellentTutor | Feb 14, 2018, 07:15 AM
  • I re-uploaded it, take a look and let me know
    User_13208 | Feb 14, 2018, 07:22 AM
  • not yet. can you upload it as a PDF?
    ExcellentTutor | Feb 14, 2018, 07:23 AM
  • idk how i uploaded it again try now
    User_13208 | Feb 14, 2018, 07:30 AM
  • I think your computer has issues. it still cant open. try to restart your computer and upload it or copy in another word document and upload it
    ExcellentTutor | Feb 14, 2018, 07:32 AM
  • hello, are you still here?
    ExcellentTutor | Feb 14, 2018, 08:30 AM
  • hi are you able to see it or no?
    User_13208 | Feb 14, 2018, 20:38 PM
  • I will assign you now to do the first part and will figure way to upload that document again. The first part I need by today, the uploaded part is not due until friday
    User_13208 | Feb 14, 2018, 20:39 PM
  • but you took long to assign it to me
    ExcellentTutor | Feb 14, 2018, 20:45 PM
  • the attachment is still not opening
    ExcellentTutor | Feb 14, 2018, 20:46 PM
  • the assignment you cant see is not due until Friday. but the one in the description box is due today and its very short just use excel to answer the three questions.
    User_13208 | Feb 14, 2018, 20:48 PM
  • so can you still do it or no?
    User_13208 | Feb 14, 2018, 20:49 PM
  • okay, I will do it
    ExcellentTutor | Feb 14, 2018, 20:49 PM
  • Halfpipe Hospital is negotiating a new contract with Rocky Mountain Health Plan. The hospital had 25,000 discharges last year and is on pace to provide the same volume of services this year; You have an average length of stay of 4.25 days per discharge; Your actual costs to provide care (what you spend for salary, medicines, supplies and other items) average 80% of charges; RMHP represents 20% of your total discharges; There is an average charge of $20,000 per discharge, for which your current contract requires you to give a 15% discount off of charges. Calculate net revenue from RMHP for Halfpipe You have been offered a per diem of $5,000 or a per discharge of $19,000. Which is better? At the last minute you see that LOS has decreased to 3.75 days. Does your answer change?
    User_13208 | Feb 14, 2018, 20:52 PM
  • this is due today
    User_13208 | Feb 14, 2018, 20:52 PM
  • use excel please
    User_13208 | Feb 14, 2018, 20:53 PM
  • I uploaded the part that's due on Friday as a PDF file check it and see if it opens for you
    User_13208 | Feb 14, 2018, 20:56 PM
  • let me check
    ExcellentTutor | Feb 14, 2018, 20:58 PM
  • still not opening. I think you are uploading it wrongly
    ExcellentTutor | Feb 14, 2018, 21:05 PM
  • Let's have you do a little comparative analysis on payment mechanisms for this week's assignment. Assume that you are on the administrative team at High Peaks Medical Center. You are currently contracted with Money Care Health Plan, but that contract will end in 60 days and you will have to re-negotiate your payment terms. The current situation at your hospital is this: • The hospital had 32,500 discharges last year and is on pace to provide the same volume of services this year; • You have an average length of stay of 4.5 days per discharge; • Your actual costs to provide care (what you spend for salary, medicines, supplies and other items) average 70% of charges; • MoneyCare represents 25% of your total discharges; • There is an average charge of $27,500 per discharge, for which your current contract with MoneyCare requires you to give a 20% discount off of charges.
    User_13208 | Feb 14, 2018, 21:18 PM
  • So your task for this assignment is in multiple parts: 1. Calculate the net revenue for High Peaks Medical Center from its current volume and payment rate with MoneyCare. 2. Now assume that you are in negotiation with MoneyCare. They have told you that they will not renew the contract under current terms and if you press for a discount off of charges, they will not renew the contract at all. SO you cannot propose cost reimbursement or anything doing with charges - after all it is 25% of your business! They are insistent on a prospective payment of some sort. They have offered either a per diem payment of $4,000 per day or a per discharge rate of $21,500. Using the facts presented above and the proposal you have from MoneyCare, which option is preferable? Why? You must show your calculations to get credit for your answer!!
    User_13208 | Feb 14, 2018, 21:19 PM
  • 3. After reviewing your latest operational statistics, you see that your average length of stay has increased to 4.9 days. Given the proposal in part 2, does your preference of reimbursement mechanisms change? Why? Again, you must show your calculations to get credit for your answer!! 4. Finally, after discussion with the negotiator from MoneyCare, their final proposal is a per discharge rate of $19,000. What do you need to do to maintain profitability at that rate? HINT: there are two answers that I am looking for - one is easy, one will require you to be creative.
    User_13208 | Feb 14, 2018, 21:19 PM
  • okay my friend
    ExcellentTutor | Feb 14, 2018, 21:22 PM
  • if you haven't started on the assignment thats due today, you don't need to its canceled :) if you did its ok I will still take it
    User_13208 | Feb 14, 2018, 23:24 PM
  • I had just started. should i stop ?
    ExcellentTutor | Feb 14, 2018, 23:26 PM
  • okay let me stop and work on the other one
    ExcellentTutor | Feb 14, 2018, 23:27 PM
  • ????
    ExcellentTutor | Feb 14, 2018, 23:30 PM
  • yah idont need it anymore , just due the one thats due on friday
    User_13208 | Feb 14, 2018, 23:36 PM
  • thank you
    User_13208 | Feb 14, 2018, 23:37 PM
  • okay
    ExcellentTutor | Feb 14, 2018, 23:39 PM
  • Let's have you do a little comparative analysis on payment mechanisms for this week's assignment. Assume that you are on the administrative team at High Peaks Medical Center. You are currently contracted with Money Care Health Plan, but that contract will end in 60 days and you will have to re-negotiate your payment terms. The current situation at your hospital is this: • The hospital had 32,500 discharges last year and is on pace to provide the same volume of services this year; • You have an average length of stay of 4.5 days per discharge; • Your actual costs to provide care (what you spend for salary, medicines, supplies and other items) average 70% of charges; • MoneyCare represents 25% of your total discharges; • There is an average charge of $27,500 per discharge, for which your current contract with MoneyCare requires you to give a 20% discount off of charges.
    User_13208 | Feb 14, 2018, 23:39 PM
  • So your task for this assignment is in multiple parts: 1. Calculate the net revenue for High Peaks Medical Center from its current volume and payment rate with MoneyCare. 2. Now assume that you are in negotiation with MoneyCare. They have told you that they will not renew the contract under current terms and if you press for a discount off of charges, they will not renew the contract at all. SO you cannot propose cost reimbursement or anything doing with charges - after all it is 25% of your business! They are insistent on a prospective payment of some sort. They have offered either a per diem payment of $4,000 per day or a per discharge rate of $21,500. Using the facts presented above and the proposal you have from MoneyCare, which option is preferable? Why? You must show your calculations to get credit for your answer!!
    User_13208 | Feb 14, 2018, 23:40 PM
  • 3. After reviewing your latest operational statistics, you see that your average length of stay has increased to 4.9 days. Given the proposal in part 2, does your preference of reimbursement mechanisms change? Why? Again, you must show your calculations to get credit for your answer!! 4. Finally, after discussion with the negotiator from MoneyCare, their final proposal is a per discharge rate of $19,000. What do you need to do to maintain profitability at that rate? HINT: there are two answers that I am looking for - one is easy, one will require you to be creative.
    User_13208 | Feb 14, 2018, 23:40 PM
  • okay. I will do it
    ExcellentTutor | Feb 14, 2018, 23:41 PM
  • I have uploaded your assignment please check and release the payment. Regards
    ExcellentTutor | Feb 16, 2018, 11:03 AM
  • hello, I have a new assignments uploaded please take a look at it and let me know if you can do it.. Do you want to make a deal, I will assign you on all of the upcoming weekly assignment if you accept to bid $15 on all of them. They are all the same type, excel problems. Let me know what you think..
    User_13208 | Feb 21, 2018, 07:42 AM
  • okay, upload one i see then we will strike a deal
    ExcellentTutor | Feb 21, 2018, 12:06 PM
  • I uploaded one yesterday
    User_13208 | Feb 21, 2018, 23:55 PM
  • it's due on Friday, take a look and let me know
    User_13208 | Feb 21, 2018, 23:57 PM
  • Okay
    ExcellentTutor | Feb 22, 2018, 04:14 AM
  • Let me check now
    ExcellentTutor | Feb 22, 2018, 04:14 AM
  • I have not seen it. where is it my friend?
    ExcellentTutor | Feb 22, 2018, 04:28 AM
  • Check I have placed my bid
    ExcellentTutor | Feb 22, 2018, 04:33 AM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[0] $}

{$ showNewChatSuccessMsg[0] $}
Unable to send Message: {$ showChatProcessErrorMsg[0] $}
 
 
proffesoranncarrl 8 years, 7 months ago
Rated 9.76 earned 242948.42 around 9258 assignments.
hi, I will deliver quality work and within the deadline.
$20.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[1] $}

{$ showNewChatSuccessMsg[1] $}
Unable to send Message: {$ showChatProcessErrorMsg[1] $}
 
 
komatsu 8 years, 7 months ago
Rated 8.8 earned 25673.74 around 681 assignments.
Hello sunshinelight
$25.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[2] $}

{$ showNewChatSuccessMsg[2] $}
Unable to send Message: {$ showChatProcessErrorMsg[2] $}
 
 
onessmati14 8 years, 7 months ago
Rated 9.59 earned 37978.64 around 1232 assignments.
Hello dear. I am interested in working on your assignment. I guarantee you top quality work within the specified deadline. Zero plagiarism. Free Turnitin report. Free premium grammar check. Free in-text citations and free works cited/reference pages. Have confidence and let me give you the best for a long-term working relationship. Thank you!
$20.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[3] $}

{$ showNewChatSuccessMsg[3] $}
Unable to send Message: {$ showChatProcessErrorMsg[3] $}
 
 
PHDGENIOUSWRITER 8 years, 7 months ago
Rated 9.66 earned 11889.04 around 299 assignments.
Hello,I am a proficient writer with adept and proven knowledge in MS excel. I am committing to deliver top quality work delivered on time. I will pay close details to instructions provided as one step leads to the other. Kindly accept my bid right away so that I can have ample time to complete your work.
$55.00
  • I took time to read through the work and I clearly understood its requirements, I am confident delivering precisely to your instructions. Thank you much. Kindly assign ASAP. I will deliver a MASTERPIECE
    PHDGENIOUSWRITER | Feb 14, 2018, 08:16 AM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[4] $}

{$ showNewChatSuccessMsg[4] $}
Unable to send Message: {$ showChatProcessErrorMsg[4] $}
 
 
phoniextutor 8 years, 7 months ago
Rated 8.98 earned 50856.21 around 1767 assignments.
Hello my friend, would you kindly grant me the precious chance to assist you
$60.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[5] $}

{$ showNewChatSuccessMsg[5] $}
Unable to send Message: {$ showChatProcessErrorMsg[5] $}
 
 
Primetutor 8 years, 7 months ago
Rated 9.2 earned 5229.67 around 164 assignments.
Hello, assign me this Finance homework for a succinct and accurate solution. I am qualified in accounting and finance and therefore understands well what your assignment entails. I have dexterity in using finance tools in excel. Thanks and let's work together
$50.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[6] $}

{$ showNewChatSuccessMsg[6] $}
Unable to send Message: {$ showChatProcessErrorMsg[6] $}
 
 
Lekish 8 years, 7 months ago
Rated 9.49 earned 9616.16 around 197 assignments.
Hi Sunshinelight
$20.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[7] $}

{$ showNewChatSuccessMsg[7] $}
Unable to send Message: {$ showChatProcessErrorMsg[7] $}
 
 
professionalwriter_d_496 8 years, 7 months ago
Rated 8.85 earned 19649.48 around 531 assignments.
I will give you an A grade
$30.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[8] $}

{$ showNewChatSuccessMsg[8] $}
Unable to send Message: {$ showChatProcessErrorMsg[8] $}
 
 
Academicresearchpro 8 years, 7 months ago
Rated 9.35 earned 53126.33 around 1501 assignments.
Hello. I have keenly read through the requirements of this task and seen that I can handle it to the best of my knowledge and ability. Kindly assign this work to me and expect the best of my effort. Looking forward to working with you. Thank you.
$50.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[9] $}

{$ showNewChatSuccessMsg[9] $}
Unable to send Message: {$ showChatProcessErrorMsg[9] $}
 
 
Essaymasters 8 years, 7 months ago
Rated 8.94 earned 80799.14 around 2500 assignments.
I will do this assignment for you and I will give you an A grade paper.
$20.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[10] $}

{$ showNewChatSuccessMsg[10] $}
Unable to send Message: {$ showChatProcessErrorMsg[10] $}