1.  Jean-Marie Bourjolly’s restaurant has the following inventory items that it orders on a weekly basis:   Inventory Item $ Value/Case # Ordered/Week Rib eye steak 157 5 Lobster tail 267 8 Pasta 45 10 Salt 25 5 Napkins 34 17 Tomato sauce 45 27 French fries 65 5 Pepper 25 9 Garlic powder 33 13 Trash can liners 34 8 Tablecloths 54 6 Fish fillets 165 6 Prime rib roasts 188 6 Oil 50 35 Lettuce (case) 57 14 Chickens 97 5 Order pads 34 5 Eggs (case) 44 15 Bacon 78 6 Sugar 26 6   a) Which is the most expensive item, using annual dollar volume? b) Which are C items? c) What is the annual dollar volume for all 20 items?

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
icon
Concept explainers
Topic Video
Question

1. 

  • Jean-Marie Bourjolly’s restaurant has the following inventory items that it orders on a weekly basis:

 

Inventory Item

$ Value/Case

# Ordered/Week

Rib eye steak

157

5

Lobster tail

267

8

Pasta

45

10

Salt

25

5

Napkins

34

17

Tomato sauce

45

27

French fries

65

5

Pepper

25

9

Garlic powder

33

13

Trash can liners

34

8

Tablecloths

54

6

Fish fillets

165

6

Prime rib roasts

188

6

Oil

50

35

Lettuce (case)

57

14

Chickens

97

5

Order pads

34

5

Eggs (case)

44

15

Bacon

78

6

Sugar

26

6

 

a) Which is the most expensive item, using annual dollar volume?

b) Which are C items?

c) What is the annual dollar volume for all 20 items?

Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Inventory management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.