Franz Beckenbauer and Johan Cruyff are purchasing managers for the headquarters of a large sports marketing company chain with a central inventory operation. Their fastest-moving inventory item has a daily demand of 35 units. The cost of each unit is £200, and the inventory carrying cost is £25 per unit per year. The average ordering cost is £60 per order. It takes about 5 days for an order to arrive, and there are 252 working days per year.  a) To minimize the cost, how many units should be ordered each time an order is placed? What is the total annual inventory cost, including the cost of the units?  b) How can they manage the days it takes for an order to arrive? (How does it impact their operations and costs?)  c) b) Even if there is substantial uncertainty in the parameters in the EOQ-model, it is still quite a useful model. Discuss why.

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

Franz Beckenbauer and Johan Cruyff are purchasing managers for the headquarters of a large
sports marketing company chain with a central inventory operation. Their fastest-moving inventory item has
a daily demand of 35 units. The cost of each unit is £200, and the inventory carrying cost is £25 per unit
per year. The average ordering cost is £60 per order. It takes about 5 days for an order to arrive, and there
are 252 working days per year. 

a) To minimize the cost, how many units should be ordered each time an order is placed?
What is the total annual inventory cost, including the cost of the units? 
b) How can they manage the days it takes for an order to arrive? (How does it impact their
operations and costs?) 
c) b) Even if there is substantial uncertainty in the parameters in the EOQ-model, it is still quite a
useful model. Discuss why. 

I got this anwsers but i am not sure if its correct:

For question 1:

EOQ=294

Annual Holding Cost= Q/2 H= 2942×25=£3675

Annual Ordering Cost=Q/D ​S= 29435×252​×60=£514.29

Annual Purchase Cost=D×P=35×252×200=£1,764,000

Purchase Cost=D×P=35×252×200=£1,764,000

Total Annual Cost=Annual Holding Cost+Annual Ordering Cost+Annual Purchase Cost=£1,769,189.29

 

For question 2:

Reorder Point (ROP)=Demand per day×Lead time=35×5=175

This indicates that the company should reorder when the inventory level reaches 175 units.

 

this is my first answer and my second with different answer is working out in pictuers but my answer down here:

Ans 1. 

 EOQ  205.7571384
Annual holding cost 2571.96423
Annual ordering cost  2571.96423
Annual purchase cost 1764000
Total annual cost  1769143.93

Ans 2. 

Time between orders 5.878775383
1 daily demand
2 Annual demand
3 Setup cost
4 Holding cost
5 Unit cost
6 Working days
Lead time
7
A
8
9
EOQ = sqrt (2*D*Co/Ch)
15 Time between orders= (EOQ/D)*W
d
D
Co
Ch
U
W
L
B
с
35
8820
60
25
200
252
5
205.7571384
5.878775383
Transcribed Image Text:1 daily demand 2 Annual demand 3 Setup cost 4 Holding cost 5 Unit cost 6 Working days Lead time 7 A 8 9 EOQ = sqrt (2*D*Co/Ch) 15 Time between orders= (EOQ/D)*W d D Co Ch U W L B с 35 8820 60 25 200 252 5 205.7571384 5.878775383
1 daily demand
2 Annual demand
3 Setup cost
4 Holding cost
5 Unit cost
A
d
D
Co
Ch
DW_
U
6 Working days
Lead time
7
8
9
EOQ = sqrt (2*D*Co/Ch)
10 Annual holding cost =(EOQ/2)*H Ah
11 Annual ordering cost =(D/EOQ)*S
As
12 Annual purchase cost-(D*U)
Au
13 Total annual cost
L
B
Ah+As+Au
с
35
8820
60
25
200
252
5
205.7571384
2571.96423
2571.96423
1764000
1769143.93
Transcribed Image Text:1 daily demand 2 Annual demand 3 Setup cost 4 Holding cost 5 Unit cost A d D Co Ch DW_ U 6 Working days Lead time 7 8 9 EOQ = sqrt (2*D*Co/Ch) 10 Annual holding cost =(EOQ/2)*H Ah 11 Annual ordering cost =(D/EOQ)*S As 12 Annual purchase cost-(D*U) Au 13 Total annual cost L B Ah+As+Au с 35 8820 60 25 200 252 5 205.7571384 2571.96423 2571.96423 1764000 1769143.93
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

I understand what you wrote but i am not sure how to answer this questions about this:

for the first question 3A i am not sure if i should also include the graphs that are given to me when i asked the first question.

3A.  To minimize the cost, how many units should be ordered each time an order is placed? What is the total annual inventory cost, including the cost of the units?

This question needs a quantitative approach.

First: Write clearly ALL the calculations STEP by STEP. 

Second: Explain the process followed and the final result.  

 

3B. How can they manage the days it takes for an order to arrive?  (How does it impact their operations and costs?)

 

3C.  Even if there is substantial uncertainty in the parameters in the EOQ-model, it is still quite a useful model. Discuss why.

123
4567
002N4G 99872
8
9
10
11
12
13
14
15
16
18
19
20
21
22
23
24
LV
26
27
28
29
A
Daily demand
Working days
Unit cost
Ordering cost
Holding cost
Lead time (days)
Annual Demand (D)
Ordering cost (0)
Holding cost (H)
Economic Order Quanity
(2*D*S)/H)
Economic Order Quanity (Q)
Average annual setup cost
Average annual setup cost
Given details:
Average annual Inventory cost
Purchase cost
Total inventory cost
Average annual Inventory cost
Purchase cost
$
a) Calculations:
$
$
$
$
$
$
$
$
$
$
$
B
35
252
5
Square root (2¹D*O)/H)
42336
205.7571384
206
Demand * Unit cost
8820
60.00
25.00
(Demand/Quantity (EOQ))*Setup cost
2,571.96
2,571.96
(Quantity (EOQ)/2)*Holding Cost
200.00 Time between orders (days)
60.00
25.00
Reorder point
Reorder point
2,571.96
2,571.96
D
1,764,000.00
1,764,000.00
1,769,143.93
b) Calculations:
Time between orders
E
(EOQ/D)*Working days
5.878775383
5.88
Average Demand * Lead time
175
175
Transcribed Image Text:123 4567 002N4G 99872 8 9 10 11 12 13 14 15 16 18 19 20 21 22 23 24 LV 26 27 28 29 A Daily demand Working days Unit cost Ordering cost Holding cost Lead time (days) Annual Demand (D) Ordering cost (0) Holding cost (H) Economic Order Quanity (2*D*S)/H) Economic Order Quanity (Q) Average annual setup cost Average annual setup cost Given details: Average annual Inventory cost Purchase cost Total inventory cost Average annual Inventory cost Purchase cost $ a) Calculations: $ $ $ $ $ $ $ $ $ $ $ B 35 252 5 Square root (2¹D*O)/H) 42336 205.7571384 206 Demand * Unit cost 8820 60.00 25.00 (Demand/Quantity (EOQ))*Setup cost 2,571.96 2,571.96 (Quantity (EOQ)/2)*Holding Cost 200.00 Time between orders (days) 60.00 25.00 Reorder point Reorder point 2,571.96 2,571.96 D 1,764,000.00 1,764,000.00 1,769,143.93 b) Calculations: Time between orders E (EOQ/D)*Working days 5.878775383 5.88 Average Demand * Lead time 175 175
Solution
Bartleby Expert
SEE SOLUTION
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.