Enhancing Efficiency and Security at Austen Food Ltd.: Inventory and Sales Optimization

1. Created By: Eric Black Martin Matthiesen Matt Hudon Damon Guard Rohit Sahajpal James Aasman

2. Introduction • About Creative Consulting • in business for 5 Years • member of the Better Business Bureau • strive to provide the best Service and Products • loyal customer base and longevity • About Austen Food Ltd. • Family based grocery store • 5 Edmonton Stores • well established in the community

3. Outline • Business Process 1:Gathering Data • Day-to-Day Inventory • Inventory Count • Discount & Sale Process • Security • Business Process 2:Processing Data • Business Process 3:Output • Training and Implementation • Cost Analysis • Benefits of our Solution

4. Business Process 1 Gathering Data Current Day-to-Day Inventory Process

5. Current Day-to-Day Inventory Process

6. Current Day-to-Day Inventory Process

7. Current Day-to-Day Inventory Process

8. Current Day-to-Day Inventory Process • Current Cash Registers

9. Current Day-to-Day Inventory Process • Capabilities of current cash registers • Current Cash Registers • rely on cashier knowing prices • only limited report capabilities

10. Current Day-to-Day Inventory Process • Problems • manual count of product received very time consuming • manual count error prone • manual pricing time consuming and wrong prices might get affixed • manual entering at register error prone • cash register does not keep track of items sold • cash register does not help in compiling of reports

11. Current Day-to-Day Inventory Process • Effects! • Austen Foods Ltd. loses profits • manpower inefficiently used • reliable reports cannot be generated • potential for human error is great

12. Current Day-to-Day Inventory Process • Proposed Solution

13. Current Day-to-Day Inventory Process • Proposed Solution

14. Current Day-to-Day Inventory Process • Proposed Solution

15. Current Day-to-Day Inventory Process • Proposed Solution

16. Current Day-to-Day Inventory Process • Proposed Solution

17. Current Day-to-Day Inventory Process • New Cash Registers

18. Current Day-to-Day Inventory Process • New Cash Registers • Capabilities of new registers with POS • comprehensive store reports • put a transaction on hold allows to easily manage merchandise prices in the store • comprehensive receipts for the customer

19. Current Day-to-Day Inventory Process • New Cash Registers

20. Current Day-to-Day Inventory Process • Benefits!! • automated checkouts more efficient • time saved • manpower efficiently used • reliable reports • reports can be issued based on item not only category • potential for human error minimized • profits maximized

21. Outline • Business Process 1:Gathering Data • Day-to-Day Inventory • Inventory Count • Discount & Sale Process • Security • Business Process 2:Processing Data • Business Process 3:Output • Training and Implementation • Cost Analysis • Benefits of our Solution

22. Business Process 1 Gathering Data Inventory Count Process

23. Current Inventory Count Process

24. Current Inventory Count Process • Problems and Effects! Problems • inventory count process takes approximately two weeks • extra staff costly • count process is slow and prone to error Effects • loses $160,000 for each inventory day per store • yearly loss of $1.6 million • product might not arrive in time

25. Current Inventory Count Process • Proposed Solution

26. Current Inventory Count Process • Proposed Solution

27. Current Inventory Count Process • Proposed Solution

28. Current Inventory Count Process • Proposed Solution • BENEFITS!! • no outside staff necessary • more efficient count • no loss due to store closure • counts immediately completed • reports can immediately be issued

29. Outline • Business Process 1:Gathering Data • Day-to-Day Inventory • Inventory Count • Discount & Sale Process • Security • Business Process 2:Processing Data • Business Process 3:Output • Training and Implementation • Cost Analysis • Benefits of our Solution

30. Business Process 1 Gathering Data Sale and Discount Process

31. Sale and Discount Process Now • Cashiers Have to Memorize the Prices • Cashiers Have to Remember Which Customer Receives Discount • Managers Waste a Considerable Amount of Time Searching for Products About to Expire

32. Sale and Discount • Now Done Automatically • Value Card • Reduce Errors • Manager now has more time • Larger and Stronger Loyalty Base

34. Outline • Business Process 1:Gathering Data • Day-to-Day Inventory • Inventory Count • Discount & Sale Process • Security • Business Process 2:Processing Data • Business Process 3:Output • Training and Implementation • Cost Analysis • Benefits of our Solution

35. Business Process 1 Gathering Data Security Process

36. Security Problems Now • Theft is Very Difficult to Detect • Customers or Staff May Be Committing Theft • Employees and Clientele Require a Sense of Security

37. Security • Consist of three Components • Camera System • Digital Video Recorder • Monitor • Reduce the Amount of Theft • Workers of the Store Honest • Everyone Knows That Big Brother is Watching

44. Outline • Business Process 1:Gathering Data • Day-to-Day Inventory • Inventory Count • Discount & Sale Process • Security • Business Process 2:Processing Data • Business Process 3:Output • Training and Implementation • Cost Analysis • Benefits of our Solution

45. Business Process 2: Processing Data

46. Business Process 2 • Accountant manually inputs items into Excel • Accountant manually formats it to Word • Susceptible to human error

47. Business Process 2 Solution Solved in two parts

48. Solution: Part 1 • Inventory properly scanned • Numbers are sent to the Inventory Database • Microsoft Access organizes Database and compares inventoried stock to physical stock

50. Solution: Part 1 Continued • Any discrepancies will be displayed • Manager makes the decision on how to reconcile the problem