Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I would like some assistance with the following quantitative methods question Details of Project BellyFull is a large and growing chain of restaurants that specialises

I would like some assistance with the following quantitative methods question

image text in transcribed
Details of Project 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 24 W N 16 Leann 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 be approximated by a normal distribution, with a standard deviation of $3. Required Using 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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Capitalist Political Economy Thinkers And Theories

Authors: Heather Whiteside

1st Edition

0429888031, 9780429888038

More Books

Students also viewed these Economics questions

Question

3. What are the three main financial needs of a business?

Answered: 1 week ago

Question

8. How can an interpreter influence the message?

Answered: 1 week ago

Question

Subjective norms, i.e. the norms of the target group

Answered: 1 week ago