Question
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
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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started