Business, 25.02.2020 22:52 helo55

The People’s Choice Bank is a small community bank that has three local branches, in Blue Ash, Delhi, and Anderson Hills. The Excel file Peoples Choice Bank is a database of major account transactions for the month of August.

1. Note that it is difficult to determine whether each trans-action in the Amount column represents a positive cash inflow or a negative cash outflow without information in other columns. Modify the database as appropriate to more easily analyze the data.

2. Suppose that you have been asked to prepare a summary of these transactions that would be clear and meaningful to the bank’s president. Use PivotTables (that are well-designed and properly formatted) to provide a summary of the key information that the president and his direct reports would want to know. Justify and explain your reasoning.

Below is the file. please show how you came about the answer.

Date Day of Week Account Type Amount Customer Branch
1-Aug Friday Savings New Account 3000 New Anderson Hills
1-Aug Friday Checking New Account 380 New Blue Ash
1-Aug Friday Checking New Account 3070 New Anderson Hills
1-Aug Friday Checking New Account 3560 New Blue Ash
1-Aug Friday Checking New Account 620 New Anderson Hills

Answers: 3

Show answers

Another question on Business

Business, 21.06.2019 22:30

True or false: banks are required to make electronically deposited funds available on the same day of the deposit

Answers: 2

Answer

Business, 22.06.2019 05:50

Match each of the terms below with an example that fits the term. a. fungibility the production of gasoline b. inelasticity the switch from coffee to tea c. non-excludability the provision of national defense d. substitution the demand for cigarettes

Answers: 2

Answer

Business, 22.06.2019 22:30

Schuepfer inc. bases its selling and administrative expense budget on budgeted unit sales. the sales budget shows 1,800 units are planned to be sold in march. the variable selling and administrative expense is $4.30 per unit. the budgeted fixed selling and administrative expense is $35,620 per month, which includes depreciation of $2,700 per month. the remainder of the fixed selling and administrative expense represents current cash flows. the cash disbursements for selling and administrative expenses on the march selling and administrative expense budget should be:

Answers: 1

Answer

Business, 23.06.2019 11:40

Anewspaper story on the effect of higher milk prices on the market for ice cream contained the following: "as a result [of the increase in milk prices], retail prices for ice cream are up 4 percent from last year. . and ice cream consumption is down 3 percent." source: john curran, "ice cream, they scream: milk fat costs drive up ice cream prices," associated press, july 23, 2001. based on the information given, what is the price elasticity of demand for ice cream?

Answers: 1

Answer

You know the right answer?

The People’s Choice Bank is a small community bank that has three local branches, in Blue Ash, Delhi...

Questions