Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Assignment Exercise 18-1: Variance Analysis Greenview Hospital operated at 120% of normal capacity in two of its departments during the year. It operated 120% times
Assignment Exercise 18-1: Variance Analysis Greenview Hospital operated at 120% of normal capacity in two of its departments during the year. It operated 120% times 20,000 normal capacity direct labor nursing hours in routine services and it operated 120% times 20,000 normal capacity equipment hours in the laboratory. The lab allocates overhead by measuring minutes and hours the equipment is used; thus equipment hours. Assumptions For Routine Services Nursing: . 20,000 hours 3 1 20% 24,000 direct labor nursing hours. Budgeted Overhead at 24,000 hours $42,000 fixed plus $6,000 variable $48,000 total. Actual Overhead at 24,000 hours $42,000 fixed plus $7,000 variable $49,000 total Applied Overhead for 24,000 hours at $2.35 $56,400 For Laboratory: . 20,000 hours 3 12096 24,000 equipment hours. Budgeted Overhead at 24,000 hours $59,600 fixed plus $11,400 variable $71,000 total. Actual Overhead at 24,000 hours = $59,600 fixed plus $11,600 variable $71,200 total. Applied Overhead for 24,000 hours at $3.455 $82,920 Required 1. Set up a worksheet for applied overhead costs and volume variance with a column for Routine Services Nursing and a second column for Laboratory 2. Set up a worksheet for actual overhead costs and budget variance with a column for Routine Services Nursing and a second column for Laboratory 3. Set up a worksheet for volume variance and budget variance totaling net variance with a column for Routine Services Nursing and a second column for Laboratory. 4. Insert input data from the Assumptions. 5. Complete computations for all three worksheets
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started