In this case scenario, you are the nurse administrator for an outpatient podiatry clinic. You have been informed by the CNO that the clinic needs to increase revenue by 10% for the next fiscal year or they will need to cut expenses by laying-off personnel.
Utilize the linked excel file of the revenue budget, make the appropriate changes in excel to project a 10% revenue increase for next year.
Excel File
You can project an increase or decrease in any line item except ‘Gift Shop” and “Donations”. You are to assume that there will be no donations next year and gift shop donations will be reduced to $5500 due to a planned renovation of the shop that will require closure for 2 months.
Please begin the conversation by posting an analysis of your proposed budget and rationale for the changes you plan to make.
By the end of the discussion period, post your final response, and upload your Excel spread sheet as an attachment to your discussion post for review and comments from your instructor. Students have the option to review and comment on each other’s submissions.
Posts may include your experiences, opinions, view points, and ideas supported by evidence (references) as appropriate.
(A) (B) (C=AxB) D E=(CxD)
Revenue Source Quantity Rate or Charge Gross Revenue Average Net Charge Revenue Net of Discounts and Allowances
Same Day Surgery
Private Insurance 1,000 1,500 1,500,000 75% 1,125,000
Medicare 600 1,500 900,000 80% 720,000
Medicaid 400 1,500 600,000 60% 360,000
Self-Pay 500 1,500 750,000 70% 525,000
Clinic Patients
PLACE THIS ORDER OR A SIMILAR ORDER WITH NURSING TERM PAPERS TODAY AND GET AN AMAZING DISCOUNT
