Calculate the Economic Order Quantities (EOQs) for the A 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...
Related questions
Question
3.. Calculate the Economic Order Quantities (EOQs) for the A items.
Transcribed Image Text:Cat. ref.
Sales Unit Description
Sample
number
Sales Unit
Last 12 mo. Inventory as Reorder
sales (units) at last year Quantity
end (units) (Units)
1,000
1,000
number
Cost (€)
1
11036
Disposable Aprons (10pk)
Ear-loop Masks(Box)
Drill Type 164
Disposable Gloves Large
150ml Syringe
Intubation Tube (Adult)
Pocket Organiser Blue
2.40
100,000
2
11456
3.60
60,000
120
3
11563
1.10
220
420
250
12054
12372
4
3.50
35,400
8,500
10,000
11.30
430
120
100
97.40
6,500
120
6.
12774
20
20
12979
7.00
160
500
8
13063
CPAP Consumable Kit
187.00
400
10
Zinc Oxide Tape
Stethoscope Head
Disp. Latex Catheter
Roll-up Wheelchair Ramp
LFT Tube
13236
1.50
1,260
50
10
13454
6.25
10
16
25
11
13597
0.60
3,560
12
20
12
13999
152.50
12
44
50
13
14068
1.40
22,500
10,500
8,000
Cervical Collar
Head Wedge
14
14242
12.00
140
24
20
14310
14405
15
89.00
44
10
16
Three-Wheel Scooter
755.00
14
17
14456
Neonatal Trach. Tube
80.40
268
6.
100
14675
Mouldable Strip Paste
Sequential Comp. Pump
Toilet Safety Frame
10.20
1,250
430
18
172
100
19
14854
430.00
40
50
20
24943
25.60
560
18
20
Weeks per annum:
52.14
Holding cost (%)
Ordering cost (€)
15
50
Transcribed Image Text:ABC Analysis of Usage Value
Sample Number Cat. Ref. No. Sales Units Description Sales Unit Cost (a) Last 12 Month Sales Units (b) Usage Value (a x b) Percentage in Total Usage Value Cumulative Percenatge Analysis
6,500
€ 97.40
€ 2.40
€ 633,100.00
€ 240,000.00
€ 216,000.00
€ 184,900.00
€ 123,900.00
€ 74,800,00
€ 21,547.20
€ 17,500.00
€ 14,336.00
€ 12,750.00
€ 10,570.00
€ 4,859.00
€ 3,916.00
€ 2,136.00
€ 1,890.00
€ 1,830.00
€ 1,680.00
€ 840.00
€ 242.00
€ 62.50
€ 1,566,858.70
6.
12774
Intubation Tube
40.41%
40.41%
A
1
11036
100,000
55.72%
Disposable Apron (10pk)
Ear-loop Mask (Box)
Sequential Comp. Pump
Dispisable Gloves Large
15.32%
B
€ 3.60
€ 430.00
2
11456
60,000
13.79%
69.51%
19
14854
430
11.80%
81.31%
€ 3.50
€ 187.00
€ 80.40
€ 1.40
€ 25.60
€ 10.20
€ 755.00
4
12054
35,400
7.91%
89.22%
8
13063
CPAP Consumable Kit
400
4.77%
93.99%
17
14456
Neonatal Trach. Tube
268
1.38%
95.37%
13
14068
LFT Tube
12,500
1.12%
96.48%
Toilet Safety Frame
Mouldable Strip Paste
20
24943
560
0.91%
97,40%
18
14675
1,250
0.81%
98.21%
16
11405
Three-Wheel Scooter
14
0.67%
98.89%
150ml Syringe
€ 11.30
€ 89.00
€ 0.60
€ 1.50
€ 152.50
€ 12.00
€ 7.00
€ 1.10
€ 6.25
5
12372
430
0.31%
99.20%
15
14310
Head Wedge
44
0.25%
99.45%
Disp. Latex Catheter
Zinc Oxide Tape
11
13597
3,560
0.14%
99,58%
9
13236
1,260
0.12%
99.70%
12
13999
Roll-up Wheel Chair Ramp
12
0.12%
99.82%
14
14242
Cervical Collar
140
0.11%
99.93%
Pocket Organiser Blue
Drill Type 164
Stethoscope Head
7
12979
120
0.05%
99.98%
3
11563
220
0.02%
100.00%
10
13454
10
0.00%
100.00%
Total
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
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…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.