Please fill in the blank spaces per excel spreadsheet:

ACTUAL RESULTS (Problem 8.4 p 298-299) 1. Volume: visits 30,000 members 360,000 A FFS B. Capitated lives Number of member months Actual visit utilization/MM Number of visits C. Total Actual Visits 0 visits O visits II. Revenue Assumptions: A. FFS per visit 0 actual visits B. Capitated lives PMPM 360,000 actual member months Total III. Cost Assumptions: A. Variable Costs: Labor Supplies Total variable costs $ Variable cost per visit = 46,000hrs * $27/hr =90,000 units * $1.40/unit #DIV/0! = $ 1,368,000 + 77,200 visits B. Fixed costs Overhead, plant, & equipment Total costs IV. Profit & Loss (P&L) Statement: Revenues FFS Capitated Total Costs: Variable: FFS Capitated Total variable costs Contribution Margin (CM) Fixed costs Profit #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! **Labor = (48,000hrs x $25/hr) Actual visits - Static visits Labor Hours = 48,000hrs x Actual visits - Static visits FLEXIBLE ***Supplies = (100,000 units x $1.50) Actual visits + Static visits Supply Units = 100,000 units x Actual visits - Static visits