Review “Simulation Case Study: Phoenix Boutique Hotel Group” for this topic’s case study, in which you provide guidance to Phoenix Boutique Hotel Group (PBHG) founder Bree Bristowe.1. Creat a simulation model. Use an Excel spreadsheet file for the calculations and explanations. Cells should contain the formulas (i.e., if a formula was used to calculate the entry in that cell). Students are highly encouraged to use the “Simulation Case Study: Phoenix Boutique Hotel Group Template” Excel resource to complete this assignment.2. Prepare a 650-word recommendation for Bristowe’s best course of action. Explain your model and the rationale for your recommendations. Prepare the assignment according to the guidelines found in the APA Style Guide.