Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Using the historical data as a guide, construct a pro forma (forecasted) profit and loss statement for the clinic's average month for all of
1. Using the historical data as a guide, construct a pro forma (forecasted) profit and loss statement for the clinic's average month for all of 2014 assuming the status quo. With no change in volume (utilization), is the clinic projected to make a profit?
Historical Financial Data TMH Urgent Care Center EXHIBIT 6.1 Monthly Averages JarFab 2014 CY 2013 Jan 2014 Feb 2014 2013 Total Number of visits Net revenue 14,522 $548,747 1,365 $55,028 1.335 $54,748 1.210 545,729 1,350 $54,888 1.230 547,037 $13,540 $13,542 18,000 18,000 3,215 538 $12,854 16,000 2,620 447 $13,544 18,000 3,215 665 843 $154,250 192,000 31,440 5,365 8,112 189 11,820 1,260 1,260 3,215 $12,952 16,286 2.705 469 700 Cases in Healthcare Finance 602 843 843 676 Salaries and wages Physician fees Malpractice insurance Travel and education General insurance Subscriptions Electricity Water Equipment rental Building lease Other operating expenses Total operating expenses 0 0 1,124 135 1,029 142 985 105 105 1,077 139 998 110 105 105 12,500 155,745 103,779 $665, 220 8,152 $58, 152 12,500 7,923 $57,966 12,979 8,648 $55,435 105 12,500 8,038 $58,059 105 12,910 8,561 $55,810 Net profit (loss) $116,473) ($ 3,124) ($ 3,218) ($ 9,706) ($ 3,173) ($ 8,773) Gross margin (%) -21.2% -5.7% -5.9% -212% -5.8% -18.7% CY current year Case 6: Tulsa Memorial Hospital 53 Number of Additional Visits per Day 1-10 11-20 21-30 0 31-40 EXHIBIT 62 TMH Urgent Care Cente Monthly Incremental Cost Data Variable costs $4.00 per visit 1.00 per visit Medical supplies Administrative supplies $5.00 per visit Total variable costs per visit Semifixed Costs Salaries and wages Physician fees $ 5,000 $ 6,000 $ 7,000 $ 8,000 12,000 12,000 12,000 16,000 $ 0 $17,000 $18,000 $19,000 $24,000 Total monthly semifixed costs Fixed Costs Marketing assistant's salary Advertising expenses $ 3,000 $ 3,000 $ 3,000 $3,000 $3,000 4,000 4,000 4,000 4,000 4,000 $ 7,000 $ 7,000 $ 7,000 $ 7,000 $ 7,000 Total monthly fixed costs
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started