Services Goods Incremental Budgeting for a Healthcare Facility 2019 168 176 Jan 160 Feb 176 Apr Mar 184 May 160 Jun % Per hr $ Benchmark 32% % INCOME Operating Income Medicare Medicare Allowance (60%) Medicaid Medicaid Allowance (80%) 3rd Party Insurance 3rd Party Allowance (14%) Patient Bad Debt (60%) 8% 2018 Financials Annual $200,000,000 ($120,000,000) $100,000,000 ($80,000,000) $140,000,000 ($20,000,000) $50,000,000 ($30,000,000) $240,000,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 52% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o 0 0 0 0 0 0 0 0 0 0 0 0 0 4% 0 0 0 0 0 0 ol 0 0 $40,000 $ Non-Operating Income Interest Income Rental Income Gifts Received Donations Other Total Non-Operating Income $40,000 0 0 0 0 0 Total INCOME 240,040,000 0 0 0 0 0 Jan Feb Mar Apr May Jun % S per hr Benchmark $24.000 $4,000 $24,000 $4,000 20% EXPENSES Operating Expenses Accounting and Legal Advertising Depreciation Dues and Subscriptions Insurance Interest Expense Maintenance and Repairs Office Supplies Medical Supplies Postage Rent Research and Development Salaries and Benefits Taxes and Licenses Telephone Travel Utilities Web Hosting and Domains Other Total Operating Expenses $7.200,600 $6,000 $28,000 $12,001,000 $48,004,000 $6,000 $180,000 $0 $144,012.000 $12,001,000 $6,000 $6,000 $6,000 $6,000 $12,000 $223,530,600 60% 0 0 0 $200,000 $ Non-Recurring Expenses Furniture, Equipment and Software Gifts Given Other Total Non-Recurring Expenses $200,000 0 0 0 Total EXPENSES $223,730,600 0 0 0 0 0 0 0 0 0 0 Net Income Before Taxes Income Tax Expense $16,309,400 $4,072,350 NET INCOME (5.1%) $12,237,050 0 0 0 0 0 2019 Budget 176 Jan 160 Feb 168 Mar 176 Apr 184 May 160 Jun 176 Jul 176 Aug 160 Sep 184 Oct 160 Nov 168 Dec Total 0 0 0 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 g a 0 0 0 0 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 0 0 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4,072.350 4,072,350 0 0 0 0 0 0 0 0 0 0 0 0 0 -4,072,350 4,072.350 Services Goods [Company Name] 2017 Budget Jan Ful Mar Apr May Juin Jul Aug Sep Oct Nov Dec Total INCOME Sales Product 1 Product 2 Product 3 Product Products Podus Other 0 0 O 0 0 0 Total Sales D 9 0 O g 0 D 9 o o 0 0 9 . 0 0 Cost of Goods sold fromdetalls section COGS - Product D coos - Produd 2 COGSProd. 3 0 COGS-Produd D COGS Products D CAS. Pre D Total Cost of Goods Sold D 0 0 D 0 D 0 a 0 o 0 5 0 D D 0 0 0 0 0 0 0 0 0 D D D D 0 0 0 O 9 . 0 0 D D D . 0 9 0 0 Gross Profit D a 0 0 0 0 0 0 D D a 0 D 0 D 0 D 0 0 0 0 0 0 0 0 0 O 0 0 0 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oel Det Nov Dec Total 0 0 D 0 D D 0 Non Operating Income Interlineare Bent home Cthe Total Non-Operating Income Total INCOME EXPENSES Operating Expenses Accountry and Legal Metro Depreciation Da deri free Internal Maced opens Che Suppen PER Postage Rarit Rustarch and Development Saland Wages Turen Lic Telephone Travel Us Web Hosting and Domains Cthe Total Operating Expenses Non-Recurring Expenses Fumure, Egonent and software Gints Green Other Total Non Recurring Expenses Total EXPENSES 0 U 0 0 0 0 0 0 0 0 O 9 0 0 D 9 0 0 g 0 D . 0 0 0 0 0 0 6 0 0 0 0 0 0 0 8 0 D 0 0 o D 0 D Nel income Bottes Income Tax 0 D O U NET INCOME 0 0 0 O 0 0 0 O 0 0 o O 0 COST OF GOODS - Details Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total D Product giginwriery Goods Purchase or Word Shipping Champ Labor Other Loss Ending her Cost of Good Sola Profit (L03) 0 0 0 0 0 O D D 0 0 0 0 0 0 . 0 0 0 . 0 0 D 0 Product 2 Beginning Inwertory Goods Furchador autoured Shing Charge Labor and paym) Other Landing Goods Sold Proin (LO) 0 0 0 0 . D D 0 0 a 0 0 1 . 0 0 Products . Beginnertory Goods Purchase or Manufactured Shpohn Changes Labor ages and payroll Ctre Less Ending theory Cost of Goods Sold Proth (Loss) 0 0 0 0 . D D 9 a 0 0 0 D . B 0 0 . . g a 0 0 0 D 0 D 0 D 0 Product Beginning Shes Goods Pudr Wed Shipping Charge Lator Che Less Enringar Cost of Goods Salt Prof Los) U 0 0 0 . 0 D 0 O 0 a 0 0 D 0 Penu Services Goods Maintenance and Repairs Office Supplies Payroll Expenses Pus Rent Research and Development Sales and Waga Taxes and licenses Telephone Travel Ulities Web Hosting and Domains Other Total Operating Expenses 0 0 0 0 0 0 0 O 0 0 Non-Recurring Expenses Furniture Equipment and software Gifts Given Other Tatal Non-Recurring Expenses 0 0 0 0 0 0 0 0 0 0 0 0 Total EXPENSES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Net Income before Taxes Income Tax Expense 1 NET INCOME 0 0 0 0 0 O 0 O 0 0 0 COST OF GOODS - Details - Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total O Product 1 Beginning inventory Goods Purchased or Manufactured Shipping Charges Labor (wages and payroll Other Less Ending Inventory Cost of Goods Sold Profit (Loss) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 D 0 0 0 o Product Beginning inventory Goods Purchased or Manufactured Shipping Charges Labor (wagos and payroll Other Less Ending luntary Cost of Goods Sold Profit (Loss) 0 0 O 0 O 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 Products Beginning Twentory Goods Purchased or Manufactured Shipping Charges Labor (wages and payroll Other Less Ending Inventory Cost of Goods Sold Profit (LOS) 0 0 o 0 0 0 0 o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Product 4 Beginning inventory Goods Purchased or Manufactured Shipping Charges Labor (wages and payrol Other Less Ending inventory Cost of Goods Sold Profit (Loss) O O 0 0 0 0 0 O 0 0 0 0 0 0 0 O 0 0 0 0 0 0 o 0 Products Beginning inventory Goods Purchased or Manufactured Shipping Charges Labor and pro Other Less Ending Inventory Cast of Goods Sold Profit (L03) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Products Beginning inventory Goods Purchased or Manufactured Shipping Charges Labor (wages and payroll Other Less Ending Inventory Cost of Goods Sold Profit (Loss) 0 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 0 0 O Services Goods Incremental Budgeting for a Healthcare Facility 2019 168 176 Jan 160 Feb 176 Apr Mar 184 May 160 Jun % Per hr $ Benchmark 32% % INCOME Operating Income Medicare Medicare Allowance (60%) Medicaid Medicaid Allowance (80%) 3rd Party Insurance 3rd Party Allowance (14%) Patient Bad Debt (60%) 8% 2018 Financials Annual $200,000,000 ($120,000,000) $100,000,000 ($80,000,000) $140,000,000 ($20,000,000) $50,000,000 ($30,000,000) $240,000,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 52% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o 0 0 0 0 0 0 0 0 0 0 0 0 0 4% 0 0 0 0 0 0 ol 0 0 $40,000 $ Non-Operating Income Interest Income Rental Income Gifts Received Donations Other Total Non-Operating Income $40,000 0 0 0 0 0 Total INCOME 240,040,000 0 0 0 0 0 Jan Feb Mar Apr May Jun % S per hr Benchmark $24.000 $4,000 $24,000 $4,000 20% EXPENSES Operating Expenses Accounting and Legal Advertising Depreciation Dues and Subscriptions Insurance Interest Expense Maintenance and Repairs Office Supplies Medical Supplies Postage Rent Research and Development Salaries and Benefits Taxes and Licenses Telephone Travel Utilities Web Hosting and Domains Other Total Operating Expenses $7.200,600 $6,000 $28,000 $12,001,000 $48,004,000 $6,000 $180,000 $0 $144,012.000 $12,001,000 $6,000 $6,000 $6,000 $6,000 $12,000 $223,530,600 60% 0 0 0 $200,000 $ Non-Recurring Expenses Furniture, Equipment and Software Gifts Given Other Total Non-Recurring Expenses $200,000 0 0 0 Total EXPENSES $223,730,600 0 0 0 0 0 0 0 0 0 0 Net Income Before Taxes Income Tax Expense $16,309,400 $4,072,350 NET INCOME (5.1%) $12,237,050 0 0 0 0 0 2019 Budget 176 Jan 160 Feb 168 Mar 176 Apr 184 May 160 Jun 176 Jul 176 Aug 160 Sep 184 Oct 160 Nov 168 Dec Total 0 0 0 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 g a 0 0 0 0 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 0 0 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4,072.350 4,072,350 0 0 0 0 0 0 0 0 0 0 0 0 0 -4,072,350 4,072.350 Services Goods [Company Name] 2017 Budget Jan Ful Mar Apr May Juin Jul Aug Sep Oct Nov Dec Total INCOME Sales Product 1 Product 2 Product 3 Product Products Podus Other 0 0 O 0 0 0 Total Sales D 9 0 O g 0 D 9 o o 0 0 9 . 0 0 Cost of Goods sold fromdetalls section COGS - Product D coos - Produd 2 COGSProd. 3 0 COGS-Produd D COGS Products D CAS. Pre D Total Cost of Goods Sold D 0 0 D 0 D 0 a 0 o 0 5 0 D D 0 0 0 0 0 0 0 0 0 D D D D 0 0 0 O 9 . 0 0 D D D . 0 9 0 0 Gross Profit D a 0 0 0 0 0 0 D D a 0 D 0 D 0 D 0 0 0 0 0 0 0 0 0 O 0 0 0 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oel Det Nov Dec Total 0 0 D 0 D D 0 Non Operating Income Interlineare Bent home Cthe Total Non-Operating Income Total INCOME EXPENSES Operating Expenses Accountry and Legal Metro Depreciation Da deri free Internal Maced opens Che Suppen PER Postage Rarit Rustarch and Development Saland Wages Turen Lic Telephone Travel Us Web Hosting and Domains Cthe Total Operating Expenses Non-Recurring Expenses Fumure, Egonent and software Gints Green Other Total Non Recurring Expenses Total EXPENSES 0 U 0 0 0 0 0 0 0 0 O 9 0 0 D 9 0 0 g 0 D . 0 0 0 0 0 0 6 0 0 0 0 0 0 0 8 0 D 0 0 o D 0 D Nel income Bottes Income Tax 0 D O U NET INCOME 0 0 0 O 0 0 0 O 0 0 o O 0 COST OF GOODS - Details Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total D Product giginwriery Goods Purchase or Word Shipping Champ Labor Other Loss Ending her Cost of Good Sola Profit (L03) 0 0 0 0 0 O D D 0 0 0 0 0 0 . 0 0 0 . 0 0 D 0 Product 2 Beginning Inwertory Goods Furchador autoured Shing Charge Labor and paym) Other Landing Goods Sold Proin (LO) 0 0 0 0 . D D 0 0 a 0 0 1 . 0 0 Products . Beginnertory Goods Purchase or Manufactured Shpohn Changes Labor ages and payroll Ctre Less Ending theory Cost of Goods Sold Proth (Loss) 0 0 0 0 . D D 9 a 0 0 0 D . B 0 0 . . g a 0 0 0 D 0 D 0 D 0 Product Beginning Shes Goods Pudr Wed Shipping Charge Lator Che Less Enringar Cost of Goods Salt Prof Los) U 0 0 0 . 0 D 0 O 0 a 0 0 D 0 Penu Services Goods Maintenance and Repairs Office Supplies Payroll Expenses Pus Rent Research and Development Sales and Waga Taxes and licenses Telephone Travel Ulities Web Hosting and Domains Other Total Operating Expenses 0 0 0 0 0 0 0 O 0 0 Non-Recurring Expenses Furniture Equipment and software Gifts Given Other Tatal Non-Recurring Expenses 0 0 0 0 0 0 0 0 0 0 0 0 Total EXPENSES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Net Income before Taxes Income Tax Expense 1 NET INCOME 0 0 0 0 0 O 0 O 0 0 0 COST OF GOODS - Details - Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total O Product 1 Beginning inventory Goods Purchased or Manufactured Shipping Charges Labor (wages and payroll Other Less Ending Inventory Cost of Goods Sold Profit (Loss) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 D 0 0 0 o Product Beginning inventory Goods Purchased or Manufactured Shipping Charges Labor (wagos and payroll Other Less Ending luntary Cost of Goods Sold Profit (Loss) 0 0 O 0 O 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 Products Beginning Twentory Goods Purchased or Manufactured Shipping Charges Labor (wages and payroll Other Less Ending Inventory Cost of Goods Sold Profit (LOS) 0 0 o 0 0 0 0 o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Product 4 Beginning inventory Goods Purchased or Manufactured Shipping Charges Labor (wages and payrol Other Less Ending inventory Cost of Goods Sold Profit (Loss) O O 0 0 0 0 0 O 0 0 0 0 0 0 0 O 0 0 0 0 0 0 o 0 Products Beginning inventory Goods Purchased or Manufactured Shipping Charges Labor and pro Other Less Ending Inventory Cast of Goods Sold Profit (L03) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Products Beginning inventory Goods Purchased or Manufactured Shipping Charges Labor (wages and payroll Other Less Ending Inventory Cost of Goods Sold Profit (Loss) 0 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 0 0 O