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 15:30

Walter wants to deposit $1,500 into a certificate of deposit at the end of each ofthe next 6 years. the deposits will earn 5 percent compound annual interest. ifwalter follows through with his plan, approximately how much will be in his accountimmediately after the sixth deposit is made?

Answers: 1

Answer

Business, 22.06.2019 09:40

The relationship requirement for qualifying relative requires the potential qualifying relative to have a family relationship with the taxpayer. t or fwhich of the following is not a from agi deduction? a.standard deductionb.itemized deductionc.personal exemptiond.none of these. all of these are from agi deductions

Answers: 3

Answer

Business, 22.06.2019 09:40

Salt corporation's contribution margin ratio is 78% and its fixed monthly expenses are $30,000. assume that the company's sales for may are expected to be $89,000. required: estimate the company's net operating income for may, assuming that the fixed monthly expenses do not change.

Answers: 1

Answer

Business, 22.06.2019 10:10

Ursus, inc., is considering a project that would have a five-year life and would require a $1,650,000 investment in equipment. at the end of five years, the project would terminate and the equipment would have no salvage value. the project would provide net operating income each year as follows (ignore income taxes.):

Answers: 1

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