Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

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 Information For Decisions

Authors: John J Wild

3rd Edition

0072974729, 978-0072974720

More Books

Students also viewed these Accounting questions