Question: Please solve using @RISK in excel Show your formulas Company XYZ has 200 personal computers. Each working computer has a 5% probability, independent of all
Please solve using @RISK in excel Show your formulas Company XYZ has 200 personal computers. Each working computer has a 5% probability, independent of all other computers, of encountering a hardware problem on any given day. Most hardware problems require 3/4 of an hour of attention from a computer support technician (CST). Each problem that occurs, however, has a 30% chance (independent of all other problems) of developing into a more serious problem requiring an extra 2 hours of attention from a CST. Each CST can spend up to 6 hours per day fixing problems, and costs the company $300 per day. Every CST hired must be paid their full salary each day, whether or not they have sufficient work to keep them busy. If the company does not have enough CSTs to solve all the problems occurring on a given day, it hires an outside firm that charges $105 per hour. However, computers being fixed by the outside firm can only be returned to the company by the end of the next day. For example, if the company sends two computers to the outside firm on day 1, these two computers will be fixed and returned to Company XYZ by the end of day 2, and can be operated on day 3. Each computer not in use (e.g., either being fixed by a CST or the outside firm or on the way to be returned) results in a daily loss of $200 in profit for the company. Company XYZs strategy is to fix the computers with minor issues with priority each day and send any remaining problematic computers to the outside firm. You can assume that the outside firm will continue fixing the computers, so that the total number of hours needed to fix the computers is unaffected by who is performing the maintenance. You are trying to decide whether to hire 1, 2, 3, or 4 CSTs. Simulate a 100-day period with a sample size of 1000. You can assume that all 200 computers are working properly at the beginning of day 1. Which option gives the lowest average cost per day? With this number, what is the average number of hours of support per day you must buy from the outside firm? SOLVE USING @RISK
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
