$\backslash$table$[[,],[$ent revenue,lupaticnd days $\backslash$times expenses per inparicen day$],[$gescy revemue,Emergescy visiss x expenses per visit$],[$atient revenue,Outpaticat visits x expelises per visit$],[$menenue$,\backslash$pi of beds $^(**)$ cost per bed $**$ on of hospocals$],[$mevenue$,\backslash$table$[[$Sum of inpacicen revesoxes, emergency$],[$revenues$,$ outpatient revenues bed revenue$]]],[$ksoms$,\backslash$table$[[$Five peroent of toal revenue$]]],[$revesos$,],[,],[$ies$,15000+1\mathrm{.}50\backslash$times $+-$ of beds x~~$\backslash$pi of hospitals$],[$uts$,25$ percent of salaines$],[200+8$ percent of toal revenue$],[2150$ per $1,000$ papulacion$],[$ccation$,\backslash$table$[[1200$ per $1,0001$ population$]]],[$Expenses$,$Allof of Se above$],[,],[,$Net Revesox less Total Expenses$]]$

TABLEEII

Simulated data foun different states

$\backslash$table$[[,,,,,],[$#i of hiospicals,$414,370,2107,203,\backslash$sqrt$163],[\backslash$table$[[\backslash$pi of beds per $1,000],[$population per$],[$bocepital$]],2\mathrm{.}6,(2\mathrm{.}1)/(2\mathrm{.}1),3\mathrm{.}4,3\mathrm{.}1,30],[$Cost per bed,$580,595,576,572,505],[\backslash$table$[[\backslash$pi of mpaticnt days$],[$per $1,000$ population$]],6012,531,961,704,556],[\backslash$table$[[$Expenses per$],[$inpaticnt dry$]],$$$1,482,51,763,$$$1,402,$$$1,387,$$$400],[\backslash$table$[[\backslash$pi of outpaticnt Visits$],[$per $1-000$ populacion$]],1,541,1,524,2,444,1,347,950],[\backslash$table$[[$Fxpenses per$],[$ourpaticnt visit$]],$$$115,5126,$$$112,5109,\backslash$bar $($SI$00)],[\backslash$table$[[$#of emergency$],[$moun visits per $1\mathrm{.}000],[$poculation$]],379,397,391,289,349],[\backslash$table$[[$Expenses per$],[$emergency room$],[$visit$]],52,0000,53,000,51,950,,$$$500]]$

To Do:

Use Excel to develop the inter$-$state bealtheare profit amalysis DSS uxing the data ard the formulas gives above.

$2$ Develop an altemative plan by varying the number of bock, and various expenses to let Ohio have a net income of at lesst $$700,000.$

Alterascive Profit Plass for Okio

$\backslash$table$[[\backslash$table$[[$Ohio$]],,$Alterancive $,$Alterascive $2],[$Net Incouse,,$],[\backslash$pi of beds per,,$],[,,],[\backslash$table$[[$population per$],[$bocopital$]],,],[$Costper bed,,$],[,\backslash$table$[[$Fof erpaticnt$],[$days per $1,000]],,],[,$population,,$],[,\backslash$table$[[$Expenses per$],[$incatient dyy$]],,],[,$o of outputicnt,,$],[,\backslash$table$[[$visits per $1,000]],,],[,,,],[,\backslash$table$[[$ourpatient visit$]],,],[,$xof,,$],[,$emergency,,$],[,$room vaits per,,$],[,$poculation,,$],[,$Expenses per,,$],[,$room vait,,$]]$