Chelsea Clinic’s static budget, flexible budget and actual expense information for 2020 is listed below.
Assumptions: | Static Budget | Flexible Budget | Actual Results | |
Blue Cross Visits | 36,000 | 40,000 | 40,000 | |
Highmark Visits | 54,000 | 60,000 | 60,000 | |
Total Visits | 90,000 | 100,000 | 100,000 | |
Revenues | ||||
Blue Cross | $ 900,000 | $ 1,000,000 | $ 1,120,000 | |
Highmark | $ 1,080,000 | $ 1,200,000 | $ 1,080,000 | |
Total | $ 1,980,000 | $ 2,200,000 | $ 2,200,000 | |
Costs | ||||
Variable: | ||||
Labor | $ 1,200,000 | $ 1,333,333 | $ 1,400,000 | |
Supplies | $ 150,000 | $ 166,667 | $ 225,000 | |
Total Variable | $ 1,350,000 | $ 1,500,000 | $ 1,625,000 | |
Fixed Costs | $ 500,000 | $ 500,000 | $ 500,000 | |
Total Costs | $ 1,850,000 | $ 2,000,000 | $ 2,125,000 | |
Profit | $ 130,000 | $ 200,000 | $ 75,000 |
3a. Based on this information, calculate revenue variance.
Choice: $220,000
Choice: $318,000
Choice: $25,000
Choice: ($55,000)
3b. Based on this information, calculate cost variance.
Choice: $95,000
Choice: $145,000
Choice: ($275,000)
Choice: ($100,000)
Solution 3a:
Revenue variance = Actual sales revenue - Budgeted sales revenue = $2,200,000 - $1,980,000 = $220,000
Hence first option is correct.
Solution 3b:
Cost variance = Budgeted total cost - Actual total cost = $1,850,000 - $2,125,000 = ($275,000)
Hence third option is correct.
Chelsea Clinic’s static budget, flexible budget and actual expense information for 2020 is listed below. Assumptions:...
11. Chelsea Clinic's static budget, flexible budget and actual expense information for 2018 is listed below. To make the following problems easier I have summarized the following three financial statements side by side - static budget, flexible budget and actual results. Assumptions: Blue Cross Visits Highmark Visits Total Visits Static Budget 36,000 54,000 90,000 Flexible Budget 40,000 60,000 100,000 Actual Results 40,000 60,000 100,000 Revenues Blue Cross Highmark Total $ $ $ 900,000 $ 1.080.000 $ 1,980,000 $ 1,000,000 $...
(--) 。 소 | Chelsea Clinic's projected budget information for 2015 is listed below. Total FFS Visit Vohume Payer Mix 凸 https:/ intncture.comuurse /1499132/qannaosannake 90,000 visits Blue Cross 40% 60% Highmark Blue Cross Highmark S25 per visit S20 per visit Variable Costs Resource Inputs Labor Supplies 48,000 total hours 00,000 total units Resource Input Prices Labor Supplies S 25.00 per hour S 1.50 per unit Fixed Costs (overhead plant and equipment) $500,000.00 Based on this information, calculate the Blue Cross...
8.6 attached for reference 8.7 Refer to Problem 8.6. Chelsea Clinic's actual results for 2015 are shown in the table below. Total FFS Visit Volume Payer Mix: 100,000 visits Blue Cross 40% 60% Highmark Reimbursement Rates: Blue Cross $28 per visit $18 per visit Highmark Variable Costs Resource Inputs 50,000 total hours 150,000 total units (continued) Labor Supplies continued from previous page) Resource Input Prices: $28.00 per hour $1.50 per unit $500,000 Labor Supplies Fixed Costs (overhead, plant, and equipment)...
6 Chelsea Clinic projected the following budget information for 2015: 8. Total FFS Visit Volume Payer Mix: 90,000 visits Blue Cross Highmark 40% 60% Reimbursement Rates: Blue Cross Highmark $25 per visit $20 per visit Variable Costs Resource Inputs: Labor Supplies Labor Supplies 48,000 total hours 100,000 total units Resource Input Prices $25.00 per hour $1.50 per unit $500,000 Fixed Costs (overhead, plant, and equipment) a. Construct Chelsea Clinic's operating budget for 2015. b. Discuss how each key budget assumption...
Chapter 8: Financia l Planning and Budgeting elsea Clinic projected the following budget information for 2015: Che 8.6 Total FFS Visit Volume Payer Mix: 90,000 visits Blue Cross 40% 60% Highmark Reimbursement Rates: Blue Cross Highmark $25 per visit $20 per visit Variable Costs Resource Inputs: Labor 48,000 total hours 100,000 total units Supplies Resource Input Prices: Labor Supplies $25.00 per hour $1.50 per unit $500,000 Fixed Costs (overhead, plant, and equipment) a. Construct Chelsea Clinic's operating budget for 2015...
Problem 1 Tallahassee Clinic projected the following budget information for 2018: Total FFS Visit Volume 90,000 visits Payer Mix: Blue Cross 40% Celtic Insurance Company 60% Reimbursement Rates: Blue Cross $25 per visit Celtic Insurance Company $20 per visit Variable Costs – Resource Inputs: Labor 48,000 total hours Supplies 100,000 total units Variable Costs – Input Prices: Labor $25 per hour Supplies $1.50 per unit Fixed Costs (overhead, plant, and equipment) $500,000...
Problem 1 Tallahassee Clinic projected the following budget information for 2018: Total FFS Visit Volume 90,000 visits Payer Mix: Blue Cross 40% Celtic Insurance Company 60% Reimbursement Rates: Blue Cross $25 per visit Celtic Insurance Company $20 per visit Variable Costs – Resource Inputs: Labor 48,000 total hours Supplies 100,000 total units Variable Costs – Input Prices: Labor $25 per hour Supplies $1.50 per unit Fixed Costs (overhead, plant, and equipment) $500,000...
Tallahassee Clinic projected the following budget information for 2018: Total FFS Visit Volume 90,000 visits Payer Mix: Blue Cross 40% Celtic Insurance Company 60% Reimbursement Rates: Blue Cross $25 per visit Celtic Insurance Company $20 per visit Variable Costs – Resource Inputs: Labor 48,000 total hours Supplies 100,000 total units Variable Costs – Input Prices: Labor $25 per hour Supplies $1.50 per unit Fixed Costs (overhead, plant, and equipment) $500,000 Construct Tallahassee...
a) Prepare actual, static and flexible budget income statements for December. b) What is the flexible budget variance and volume variance for total COGM and indicate if it is favorable or unfavorable? c) To further investigate the flexible budget variance, Merry Inc. found that the budgeted direct labor rate was $54 per hour and expected production rate was 10 trees per hour. Actual direct labor rate was $70 per hour and actual production rate was 12 trees per hour. Compute...
M9-5 (Static) Preparing a Flexible Budget (LO 9-2] Evanson Company expects to produce 500,000 units of their product during the year. Monthly production is expected to range fro 40,000 to 80,000 units. The company has budgeted manufacturing costs per unit to be as follows: Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Prepare a flexible manufacturing budget using 20,000 unit increments Prepare a flexible manufacturing budget using 20,000 unit increments. ® Answer is complete but not entirely correct....