BellyFull is a large and growing chain of restaurants that specialises in traditional Caribbean foods. The restaurant has its main office in Bronx NY. The company has become large enough that it no longer buys insurance from private insurance company. BellyFull has grown to be self-insured, paying health insurance claims with its own money. Some of the administrative details are outsourced, so that it can focus on the core strategic and operational issues of the company. The money the company uses to pay claims comes from two sources: (1) employees' contributions - premiums deducted from employees' monthly salary and (2) company funds - the company's contribution. The company's contribution is equal to the amount not covered by the employees' contributions. Each employee covered by the health plan contributes $120 per month. However, the number of employees covered by the plan changes from month to month as employees are hired and fired, quit, or simply add or drop health insurance coverage. A total of 14,500 employees were covered by the plan last month. The company records show that the average monthly health claim per covered employee last month was $240. Company's record also shows that (i) the number of months that shows an increase of 1%%, 2% or 3% increase in that number of employees (monthly) (see Table 1); (ii) the average monthly claim per employee increased by 1% and (iii) monthly contribution per employee was held constant Table 1-Months of % Increase of Employees % Increase of Employees (1) Number of Months 20 2 24 3 16Learn has been hired as an analyst in the corporate planning department of Belly-Full Restaurant. Her first assignment is to determine how much money the company needs to accrue in the coming year to pay for its employees' health insurance claims. Scenarios Leann is considering the following scenarios in determining BellyFull's yearly and average monthly contribution to the health coverage of its employees: A. Develop a basic model that covers the information given B. Not convinced that the basic model is realistic, develop a model with the following assumptions (i) number of covered employees can decrease by a maximum of 2% and increase by a maximum of 4%; (ii) in addition to the $230 average claim and the 1%% average monthly increase in claim per employee, the monthly claim can he ann simated by a normal distribution. with a standard deviation of $3Using the information provided do the following: 1. Develop the basic simulation model referenced in scenario (A) (3 Marks) 2. Develop the simulation model referenced in scenario (B) (4 Marks) 3. Conduct 500 replications of the model for scenario (B), using the metric total company cost over 12 months. (2 Marks) 4. From the replications done in (3), calculate the company's (i) average monthly cost, (ii) maximum monthly cost and (iii) minimum monthly cost (2 Marks) 5. From the model developed under scenario (B), conduct sensitivity analysis of standard deviation of monthly claim from $2 to $5 in increment of $1. (3 Marks) 6. From the sensitivity analysis done in (5), create the scenario where the standard deviation that gives the highest average monthly cost is highlighted. No of the other standard deviations should be highlighted. (1 Mark) 7. BONUS: Based on the 500 replications from (3), calculate AND interpret a 95%% Confident Interval for BellyFull's average monthly cost. (2 Marks)