Submit the following Status Report on the Project Selected in a Word document. It will consist of a cover page and a two- to three-page report containing the following organized sections: Team Member Names: If your Instructor has assigned this project as a Team Assignment, provide the name of team members. Project Title

: Give your project a descriptive title that is indicative of your planned goals for the project . Project Description: In two to three paragraphs in your words, explain the situation and the report that you (or your team) that your team will provide. Source for the Data: Explain the source of the data that will serve as the basis of your data analysis. The data may originate from other applications and be imported into Excel. In other words, your data doesn't have to start as a worksheet. In this course, you will learn how to import data and save as an Excel Worksheet. Depending on the type of analysis (see the next bullet) your data may be a large dataset. This part is subject to alteration as you work through the analysis task Type of Analysis: Explain the type of data analysis that you will be performing. Explain the decision that your team wants to arrive at. Describe the type of charts that you will create. Again, this is subject to change as you learn about Excel and go through the exercises planned for the course. See the section titled Features of Excel to Be Utilized in Your Analysis (near the end of this document) for a list of features that we will work with in this course. By the time your team submits the project proposal, you will have been introduced to the majority of these features. Remember, the type of analysis you choose to perform is the most important part of the course project. Use as many of the Excel data analysis features as you can to show the depth of your understanding of the concepts covered in this course and the thoroughness of your analysis. Status to date: Provide a short summary of work completed to date. Also, set forth any challenges, questions, Excel technique breakthroughs and other items of significance that should be reported to your Instructor.

heres the project :

The second worksheet will contain the following information: Format all dollar amounts to currency The first worksheet must calculate the employee's gross pay and net pay. Deductions for taxes and state/federal programs. You will need to research the necessary tax and deduction values. You are responsible testing the worksheets using the data found in Heathers.xlsx. You will add the two worksheets detailed in this project to that workbook. You will provide an executive summary and oral presentation to Heather Graham. Project: Heathers Heather Graham owns a department store called Heathers. Heathers is an upscaled department store located in downtown Chicago. The store has specialty departments for women, men, children, cosmetics, cologne, linen, furniture and housewares. Heathers has a finely trained workforce. Heathers believes in rewarding its staff for hard work. Each employee is paid a regular hourly wage plus commission. The commission is only paid if the employee meets or exceeds his or her sales quota. The sales quota is based on the title of the employee and is set per hour. Sales representatives are classified as either part-time or full-time. Part-time employees are either sales assistants (PT1) or sales partners. (PT2). Fulltime representatives are either assistant managers (AM), sales consultants (S2) or sales associates (S1). Part-time representatives work up to 20 hours a week. Fulltime representatives work between 30 and 40 hours a week. There is no overtime work. Sales representatives have a say in how many hours they work per day. Sales representatives are ranked and paid according to their experience and tenure. The employee is paid commission for exceeding the required total weekly sales quota. The required total weekly sales quota is the hourly sales quota times the number of hours worked. Commission is only paid on sales amounts exceeding the required total weekly sales quota. The first worksheet will contain the calculations for determining an employee's weekly pay. The second work sheet will contain all the information that needs to be looked up. The worksheet already in the workbook contains the test data. The first worksheet will allow Heather to input the name of the employee, department, title code, hours worked and the number of sales for the time worked. This work sheet will then reference the second worksheet which will have all the information about the position. Heather wants the look up information on a different sheet for easy updating and referencing