USE EXCEL PLEASE TO DO THE PROBLEM AND I CAN OFFER EXTRA EXTRA POINTS IF YOU GUYS CAN DO IT FAST.

Mike's Candy Shop Board of Directors is considering revising its production figures. They have asked you to create a worksheet they can use in making this decision. The worksheet should show the total number of pounds of each candy ordered for each holiday, total candy ordered for the four holidays & potentail dollar sales for each type of candy. Include an appropraite chart illustrating total potential dollar sales for each candy type. Then produce a document to handout to the borad members summarizing your findings.

_________________________________

DATA:

Mike's candy shop is all year, but most of the shop's sales revolves around four holidays: Valentine's Day (18,990 pounds of candy), Easter (12,925 pounds of candy), Halloween (14,275 pounds of Candy ), and Christmas (15,975 pounds of candy). on and around these holidays, 31% of the store's output is chocolate creams sell for $4.50 per pound, the Gummy Bears for $2.75 per pound, the jelly Beans for $ 2.50 per pound, and the Mints for $ 1.75 per pound.