Action To Save Candy Store

This is a project to practice Excel skills.

Problem

The problem is that my candy store is losing sales, kids like my candies taste but the color is boring. I use Excel to create data and figure out how to save the store.

Candy In The Package

So when I counted the candy I found out pink is the most used color in the package!

mintiiiiiiiiiiiiiiiiiiiiiiii-nooooooooo

My Survey

This is my survey on which color (flavor) kids like most. I see yellow, pink, and green are the most popular while black, orange, and brown are the least.
candy-fac

candi-faci-3

My Plan to Save the Factory

I won’t add more candy into the bag because it’s more money for the factory and it wasn’t the problem. I will take the non-fun colors out (orange, black, and brown),  and the problem will be fixed.  I’ll add more yellow, green, pink, red, and blue.