Task 1: Identify the following accounts in the report and subtract the cummulative values for the actual sales and the 2023 budget. Then copy the accounts from Tab. Met Nashville Gen. Task 2: Assumed that the following accounts are the only expenses. Task 3: Based on 2023 , 11 month expenses, please (annualise) calculate the cumulative at 12 month. Then, please standarize measures Task 4: Apply 5% cumulative inflation per year to the total general expenses. Taks 5: Once standarize, please create a Pie CHART based on this "budget" (do not forget to ID the accounts)

Metropolitan Nashville General Hospital (MNGH) Budget Comparison between actual sales 2023 & buget 2023 (see Report & Budget attached Ex.#2)

11 month

Task 3: 2023 (yr)

BUDGET 2023 (yr)

Budget Difference

equal to (Actual / Buget) - (1)

General

$

$

%

$

%

$

%

Utilities

Laboratory

Environmental Services

Pharmacy

Operating Rooms

Housekeeping

Laundry

TOTAL General Expenses

Task 4:

Apply 5% cumulative inflation per year to the total general expenses.

2023

Year 1

Year 2

Year 3

Year 4

Year 5

(Gen. Expenses)(1+ %)^n