The following table contains figures on the annual usage and unit costs for a random sample of 12 items. Develop and A-B-C classification for these items: Item Name Annual Usage (No of Items) Unit Cost 1 500 TK 4300 2 3000 720 3 1900 500 4 1000 710 5 4500 250 6 2500 192 7 400 200 8 500 190 9 200 210 10 1000 35 11 3000 10 12 19000 3

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

The following table contains figures on the annual usage and unit costs for a random sample of 12 items. Develop and A-B-C classification for these items:

Item Name

Annual Usage (No of Items)

Unit Cost

1

500

TK 4300

2

3000

720

3

1900

500

4

1000

710

5

4500

250

6

2500

192

7

400

200

8

500

190

9

200

210

10

1000

35

11

3000

10

12

19000

3

 

Brown and Brown Electronics manufacture a line of digital audiotape (DAT) players. While there are differences among the various products, there are a number of common parts within each player. The bill materials showing the number of each item required, lead times and the current inventory on hand for the parts and components, follows:

Demand of products A & B and demand of spares components are shown below:

Item

Demand on 5th week

Demand on 7th Week

On-Hand

Lead Time (Weeks)

A

700

------

30

1

B

1200

------

50

2

C

------

270

75

1

D

320

------

80

2

E

------

380

100

1

F

------

100

150

1

G

------

------

40

1

H

------

------

200

1

I

------

------

300

1

 

Prepare a MRP schedule to satisfy demand (Use the supplied sheet).

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 6 images

Blurred answer
Knowledge Booster
Forecasting methods
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.