Questions & Answers

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.

Question and Answer Item 75 - Browse All Question and Answer Items

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).

Question and Answer Item 76 - Browse All Question and Answer Items

Q: I would just like a few cells unprotected near the top of the Calculation Summary so I can factor in some percentages for taxes etc. to give me a more accurate picture.

A: To add some additional formula etc it may be best to link to a new workbook as the calculator is dynamic in structure and adds/removes/hides rows/columns as part of its processing. To add your own formula simply open a new workbook and then click on the cell where you want the data to be displayed, type in = and then click the source data cell in the calculator. This allows you to add any data from the caluclator in any order/arrangment you like and then add formula to provide additional information as required. Because the data is linked to the calcualtor when the calcualtor data changes the new workbook data will change efficivly making it as dynamic as the calcualtor.

Question and Answer Item 73 - Browse All Question and Answer Items

Q: I would like the password to unprotect the workbook. I want to add some of my own info. I will save the origional, (protected) so there will be no issuses.

A: With our standard Non-Commercial license all non-input cells and Visual Basic code are protected to ensure integrity and protect source code. 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 view the formula applied to enhance your knowledge of software operation (macros remain protected). You can upgrade from a Non-Commercial license to a Commercial license at https://bizpep.com/upgrade.html . Depending on what you are trying to do you can always link from cells in the Wage Calculator to a new workbook and arrange the data/display any way you like. That may provide what you require.

Question and Answer Item 74 - Browse All Question and Answer Items

Q: I am looking for a scheduler that would be suitable for nursing staff. In our case the shifts are (1) 07:30-15:30, (2) 13:30-21:30 and (3)21:00-08:00. There is a 0.5 hour handover time for the 1st and 3rd shift and a 2 hour overlap on the 2nd shift. Is there any way I can do this with your normal scheduler that I have just downloaded? This seems to be a common need in many hospital and hospice wards where continuous cover of nursing staff is required. Any help would be most welcome.

A: Yes, you can have overlapping shifts by simply setting the shift start time and duration. By default these roll on from the previous shift however you can overwrite them (yellow cells). The main requirement is that the shifts are arranged in chronological order.

Question and Answer Item 59 - Browse All Question and Answer Items

<< < Page 281 282 283 284 285 286 287 288 289 290 > >>