Improve inventory system in Skylark
Frank, Wilson, Jason
Department of Industrial Engineering and Engineering Management
National Tsing Hua University
Hsinchu (300), Taiwan
ABSTRACT
This improvement issue focuses on inventory management system in a California restaurant. We have found a problem about the restaurant “SKYLARK”, which often out of stock issues. The most serious part of all is that the way the company to check inventory and decide whether to replenish is inefficient. The company check inventory in their warehouse per week, and then at the end of the day to determine what to order, how many to buy. It may cause the company often face stock out, and have something too much that would be a waste. And the reason why SKYLARK would meet those situation often is because they didn’t have a property strategy to manage their inventory and the flow of whether to order.
According to our working experience in the restaurant, while hoping that through the establishment of an inventory system to solve the inventory problem and stock outs. The ground around the concept of the system we can see that each product sell the amount of material consumption, and when the material consumption to less than nest egg when they want to send a message that order, while the nest egg the formulation of the material of the pre-delivery period to develop a number of small. So that labor costs can be resolved to reduce the lack of Cargo phenomenon even without increasing inventory costs.
Keywords: Inventory, Information Technology (IT), Human Resource Allocation
13
1. INTRODUCTION
1.1 Case description
Our analysis of this restaurant's name as the Skylark, there are 18 branches in Taiwan, The store is located in Taoyuan city center, this restaurant mainly provides packaged meals service, meals include appetizers, soup, entree, dessert as well as drinks and so on, it is all stores of the smallest shops, employees about 15 people around. When some employees have a holiday, the company would employ a fixed number of work-study born to fill vacancies in regular staff. The company year round. In addition, Operating daily from 10 am to 10 pm and then closed shop, it is divided into two shifts, morning shift is from 10 am to 5 pm, another class is from the 5 pm to 10 pm.
The company’s processes are that shop begins to take to do some cleaning and place tableware and so on in the morning every day. When the customers arrival and start with a bit, to help guests pour, to order meal, delivery meals and other services until the customer left. We start to clean and finish table until the next Group Customers come to here and repeat the above process services, while the outside part of the process-counter market, received the most orders for production of beverages and desserts to the customers wait to send the above part of the field for the part of the internal market process, processes are orders, make meals. According to the appetizers, soup, main meal to delivery the guests. When it comes to close shop, the manager will ask the infield and outfield of the people to count inventory of materials, to check which materials are insufficient to allow the manager to decide which materials must be ordered. In addition, a closed shop must also do cleaning and clearing the entire store and the turnover of the day, the above is probably the entire family for this situation in the daily condition.
1.2 Analysis case main problem
This restaurant there often has a problem that is out of stock, but they are manner of ordering materials in accordance with staff to see the inventories and the inventories of the day decided what material to order. And this situation will make them want more than to increase the human resource cost and time-consuming to do this work even to staff negligence, and are often caused by stock-outs, resulting in customer complaints. Therefore suppliers who want to establish a system to solve the shortage problem. The system is probably the concept of the ground we can know how much material consumption of each product sold, so that you can solve the labor costs, reduce stock-outs or even no increase in inventory costs.
In addition, suppliers will have delivery problems of lead-time. Usually after ordering, the materials will not be sent immediately the next day, but must wait one or two days.
2. BUSINESS PROCESS MODELING USING INCOME
2.1 BEHAVIOR MODEL
In this chapter, we want to show model AS-IS and To-Be.
2.1.1 As-Is Model
Figure1
When the customers come in the service system, the process will be started. First, the waiters will confirm whether the customers make a reservation. After confirmed, the waiters will bring the customers to their seats. The next step, the customer will start ordering. After the end point will be the menu into the meal preparation systems.
Since then, the orders will be divided into two categories while the customers finished ordering. The one of them is of a meal category, this one is belong of the kitchen. And the other one is a kind of dessert and drinks category, this one is belong of the bar.
Then, when the meals came out, the waiters were ready to send the meals to the customers. And when guests enjoyed the finished service, and then is to pay off bills, Content of the bill contains the
customer's ordering type, quantity, and date, etc. And the guests will leave after they pay the bills.
When all of the customers left, the waiters will be to carry out three actions. In the inventory after this time, the boss will be according as experience to determine whether to purchase additional stocks or not, next step is to call to the supplier. The second is the accounting part, at the end of business day after the accounting staff will go to calculate the day's turnover. The last stage is the waiters is responsible for cleaning up the shop. The recognition that all steps are completed and then closed shop.
2.1.2 To-Be Model
Figure2
In the previous process, because the inventory of systems are the use of human resources to operate, for which we have designed a set of inventory system, staff will be a day of shopping as long as a single data input to the system, then the system will automatically convert the consumption of materials. At this time, inventory system, the integrity of these materials will be presented to the manager, so how much needs to be ordered for the manager and order what kind of materials to do a decision-making.
A decision to order quantity, but after they re-enter the inventory system manager will be the type of material he needed and quantity of the information input to the system. Then the system will automatically showed off material information with the vendor information, and send procurement needs. In this step with the biggest difference is that before, manager did not need to issue purchase orders to suppliers, but to use input system, the system will automatically
inform the suppliers that we need to demand information, this way, makes the transmission speed even more quickly and easily.
When the vendors after the procurement of information materials will be transmitted over, manager will receive a list of raw materials, such as the goods arrive, it will make classification of their warehouses after they admitted to the system.
2.2 OBJECT MODEL
2.2.1 As-Is Object Model
Object model define information structure, so we can understand the relationship between each data. Figure 8 and Figure9 shows the information structure in our AS-IS Object diagram.
Figure3
(1) A list of seat database contains information of waiter. It means that which one is responsible for today's service with a bit. Therefore, a list of seat can link waiter database. The relationship between a list of seat and waiter is one to one.
(2) Waiter database contains information of customer. It means that waiters service number of customer. Therefore, waiter database can link customer database. The relationship between waiter and customer is one to multiple.
(3) Customer database contains information of bill. It means that customers have to pay the bill when customers leave. So customer must have information of bill. So customer database can link bill database. The relationship between customer and bill is one to one.
(4) Waiter database contains information of replenishment’s order. It means that some of waiters must to be responsible to replenish materials. So waiter database can link replenishment’s order. The relationship between waiter and replenishment’s order is one to multiple.
(5) Waiter database contains information of packing list. It means that some of waiters must be responsible to receive materials which delivery to kitchen and bar. So waiter database can link packing list. The relationship between waiter and packing list is one to multiple.
(6) packing list database contains information of warehouse. It means that waiters go to warehouse to receive materials when waiters take sheets. So packing list database can link warehouse database. The relationship between packing list and warehouse is multiple to one.
(7) Waiter database contains information of stocktaking’s sheet. It means that some of waiter must be responsible to check inventory of materials. Therefore, waiter database can link stocktaking’s sheet. The relationship between waiter and stocktaking’s sheet is one to multiple.
(8) Stocktaking’s sheet database contains information of warehouse. It means that they go to warehouse to check inventory of materials when waiters take stocktaking’s sheet. So stocktaking’s sheet database can link
(9) warehouse database. The relationship between stocktaking’s sheet and warehouse is multiple to one.
(10) Kitchen database contains information of packing list. It means that waiters have to delivery materials by packing list when kitchen need to make meals. So kitchen database can link packing list database. The relationship between kitchen and receives’ sheet is one to multiple.
(11) Kitchen database contains information of meal’s order. It means that waiters will cook meals when waiters give kitchen meal’s order. So kitchen database can link meal’s orders. The relationship between kitchen and meal’s order is one to multiple.
(12) Bar database contains information of packing list. It means that waiters have to delivery materials by packing list when bar needs to make drinks. So bar database can link packing list database. The relationship between bar and packing list is one to multiple.
(13) Bar database contains information of drink’s order. It means that waiters will make drinks when waiters give bar drink’s orders. So bar database can link drink’s order. The relationship between bar and drink’s order is one to multiple.
2.2.2 To-Be Object Model
(1) Manger database contains information of staff .It means that manger sometimes assigns tasks to staffs, for example, assign staffs to replenish material .Therefore, manger database can link staff database .The relationship between is one to multiple.
(2) Manger database contains information of purchasing order. It means that manger needs to use purchasing order when manger wants to purchase material. Therefore, manger database can link purchasing order database. The
Figure 4
relationship between is one to multiple.
(3) Staff database contains information of inventory system. It means that staffs needs to use the information system to check inventory. Therefore, staff database can link inventory system. The relationship between is multiple to one.
(4) Delivery’s sheet database contains information of manger. It means that suppliers need to use delivery’s sheet when suppliers want to deliver material. Therefore, delivery’s sheet database can link manger database. The relationship between is multiple to one.
(5) Supplier database contains information of delivery’s sheet. It means that supplier needs to use delivery’s sheet when suppliers deliver material to company. Therefore, supplier database can link delivery’s sheet database. The relationship between is one to multiple.
(6) Inventory system contains information of appetizer, soup, meal, dessert and drink. It means that we want to know any meal’s information so the system has to include them. Therefore, inventory system database can link these databases. The relationship between is one to multiple.
(7) Appetizer database contains information of material. It means that we want to know material’s information so it can link material database. The relationship between is one to multiple.
(8) Inventory system database contains information of purchasing system. It means that staffs need
to use this system when material can not satisfy demand.
(9) Purchasing system database contains information of material. It means that we want to know any material’s information so that we can know which material we need to purchase. Therefore, purchasing system database can link material database. The relationship between is one to multiple.
(10) Purchasing system database contains information of suppliers. It means that we want to know which suppliers we need to connect. Therefore, purchasing system database can link supplier database. The relationship between is one to multiple.
Figure5
2.3 ORGANIZATION MODEL
The figure below describes the organization of Skylark California restaurant. There are about 12 members and each has their own position which is described as below:
Manager: Each branch store has one leader, who makes the core decision such as whether to order the food material or coordinate the responsibility between inside leader and outside leader.
Inside: Inside leader also could named as chef, the guy who to allocate each work to the station chefs upon the menu sequence. And if the station chefs too busy to handle the menu in time, the chef will go and help them to catch up with the progress of meals.
kitchen: There are two types of chefs, one is responsible for making soup and the other is prepare the meals for customer.
Outside: To coordinate the waiter and waitress to do their work. Make sure that all customer been served and sacrifice with their service.