Description
Hello, I am looking for a fully worked out solution to the questions in the attached assignment. This is for a grad school industrial engineering masters and usually requires an excel spreadsheet solution and a word document to explain the solutions. I can also provide lecture power points from the professor for further detail on the subject matter as well.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
View attached explanation and answer. Let me know if you have any questions.
1. Solution:
Cost per each trip (K) = $1,000
Demand for automobiles (λ) = 150,000 per year
Cost per engine (c) = $500
Holding cost (h) = ic = 20% × $500 = $100
a) Calculating economic order quality (EOQ) =
𝑞∗ = √
𝑞∗ = √
2×𝐾×𝜆
ℎ
2 × 1000 × 150,000
= 1732.05 𝑒𝑛𝑔𝑖𝑛𝑒𝑠 ≈ 1732 𝑒𝑛𝑔𝑖𝑛𝑒𝑠
100
𝑞∗
b) Annual inventory holding cost = ( 2 ) ℎ
=(
1732
2
) × 100 = $ 86600
c) The average annual cost associated with this policy:
𝐾𝜆 ℎ𝑞 ∗
𝐶(𝑞) = 𝑐𝜆 + ∗ +
𝑞
2
𝐶(𝑞) = 500 × 150,000 +
1000 × 150,000 100 × 1732
+
= $75173205.08/𝑦𝑒𝑎𝑟
1732
2
Hence, the average annual cost associated with the policy is $75173205.08.
2. Solution:
Annual Demand (λ) =6×52 = 312 tons/year
Holding cost (h) = 20%×3000 = $600
Setup cost (K) = $15,000
Production rate (P) = 30 tons/week = 30× 52 =1560 tons/year
a) The optimal production batch size for I-beams:
𝑞∗ = √
2×𝐾×𝜆
2 × 15,000 × 312
=√
= 139.64 𝑡𝑜𝑛𝑠
312
𝜆
600
(1
−
)
ℎ (1 − 𝑃)
1560
b) The annual setup cost of the optimal policy:
=
𝐾𝜆
312
=
15,000
×
= $33514.753
𝑞∗
139.64
c) The annual inventory holding cost:
𝜆 𝑞∗
312 139.64
)
= ℎ (1 − ) = 600 (1 −
= $33513.6
𝑃 2
1560
2
d) Required setup cost for 50 tons batch size to be optimal:
𝑞∗ = √
𝐾=
2×𝐾×𝜆
𝜆
ℎ (1 − 𝑃 )
(𝑞 ∗ )2 ℎ(1 − 𝜆/𝑃)
2𝜆
For 𝑞 ∗ = 50 tons,
𝐾=
502 × 600 (1 −
2 × 312
312
)
1560 = $1923.07
Hence, the required setup cost required for 50 tons batch size to be optimal is $1923.07.
Using excel solver:
3. Solution:
Gator21
Gator21 (b)
Mini (a)
Gator21 Pro
Gator21
(c)
ProMax (d)
Annual demand rate (λ)
40,000
50,000
30,000
10,000
Order cost (C0)
$3,000
$3,000
$3,000
$3,000
Product-specific order cost (Cko)
$1,000
$1,300
$1,600
$2,000
$400
$400
$400
$400
0.3
0.3
0.3
0.3
Unit cost (c)
Annual inventory carrying rate (i)
For individual ordering:
Total order cost (K) = C0 + Cko
For Gator21 Mini, K = $3,000 + $1,000 = $4000
For Gator21, K = $3,000 + $1,300= $4300
For Gator21 Pro, K = $3,000 + $1,600= $4600
For Gator21 ProMax, K = $3,000 + $2,000 = $5000
Economical order quantity for each mobile:
𝑞𝑎∗ = √
𝑞𝑏∗ = √
𝑞𝑐∗ = √
2×𝐾×𝜆
2 × 4000 × 40,000
= √
= 1633 𝑢𝑛𝑖𝑡𝑠
𝑖𝑐
0.3 × 400
2×𝐾×𝜆
2 × 4300 × 50,000
= √
= 1893 𝑢𝑛𝑖𝑡𝑠
𝑖𝑐
0.3 × 400
2×𝐾×𝜆
2 × 4600 × 30,000
= √
= 1517 𝑢𝑛𝑖𝑡𝑠
𝑖𝑐
0.3 × 400
𝑞𝑑∗ = √
2×𝐾×𝜆
2 × 5000 × 10,000
= √
= 913 𝑢𝑛𝑖𝑡𝑠
𝑖𝑐
0.3 × 400
Hence,
...