The Queuing Model will calculate the optimum number of customer service points (staff) to minimize costs for your business. It considers the average arrival rate of customers, the average customer service rate, the cost to the business of customer waiting time (customer dissatisfaction), and the cost to operate customer service points. Queuing models are used extensively in call centers, toll booth operations and situations where a there is a queue for service including, counter staff, service staff, call response staff or maintenance staff. They can be applied in any business providing a customer service function. The model will calculate the optimum number of service points and allow you to test alternatives by manually inputting service point numbers. Additional results include the average number of customers waiting in the queue, their average waiting time, and service point (staff) utilization. The Total Cost Chart plots total cost verses number of service points to display the impact of changes in service point numbers.
Excel 2010/2007 and Excel 93-2003 Versions are now included in the download package. Save the download file and its content files to a known location on your local computer and then from this location select the software file that matches your Excel version.
Download Queuing Model Excel 30
Compressed Zip file - qme.zip 294 kb
Software downloaded as a standard Compressed Zip file (.zip) requires unzipping for use. It is suitable for all operating systems. Click the link to download and save the zip file to your computer. Then unzip/extract the downloaded file and save the software spreadsheet file. To use the software open the spreadsheet file.
Download Queuing Model Excel 30
Self-Extracting Zip file - qme.exe 356 kb
Software downloaded as a Self-Extracting Zip file (.exe) will self extract the software file. It is suitable for windows operating systems. Click the link to download and save the exe file to your computer. Then open the downloaded file and click Unzip. This will save the software spreadsheet file in the same directory as the Self-Extracting Zip file. To use the software open the spreadsheet file.
You can download Queuing Model Excel free of charge for evaluation but to fully enable your software requires registration. If you have not already purchased a software license to register your software you can
for full functionality and a 30 day money back guarantee. Evaluation software is fully enabled when you input your registration details.
Only US$69.00 for a Single User Non-Commercial License, plus a 30% discount for Multi User Licenses at just US$48.30. Additional pricing options are provided when you click the Order Now button.
The download package includes both an Excel 2010/2007 .xlsm file and an Excel 97-2003 .xls file. Save the download package and its content files to a known location on your local computer and from this location open the Excel file that corresponds with your Excel version. Macros must be enabled for this software to function. If you cannot access the input sheet or the command buttons do not function macros are not enabled. In this case please refer to the Enable Macros information below.
Enable Macros using Excel 2010/2007 to open a .xlsm file - When you open the .xlsm Excel file with Excel 2010/2007 macro status and options will depend on your system and security settings. The .xlsm extension indicates the file is an Excel Macro-enabled Workbook. If macros are not enabled from the top ribbon click Developer, Macro Security to access the Trust Center. If the Developer tab is not displayed, click the Microsoft Office Button, Excel Options, Trust Center, and the Trust Center Settings Button. From the Trust Center click Trusted Locations, Add new location, browse to the directory in which the Excel software file is saved, select the sub folders option if required, click OK, and then click OK once more to exit the Trust Center. This enables macros for any files saved in a Trusted Location. Only files that you trust should be saved in Trusted Locations, if you save all your Bizpep Excel files to a trusted directory macros will be enabled and they will run correctly. For additional information see Microsoft's Create, remove, or change a trusted location for your files. Alternatively from the Macro Settings category in the Trust Center you can select 'Enable all macros' however this enables macros in files from any location and should only be used when all files you access are trusted.
Enable Macros using Excel 93-2003 to open a .xls file - If when you open the Excel software you are not presented with an option to enable macros you may need to adjust your macro security levels. To adjust macro security levels from Excel go Tools, Macro, Security, Security Level. It is recommended that you select Security Level as Medium. When you open software with macros and Security Level is set as Medium you are presented with a message advising that the software contains macros with a prompt to Disable or Enable Macros. Once you have made your adjustment close Excel and reopen, then when prompted click Enable Macros.
You can download this software free of charge for evaluation. Software is in Microsoft Excel format and Excel is required for use. To register software and enable all functions you must purchase the appropriate license. You can Order online for immediate delivery and receive a 30 day money back guarantee.
Conditions of Use
The specific suitability of this software must be independently assessed. Software is provided as is, use is entirely at the users risk, and use acknowledges that the developer and all associated parties are held harmless from any claims or losses relating to software provided.