1 / 5

Spreadsheet Assignment: Calculating Employee Net Pay at Crestwood Laundry

In this assignment, you will create a spreadsheet to calculate the net pay for each of the five employees at Crestwood Laundry for the week ending September 19, 2000. You will include essential titles, labels, values, and formulas, ensuring to total the columns for Gross Pay, Income Tax, EI, Medical, and Net Pay. You will also utilize forecasting by adjusting specific amounts for employees Adams and Bruckner, enabling automatic updates in the spreadsheet. Finally, answer additional questions about the new net pays and total calculations.

bran
Télécharger la présentation

Spreadsheet Assignment: Calculating Employee Net Pay at Crestwood Laundry

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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

More Related