Capstone Design (Efficient Stock Control)

1. Capstone Design(Efficient Stock Control) 20072375 정성욱 20072385 송준권 20072393 박양우

2. Contents • Introduce Company • Our Subject • A point in dispute • Forward for the solution of the planning • The next time our plan

3. Contents • subject of our team • visited hollys coffee • Visit the content • Contents Organization • The next time our plan

4. Contents • problem that we have to solve • Methods to solve this problem • How selected • The selected methods

5. Contents • Introduction of method we previously talked about • Management science • Information needed to solve problem with management science • Information gathering and arranging • Make graph

6. Contents • Management science • Information needed to solve problem with management science • Information gathering and arranging • Make graph • The problem occurred • Worry about the problem

7. Introduce Company • Business name: Hollys Coffee • Location: 광주광역시 서구 치평동1241-1번지 상무힐타워1층 • Store size: 232㎡ (72평) • Workforce: 12people(rotation) • Weekday sales : \200~\300만원 • Weekend sales: \350~\400만원 • 홈페이지 : www.hollys.co.kr

8. Introduce Company • Store front picture

9. Introduce Company • Store inside picture

10. Introduce Company • Store picture

11. Our Subject • Hollys Coffee in stock • Milk, Coffee Beans, Fruit, Bread, Cake etc. • When we have to order and how much should we order? • How manage the items efficiently.

12. Problem

13. Forward for the solution of the planning • We find the optimal solution • loss expenses research • The optimal order quantity decision • The optimal order cycle decision

14. Forward for the solution of the planning

15. Forward for the solution of the planning • Use to management Science(EOQ) • Example)

16. Forward for the solution of the planning • Simulation • Program name: Arena • Example)

17. subject of our team

18. visited hollys coffee • the date : 26th 3pm • Visit the shop: at SANG-MU hospital • Visit the content • First, we requested cooperation. • After that, we investigated shop. • Third, we investigated kind of stock. • Third, we investigated kind of stock. • Finally, we interviewed executive and employee.

19. Visit the content(1) • request for cooperation.

20. Visit the content(2) • investigation of shop.

21. Visit the content(3) • investigation of stock.

22. Visit the content(4) • Interview data • Interview language : Korean • the interview was proceeded through: 2hours. • Interview data • major inventory management, • kind of stock and storage period • famous menu and consumption • other important matters. • the interviewees : supervisor and owner. • we spend 5 or 6 hours to arrange interview.

23. Visit the content(5) • Talking about the interview Q : How did you management stock? A : A set of individual stock management Q : What kind of stock? A : Milk, Coffee beans, Cookies, Muffin, Strawberry…

24. Visit the content(6) Q : What the most popular menu? A : 1. Macchiato 2. Café mocha3. Café latte . 4. Fruit smoothie Q : What the most popular stock? A : 1. Coffee beans 2. Milk 3. Strawberry smoothie Pack `` 4. Baguette

25. Visit the content(7)

26. Contents Organization (1) • Interview Organization

27. Contents Organization (2) • Our contents of inventory management

28. Contents Organization(3) • Milk management • Coffee beans

29. Contents Organization(4) • Economic loss

30. Result Manager: “although the economic loss is not too big, it can cause numerous economic loss later.” “This company needs improvements”

31. The problem that we have to solve (1) • Management stock data • The stock's contents for order last week at hollys coffee Order!! Order!! Order!!

32. The problem that we have to solve (2) • Currently is stock 18 19 20 21 22 23 24 10Pack  4Pack 25 26 27 28 29 30 31 8Pack all

33. Possible Method • Management Science(EOQ) • Inventory management program • Simulation • Excel inventory management • ABCanalysis

34. Methods to solve this problem • Use to management Science(EOQ) • Example)

35. Methods to solve this problem • Simulation • Program name: Arena • Example)

36. Methods to solve this problem • Inventory management program

37. Methods to solve this problem • Excel inventory management • Excel and Access DataBase to used reliable solution • Data is stored in a database management program. There is no limit of capacity, this is a very fast speed. • local version: 1 people • Money: ₩ 150,000 • network version: 10인 이하 • money: \400,000

38. Methods to solve this problem • ABC analysis • Price is high, to come less quantity is difficult. A inventory.Theprice is cheap and easy to buy, C inventory. The middle of it B inventory. How to classify this and changing management emphasis.

39. Quality Function Deployment 송준권

40. Quality Function Deployment 정성욱

41. Quality Function Deployment 박양우

42. Quality Function Deployment

43. selected methods • Use to management Science(EOQ) • The reason • Specialty • Have learned • No cost

44. Management Science • Not Allow the “out of stock” • Allow “out of stock”

45. Information needed to solve problem with management science • Consumption of stock for a week • Demand of milk and coffee beans

46. Information gathering and arranging

47. Information gathering and arranging

48. Information gathering and arranging

49. Information gathering and arranging • Coffee bean 1Pack  55shots • Milk 1Pack 6cups

50. Information gathering and arranging