The first two photos are of one page while the 3rd photo is the answer sheet.

Formatting as Table Styles Format 34 Finer iven the assumptions listed below, calculate the following: 3. G A. Actual Net Revenue 3 POINTS B. Budgeted Net Revenue C. Actual Total Expenses Budgeted Total Expenses D. E. Actual Net Income F. Budgeted Net Income Static Variance for each line item State whether each line is favorable or unfavorable G. H. Assumptions: 17 1. Actual number of procedures performed are 1,500. 2. Budgeted number of procedures were 1,250. 3. Revenue per procedure is $450 20 21 Actual Expenses for the period were: 23 175,000 a. Salaries and Benefits 42,000 3,000 b. Supplies 25 c. Insurance -General 26 6,000 d. Malpractice e. Depreciation - Building f. Depreciation-Equipment 40,000 120,000 386,000 29 Budgeted expenses for the period were 155,000 a. Salaries and Benefits 28,500 b. Supplies 35 c. Insurance- General 5,000 37 - . +100% FinalEx014 -- $v%, Merge & Center v // Conditional Format Cell Formatting as Table Styles Sort & deas Format d. Malpractice 5,000 e. Depreciation- Building f. Depreciation- Equipment 40,000 120,000 350,500 FinalEx014 +100 ACTUAL STATIC STATIC AMOUNTS BUDGET BUDGET INCURRED TOTALS VARIANCE F/u Number of Procedures Net Revenue Expenses Salaries & Benefits Supplies Insurance General Malpractice Depreciation- Building Depreciation Equipment Total Expenses Operating Income