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

Answer 1

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.