Site icon Cliff Notes

UMBC Income Budget Transaction Activity Volumes & Charge per Patient Excel Worksheet

admin one

UMBC Income Budget Transaction Activity Volumes & Charge per Patient Excel Worksheet

Question Description

Using Excel to calculate the following exercise.

  • Call Information:
    • Charge Amounts (These are what you would send to the insurer)
      Call Type Commercial Medicare
      BLS Emergency 550.00 550.00
      BLS Non-Emergency 300.00 300.00
      ALS Emergency 800.00 800.00
    • Payment Amounts (This is the amount you would collect on each patient.)
    • Call Type Commercial Medicare
      BLS Emergency 475.50 340.69
      BLS Non-Emergency 275.00 212.93
      ALS Emergency 700.00 404.57
  • Based on the data above, build an income budget on what you will think you will make in the month of June.
  • You board wants to know:
    • The amount you charged all patients.
    • The contractual allowances for the month of June. (The amount your charged minus the amount you owe.)
    • The expected amount of revenue you will make.
  • They want to see the following data in an excel sheet, because your treasurer is an accountant and likes excel.
  • Your call volume for the month of June

    • Call Volume

    Commercial

    Medicare

    BLS Emergency

    Your birth month (January 1, February 2, etc.)

    65

    BLS Non-Emergency

    30

    Your day of birth (1, 2, ….31) etc.

    ALS Emergency

    Last 2 digits of your phone Number

    10

    Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."

    Exit mobile version