You are a Junior Analyst working for wholesale party supply company. Your company sells: Balloons, Candy, Costumes, Seasonal Decorations, and Cake Making/Decorating Supplies. These are not sold individual, but as cases which also makes for easy storage. The company mainly sell to small local businesses, however there are a few larger clients that make up some of your larger sales and your company has put together specific custom packages of products together for them.

Currently, the company stocks all products each month in the warehouse. Your boss wants to know if there are potential ways to increase revenue, and if there should be any changes made to this method of stocking products in the warehouse. The only information she can provide you is a list of all their sales over the last year. She knows this isnt the best use of space in the warehouse, as some months they have products that dont move, and other months some products run out (missing out on a greater sales opportunity) however, she doesnt have any data as to which months/products have run out but knows it has been during high demand seasonal times.

Your boss has provided you no other direction other than this, as she knows you were hired for your excellent critical thinking, problem-solving skills, and ability to make reasonable assumptions should information not be presented.

Your role as an analyst is to critically assess the information provided to you (Excel document) and present it back to your boss with your findings and recommendations. Utilize what you have learned so far in this class by applying multiple tools and visuals to determine what the data is saying and make your recommendations according to what you find.