Question: *******i need answers, not explain, please: 1. Project background 2. Table of contents 3. projects the main finding 4. Charts . Include two charts that

*******i need answers, not explain, please:

1. Project background

2. Table of contents

3. projects the main finding

4. Charts. Include two charts that depict your main findings or your data.

5. Recommendation.

hers the project:

Answers all the above please 5 pages ;

*******i need answers, not explain, please:1. Project background2. Table of contents3. projects

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). Full- time representatives are either assistant managers (AM), sales consultants ($2) or sales associates ($1). Part-time representatives work up to 20 hours a week. Full- time 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. The second worksheet will contain the following information: Title Code Description Hourly Rate Hourly Sales Commission Quota Rate AM Assistant Manager 20.00 200 .03 PTI Sales Assistant 8.50 100 .OIS PT2 Sales Partner 9.00 150 .010 $1 Sales Associate 10.50 175 .02 $2 Sales Consultant 12,00 200 .025 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.xIsx. 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. Employee Name Title Code Hours Worked Sales 2 Sarah Roberts AM 40 12310.96 3 Tom Jones $1 35 13384.25 4 Sally Ride $2 30 3043.86 5 William Mathers AM 35 7562.75 6 Robert Mulch PT1 27 8092.2 7 Samuel Mccloud AM 40 7768.39 8 Gunga Din PT1 20 464.09 9 Cruel DeVille PT2 11 1157.17 10 Tom Barber PT2 20 3018.91 11 Gary Grauer AM 37 848.69 12 Robert Plant $2 40 999.25 13 Terry Pons $1 32 3582.11 14 Mark Spitzer PT2 20 5032.19 15 Sarge Stulz AM 38 4914.22 16 Timothy Yanez 33 4440.95 17 Earl Smith AM 34 8131,72 18 James Jones PT2 16 1870.61 19 Jack Black $1 39 5193.25 20 Brutus White PT1 8 422.94 21 Thomas Engine PT2 10 1683.1 22 Anthony Wright AM 31 4735.46 23

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!