Smart purchasing
It is time to start thinking more about how and what results you want to report. The management team mentioned in a meeting about your preliminary results if there is a relation between COGS, amount of sales, and revenue, specifically when purchasing new stock. Your task is to use a COGS-to-revenue ratio to guide Acropolis Retail when purchasing new stock. Items with low COGS-to-revenue ratios generate more profit since their costs are lower than their selling prices. The company can then identify which items are better to purchase!
We recommend you to keep working in your own workbook but if you lost progress you can open 2_5_preliminary_results_solution.twbx
from the Workbooks folder on the Desktop.
This exercise is part of the course
Case Study: Inventory Analysis in Tableau
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
