Business, 24.09.2020 22:01 cjjjjjjjjjjjjj

1. A college graduate who is living in Cincinnati expects to earn an annual salary of $55,000. The Excel file Cost of Living Adjustments shows the comparative salaries in other cities and percentage adjustments for living expenses. Develop an Excel template that allows the user to enter current annual expenses (in Cincinnati) for groceries, housing, utilities, transportation, and health care and compute the corresponding expenses for any selected city and the net salary surplus for both Cincinnati and the selected city. An example of what the output should look like is provided next: Cincinnati Atlanta
Salary $55,000.00 $60,482.00
Annual Expenses Groceries $7,800.00 $8,970.00
Housing $14,400.00 $18,000.00
Utilities $3,000.00 $2,700.00
Transportation $1,020.00 $1,081.20
Healthcare $4,200.00 $4,410.00
Total $30,420.00 $35,161.20
Salary Surplus $24,580.00 $25,320.80
2. Use Pivot Tables to find the number of sales transactions by product and region, total amount of revenue by region, and total amount of revenue by region and product in the Sales Transactions database.

Answers: 3

Show answers

Another question on Business

Business, 21.06.2019 16:40

Acme published a story about paul and as a result paul sued acme for damage to his reputation, emotional distress, and punitive damages. paul won an award of $20,000 for damages, $5,500 for emotional distress, and $50,000 for punitive damages. what amount must paul include in his gross income

Answers: 1

Answer

Business, 21.06.2019 18:50

You are the manager of a firm that produces output in two plants. the demand for your firm's product is p = 20 − q, where q = q1 + q2. the marginal costs associated with producing in the two plants are mc1 = 2 and mc2 = 2q2. how much output should be produced in plant 1 in order to maximize profits?

Answers: 3

Answer

Business, 22.06.2019 05:10

1. the political environment in india has proven to be critical to company performance for both pepsico and coca-cola india. what specific aspects of the political environment have played key roles? could these effects have been anticipated prior to market entry? if not, could developments in the political arena have been handled better by each company? 2. timing of entry into the indian market brought different results for pepsico and coca-cola india. what benefits or disadvantages accrued as a result of earlier or later market entry? 3. the indian market is enormous in terms of population and geography. how have the two companies responded to the sheer scale of operations in india in terms of product policies, promotional activities, pricing policies, and distribution arrangements? 4. “global localization” (glocalization) is a policy that both companies have implemented successfully. give examples for each company from the case.

Answers: 1

Answer

Business, 22.06.2019 14:40

Which of the following statements about revision is most accurate? (a) you must compose first drafts quickly (sprint writing) and return later for editing. (b) careful writers always revise as they write. (c) revision is required for only long and complex business documents. (d) some business writers prefer to compose first drafts quickly and revise later; others prefer to revise as they go.

Answers: 3

Answer

You know the right answer?

1. A college graduate who is living in Cincinnati expects to earn an annual salary of $55,000. The E...

Questions