Restaurant Analysis 7% 2 Shipping Costs S/ib 4 Ingredient 5 Chicken 6 Beef 7 Tom

Question

Restaurant Analysis 7% 2 Shipping Costs S/ib 4 Ingredient 5 Chicken 6 Beef 7 Tomatoes 8 Lettuce 9Total cost wishipping 10 Category lbs FoodWay DiretFood Cost Meat Cost 54.00 Meat 13$ 3.99 S 4.25 51.87$55.25 Veggie 10 $ 1.65 $1.15$ 16.50 11.50 4.16 S 139.10$ 133.65 24 S 2.40 S2.25 57.60 Veggie | 13|$ 0.31 I $ 0.32 | $ 4.03 $ 12 # items ordered 136.38 133.65 Total Cost 2 $ 109.25 2$ 15.66 # items 14 min cost order incl. shipping 15 |# Foodway items over S2 Meat Veggie You own a restaurant and use an Excel spreadsheet to keep track of food ingredients. You currently ha two distributors, Food Way and DirectFood. Each distributor has different prices for a pound of each of these ingredients as given in columns F and G respectively. The number of pounds you need to order is given in column C. Shipping costs are 7% of the total order value. So a $100 order from Direct Food would result in a shipping cost of $7 and a total cost with shipping of $107. Write a formula in cell F5, which can be copied down the column and across the row, to calculate the total cost of each ingredient from FoodWay and DirectFood, taking into account the number of pounds being ordered and the price per pound for the corresponding item and store. 2. Vrite a formula in cell F9, which can be copied across the row, to calculate the total value of the order including shipping. (Hint: Use a function when totaling the order costs and then multipl by the 1+ the shipping percentage.) Write a formula in cell B12 to determine the number of ingredients that are being orde

Explanation / Answer

Below is the solution:

1. formula is =C5*D5 to multiply to get the result

2. formula to calulate =SUM(F5:F8)*7/100 + + SUM(F5:F8)

3. formula to count =COUNTA(F5:F8)

4. formula =SUM(F9+G9)/2

5. forula =MIN(F9:G9)

6. formula =COUNTIF(D5:D8,">=2")

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

---

---

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