Industrial Design Question

User Generated

PbhfvaIvaal

Engineering

University of Florida

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

ESI6323 Models for Supply Chain Management 2021 Summer Homework 5 – Cycle Inventory Management in a Supply Chain Homework Questions Question 1 Gator Automobiles (GA) has its engine assembly plant in Atlanta and its automobile assembly plant in Houston. Engines are transported between the two plants using trucks, with each trip costing $1,000. The automobile plant assembles and sells 150,000 automobiles per year. Each engine costs $500; GA incurs an annual inventory carrying rate of 20 percent per year. a. How many engines should GA load on each truck? (5 pts.) b. What is the annual inventory holding cost? (5 pts.) c. What is the average annual cost associated with this policy? (5 pts.) Question 2 A steel rolling mill can produce I-beams at the rate of 30 tons per week. Customer demand for the beams is 6 tons per week. To produce I-beams, the mill must go through a setup that requires changing to the appropriate rolling patterns. Each setup costs the mill $15,000 in labor and lost production. I-beams cost the mill $3,000 per ton and the mill has a holding cost of 20 percent. Assume the mill operates 52 weeks per year. a. b. c. d. What is the optimal production batch size for I-beams? (5 pts.) What is the annual setup cost of the optimal policy? (5 pts.) What is the annual inventory holding cost? (5 pts.) The mill would like to produce I-beams in batches of 50 tons. For what setup cost would this batch size be optimal? (5 pts.) 1 ESI6323 Models for Supply Chain Management 2021 Summer Question 3 Gator Mobile (GM) sells four models of cell phones, Gator21 Mini, Gator21, Gator21 Pro, and Gator21 ProMax. Demands and costs for independent ordering are shown in the table below. Gator21 Gator21 Gator21 Pro Gator21 Mini ProMax Annual demand rate 40,000 50,000 30,000 10,000 Order cost $3,000 $3,000 $3,000 $3,000 Product-specific order cost $1,000 $1,300 $1,600 $2,000 Unit cost $400 $400 $400 $400 Annual inventory carrying rate 0.3 0.3 0.3 0.3 A fixed order cost of $3,000 is incurred each time an order is placed. For each model ordered and delivered with the same order, an additional fixed cost is incurred for receiving and storage. Evaluate the lot sizes that GM should order and the annual cost of such a policy. The store manager may consider the following approaches to the multiple products ordering decision: • Each model is to be ordered individually, the order cost as well as the product-specific order cost are incurred for each model. • All models are to be ordered jointly in each order and the order cost is incurred for the batch of products. What policy should the manager take to minimize the average annual cost? (30 pts.) Question 4 Demand for Bluetooth headphones at Gator Electronic (GE) is 5,000 per month. Holding cost is 25 percent and the company incurs a fixed cost of $500 for each order placed. a. The supplier offers an all unit quantity discount with a price of $200 per headphone for all orders under 1,000, a price of $195 for all orders of 1,000 or more but under 2,000 and a price of $190 for all orders of 2,000 or more. How many headphones should GE order per replenishment? (15 pts.) b. The supplier offers a marginal unit quantity discount with a price of $200 per headphone for all orders under 1,000, a price of $195 for all orders of 1,000 or more but under 2,000 and a price of $190 for all orders of 2,000 or more. How many headphones should GE order per replenishment? (20 pts.) 2
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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,
...


Anonymous
Excellent! Definitely coming back for more study materials.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags