Excel Assignment:

Spreadsheet #1:

You want to set up your inventory on a spreadsheet.

You need the following columns. You should enter data for some inventory that you think your company should carry (you should carry five or six items):

Item number

Item name

On hand

On order

Cost

Price

Now you need to add a column called profit and calculate the difference between the price and the cost to figure out your profit for each item. Once you have the formula for one row, you should copy and paste to get the profit for the other rows.

You now want a total line that contains the following:

A count of the number of items in your inventory

A total of the on hand column

A total of the on order column

Spreadsheet #2:

You want to set up payroll on a spreadsheet.

You need the following columns. You should enter data for some employees (you should have five or six employees):

Employee number

Employee name

Hours worked

Pay per hour

Percent withheld for medical

Percent withheld for taxes

You should add a column after pay per hour where you calculate gross pay (hours worked times pay per hour).

You should add a column after percent withheld for medical where you put the amount withheld for medical (gross pay times percent withheld for medical).

You should add a column after percent withheld for taxes where you put the amount withheld for taxes (gross pay times percent withheld for taxes)

You should add another column after amount withheld for taxes where you calculate net pay (gross pay minus amount withheld for medical and minus amount withheld for taxes)

You now want a total line that contains the following:

Total number of employees

Total gross pay

Total amount withheld for medical

Total amount withheld for taxes

Total net pay