Poppa Martini's Pizza Payroll
(1) Log into Google Classroom and open th Pizza Payroll spreadsheet
(2) Scroll to the bottom of this page and copy/paste the data into your spreadsheet.. (If it pastes strangely, open this page in a different browser)
(3) Calculate Gross Pay by multiplying hours by rate. Type the formula then fill it into the cells below.
(3) Calculate taxes based on the following rates:
FICA 8% |
Multiply Gross Pay by the percentage shown to the left. |
(4) Calculate Net Pay by subtracting the four taxes from the gross pay.
(5) Insert a formula to total each column except for Rate (that wouldn't
make much sense). 
(6) Put in a border on top and bottom of the Total row. Put a heavy border
on bottom of title row (that's row 3). 
(7) Make a column chart that represents hours worked
and name. Use the chart wizard 
(8) Sort the rows alphabetically by name.
(9) Cleaning Up:
- Change color of sheet.
- Make sure all dollar amounts are formatted as currency with 2 decimal places.
- Also make sure that all columns are just wide enough to accommodate the data.