Required information
[The following information applies to the questions displayed below.]
Keywords: Customer Profitability, Inventory Management, Customer Relationship Management
Decision-Making Context: Merchandising companies sell products to customers. They make money by selling the products for more than what they paid. In this lab, we compute the gross margin for each product to identify the companys most profitable products. This analysis allows merchandising companies to focus their efforts on selling the most profitable products, which in turn helps them make more profits.
Required:
- Create calculated fields for the gross margin and gross margin percentage.
- Create a histogram to visualize the distribution of gross margin percentage across SKUs.
- Adjust the automated bin size to 0.025.
- Create a list of SKUs in the highest bin.
Data:
Specify the Question: Which products (SKUs) are the most profitable to sell?
Obtain the Data: Fancy Fruits is a fictitious mail-order business that sells exotic fruit from around the world to customers throughout the United States. The company keeps a price list for each product. We will work from this price list to find the items that are most profitable per dollar of sales.
Analyze the Data: Refer to lab 1.3 in your text for additional instructions and steps.
Upload one Word or PDF document containing all of your screenshots for this Lab using the button below.
Note: Please submit your file attachment response in one of the approved file formats; Word file (.doc or .docx), Excel file (.xls or .xlsx), or PDF. To submit photo or image files please paste them into Word or PDF. Consult with your instructor as needed on their preferred file attachment format.
- Take a screenshot of your histogram, paste it into a Word document named Lab 1.3 Tableau Submission.docx, and label the screenshot Submission 1.
- Take a screenshot of your dashboard, paste it into the same Word document, and label the screenshot Submission 2.
see the video and do the same
Requirements: the same Required
Get fast, custom help from our academic experts, any time of day.
Place your order now for a similar assignment and have exceptional work written by our team of experts.
Secure
100% Original
On Time Delivery