{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

SpreadsheetAssignment - Paulie'sRestaurant...

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

View Full Document Right Arrow Icon
Andrew Cheung 08 1 Paulie's Restaurant March Payroll Report Division Pay Rate Overtime Managers 2 $35.00 100 $7,000.00 $700.00 $2,500.00 Full-Time 5 $30.00 160 $24,000.00 $2,400.00 $500.00 Part-Time 4 $15.00 80 $4,800.00 $480.00 $1,100.00 Cleaning Staff 2 $12.00 100 $2,400.00 $240.00 $0.00 Cooks 6 $25.00 180 $27,000.00 $2,700.00 $600.00 Waiters 6 $15.00 120 $10,800.00 $1,080.00 $2,000.00 Delivery Drivers 5 $15.00 80 $6,000.00 $600.00 $0.00 Column Totals 30 $147.00 820 $82,000.00 $8,200.00 $6,700.00 No. of Staff  Members Average  Hours Total  Salaries Commissio n
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
Andrew Cheung 08 2 28.00% Taxes Meal Costs $2,856.00 $950.00 $1,000.00 $4,806.00 $10,200.00 $7,532.00 $2,450.00 $1,000.00 $10,982.00 $26,900.00 $1,786.40 $590.00 $1,000.00 $3,376.40 $6,380.00 $739.20 $240.00 $1,000.00 $1,979.20 $2,640.00 $8,484.00 $2,760.00 $1,000.00 $12,244.00 $30,300.00 $3,886.40 $1,280.00 $1,000.00 $6,166.40 $13,880.00 $1,848.00 $600.00 $1,000.00 $3,448.00 $6,600.00 $27,132.00 $8,870.00 $7,000.00 $43,002.00 $96,900.00 Uniform  Cleaning Total  Deductions Total  Payroll
Background image of page 2
Andrew Cheung 08 3 Paulie's Restaurant March Payroll Report Division Pay Rate Average Hours Total Salaries Managers 2 $35.00 100 $7,000.00 Full-Time 5 $30.00 160 $24,000.00 Part-Time 4 $15.00 80 $4,800.00 Cleaning Staff 2 $12.00 100 $2,400.00 Cooks 6 $25.00 180 $27,000.00 Waiters 6 $15.00 120 $10,800.00 Delivery Drivers 5 $15.00 80 $6,000.00 Column Totals 30 $147.00 820 $82,000.00 No. of Staff  Members
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
Andrew Cheung 08 4 28.00% Commission Overtime Taxes Meal Costs $700.00 $2,500.00 $2,856.00 $950.00 $1,000.00 $2,400.00 $500.00 $7,532.00 $2,450.00 $1,000.00 $480.00 $1,100.00 $1,786.40 $590.00 $1,000.00 $240.00 $0.00 $739.20 $240.00 $1,000.00 $2,700.00 $600.00 $8,484.00 $2,760.00 $1,000.00 $1,080.00 $2,000.00 $3,886.40
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
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}