please answer e-h ive already answered the first part.ive attached problem 1

Problem 2 Refer to Problem I above. Columbia Clinic's actual results for 2020 are shown in the table below: Total FFS Visit Volume 100,000 visits Payer Mix Private Insurance Medicare Reimbursement Rates: Private Insurance 2% per shit Medicare S18 per visit Variable Costs - Resource Inputs: Labor 50,000 total hours Supplies 150,000 total units Variable Costs - Input Prices 528 per hour Supplies $1.50 per unit Fixed Costs (overhead, plant, and equipment) $500,000 Labor a. Construct Tallahassee Clinic's flexible budget for 2020. Static budget for Fixable budget Fixable budget for Acutel 90000 visits per unit 100000 visits 100000 Variance Sales 405000 $45 4500000 4600000 100000A Direct Material 1000 LS per unit 225000 22:5000 Direct Labor 100000 25 per hour 1250000 1400000 150000 A Variable Overheads Total varible cost 11 SOOD 26.5 1475000 1625000 Contribution 1100000 18.5 18SODOC 297 500 Fixed cost 500000 5.56 S00000 S00000 Net profit 6000001 12.94 1350000 2475000 1125000A b. Calculate the revenue variance 550000 c. Calculate the cost variance 150000 d. Calculate the profit variance 129400 e. Focus on the revenue side. What is the volume variance? f. Focus on the revenue side. What is the price variance? g. Focus on the cost side. What is the volume variance? h. Focus on the cost side. What is the management variance? Problem 1 Columbia Clinic projected the following budget information for 2020: Total FFS Vis Volume 90,000 Payer Mit Private Insurance 40% Medicare Reimbursement Rates Private Insurance Medicare 530 per shit Variable Costs - Resource Inputs: Labor 28,000 totale Supplies Variable Couto - Input Price Labor 525 per her Supplies 51.50 per Fixed Costs overhead, plant, and equipment, Construct Columbia Clinic's static operating budget for 2020. (See Exhibit 8.3, page 283. Note that there are four components that need to be included: Volume Assumptions, Revenue Assumptions, Cost Assumptions, and the Pro Forma Profit and Loss or P&L projected Statement. Columbia Clinic does not have capitated contracts.) Private Insurance Medicare Total 3600X SO of visits Ratio Reveme A 525 per visit 900,000.00 1.000.000,00 1.90,0000 520 pst visit Variable Costs Lahor hours ratio Labor cost25 per hour bis 19200 BO 480,000.00 720,000.00 $ 1.200,000.00 Supplies unit Ratio Laborcos 1.5 unit OOK BOOK 100 4 1,000,000.00 $ 1.500,000.00 $ 2.500,000.00 Fixed cost 200,000.00 30,000.00 5 SO,000.00 207 1.220,000.005 1.560,000.00 2.780,000.00 Profit A.B.C.D 1. Labor hours are divided in the ratio of visits 2. Units supplied are divided in the ratio of visits 3. Fixed cost has been allocated in the ratio of visits. Name Faithful Byrd Problem 1 Columbia Clinic projected the following budget information for 2020 Total Volume Pyer Mix Private Medica Reimbursementes Polve Insume 525 Matic 520 per Variable - Recept Supplies Variable CosInput Laher Supplies Fived Costs overhead plant and equipment tal Construct Columbia Clinic's static operating budget for 2020 (See Exhibit 8.3, page 283. Note that there are four components that need to be included: Volume Assumptions, Revenue Assumptions, Cost Assumptions, and the Pro Forma Profit and Loss or P&L projected Statement. Columbia Clinic does not have capitated contracts.) of visits Mere Sood 40 nd 900.000 DOSTORO,000.00 190.000 RA Variable Co Labor hours 1930 40 Labor cost per hours 720,000.00 1.200 Support Ratio The coup 1.000.000 1.500.000 200.000.00 10,000.00 0.0 Patio Profit ABCD 1.220.000 1.300.000 27.000 1. Labor hours are divided in the ratio of visits 2. Units supplied are divided in the ratio of visits 3. Fixed cost has been allocated in the ratio of visits. Problem 2 Refer to Problem have Columbia Chile Problem 2 Refer to Problem I above. Columbia Clinic's actual results for 2020 are shown in the table below: Total FFS Visit Volume 100,000 visits Payer Mix Private Insurance Medicare 60% Reimbursement Rates Private Insurance 52% per visit Medicare S18 per visit Variable Costs - Resource Inputs: Labor 50,000 total hours Supplies 150,000 total units Variable Costs - Input Prices Labor $28 per hour Supplies $1.50 per unit Fixed Costs (overhead, plant, and equipment) $500,000 a. Construct Tallahassee Clinic's flexible budget for 2020. Static budget for Fixable budget Fiable budget for Acutal 90000 visits per unit 100000 visits 100000 Variance Sales 4050000 5451 4500000 4600000 100000 Direct Material 150000 1.5 per unit 22:5000 225000 Direct Labor 100000 25 per hour 1250000 1400000 150000 Variable Overheads Total varible koos 1150000 26.5 147500016250001 Contribution 1100000 1&S 185000 2975000 Fixed cost 500000 5.56 SOODI 500000 Net profit 600000 12.94 1350000 2475000/1125000 b. Calculate the revenue variance 550000 c. Calculate the cost variance 150000 d. Calculate the profit variance 129400 e. Focus on the revenue side. What is the volume variance? f. Focus on the revenue side. What is the price variance? g. Focus on the cost side. What is the volume variance? h. Focus on the cost side. What is the management variance? Problem 2 Refer to Problem I above. Columbia Clinic's actual results for 2020 are shown in the table below: Total FFS Visit Volume 100,000 visits Payer Mix Private Insurance Medicare Reimbursement Rates: Private Insurance 2% per shit Medicare S18 per visit Variable Costs - Resource Inputs: Labor 50,000 total hours Supplies 150,000 total units Variable Costs - Input Prices 528 per hour Supplies $1.50 per unit Fixed Costs (overhead, plant, and equipment) $500,000 Labor a. Construct Tallahassee Clinic's flexible budget for 2020. Static budget for Fixable budget Fixable budget for Acutel 90000 visits per unit 100000 visits 100000 Variance Sales 405000 $45 4500000 4600000 100000A Direct Material 1000 LS per unit 225000 22:5000 Direct Labor 100000 25 per hour 1250000 1400000 150000 A Variable Overheads Total varible cost 11 SOOD 26.5 1475000 1625000 Contribution 1100000 18.5 18SODOC 297 500 Fixed cost 500000 5.56 S00000 S00000 Net profit 6000001 12.94 1350000 2475000 1125000A b. Calculate the revenue variance 550000 c. Calculate the cost variance 150000 d. Calculate the profit variance 129400 e. Focus on the revenue side. What is the volume variance? f. Focus on the revenue side. What is the price variance? g. Focus on the cost side. What is the volume variance? h. Focus on the cost side. What is the management variance? Problem 1 Columbia Clinic projected the following budget information for 2020: Total FFS Vis Volume 90,000 Payer Mit Private Insurance 40% Medicare Reimbursement Rates Private Insurance Medicare 530 per shit Variable Costs - Resource Inputs: Labor 28,000 totale Supplies Variable Couto - Input Price Labor 525 per her Supplies 51.50 per Fixed Costs overhead, plant, and equipment, Construct Columbia Clinic's static operating budget for 2020. (See Exhibit 8.3, page 283. Note that there are four components that need to be included: Volume Assumptions, Revenue Assumptions, Cost Assumptions, and the Pro Forma Profit and Loss or P&L projected Statement. Columbia Clinic does not have capitated contracts.) Private Insurance Medicare Total 3600X SO of visits Ratio Reveme A 525 per visit 900,000.00 1.000.000,00 1.90,0000 520 pst visit Variable Costs Lahor hours ratio Labor cost25 per hour bis 19200 BO 480,000.00 720,000.00 $ 1.200,000.00 Supplies unit Ratio Laborcos 1.5 unit OOK BOOK 100 4 1,000,000.00 $ 1.500,000.00 $ 2.500,000.00 Fixed cost 200,000.00 30,000.00 5 SO,000.00 207 1.220,000.005 1.560,000.00 2.780,000.00 Profit A.B.C.D 1. Labor hours are divided in the ratio of visits 2. Units supplied are divided in the ratio of visits 3. Fixed cost has been allocated in the ratio of visits. Name Faithful Byrd Problem 1 Columbia Clinic projected the following budget information for 2020 Total Volume Pyer Mix Private Medica Reimbursementes Polve Insume 525 Matic 520 per Variable - Recept Supplies Variable CosInput Laher Supplies Fived Costs overhead plant and equipment tal Construct Columbia Clinic's static operating budget for 2020 (See Exhibit 8.3, page 283. Note that there are four components that need to be included: Volume Assumptions, Revenue Assumptions, Cost Assumptions, and the Pro Forma Profit and Loss or P&L projected Statement. Columbia Clinic does not have capitated contracts.) of visits Mere Sood 40 nd 900.000 DOSTORO,000.00 190.000 RA Variable Co Labor hours 1930 40 Labor cost per hours 720,000.00 1.200 Support Ratio The coup 1.000.000 1.500.000 200.000.00 10,000.00 0.0 Patio Profit ABCD 1.220.000 1.300.000 27.000 1. Labor hours are divided in the ratio of visits 2. Units supplied are divided in the ratio of visits 3. Fixed cost has been allocated in the ratio of visits. Problem 2 Refer to Problem have Columbia Chile Problem 2 Refer to Problem I above. Columbia Clinic's actual results for 2020 are shown in the table below: Total FFS Visit Volume 100,000 visits Payer Mix Private Insurance Medicare 60% Reimbursement Rates Private Insurance 52% per visit Medicare S18 per visit Variable Costs - Resource Inputs: Labor 50,000 total hours Supplies 150,000 total units Variable Costs - Input Prices Labor $28 per hour Supplies $1.50 per unit Fixed Costs (overhead, plant, and equipment) $500,000 a. Construct Tallahassee Clinic's flexible budget for 2020. Static budget for Fixable budget Fiable budget for Acutal 90000 visits per unit 100000 visits 100000 Variance Sales 4050000 5451 4500000 4600000 100000 Direct Material 150000 1.5 per unit 22:5000 225000 Direct Labor 100000 25 per hour 1250000 1400000 150000 Variable Overheads Total varible koos 1150000 26.5 147500016250001 Contribution 1100000 1&S 185000 2975000 Fixed cost 500000 5.56 SOODI 500000 Net profit 600000 12.94 1350000 2475000/1125000 b. Calculate the revenue variance 550000 c. Calculate the cost variance 150000 d. Calculate the profit variance 129400 e. Focus on the revenue side. What is the volume variance? f. Focus on the revenue side. What is the price variance? g. Focus on the cost side. What is the volume variance? h. Focus on the cost side. What is the management variance