Question

In: Statistics and Probability

The commercial loan operation of a financial institution has a standard for processing new loan applications...

  1. The commercial loan operation of a financial institution has a standard for processing new loan applications in 24 hours. Table below shows the number of applications processed each day for the last 20 days and the number of applications that required more than 24 hours to complete. (can you please send me the excel file for this problem? Thanks) the question is Draw the chart to see if the system is in control or not? I am not exactly sure which chart I should use for this type of question. Thanks

Day

Number of Apps

Number Late

1

260

3

2

250

4

3

240

2

4

350

5

5

200

2

6

250

4

7

246

3

8

258

5

9

275

2

10

274

1

11

219

0

12

238

10

13

250

4

14

302

6

15

219

20

16

246

3

17

251

6

18

273

7

19

245

3

20

260

1

Solutions

Expert Solution

A P chart will be created in this regard:

Solution:

Now,

Or. P bar = 91/5106 = 0.0178

Or n = 5106/20 = 255 almost.

Calculations:

So, the control chart is given below:

The process is not under control as there is a point situated outside the control limit. For the process to be under control, all the p values should be within the control limits which is not in the case of this experiment...

End of the Solution...


Related Solutions

Determine the utilization and the efficiency for each of these situations: a. A loan processing operation...
Determine the utilization and the efficiency for each of these situations: a. A loan processing operation that processes an average of 4 loans per day. The operation has a design capacity of 12 loans per day and an effective capacity of 11 loans per day. (Round your answer to 1 decimal place. Omit the "%" sign in your response.) Utilization % Efficiency % b. A furnace repair team that services an average of 3 furnaces a day if the design...
An American Financial Institution has made a loan commitment of €10,000,000 to a client which is...
An American Financial Institution has made a loan commitment of €10,000,000 to a client which is likely to be taken down in 6 months. The current spot exchange rate is $1.50/€. • Is the FI exposed to a dollar depreciation or appreciation? • If the spot rate six months from today is $1.6/€, what amount of dollars is needed if the loan is taken down and the FI is not hedged? • If it decides to hedge using € futures,...
Example of a financial institution that experienced financial loss because of ambiguous language in a loan...
Example of a financial institution that experienced financial loss because of ambiguous language in a loan policy
Adam Holmes is the Processing Manager of Empire Mortgage Company, a firm that processes loan applications...
Adam Holmes is the Processing Manager of Empire Mortgage Company, a firm that processes loan applications for a number of regional builders. Home buying and therefore mortgage processing is a highly seasonal business, and requires temporary staff during busy processing periods. Holmes hires staff on a monthly basis from two different temporary staffing firms - Professional Temps (PT) and Support on Demand (SD). In June, Empire hired 14 staff members from PT and 10 from SD. PT is a more...
Adam Holmes is the Processing Manager of Empire Mortgage Company, a firm that processes loan applications...
Adam Holmes is the Processing Manager of Empire Mortgage Company, a firm that processes loan applications for a number of regional builders. Home buying and therefore mortgage processing is a highly seasonal business, and requires temporary staff during busy processing periods. Holmes hires staff on a monthly basis from two different temporary staffing firms - Professional Temps (PT) and Support on Demand (SD). In June, Empire hired 14 staff members from PT and 10 from SD. PT is a more...
3. For commercial and industrial loans, explain how the credit risk profile of the financial institution...
3. For commercial and industrial loans, explain how the credit risk profile of the financial institution changes as a result of issuing a secured loan versus an unsecured loan. Explain how syndicating a loan can reduce credit risk for a financial institution.
SCENARIO: The Duncan National Commercial Bank of The Caribbean (DNCBC) is a relatively large financial institution...
SCENARIO: The Duncan National Commercial Bank of The Caribbean (DNCBC) is a relatively large financial institution in the Caribbean region. It has assets of over US $4 billion and in 2017 it experienced a net loss for the first time in over 50 years of operations. The loss was attributed to aggressive expansion in St. Lucia, Barbados and Dominica and the Directors estimate that profitability will be achieved in the new financial year March 1 2018- April, 30, 2019.The bank...
Suppose an institution has purchased a $250,000 mortgage loan from the loan originator and wishes to...
Suppose an institution has purchased a $250,000 mortgage loan from the loan originator and wishes to create a mortgage pass-through security. In doing so, this institution will generate revenue by charging a servicing fee of 35 basis points. If the monthly mortgage payment on the loan is $1,250, how much income is passed through to the investor in the mortgage pass through each month (rounded to the nearest dollar)?
A financial institution is charging a 13 percent interest rate on a $15,000,000 loan. The bank...
A financial institution is charging a 13 percent interest rate on a $15,000,000 loan. The bank also charged $150,000 in fees to originate the loan. The bank has a cost of funds of 9 percent. The borrower has a five percent chance of default, and if default occurs, the bank expects to recover 90 percent of the principal and interest. What is the risk of the loan using the Moody's Analytics model? Briefly discuss the importance of this model.
A financial institution has brought together two firms who seek access to new debt capital for...
A financial institution has brought together two firms who seek access to new debt capital for expansions of their operations. Company AAA is concerned about rising interest rates and seeks fixed rate financing, while company BBB is prepared to take what it believes to be the attractive current variable rate which is on offer. The two firms have existing arrangements in place for sources of financing, however AAA can attract funds from the Eurodollar market at what it believes to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT