I need help completing the top common sizing portion of M5A2 Common Sizing & Ratio. There is a Tip sheet on M5A2 tips to help.
M2A2: Components of Balance Sheet and Statement of Net Income Current Liabilities Total Assets Income from Operations Accumulated Depreciation Total Operating Revenue Current Portion of Long-Term Debt Interest Income Inventories 20X3 $5,825,000.00 $10,625,000.00 $1,700,000.00 $1,900,000.00 $35,100,000.00 $525,000.00 $80,000.00 $900,000.00 The most current year is placed in the first column. 20X2 $6,300,000.00 $9,975,000.00 $840,000.00 $1,800,000.00 $34,600,000.00 $500,000.00 $40,000.00 $850,000.00 Calculating the Contribution Margin The Mental Health program for the Community Center has just completed its fiscal year end. The Program Director determines that his progr revenue for the year of $1,520,000. He believes his variable expense amounts to $320,000 and he knows his fixed expense amounts to $1,3 1. Compute the contribution margin for the Community Center Mental Health program. 2. What does the result tell you about the program? COMPUTATION Program Revenue Less Variable Expense Contribution Margin Less Fixed Cost Operating Profit - Loss 2. Answer to Question: $1, 520,000 ($320,000) $1,200,000 ($1,300,000) $100,000 The programs revenue is enough to cover the compaines variable expenses. The companies fixed costs are higher than the contrib ermines that his program has ense amounts to $1,300,000. e higher than the contribution margin which causes the company to operate at a net loss. The fixed costs are incurred irrespectively. HS414 Module 3 Activity - Variance Analysis Worksheet 1 Applied Overhead Costs (Less) Budgeted Overhead Costs Volume Variance Routine Services Nursing Laboratory 56,400 82,920 (48,000) (71,000) 8,400 11,920 Worksheet 2 Actual Overhead Costs (Less) Budgeted Overhead Costs at 24,000 hours Budget Variance 49,000 (48,000) 1,000 71,200 (71,000) 200 8,400 (1,000) 7,400 11,920 (200) 11,720 Worksheet 3 Volume Variance (Less) Budgeted Variance Net Variance Please read the instructions for this activity under Module 4 Activity 2 and compute the number of FTEs required to fill the O Position(s) Nursing Supervisor Technician RN LPN Aide Clerical FTEs to cover positions 7 days/week Shift 1 Day 2 2 3 0 1 1 Shift 2 Evening 1 2 2 0 0 0 Shift 3 Night 1 1 1 1 0 0 12.6 (9 x 1.4) 7 (5 x 1.4) 5.6 (4 x 1.4) 24 hour Scheduling Total 4-8 hour shifts 5-8 hour shifts 6-8 hour shifts 1-8 hour shifts 1-8 hour shifts 1-8 hour shifts 25.2 FTEs er of FTEs required to fill the Operating Room staffing positions. Module 5 Assignment Common Sizing Template 1. Common size the MHS Statement of Revenue and Expenses for each category. Metropolis Health System Statement of Revenue and Expenses For the Years Ended March 31, 20XX and 20XX Year 2 Common Sized Year 1 Common Sized Revenue Net patient service revenue Other revenue Total Operating Revenue $34,000,000 $1,100,000 $35,100,000 100% $33,600,000 $1,000,000 $34,600,000 100% $5,450,000 $12,950,000 $3,220,000 $8,340,000 $1,800,000 $50,000 $350,000 $1,600,000 $33,760,000 97.11% 2.89% (EXAMPLE) 100% Expenses Nursing services Other professional services General services Support services Depreciation Amortization Interest Provision for doubtful accounts Total Expenses Income from Operations $5,025,000 $13,100,000 $3,200,000 $8,300,000 $1,900,000 $50,000 $325,000 $1,500,000 $33,400,000 $1,700,000 $840,000 $20,000 $80,000 $100,000 $70,000 $40,000 $110,000 100% Nonoperating Gains (Losses) Unrestricted gifts and memorials Interest income Nonoperating Gains Net Revenues and Gains in Excess of Expenses and Losses Ratio Calculations (Show your Work) $1,800,000 100% $950,000 100% Use the Metropolis Health System (MHS) comparative financial statements in the Examples and Exercises section. Quick Ratio Year 2 = Cash & Cash Equivalents + Net Receivables / Current Liabilities (115,0000+825,000+7,400,000+15 Days Receivables Year 2 = Net Receivables / Net Credit Revenue / # of Days In Period ((8,700,000+150,000)/35,100,000)*365 Operating Margin Year 2 = Operating Incom (loss) / Total Operating Revenues (1700,000/3,500,000) = 4.84% See following tab M5A2 Ratios 'TIP SHEET' for assistance with Ratios (EXAMPLE) ises section. (115,0000+825,000+7,400,000+150,000)/5,825,000 = 1.64 00,000+150,000)/35,100,000)*365 = 92.03 Days 00,000) = 4.84% Refer to the Metropolis Health System (MHS) case study. How to compute Ratio Tip sheet HS414-Module 6-Medicare Prevailing Rates Activity CPT/HCPCS 99201 99202 99203 99204 99205 99211 99212 99213 99214 99215 SHORT DESCRIPTION Office/ Outpatient Visit new patient Office/ Outpatient Visit new patient Office/ Outpatient Visit new patient Office/ Outpatient Visit new patient Office/ Outpatient Visit new patient Office/Outpatient Visit Established Patient Office/Outpatient Visit Established Patient Office/Outpatient Visit Established Patient Office/Outpatient Visit Established Patient Office/Outpatient Visit Established Patient PROC STAT A A A A A A A A A A CARRIER LOCALITY 1230201 1230201 1230201 1230201 1230201 1230201 1230201 1230201 1230201 1230201 NON FACILITY PRICE $47.15 $79.78 $115.83 $175.71 $217.02 $22.00 $47.15 $77.82 $113.99 $152.25 FACILITY PRICE $27.37 $51.79 $79.62 $135.77 $174.10 $9.31 $25.88 $52.44 $80.78 $113.81 PAYMENT AMOUNT CONV FACTOR 34.023 34.023 34.023 34.023 34.023 34.023 34.023 34.023 34.023 34.023 NA NA NA NA NA NA NA NA NA NA PAYMENT AMOUNT NA NA NA NA NA NA NA NA NA NA M6A2 - Health Care Administrator Case Study Project - Part 1 1. 2. Read the Case Study 13.3: North Side Hospital in module Complete the form to prepare a cash forecast (budget) for the months of January, February, and March using th Description November Receivables December Receivables January Receivables February Receivables March Receivables Less: 2% discount Total cash inflows from receivables Gross Receivable January Collections February Collections 15,000 7,500 25,000 10,000 7,500 200,000 98,000 40,000 210,000 102,900 220,000 6,300 115,500 150,400 Cash disbursements for expenses in month incurred 80,000 80,000 Cash disbursements for expenses in month AFTER incurred 75,000 80,000 Cash Balance change from operations for month -39,500 -9,600 40,000 40,000 39,500 9,600 40,000 40,000 Cash balance, beginning Cash from financing Cash balance, ending Budget Form of January, February, and March using the case study as a guide. March Collections Total Collected Excluding 2% Discount 15% Not Collected Remaining Receivable Balance 7,500 0 7,500 0 30,000 0 30,000 2,000 42,000 2,100 63,000 107,800 2,200 110,000 179,800 80,000 80,000 19,800 40,000 59,800
