What is the minimum cost in your optimal solution

Assignment Help Operation Management

Reference no: EM131800327

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: EM131800327

Questions Cloud

Developing an agile method using scrum : You are a project consultant for the ACME Company and are helping to develop an agile method using SCRUM. The company has always used predictive project.

How does social media impact your sense of self : How does social media impact your sense of self? Recall the three components of the self, and discuss the impact of interactive media on these three things

Determining the bullwhip effect : Bullwhip effect. Why does it happen- drivers of the bullwhip effect? What are counter-measures and practices to reduce or avoid it?

Calculate the amount of inventory loss from the flood : a flood destroyed the warehouse of Stuco Distributing Co. From the waterlogged records of the company

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

Burger king recently merged with tim horton of canada : Burger King recently merged with Tim Horton's of Canada. Do some research on the issues involved in this merger.

What is the allowable depreciation for the current year : Alexandra purchased a $35,00 automobile during 2011. The business use was 70%. What is the allowable depreciation for the current year

What is the npv and irr : The Green Goddess Company is considering the purchase of a new machine. If the cost of capital is 10 percent, what is the NPV? What is the IRR?

Define project for implementation financially : Project A has an internal rate of return (IRR) of 21 percent in 2 years. Project B has an IRR of 17 percent in 3 years. Project C has an IRR of 31 percent.

User Account

All Pages