What is probability that account will have insufficient fund

Assignment Help Simulation in MATLAB
Reference no: EM13860148

I need to know how to solve the question on the tab marked solve. I am using an excel addin called risk solver.

Hungry Dawg Restaurants

Intial condition

Assumptions



Number of covered employees 18,533 Max Decrease 3% Max increase 7% Uniform
Average Claims per employee  $  250.00 Monthly increase 1% Std Dev  $       3.00 Normal
Amount contributed per employee  $  125.00 Constant



Refer to the Hungry Dawg Restaurant example presented in this chapter. Health claim costs actually tend to be seasonal, with higher levels of claims occurring during the summer months (when kids are out of school and more likely to injure themselves) and during December (when people schedule elective procedures before the next year's deductible must be paid). The following table summarizes the seasonal adjustment factors that apply to RNGs for average claims in the Hungry Dawg problem. For instance, the average claim for month 6 should be multiplied by 115%, and claims for month 1 should be multiplied by 80%.

Month 1 2 3 4 5 6 7 8 9 10 11 12
Seasonal Factor 0.80 0.85 0.87 0.92 0.93 1.15 1.20 1.18 1.03 0.95 0.98 1.14

Suppose the company maintains an account from which it pays health insurance claims. Assume there is $2.5 million in the account at the beginning of month 1. Each month, employee contributions are deposited into this account and claims are paid from the account.

a. Modify the spreadsheet to include the cash flows in this account. If the company deposits $3 million in this account every month, what is the probability that the account will have insufficient funds to pay claims at some point during the year? (Hint: You can use the COUNTIF( ) function to count the number of months in a year in which the ending balance in the account is below 0.)

b. If the company wants to deposit an equal amount of money in this account each month, what should this amount be if the company wants there to only be a 5% chance of having insufficient funds?

Reference no: EM13860148

Questions Cloud

Difference between push and pull promotion strategies : How does Integrated Marketing Communications techniques add value for customers? What is the difference between push and pull promotion strategies
What situations serve as a foundation for the development : What situations serve as a foundation for the development of Stockholm syndrome?
Develop a relay logic diagram : You are an electrical engineer for Packaging, Inc. Your boss has assigned you a project to program a pick and place system using a robot to remove cases from a conveyor to a pallet. provide a narrative description of how your system will work.
How could these types of behaviors be presented in future : How could these types of behaviors be presented in the future? Provide your rationale for what, if anything might have been done differently in this case
What is probability that account will have insufficient fund : What is the probability that the account will have insufficient funds to pay claims at some point during the year - what should this amount be if the company wants there to only be a 5% chance of having insufficient funds?
What changes in sales management program would you recommend : What changes in the sales management program would you recommend to eric johnson to improve the implementation of the system.
Develop the plan that will ensure a successful market entry : Develop the plan that will ensure a successful market entry. Address the social responsibility and ethical considerations relating to the product and market you are planning on entering.
Performance management programs : The legal aspects associated with performance management programs and the process of performance appraisals can range from one state to another and across international boundaries.
Why does kininogen bind to glycosaminoglycans easily : kininogen which is a lysine-rich protein . Like HRGP , it is able to bind to glycosaminoglycans and antimicrobial, but this binding is far less sensitive to small fluctuations id physiological pH. Q1 , Why does kininogen bind to glycosaminoglycans e..

Reviews

Write a Review

 

Simulation in MATLAB Questions & Answers

  Plot the original periodic square wave

Plot the original periodic square wave on the same graph. Comment on the difference between the original periodic square wave and its truncated Fourier series presentation.

  Write and implement a matlab program to apply 3 x 3 mask

Write and implement a matlab program to apply 3 x 3 mask

  Simulate 16-qam system without grey coding

Simulate and compare the BER of a 16-PSK system and a 16-QAM system without Grey coding and Eb/N0=0,2,4,6,8,10 dB. "

  Simulate using beam propagation method

Simulate using BPM (Beam propagation method) the following wave guid?

  Effect on the ber of changing the way

Using M-PSK and QAM modulations with M>2, investigate the effect on the BER of changing the way in which the various bit combinations are mapped to the constellation points. Both binary and Gray mapping are available in the modulation dialogue box..

  How dc motors are physically constructed

How DC motors are physically constructed. How to test DC motors to assess performance. How to use Excel and MATLAB.

  Build a matlab based graphical user interface

Build a Matlab based graphical user interface (GUI) that operates in conjunction with a base Matlab/ Simulink simulation program. Any base simulation is considered acceptable.

  Calculate the mid-point of the hermite curve

Calculate the mid-point of the Hermite curve that fits the points and the tangent vectors

  Solve the linear system

Compute the rank of S manually and use the MATLAB function to verify the result - Solve the linear system of equations Ax = b using MATLAB.

  Build a simulation using newtons laws of motion

Build a new and different simulation of your own using Newtons laws of motion and Show the code and describe how it works

  Design the automatic control section using statecharts

Aim of this project is to design an embedded system which can move loads from one place to another. The system can be operated manually, automatically and wirelessly.

  Develop and simulate in matlab model

Develop and simulate in matlab model of trash to steamp lant in Baltimore

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd