Fill in the blank cells to ultimately get the 2016 budgeting...

Fill in the blank cells to ultimately get the  2016 budgeting projection. Some hints in red are included

 

      

Transcribed Image Text:

A B C D E F G H J Date: Name: Bellaire Clinical Labs, Inc. 2016 Budgeting Projection Number of tests per year % of tests routine 2015 Actual 2016 Projected 980,000 1,000,000 2015 Actual Number of tests billed to Physicians 84% 80% Patients Others % of tests specialty - % of tests paid for by physicians % of tests paid for by patients % of tests paid for by other parties Average price for a routine test when physicians pay when patients pay when other party pays Average price for a specialty test when physicians pay when patients pay when other party pays Total 2016 Projections (Q) Percentage (%) Number of tests billed to Physicians Patients Others Total Routine 823,200 Specialty Total 823,200 Routine Specialty Total 80% 20% 100% K 2016 Projections (Revenue in $) Number of tests billed to Physicians Patients Others Reveue Total 2016 Projection - Expenses SG&A Mgt Compensation Other Admin Cost Variable Cost Material ($2.70/test) Labor: Routine ($12/hour & 0.25/test) Specialty Billing and Collection Physicians Patients Others Fixed Cost Dep Advertising Other cost Other testing ($300,00 + $0.80/test) Expense Total Profit L N A Routine Specialty Total A B C D E F G H J Date: Name: Bellaire Clinical Labs, Inc. 2016 Budgeting Projection Number of tests per year % of tests routine 2015 Actual 2016 Projected 980,000 1,000,000 2015 Actual Number of tests billed to Physicians 84% 80% Patients Others % of tests specialty - % of tests paid for by physicians % of tests paid for by patients % of tests paid for by other parties Average price for a routine test when physicians pay when patients pay when other party pays Average price for a specialty test when physicians pay when patients pay when other party pays Total 2016 Projections (Q) Percentage (%) Number of tests billed to Physicians Patients Others Total Routine 823,200 Specialty Total 823,200 Routine Specialty Total 80% 20% 100% K 2016 Projections (Revenue in $) Number of tests billed to Physicians Patients Others Reveue Total 2016 Projection - Expenses SG&A Mgt Compensation Other Admin Cost Variable Cost Material ($2.70/test) Labor: Routine ($12/hour & 0.25/test) Specialty Billing and Collection Physicians Patients Others Fixed Cost Dep Advertising Other cost Other testing ($300,00 + $0.80/test) Expense Total Profit L N A Routine Specialty Total