Question

# In relation to Susan's Special Sauces: MIS Cases. How do I determine the overall cost if...

In relation to Susan's Special Sauces: MIS Cases. How do I determine the overall cost if all orders were filled?

 OrderNo PNo Quantity CustNo 1 4 100 123 1 11 50 123 2 8 10 234 3 7 75 56 4 1 20 45 4 4 150 45 5 20 120 12 6 1 12 119 6 14 15 119 7 10 200 80 8 20 10 32 9 17 10 22 10 16 20 10 11 5 12 17 11 14 12 17 12 5 25 90 12 18 15 90
 PNo ProductName PCategoryCode QOH SellingPrice ProductCost Current Inventory MinInvLev Daily Demand MaxInventory 1 Extra Creamy Ranch Dressing DR 140 \$3.50 \$2.00 100 120 25 150 2 Extra Creamy Italian Dressing DR 100 \$3.50 \$2.00 140 100 35 210 3 Italian Dressing DR 100 \$3.00 \$1.50 160 90 40 240 4 Superior Caesar Salad Dressing DR 150 \$3.25 \$1.25 160 90 40 240 5 Susan's French Dressing DR 119 \$3.25 \$1.25 168 86 42 252 6 Susan's Thousand Island Dressing DR 125 \$3.25 \$1.25 220 60 55 330 7 Susan's Creamy Blue Cheese Dressing DR 330 \$3.25 \$1.25 220 60 55 330 8 Sensational Steak Sauce SA 202 \$4.50 \$2.50 180 80 45 270 9 Thick and Hearty Sensational Steak Sauce SA 40 \$4.75 \$2.75 120 110 30 180 10 Meatball Express PS 180 \$4.35 \$2.85 120 110 30 180 11 Vegetarian's Delight PS 150 \$4.50 \$2.90 120 110 30 180 12 Garlic, Onion, Mushrooms PS 30 \$4.50 \$3.00 20 160 5 30 13 More Cheese, Please PS 4 \$4.75 \$3.50 60 140 15 90 14 Mild Picante SL 149 \$3.10 \$1.55 100 120 25 150 15 Medium Picante SL 130 \$3.10 \$1.55 100 120 25 150 16 Jumpin' Hot Picante SL 115 \$3.10 \$1.55 80 130 20 120 17 Hickory Smoke Barbecue Sauce BS 130 \$4.90 \$2.95 100 120 25 150 18 Uncle Steve's Best Ever Barbecue Sauce BS 164 \$5.90 \$3.45 120 110 30 180 19 Magnificent Mesquite Flavored Barbecue Sauce BS 110 \$4.75 \$2.75 80 130 20 120 20 Extra Spicy Barbecue Sauce BS 101 \$4.50 \$2.25 100 120 25 150

As only there is product cost provided, the overall cost is determined using the product cost.

The table below shows the overall cost

 Order no. Product no. Quantity Customer no. Product cost Total cost(\$) 1 4 100 123 1.25 125 1 11 50 123 2.9 145 2 8 10 234 2.5 25 3 7 75 56 1.25 93.75 4 1 20 45 2 40 4 4 150 45 1.25 187.5 5 20 120 12 2.25 270 6 1 12 119 2 24 6 14 15 119 1.55 23.25 7 10 200 80 2.85 570 8 20 10 32 2.25 22.5 1526

Hence, the total cost \$1,526.

#### Earn Coins

Coins can be redeemed for fabulous gifts.