Home / Questions / Information Technology Technological Institute or IT Tech as it is more commonly known) is...
Information Technology Technological Institute (or IT Tech as it is more commonly known) is located in downtown Greensboro, North Carolina. The Institute provides computer training for companies in the central area of the State. Recently IT Tech has signed a fixed-payment contract to provide specialized computer training for a biotechnology company moving to the North Carolina Research Campus. The Campus is a 350-acre massive scientific and economic revitalization project that encompasses the former Pillowtex textile plant and the entire downtown area of Kannapolis. Specifically IT Tech has agreed to provide the biotechnology company with at least 30 trained IT specialists. Once enrolled in the training program, the students would agree to do their best to complete it, and would agree to work for the biotechnology company for at least two years if they did so.
The specialized IT training consists of both hardware and software instruction. The hardware training consists of instruction on the operation of the testing devices and computer equipment in use. The software training comprises instruction on both the systems programming and applications programming necessary to meet the needs of the biotechnology company. IT Tech estimates that the setup cost for the training is $35,000, while the variable cost is $2,250 per trainee. Based on past experience, IT Tech estimates that every student independently has a 15 percent chance of failing to master the training and will have to be dropped from the program. So, for example, if 40 students start training, then the expected number who pass will be 34 (85% of 40), but the actual number who pass will be a random variable with values from 0 to 40 (not all of which are equally likely). (Question: what is the probability distribution of the number of students who successfully complete the training?)
While IT Tech has classroom capacity to train up to 60 students, they are trying to decide how many students to enroll. They plan to enroll at least 30 students. Naturally they would hope that at least 30 of the students who started the training could complete it. Of course enrolling too many students might just incur unnecessary costs. If fewer than 30 students completed the training, IT Tech figured that they could always identify some of their best former students, lure them away from their current employers with a cash advance, and quickly provide them with the necessary specialized training to fulfill the contract. However, this would be an expensive undertaking, and would cost approximately $25,000 per student. Fortunately IT Tech expected that all of these former students could successfully complete the training.
add a Excel model that simulates the training of one group of students. The model should have one input cell (the number of students trained) and one output cell (the total cost of the training, to include any secondary hiring). In building your Excel model you should make sure that if 40 students are enrolled and 29 pass, then the total cost is $150,000, and that if 40
students are enrolled and 31 pass, then the total cost is $125,000.
Using Crystal Ball determine how many students should start training if IT Tech wants to minimize the expected total cost of meeting the contract. Turn in a printout of your Crystal Ball model, brief explanations of how you defined any decision, assumption, and forecast cells, and any printouts to support your results. Include a graph showing how the expected total cost varies as a function of the number of students enrolled. Someone looking at your homework should be able to see how you reached your conclusion, and should be able to replicate your results.
Note: there is a utility available in Crystal Ball called OptQuest. OptQuest is a sophisticated optimization tool that sometimes, but not always, identifies the optimal solution to a simulation problem. We do not want you to use OptQuest. OptQuest operates somewhat as a black box, and you do not need to resort to something as complex as OptQuest to solve ITTech's problem. If you wish to use OptQuest then you need to include a detailed description of exactly what it did and why you know that it found the correct answer.
Apr 03 2020 View more View Less
QUESTION 3 (25 MARKS a) Let A = {2, 4, 6) and B = {2, 3, 5, 8, 10) and R be the relation from A to B defined by aRb if and only if 2b - 3a 21 i) List the ordered pair of ...
Apr 14 2021You're prepared to make monthly payments of $370, beginning at the end of this month, into an account that pays 7 percent interest compounded monthly. Required:How many ...
Jun 10 20211. The voltage across a 682 Ω resistor is 121 V. What is the current, in mA, through the resistor2. The voltage across a 708 ? resistor is 126 V. What is the current, in ...
Apr 15 2020Macroeconomic topics can be impacted by which of the following microeconomic topics? What combination of goods and services will best fit their needs and wants, given the...
May 18 2020Prepare the balance sheets of Parent Ltd and the consolidated balance sheet as at 1 January 20X7 after each transaction, using for each question the balance sheets of Pa...
Mar 27 2020For each of the following sentences, identify any errors in the use of colons. Then in the space provided, write the correct punctuation plus the preceding word. If a col...
Jul 14 2021What is the ratio of the average velocity of krypton gas atoms () to that of nitrogen () molecules at the same temperature?
Aug 19 2021Scooby Corporation issued $200,000 of five-year 6% bonds at face value on August 1, 2013. Interest is paid annually on July 31. a) Prepare Scooby's journal entry t...
Jan 25 2020You have bought $20,000 from Chase to buy a car at the annual interest rate of 7.5%. Please produce the mortgage table if you want to return the money in one, two, and fo...
Apr 13 2020