How do you calculate MinInventoryLevel with a Lead Time and Safety Stock of 2 days...

90.2K

Verified Solution

Question

Accounting

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
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students