Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Aspen Home Healthcare, a regional entity providing in-home care services in and around Aspen, Colorado expected to have 750 visits patients during September 2020 and
Aspen Home Healthcare, a regional entity providing in-home care services in and around Aspen, Colorado expected to have 750 visits patients during September 2020 and had budgeted $40,500 in variable costs for the month. Actual patient visits for September 2020 were higher than expected at 825 and variable costs also exceed budget, coming in at $44,550 for the month. In contrast to the higher than expected expenses, revenue came in higher than expected at $61,875, which was above the budgeted revenue of $61,500 expected for September. | |||||||||
43.How much of Aspen's variance is due to actual volume being higher than budget by 75 visits? 44.How much of Aspen's variance is due to price differences, i.e., $75 per visit actual price versus $82 price per visit budget? 45. How much is Aspen's total profit variance? | |||||||||
Total Revenue | $61,500 | $61,875 | |||||||
Total Costs | $40,500 | $44,550 | |||||||
Patient Volume | 750 | 825 | |||||||
Revenue Per Visit | $82.00 | $75.00 | |||||||
Cost Per Visit | $54.00 | $54.00 | |||||||
Budget | Actual | Total Variance | Favorable or Unfavorable? | Volume Variance | Rate Variance | Total Variance | Favorable or Unfavorable? | ||
Total Patient Revenue | $0 | $0 | |||||||
Total Variable Costs | $0 | $0 | |||||||
Total Fixed Costs | $0 | -- | |||||||
Total Costs | $0 | $0 | $0 | $0 | $0 | $0 | |||
Monthly Profit/(Loss) | $0 | $0 | $0 | $0 | $0 | $0 | |||
(1)Volume Variance Formula | (Actual Volume - Budgeted Volume) x Budgeted Rate | ||||||||
(2)Rate Variance Formula | Actual Volume x (Actual Rate - Budgeted Rate) |
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