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, 22.06.2019 18:00

Biochemical corp. requires $600,000 in financing over the next three years. the firm can borrow the funds for three years at 10.80 percent interest per year. the ceo decides to do a forecast and predicts that if she utilizes short-term financing instead, she will pay 7.50 percent interest in the first year, 12.15 percent interest in the second year, and 8.25 percent interest in the third year. assume interest is paid in full at the end of each year. a)determine the total interest cost under each plan. a) long term fixed rate: b) short term fixed rate: b) which plan is less costly? a) long term fixed rate plan b) short term variable rate plan

Answers: 2

Answer

Business, 22.06.2019 22:00

In 2018, laureen is currently single. she paid $2,800 of qualified tuition and related expenses for each of her twin daughters sheri and meri to attend state university as freshmen ($2,800 each for a total of $5,600). sheri and meri qualify as laureen’s dependents. laureen also paid $1,900 for her son ryan’s (also laureen’s dependent) tuition and related expenses to attend his junior year at state university. finally, laureen paid $1,200 for herself to attend seminars at a community college to her improve her job skills.what is the maximum amount of education credits laureen can claim for these expenditures in each of the following alternative scenarios? a. laureen's agi is $45,000.b. laureen’s agi is $95,000.c. laureen’s agi is $45,000 and laureen paid $12,000 (not $1,900) for ryan to attend graduate school (i.e, his fifth year, not his junior year).

Answers: 2

Answer

Business, 22.06.2019 23:00

Which of the following represents an unlimited queue? a. toll booth serving automobiles on the interstateb. drive through lane at a fast food restaurantc. faculty office with limited seating during office hoursd. restaurant with no outside seating and limited capacity due to fire departments restrictionse. small barbershop with only 5 chairs for waiting customers

Answers: 3

Answer

Business, 22.06.2019 23:30

Sally has a high-paying management position with a fortune 500 company, but she is tired of working for corporate america. so sally has decided to start a business, and she knows she will be successful as an entrepreneur because entrepreneurs typically

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