1 / 57

Capstone Design (Efficient Stock Control)

Capstone Design (Efficient Stock Control). 20072375 정성욱 20072385 송준권 20072393 박양우. Contents. Introduce Company Our Subject A point in dispute Forward for the solution of the planning The next time our plan. Contents. subject of our team visited hollys coffee Visit the content

hewitt
Download Presentation

Capstone Design (Efficient Stock Control)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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

More Related