Question

In: Accounting

Chelsea Clinic’s PROJECTED budget information for 2020 is listed below. Please use this information to answer...

Chelsea Clinic’s PROJECTED budget information for 2020 is listed below. Please use this information to answer the questions below.

Chelsea Clinic
Total FFS Visit Volume 90,000 visits
Payer Mix:
Blue Cross 40%
Highmark 60%
Reimbursment Rates
Blue Cross $25 per visit
Highmark $20 per visit
Variable Costs
Resource Inputs
Labor            48,000 total hours
Supplies          100,000 total units
Resource Input Prices
Labor $          25.00 per hour
Supplies $            1.50 per unit
Fixed Costs (overhead, plant and equipment) $ 500,000.00

1a. Based on the projected budget information calculate the total budgeted costs.

Choice: $1,850,000

Choice: $1,455,000

Choice: $2,200,400

Choice: $1,000,000

1b. Based on the projected budget information, calculate the contribution margin.

Choice: $550,000

Choice: $630,000

Choice: $874,000

Choice: $1,000,000

1c.  Based on the projected budget information, calculate the budgeted profit.

Choice: $98,000

Choice: $117,000

Choice: $130,000

Choice: $158,000

Solutions

Expert Solution

Answer 1a:

$ 1,850,000

Answer 1b:

$ 630,000

Answer 1c:

$ 130,000

Calculations:

Particulars Blue Cross Highmark Total
Visits       36,000.00          54,000.00          90,000.00
Rate $          25.00 $              20.00
Total revenue $900,000.00 $1,080,000.00 $1,980,000.00
Cost
Labor hours       19,200.00          28,800.00          48,000.00
Labor rate $          25.00 $              25.00
Total labor cost $480,000.00 $    720,000.00 $1,200,000.00
Supplies       40,000.00          60,000.00        100,000.00
Rate $            1.50 $                1.50
Total supplies cost $   60,000.00 $      90,000.00 $    150,000.00
Contribution $ 360,000.00 $    270,000.00 $    630,000.00
Less: Fixed cost $    500,000.00
Profit $    130,000.00

In case of any doubt, please comment.


Related Solutions

Chelsea Clinic’s actual and budget information for 2020 is listed below, we will use this to...
Chelsea Clinic’s actual and budget information for 2020 is listed below, we will use this to calculate the flexible budget. Chelsea had actual visits of 100,000 patient visits. Total FFS Visit Volume 100,000 visits Budgeted FFS Visit Volume 90,000 visits Budgeted Variable Costs Variable Budget - Volume : Labor 48,000 total hours Supplies 100,000 total units Variable Budget - Prices: Labor $ 25.00 per hour Supplies $ 1.50 per unit Actual Variable Costs Actuals - Volume: Labor 50,000 total hours...
CHAPTER 8: FINANCIAL PLANNING & BUDGETING Homework 3.4, Chapter8 Chelsea Clinic projected the following budget information...
CHAPTER 8: FINANCIAL PLANNING & BUDGETING Homework 3.4, Chapter8 Chelsea Clinic projected the following budget information for 2021: Total FFS Visits Volume 70,000 visits Payer Mix:    Blue Cross 60%    Highmark 40% Reimbursement Rates:    Blue Cross $45 per visit    Highmark $50 per visit Variable Costs     Resource Inputs:         Labor 0.7 total hours         Supplies 1.3 total units     Resource Input Prices:         Labor $22.00 per hour         Supplies $1.25 per unit Fixed Costs $800,000 Using Exhibit...
Use the following information to answer the questions below. The balances listed below were taken from...
Use the following information to answer the questions below. The balances listed below were taken from the ABC Inc.’s unadjusted trial balance on January 31st. The company’s reporting period began on January 1st . Accounts Receivable $23,000 Accumulated Depreciation 27,000 Accounts Payable 40,000 Cash 22,000 Common Stock 50,000 Equipment 72,000 Land 2,000 Long-term investment 55,000 Prepaid Rent 18,000 Retained Earnings (Beginning) 56,000 Salaries Expense 15,200 Service Revenue 42,200 Supplies 5,000 Utilities Expense 3,000 In addition, assume the following: A. There...
REQUIRED Use the information provided below to prepare the following for March 2020: 2.1. Flexible budget...
REQUIRED Use the information provided below to prepare the following for March 2020: 2.1. Flexible budget for two different activity levels i.e. 18 000 and 25 000 units (9) 2.2. Performance report (11) 2.3. Comment on the following variances: 2.3.1. Sales (1) 2.3.2. Direct Material (2) 2.3.3. Fixed overheads (2) INFORMATION Widget Ltd manufactures a single product. It originally planned to produce and sell 12 000 units during the year but the actual activity level was 14 000 units. The...
Please read the Bloomberg article below, and use the information in the article to answer this...
Please read the Bloomberg article below, and use the information in the article to answer this question. U.S. Gasoline Use Rising to Record This Summer on Low Prices by Mark Shenk U.S. Gasoline Use Rising to Record This Summer on Low Prices by Mark Shenk June 7, 2016, 12:23 PM EDTJune 8, 2016, 12:01 AM EDT Gasoline consumption to average 9.5 million barrels a day: EIA WTI crude seen averaging $42.83/bbl in 2016, $51.82 in 2017 Oil Producers Respond to...
PLEASE PLEASE ANSWER AS SOON AS POSSIBLE. 1. Use the information below for Harding Company to...
PLEASE PLEASE ANSWER AS SOON AS POSSIBLE. 1. Use the information below for Harding Company to answer the question that follow. Harding Company Accounts payable $27,565 Accounts receivable 71,510 Accrued liabilities 6,541 Cash 16,862 Intangible assets 42,141 Inventory 77,866 Long-term investments 103,355 Long-term liabilities 70,445 Marketable securities 33,752 Notes payable (short-term) 23,329 Property, plant, and equipment 622,170 Prepaid expenses 2,338 Based on the data for Harding Company, what is the amount of working capital? a.$969,994 b.$202,328 c.$619,832 d.$144,893 4. The...
Please show all work and formula: Please use the information on the table below to answer...
Please show all work and formula: Please use the information on the table below to answer this question. Security                       Actual Return             Beta A                                 12%                             1.2 B                                  10%                             1.0 C                                  14%                             1.4 Assume the risk-free interest rate is 1% and the market risk premium is 5.5%. An investor would like to invest $40,000 in Security A, $25,000 in security B and $50,000 in Security C. Find the portfolio’s expected return. Find the portfolio’s actual return. Based on your answers to a...
Use the first web site listed below to find the budget surplus or deficit for the...
Use the first web site listed below to find the budget surplus or deficit for the last 5 years. Use the second web site to find the unemployment rate during those same years. Explain whether you think fiscal policy was appropriate during the last 5 years, assuming the economy is at the full employment level when the unemployment rate is 5 percent. Make your reasons clear. The Congressional Budget Office is charged with providing nonpartisan analysis of the economy and...
Use the first web site listed below to find the budget surplus or deficit for the...
Use the first web site listed below to find the budget surplus or deficit for the last 5 years. Use the second web site to find the unemployment rate during those same years. Explain whether you think fiscal policy was appropriate during the last 5 years, assuming the economy is at the full employment level when the unemployment rate is 5 percent. Make your reasons clear. The Congressional Budget Office is charged with providing nonpartisan analysis of the economy and...
Using the information given in the master schedule below, answer the following: Determine the Projected Ending...
Using the information given in the master schedule below, answer the following: Determine the Projected Ending Inventory in each week as well as the Available to Promise quantities in weeks 2, 4, 6, and 8. What does a negative projected ending inventory value mean? How does it differ from a negative available to promise value? Which do you think would be easier for a manger to deal with – a negative projected inventory value or a negative ATP? Why? On-hand...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT