SpreadsheetAssignmentSecond

SpreadsheetAssignmentSecond - Paulie'sRestaurant...

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

View Full Document Right Arrow Icon
Andrew Cheung 08 1 Paulie's Restaurant March Payroll Report Division No. of Staff Members Pay Rate Total Salaries Overtime Managers 2 $35.00 100 $7,000.00 $700.00 35.00% $2,450.00 Full-Time 5 $30.00 160 $24,000.00 $2,400.00 20.00% $4,800.00 Part-Time 4 $15.00 80 $4,800.00 $480.00 50.00% $2,400.00 Cleaning Staff 2 $12.00 100 $2,400.00 $240.00 50.00% $1,200.00 Cooks 6 $25.00 180 $27,000.00 $2,700.00 20.00% $5,400.00 Waiters 6 $15.00 120 $10,800.00 $1,080.00 20.00% $2,160.00 Delivery Drivers 5 $15.00 80 $6,000.00 $600.00 35.00% $2,100.00 Column Totals 30 $147.00 820 $82,000.00 $8,200.00 $20,510.00 Number of Cells with values Number of cells with text Largest value Smallest Value Average Value 130 28 110712.3 0 6463.8 Average  Hours Commissio n Overtime  Rate
Background image of page 1

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

View Full DocumentRight Arrow Icon
Andrew Cheung 08 2 28.00% Taxes Meal Costs Salary Rate $2,842.10 $945.00 $1,000.00 $4,787.10 $10,150.35 $0 50.00% $8,736.06 $2,880.00 $1,000.00 $12,616.06 $31,200.20 $5,000  35.00% $2,150.54 $720.00 $1,000.00
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

SpreadsheetAssignmentSecond - Paulie'sRestaurant...

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

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