spreadsheet_assignment_2

spreadsheet_assignment_2 - Tracy's Department Store...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Brian Whiteley Section 20 Page 1 Tracy's Department Store Location-wise performance report for October, 2007 35.00% Department-wise sales Location Apparel Cosmetics Furniture Electronics Total Sales Sales Taxes Salaries Overtime Rate New York 30000 $3,500.00 100000 $25,000.00 $158,500.00 $29,750.00 $85,000.00 $0.10 Boston 25000 $2,000.00 160000 $5,000.00 $192,000.00 $26,250.00 $75,000.00 $0.15 San Francisco 32000 $1,500.00 80000 $11,000.00 $124,500.00 $31,850.00 $91,000.00 $0.10 Houston 18000 $1,200.00 180000 $0.00 $199,200.00 $16,100.00 $46,000.00 $0.20 Philadelphia 20000 $2,500.00 120000 $2,000.00 $144,500.00 $27,650.00 $79,000.00 $0.15 Chicago 29000 $1,500.00 80000 $0.00 $110,500.00 $24,500.00 $70,000.00 $0.15 Column Totals 154000 12200 720000 43000 929200 156100 446000 #cells 9 8 10 8 8 9 9 7 max 154000 12200 720000 43000 929200 ### 446000 0.2 min 18000 1200 80000 0 110500 35.00% 46000 0.1 average 44000 3485.71 205714.29 12285.71 265485.71 3902504.38% 127428.57 0.14
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Brian Whiteley Section 20
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/29/2008 for the course COMP APPS 170 taught by Professor Gayatreeganu during the Fall '08 term at Rutgers.

Page1 / 4

spreadsheet_assignment_2 - Tracy's Department Store...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online