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

Still stressed with your coursework?
Get quality coursework help from an expert!