Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Belverd E. Needles

5th Edition

0395698022, 978-0395698020

More Books

Students also viewed these Accounting questions

Question

How does a futures contract differ from a forward contract?

Answered: 1 week ago