Determine the impact of implementation of new technologies

Assignment Help Operation Management

Reference no: EM132293320

A student project at WCU was initiated to try to determine the impact of implementation of new technologies. The students want to survey both distance and residential undergraduate students in the four different years at Western (first year, sophomore, junior, and senior). They have estimated that it will cost them $5.50 to survey first year and sophomore residential students and $8.00 to survey junior and senior residential students. The cost to interview distance students is slightly higher. It will cost $6.75 for first year and sophomores and $9.50 for junior and seniors. For statistical validity they want to interview at least 900 students. They feel that there are certain criteria that they must adhere to:

At least 25% of first year students surveyed should be distance students

At least 20% of sophomore students surveyed should be distance students

At least 35% of junior students surveyed should be distance students

At least 40% of senior students surveyed should be distance students

No more than 35% of all the students surveyed should be first year students Juniors and seniors should be at least 45% of the students surveyed

Each of the eight types of students must be represented in the survey by at least 10% of the total interviews

Formulate and solve this problem in Excel to determine the number of each type of student that should be surveyed that meets the requirements and minimizes the cost to carry out the interviews.

a) What is the minimum cost in your optimal solution (the value of the objective function)?

b) If the cost of surveying first year and sophomore residential students increases from $5.50 to $7.00 – what is the new minimum cost in your optimal solution?

Reference no: EM132293320

Questions Cloud

He also seems to be great source of support for employees : Everybody loves him. He's funny, very social, and good-looking. He also seems to be a great source of support for other employees.

Race and color discrimination are manifested in workplace : Identify several ways that race and color discrimination are manifested in the workplace.

Generation gaps in the workplace-situation : Generation gaps in the workplace - situation, problem, challenges and issues etc.

Organization differ in terms of management control : How do the three most basic forms of organization differ in terms of management control by the owner and sharing of the firm’s profits.

Determine the impact of implementation of new technologies : A student project at WCU was initiated to try to determine the impact of implementation of new technologies.

Solar under the americans with disabilities act : Sally files a suit against Solar under the Americans with Disabilities Act (ADA).

Differences between qualitative and quantitative forecasts : Explain in detail the differences between qualitative and quantitative forecasts. Include at least two examples of when each would be utilized.

Dennison widgets violated any antitrust law : Have Essential Parts and Dennison Widgets violated any antitrust law?

The application of new or improved technology : Describe one business problem that the organization faced that could be solved with the application of new or improved technology.

User Account

All Pages