Hey, I'm struggling with this case study. I have attached the excel and the case study pdf which contains the data.

Bandon Medical Associates (A) Dr. Desautels has essentially two options in this case: He can 1) increase revenues or 2) reduce costs. Make some suggestions on what actions Bandon Medical Associations should take, and then calculate those recommendations/suggestions utilizing the Budget 2 and Budget 3 worksheets within this file. When doing this case, you WILL need to create some additional calculations and create additional spreadsheets outside of the provided budget template in order to compare the original budget and the new budget after your suggestions have been implemented. For example, if you suggest a 10% increase in provider productivity make calculations in order to determine the affect of that 10% productivity increase. There would be a decrease in the number of minutes per visit for each type of visit. That would decrease the variable (and subsequently the total) expense per visit. OR for example, if you choose to increase revenue by doing additional marketing then you will need to estimate and include that cost of increased marketing and then increase the number of visits. Remember that healthcare providers are "price takers" meaning that they have minimal control over their reimbursement per visit, so it doesn't make much sense to raise price per visit. Good luck! Student Name: Date: Bandon Medical Associates (A) Original Budget Enter the amounts from the case in Exhibit 1 in the appropriate cells. You ONLY need to enter into the yellow cells Initial Consultation Variable Expense Detail: Physician care: Average # minutes per visit Average wage per minute Total expenses per visit Routine Physical Intensive Visit Routine Visit 1,500 $ - $ - $ - $ - 1,400 - Extender care: Average # minutes per visit Average wage per minute Total expenses per visit $ - $ - $ - $ - Medical supplies: Average # minutes per visit Average expense per minute Total expenses per visit $ - $ - $ - $ - $ - $ - $ - $ - Total Average variable expense per visit Initial Consult Routine Physical Intensive Visit Routine Visit Total Overall Budget: - Number of visits Revenue (price) per visit Total Revenue $ - $ - $ - $ - $ - Variable expenses per visit Total variable expenses $ $ - $ $ - $ $ - $ $ - $ - Unit contribution margin $ - $ - $ - $ - Total contribution margin Total fixed expenses Allocated overhead Surplus $ - $ - $ - $ - $ - $ - Student Name: Date: Bandon Medical Associates (A) Budget Number 2 - Testing Recommendations - Insert your explanation indicating the recommendations you're testing here. Initial Consultation Routine Physical Intensive Visit Routine Visit Variable Expense Detail: Physician care: Average # minutes per visit Average wage per minute Total expenses per visit $ - $ - $ - $ - Extender care: Average # minutes per visit Average wage per minute Total expenses per visit $ - $ - $ - $ - Medical supplies: Average # minutes per visit Average expense per minute Total expenses per visit $ - $ - $ - $ - $ - $ - $ - $ - Total Average variable expense per visit Initial Consult Routine Physical Intensive Visit Routine Visit Total Overall Budget: - Number of visits Revenue (price) per visit Total Revenue $ - $ - $ - $ - $ - Variable expenses per visit Total variable expenses $ $ - $ $ - $ $ - $ $ - $ - Unit contribution margin $ - $ - $ - $ - Total contribution margin Total fixed expenses Allocated overhead Surplus $ - $ - $ - $ - $ - $ - Student Name: Date: Bandon Medical Associates (A) Budget Number 3 - Testing Recommendations - Insert your explanation indicating the recommendations you're testing here. Initial Consultation Routine Physical Intensive Visit Routine Visit Variable Expense Detail: Physician care: Average # minutes per visit Average wage per minute Total expenses per visit $ - $ - $ - $ - Extender care: Average # minutes per visit Average wage per minute Total expenses per visit $ - $ - $ - $ - Medical supplies: Average # minutes per visit Average expense per minute Total expenses per visit $ - $ - $ - $ - $ - $ - $ - $ - Total Average variable expense per visit Initial Consult Routine Physical Intensive Visit Routine Visit Total Overall Budget: - Number of visits Revenue (price) per visit Total Revenue $ - $ - $ - $ - $ - Variable expenses per visit Total variable expenses $ $ - $ $ - $ $ - $ $ - $ - Unit contribution margin $ - $ - $ - $ - Total contribution margin Total fixed expenses Allocated overhead Surplus $ - $ - $ - $ - $ - $ - Student's Name: Date: Case Title: Bandon Medical Associates Chapter.Case#: 1. Using the information contained in the case and Exhibit 1 (page 388), prepare a budget for BMA for the four visit types shown. Use the approach suggested by Dr. Desautels at the end of the case, and organized your figures so the he will find them understandable and useful. (The worksheets that I have provided you will allow you to easily test your assumptions/ recommendations. The Original Budget should be with the information that Dr. Desautels uses, and you will create two additional budgets in order to test two different recommendations.) 2. a) Assuming Dr. Desautels is unhappy with the bottom line of this budget, what options are available to change it? b) Which options seem the most feasible to implement and why? a) DoubleClick&StartTypingToInsertYourResponse b) DoubleClick&StartTypingToInsertYourResponse 3. a) What problems do you think that Dr. Desautels will encounter in attempting to implement this budget? b) What should be done about those problems? a) DoubleClick&StartTypingToInsertYourResponse b) DoubleClick&StartTypingToInsertYourResponse