budgete Analytical Assignment 3: The administrator of Pearland Nursing Home is very aware of needing to keep his cost down since he just negotiated a new arrangement with a large insurance company that will pay him a fixed amount per patient day. Listed below are budgeted and actual expenses for the previous month. Actual patient days were 30,000 compared to budgeted patient days of 24,000. Pearland Nursing Home Budgeted and Actual Expenses Budgeted Costs @ Budgeted Cost Per Actual Costs @ 24,000 Patient Days Unit 30,000 Patient Days Pharmacy Costs $100,000 $4.167 $140,000 Variable Misc Supplies $56,000 $2.333 $67,500 Costs Variable Fixed Overhead $708,000 $29.50 $780,000 Costs Total $864,0000 $36.00 $987,500 3.1. Determine the total variance associated with the planned and actual expenses. 3.2. Prepare a flexible budget of expense at 30,000 patient days. 3.3. Determine the "Spending Variance" which is defined as Actual costs less costs budgeted at actual volume.