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
Other questions on the subject: Business
Business, 22.06.2019 09:40, leomessifanboy678
As related to a company completing the purchase to pay process, is there an accounting journal entry "behind the scenes" when xyz company pays for the goods within 10 days of the invoice (gross method is used for discounts and terms are 2/10 net 30) that updates the general ledger?
Answers: 3
Business, 22.06.2019 16:10, nsheikh2407
Regarding the results of a swot analysis, organizational weaknesses are (a) internal factors that the organization may exploit for a competitive advantage (b) internal factors that the organization needs to fix in order to be competitive (c) mbo skills that should be emphasized (d) skills and capabilities that give an industry advantages problems that a specific industry needs to correct
Answers: 1
Business, 22.06.2019 17:00, PlzNoToxicBan
Cadbury has a chocolate factory in dunedin, new zealand. for easter, it makes two kinds of “easter eggs”: milk chocolate and dark chocolate. it cycles between producing milk and dark chocolate eggs. the table below provides data on these two products. demand (lbs per hour) milk: 500 dark: 200 switchover time (minutes) milk: 60 dark: 30 production rate per hour milk: 800 dark: 800 for example, it takes 30 minutes to switch production from milk to dark chocolate. demand for milk chocolate is higher (500lbs per hour versus 200 lbs per hour), but the line produces them at the same rate (when operating): 800 lbs per hour. a : suppose cadbury produces 2,334lbs milk chocolate and 1,652 lbs of dark chocolate in each cycle. what would be the maximum inventory (lbs) of milk chocolate? b : how many lbs of milk and dark chocolate should be produced with each cycle so as to satisfy demand while minimizing inventory?
Answers: 2
Business, 23.06.2019 10:20, tracyaleblanc
Which theorem states that no two species competing for the exact same resources can coexist? which theorem states that no two species competing for the exact same resources can coexist? resource partitioning principle complex community network principle dominance species principle competitive exclusion principle?
Answers: 3
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 in other subjects:
Mathematics, 10.12.2020 22:40
Health, 10.12.2020 22:40
