000 a 2 Please complete the budgeting analysis by filling out the chart below- you must use excel for credit 3 Fringe benefits are 36.5% of Salaries 4 Equipment is budgeted at 1.5% less than supplies but came in at 3.2% less than budgeted 5 What is your observation of each line item? 6 Adopted vs Actual Budget (Fiscal Year Ended 12/31/2022) 7 LIU HEALTHCARE WALK-IN CLINIC 8 EXPENDITURES BY TYPE Percent Percent of End of Year Adopted Budget in Change Total Actual/Spent beginning of Year Net Change Budgeted vs. Expenditures December 2022) (January 2022) (Variance) Actual SPENT Analysis/Observation 10 Personnel Expenditures 11 Salaries $1,700,500 $1,655,250 12 Fringe Benefits 13 Total Personnel Expenditures 14 Operating Expenditures 15 Supplies $ 425,000 $ 450,000 16 Equipment Subtotal Operating Red End of Year Actual/Spent (December 2022) Adopted Budget in beginning of Year (January 2022) Net Change (Variance) Percent Percent of Change Total Budgeted vs. Expenditures Actual SPENT 9 Analysis/Observation 10 Personnel Expenditures 11 Salaries 12 Fringe Benefits $1,700,500 $1,655,250 $ 425,000 $ 450,000 13 Total Personnel Expenditures 14 Operating Expenditures 15 Supplies 16 Equipment Subtotal Operating 17 Expenditures 18 Total Expenditures 19 20 21 22 000 a 2 Please complete the budgeting analysis by filling out the chart below- you must use excel for credit 3 Fringe benefits are 36.5% of Salaries 4 Equipment is budgeted at 1.5% less than supplies but came in at 3.2% less than budgeted 5 What is your observation of each line item? 6 Adopted vs Actual Budget (Fiscal Year Ended 12/31/2022) 7 LIU HEALTHCARE WALK-IN CLINIC 8 EXPENDITURES BY TYPE Percent Percent of End of Year Adopted Budget in Change Total Actual/Spent beginning of Year Net Change Budgeted vs. Expenditures December 2022) (January 2022) (Variance) Actual SPENT Analysis/Observation 10 Personnel Expenditures 11 Salaries $1,700,500 $1,655,250 12 Fringe Benefits 13 Total Personnel Expenditures 14 Operating Expenditures 15 Supplies $ 425,000 $ 450,000 16 Equipment Subtotal Operating Red End of Year Actual/Spent (December 2022) Adopted Budget in beginning of Year (January 2022) Net Change (Variance) Percent Percent of Change Total Budgeted vs. Expenditures Actual SPENT 9 Analysis/Observation 10 Personnel Expenditures 11 Salaries 12 Fringe Benefits $1,700,500 $1,655,250 $ 425,000 $ 450,000 13 Total Personnel Expenditures 14 Operating Expenditures 15 Supplies 16 Equipment Subtotal Operating 17 Expenditures 18 Total Expenditures 19 20 21 22