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
Another question on Business
Business, 22.06.2019 15:40
Brandt enterprises is considering a new project that has a cost of $1,000,000, and the cfo set up the following simple decision tree to show its three most likely scenarios. the firm could arrange with its work force and suppliers to cease operations at the end of year 1 should it choose to do so, but to obtain this abandonment option, it would have to make a payment to those parties. how much is the option to abandon worth to the firm?
Answers: 1
Business, 23.06.2019 13:00
What three important pieces of information can we learn by reading a production possibilities gragh?
Answers: 2
Business, 23.06.2019 18:50
Acme foods wants to make its chips saltier, but it doesn't want to spend more than it has to on salt. a sample of consumers are asked to compare its current chip (saltiness = 100) with saltier versions and to say whether the new version is saltier. on average, sample consumers reliably say the new chip is saltier when its saltiness value is 108, but not when its saltiness value is below 108. assuming acme foods' sample consumers are representative of people in general, which of the following best represents the just noticeable difference for saltiness? a. 8% b. 108 c. 80% d. 100
Answers: 2
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
Mathematics, 20.12.2019 05:31
English, 20.12.2019 05:31
Mathematics, 20.12.2019 05:31
History, 20.12.2019 05:31
Mathematics, 20.12.2019 05:31
Chemistry, 20.12.2019 05:31
Health, 20.12.2019 05:31
