Authors
Logvin I.
|
Degree
|
Master's Student, Tomsk State University of Control System and Radio Electronics |
|---|---|
|
E-mail
|
igor31821788@gmail.com |
|
Location
|
Tomsk |
|
Articles
|
A spreadsheet simulation model of fast food restaurant service systemThe 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...
|
