I need the HW ASAP!

profileOliver97
alhassan_go16_xl_ch02_grader_2g_as.xlsx
Home>Computer Science homework help>I need the HW ASAP!

Sheet1

Valley View Facility: Inventory Status of Condiments
As of June 30, 2014
Total Items in Stock
Average Price
Median Price
Lowest Price
Highest Price
Relish Types:
Relish Total Quantity:
Quantity in Stock Item #/Category Item Name Retail Price Size
45 1956-Olives Moroccan 7.59 8 oz.
46 1899-Chutney New England Cranberry 6.99 8 oz.
46 1898-Pesto Basil and Parsley 9.99 12 oz.
152 1897-Chutney Spicy Plum 7.95 9 oz.
89 1456-Relish Hot and Spicy Corn 8.59 12 oz.
56 1896-Mustard Red Raspberry Wasabi 8.95 8 oz.
129 1798-Chutney Portuguese Membrillo 10.99 12 oz.
109 1285-Relish Homemade Hot dog 8.58 10 oz.
68 1654-Relish Orange Fennel/Caper 9.35 10 oz.
52 1652-Olives Stuffed Manzanilla 4.95 6 oz.
45 1645-Olives Organic Arbequina 39.95 32 oz.
43 1645-Spread Roasted Garlic 8.59 11 oz.
66 1635-Relish Pomegranate Molasses 9.65 12 oz.
149 1569-Olives Pitted Variety 14.85 12 oz.
243 1568-Olives Variety Pack 15.85 16 oz.
102 1565-Spread Vietnamese Dipping Sauce 14.55 15 oz.
29 1565-Olives Stuffed Greek 8.99 7 oz.
75 1564-Olives Garlic/Lemon Green 7.95 11 oz.
85 1564-Spread Pork Sausage Ragu 9.95 12 oz.
46 1564-Pesto Pine Nut Cilantro 8.98 6 oz.
42 1465-Relish Roasted Onion 7.52 12 oz.
89 1548-Spread Tomato Sauce with Pancetta 12.89 16 oz.
24 1545-Mustard Balsamic Vinaigrette 8.85 9 oz.
85 1528-Chutney Strawberry 14.85 20 oz.
68 1523-Mustard Maine Maple 6.55 8 oz.
75 1498-Spread Red Clam 8.59 11 oz.
75 1490-Spread Sicilian Bruschetta 12.85 14 oz.
135 1489-Spread Black Olive 14.85 15 oz.

Sheet2

Valley View Facility: Inventory Status of Toppings
As of June 30, 2014
Total Items in Stock
Average Price
Median Price
Lowest Price
Highest Price
Salsa Types:
Salsa Total Quantity:
Quantity in Stock Item #/Category Item Name Retail Price Size
87 9952-Salsa Verde Hot 8.95 13 oz.
235 8582-Syrup Dark Chocolate 15 17 oz.
45 8256-Jam Tangerine Marmalade 7.59 13 oz.
42 6255-Sauce Artichoke Pesto 9.95 8 oz.
153 5664-Dressing Olive Oil and Balsamic 6.89 13 oz.
95 5636-Sauce Classic Alfredo 9.59 14 oz.
182 5635-Sauce Chocolate Peanut Butter 8.45 9 oz.
185 5522-Sauce Bittersweet Chocolate 8.95 12 oz.
110 5463-Dressing Balsamic Fig 8.59 11 oz.
285 4822-Salsa Black Bean 6.5 8 oz.
126 4652-Dressing Creamy Asiago 8.75 13 oz.
108 4625-Jam Raspberry Peach 4.75 4 oz.
385 4597-Sauce Roasted Garlic Basil 6.95 8 oz.
210 4587-Sauce Maple Chipotle 7.56 11 oz.
185 4567-Dressing Creamy Asiago 6.95 11 oz.
22 1630-Salsa Spicy Corn Relish 6.55 11 oz.
54 3933-Dressing Chocolate Orange 6.95 10 oz.
82 3252-Syrup European Crock 29.95 16 oz.
108 2895-Dressing Black Bean 8.59 11 oz.
175 2850-Jam Strawberry 4.75 4 oz.
42 2587-Salsa Habanero Mango 7.75 9 oz.
32 2469-Dressing Roasted Salmon 6.95 10 oz.
110 2389-Syrup Cinnamon Apple 6.95 9 oz.
14 2348-Dressing Green Goddess 7.45 15 oz.
87 2347-Dressing Cilantro Lime 7.59 11 oz.
85 1004-Salsa Black Bean 6.95 8 oz.
35 2133-Sauce Habanero Mango 7.25 12 oz.
49 1783-Dressing Roasted Garlic Oil 6.75 9 oz.