Which measures would you regard as inputs and outputs, respectively? Please provide your justification

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

A small engineering consulting firm is establishing a plan for next year. The director and the
three partners need to prioritize the eight projects. The expected profit for each project is given
in the following table together with the number of person-days required to prepare each project.
Another measure included is the computing resource measured as the computer processing
unit (CPU) time (in hours). You have been tasked to evaluate which projects they ought to
pursue based on efficiency. Given the sample data below, you plan to construct a data
envelopment analysis (DEA) model:
a. Which measures would you regard as inputs and outputs, respectively? Please
provide your justification.
b. Conduct data envelopment analysis, explain what type of DEA model is selected
and describe the project you regard as “efficient” and “inefficient”, respectively.
c. Which project would you recommend and why?
d. In what ways can you improve on your recommendation? You are free to openly
source for other datasets (or create one) and justify the new set of input and output
measures before conducting another data envelopment analysis. Elaborate on your
recommendations and solutions.
e. Assuming that you have to consider the project from a different industry in your
analysis and you can have any data and measurement at your disposal, what would
be the ideal steps taken to ensure that the projects from different industries are
comparable?
Project Profit (in million £) Persondays
CPU time (hours)
1 2.1 550 200
2 0.5 400 150
3 3 300 400
4 2 350 450
5 1 450 300
6 1.5 500 150
7 0.6 350 200
8 1.8 200 600

Project Profit (in million £)
1
2
ال
3
4
5
6
7
8
2.1
0.5
ان
3
2
1
1.5
0.6
1.8
Person-
days
550
400
300
350
450
500
350
200
CPU time (hours)
200
150
400
450
300
150
200
600
Transcribed Image Text:Project Profit (in million £) 1 2 ال 3 4 5 6 7 8 2.1 0.5 ان 3 2 1 1.5 0.6 1.8 Person- days 550 400 300 350 450 500 350 200 CPU time (hours) 200 150 400 450 300 150 200 600
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Decision Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education