3 Billie Mendoza is the purchasing manager for a medium-sized all-suite hotel with a restaurant and a banquet hal. She needs to create the food purchase orders 4 for tomorrow, and she wants to make sure that she is getting the best price for the best quality and service. At the beginning of this week, Billie received bids on produce items from Vilage Produce, City Produce, and Country Produce. She has listed these prices in the following price comparison sheet 5 6 Identify the best bid price and best company for each of Bilie's produce items. (Spreadsheet hint: Use the MIN function in the Best Bid S column) 7 B 9 10 Price Comparison Sheet 11 Item Description Village City Country Best Best Last Produce Produce Produce Bid $ Company Price 12 Quote Paid 13 Avocados 48 ct. Case 61.80 $ 60.30 $ 59.46 $57.94 14 Cauliflower 12 ct Case $ 12.80 $ 12.90 $ 13 27 $ 1326 15 Cucumbers Medium Case $ 11.10 $ 11.52 $ 10.91 $ 11.34 16 Grapes Red Seedless Lug $ 19.32 $ 19.50 $ 19.14 $18.72 17 Lettuce Green Leaf, 24 ct Case $ 9.53 $ 9.84 $ 10.27 $ 10.02 18 Lettuce Romaine, 24 ct. Case 17.75 $ 17.82 $ 18.22 $ 18.10 Q1 Q2 Q3 Q & Q9 Q 11 Read Unit en una Umeweza is the purchasing manager for a medium-sized all-suite hotel with a restaurant and a banquet hall. She needs to create the food purchase orders for tomorrow, and she wants to make sure that she is getting the best price for the best quality and service. At the beginning of this week, Bilie received bids on produce items from Village Produce, City Produce, and Country Produce. She has listed these prices in the following price comparison sheet. Identify the best bid price and best company for each of Billie's produce items. (Spreadsheet hint: Use the MIN function in the Best Bid 5 column) . Price Comparison Sheet Item Description Unit Village Produce City Produce Country Produce Best Bid $ Best Company Quote Avocados Cauliflower Cucumbers Grapes Lettuce Lettuce Pears Q1 48 ct Case 12 ct. Case Medium Case Red Seedless Lug Green Leaf, 24 ct. Case Romaine, 24 ct. Case D'Anjou Case Q2 Q3 Q8 Q9 Q11 $ $ $ $ $ $ $ 61.80 $ 12.80 $ 11.10 $ 19.32 $ 9.53 $ 17.75 $ 20.82 $ 60.30 $ 12.90 $ 11.52 S 19.50 $ 9.84 S 17.82 S 20.58 S 59.46 13.27 10.91 19.14 10.27 18.22 20.64 Last Price Pald $ 57.94 S 13.26 S 11.34 $ 18.72 $ 10.02 $ 18.10 $20 62 Lug Medium Case Red Seedless Green Leaf, 24 ct. Case Romaine, 24 ct. Case D'Anjou Case Green Bell, med Case 7 ct. Case B Reds 50-lb. Bag Peeled, Large 25-1b. Bag Yellow #2 + 30-1b. Case Driscoll Flat $ $ $ S $ $ $ $ $ $ $ 11.10 $ 19.32 $ 9.53 $ 17.75 $ 20.82 $ 8.30 $ 10.50 $ 15.06 $ 17.52 $ 8.55 $ 18.29 $ 11.52 $ 19.50 $ 9.84 $ 17.82 $ 20.58 $ 8.38 $ 10.38 $ 14.82 $ 17.22 $ 8.71 $ 18.06 $ 10.91 19.14 10.27 18.22 20.64 9.28 10.68 14.88 17.28 8.98 17.10 - o oo oooooo 11.34 $ 18.72 $ 10.02 $ 18.10 20.62 9.02 10.08 14.98 17.18 9.10 18.30 If Billie was going to create a purchase order just for Village Produce, what items would B she likely put on the purchase order based solely on bid prices? Type your answer in the box below. 1 Answer: 2 3