Sales Across the First Three Months of 2019 & Business Intelligence Project

User Generated

vfnzhff

Business Finance

Description

Hi all,


Looking for someone who is professional on Excel.


See the attachments below.

Unformatted Attachment Preview

Hello! When you open the Excel Assignment workbook, you’ll find two worksheets. There’s a blank Data Sheet that will cover sales across the first three months of 2019 (BE AWARE, some of the columns aren’t filled in yet!), and there’s a Question Sheet that asks a simple business intelligence question about the data on the Data Sheet. The Data Sheet starts off blank, but after you complete the Step 1 in the “Directions for Success” on the next page, it is broken down as follows: Invoice Number – Each sale is attached to an invoice. An invoice works just like when you go to the grocery store. Multiple items across many different categories can end up on the same invoice. Sale Date – This is the date that the sale was made. Sometimes more than one invoice occurs on the same day. Item Category – This is the category that a particular item comes from. For instance, an item might be from the Tool department. In this simplified representation of real life, people are going to potentially buy multiple copies of the same item, all of them at the same price (like when you buy 6 Chicken flavored Cup O Noodles for your dorm room). Individual Price – This is the sale price for a single one of the items in the category (i.e, the price of a single Cup O Noodles). Quantity Sold – This is how many of the items was purchased by the customer. Subtotal – This isn’t filled in yet, but it’s simple! This is the total cost of the items from this part of the invoice (IE: a Quantity of 6 Cup O Noodles, sold @ $1 each would have a subtotal of $6. It is the product of the Individual Price multiplied by the Quantity). Salesperson – This is the name of the Salesperson who made the sale. There is one salesperson per invoice (this is like when you go to a grocery store, and one cashier checks you out). Commission Percentage – This is the percent of the total sale that the Salesperson will receive as a commission. Commission Amount – This isn’t filled in yet, but it’s simple! This is the actual dollar amount that the salesperson will earn on this portion of the invoice (IE: A Subtotal of $100 with a Commission Percentage of 5% would earn the Salesperson $5. It is the product of the Subtotal multiplied by the Commission Percentage). On the next page give you some guidance for how to fill in your answers and earn a good grade. Directions For Success In order to get a 100% (50 total points) on this assignment, you’ll need to successfully fill in your Data Sheet and answer the question on your Question Sheet. Here’s how to do that: Data Sheet (9.5 Points): 1) Import the Sale Data.csv file [located on Moodle – Download it to your computer!] from Text/CSV into your workbook’s Data Sheet – When you are loading the data, make sure you load it to the Data Sheet. 2) Fill in the Subtotal Column – On the previous page, I gave you the basic formula for filling in the Subtotal column. Create a formula in Excel that will appropriately calculate the Subtotal for you. 3) Fill in the Commission Amount Column – On the previous page, I gave you the basic formula for filling in the Commission Amount column. Create a formula in Excel that will appropriately calculate the Commission Amount for you. Question Sheet (40.5 Points): QUESTION: (Which salesperson had the highest dollar amount in gross sales? Explain your answer. In order to answer this question you’ll need to make a PivotTable on a new sheet. The PivotTable should examine the relationship between each Salesperson and their overall Subtotal. Give a brief explanation of why you chose the Salesperson that you did. Question # Question Which salesperson had the highest dollar amount in gross sales? Explain your answer. 1 Answer Explanation Invoice Number Sale Date 10001 1/1/2019 10002 1/2/2019 10002 1/2/2019 10002 1/2/2019 10002 1/2/2019 10002 1/2/2019 10003 1/3/2019 10003 1/3/2019 10004 1/4/2019 10004 1/4/2019 10004 1/4/2019 10004 1/4/2019 10004 1/4/2019 10005 1/4/2019 10005 1/4/2019 10006 1/4/2019 10007 1/5/2019 10008 1/6/2019 10009 1/6/2019 10010 1/6/2019 10010 1/6/2019 10010 1/6/2019 10010 1/6/2019 10010 1/6/2019 10011 1/6/2019 10011 1/6/2019 10012 1/6/2019 10012 1/6/2019 10012 1/6/2019 10012 1/6/2019 10013 1/7/2019 10013 1/7/2019 10014 1/7/2019 10014 1/7/2019 10014 1/7/2019 10015 1/7/2019 10015 1/7/2019 10016 1/7/2019 10017 1/7/2019 10017 1/7/2019 Item CategoryIndividual Price Quantity SoldSubtotal Tools $3.22 4 Office Supplies $12.36 5 Automotive $7.35 4 Tools $3.03 5 Clothing $9.04 1 Electronics $6.32 2 Office Supplies $11.49 3 Crafts $10.98 3 Groceries $12.33 2 Automotive $11.24 4 Tools $12.72 4 Tools $10.51 3 Automotive $2.30 1 Tools $12.26 1 Jewelry $5.55 5 Electronics $6.94 4 Clothing $5.52 1 Home Living $9.41 4 Electronics $12.45 1 Tools $12.00 2 Tools $13.52 1 Electronics $6.33 2 Baby $9.52 1 Baby $26.40 3 Groceries $10.05 5 Electronics $12.29 2 Tools $13.66 2 Jewelry $9.00 1 Jewelry $8.27 3 Clothing $5.85 4 Pets $23.94 3 Home Living $9.40 5 Crafts $10.79 5 Home Living $9.51 5 Baby $23.29 5 Clothing $8.12 3 Office Supplies $11.55 4 Home Living $6.76 2 Electronics $9.21 1 Groceries $6.66 1 Salesperson Nikki Renoldo Renoldo Renoldo Renoldo Renoldo Kelly Kelly Rickey Rickey Rickey Rickey Rickey Denise Denise George Denise Nikki Renoldo Marie Marie Marie Marie Marie Renoldo Renoldo Renoldo Renoldo Renoldo Renoldo Rickey Rickey Denise Denise Denise Jennifer Jennifer Kelly Jennifer Jennifer 10018 10019 10019 10019 10019 10019 10020 10020 10020 10020 10020 10021 10022 10023 10024 10024 10024 10025 10025 10026 10026 10026 10026 10026 10027 10027 10028 10028 10028 10028 10028 10029 10029 10030 10030 10030 10031 10031 10031 10031 10031 1/7/2019 1/7/2019 1/7/2019 1/7/2019 1/7/2019 1/7/2019 1/7/2019 1/7/2019 1/7/2019 1/7/2019 1/7/2019 1/7/2019 1/7/2019 1/8/2019 1/9/2019 1/9/2019 1/9/2019 1/10/2019 1/10/2019 1/11/2019 1/11/2019 1/11/2019 1/11/2019 1/11/2019 1/12/2019 1/12/2019 1/13/2019 1/13/2019 1/13/2019 1/13/2019 1/13/2019 1/14/2019 1/14/2019 1/14/2019 1/14/2019 1/14/2019 1/14/2019 1/14/2019 1/14/2019 1/14/2019 1/14/2019 Clothing Automotive Electronics Clothing Baby Office Supplies Home Living Baby Automotive Pets Tools Pets Home Living Crafts Office Supplies Jewelry Tools Automotive Crafts Crafts Clothing Jewelry Office Supplies Groceries Clothing Electronics Office Supplies Jewelry Jewelry Baby Jewelry Office Supplies Pets Crafts Groceries Automotive Groceries Automotive Pets Electronics Pets $5.60 $6.40 $3.93 $2.68 $18.29 $24.14 $6.23 $19.62 $4.08 $73.90 $6.37 $65.70 $10.21 $12.20 $5.11 $6.11 $9.02 $3.67 $13.69 $13.38 $3.01 $9.92 $4.02 $10.92 $2.31 $10.40 $19.03 $8.11 $10.73 $14.26 $6.75 $20.55 $12.37 $11.78 $6.03 $7.83 $8.81 $3.43 $75.52 $7.88 $75.53 1 4 4 4 3 5 3 5 3 4 1 3 1 5 5 1 5 1 3 3 2 1 2 3 1 1 2 2 4 2 5 5 1 2 3 4 2 5 2 5 5 Stephen Nikki Nikki Nikki Nikki Nikki Jennifer Jennifer Jennifer Jennifer Jennifer Nikki Johnny Stephen Denise Denise Denise George George Johnny Johnny Johnny Johnny Johnny Stephen Stephen Jennifer Jennifer Jennifer Jennifer Jennifer Jennifer Jennifer Denise Denise Denise Kelly Kelly Kelly Kelly Kelly 10031 10031 10032 10032 10032 10033 10033 10033 10033 10034 10034 10034 10034 10034 10034 10034 10034 10034 10035 10035 10036 10036 10037 10037 10038 10038 10038 10038 10038 10039 10040 10041 10042 10042 10043 10044 10044 10044 10045 10046 10047 1/14/2019 1/14/2019 1/14/2019 1/14/2019 1/14/2019 1/15/2019 1/15/2019 1/15/2019 1/15/2019 1/16/2019 1/16/2019 1/16/2019 1/16/2019 1/16/2019 1/16/2019 1/16/2019 1/16/2019 1/16/2019 1/16/2019 1/16/2019 1/17/2019 1/17/2019 1/17/2019 1/17/2019 1/17/2019 1/17/2019 1/17/2019 1/17/2019 1/17/2019 1/17/2019 1/18/2019 1/18/2019 1/19/2019 1/19/2019 1/20/2019 1/20/2019 1/20/2019 1/20/2019 1/21/2019 1/21/2019 1/21/2019 Tools Home Living Groceries Baby Groceries Home Living Electronics Jewelry Jewelry Crafts Groceries Pets Automotive Tools Baby Groceries Office Supplies Crafts Home Living Automotive Automotive Baby Jewelry Groceries Baby Home Living Automotive Tools Tools Office Supplies Office Supplies Home Living Office Supplies Baby Electronics Baby Pets Crafts Groceries Baby Baby $11.38 $11.10 $8.95 $17.55 $4.97 $2.88 $11.87 $5.56 $9.03 $12.01 $7.86 $29.87 $10.67 $6.98 $19.40 $7.93 $18.89 $11.73 $9.81 $4.37 $1.97 $7.57 $5.40 $11.58 $24.23 $3.25 $10.42 $3.05 $15.94 $5.59 $21.94 $7.00 $10.63 $13.24 $3.67 $22.82 $19.42 $10.96 $10.00 $18.08 $28.51 4 4 2 3 1 2 4 5 2 3 1 2 5 3 3 4 3 2 4 4 1 5 4 2 5 5 4 4 1 5 2 1 4 5 4 2 3 5 3 1 1 Kelly Kelly Johnny Johnny Johnny Nikki Nikki Nikki Nikki Rickey Rickey Rickey Rickey Rickey Rickey Rickey Rickey Rickey Johnny Johnny Marie Marie Renoldo Renoldo Renoldo Renoldo Renoldo Renoldo Renoldo Jennifer George Denise Johnny Johnny Denise Denise Denise Denise Kelly Johnny Nikki 10048 10048 10048 10048 10048 10048 10048 10049 10049 10049 10049 10050 10050 10050 10050 10051 10051 10051 10052 10052 10052 10053 10053 10054 10054 10054 10055 10055 10056 10057 10057 10057 10057 10058 10058 10058 10059 10060 10060 10060 10060 1/21/2019 1/21/2019 1/21/2019 1/21/2019 1/21/2019 1/21/2019 1/21/2019 1/22/2019 1/22/2019 1/22/2019 1/22/2019 1/22/2019 1/22/2019 1/22/2019 1/22/2019 1/22/2019 1/22/2019 1/22/2019 1/23/2019 1/23/2019 1/23/2019 1/23/2019 1/23/2019 1/24/2019 1/24/2019 1/24/2019 1/25/2019 1/25/2019 1/26/2019 1/26/2019 1/26/2019 1/26/2019 1/26/2019 1/27/2019 1/27/2019 1/27/2019 1/27/2019 1/28/2019 1/28/2019 1/28/2019 1/28/2019 Jewelry Jewelry Electronics Home Living Automotive Jewelry Crafts Office Supplies Office Supplies Crafts Baby Jewelry Automotive Tools Office Supplies Clothing Jewelry Tools Home Living Tools Baby Home Living Crafts Pets Electronics Crafts Clothing Pets Tools Pets Pets Clothing Automotive Automotive Pets Automotive Electronics Electronics Jewelry Clothing Tools $3.09 $5.58 $3.54 $10.98 $3.81 $3.41 $8.75 $17.75 $20.82 $7.20 $27.76 $8.81 $11.11 $5.77 $4.59 $2.39 $4.22 $3.55 $10.35 $15.56 $26.94 $3.04 $9.13 $23.01 $2.58 $11.91 $6.75 $45.21 $12.85 $19.02 $30.48 $4.99 $10.93 $2.52 $81.47 $4.51 $12.75 $3.17 $7.64 $6.91 $9.02 3 5 1 2 3 4 5 2 4 4 2 4 2 3 4 5 4 1 5 3 1 5 5 1 3 3 2 1 2 3 5 5 1 1 2 3 5 4 2 1 4 Johnny Johnny Johnny Johnny Johnny Johnny Johnny Stephen Stephen Stephen Stephen Stephen Stephen Stephen Stephen Nikki Nikki Nikki Marie Marie Marie Nikki Nikki Stephen Stephen Stephen Denise Denise Kelly George George George George Renoldo Renoldo Renoldo Marie Renoldo Renoldo Renoldo Renoldo 10060 10060 10060 10060 10061 10061 10062 10062 10062 10062 10063 10063 10063 10063 10063 10063 10063 10063 10063 10063 10063 10063 10063 10064 10064 10065 10065 10066 10066 10067 10067 10067 10067 10067 10067 10067 10067 10067 10068 10068 10069 1/28/2019 1/28/2019 1/28/2019 1/28/2019 1/28/2019 1/28/2019 1/28/2019 1/28/2019 1/28/2019 1/28/2019 1/29/2019 1/29/2019 1/29/2019 1/29/2019 1/29/2019 1/29/2019 1/29/2019 1/29/2019 1/29/2019 1/29/2019 1/29/2019 1/29/2019 1/29/2019 1/30/2019 1/30/2019 1/31/2019 1/31/2019 1/31/2019 1/31/2019 1/31/2019 1/31/2019 1/31/2019 1/31/2019 1/31/2019 1/31/2019 1/31/2019 1/31/2019 1/31/2019 1/31/2019 1/31/2019 1/31/2019 Automotive Tools Clothing Office Supplies Home Living Crafts Electronics Clothing Pets Automotive Automotive Jewelry Automotive Home Living Home Living Baby Groceries Automotive Office Supplies Clothing Electronics Automotive Crafts Automotive Tools Groceries Jewelry Clothing Tools Jewelry Electronics Electronics Groceries Automotive Jewelry Crafts Home Living Baby Groceries Electronics Pets $3.08 $5.23 $3.50 $3.76 $8.57 $8.96 $8.49 $7.72 $77.22 $4.87 $8.64 $8.81 $2.06 $4.03 $6.95 $28.58 $9.29 $7.65 $3.79 $5.86 $2.50 $7.50 $10.00 $8.63 $12.72 $10.14 $10.87 $8.42 $7.96 $10.29 $7.67 $10.77 $7.91 $2.27 $10.90 $9.78 $7.77 $7.73 $11.04 $2.62 $48.83 2 5 5 1 2 3 5 3 1 5 3 2 2 3 2 3 2 2 3 5 2 4 1 4 3 2 2 4 1 1 3 2 3 1 3 1 1 5 4 3 3 Renoldo Renoldo Renoldo Renoldo Marie Marie Kelly Kelly Kelly Kelly Johnny Johnny Johnny Johnny Johnny Johnny Johnny Johnny Johnny Johnny Johnny Johnny Johnny Renoldo Renoldo Kelly Kelly Marie Marie Kelly Kelly Kelly Kelly Kelly Kelly Kelly Kelly Kelly George George Jennifer 10069 10069 10070 10071 10071 10071 10071 10071 10071 10072 10073 10074 10074 10075 10076 10076 10076 10076 10076 10077 10077 10077 10078 10078 10078 10078 10079 10079 10079 10079 10080 10081 10081 10081 10082 10082 10082 10083 10083 10083 10083 1/31/2019 1/31/2019 2/1/2019 2/1/2019 2/1/2019 2/1/2019 2/1/2019 2/1/2019 2/1/2019 2/1/2019 2/2/2019 2/3/2019 2/3/2019 2/3/2019 2/3/2019 2/3/2019 2/3/2019 2/3/2019 2/3/2019 2/3/2019 2/3/2019 2/3/2019 2/4/2019 2/4/2019 2/4/2019 2/4/2019 2/5/2019 2/5/2019 2/5/2019 2/5/2019 2/5/2019 2/5/2019 2/5/2019 2/5/2019 2/5/2019 2/5/2019 2/5/2019 2/5/2019 2/5/2019 2/5/2019 2/5/2019 Tools Automotive Electronics Home Living Electronics Jewelry Clothing Home Living Crafts Groceries Office Supplies Home Living Groceries Home Living Office Supplies Groceries Pets Clothing Pets Jewelry Groceries Clothing Clothing Clothing Automotive Electronics Groceries Tools Home Living Automotive Crafts Baby Groceries Crafts Baby Tools Office Supplies Electronics Crafts Jewelry Office Supplies $4.89 $4.52 $6.94 $4.67 $8.19 $7.27 $2.89 $7.16 $4.63 $4.32 $16.36 $8.29 $7.19 $9.65 $15.17 $12.34 $54.74 $7.28 $71.91 $7.84 $8.72 $8.39 $6.02 $7.22 $3.49 $3.04 $11.90 $4.54 $10.16 $10.51 $7.73 $17.90 $8.45 $10.69 $17.44 $13.98 $8.14 $8.37 $4.22 $3.56 $9.96 5 3 4 1 1 1 2 4 5 4 1 3 1 3 2 4 1 4 4 1 4 4 2 4 3 3 5 5 5 5 3 4 2 5 2 4 4 3 1 1 2 Jennifer Jennifer Marie Jennifer Jennifer Jennifer Jennifer Jennifer Jennifer Stephen Johnny Marie Marie Jennifer Renoldo Renoldo Renoldo Renoldo Renoldo Marie Marie Marie Rickey Rickey Rickey Rickey Renoldo Renoldo Renoldo Renoldo Kelly Rickey Rickey Rickey Nikki Nikki Nikki Denise Denise Denise Denise 10084 10084 10084 10085 10085 10085 10086 10087 10088 10089 10090 10090 10091 10091 10092 10092 10093 10093 10094 10094 10094 10094 10095 10096 10096 10096 10096 10096 10096 10096 10096 10096 10097 10097 10097 10097 10097 10097 10097 10097 10098 2/5/2019 2/5/2019 2/5/2019 2/5/2019 2/5/2019 2/5/2019 2/5/2019 2/5/2019 2/6/2019 2/6/2019 2/7/2019 2/7/2019 2/8/2019 2/8/2019 2/8/2019 2/8/2019 2/9/2019 2/9/2019 2/9/2019 2/9/2019 2/9/2019 2/9/2019 2/10/2019 2/10/2019 2/10/2019 2/10/2019 2/10/2019 2/10/2019 2/10/2019 2/10/2019 2/10/2019 2/10/2019 2/10/2019 2/10/2019 2/10/2019 2/10/2019 2/10/2019 2/10/2019 2/10/2019 2/10/2019 2/11/2019 Jewelry Automotive Clothing Clothing Baby Groceries Office Supplies Pets Pets Tools Groceries Jewelry Jewelry Automotive Jewelry Tools Home Living Clothing Office Supplies Groceries Tools Tools Jewelry Crafts Electronics Groceries Office Supplies Home Living Baby Jewelry Pets Baby Electronics Office Supplies Office Supplies Baby Baby Office Supplies Electronics Pets Pets $5.40 $2.28 $4.97 $6.20 $28.86 $8.38 $9.79 $77.70 $64.88 $13.75 $3.43 $9.55 $3.47 $10.38 $7.94 $10.48 $9.00 $3.04 $15.92 $12.02 $9.45 $11.46 $3.73 $12.47 $5.92 $7.77 $8.47 $3.11 $23.95 $5.54 $53.54 $9.42 $7.44 $20.52 $12.51 $8.22 $17.85 $8.86 $10.42 $38.36 $77.91 4 5 4 4 1 1 1 5 2 1 4 3 4 5 2 4 1 1 1 1 2 2 5 2 2 5 1 2 2 1 4 1 4 3 3 3 5 1 4 1 4 Nikki Nikki Nikki George George George Jennifer Renoldo Jennifer Rickey Kelly Kelly Denise Denise Johnny Johnny Stephen Stephen Marie Marie Marie Marie George Johnny Johnny Johnny Johnny Johnny Johnny Johnny Johnny Johnny Renoldo Renoldo Renoldo Renoldo Renoldo Renoldo Renoldo Renoldo Marie 10099 10099 10100 10101 10102 10103 10104 10104 10105 10105 10105 10105 10105 10105 10105 10106 10106 10106 10106 10107 10108 10109 10109 10109 10110 10110 10111 10111 10112 10112 10112 10112 10112 10112 10112 10112 10113 10114 10114 10114 10114 2/12/2019 2/12/2019 2/13/2019 2/13/2019 2/13/2019 2/14/2019 2/14/2019 2/14/2019 2/15/2019 2/15/2019 2/15/2019 2/15/2019 2/15/2019 2/15/2019 2/15/2019 2/15/2019 2/15/2019 2/15/2019 2/15/2019 2/15/2019 2/16/2019 2/16/2019 2/16/2019 2/16/2019 2/17/2019 2/17/2019 2/18/2019 2/18/2019 2/19/2019 2/19/2019 2/19/2019 2/19/2019 2/19/2019 2/19/2019 2/19/2019 2/19/2019 2/20/2019 2/21/2019 2/21/2019 2/21/2019 2/21/2019 Clothing Home Living Home Living Jewelry Groceries Electronics Clothing Home Living Clothing Clothing Electronics Groceries Baby Home Living Groceries Automotive Home Living Electronics Clothing Automotive Baby Tools Groceries Clothing Tools Groceries Crafts Crafts Office Supplies Pets Automotive Clothing Pets Automotive Crafts Crafts Automotive Baby Automotive Jewelry Automotive $2.40 $6.35 $9.24 $9.62 $5.76 $8.16 $4.84 $9.88 $2.82 $4.25 $11.71 $10.64 $9.54 $10.18 $12.36 $5.81 $5.53 $6.19 $2.37 $8.99 $27.14 $10.34 $6.70 $7.28 $12.13 $11.47 $12.70 $10.59 $15.09 $51.20 $7.18 $3.67 $39.09 $9.11 $9.67 $6.19 $3.67 $19.73 $2.36 $3.84 $3.23 3 1 5 5 3 2 3 4 1 1 4 3 4 3 1 2 2 2 5 4 4 1 1 1 4 2 5 5 1 3 3 2 1 2 4 3 2 2 2 5 4 Denise Denise Marie George Stephen George Rickey Rickey Jennifer Jennifer Jennifer Jennifer Jennifer Jennifer Jennifer Marie Marie Marie Marie Marie Johnny George George George Kelly Kelly Johnny Johnny Stephen Stephen Stephen Stephen Stephen Stephen Stephen Stephen Stephen George George George George 10115 10115 10115 10115 10115 10116 10116 10117 10118 10119 10120 10121 10121 10121 10121 10122 10123 10124 10124 10124 10124 10124 10125 10125 10126 10126 10126 10126 10126 10126 10126 10126 10127 10127 10128 10128 10128 10128 10128 10128 10128 2/22/2019 2/22/2019 2/22/2019 2/22/2019 2/22/2019 2/23/2019 2/23/2019 2/23/2019 2/24/2019 2/25/2019 2/26/2019 2/26/2019 2/26/2019 2/26/2019 2/26/2019 2/27/2019 2/28/2019 2/28/2019 2/28/2019 2/28/2019 2/28/2019 2/28/2019 2/28/2019 2/28/2019 2/29/2019 2/29/2019 2/29/2019 2/29/2019 2/29/2019 2/29/2019 2/29/2019 2/29/2019 3/1/2019 3/1/2019 3/2/2019 3/2/2019 3/2/2019 3/2/2019 3/2/2019 3/2/2019 3/2/2019 Office Supplies Electronics Crafts Clothing Jewelry Groceries Jewelry Home Living Automotive Clothing Electronics Tools Home Living Crafts Electronics Clothing Jewelry Clothing Baby Electronics Jewelry Office Supplies Automotive Electronics Clothing Crafts Automotive Crafts Clothing Home Living Home Living Groceries Groceries Office Supplies Crafts Crafts Jewelry Office Supplies Baby Groceries Office Supplies $7.78 $11.97 $12.80 $4.57 $10.17 $7.18 $4.66 $6.19 $5.31 $7.81 $5.41 $10.07 $6.58 $4.05 $7.01 $6.08 $9.74 $5.41 $27.20 $8.38 $9.16 $14.67 $7.65 $7.87 $2.72 $5.50 $5.21 $4.84 $7.04 $6.43 $4.92 $10.08 $13.15 $18.97 $5.53 $11.98 $7.70 $3.63 $23.37 $12.90 $13.00 4 2 2 4 5 4 1 1 5 1 5 4 3 5 3 3 2 4 3 4 1 3 5 4 5 4 5 5 4 3 2 1 4 3 5 5 5 3 1 3 1 Johnny Johnny Johnny Johnny Johnny Jennifer Jennifer Renoldo Jennifer Stephen Denise Jennifer Jennifer Jennifer Jennifer Stephen Denise George George George George George Johnny Johnny Kelly Kelly Kelly Kelly Kelly Kelly Kelly Kelly George George Stephen Stephen Stephen Stephen Stephen Stephen Stephen 10128 10128 10128 10128 10129 10129 10129 10129 10129 10129 10130 10130 10130 10130 10130 10131 10132 10132 10133 10134 10135 10136 10137 10137 10137 10137 10138 10138 10139 10140 10140 10141 10142 10143 10143 10143 10143 10144 10145 10146 10146 3/2/2019 3/2/2019 3/2/2019 3/2/2019 3/2/2019 3/2/2019 3/2/2019 3/2/2019 3/2/2019 3/2/2019 3/3/2019 3/3/2019 3/3/2019 3/3/2019 3/3/2019 3/4/2019 3/5/2019 3/5/2019 3/5/2019 3/6/2019 3/7/2019 3/7/2019 3/7/2019 3/7/2019 3/7/2019 3/7/2019 3/8/2019 3/8/2019 3/8/2019 3/9/2019 3/9/2019 3/9/2019 3/10/2019 3/10/2019 3/10/2019 3/10/2019 3/10/2019 3/10/2019 3/11/2019 3/12/2019 3/12/2019 Home Living Office Supplies Office Supplies Electronics Pets Home Living Crafts Home Living Clothing Groceries Groceries Tools Home Living Baby Electronics Electronics Home Living Jewelry Crafts Tools Automotive Baby Automotive Electronics Electronics Home Living Tools Groceries Clothing Groceries Pets Automotive Home Living Groceries Electronics Office Supplies Crafts Home Living Tools Pets Pets $7.18 $8.80 $8.56 $3.75 $65.57 $3.54 $3.48 $3.20 $3.55 $5.21 $13.47 $9.86 $6.54 $9.07 $7.29 $9.18 $3.98 $5.10 $5.81 $6.13 $7.64 $15.06 $8.10 $11.37 $10.87 $10.40 $3.54 $9.41 $6.98 $6.71 $12.09 $5.27 $7.39 $7.81 $8.76 $20.77 $6.34 $5.04 $9.52 $62.80 $59.53 2 5 3 3 5 2 1 3 2 5 3 3 4 4 1 2 1 4 3 1 5 1 4 4 2 2 1 1 5 4 2 3 5 1 5 2 4 1 4 5 5 Stephen Stephen Stephen Stephen Nikki Nikki Nikki Nikki Nikki Nikki Marie Marie Marie Marie Marie Nikki Jennifer Jennifer Denise Denise Nikki George Denise Denise Denise Denise Denise Denise Johnny Nikki Nikki Denise Stephen George George George George Denise George Stephen Stephen 10146 10146 10146 10147 10148 10148 10149 10149 10149 10149 10149 10150 10150 10150 10150 10150 10150 10150 10151 10151 10151 10152 10152 10153 10153 10153 10154 10154 10154 10155 10155 10155 10156 10156 10156 10156 10156 10156 10156 10156 10156 3/12/2019 3/12/2019 3/12/2019 3/13/2019 3/14/2019 3/14/2019 3/14/2019 3/14/2019 3/14/2019 3/14/2019 3/14/2019 3/14/2019 3/14/2019 3/14/2019 3/14/2019 3/14/2019 3/14/2019 3/14/2019 3/15/2019 3/15/2019 3/15/2019 3/15/2019 3/15/2019 3/15/2019 3/15/2019 3/15/2019 3/16/2019 3/16/2019 3/16/2019 3/17/2019 3/17/2019 3/17/2019 3/17/2019 3/17/2019 3/17/2019 3/17/2019 3/17/2019 3/17/2019 3/17/2019 3/17/2019 3/17/2019 Groceries Pets Automotive Crafts Clothing Clothing Office Supplies Home Living Baby Office Supplies Crafts Home Living Automotive Groceries Crafts Home Living Crafts Groceries Home Living Automotive Pets Home Living Baby Groceries Office Supplies Pets Baby Crafts Groceries Automotive Groceries Electronics Home Living Home Living Automotive Home Living Baby Baby Electronics Automotive Automotive $6.23 $19.16 $6.63 $4.29 $3.51 $8.27 $17.98 $10.67 $16.07 $18.78 $7.82 $6.19 $5.85 $10.02 $3.90 $6.70 $13.26 $11.29 $3.95 $9.59 $22.50 $9.13 $28.47 $11.54 $16.40 $14.76 $19.46 $6.62 $12.05 $8.16 $4.90 $12.81 $5.10 $4.07 $10.25 $4.42 $22.13 $27.26 $12.99 $2.44 $7.62 2 4 2 2 1 1 5 1 2 3 5 3 2 4 2 5 5 5 2 3 2 4 3 5 3 5 3 2 2 4 3 4 1 1 4 4 1 3 5 2 3 Stephen Stephen Stephen Johnny Denise Denise Jennifer Jennifer Jennifer Jennifer Jennifer Kelly Kelly Kelly Kelly Kelly Kelly Kelly Marie Marie Marie Marie Marie Denise Denise Denise George George George Nikki Nikki Nikki Denise Denise Denise Denise Denise Denise Denise Denise Denise 10156 10156 10157 10157 10158 10158 10158 10158 10158 10158 10158 10159 10159 10159 10160 10160 10160 10160 10161 10161 10161 10161 10162 10162 10162 10162 10163 10163 10163 10163 10164 10164 10164 10164 10164 10164 10165 10166 10166 10166 10166 3/17/2019 3/17/2019 3/18/2019 3/18/2019 3/19/2019 3/19/2019 3/19/2019 3/19/2019 3/19/2019 3/19/2019 3/19/2019 3/19/2019 3/19/2019 3/19/2019 3/19/2019 3/19/2019 3/19/2019 3/19/2019 3/20/2019 3/20/2019 3/20/2019 3/20/2019 3/21/2019 3/21/2019 3/21/2019 3/21/2019 3/22/2019 3/22/2019 3/22/2019 3/22/2019 3/22/2019 3/22/2019 3/22/2019 3/22/2019 3/22/2019 3/22/2019 3/23/2019 3/24/2019 3/24/2019 3/24/2019 3/24/2019 Home Living Clothing Tools Pets Jewelry Baby Clothing Tools Groceries Pets Electronics Home Living Office Supplies Jewelry Office Supplies Automotive Pets Clothing Office Supplies Jewelry Jewelry Pets Home Living Office Supplies Baby Crafts Office Supplies Jewelry Tools Home Living Pets Electronics Pets Automotive Home Living Tools Clothing Home Living Home Living Home Living Electronics $9.53 $4.56 $14.25 $38.96 $3.55 $15.26 $9.07 $7.35 $11.63 $55.80 $10.91 $3.73 $21.36 $10.90 $7.70 $2.51 $40.98 $8.34 $15.77 $5.70 $3.36 $48.72 $6.06 $20.37 $23.32 $5.33 $14.38 $9.41 $12.73 $10.10 $59.32 $3.47 $18.15 $2.17 $8.00 $3.53 $8.20 $6.28 $4.38 $5.36 $6.52 3 5 2 2 4 2 2 4 1 1 2 1 5 3 2 3 5 1 4 5 3 2 4 2 2 3 2 2 2 3 4 4 1 1 1 5 4 4 1 1 1 Denise Denise Nikki Nikki Jennifer Jennifer Jennifer Jennifer Jennifer Jennifer Jennifer Marie Marie Marie Nikki Nikki Nikki Nikki Rickey Rickey Rickey Rickey Jennifer Jennifer Jennifer Jennifer Kelly Kelly Kelly Kelly Rickey Rickey Rickey Rickey Rickey Rickey Stephen Stephen Stephen Stephen Stephen 10166 10167 10167 10168 10168 10168 10168 10168 10169 3/24/2019 3/25/2019 3/25/2019 3/26/2019 3/26/2019 3/26/2019 3/26/2019 3/26/2019 3/27/2019 Jewelry Groceries Groceries Crafts Home Living Electronics Home Living Home Living Electronics $6.31 $4.57 $9.14 $11.93 $3.90 $2.54 $9.43 $5.53 $6.43 3 3 4 3 2 2 5 1 2 Stephen Rickey Rickey Kelly Kelly Kelly Kelly Kelly Jennifer Commission Percentage Commission Amount 4.10% 1.00% 1.30% 4.10% 1.10% 3.00% 1.00% 1.70% 4.80% 1.30% 4.10% 4.10% 1.30% 4.10% 1.10% 3.00% 1.10% 3.90% 3.00% 4.10% 4.10% 3.00% 5.70% 5.70% 4.80% 3.00% 4.10% 1.10% 1.10% 1.10% 2.90% 3.90% 1.70% 3.90% 5.70% 1.10% 1.00% 3.90% 3.00% 4.80% 1.10% 1.30% 3.00% 1.10% 5.70% 1.00% 3.90% 5.70% 1.30% 2.90% 4.10% 2.90% 3.90% 1.70% 1.00% 1.10% 4.10% 1.30% 1.70% 1.70% 1.10% 1.10% 1.00% 4.80% 1.10% 3.00% 1.00% 1.10% 1.10% 5.70% 1.10% 1.00% 2.90% 1.70% 4.80% 1.30% 4.80% 1.30% 2.90% 3.00% 2.90% 4.10% 3.90% 4.80% 5.70% 4.80% 3.90% 3.00% 1.10% 1.10% 1.70% 4.80% 2.90% 1.30% 4.10% 5.70% 4.80% 1.00% 1.70% 3.90% 1.30% 1.30% 5.70% 1.10% 4.80% 5.70% 3.90% 1.30% 4.10% 4.10% 1.00% 1.00% 3.90% 1.00% 5.70% 3.00% 5.70% 2.90% 1.70% 4.80% 5.70% 5.70% 1.10% 1.10% 3.00% 3.90% 1.30% 1.10% 1.70% 1.00% 1.00% 1.70% 5.70% 1.10% 1.30% 4.10% 1.00% 1.10% 1.10% 4.10% 3.90% 4.10% 5.70% 3.90% 1.70% 2.90% 3.00% 1.70% 1.10% 2.90% 4.10% 2.90% 2.90% 1.10% 1.30% 1.30% 2.90% 1.30% 3.00% 3.00% 1.10% 1.10% 4.10% 1.30% 4.10% 1.10% 1.00% 3.90% 1.70% 3.00% 1.10% 2.90% 1.30% 1.30% 1.10% 1.30% 3.90% 3.90% 5.70% 4.80% 1.30% 1.00% 1.10% 3.00% 1.30% 1.70% 1.30% 4.10% 4.80% 1.10% 1.10% 4.10% 1.10% 3.00% 3.00% 4.80% 1.30% 1.10% 1.70% 3.90% 5.70% 4.80% 3.00% 2.90% 4.10% 1.30% 3.00% 3.90% 3.00% 1.10% 1.10% 3.90% 1.70% 4.80% 1.00% 3.90% 4.80% 3.90% 1.00% 4.80% 2.90% 1.10% 2.90% 1.10% 4.80% 1.10% 1.10% 1.10% 1.30% 3.00% 4.80% 4.10% 3.90% 1.30% 1.70% 5.70% 4.80% 1.70% 5.70% 4.10% 1.00% 3.00% 1.70% 1.10% 1.00% 1.10% 1.30% 1.10% 1.10% 5.70% 4.80% 1.00% 2.90% 2.90% 4.10% 4.80% 1.10% 1.10% 1.30% 1.10% 4.10% 3.90% 1.10% 1.00% 4.80% 4.10% 4.10% 1.10% 1.70% 3.00% 4.80% 1.00% 3.90% 5.70% 1.10% 2.90% 5.70% 3.00% 1.00% 1.00% 5.70% 5.70% 1.00% 3.00% 2.90% 2.90% 1.10% 3.90% 3.90% 1.10% 4.80% 3.00% 1.10% 3.90% 1.10% 1.10% 3.00% 4.80% 5.70% 3.90% 4.80% 1.30% 3.90% 3.00% 1.10% 1.30% 5.70% 4.10% 4.80% 1.10% 4.10% 4.80% 1.70% 1.70% 1.00% 2.90% 1.30% 1.10% 2.90% 1.30% 1.70% 1.70% 1.30% 5.70% 1.30% 1.10% 1.30% 1.00% 3.00% 1.70% 1.10% 1.10% 4.80% 1.10% 3.90% 1.30% 1.10% 3.00% 4.10% 3.90% 1.70% 3.00% 1.10% 1.10% 1.10% 5.70% 3.00% 1.10% 1.00% 1.30% 3.00% 1.10% 1.70% 1.30% 1.70% 1.10% 3.90% 3.90% 4.80% 4.80% 1.00% 1.70% 1.70% 1.10% 1.00% 5.70% 4.80% 1.00% 3.90% 1.00% 1.00% 3.00% 2.90% 3.90% 1.70% 3.90% 1.10% 4.80% 4.80% 4.10% 3.90% 5.70% 3.00% 3.00% 3.90% 1.10% 1.70% 4.10% 1.30% 5.70% 1.30% 3.00% 3.00% 3.90% 4.10% 4.80% 1.10% 4.80% 2.90% 1.30% 3.90% 4.80% 3.00% 1.00% 1.70% 3.90% 4.10% 2.90% 2.90% 4.80% 2.90% 1.30% 1.70% 1.10% 1.10% 1.00% 3.90% 5.70% 1.00% 1.70% 3.90% 1.30% 4.80% 1.70% 3.90% 1.70% 4.80% 3.90% 1.30% 2.90% 3.90% 5.70% 4.80% 1.00% 2.90% 5.70% 1.70% 4.80% 1.30% 4.80% 3.00% 3.90% 3.90% 1.30% 3.90% 5.70% 5.70% 3.00% 1.30% 1.30% 3.90% 1.10% 4.10% 2.90% 1.10% 5.70% 1.10% 4.10% 4.80% 2.90% 3.00% 3.90% 1.00% 1.10% 1.00% 1.30% 2.90% 1.10% 1.00% 1.10% 1.10% 2.90% 3.90% 1.00% 5.70% 1.70% 1.00% 1.10% 4.10% 3.90% 2.90% 3.00% 2.90% 1.30% 3.90% 4.10% 1.10% 3.90% 3.90% 3.90% 3.00% 1.10% 4.80% 4.80% 1.70% 3.90% 3.00% 3.90% 3.90% 3.00%
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hi, Please check and give me a feedback. Tell me if anything needs to be changed. 😊

Invoice Number
Sale Date
Item Category
10001
1/1/2019 Tools
10002
1/2/2019 Office Supplies
10002
1/2/2019 Automotive
10002
1/2/2019 Tools
10002
1/2/2019 Clothing
10002
1/2/2019 Electronics
10003
1/3/2019 Office Supplies
10003
1/3/2019 Crafts
10004
1/4/2019 Groceries
10004
1/4/2019 Automotive
10004
1/4/2019 Tools
10004
1/4/2019 Tools
10004
1/4/2019 Automotive
10005
1/4/2019 Tools
10005
1/4/2019 Jewelry
10006
1/4/2019 Electronics
10007
1/5/2019 Clothing
10008
1/6/2019 Home Living
10009
1/6/2019 Electronics
10010
1/6/2019 Tools
10010
1/6/2019 Tools
10010
1/6/2019 Electronics
10010
1/6/2019 Baby
10010
1/6/2019 Baby
10011
1/6/2019 Groceries
10011
1/6/2019 Electronics
10012
1/6/2019 Tools
10012
1/6/2019 Jewelry
10012
1/6/2019 Jewelry
10012
1/6/2019 Clothing
10013
1/7/2019 Pets
10013
1/7/2019 Home Living
10014
1/7/2019 Crafts
10014
1/7/2019 Home Living
10014
1/7/2019 Baby
10015
1/7/2019 Clothing
10015
1/7/2019 Office Supplies
10016
1/7/2019 Home Living
10017
1/7/2019 Electronics
10017
1/7/2019 Groceries
10018
1/7/2019 Clothing
10019
1/7/2019 Automotive
10019
1/7/2019 Electronics
10019
1/7/2019 Clothing
10019
1/7/2019 Baby
10019
1/7/2019 Office Supplies

Individual Price
3.22
12.36
7.35
3.03
9.04
6.32
11.49
10.98
12.33
11.24
12.72
10.51
2.3
12.26
5.55
6.94
5.52
9.41
12.45
12
13.52
6.33
9.52
26.4
10.05
12.29
13.66
9
8.27
5.85
23.94
9.4
10.79
9.51
23.29
8.12
11.55
6.76
9.21
6.66
5.6
6.4
3.93
2.68
18.29
24.14

Quantity Sold
4
5
4
5
1
2
3
3
2
4
4
3
1
1
5
4
1
4
1
2
1
2
1
3
5
2
2
1
3
4
3
5
5
5
5
3
4
2
1
1
1
4
4
4
3
5

Subtotal
12.88
61.8
29.4
15.15
9.04
12.64
34.47
32.94
24.66
44.96
50.88
31.53
2.3
12.26
27.75
27.76
5.52
37.64
12.45
24
13.52
12.66
9.52
79.2
50.25
24.58
27.32
9
24.81
23.4
71.82
47
53.95
47.55
116.45
24.36
46.2
13.52
9.21
6.66
5.6
25.6
15.72
10.72
54.87
120.7

10020
10020
10020
10020
10020
10021
10022
10023
10024
10024
10024
10025
10025
10026
10026
10026
10026
10026
10027
10027
10028
10028
10028
10028
10028
10029
10029
10030
10030
10030
10031
10031
10031
10031
10031
10031
10031
10032
10032
10032
10033
10033
10033
10033
10034
10034
10034

1/7/2019
1/7/2019
1/7/2019
1/7/2019
1/7/2019
1/7/2019
1/7/2019
1/8/2019
1/9/2019
1/9/2019
1/9/2019
1/10/2019
1/10/2019
1/11/2019
1/11/2019
1/11/2019
1/11/2019
1/11/2019
1/12/2019
1/12/2019
1/13/2019
1/13/2019
1/13/2019
1/13/2019
1/13/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/15/2019
1/15/2019
1/15/2019
1/15/2019
1/16/2019
1/16/2019
1/16/2019

Home Living
Baby
Automotive
Pets
Tools
Pets
Home Living
Crafts
Office Supplies
Jewelry
Tools
Automotive
Crafts
Crafts
Clothing
Jewelry
Office Supplies
Groceries
Clothing
Electronics
Office Supplies
Jewelry
Jewelry
Baby
Jewelry
Office Supplies
Pets
Crafts
Groceries
Automotive
Groceries
Automotive
Pets
Electronics
Pets
Tools
Home Living
Groceries
Baby
Groceries
Home Living
Electronics
Jewelry
Jewelry
Crafts
Groceries
Pets

6.23
19.62
4.08
73.9
6.37
65.7
10.21
12.2
5.11
6.11
9.02
3.67
13.69
13.38
3.01
9.92
4.02
10.92
2.31
10.4
19.03
8.11
10.73
14.26
6.75
20.55
12.37
11.78
6.03
7.83
8.81
3.43
75.52
7.88
75.53
11.38
11.1
8.95
17.55
4.97
2.88
11.87
5.56
9.03
12.01
7.86
29.87

3
5
3
4
1
3
1
5
5
1
5
1
3
3
2
1
2
3
1
1
2
2
4
2
5
5
1
2
3
4
2
5
2
5
5
4
4
2
3
1
2
4
5
2
3
1
2

18.69
98.1
12.24
295.6
6.37
197.1
10.21
61
25.55
6.11
45.1
3.67
41.07
40.14
6.02
9.92
8.04
32.76
2.31
10.4
38.06
16.22
42.92
28.52
33.75
102.75
12.37
23.56
18.09
31.32
17.62
17.15
151.04
39.4
377.65
45.52
44.4
17.9
52.65
4.97
5.76
47.48
27.8
18.06
36.03
7.86
59.74

10034
10034
10034
10034
10034
10034
10035
10035
10036
10036
10037
10037
10038
10038
10038
10038
10038
10039
10040
10041
10042
10042
10043
10044
10044
10044
10045
10046
10047
10048
10048
10048
10048
10048
10048
10048
10049
10049
10049
10049
10050
10050
10050
10050
10051
10051
10051

1/16/2019
1/16/2019
1/16/2019
1/16/2019
1/16/2019
1/16/2019
1/16/2019
1/16/2019
1/17/2019
1/17/2019
1/17/2019
1/17/2019
1/17/2019
1/17/2019
1/17/2019
1/17/2019
1/17/2019
1/17/2019
1/18/2019
1/18/2019
1/19/2019
1/19/2019
1/20/2019
1/20/2019
1/20/2019
1/20/2019
1/21/2019
1/21/2019
1/21/2019
1/21/2019
1/21/2019
1/21/2019
1/21/2019
1/21/2019
1/21/2019
1/21/2019
1/22/2019
1/22/2019
1/22/2019
1/22/2019
1/22/2019
1/22/2019
1/22/2019
1/22/2019
1/22/2019
1/22/2019
1/22/2019

Automotive
Tools
Baby
Groceries
Office Supplies
Crafts
Home Living
Automotive
Automotive
Baby
Jewelry
Groceries
Baby
Home Living
Automotive
Tools
Tools
Office Supplies
Office Supplies
Home Living
Office Supplies
Baby
Electronics
Baby
Pets
Crafts
Groceries
Baby
Baby
Jewelry
Jewelry
Electronics
Home Living
Automotive
Jewelry
Crafts
Office Supplies
Office Supplies
Crafts
Baby
Jewelry
Automotive
Tools
Office Supplies
Clothing
Jewelry
Tools

10.67
6.98
19.4
7.93
18.89
11.73
9.81
4.37
1.97
7.57
5.4
11.58
24.23
3.25
10.42
3.05
15.94
5.59
21.94
7
10.63
13.24
3.67
22.82
19.42
10.96
10
18.08
28.51
3.09
5.58
3.54
10.98
3.81
3.41
8.75
17.75
20.82
7.2
27.76
8.81
11.11
5.77
4.59
2.39
4.22
3.55

5
3
3
4
3
2
4
4
1
5
4
2
5
5
4
4
1
5
2
1
4
5
4
2
3
5
3
1
1
3
5
1
2
3
4
5
2
4
4
2
4
2
3
4
5
4
1

53.35
20.94
58.2
31.72
56.67
23.46
39.24
17.48
1.97
37.85
21.6
23.16
121.15
16.25
41.68
12.2
15.94
27.95
43.88
7
42.52
66.2
14.68
45.64
58.26
54.8
30
18.08
28.51
9.27
27.9
3.54
21.96
11.43
13.64
43.75
35.5
83.28
28.8
55.52
35.24
22.22
17.31
18.36
11.95
16.88
3.55

10052
10052
10052
10053
10053
10054
10054
10054
10055
10055
10056
10057
10057
10057
10057
10058
10058
10058
10059
10060
10060
10060
10060
10060
10060
10060
10060
10061
10061
10062
10062
10062
10062
10063
10063
10063
10063
10063
10063
10063
10063
10063
10063
10063
10063
10063
10064

1/23/2019
1/23/2019
1/23/2019
1/23/2019
1/23/2019
1/24/2019
1/24/2019
1/24/2019
1/25/2019
1/25/2019
1/26/2019
1/26/2019
1/26/2019
1/26/2019
1/26/2019
1/27/2019
1/27/2019
1/27/2019
1/27/2019
1/28/2019
1/28/2019
1/28/2019
1/28/2019
1/28/2019
1/28/2019
1...


Anonymous
Excellent resource! Really helped me get the gist of things.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags