90.2K

Verified Solution

Link Copied!

How do you calculate MinInventoryLevel with a Lead Time and Safety Stock of 2 days with the data provided. This is the information that was provided to do so. I can't really say.

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

Answer & Explanation Solved by verified expert

See Answer