Browse All Question and Answer Items

Items selected where Topic is Queuing Model Excel

<<   <   Page  1  2  3   >   >>

Topic: Queuing Model Excel
Q: When I enter the input some cells are in a protected mode. When I try to =E2=80=98unprotect sheet=E2=80=99, it asked for a password. Could you pleas= e guide me how to solve this problem?

A: Input cells (blue) are not protected and are the only cells that should be changed for the software to function correctly. Please follow the instructions for use. All non-input cells and Visual Basic code are protected to ensure integrity and protect source code. All input is via unprotected input cells, protected cells contain formula and should not be changed. The software is fully functional and the protection is in place to ensure the software formula and code is not corrupted. We do offer Commercial licenses for the use of software for inter-business support, advice, or consulting 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. Our standard Non-Commercial license is for private and internal business use only. You can upgrade from a Non-Commercial license to a Commercial license at www.bizpep.com . Please note that Bizpep retain full copyright and intellectual property rights at all times.

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: Downloaded the excel verison of Queuing Model for evaluation. I cannot open the file as it requires a password. Is there a way I can eval the product or do I need to puchase?

A: You should be able to open and extract the excel file from the download file. Then open the Excel file. In the Excel file input cells (blue) are not protected and are the only cells that should be changed for the software to function correctly. All input is via unprotected input cells, protected cells contain formula and should not be changed. The software is fully functional and the protection is in place to ensure the software formula and code is not corrupted. Please refer to the instructions sheet for details. If you continue to have difficulty please let me know exactly what you are doing and I can 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: Could you please elaborate on the definition of Cost of Waiting, as Cost per Service Point is different (and a more straightforward costing exercise).

A: Customer waiting cost is an estimate of the lost customer value as waiting time increases ie unsatisfied customers that do not return due to excessive waiting time, this indicates the lost future profit. An example is provided in the instruction sheet. Cost per Service Point is the staffing cost and any asset/delivery cost per service point ie how much it costs to provide the service point. If the model was simply optimised for minimum service point cost an unacceptable waiting time would be introduced and customers lost. By considering the cost of waiting this can be allowed for.

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 was wondering if there is a possibility to have a customized version, or at least be able to set some of the other variables. I am looking to determine how many service points are needed (based on a single queue/multiple service points model) that meet the following KPI baseline - Average Waiting Time: 10 minutes - Zero Occurences where customers wait for more than 30 minutes - 95% of all customers are served in less than 15 minutes I also would like to maximize the utilization of the service points.

A: The other "variables" are all calculations based on the inputs provided so they are not really variables at all. If the model was redesigned the inputs could be swapped for some of the calculations ie input average waiting time etc however this would be a substantial rework and it would probably be best to simply develop a queuing formula structure to suit your specific needs. You could achieve a similar result by adjusting current variables ie manually change the Number of Service points to find the best Average Waiting time required (as service points are integers the actual waiting time possibilities may never closely approach your required value). The zero occurrences and 95% requirements do not fit within standard formulation theory (more thought required). Maximising utilisation can be calculated by simply setting the Cost of Waiting to 0, this will usually result in a decrease in Service Points but an unacceptable Customer Waiting time. If you wanted to explore the model functionality we do offer Commercial licenses providing 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. You can upgrade from a Non-Commercial license to a Commercial license at www.bizpep.com . To access the source code of our software including the visual basic code (macros) a Source License is required. This license allows you to modify and adapt all components of the software to meet your specific needs. Source licensing fees are 3 times Commercial licensing fees. Source Code License details are available at www.bizpeponline.com . Please note that Bizpep retain full copyright and intellectual property rights at all times. Hope this helps.

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: Still on the Queuing Model, during my 7 days evaluation I notice that sometimes the value of Average Waiting Time per Customer turns out to be negative. What does the negative values means? How about positive values?

A: A negative Average Waiting Time per Customer indicates that the Arrival rate exceeds the Capacity of the service ie you need more service points. If the Average Customer Arrival Rate is greater than the Service Rate Capacity per Service Pt * the Number of Service Points then even without allowing for arrival distribution the Service Capacity is too low. When the Service Capacity is able to manage the Customer Arrival rate the Average Waiting Time per Customer is positive and this is how long on average a customer will wait for service.

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

 

<<   <   Page  1  2  3   >   >>

Client Comments

"You guys are fantastick ...excellent service each and every time, without fail."

"This was my first software purchase over the internet. I am very please with the results."

"Whole transaction and result well done."

"Thank you sir for your prompt response and excellent service."

"...you guys were great!"

"Keep up the good work!!"

"Great as usual, Thanks."

"These are practical business tools and the service that you offer for modification and assistance to adapt to practical circumstances is outstanding."

"I really appreciate your time and responsiveness... I'll definitely be back to your site soon."

"I like the simplicity and layout of your product."

"Excellent for the three items."

more.... »