Operating Budget, Flexible Budget: Carroll Clinic
Not what you're looking for?
2008 Carroll Clinic Operating Budget:
I. Volume (number of visits)
Payer A 9000
Payer B 12,000
Total 21,000
II. Reimbursement (per visit)
Payer A $ 100
Payer B $ 90
III. Costs
Variable costs:
Supplies $ 315,000
Fixed costs:
Labor $1,035,000
Overhead 500,000
Total $1,535,000
IV. Forecasted P&L Statement
Revenues:
Payer A $ 900,000
Payer B $ 1,080,000
Total Revenue $1,980,000
Variable costs $315,000
Fixed costs $1,535,000
Total costs $1,850,000
Profit $ 130,000
Carroll Clinic Actual Results 2008
I. Volume
Payer A 11,000
Payer B 12,000
Total 23,000
II. Reimbursement
Payer A $ 95
Payer B $ 95
III. Costs
Variable costs:
Supplies $ 350,000
Fixed costs:
Labor $1,000,000
Overhead 500,000
Total $1,500,000
IV. Forecasted P&L Statement
Revenues:
Payer A $ 1,045,000
Payer B 1,140,000
Total Revenues $2,185,000
Variable costs $ 350,000
Fixed costs $1,500,000
Total $1,850,000
Profit $ 335,000
a. What are the profit, revenue, and cost variances based on the simple budget?
b. Construct a flexible budget for 2008.
c. What are the profit, revenue and cost variances based on the flexible budget?
d. Interpret the results. In particular, focus on the differences between the variance analysis here and the Carroll Clinic illustration presented in the chapter.
Purchase this Solution
Solution Summary
Profit, revenue, cost variances, flexible budgets, and variance analysis are investigated in this Excel solution.
Purchase this Solution
Free BrainMass Quizzes
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
Motivation
This tests some key elements of major motivation theories.
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.