The Data

Last Year's Employee Compensation Information:

Name	Annual Salary	Hourly Wage	Average O/T Hours per Pay Period	Average Sales per Pay Period
Jack	$62,088		3
Gail				$269,844
Jennifer		$27.03	8
Evelyn				$213,328
Indiana	$121,788		5
Hakim		$55.62	6

Per Pay Period Graduated Commission Scale:

Commission Scale	Commission Rate
$0.00-$50,000.00	1.01%
$50,000.01-$100,000.00	2.98%
$100,000.01 and up	4.44%

Important Information

• A normal workweek for any employee is 7.5 hours per day from Monday through Friday.
• Lightning Wholesale pays overtime at time-and-a-half and is never open on statutory holidays.
• Lightning Wholesale issues payroll every two weeks.
• Lightning Wholesale is situated in New Brunswick.
• Federal and provincial income tax information can be found in the Tables below
• A 52-week year is assumed.

Your Tasks

1. Create a report on each employee and summarize the information in a table.
   1. Calculate the annual regular earnings.
   2. Calculate the annual overtime earnings.
   3. Calculate the annual gross earnings
   4. Calculate the annual federal income taxes.
   5. Calculate the annual provincial income taxes.
   6. Calculate the employee's take-home pay after deducting taxes.
   7. Calculate the totals of all of the above.

\f2013 Provincial Taxes Province/ Taxable Income Tax Rate Province/ Taxable Income Tax Rate Territory Territory British Columbia $0.00 $10,276.00* 0% Nova Scotia $0.00-$8,481.00* 0% $ 10,276.01-$37,568.00 5.06% $8,481.01-$29,590.00 8.79% $37,568.01-$75,138.00 7.7% $29,590.01-$59,180.00 14.95% $75, 138.01-$86,268.00 10.5% $59,180.01-$93,000.00 16.67% $86,268.01-$104,754.00 12.29% $93,000.01-$150,000.00 17.5% $ 104,754.01 and up 14.7% $150,000.01 and up 21% Alberta $0.00-$17,593.00# 0% Prince Edward $0.00-$7,708.00* 0% $17,593.01 and up 10% Island* * $7,708.01-$31,984.00 9.8% Saskatchewan $0.00 $15,241.00# 0% $31,984.01-$63,969.00 13.8% $15,241.01-$42,906.00 1 1% $63,969.01 and up 16.7% $42,906.01-$122,589.00 13% Newfoundland and $0.00-$8,451.00* $122,589.01 and up 15% Labrador $8,451.01-$33,748.00 7.7% Manitoba $0.00-$8,884.00* 0% $33,748.01-$67,496.00 12.5% $8,884.01-$31,000.00 10.8% $67,496.01 and up 13.3% $31,000.01-$67,000.00 12.75% Yukon** $0.00-$11,038.00* 0% $67,000.01 and up 17.4% $11,038.01-$43,561.00 7.04% Ontario* * $0.00-$9,574.00* 0% $43,561.01-$87, 123.00 9.68% $9,574.01-$39,723.00 5.05% $87,123.01-$135,054.00 11.44% $39,723.01-$79,448.00 9.15% $135,054.01 and up 12.76% $79,488.01-$509,000.00 11.16% $ 509,000.01 and up 13.16% Northwest $0.00-$13,546.00* 0% Quebec $0.00-$ 11, 195.00* 0% Territories $13,546.01-$39,453.00 5.9% $11, 195.01-$41,095.00 16% $39,453.01-$78,908.00 8.6% $41,095.01-$82,190.00 20% $78,908.01-$128,286.00 12.2% $82, 190.01 and up 24% $128,286.01 and up 14.05% New Brunswick $0.00-$9,388.00* 0% Nunavut $0.00-$12,455.00* 0% $9,388.01-$38,954.00 9.1% $ 12,455.01-$43,535.00 4% $38,954.01-$77,908.00 12.1% $43,535.01-$83,071.00 7% $77,908.01-$126,662.00 12.4% $83,071.01-$135,054.00 9% $126,662.01 and up 14.3% $135,054.01 and up 11.5% * These amounts represent the basic personal amount. **There are additional income surtaxes in these provinces and Yukon. These surtaxes are not covered in this textbook