+7 (495) 987 43 74 ext. 3304
Join us -              
Рус   |   Eng

Authors

Karmanovskaya E.

Degree
Master's Student, Tomsk State University of Control System and Radio Electronics
E-mail
katy.karmanovskaya@gmail.com
Location
Tomsk
Articles

A spreadsheet simulation model of fast food restaurant service system

The article is devoted to the development of a spreadsheet model of a fast food restaurant. When creating the model, the data of real object was used. The type of distribution was determined using the Chi square test. The model includes two phases of request processing related to the purchase and preparation of meals and table service. Requests can come in groups of several people. Customers do not receive service if the queue length exceeds the maximum value or if all tables are occupied. The model is implemented using Excel formulas without programming. The program developed by the authors was used for the implementation of multiple simulation. The program includes a set of typical scenarios designed to handle a spreadsheet model. This eliminates the need for programming and speeds up the process of working with the model. As a result of computational experiments were calculated indicators such as average revenue, the average number of failures and the average waiting time. The article may be useful for readers, who want to create basic models of queues systems using spreadsheets. The model can be used both in the educational process and in the study of the process of restaurant service and decision-making to improve it.
Read more...