top of page

λ¬Όλ₯˜κ³΅ν•™ (Logistics Engineering) ν”„λ‘œμ νŠΈ

Demand &Sales Forecasting

μˆ˜μš” 및 판맀 예츑

Production Planning (μƒμ‚°κ³„νš)

κ³Όκ±° 데이터λ₯Ό 톡해 νšŒμ‚¬μ˜ μ—°κ°„ μˆ˜μš”λŸ‰μ™€ νŒλ§€λŸ‰μ„ μ˜ˆμΈ‘ν•©λ‹ˆλ‹€.

​

β€‹μ΄μš©ν•œ μ•Œκ³ λ¦¬μ¦˜:

​

-  Least Mean Square Method

-  Exponential Smoothing Method

-  Tracking Signal Method

README

Solution

Static Machine Cellular Layout

​기계 μ…€λ£°λŸ¬ λ ˆμ΄μ•„μ›ƒ

Facility Location Optimization​ (μž₯λΉ„ μœ„μΉ˜ μ„ μ • μ΅œμ ν™”)

VBAλ₯Ό μ΄μš©ν•˜μ—¬ 졜적의 기계 λ ˆμ΄μ•„μ›ƒμ„ μ°ΎλŠ” ν”„λ‘œκ·Έλž¨μ„ λ””λ²¨λ‘­ν•©λ‹ˆλ‹€.

 

9개의 기계 μ‚¬μ΄μ˜ 총 이동거리λ₯Ό μ΅œμ†Œν™”μ‹œν‚¬ 수 μžˆλŠ” 졜적의 기계 μ…€λ£°λŸ¬ λ ˆμ΄μ•„μ›ƒμ„ μ°Ύμ•„λƒˆμŠ΅λ‹ˆλ‹€.

README

Summary

Solution (.xlsm)

MRP AND MPS

Material Requirement Planning (μ£Όμƒμ‚°κ³„νš)

Material Production Schedule (μžμž¬μ†Œμš”κ³„νš)

ν•˜μœ„λΆ€ν’ˆ (subassemblies)의 μ’…λ₯˜μ™€ μž¬κ³ κ°€ 점점 λŠ˜μ–΄λ‚˜κ³  μžˆλŠ” μ‚°μ—… μž₯λΉ„ μ œμ‘°μ—… νšŒμ‚¬μ˜ 문제λ₯Ό ν•΄κ²°ν•˜κΈ° μœ„ν•΄ aggregate production plan (μ’…ν•©μƒμ‚°κ³„νš), MPS, MRPλ₯Ό κ΅¬μΆ•ν•©λ‹ˆλ‹€.

README

Solution

Solution

© 2022 by Jungeun Melissa Eom 

bottom of page