Browse All Question and Answer Items
Items selected where Topic is Queuing Model Excel
Topic: Queuing Model Excel
Q: I am in the Party rental business which includes the rental of tents and other equipment. I am having a problem with scheduling and delivery times. Can this queuing model software assist me with deliveries, setups, collections and costing using standards that already exist in my company.
A: The Queuing Model calculates the optimum number of customer service points (staff) to minimize costs for your business. Queuing models are used in situations where a there is a queue for service including, counter staff, service staff, call response staff or maintenance staff. Depending upon your structure this may or may not be applicable. You can download and give it a try to see if it provides any value/insight. At a minimum it might help you to consider/quantify the cost of customer waiting time (customer dissatisfaction) and staff trade off's associated with this.
This Question and Answer Item relates to Queuing Model Excel from www.bizpeponline.com.
Browse Other Queuing Model Excel Items - Browse All Question and Answer Items
Topic: Queuing Model Excel
Q: If I purchase this model, I am able to unlock the hidden sheets to clearly understand the model logic?
A: The Queuing Model is based on standard queuing theory. Without queuing theory knowledge the logic of the process may not be clear even when viewing the model structure. With a Non-Commercial License all non-input cells and Visual Basic code are protected to ensure integrity and protect source code however we do offer Commercial licenses and upon request with a Commercial license can provide an unprotected software version allowing you to to view the formula applied, access cell contents to enhance your knowledge of software operation (macros remain protected) and undertake minor refinements (ie headings etc). In this format application sheets are unprotected, the workbook itself and the Terms and Conditions and Instructions sheets remain protected to maintain licencing and intellectual property rights notification. Please note that Bizpep retain full copyright and intellectual property rights at all times. If you purchase a Commercial license you can request an unprotected software version.
This Question and Answer Item relates to Queuing Model Excel from www.bizpeponline.com.
Browse Other Queuing Model Excel Items - Browse All Question and Answer Items
Topic: Queuing Model Excel
Q: I cannot register the Queuing model and I cannot get to the data spreadsheets.
A: To register the software and for it to function macros must be enabled. Please ensure you enable macros when your open the software Excel file. To assist you I have attached a pre-registered version of your software. Simply save it to your computer and open it with macros enabled. If this response not resolve your issue please provide specific details and I will be able to assist further.
This Question and Answer Item relates to Queuing Model Excel from www.bizpeponline.com.
Browse Other Queuing Model Excel Items - Browse All Question and Answer Items
Topic: Queuing Model Excel
Q: I am trying to use the model to determine how many service engineers I need to ensure an average customer time waiting and being served of 12 hours based on a 24 hour clock. I've tried the calculation with a time period of per hour and entered in 24 for the time period under consideration. (avg customer arrival rate is 1.02 and the service rate capacity it .03 per hour). The results I get indicate the average time spent by customer waiting & being served as 42.19 hours with an average waiting time of 13.27. If I understand this correctly, then it takes on average 28.92 hrs to serve the customer - having a difficult time understanding that?
A: From what you have said you have 24.48 customers arriving in 24 hours (1.02 customers/hour * 24) and you can serve 1 customer in 33 hours (1 / 0.03 ie 0.03 of a customer served per hour). Is this the case? If you continue to have difficulty send me a copy of your model with your input (and some detail) and I will have a quick look for you.
This Question and Answer Item relates to Queuing Model Excel from www.bizpeponline.com.
Browse Other Queuing Model Excel Items - Browse All Question and Answer Items
Topic: Queuing Model Excel
Q: I already have the program, but have a question about when selecting DAY as the basis for the calculation. Is the calculation based on an 8 hour or 24 hour day?
A: It is a 24 hour day. However as all results are expressed as a function of the Time Period selected it does not really matter. If you wanted to use Days and only worked 8 hours a day and input data for 8 hours, the results are expressed in relation to what a day is to you, in this case 8 hours. Results are given the unit of Day so an Average Time Spent by Customer of .5 Days is for you 4 hours (.5 * * hours). Therefore your output is directly related to the unit defined as input (although where possible it is probably best to use the simplest unit to minimize complexity).
This Question and Answer Item relates to Queuing Model Excel from www.bizpeponline.com.
Browse Other Queuing Model Excel Items - Browse All Question and Answer Items
