Question

Show the formula

CASE PROBLEMS Level 1- Analyzing Sales for Crèmes Ice Cream quarter, he completes two separate analyses: an analysis comparing ice cream flavor sale volumes from all regional locations with the same quarter sales volumes from the previou year and an analysis comparing total sales in dollars, including mean, median, mode, and standard deviation, of sales by store. Judd Hemming is the eastern regional marketing manager for Crèmes Ice Cream. Eac The first analysis, sales by flavor, compares the total quantities sold in gallons. The data collected lists for each flavor of the number of pints, gallons, and 10-gallon tubs sold for all stores. Pints and gallons are sold directly to the public, whereas 10-gallon tubs are used for in-store sales of cones, cups, and specialty items, such as sundaes and banana splits. To eliminate any impact of pricing changes or special promotions, Judd simply uses the ice cream volumes in gallons to compare sales by flavor. Judd has asked for your help this quarter in completing this analysis. Judd created two workbook files: Creme.xlsx, which contains the current quarter's sales on a worksheet named Flavors, and HCreme.xlsx, which contains the corresponding historical quarterly data for the previous year on a werksheet named HFlavors. For ease of data handling, the flavors in both data sets are in identical order except for two new flavors introduced this year, which appear at the bottom of the current data set. Keep in mind the following conversions when analyzing this data: There are 8 pints per gallon. Each tub holds 10 gallons

Answer 1