Using the financial model (attached), and the Excel template provided, simulate (using Excel Solver) the effect of the proposed scenarios on this hospital’s profit.

  • Using the financial model (attached), and the Excel template provided, simulate (using Excel Solver) the effect of the proposed scenarios on this hospital’s profit.

Scenario 1: Set the max value of reduction across the revenue options at 30%

Scenario 2: Set the max value of reduction across the revenue options at 20%.

Scenario 3: Set the Shared Savings revenue at 50 (in the Baseline portion of the file).

Which one of the proposed scenarios results in the bigger profit (net) for the hospital? Does your result (answer) make sense? Please explain.

  • Develop a strategy map for a primary care dental clinic. Using your own professional and academic research, determine five challenges facing primary care dentistry, and develop a strategy map that this clinic should use to increase their market share in the field. Make sure that the strategy map includes eight initiatives and that they touch the four perspectives. Also, include targets for each initiative, and make sure that the metrics for these targets are a mix of leading and lagging indicators.

Beside the strategy map, you should also submit a document (or additional slides in the PowerPoint document with the strategy map) where you address how the challenges found influence the field of primary care dentistry. You should also discuss how the initiatives proposed relate to the challenges presented, and how could they contribute to the desired increase in market share.  

A template for the strategy map is posted on Blackboard. You can definitely use the template to develop your strategy map.