1. The Exel file Accounting Professionals.xls provides the results of a survey of 27 employees in a tax division of a Fortune 100 company. Use PivotTables to find a cross tabulation of the following. Copy and Paste your results and write 1-2 sentences summarizing your findings.
   1. The number of employees of each gender who have or do not have a CPA
   2. The number of employees in each age group who have or do not have a CPA

Employee        Gender  Years of Service.       Years Undergraduate Study       Graduate Degree?        CPA?    Age Group       
1       F       17      4       N       Y       5       
2       F       6       2       N       N       2       
3       M       8       4       Y       Y       3       
4       F       8       4       Y       N       3       
5       M       16      4       Y       Y       4       
6       F       21      1       N       Y       7       
7       M       27      4       N       N       7       
8       F       7       4       Y       Y       2       
9       M       8       4       N       N       3       
10      M       23      2       N       Y       5       
11      F       9       4       Y       Y       3       
12      F       8       2       N       N       2       
13      F       8       4       Y       N       2       
14      M       26      4       N       Y       6       
15      F       9       4       N       Y       2       
16      F       9       2       N       N       2       
17      M       19      2       Y       Y       4       
18      M       5       4       N       N       4       
19      M       19      4       Y       N       7       
20      M       20      4       N       N       6       
21      F       14      4       Y       Y       4       
22      M       31      4       N       N       7       
23      F       10      0       N       N       7       
24      F       10      4       N       Y       3       
25      M       26      4       Y       Y       6       
26      M       28      4       N       N       7       
27      F       5       4       N       Y       1       
                                                        
                                                Age Group       Age Range
                                                1       21-25
                                                2       26-30
                                                3       31-35
                                                4       36-40
                                                5       41-45
                                                6       46-50
                                                7       51-55
                                                8       56-60
                                                9       over 60
                                                        

Consider the following: 1. Banks that lend money to customers,2. Consumers use credit cards for purchases,3.retired people on fixed incomes,4. college students taking out student loans

In the reading it argues that inflation redistributes income,that is not neccessarily fair or equitable Some people and companies are more vulnerable than others. Some people and companies can adjust income to combat higher prices and redistribution.

1.List the four above from least to most vulnerable.

2. In paragraphs 1-4 explain why you ranked them in this order,and how they can adjust spending and income?

3. Paragraph 5, explain why you selected the ranking you did?

Problem 4-14 Compute and Use Activity Rates to Determine the Costs of Serving Customers [LO4-2, LO4-3, LO4-4]

Gino’s Restaurant is a popular restaurant in Boston, Massachusetts. The owner of the restaurant has been trying to better understand costs at the restaurant and has hired a student intern to conduct an activity-based costing study. The intern, in consultation with the owner, identified the following major activities:

A group of diners who ask to sit at the same table is counted as a party. Some costs, such as the costs of cleaning linen, are the same whether one person is at a table or the table is full. Other costs, such as washing dishes, depend on the number of diners served.

Data concerning these activities are shown below:

Prior to the activity-based costing study, the owner knew very little about the costs of the restaurant. She knew that the total cost for the month was $313,600 and that 32,000 diners had been served. Therefore, the average cost per diner was $9.80 ($313,600 ÷ 32,000 diners = $9.80 per diner).

Required:

1. Compute the activity rates for each of the three activities.

2. According to the activity-based costing system, what is the total cost of serving each of the following parties of diners?

a. A party of four diners who order three drinks in total.

b. A party of two diners who do not order any drinks.

c. A lone diner who orders two drinks.

3. Convert the total costs you computed in part (2) above to costs per diner. In other words, what is the average cost per diner for serving each of the following parties?

a. A party of four diners who order three drinks in total.

b. A party of two diners who do not order any drinks.

c. A lone diner who orders two drinks.

Create a PivotTable to combile the following information:

1. The total revenue for each salesperson

2. For each salesperson, the total revenue by product

3. Total revenue generated by each salesperson broken down by location

Please provide excel formulas and solutions

https://drive.google.com/open?id=16kL_VoQlIsOCaioggkjnGBFR_GvCrSGM

Please comment on Alibaba current Revenue, Profit Margin, Earning ,EBITDA and Price/Earning ratio affect the profitability of the company

Case Study: Greenly Insurance Company

Greenly has worked hard over the past year and has increased their marketing efforts to reach certain “untapped” demographics. Greenly has determined that it has been able to retain its Generation Y customers, who have established their own households. Greenly’s new survey of former customers has revealed that it is losing its Baby Boomer customers who like to shop for coverage based on price. One of the reasons most often cited for leaving is the inability to obtain quotes through Greenly’s Web site.

Create your own assumptions using the information presented to evaluate Greenly’s and recommend an action plan / strategies for growth.

The city of New Orleans has 200 advertising companies, 199 of which employ designers of normal ability at a salary of $200,000 a year. The firms that employ designers of normal ability each collect $500,000 in revenue a year, which is just enough to ensure that each earns exactly a normal profit. However, the 200th company employs Janus Jacobs, an unusually talented designer. Because of Jacob's talent, this company collects $900,000 in revenue a year.

a. How much will Jacobs earn? What proportion of his annual salary will be economic rent?

b. Will the advertising company for which Jacobs works be able to earn an economic profit?

PLSSSS explain each step, so lost!

Compute the correlations for the “Hot Growth Companies” in Date 1 for each pair of variables rank, P/E ratio, and return, using the first 50 and second 50 values separately. Compare these results with those given in Example 2.4. Explain the differences.

Date 1

Example 2.4