The same company from the previous sections needs to be able to review sales by their product manufacturer. This same BI reporting can be used for any information that is tracked in inventory categories.
This company sells all across the U.S., and sells products from a variety of manufacturers. They have a direct sales force, a physical showroom where customers can purchase in person, and a web presence where customers can place orders directly via their website.
They use inventory item category 1 to store the manufacturer of each item. This field is used because they can either purchase items directly from the manufacturer or a wholesale distributor. Although the vendors change, the item's manufacturer does not.