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:20

Steele bicycle manufacturing company currently produces the handlebars used in manufacturing its bicycles, which are high-quality racing bikes with limited sales. steele produces and sells only 10,000 bikes each year. due to the low volume of activity, steele is unable to obtain the economies of scale that larger producers achieve. for example, steele could buy the handlebars for $31 each: they cost $34 each to make. the following is a detailed breakdown of current production costs: after seeing these figures, steele's president remarked that it would be foolish for the company to continue to produce the handlebars at $34 each when it can buy them for $31 each. calculate the total relevant cost. do you agree with the president's conclusion?

Answers: 1

Answer

Business, 22.06.2019 05:30

The hartman family is saving $400 monthly for ronald's college education. the family anticipates they will need to contribute $20,000 towards his first year of college, which is in 4 years .which best explain s whether the family will have enough money in 4 years ?

Answers: 1

Answer

Business, 22.06.2019 11:30

Money from an allowance or job is known as .

Answers: 3

Answer

Business, 22.06.2019 16:00

Analyzing and computing accrued warranty liability and expense waymire company sells a motor that carries a 60-day unconditional warranty against product failure. from prior years' experience, waymire estimates that 2% of units sold each period will require repair at an average cost of $100 per unit. during the current period, waymire sold 69,000 units and repaired 1,000 units. (a) how much warranty expense must waymire report in its current period income statement? (b) what warranty liability related to current period sales will waymire report on its current period-end balance sheet? (hint: remember that some units were repaired in the current period.) (c) what analysis issues must we consider with respect to reported warranty liabilities?

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