Creme Workbook Flavors Worksheet Stores Worksheet HCreme Workbook HFlavors Works

Question

Creme Workbook

Flavors Worksheet

Stores Worksheet

HCreme Workbook

HFlavors Worksheet

Flavor #Pints Containers Sold Current Qtr #Gallons Containers Sold Current Qtr # Tubs Used Current Qtr Vanilla            164,254                  6,297.00      1,043.77 Chocolate            215,191                15,549.00      6,550.37 Strawberry             27,503                  3,231.00      1,887.84 Maple Walnut             57,513                  2,489.00        594.46 Praline             76,236                  2,532.00        745.07 Butter Pecan             38,361                  2,571.00        147.37 Chocolate Chip             99,103                  4,691.00      1,981.00 Mint Chocolate Chip             91,186                  1,229.00        354.01 Cookie Dough             91,233                  3,040.00      1,023.65 Rocky Road             46,187                  3,430.00        890.76 Fudge Swirl             51,974                  2,800.00      1,234.45 Peach             65,808                  1,423.00      1,233.91 Pumpkin                    -                             -                 -   Marshmallow Fudge               8,467                    722.00        243.97 Coffee            228,592                  5,547.00      2,313.05 Mocha Chip            130,943                  4,311.00        185.74 Raspberry                    -                             -                 -   Watermelon             54,154                  2,692.00      1,478.99 Cinnamon Spice                    -                             -                 -   Chocolate Fudge             47,952                  3,083.00        175.68 Cherry Vanilla             69,125                  3,536.00      1,597.04 Level 1 - Analyzing Sales for Crèmes Ice Cream Judd Hemming is the castern regional marketing manager for Crèmes Ice Cream. Each quarter, he completes two separate analyses: an analysis comparing ice cream flavor sales volumes from all regional locations with the same quarter sales volumes from the previous year, and an analysis comparing total sales in dollars, including mean, median, mode, and standard deviation, of sales by store Sales by Flavor in Gallons The first analysis, sales by flavor, compares the total quantities sold in gallons. The data collected provides for each flavor 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 sundaces 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

Explanation / Answer

Answer:

By using , given data

Firstly ,i am not giving you the working of your question ,since you have attached screen shots of your excel. it would be better if you could attached the excel book or even copy paste the basic data so we could work on the same.

However, I can explain, you how u can work out question 8 and 9.

(8).

As compared to PY the company is doing better in terms of sales.

(9).We have to calculate price per gallon of ice cream .you can use use mean of sales value and mean of sales quantity to arrive at average sale price per gallon.

You have to calculated the current period mean of sales qty = 23,120( flavours sheet) and Sales value mean = 9044 from (stores sheet).

Thus ,average price per gallon = 9044/23120 = 0.39$ / gallons.

Current Year Previous Year Change % Change Mean 9044 8817 227 3% Median 8935 8000 935 12% Mode 9361 5500 3861 70% Standard Deviation 5195 2920 2275 78%

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.