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

 

      

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