In relation to Susan\'s Special Sauces: MIS Cases. How do I determine the overal
ID: 2392654 • Letter: I
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
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
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
Explanation / Answer
As only there is product cost provided, the overall cost is determined using the product cost.
The table below shows the overall cost
Hence, the total cost $1,526.
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 1526Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.