Question: Hello, Here is a simulation question I have: 1. Construct a simulation table to simulate 28 days of the banking simulation similar to the one

Hello,

Here is a simulation question I have:

1. Construct a simulation table to simulate 28 days of the banking simulation similar to the one in class. The initial balance is $1600. Each week a withdrawal of $225 is made for living expenses, starting on day 7. A withdrawal of $50 (for additional expenses) is made from the ATM randomly, according to an inter arrival time that is given by an exponential distribution with mean of 4 days (i.e., use -4 ln( R ), where R is uniformly distributed). Determine the average balance in the account over the 28 day period. You may use RAND() values from Excel. Rounding the dates to a single decimal place should not affect the answer significantly.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!