USE EXCEL PLEASE TO DO THE PROBLEM AND I CAN OFFER EXTRA EXTRA POINTS IF YOU GUY
ID: 2449185 • Letter: U
Question
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.
Explanation / Answer
$ 64,238
an appropraite chart illustrating total potential dollar sales for each candy type.
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. Ans) Candy/ Pounds Per pound Total Sales Valentines Day 18990 $ 4.50 $ 85,455 Easter Day 12925 $ 4.50 $ 58,163 Halloween 14275 $ 4.50$ 64,238
Chrishmas 15975 $ 4.50 $ 71,888 Total Candy 62165 $ 4.50 $ 279,743an appropraite chart illustrating total potential dollar sales for each candy type.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.