computer comp.

 

if ur good in excel take a look at this.

   

Attached Files:

 Excel Assignment  (196.254 KB) BOOKSTORE PAYROLL.xlsx (202.996 KB) MusicRentals.xls (43 KB)Assignment Week Two:Please downlaod and follow the instruction s in the Excel Assignment PDF. Email any questions you might have.Thanks,

Excel Assignment

 Title in Cell A1 – Bookstore Payroll

Create table in excel

Table: 8 columns and 10 rows

Column headings:

 Column 1: Cell A3 – Employees First Name

 Column 2: Cell B3 – Employee Last Name

 Column 3: Cell C3 – Monthly Gross

 Column 4: Cell D3 – Soc. Security

 Column 5: Cell D3 – Medicare

 Column 6: Cell E3 – Federal Tax

 Column 7: Cell F3- State Tax

 Column8: Cell G3 – Net Pay

Add the First Names to Column 1, Last Name to column 2 and Level to Column 3

 John Doe Entry Level

 Melissa Page Junior Level

 Robert Moses Senior Level

 Jones Beach Junior Level

 Paul Simon Senior Level

 Sue Ellen Entry Level

 Mike Pro Junior Level

 Pete Lee Senior Level

 Maya Lou Junior Level

 Mary Pie Junior Level

 Bottom row Totals

 Each Employee works a total of 40 hours a week.

Use an excel formula to calculate each of these:

 Monthly Gross Income

 Social Security Employee

 Social Security Employer

 Federal tax

 State tax

 Net pay for each

 Totals

 Sort employee last in ascending order

Save file and upload to Dropbox.

Sheet1

Deductions

Soc. Sec

6.20%

Federal Tax

8%

State Tax

2%

Medicare

1.45%

Employee Rate

Entry Level

$40/hr

Junior Level

$50/hr

Senior Level

$80/hr

Sheet2

Sheet3

2

>Rental Prices

Main Street

8

0

) 555-2

20

months

0

0

6

8

$40 $22 $770 $616

$58

	7		5			0
	Danbury, CT 0	6								1
	(	20				3		9
	www.makingmusic.com
	Instrument	Fee for First Four Months	Regular Monthly Rental Fee	Purchase price	Discount price if purchased before end of first		12
	Trumpet		$			4		$22		$770		$616	Coming Soon!
	Alto saxophone	$80	$42	$1,	47	$1,		17	French horn
	Flute	$38	$	21	$735		$58	oboe
	Snare drums	$30	$17	$595	$476
	Trombone	$44	$24	$840	$672
	Tenor saxophone	$	86	$	45	$1,575	$1,260
	Clarinet
	Bass clarinet	$31	$1,085	$8	68
All payments apply to the price of the instrument. No finance charges are added.
You may exercise the option to pay off the balance owed at any time without penalty.
A discount applies to early payout during the first 12 months.

Rentals 2005-2006

750 Main Street
Danbury, CT 068

(203) 555-

20

www.makingmusic.com
Instrument

Trumpet 9 20 17

12

Alto saxophone 2 5 3 6 3

Flute

29 21

Snare drums 10 11 9 12 5 47
Trombone 3 4 2 4 2 15
Tenor saxophone 1 0 1 1 1 4
Clarinet 15 17

10

Bass clarinet 1 0 1 0 1 3
Total

86 68

45

10
29
South Middle School	Roosevelt Middle School	Brown Middle School	Danbury High School	Brookfield High School		Total
25	83
19
		15	33		11	109
14	18	74
56	99	354

Rentals Chart 2005-2006

Total Instrument Rentals 2005-2006