Childrens Hospital of the Kings Daughters Health System in Norfolk, Virginia, introduced a new budgeting method that allowed the hospitals annual plan to be updated for changes in operating plans. For example, if the budget was based on 400 patient-days (number of patients number of days in the hospital) and the actual count rose to 450 patient-days, the variable costs of staffing, lab work, and medication costs could be adjusted to reflect this change. The budget manager stated, I work with hospital directors to turn data into meaningful information and effect change before the month ends. a. What budgeting methods are being used under the new approach? b. Why are these methods superior to the former approaches?

Please also show work in an excel spreadsheet.