![subject](/tpl/images/cats/ekonomika.png)
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.
![ansver](/tpl/images/cats/User.png)
Answers: 3
![](/tpl/images/ask_question.png)
![](/tpl/images/ask_question_mob.png)
Other questions on the subject: Business
![image](/tpl/images/cats/ekonomika.png)
Business, 21.06.2019 19:40, heroicblad
Sean has placed a job ad and is now interviewing potential employees. which of the following questions is he legally allowed to ask during the interview? do you have any disabilities that will require special accommodation? how many children do you have? where did you earn your degree and how has it prepared you for this position? is this your maiden name that you have listed on the job application?
Answers: 2
![image](/tpl/images/cats/ekonomika.png)
![image](/tpl/images/cats/ekonomika.png)
Business, 22.06.2019 07:10, firdausmohammed80
mark, a civil engineer, entered into a contract with david. as per the contract, mark agreed to design and build a house for david for a specified fee. mark provided david with an estimation of the total cost and the contract was mutually agreed upon. however, during construction, when mark increased the price due to a miscalculation on his part, david refused to pay the amount. this scenario is an example of a mistake.
Answers: 1
![image](/tpl/images/cats/ekonomika.png)
Business, 22.06.2019 11:10, addsd
Sam and diane are completing their federal income taxes for the year and have identified the amounts listed here. how much can they rightfully deduct? • agi: $80,000 • medical and dental expenses: $9,000 • state income taxes: $3,500 • mortgage interest: $9,500 • charitable contributions: $1,000.
Answers: 1
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 in other subjects:
![Konu](/tpl/images/cats/fr.png)
![Konu](/tpl/images/cats/informatica.png)
Computers and Technology, 25.05.2021 04:10
![Konu](/tpl/images/cats/biologiya.png)
Biology, 25.05.2021 04:10
![Konu](/tpl/images/cats/biologiya.png)
Biology, 25.05.2021 04:10
![Konu](/tpl/images/cats/mat.png)
Mathematics, 25.05.2021 04:10
![Konu](/tpl/images/cats/en.png)
![Konu](/tpl/images/cats/mat.png)
![Konu](/tpl/images/cats/mat.png)
![Konu](/tpl/images/cats/istoriya.png)
![Konu](/tpl/images/cats/en.png)
English, 25.05.2021 04:10