Project 5: Profitability, Customers, and Inventory Spreadsheets in Sales Workbook

profileqFop
excelbook5rev.xlsx
Home>Business & Finance homework help>Accounting homework help>Project 5: Profitability, Customers, and Inventory Spreadsheets in Sales Workbook

Sheet1

Sale ID Date of Sale Product Quantity Color Unit Price ($) Subtotal ($) Tax Item Total Sales Person Customer Region
1 3142 5/10/19 Trouser, draw string 500 black 4 2,000 123.54 2,123.54 Wilberforce K. Quick Mart Northern
2 3145 5/11/19 Trouser, draw string 432 blue 4 1,728 107.136 1,835.14 Wilberforce K. Quick Mart NW
3 3147 5/15/19 Trouser, sweat pants 354 white 5 1,770 115 1,885.00 Kerry W. Nakumatt NE
4 3153 5/18/19 pair of socks 415 grey 2 830 50 880.00 Biden W. Quick Mart NW
5 3154 5/19/19 Trouser, draw string 425 blue 4 1,700 105 1,805.00 Wilberforce K. Sportsmart SW
6 3158 5/23/19 shirt, polo neck 587 pink 8 4,696 282 4,978.00 Kate R. Sportsmart SE
7 3159 5/23/19 pair of socks 879 black 2 1,758 108 1,866.00 Biden W. Nakumatt Eastern
8 3172 5/19/19 sweater, poloneck 389 blue 8 3,112 185 3,297.00 Diana R. Eastland retails Western
9 3179 5/15/19 sweater, poloneck 568 green 8 4,544 273.5 4,817.50 Diana R. Nakumatt SW
10 3185 5/28/19 pair of socks 987 yellow stripped 2 1,974 119.45 2,093.45 Biden W. Quick Mart SE
11 3189 5/15/19 trouser, wool type 243 navy blue 5 1,215 72.8 1,287.80 Ann Kerry T. Keiw stores NE
12 3190 5/28/19 Trouser, draw string 455 grey 4 1,820 110 1,930.00 Wilberforce K. Keiw stores Northern
13 3195 5/29/19 Shirt, Tee 345 milky white 9 3,105 185.9 3,290.90 Charles K. Eastland retails Southern
14 3198 5/30/19 pair of socks 341 blue 2 682 40.92 722.92 Biden W. Sportsmart SW
15 3199 5/30/19 jacket, woolen 434 violet 10 4,340 260.4 4,600.40 Quincy L. Quick Mart NW
37,412.65