What was the state income tax paid by quarter by state

Assignment Help Accounting Basics

Reference no: EM131911279

Assignment

1. How many total employees did Smart-Buy have in 2015?

2. How many employees did Smart-Buy have in each of the states that it operated in 2015?

3. How many employees did Smart-Buy have in each department in 2015?

4. How many employees does Smart-Buy have by company (e.g. Largemart and Bullseye)?

5. Which department had the most employees? How many employees did that department have by company?

6. Which departments were unique to Largemart and Bullseye? (Meaning a department exists in one company, but not in the other.) Hint: Simple query taken over to excel to analyze in a pivot table will find this or use a subquery with a NOT IN argument.

7. What was the average salary by department in the 4/15/2015 period?

8. How many employees in Oklahoma and California made over $125,000 in 2015?

9. Which department had the highest gross payroll in 2015? What % of the gross payroll did it represent?

10. How much federal income tax did Smart-Buy pay on behalf of its employees?

11. What was the state income tax paid by quarter by state?

12. Which departments in which states had the highest payroll (gross_pay) costs? List only the top 10.

13. Where should Smart-Buy's new headquarters be and why should it be located there? Prepare a geographic heat map to support your solution for extra credit.

14. Bonus Question: Is the social security tax calculated correctly for employees? If not, how many employees was the security tax incorrectly calculated? Hint: research what the social security cap is.

15. Write your own query answering a question with the data. Find your own insight into the data.

Prepare a report that answers all of these questions including visualizations. Also include a Process Memo that details the technical details of how you arrived at your solutions.

Reference no: EM131911279

Questions Cloud

What might be the consequences for smaller companies : What might be the consequences for smaller companies of not complying with corporate governance principles?

Prepare manual accounting system using the journals : Find the source documents of Castle & Co Accounting. You are required to enter these source documents into their manual accounting system using the journals

Create necessary journal entrys to account for transaction : On March 1, 2012 Management of Taint Incorporated approved. Create the necessary journal entry(s) to account for the transaction.

Develop an it strategic plan for the organization : Why is it important to have the senior leadership/management of an organization involved in the IT governance process?

What was the state income tax paid by quarter by state : How much federal income tax did Smart-Buy pay on behalf of its employees? What was the state income tax paid by quarter by state?

Analyzes two retailers business models and strategies : Explain the role that information technology plays in each of these businesses and describe the role of the various IT professionals involved in this case.

Increasing the risk of acquiring the disease : Despite breast cancer being frequently linked to genetics, several studies have identified that factors like hormones, lifestyles and environment contribute

Evaluate the success of vodafones implementation plan : Analyze and discuss the central issue(s) faced by Vodafone, including the contributing management and technological factors.

Crowdfunding trend in business : Briefly discuss how this is true with crowdfunding trend in business and how in your prospective this trend is here to stay?

User Account

All Pages