please answer the following question using the date given.

You are interviewing for a new position as an administrator for a Brooklyn-based community based healthcare clinic. You are given the following scenario to complete as part of the job interview process competitive position, so you must show your prospective employer that you have the analytical and excel skills to be selected for this position. Assume that all costs are fixed, except administrative and medical supply costs, which are variable. Furthermore, assume that the clinic must pay taxes at a 30 percent rate. a. Construct the clinic's projected P&L statement. b. What number of visits is required to break even? c. What number of visits is required to provide you with profit of $100,500? d. Now assume the Clinic contracts with one HMO, which proposes as 25% discount from charges on 35% of its patients. Comparing BOTH accepting AND rejecting the contract, what would you advise your prospective employer? YOU HAVE BEEN ASKED TO SHOW PROFIT AND LOSS STATEMENTS FOR BOTH SCENARIOS, INCLUDING CONTRIBUTION MARGINS! The clinic's financial projections and assumptions for the first year of operations are as follows: Revenues (12,500 visits) $525,000 Wages and benefits $225,000 Rent $6,000 Depreciation $30,000 Utilities $2,500 Medical supplies $52,000 Administrative supplies $12,000 Number of visits 12,500 Per visit Revenue $42.00