INF1060: SPREADSHEET1

1. INF1060: SPREADSHEET1

2. Assignment #2The Fill Down Command • In this activity you will prepare a spreadsheet that calculates the net pay for each of the five employees of Crestwood Laundry for the week ending September 19, 2000. • Also, totalthe columns for Gross Pay, Income Tax, EI, Medical and Net Pay. INF1060 Spreadsheet I

3. Assignment #2 (Cont’d) • Create a spreadsheet using the above information. Include titles, labels, values and formulas (don’t forget the planning sheet). • Save the spreadsheet as “1060 SS Assgn 2”. Submit the completed spreadsheet to Moodle. ? INF1060 Spreadsheet I

4. Assignment #2b (Cont’d) • Now you will see the real power of the spreadsheet… FORECASTING! • Forecasts predict the future based on past results. • You will change several values in the spreadsheet and the computer will automatically update the spreadsheet for you. Answer the following questions on the print out of your spreadsheet. • Change the following amounts for Adams: • Gross Pay: $730 • Income Tax: $162.70 • EI: $51.83 • A). What is the new net pay for Adams? INF1060 Spreadsheet I

5. Assignment #2b (Cont’d) • Change the following amounts for Bruckner: • Gross Pay: $440.86 • Income Tax: $58 • EI: $33 • B). What is the new net pay for Bruckner? • C). What are the new totals for Gross Pay, Income Tax and Net Pay? ***BONUS (1)*** What percentage of the gross pay is taken off as EI? Briefly explain how you arrived at your answer. INF1060 Spreadsheet I