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...
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...
Use the following information to answer the questions below:
Use the following information to answer the questions below: note: all sales are credit sales Income Stmt info: 2016 2017 Sales $ 975,000 $        1,072,500 less Cost of Goods Sold: 325,000 346,125 Gross Profit 650,000 726,375 Operating Expenses 575,000 609,500 Earnings before Interest & Taxes 75,000 116,875 Interest exp 25,000 31,000 earnings before Taxes 50,000 85,875 Taxes 20,000 34,350 Net Income $ 30,000 $              51,525 Balance Sheet info: 12/31/2016 12/31/2017 Cash 60,000 $ 63,600 Accounts Receivable 80,000 $ 84,000 Inventory...
Enter the transactions listed below in the General Journal. January 1, 2019 or 2020 – Use...
Enter the transactions listed below in the General Journal. January 1, 2019 or 2020 – Use January 1 as the starting date for transactions. This will give us a one-month accounting period for reports, etc. Date 1 Night invested cash in business, $90,000. Debit: Checking increases. Credit: Owner’s Equity increases. 1 Paid insurance premium for six-month camping season, $9,000. (Record the insurance payment as a pre-paid asset.) Debit: Prepaid asset of insurance Credit: Checking as cash was reduced 2 Paid...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT