WinterS_CaseStudy1_Deliverable1
.docx
keyboard_arrow_up
School
Crowder College *
*We aren’t endorsed by this school
Course
321
Subject
Industrial Engineering
Date
Dec 6, 2023
Type
docx
Pages
2
Uploaded by MegaHareMaster86
1. The committee recommended several alternatives.
a. Before analyzing the data, which suggestion makes the most sense?
I believe that the virtual option makes the most sense before analyzing the data.
b. After analyzing the data, which option would be the best for the University, to
support your answer?
I believe that after analyzing the data bringing your own devices room would be the best
option. It has the least number of startup costs, and the yearly costs would be way less than either
of the other options.
2. List and explain the steps in the data cleaning process. Note any assumptions you made.
First I followed all of the steps in the videos, Then on a separate sheet I calculated the
sum for 1 year for the costs of the computers. I added 2 days of cost for the ones with weekend
use. I assumed that the laptops did not need monitors, so I excluded that cost. I also assume there
was no data for 2020 because of covid.
3. After evaluating the data, what are your recommendations to the University stakeholders?
a. Consider the following questions to guide your analysis:
i. What is the current utilization of the computer labs?
The average is around .51%
ii. What is the current electric cost of the computers?
Each year the computers would have an electricity cost of $38326.88.
iii. Based on the utilization, what should the cost of utilization be?
$195.99
iv. Is the elimination of 75% of computers feasible?
Yes
v. Using an estimated budget of $216,000, how many bring-your-own-device
labs could be created?
5 labs
1. What are the advantages and disadvantages of this approach?
Disadvantage: People would have to have their own device.
Advantage: It would save money.
vi. Using an estimated budget of $216,000, how many virtual machines could
be purchased and funded for five years?
4 Virtual Machines
4. What is the final recommendation to the University? Support and explain your answer.
I believe that after analyzing the data bringing your own devices room would be the best
option. It has the least number of startup costs, and the yearly costs would be way less than either
of the other options.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help