80.2K

Verified Solution

Link Copied!

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

Answer & Explanation Solved by verified expert

See Answer