spreadsheet_assignment_2

spreadsheet_assignment_2 - Tracy's Department Store...

Info icon This preview shows pages 1–4. 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
Image of page 1

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

View Full Document Right Arrow Icon
Brian Whiteley Section 20 Page 1 Expenses Overtime Facility Maintenance Publicity Total Expenses Net Worth $8,500.00 $10,000.00 $5,000.00 $108,500.00 20250 0 0.2 $11,250.00 $10,000.00 $5,000.00 $101,250.00 64500 69000 0.15 $9,100.00 $10,000.00 $5,000.00 $115,100.00 -22450 80000 0.1 $9,200.00 $10,000.00 $5,000.00 $70,200.00 112900 $11,850.00 $10,000.00 $5,000.00 $105,850.00 11000 $10,500.00 $10,000.00 $5,000.00 $95,500.00 -9500 60400 60000 30000 596400 176700 8 8 8 8 8 60400 60000 30000 596400 176700 8500 10000 5000 70200 -22450 17257.14 17142.86 8571.43 170400 50485.71
Image of page 2
Brian Whiteley Section 20 Page2 Tracy's Department Store Location-wise performance report for October, 2007 35.00% Department-wise sales Location Apparel Cosmetics Furniture Electronics Total Sales
Image of page 3

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

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern