Bandon Medical Associates Case A

Assignment 1. Using the information contained in the case and Exhibit 1, prepare a budget for BMA for the four visit types shown. Use the approach suggested by Dr. King at the end of the case, and organize your figures so that she will find them understandable and useful.* Assuming Dr. King is unhappy with the bottom line" of this budget, what options are available to change it? Which options seem the most feasible to implement? 3. What problems do you think Dr. King will encounter in attempting to implement this budget? What should be done about those problems? Try to set up a spreadsheet to calculate the budget. Make it as formula-driven as possible. This will allow you to easily test assumptions in answering Question 2. * BANDON MEDICAL ASSOCIATES (A) Exhibit 1. Budget Data Expected Expected Expected Expected Expected Physician Extender Medical Number Revenue Time Time Supplies of visits per visit per visit (1) per visit (2) per visit (3) Type of Visit Initial consultation Routine physical Intensive visit Routine visit 3,000 4,000 6,000 6,000 $150 $110 $80 $60 60 45 20 10 15 10 10 15 3 2 2 Notes: 1. In minutes at $1.35 per minute. 2. In minutes at $0.90 per minute. 3. In units at $4.00 per unit