Use the Excel spreadsheet located in this Week’s Books and Resources to convert the static budget presented in Column C to a Flexible Budget. Put the Flexible budget in Column E. In Column F, explain how you converted each line item. Remember the relationship of various costs to volumes.
Length: 1 completed static Excel budget on the template providedUsing the data in Column C, Static Budget Develop the Cost/Volume relationship which will be used to prepare a Flexible Budget in Column E, based on the new volumes reported in Column E. ABC Hospital Annual Budget FY 2018 Static Budget Patient Days 20,000.00 Revenue Per Day $7,000 Net Patient Revenue Expenses Salaries Fixed Variable Semi-Fixed $140,000,000 Adjust 2% or each 5% change in volume Total Salaries Benefits