For Tulsa Memorial Hospital' please complete the following for your financial analysis:

1. Using the current financial data and the segregation of costs already (variable, semi-fixed and fixed) try to determine some financial projections of what the urgent care center may generate if they do nothing or encompass some aggressive marketing initiatives and raise the volume to 10, new visits, 20 new visits or 40 new visits.

TULSA MEMORIAL HOSPITAL MARKETING INITATIVE No new volume 10 new visits daily 20 new visits daily 30 new visits daily 40 new visits daily Jan-Feb Expected 2014 658,656 162,504 216,000 38,580 CY 2013 548,747 154,250 192.000 31,440 5,365 8,112 189 11,820 1,260 1,260 155,745 103,779 7,224 10,116 12,924 1,668 1,260 150,000 96,456 Net revenue Salaries & wages Physican fees Malpractice insurance Travel and education General Insurance Subscriptions Electricity Water Equipment rental Building lease Other operating expenses INCREMENTAL COSTS Marketing assistant salary Advertising expenses New variable costs - Supplies Additional salaries Additional physician fees Total operating expenses Net profit/(loss) Gross margin % Number of visits Average daily visits Fee per visit #DIV/01 #DIV/01 #DIV/0! #DIV/01 #DIV/0! 665,220 (116,473) (0.21) 14,522 39.79 37.79 696,732 (38,076) (0.06) 16,200 44.38 40.66 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! TULSA MEMORIAL HOSPITAL MARKETING INITATIVE No new volume 10 new visits daily 20 new visits daily 30 new visits daily 40 new visits daily Jan-Feb Expected 2014 658,656 162,504 216,000 38,580 CY 2013 548,747 154,250 192.000 31,440 5,365 8,112 189 11,820 1,260 1,260 155,745 103,779 7,224 10,116 12,924 1,668 1,260 150,000 96,456 Net revenue Salaries & wages Physican fees Malpractice insurance Travel and education General Insurance Subscriptions Electricity Water Equipment rental Building lease Other operating expenses INCREMENTAL COSTS Marketing assistant salary Advertising expenses New variable costs - Supplies Additional salaries Additional physician fees Total operating expenses Net profit/(loss) Gross margin % Number of visits Average daily visits Fee per visit #DIV/01 #DIV/01 #DIV/0! #DIV/01 #DIV/0! 665,220 (116,473) (0.21) 14,522 39.79 37.79 696,732 (38,076) (0.06) 16,200 44.38 40.66 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0