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 20:00

Which of the following is a competitive benefit experienced by the first mover firm in an industry? a. the first mover will be able to achieve a less steep learning curve. b. the first mover will be able to reduce the switching costs. c. the first mover will not have to patent its products or technology. d. the first mover will be able to reduce costs through economies of scale.

Answers: 3

Answer

Business, 22.06.2019 20:40

Which of the following is true concerning the 5/5 lapse rule? a) the 5/5 lapse rule deems that a taxable gift has been made where a power to withdraw in excess of $5,000 or five percent of the trust assets is lapsed by the powerholder. b) the 5/5 lapse rule only comes into play with a single beneficiary trust. c) amounts that lapse under the 5/5 lapse rule qualify for the annual exclusion. d) gifts over the 5/5 lapse rule do not have to be disclosed on a gift tax return.

Answers: 1

Answer

Business, 22.06.2019 21:00

There is just one person in our group, silvia, who seems to have radically different ideas about how to complete our project. she seems to purposely disagree with the majority opinions of the rest of us though yesterday she said something that made a lot of sense to us solve our production problem. i suggested to the entire group today that we hear silvia’s suggestions and asked silvia to share in-depth more of what she said yesterday. i am using which adaptive leader behavior?

Answers: 2

Answer

Business, 22.06.2019 22:30

Schuepfer inc. bases its selling and administrative expense budget on budgeted unit sales. the sales budget shows 1,800 units are planned to be sold in march. the variable selling and administrative expense is $4.30 per unit. the budgeted fixed selling and administrative expense is $35,620 per month, which includes depreciation of $2,700 per month. the remainder of the fixed selling and administrative expense represents current cash flows. the cash disbursements for selling and administrative expenses on the march selling and administrative expense budget should be:

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