Analyanze profitability of the credit card product

Assignment Help Engineering Mathematics

Reference no: EM131439777

Question: J&G Bank receives a large number of credit-card applications each month, an average of 30,000 with a standard deviation of 4,000, normally distributed. Approximately 60% of them are approved, but this typically varies between 50% and 70%. Each customer charges a total of $2,000, normally distributed, with a standard deviation of $250, to his or her credit card each month. Approximately 85% pay off their balances in full, and the remaining incur finance charges. The average finance charge has recently varied from 3% to 4% per month. The bank also receives income from fees charged for late payments and annual fees associated with the credit cards. This is a percentage of total monthly charges and has varied between 6.8% and 7.2%. It costs the bank $20 per application, whether it is approved or not. The monthly maintenance cost for credit-card customers is normally distributed with a mean of $10 and standard deviation of $1.50. Finally, losses due to charge-offs of customers' accounts range between 4.6% and 5.4% of total charges.

a. Using average values for all uncertain inputs, develop a spreadsheet model to calculate the bank's total monthly profit.

b. Use Monte Carlo simulation to analyze the profitability of the credit card product. Use any of the Analytic Solver Platform tools as appropriate to fully analyze your results and provide a complete and useful report to the manager of the credit card division.

Reference no: EM131439777

Questions Cloud

Components of the change in consumer surplus : In your explanation please interpret the components of the change in consumer surplus, producer surplus and total welfare. In other words what do these parts represent?

What is the unit contribution for brand x : MGMT 880 - Strategic Marketing Assignment: Marketing Arithmetic Problems. What is the unit contribution for Brand X? (Check your calculation -- this is a critical step that if wrong will cause all subsequent calculations to also be wrong) If the r..

Determine and draw the thevenin equivalent circuit : Using Superposition, determine the voltage drop across R2 of the circuit below. Determine and draw the Thevenin Equivalent Circuit for the circuit below.

Develop a simulation model to find the net present value : Waring Solar Systems provides solar panels and other energy-efficient technologies for buildings. In response to a customer inquiry, the company is conducting a feasibility study to determine if solar panels will provide enough energy to pay for t..

Analyanze profitability of the credit card product : J&G Bank receives a large number of credit-card applications each month, an average of 30,000 with a standard deviation of 4,000, normally distributed. Approximately 60% of them are approved, but this typically varies between 50% and 70%.

Feedstock-feed production : An animal feedstock is to be prepared using the residual seedcake from two oilseeds after the oil has been extracted. Oilcake-1 contains 30% protein and 70% carbohydrate and oilcake-2 contains 65% protein and 35% carbohydrate. Draw a block diagram of..

Gasoline impact the effectiveness of taxes : How does the price elasticity of demand for gasoline impact the effectiveness of taxes on gasoline aimed at correcting a negative externality?

What would the three-sigma lower control limit be : A company randomly selects 100 light bulbs every day for 40 days from its production process. If 600 defective light bulbs are found in the sampled bulbs, what would the 3-sigma lower control limit be? Show all work.

Calculate a confidence interval in spss : You will calculate a confidence interval in SPSS. Choose an appropriate variable from Weeks 2 and 3 and calculate a confidence interval in SPSS. (use: SEXUAL ORIENTATION and Hours spent on math homework/studying in typical school week all found in..

User Account

All Pages