Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Total Costs of Physician Visits 77322 79177 74888 73428 74535 75487 74222

Hi, can you please help me solve this problem for this case? The question is as follows: Using the six months of data provided in the Excel file, simulate the profitability of the physician services department if copayments are increased to $20 per visit. Repeat your analysis using a copayment of $25 per visit. 

The excel file is attached.

Thank you,

Danielle