{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

9.7.2017 mgmt info systems.xlsx

9.7.2017 mgmt info systems.xlsx - PAYROLL EXAMPLE As of...

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

View Full Document Right Arrow Icon
PAYROLL EXAMPLE As of 9/7.17 Name hourly rate OT hours OT wages 50 $50 $2,500 $60 10 $600 $3,100 60 $70 $4,200 $84 20 $1,680 $5,880 30 $40 $1,200 $48 30 $1,440 $2,640 20 $40 $800 $48 40 $1,920 $2,720 TOTAL 160 $8,700 $5,640 $14,340 % of total wage as OT 39.33% AVERAGE $3,585 MAX $3,100 MIN $2,640 ASSUMPTIONS SECTION OT wage rate 1.2 VLOOKUPTABLE YEARS PAY 0 $ 12.50 2 $ 14.65 5 $ 17.00 10 $ 20.00 hours worked standard wages OT hourly rate Total wages
Background image of page 1

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

View Full Document Right Arrow Icon
Years Worked Hourly Rate 19.35% 20 $ 20.00 28.57% 12 $ 20.00 54.55% 8 $ 17.00 70.59% 18 $ 20.00
Background image of page 2
Background image of page 3

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

View Full Document Right Arrow Icon
Background image of page 4
Background image of page 5

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

View Full Document Right Arrow Icon
Background image of page 6
Background image of page 7

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

View Full Document Right Arrow Icon
Background image of page 8
Background image of page 9

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

View Full Document Right Arrow Icon
Background image of page 10
Background image of page 11

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

View Full Document Right Arrow Icon
Background image of page 12
Background image of page 13

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

View Full Document Right Arrow Icon
Background image of page 14
Background image of page 15

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

View Full Document Right Arrow Icon
Background image of page 16
Background image of page 17

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

View Full Document Right Arrow Icon
Background image of page 18
Background image of page 19

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

View Full Document Right Arrow Icon
Background image of page 20
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}