rogers_logan_hw3

rogers_logan_hw3 - Rolling Thunder Wheelchair Sales...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Rolling Thunder Wheelchair Sales Projection for 5 years Chair Type Racer 8,000 Rugged Terrain Basketball Football Sales Differences Racer 0.00% Rugged Terrain 2.50% Basketball 3.00% Football 4.25% Number of Years Between Sales 1 Average yearly sale diff. Year % Change 2008 0.00% 2009 9.00% 2010 8.25% 2011 7.50% 2012 6.50% Year 2008 Sales 2009 Sales 2010 Sales 2011 Sales 2012 Sales Racer $8,000.00 $8,720.00 $9,439.40 $10,147.36 $10,806.93 Rugged $8,200.00 $8,938.00 $9,675.39 $10,401.04 $11,077.11 Basketball $8,240.00 $8,981.60 $9,722.58 $10,451.78 $11,131.14 Football $8,340.00 $9,090.60 $9,840.57 $10,578.62 $11,266.23 Total Yearly Sales $32,780.00 $35,730.20 $38,677.94 $41,578.79 $44,281.41 Avgerage Yearly Sales $8,195.00 $8,932.55 $9,669.49 $10,394.70 $11,070.35
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
5 Year Total $193,048.34
Background image of page 2
Halcyon Homes Monthly Payroll Month's End 01/31/07 Number of Days in Year 365 02/28/07 Min Number of Years 3 03/31/07 Base Salary 3+ years $5,000.00 04/30/07 Base Salary 3- years $3,000.00 05/31/07 Commission $900k+sales 4.25% $900,000.00 06/30/07 Commission $450k-$899,999 4.00% $450,000.00 07/31/07 Commission $449,999- 3.50% 08/31/07 09/30/07 10/31/07 11/30/07 12/31/07 Employee ID Name Hire Date 5121 Logan 06/12/00 6121 West 07/10/90 7121 Smith 04/03/65 8121 Robinson 03/12/97 9121 Carson 07/01/04 1121 Bradley 05/12/04 Employee ID Name January Sales Years Employed Base Salary Commission Rate Commission 5121 Logan $500,000.00 6.64 $5,000.00 4.00% $20,000.00 6121 West $557,658.00 16.57 $5,000.00 4.00% $22,306.32 7121 Smith $578,668.00 41.86 $5,000.00 4.00% $23,146.72 8121 Robinson $356,897.00 9.90 $5,000.00 3.50% $12,491.40 9121 Carson $876,575.00 2.59 $3,000.00 4.00% $35,063.00 1121 Bradley $757,424.00 2.72 $3,000.00 4.00% $30,296.96 Total $3,627,222.00 $26,000.00 $143,304.40 Average 3.92% $23,884.07 High Commission $35,063.00 Low Commission $12,491.40
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Employee ID Name February Sales Years Employed Base Salary Commission Rate Commission 5121 Logan $1,434,000.00 6.72 $5,000.00 4.25% $60,945.00 6121 West $255,674.00 16.65 $5,000.00 3.50% $8,948.59 7121 Smith $423,578.00 41.93 $5,000.00 3.50% $14,825.23 8121 Robinson $6,437,689.00
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 12

rogers_logan_hw3 - Rolling Thunder Wheelchair Sales...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online