Question
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
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 |
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