4. Billie Mendorn in the purchasing manager for a medium-sized maite hotel with tourant 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 qunlity and service. At the beginning of this week, Billie 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 (Sprendshot hint: Use the MIN function in the Best Bid column.) Price Comparison Sheet Best Bids Best Company Quote Item Description Avocados 48 ct Cauliflower 12 ct Cucumbers Medium Grapes Red Seedless Lettuce Kreen Leaf, 24 ct Lettuce Romaine, 24 et Pears Danjou Peppers Green Bell, Med. Pineapples Potatoes B Reds Potatoes Peeled. Large Squash Yellow 1/2 Strawberries Driscoll Unit Cause Case Case Lug Case Case Casc Case Case SO Bae 250 Bar 300 Case Village Produce $61.80 12.80 11.10 19.32 9.53 17.75 20.82 8.30 10.50 15.06 17.52 8.55 18.29 City Produce 560.30 12.90 11.52 19.50 9.84 17.82 20.58 8.38 10.38 14.82 17.22 8.71 18.06 Country Produce $59.46 13.27 10.91 19.14 10.27 18.22 20.64 9.28 10.68 14.88 1728 8.98 17.10 Last Price Pald $57.94 13.26 11.34 18.72 10.02 18.10 20.62 9.02 10.08 14.98 17.18 9.10 18.30 17 ct b. 1. Now that Billie knows which vendors have the best prices, she decides to take the daily inventory to find out what she needs to order for tomorrow. Her par value, on-hand, and special order requirements are as follows. Help Billie determine the amount of each item she needs to order. (Spreadsheet hint: Use the ROUNDUP function in the Order Amount column.) Par Value On Hand Special Order Order Amount Unit 3 4 Item Description Avocados 48 ct. Cauliflower 12 ct. Cucumbers Medium Grapes Red Seedless Lettuce Green Leaf, 24 ct. Lettuce Romaine, 24 ct. Pears D'Anjou Peppers Green Bell, Med. Pineapples 17 ct. Potatoes B Reds Potatoes Peeled, Large Squash Yellow #2 Strawberries Driscoll Case Case Case Lug Case Case Case Case Case 50# Bag 25# Bag 30# Case Flat 6 5 3 4 5 3 3 7 4 3 4 5 3 2 1 0 1 2 0.5 1 2 0 0.5 1 2 1.5 5 4 2 b. 2 Next, Billie needs to create the purchase orders for tomorrow. Help her create the correct purchase order for Village Produce based on her inventory needs (part b.1.) and the bid prices for Village Produce located on the price comparison worksheet (part a). Purchase Order Supplier Company Name: Village Produce Street Address: 123 Somewhere City, State, Zip: Village, CA 12345 Phone Number: 555-5555 Fax Number: 555-5556 E-Mail: Village@isp.org Contact: Mr. Green Purchase Order P.O. Number 456 Order Date: 1/1 Delivery Date: 1/2 Phone Number: 555-5557 Fax Number: 555-5558 E-mail: Billie@isp.org Buyer: Ms. Mendoza Item Description Unit Quantity Unit Price $ Extension
